Everything PHP: Creating a Database
Posted on July 1st, 2009
Now that we have gone over database structures and field types, we can finally create our database. Once we have created our database, we can begin to go over how to interact with the MySQL server using PHP.
The process to create a database will vary depending on your host. However, the basic premise is the same. You create a database along with a MySQL username and password (choose a strong, randomized password). You then associate the MySQL user with the database. Once you have done that, you MySQL database now exists.
However, your database is basically useless, as you currently have no structure to store any data in. To begin adding in your structure, you’ll have to move over to a different tool, which is usually phpMyAdmin. Once you’re in phpMyAdmin, you can begin creating tables and fields in your database.
If you ever get stuck on what field type you should use, refer to the MySQL documentation for an explanation. Get your database all setup and ready for next week, when we’ll be getting into the integration between PHP and MySQL.
Posted in Development | | | Digg This | del.icio.us | Technorati
Related Topics:
Everything PHP: Connecting to MySQLEverything PHP: Introduction to Database StructuresEverything PHP: Connecting to MySQLWordPress Development: Database CallsEverything PHP: Introduction to MySQL
2 Comments
Sorry, the comment form is closed at this time.
phpMyAdmin is outstanding software. It makes managing MySQL possible for people with limited technical skills.
I’m trying to create a simple search form that will search my databases table columns, and return and display rows that match the search criteria. Kinda like searching an address book. Any ideas??