How to retrieve a single data/record from database using php mysql

Поделиться
HTML-код
  • Опубликовано: 3 фев 2025

Комментарии • 118

  • @salmaahmed8201
    @salmaahmed8201 4 года назад

    Thank you so much! I sat here for the whole day and wasn't able to get the data to retrieve from the database, thanks to your videos I was able to manage within just a snap! THANK YOU! you just saved me :))))

  • @oparrab
    @oparrab 4 года назад +1

    Good video and explanation.... It is a good example and very clear. Thanks a lot.

  • @IslamAudioStation
    @IslamAudioStation 4 года назад +24

    This man needs a new keyboard every few weeks ;D

  • @sooryasaan2588
    @sooryasaan2588 3 года назад

    Tried to push code's in GitHub or other secured site. It is really helpfull for others

  • @adityamahilane5709
    @adityamahilane5709 3 года назад

    tabahi😁

  • @moinuddinchudiwal9347
    @moinuddinchudiwal9347 3 года назад

    Thanks bro keep it up👍

  • @homerask3329
    @homerask3329 3 года назад

    Thanks man...you make my day 🔥

  • @Venkata_krishna_tutorials
    @Venkata_krishna_tutorials Год назад

    Thank you soooo much bro🥰

  • @geeti3002
    @geeti3002 3 года назад

    Helped a lot...Thank you!!

  • @rechalchal1235
    @rechalchal1235 3 года назад

    bro ur video explain is good, im following ur video how to insert the data connecton with xampp add one more video

  • @prasannasilva7754
    @prasannasilva7754 3 года назад +3

    Everything works just fine except when i type the id number, it does not show the data related to the number. only the table itself.
    how that could be?

  • @arunagrawal6270
    @arunagrawal6270 4 года назад +2

    Nice tutorial Sir. It would be more helpful if you provide source code also

  • @version8813
    @version8813 3 года назад +2

    Thank you !!! keep safe we always need someone like you !

  • @koykoy8269
    @koykoy8269 3 года назад

    This helped me a lot

  • @zainvediocollection
    @zainvediocollection 2 года назад

    How can add more then one row in table 🤔
    If I wana to add second row the first row will be removed....

  • @princessfathi466
    @princessfathi466 4 года назад

    Thnk u so much bro👌👌

  • @rahulkamble4617
    @rahulkamble4617 5 лет назад +3

    Good one yeah ! Thankyou :)

  • @erbloggerboy
    @erbloggerboy 2 года назад

    Thanks sir

  • @hitendrachaurasia199
    @hitendrachaurasia199 3 года назад

    agar hmko one by one data chahiye to kaise aayega jai aap search kiya 1 toh one aaya uske baad aap ne search kiya 4 toh 4 aaya lakin 1 chala gya hmko data add hota jye niche kaise hoga ....?

  • @mazterz631
    @mazterz631 5 лет назад +1

    thanks men you saved me!

  • @ipraneethareddy6172
    @ipraneethareddy6172 4 года назад

    Thank you bro but small querys

  • @CirkaFitness
    @CirkaFitness 4 года назад

    Thanks for the effort. However, better if you can focus just on the specific topic and leave out other items like formatting etc

  • @jestocj
    @jestocj 3 года назад +1

    Sir can you please give me the source code ? You are so much helpful for me as well as all the viewers. Can you please give me the sourse code ?

  • @endone3661
    @endone3661 3 года назад

    OH I did it !!! thank you !

  • @vandamieespadero6633
    @vandamieespadero6633 4 года назад

    what will happen if there are no existing data on the database?

  • @FATIMA-8397
    @FATIMA-8397 3 года назад

    it give me an Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in....what I shold do

  • @grootgroot3764
    @grootgroot3764 5 лет назад +1

    It shows me an error mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in file,.............how do i resolve this??

  • @strangeman4088
    @strangeman4088 4 года назад

    Quality

  • @TECLOVENIA
    @TECLOVENIA 3 года назад

    Bro how to add else statement if the wrong ID is entered and alert error?

    • @fundaofwebit
      @fundaofwebit  3 года назад +1

      Before while loop use if else condition. To check id exists or not? with mysql code.
      if(mysqli_num_rows($query_run) > 0)
      {
      //Your while loop
      }
      else
      {
      echo "ID not found";
      }

    • @TECLOVENIA
      @TECLOVENIA 3 года назад +1

      @@fundaofwebit Thank you very much brother 🙏🙏🙏 Your help is a blessing for me and for all who are watching your videos.
      May God bless you and your family 🙏

  • @jeremytiempo9639
    @jeremytiempo9639 3 года назад

    the variable $db? what the functionof it? it not used in coding.

    • @TechAlokKushwaha
      @TechAlokKushwaha 2 года назад +1

      its uses for connect database if you use this code you dont need to run $db variable
      $con = mysqli_connect("localhost", "saunhain_database", "database@1234", "saunhain_database");

  • @muchopeanut22
    @muchopeanut22 3 года назад

    uhm.. hello sir can i ask what code to put if i want search my id 2,3,4 ..without refreshing my last id search (1) ?

  • @puneetsharma3253
    @puneetsharma3253 4 года назад

    Thanku so much

  • @addinan
    @addinan 4 года назад +2

    so you have a link where I could download this script?

  • @khuraijamshitalsingh
    @khuraijamshitalsingh Год назад

    How to contact you

  • @shahzebrehmankhattak5529
    @shahzebrehmankhattak5529 3 года назад

    someone help me i want to retirev single data on login mean when i login to id 1 ..i want that it have to show me only data of id 1

    • @fundaofwebit
      @fundaofwebit  3 года назад

      In this, I have shown how to get login user data and how to save his data in session variable and display it's data using also how to authenticate that logged in user.
      ruclips.net/video/dyekdg6ySR0/видео.html

  • @awinashkhare4293
    @awinashkhare4293 3 года назад

    Hello Sir, Can you create a video on how to retrieve data in the same id without search button.

  • @midevkm18
    @midevkm18 3 года назад +1

    Showing Warning and not Displaying the details.
    " Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\covid\searchdata.php on line 48 "

  • @chakralakshmi8970
    @chakralakshmi8970 3 года назад

    How do you display no records found if no records retrieved

    • @fundaofwebit
      @fundaofwebit  3 года назад

      If(mysqli_num_rows($query_run) > 0)
      {
      //your loop
      }
      else
      {
      echo "No record found";
      }

    • @chakralakshmi8970
      @chakralakshmi8970 3 года назад +1

      @@fundaofwebit Thanks your videos are useful for beginners like me in PHP

  • @iqenx-dev2373
    @iqenx-dev2373 5 лет назад +1

    Hello may you please help me? Its now working with me

  • @warrenpondoc1618
    @warrenpondoc1618 3 года назад

    I got an error on while($row = mysqli_fetch_array($query_run))
    It says Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\login\searchdata.php:54 Stack trace: #0 C:\xampp\htdocs\login\searchdata.php(54): mysqli_fetch_assoc(false) #1 {main} thrown in C:\xampp\htdocs\login\searchdata.php on line 54

  • @vishaldubey519
    @vishaldubey519 4 года назад

    There is no error but display the data
    How to solve it

  • @rocktechmahi
    @rocktechmahi 5 лет назад

    Your code is showing error please suggest

  • @justicetam5134
    @justicetam5134 6 лет назад +1

    love this

  • @smitititecnosoft
    @smitititecnosoft 4 года назад

    Hi, is it possible to retrieve data from database by making two search field?

    • @fundaofwebit
      @fundaofwebit  4 года назад

      ruclips.net/video/sFtTNV92o1Y/видео.html

    • @smitititecnosoft
      @smitititecnosoft 4 года назад

      @@fundaofwebit thank you so much Sir for answering...

    • @fundaofwebit
      @fundaofwebit  4 года назад

      @@smitititecnosoft Thank you. Keep supporting me.

  • @vaibhavbhatnagar9865
    @vaibhavbhatnagar9865 4 года назад

    thanks

  • @Mehachi
    @Mehachi 3 года назад

    Insane mate

  • @akashsaha574
    @akashsaha574 4 года назад

    thank you

  • @pranalipawar5849
    @pranalipawar5849 4 года назад

    how can I retrieve a single record from CSV file?

  • @Being_Human_Karthick
    @Being_Human_Karthick 4 года назад

    I need Help In Creating Relation Between Two Table,For Example I have Stock Table and Purchase table For Every Purchase Stock Table Need to Be Updated,For That I Need Help In Creating Relation Among The Table @Funda of Web IT

  • @satyajit2019
    @satyajit2019 4 года назад

    The code is not working
    Can u help me

    • @fundaofwebit
      @fundaofwebit  4 года назад

      ruclips.net/video/PN68OwYyObc/видео.html
      ruclips.net/video/sFtTNV92o1Y/видео.html

    • @satyajit2019
      @satyajit2019 4 года назад

      @@fundaofwebit simple sa banaa dijiye Na ja sake samajh mein aaye

  • @thushi4107
    @thushi4107 4 года назад

    not working to me

  • @biransubba2169
    @biransubba2169 4 года назад +1

    Not working please make on hostinger hosting

  • @akhileshtiwari7250
    @akhileshtiwari7250 4 года назад

    How to append multiple data using search one by one

  • @Mehachi
    @Mehachi 3 года назад

    YAAAA

  • @aswinjoy6214
    @aswinjoy6214 4 года назад

    can you share the code

  • @angcheekent2279
    @angcheekent2279 3 года назад +1

    i get an error of
    mysqli_fetch_array() expects parameter 1 to be mysqli_result
    in this line
    while($row = mysqli_fetch_array($query_run))
    can you help me out? appreciate and thank a lot

  • @khozarammala9936
    @khozarammala9936 5 лет назад

    mine is not returning anything!!

    • @fundaofwebit
      @fundaofwebit  5 лет назад

      what is the error your getting ?

    • @khozarammala9936
      @khozarammala9936 5 лет назад +1

      there's no error message, it just return nothing when i search my database

    • @khozarammala9936
      @khozarammala9936 5 лет назад

      General Valuation
      Musina General Valuation
      Search by Entering ERF, Sectional Title or a Farm Number




      ERF
      PTN
      RE
      TOWN
      CATEGORY
      LAND USE
      STREET ADDRESS
      EXTENT
      MARKET VALUE
      REGISTERED OWNER
      COMMENT BY VALUER

    • @fundaofwebit
      @fundaofwebit  5 лет назад +1

      @@khozarammala9936 ruclips.net/p/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1

  • @praveenas80
    @praveenas80 5 лет назад

    Can u do a php code for shopping cart?

  • @khozarammala9936
    @khozarammala9936 5 лет назад

    Please assist me, i am not getting any results.

    • @webtube4131
      @webtube4131 5 лет назад

      add attribute method="post" in form tag
      ex:
      ....
      .....

  • @vijaygohil7402
    @vijaygohil7402 3 года назад

    where is code ? please add here

    • @fundaofwebit
      @fundaofwebit  3 года назад

      In this link: ruclips.net/video/yp5pYIg4WHc/видео.html
      Checkout the description.

  • @bishnuprasadpani5123
    @bishnuprasadpani5123 5 лет назад

    I AM NOT GETTING THE SEARCH RESULT

  • @Rk-yt1bo
    @Rk-yt1bo 5 лет назад

    How to edit/ update user data in php Codeigniter

    • @fundaofwebit
      @fundaofwebit  5 лет назад

      ruclips.net/p/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1
      ruclips.net/p/PLRheCL1cXHrsnOsrT3PxmHDMLbZEwqPZ5
      In this playlist .. I have done it.. so... you can call its Id and update the data... just see once.. ull understand concept...

  • @SHINELOVENIA7dexterity
    @SHINELOVENIA7dexterity 5 лет назад

    Good video bro 👍🙂 I have subscribed to your channel. Would you kindly help me to create a search box like Google Search, and retrieve Data by Name from database.

  • @artemgalperin
    @artemgalperin Год назад

    code...

  • @pramilamuthu4633
    @pramilamuthu4633 4 года назад

    Plz upload using javascript mysql

  • @bdschoolforknowledge4025
    @bdschoolforknowledge4025 4 года назад +1

    mysqli_fetch_array() expects parameter 1

    • @fundaofwebit
      @fundaofwebit  4 года назад

      Put a variable in this function.

    • @bdschoolforknowledge4025
      @bdschoolforknowledge4025 4 года назад

      @@fundaofwebit
      Search Data From Database
      body{
      background-color: grey;
      }
      table,th,td{
      border: 2px solid black;
      width: 600px;
      background-color: lightgreen;
      }
      .btn{
      width: 10px;
      height: 5px;
      font-size: 22px;
      padding: 0px;
      }




      Search data from Database
      I am a Robot




      question
      answer

    • @bdschoolforknowledge4025
      @bdschoolforknowledge4025 4 года назад

      @@fundaofwebit it still say this problem

    • @bdschoolforknowledge4025
      @bdschoolforknowledge4025 4 года назад

      @@fundaofwebit sir can you give me a sorch code
      My email asib20025@gmail.com

  • @pmolax5903
    @pmolax5903 3 года назад

    KINDLY ADD SOURCE CODE

  • @nikkygeorgephilip52
    @nikkygeorgephilip52 5 лет назад

    Can you please add the source code

  • @Milan-ef5qr
    @Milan-ef5qr 4 года назад

    please provide source file

  • @endone3661
    @endone3661 3 года назад

    I am a student and I find this confusing

    • @fundaofwebit
      @fundaofwebit  3 года назад +2

      ruclips.net/video/yp5pYIg4WHc/видео.html

  • @bishnuprasadpani5123
    @bishnuprasadpani5123 5 лет назад

    PLEASE SEND ME THE SOURCE CODE

  • @addinan
    @addinan 4 года назад +1

    there's an error on this code while($row = mysqli_fetch_array($query_run))
    it say's
    Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\br-new\search.php on line 46

    • @excaliburgz1996
      @excaliburgz1996 4 года назад +1

      Try to replace it with mysqli_fetch_assoc() function

  • @sopnonildip1062
    @sopnonildip1062 5 лет назад

    plz give me source code

  • @shahindomar3958
    @shahindomar3958 4 года назад

    Maay isko samjha,lakin isko sath photo kaise display kar sakti o print kaise karta hu, mujhe bataye , mera email: shahindom76@gmail.com. thanks

  • @linkdotnet2157
    @linkdotnet2157 2 года назад

    can you plz share the source code