Managing Your Database
I have seen tutorials around that explain how to set up tables using a shell. Although this approach definitely has advantages and is probably 'the right' way to do it, I am going to explain a simpler way for the designer who doesn't intend on working as a system admin at night.
As a first project for your database, I highly recommend setting up a system called 'phpmyadmin'. It's a web interface for your database(s) that gives you the ability to manage your data directly from the web with a simple, easy to use interface. Follow this link: http://phpmyadmin.sourceforge.net/ and download the latest version. The installation of phpmyadmin is easy and well explained but I will go over it here also. Unzip the files and find 'config.inc.php'. Open this with a text editor (I recomend using www.editplus.com but notepad will do). Use the comments as a guide and set the database name and password according to your database that you just created. Then, ftp all the files to your web site in a directory such as '/phpmyadmin'.
That's it for phpmyadmin. Go to the directory where it has been installed that contains the 'index.php' file and you should see a variety of options for adding tables and entering queries.
|» Level Basic|
Rating: 4 Votes: 105
|Bridging the gap between the world of PHP/MySQL and Flash.|
|Download the files used in this tutorial.|
|Download (0 kb)|
|More help? Search our boards for quick answers!|