Samples Product Information Home Page Download Pricing

phpMyAdmin

phpMyAdmin is the standard tool used by most website developers to administer mySQL databases. If you decide to contract this part of your project out to a developer, they will almost certainly use phpMyAdmin as I describe it below.

If you created a database using the steps above, you can now look for the Control Panel link to run phpMyAdmin. Your version of phpMyAdmin may show different screens but should be similar enough to follow along.

 

Look at the top of this screenshot to find the Server name. In almost all cases, this will be localhost as shown here. If it is something different, make a note of it as you'll need it later. Notice also that the full name of the database mySite_newDatabase is also shown.

The name of the databases you create are shown on the left. At this stage, there are no tables so the next step is to create one. I'm going to call my table myInventory and, for now, I'm only to create a single column.

If you are comfortable working with phpMyAdmin, you can create all the columns manually but CleverCat provides an interface which may be easier to use and creates a CSV file for uploading at the same time. In the next chapter, I'll describe what columns are necessary.

Click Go or Save to continue.

 

Every table should have a Primary Index and that's the only column we need to create for now. In the screenshot below I've given the column the name pIndex, set the Type to Int, the Length to 11, the Index to PRIMARY and checked the A_I (auto-increment) box.

Click Go or Save to continue.

 

Here's a view of the table so far under the Structure tab. The table has only a single, indexed column pIndex and that's all you need if you are going to use CleverCat's utilities.

 

Here's a view of the full table we're going to create. You can use CleverCat's own utility to make sure the table structure matches your products or continue with phpMyAdmin. If you decide to continue with phpMyAdmin, note that the columns have different Types. CleverCat's utility will set the columns to the correct type if you decide to use it.

 

Adding columns with phpMyAdmin is not difficult. Below the current table structure you'll see the Add field where you enter the number of columns you want to add. The option At End of Table is selected by default and when you click Go, you'll see the same form (with one row for each column) that you used to add the Primary Index at the beginning of the chapter. You can simply enter the Types and values you see in the screenshot above.

 

The data types and required columns are discussed in greater detail in the next chapter.

 

Return to Tutorial Selection or Continue to the next chapter: Data Structure