Live Search Using Bootstrap 4, PHP, MySQLi Prepared Statement & Ajax

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ก.ย. 2024
  • Hello world! In this video I'm showing you how to make a live search of record from the database using Bootstrap 4, PHP, MySQLi Prepared Statement in Object Oriented Style and Ajax. By using this you can search the record without page refresh in the same page.
    #liveSearchPhpAjax
    #SearchRecordWithoutPageRefresh
    If you like my works and my video tutorials then you can donate me some amount. You can donate through these links :
    Paypal : www.paypal.me/...
    Instamojo (Credit/Debit Card & UPI) : www.instamojo....
    Thanks for watching this video. If you like this video then hit like button, share this video, And Subscribe my Channel. Also like my Facebook page for latest updates.
    ♥ Facebook Page - / dcodemania
    ♥ Myself On FB - / sahil4rock
    ♥ Instagram - / sahil4rock
    ♥ Twitter - / dcodemania

ความคิดเห็น • 56

  • @jeremyluca7916
    @jeremyluca7916 5 ปีที่แล้ว +1

    All the way from Twitter. I hear you have quality contents in php, I'll be an avid follower from now on

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว

      Thank you so much!!!!😊😊😊

  • @MuhammadAdnan-gx6rd
    @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +2

    Awesome..... Thanks keep us updated. ...

  • @angel21mp
    @angel21mp 5 ปีที่แล้ว +2

    hey just wanted to say thanks for sharing this great tutorial

  • @masumbillah4608
    @masumbillah4608 3 ปีที่แล้ว +1

    Thank you very much. God bless you always.

  • @preciousakaninwor1668
    @preciousakaninwor1668 5 ปีที่แล้ว +1

    I just subscribed to your channel. Thanks for sharing this

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว

      😊😊😊👍👍👍

  • @POOJAKUMARI-fw6vc
    @POOJAKUMARI-fw6vc 5 ปีที่แล้ว +2

    Very good sahil....

  • @Skanderthabet
    @Skanderthabet 4 ปีที่แล้ว +2

    You saved me dude ! thank you so much

  • @georgelineageify
    @georgelineageify 4 ปีที่แล้ว +1

    very good job man!!!!!

  • @anugrah53
    @anugrah53 3 ปีที่แล้ว +1

    thank you so much, dude

  • @samiayasmin5782
    @samiayasmin5782 2 ปีที่แล้ว

    Thank you bro. U saved me!

  • @azizkouiki
    @azizkouiki ปีที่แล้ว

    Thank you sir !

  • @engineeringtechnology3113
    @engineeringtechnology3113 3 ปีที่แล้ว +2

    Any other watching in 2021?

  • @FaridSenpai
    @FaridSenpai 4 ปีที่แล้ว

    Thanks bro, you really helped me a lot.

  • @MFaisalHafeez
    @MFaisalHafeez 4 ปีที่แล้ว +2

    too good help for me can u upload project files

  • @ousmaneniang690
    @ousmaneniang690 ปีที่แล้ว

    hello grand your tutorial is very interesting however I have to do this research but I cannot manage to integrate the action buttons at the same time if you can redo the tutorial with the action buttons example modify and delete

  • @alka_seltzer3007
    @alka_seltzer3007 3 ปีที่แล้ว +1

    Nice tutorial sir. I copied your code although I have a problem. Buttons or anchor links in a table cell won't show up😕. How to fix this?

  • @jericksejas6680
    @jericksejas6680 3 ปีที่แล้ว

    Thanks man!

  • @ahmedjoo1858
    @ahmedjoo1858 4 ปีที่แล้ว

    Great video, can you explain how to sanitize user input in search box before executing the AJAX to avoid SQL injection?

  • @alisindha129
    @alisindha129 4 ปีที่แล้ว +1

    Can it worked in php crud pagination ???
    Please reply

  • @waheed-ou4ek
    @waheed-ou4ek 3 ปีที่แล้ว

    Thank you for good tutorial....!! But when I search available data the table is showing in horizontal form.... What can I do to sort it out? Please, help...!!

  • @brucereal4418
    @brucereal4418 5 ปีที่แล้ว +1

    I follow your steps with different database table mine is not working :(

  • @mkfilmovi
    @mkfilmovi 3 ปีที่แล้ว

    Great tutorial. Locally this search is working but when I put the code online (changed connection string) it is not working. Any idea where to look for the problem?

  • @lucappelman8558
    @lucappelman8558 5 ปีที่แล้ว +1

    next time, show the code then do all the css because now it contains so much information most people probably wouldn't care about if they build a website in a different style.

  • @misschoa9358
    @misschoa9358 4 ปีที่แล้ว +1

    what can I do when I have "Edit" and "Delete" button inside my table and I want the button to came out with the result too?

    • @misschoa9358
      @misschoa9358 4 ปีที่แล้ว +1

      I try to make it like this but it did not work..sorry for asking this dumb question I'm still new with this..
      ";
      while ($data = $result->fetch_assoc()){
      $output .="

      ".$data['Id']."
      ".$data['username']."
      ".$data['email']."
      ".$data['password']."
      ".
      EDIT
      ."
      ".
      DELETE
      ."
      ";
      }
      $output .="";
      and I got this error
      Parse error: syntax error, unexpected '

  • @funnyusi0431
    @funnyusi0431 4 ปีที่แล้ว

    thanks for the useful info, I tried with myself but it gives this error (Fatal error: Uncaught Error: Call to a member function bind_param() on bool in C:\xampp\htdocs\invent2\process.php:14 Stack trace: #0 {main} thrown in C:\xampp\htdocs\invent2\process.php on line 14)

  • @CanadaweSihine
    @CanadaweSihine 4 ปีที่แล้ว

    kindly help me. my code not working. i followed every steps. its not working

  • @k_a_r_i_s-1812
    @k_a_r_i_s-1812 4 ปีที่แล้ว

    i love your content sir. thank you. qn, how do i do the same from two similar tables? if the table in this example were two tables from the same database?if citizen of countries database... tbl1-USA tb2-CANADA... how do i search both tables without creating different pages? do you mind either creating a video or just coment the code here? thank you

  • @bhkazaure
    @bhkazaure 4 ปีที่แล้ว +1

    This is a wonderful project pls can I have a code

  • @MuhammadAdnan-gx6rd
    @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +2

    Can you also create indeed.com like search bar with two input box ?

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว +1

      Okay in upcoming videos I'll make this also!!!

    • @MuhammadAdnan-gx6rd
      @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +1

      Don't lie to me Bro. ...hhhh

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว +1

      I'm not telling lie.

    • @MuhammadAdnan-gx6rd
      @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +2

      Kidding Bro. ....
      1 thing is cleared you r uploading advance concepts topics of php great. ....

  • @LightJ_us
    @LightJ_us 3 ปีที่แล้ว

    Do you know any alternatives for get_result() in Oracle?

  • @shafinazsanimi3726
    @shafinazsanimi3726 4 ปีที่แล้ว +2

    I follow all your steps, but its still not working :((

    • @DCodeMania
      @DCodeMania  4 ปีที่แล้ว

      Watch the video again and follow all steps carefully.....may be you have mistaken somewhere in your coding...!!!

  • @vaibhavvaidya935
    @vaibhavvaidya935 5 ปีที่แล้ว +2

    Re-uploaded??

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว +1

      No bro!!! It's a new one!!!

  • @pratikjangam1277
    @pratikjangam1277 4 ปีที่แล้ว

    Bruhh this may gives a fatal error of calling member function bind_param()....!!!!

  • @anbu5782
    @anbu5782 2 ปีที่แล้ว

    How add the fillter

  • @hugohermkens1962
    @hugohermkens1962 3 หลายเดือนก่อน

    Can i have the source code ?

  • @artemgalperin
    @artemgalperin ปีที่แล้ว

    codes...?

  • @bolajiteslim9408
    @bolajiteslim9408 ปีที่แล้ว

    Source code pls

  • @mullayam
    @mullayam 2 ปีที่แล้ว

    Share Source code plizzzz

  • @ihssanemo4474
    @ihssanemo4474 2 ปีที่แล้ว

    Hello, please what does this "search" in the bind param refer to $stmt->bind_param("ss",$search,$search);