Creating a database
You'll need a database to execute your PHP code against, so creating that database is your next step. Because configurations vary among web hosts, you'll need to find out from yours the specific passwords and procedures needed to create the initial database.
Once you've created the database, let's apply a PHP script to create a table for it, and then some sample data for the table.
Paste the following code into your IDE.
mysql_connect("YOUR_USERNAME.YOUR_HOSTS_MYSQL_WEB_ADDRESS", "YOUR_USERNAME", "YOUR_PASSWORD") or die(mysql_error());
mysql_select_db("YOUR_DATABASE_NAME") or die(mysql_error());
$query="CREATE TABLE movies (Title varchar(80), Director varchar(80), YearReleased int);";
$rc = mysql_query($query);
Replace the capitalized text with your logon information, which your web host will provide to you.
Upload the script to your server, then execute it by entering its web address in a browser. You should see a "1" if the script succeeded in creating a table. If you see another number, verify that you entered the script correctly, and also verify your logon information.
Open the MySQL administration console on your web host, and click the link for your database. The resulting page should display a new table called "movies." That's the table your PHP script just created.