Use PHP to Retrieve MySQL Data
Display the data in a MySQL database table in a web page using PHP.
May 4, 2010 | Filed Under Mysql Tutorials
Comments
14 Responses to “Use PHP to Retrieve MySQL Data”
Powered by Yahoo! Answers
GREAT tutorial. I am hoping to see more advanced use of php/mysql in future videos from you.
good one..hope you can post more of these!
Great tutorial dude :)
Though I’m a Pro on PHP but I love your videos, you explain good.
Very good for newbies.
hey if your pretty good at it could you make a video on how to put a username and pass on a site?
Yes, sure.
But I hate the uploading limit.
what is the link
YOU SOUND LIKE MARK ZUCKERBERG
He’s got a beautiful accent. Which region people sound like this?
What keyboard are you using?
Firstly. Very well done tutorial. Wish I had found something like this when I was starting off. =(
Just a small note.
Using mysql_fetch_array is unnecessary as it returns both the name of the db column AND it’s index number. There’s no point in returning both when you’re only going to be using one. I’ve never been in a situation where I needed anything more than the associative name.
So instead, just use:
while($row = mysql_fetch_assoc($result)){
//etc
I’d be willing to be that it’s faster
I have been following your tut and i’m trying to imply it to my coding. Pretty much im trying to do the same thing. i want to retrieve data from my forum that i made onto my site but its not working. do u have msn or an email so i can explain it more in detail? its probably an easy fix.
I’ve tried and failed working with several php/MYSQL tutorials but this one works great! Can see the text clearly and the steps are clear and simple. Top stuff!
This was the first tutorial on this that I had followed that was
a) complete
and
b) I got working
great thanks.
In mysql the date format is in yyyy/mm/dd , is there a way to manipulate this so that when it displays on your page with the rest of the retrieved data that it can be dd/mm/yy ?