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

[@salmaahmed8201]

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]

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

[@IslamAudioStation]

This man needs a new keyboard every few weeks ;D

[@SharmaCoder]

hahaha

[@prasannasilva7754]

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?

[@sooryasaan2588]

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

[@zainvediocollection]

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

[@adityamahilane5709]

tabahi😁

[@hitendrachaurasia199]

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 ....?

[@rechalchal1235]

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

[@jestocj]

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 ?

[@vandamieespadero6633]

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

[@FATIMA-8397]

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

[@homerask3329]

Thanks man...you make my day 🔥

[@addinan]

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

[@grootgroot3764]

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

[@kbikers7141]

I also got same error

[@kbikers7141]

Plz u remove the colon from select * from salary

[@puneetsharma3253]

@@kbikers7141 thanks for your guidance

[@muhammadhafizibinabmanan7714]

"SELECT * from patient WHERE id=".$id.""
Try this code. Replace patient with ur database table name.

[@markjosephprincipe1988]

@@muhammadhafizibinabmanan7714 Thankyou so much

[@TECLOVENIA]

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

[@fundaofwebit]

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]

@@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 🙏

[@arunagrawal6270]

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

[@version8813]

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

[@GabrielLopez-du6uq]

Kkkk

[@moinuddinchudiwal9347]

Thanks bro keep it up👍

[@jeremytiempo9639]

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

[@TechAlokKushwaha]

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]

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) ?

[@abdo_74_]

SAME

[@fundaofwebit]

Use WHERE IN sql query.

[@Venkata_krishna_tutorials]

Thank you soooo much bro🥰

[@iqenx-dev2373]

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

[@awinashkhare4293]

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

[@geeti3002]

Helped a lot...Thank you!!

[@smitititecnosoft]

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

[@fundaofwebit]

th-cam.com/video/sFtTNV92o1Y/w-d-xo.html

[@smitititecnosoft]

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

[@fundaofwebit]

@@smitititecnosoft Thank you. Keep supporting me.

[@shahzebrehmankhattak5529]

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]

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.
th-cam.com/video/dyekdg6ySR0/w-d-xo.html

[@Being_Human_Karthick]

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

[@chakralakshmi8970]

How do you display no records found if no records retrieved

[@fundaofwebit]

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

[@chakralakshmi8970]

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

[@vishaldubey519]

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

[@pranalipawar5849]

how can I retrieve a single record from CSV file?

[@rocktechmahi]

Your code is showing error please suggest

[@akhileshtiwari7250]

How to append multiple data using search one by one

[@midevkm18]

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 "

[@rahulkamble4617]

Good one yeah ! Thankyou :)

[@warrenpondoc1618]

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

[@CirkaFitness]

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

[@biransubba2169]

Not working please make on hostinger hosting

[@princessfathi466]

Thnk u so much bro👌👌

[@ipraneethareddy6172]

Thank you bro but small querys

[@praveenas80]

Can u do a php code for shopping cart?

[@koykoy8269]

This helped me a lot

[@khuraijamshitalsingh]

How to contact you

[@satyajit2019]

The code is not working
Can u help me

[@fundaofwebit]

th-cam.com/video/PN68OwYyObc/w-d-xo.html
th-cam.com/video/sFtTNV92o1Y/w-d-xo.html

[@satyajit2019]

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

[@mazterz631]

thanks men you saved me!

[@thushi4107]

not working to me

[@khozarammala9936]

mine is not returning anything!!

[@fundaofwebit]

what is the error your getting ?

[@khozarammala9936]

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

[@khozarammala9936]

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]

@@khozarammala9936 th-cam.com/play/PLRheCL1cXHrsxB2aUyfNMxr50XMKwQoa1.html

[@Rk-yt1bo]

How to edit/ update user data in php Codeigniter

[@fundaofwebit]

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

[@erbloggerboy]

Thanks sir

[@angcheekent2279]

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

[@muhammadhafizibinabmanan7714]

"SELECT * from x WHERE id=".$id.""
Try this code.

[@khozarammala9936]

Please assist me, i am not getting any results.

[@webtube4131]

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

[@aswinjoy6214]

can you share the code

[@bishnuprasadpani5123]

I AM NOT GETTING THE SEARCH RESULT

[@sheebaamanya8617]

same!

[@endone3661]

OH I did it !!! thank you !

[@pramilamuthu4633]

Plz upload using javascript mysql

[@justicetam5134]

love this

[@bdschoolforknowledge4025]

mysqli_fetch_array() expects parameter 1

[@fundaofwebit]

Put a variable in this function.

[@bdschoolforknowledge4025]

@@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]

@@fundaofwebit it still say this problem

[@bdschoolforknowledge4025]

@@fundaofwebit sir can you give me a sorch code
My email [e-mail]

[@vijaygohil7402]

where is code ? please add here

[@fundaofwebit]

In this link: th-cam.com/video/yp5pYIg4WHc/w-d-xo.html
Checkout the description.

[@puneetsharma3253]

Thanku so much

[@nikkygeorgephilip52]

Can you please add the source code

[@SHINELOVENIA7dexterity]

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.

[@strangeman4088]

Quality

[@pmolax5903]

KINDLY ADD SOURCE CODE

[@endone3661]

I am a student and I find this confusing

[@fundaofwebit]

th-cam.com/video/yp5pYIg4WHc/w-d-xo.html

[@bishnuprasadpani5123]

PLEASE SEND ME THE SOURCE CODE

[@akashsaha574]

thank you

[@addinan]

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]

Try to replace it with mysqli_fetch_assoc() function

[@Milan-ef5qr]

please provide source file

[@vaibhavbhatnagar9865]

thanks

[@artemgalperin]

code...

[@Mehachi]

Insane mate

[@sopnonildip1062]

plz give me source code

[@Mehachi]

YAAAA

[@shahindomar3958]

Maay isko samjha,lakin isko sath photo kaise display kar sakti o print kaise karta hu, mujhe bataye , mera email: [e-mail]. thanks

[@linkdotnet2157]

can you plz share the source code