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

Поділитися
Вставка
  • Опубліковано 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.
      ua-cam.com/video/dyekdg6ySR0/v-deo.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 роки тому

      ua-cam.com/video/sFtTNV92o1Y/v-deo.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 роки тому

      ua-cam.com/video/PN68OwYyObc/v-deo.html
      ua-cam.com/video/sFtTNV92o1Y/v-deo.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 ua-cam.com/play/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1.html

  • @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: ua-cam.com/video/yp5pYIg4WHc/v-deo.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 років тому

      ua-cam.com/play/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1.html
      ua-cam.com/play/PLRheCL1cXHrsnOsrT3PxmHDMLbZEwqPZ5.html
      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

      ua-cam.com/video/yp5pYIg4WHc/v-deo.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