first time I tried to connect to my db something went wrong. Among other things I had to give up. Today I could to it thanked to your awesome tutorial.
if anyone gets the error mysql_fetch_assoc() expects parameter 1 to be resource, object given in... replace while ($employee=mysql_fetch_assoc($records) with while ($employee = $records->fetch_assoc())
Thanks. Very explanatory and straight to the point. Please i have created a login id page, how do i display the details on browser from mysql database?
+dhanush gr This error means you did something wrong in your query. Check for single/double quotation marks. When I called my table with single quotations, I got this error too. I removed the quotations and the error was gone. Edit: you can also log the error after the result (in this video $records). Just type if (!$result){ echo "error: ".mysql_error(); } This will log it outside of the html, so it will probably be on the top of your page. You can also place it inside of your html code by adding the error message to a variable like so: if (!$result){ $msg = ""
+Aaron Esteban (Etsy SEO Talk) Yes, all you have to do is replace the database connection with a more secure option, but the code bellow it is still good to be used.
excellent video, been looking for this for months can't find it, how about inserting images from a database, or querying the informayion and the result display in db Thanks
Great video, straight to the point, simple and easy to follow Thank you for the tutorial, would be nice to see a few more php tutorial Liked and subbed
hi, what about the user require and the system may need to perform to them? such as login: user >> login >> confirm with database >> profile My problem is how does the user able to see their information after succesfully login? Thnak you!
"unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)" i did the same but it shows the above error , can i get any help?
Hello sir, can u help me? problem is: i have two table 1 (id, name), & table 2 (id, amout). I want to create a page like (index.php), when i input id on textbox then name will automatic show into another textbox then i input amount. Is it possible ?
Instead of echoing all that HTML it's better practice to embed your php code within the HTML. Because it's loop, it's generate a new row and data over and over until you pass all your data.
Hi! I followed your tutorial... I got this error -> Parse error: syntax error, unexpected '{' Right next to the while ($employee = $records->fetch_assoc())
you're an absolute beauty, ten years old and this video is still the best on youtube!
One of the clearest and most straightforward tutorials I have seen regarding this. Great job!
The table's headline's tag doesn't close correctly. You forgot the /
Very useful video, straight to the point and easy to understand code
first time I tried to connect to my db something went wrong. Among other things I had to give up. Today I could to it thanked to your awesome tutorial.
Thank you man, I have been struggling all night. You just saved me one piece of code.
Its Excellent...Keep Posting Such videos..
if anyone gets the error mysql_fetch_assoc() expects parameter 1 to be resource, object given in...
replace while ($employee=mysql_fetch_assoc($records) with
while ($employee = $records->fetch_assoc())
i've been looking for a tutorial that explains how to rach elements of my sql table. Thanks so much!
You sir, deserve a thousand likes!
thank you so very much fiki.. you did a great job... and my project has greatly benefitted from this..
Very explanatory. Thank you very much. I look forward to seeing more of your work.
Thanks. Very explanatory and straight to the point. Please i have
created a login id page, how do i display the details on browser from mysql database?
Thanks, very very straight forward to follow.
I really liked your video. fantastic job and super helpful.
very good video tutorial! gives a very good understanding
Thank You! very simple and well-explained example. This is exactly what I needed.
Great! it works. But can you implement so that we can search a term and then display only those values.
This videos are very nice. Wow!
Great turtorial!
Thank you very much! You helped me alot
hey i followed your tutorial , getting the following error :-
mysql_fetch_assoc() expects parameter 1 to be resource, boolean. What to do??
+dhanush gr This error means you did something wrong in your query. Check for single/double quotation marks. When I called my table with single quotations, I got this error too. I removed the quotations and the error was gone.
Edit: you can also log the error after the result (in this video $records). Just type
if (!$result){
echo "error: ".mysql_error();
}
This will log it outside of the html, so it will probably be on the top of your page. You can also place it inside of your html code by adding the error message to a variable like so:
if (!$result){
$msg = ""
I Got The Reset Katarina Okay katarina , ill try that..
mysql is no more valid... Try using mysqli_fetch_assoc()
i am working on a project. And you helped me out. thanks!!!!
Also, by the way. The PDO class does this much more efficient. I recommend that over this technique. It's safer too.
Thank you very much ! You helped me alot ! I've been doing it since 3 days non - stop but this helped me ! THanks!
great explanation
how can i manually input the query?
like add a input text box and type the query on the page itself rather in the php code
thank you very much brother for this tutorial.
hai thanks you very much,its very usefull for my work
great explanation...
Thanks. Very explanatory and straight to the point. Please i have created a signup page, how do i save the details on mysql database?
I will soon be posting some videos to that effect, stay in touch.
+Aaron Esteban (Etsy SEO Talk) Yes, all you have to do is replace the database connection with a more secure option, but the code bellow it is still good to be used.
thank you mr. gobi
Good Tutorial... Thanks a lot...
Thanks, clear explanation. Liked and subscribed.
wowwww.... super
thanks for the explanation
excellent video, been looking for this for months can't find it, how about inserting images from a database, or querying the informayion and the result display in db
Thanks
He did display the results and the original database. The results showed at the end of the video.
thank you very much it really helped with my project
Great tutorial, thanks!
awesome video, thank you!
Great video, straight to the point, simple and easy to follow
Thank you for the tutorial, would be nice to see a few more php tutorial
Liked and subbed
Thanks, i works perfectly...
Thanks for your nice vid tutorials. How can we search query from a input box using form,?
Helped SO MUCH, thank you.
thank for your video. it is definitely understandable
thank you for this video, it helps me a lot
Thanks,it work..really helpful..
good video man,it helped me a lot
nice tutorial
Woow! This one just helped me..
😊😊😊 thank you ✔✔✔ good job there..it will really help me
Nice tutorial, helped with a problem i was having :)
very nice. Thank you
tx so much. You make it look easy! : )
I tried it it works fine
this is awesome. thanks a lot for sharing
sir, you are a legend! thank you so much!
thanks a lot man this was very helpful for me!
Hi,
Could you please provide link in the description field for the code so that it is convenient for us.
Best Regards
Hi,
This is awesome but;
What if i want to display this dynamically accessed data in a slider (4 items per slide)...
It helped thank you very much
Thank you!
Is it possible to format the data that's extracted from the database? That is not have it just be in displayed in a table?
HEY man.
best instruction
Good tutorial. But why did you need to loop it? And thanks for the vid.
super bro
thank you very much. your really saved me
thank bro it is very useful for me i am very upset for this thank again
Can u help me.....
Thank you for your program.
really helpful
hi, what about the user require and the system may need to perform to them?
such as login: user >> login >> confirm with database >> profile
My problem is how does the user able to see their information after succesfully login?
Thnak you!
nice.. really helping..
helpful
i have 2 datas in database. i want to show the datas in one text box using php?
Thank you very much :)..
Thanks Sir
Great vid, why does everyone always use a html table though? Is there not a better way?
There are tons of better ways but tables are just good for teaching the concept, i`m not saying its the best though.
Thanks.
What other ways would you recommend?
many thanks
!
Thanks. Very helpful.
"unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)"
i did the same but it shows the above error , can i get any help?
I thank you so much, this saved me
Hello sir, can u help me? problem is:
i have two table 1 (id, name), & table 2 (id, amout). I want to
create a page like (index.php), when i input id on textbox then name
will automatic show into another textbox then i input amount. Is it
possible ?
Thank You a lot
Thanks a lot
awesome
really help me alot, thx ^_^
Ty, this was an excellent tutorial :p
thank u soo much just copy this code and edit it..
Instead of echoing all that HTML it's better practice to embed your php code within the HTML. Because it's loop, it's generate a new row and data over and over until you pass all your data.
Thank you
but we dont explain what does we use roots in this web page
really works...damn good man...really helpful.thanks loadz man
when are you going to upload a PDO video for PHP7?
Very soon
i am having so many problems with the pdo i think i will simply uninstall xampp with php7 and downgrade to php5
Hi! I followed your tutorial... I got this error -> Parse error: syntax error, unexpected '{'
Right next to the while ($employee = $records->fetch_assoc())
THANK YOU SO MUCH!
It worked perfectly. Thank you so much!
Thank youu soo much!! ^_^ Great help here!! :)
You rock!
what does $records means
can i change it ? pls help
thanks a lot
you know you can select database inline with the connect query like this
mysql_connect('localhost', 'root', 'yourpass', 'db_name');
the current technique is by using pdo
Thanks
how to show a single person info from a database which is active and want to see his/her own profile ?????