PHP Lesson 34 - Creating Tables in MySQL using PHP

In this lesson I create a table in a MySQL database using a PHP web page. I use the MYSQL_CONNECT function to connect to MySQL. After the connection, I use the MYSQL_SELECT_DB function to select the database the table will be created in. To create the table I use the MYSQL_QUERY function to send a SQL Statement to create the table with the fields.

[davidsmith-wsbz]

Excellent tutorials. You also have a very nice voice, that is easy to listen to.

thanks for high quality tutorials, see you

[randotron]

Brilliant! thank getting my ass kicked by the course im taking!!!! until i found this you again!!!!

[jerkie]

thank you sir for this tutorial. sir, your code didn't work but it's a big help for me to edit. I edit some codes in your tutorial and finally it works... Godbless :)

[zainfarooq]

Thank you very much... May God Bless you

[AlanDuggan]

i'm working with your video but i'm using my own database farms, i'm doing for a project, but when i create a table in the farms database, not table shows up, WHY!!!

[AutumnRide]

Great tutorials! One question though. How come your collation is coming up as latin1_swedish_ci in the table you created? Sorry if you mentioned why in the vid and I missed it.

[dashbyictfd]

Nice tutorial, 1 question, I have created the test table for future use but when creating the table normally your first field is an id of sorts, normally the PK, how do you set the PK through Php?

Everything worked great, just want to save myself going in PhpMyAdmin

[the_hunterghost]

how come when u created the table didnt created an ID parameter for the table that is and int and auto increment????

[itsumarejaz]

The table doesn't show up. i'm working with your video but i'm using my own database. but the table doesn't show up

[reybolesca]

your video is very helpful, but the same with dashbyictfd, how to create a table attribute that is a primary key?? tnx sir.

[billskinnars]

I have a litle bit of a problem. When i am trying to connect to my database it hasent got any information what so ever from the php code. I know that I have connected to the right database and followed this tutorial. So please help me.
'

[uzi]

how to set auto increment id with php code???

[dancecurly]

do you have a clear code for this video?

[awalji]

Can you help me with this error?

mysql_select_db() expects parameter 2 to be resource, null given

[arasaezat]

please help me in this error : -

--> Access denied for user ''@'localhost' to database 'test2' <--




//test2 is my db