PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD-




In this tutorial, you will learn how to create a database and table within phpMyAdmin. Be sure to SUBSCRIBE because there will be a new tutorial every week.

Original source


46 responses to “PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD-”

  1. #1064- You have an error in you SQL syntax; check the manual that corresponds to your MainDB server version for the right syntax to use near '.'b'.'c' NOT NULL DEFAULT 'a' , 'email_activation' ENUM('0'.'1') NOT NULL DEFA' at line 1                                                                                                                                                                                                                                           that's the error I get when I click save. can somone please help

  2. I wouldn't recommend using VARCHAR for a numbers field as it takes up 8x as much space on the host. also, if you need to require a certain amount of characters to be entered, use CHAR instead of VARCHAR. For example, if you wanted every username to be exactly 8 characters long, you could use char and write code to listen for errors in the database.

  3. Hey just wondering im new… so for example, if im making a page on mysql @ //localhost. do i just make a .php file and save it in the server directory? Maby i haavent come across it yet but im wondering how a html doc and a php file on the database "talks" to eachother. Bvasicaly How does http://Www.example.com send the input data of a <form> to the php for processing? Is it correct to say that http://www.example.com is the server and http://www.example.com/example.php or http://www.example.com/example.jpg would be the files in the database running on the server by the user input? Is that how this shit works?

Leave a Reply