Use PHP to Retrieve MySQL Data

[farha2012]

thanks a lot..:)

[MegaTony1965]

Thanks nice and neat work.

I just added the username and password of my PHPAdmin

Thanks

[soldieroscar]

TY helped a lot..

[KaibaCorporationDTDL]

thanks man, this helped a lot.

[mastersuv]

So, that query will always take all the data and put it into an array? No exception?

[angelbacs]

Hello Sir, What if i would like to retrieve the image from the database? i think the type is blog.it is the same process?plss help me...

from~gel_marc@yahoo.com

[batangyagit20]

man i love you very much :D now i know how to connect to an online database!

[samiwistler]

PHP gurus

[titanicmusic14]

You probably already know this but ... YOU ARE THE MAN!!!!!!!! thanks for your help!

[mmelson350]

When i dump data on my site, I need those "enum" values to repersent what they stand for. Dumping them just prints what is in the fields. Like a "Male" = "0" and "Female" = "1". To make my website display what the values mean. Maybe someone can point me in the right direction.

[aramkurdi]

hi, thank you for your time and effert for creating these tutorials, can you make one tutorial of (how to querry the database from web using php, ie make the query from user input, rather than saying select * ,,, just put and id and then retrive the entire row that have connection with that row.

your time and effort appreciated very much. aram1918@yahoo.co.uk

[anayfp]

Many Thanks, great Job!. 

[ncbookz]

thank you sir i will be glad to add money to a paypal email for this help, i have my own server and php my admin but i needed to display sku on a web page for my helper to have fast access very good help! i will formulate a question later on help in another issue

[dashbyictfd]

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 ?

[dashbyictfd]

This was the first tutorial on this that I had followed that was

a) complete

and

b) I got working

great thanks.

[ncbookz]

@dashbyictfd i agree it worked perfect on my code and i looked at another site and the code was using loops like crazy this was a lot easier code very short ans sweet

[betaalpha987]

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!

[TheyCallmeSR]

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.

[ncbookz]

@TheyCallmeSR if your forum uses a database then it will work this worked perfect for me he did a great job it is perfectemente

[WayneWexford]

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

[WeedingWaimbow]

What keyboard are you using?

[HxNxIxC]

YOU SOUND LIKE MARK ZUCKERBERG

[duubamg]

He's got a beautiful accent. Which region people sound like this?

[timboiscool]

what is the link

[Petterss22]

Great tutorial dude :)

Though I'm a Pro on PHP but I love your videos, you explain good.

Very good for newbies.

[littleweb1]

hey if your pretty good at it could you make a video on how to put a username and pass on a site?

[Petterss22]

Yes, sure.

But I hate the uploading limit.

[23528]

good one..hope you can post more of these!

[alasxdair]

GREAT tutorial. I am hoping to see more advanced use of php/mysql in future videos from you.