Figure 10-4 6. If you click New Character again, you should now see an extra field for Enemies. You can select any previously created character in the database as the current character s enemy. 7. From the home page, click one of your characters names. The Character Editor page loads again, but now the background is green, and the character s data will be automatically entered into the fields (see Figure 10-5). If you look at the URL for this page, you see ?c=x at the end, where x is the character s number. 8. Change some of the data, and click Update Character. You are taken back to the home page, and you should immediately see the results of your changes. In fact, if you selected an enemy for this character, you should see the results change in the enemy s row as well. 314 Chapter 10
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.

Figure 10-3 313 Building Databases
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.

3. Open your browser, and point it to the location of charlist.php. This is your Character Database home page. It should look something like Figure 10-2. If the logo is missing, you can download it from the Web site, edit the four pages to eliminate the image, or change it to anything you want. Because you don t currently have any characters to look at, let s move on. Figure 10-2 4. Click the New Character link. A shiny new page appears, ready for your data input (see Figure 10-3). You will notice that the powers you entered are choices in the Powers field. (Relational databases rule!) 5. Enter the appropriate data, and click Create Character. You should be taken to the home page, where you ll now see the character you entered (as in Figure 10-4). 312 Chapter 10
Searching for affordable and proven webhost to host and run your servlet applications? Go to Linux Web Hosting services and you will find it.

Enemies:
(Ctrl-click to
select multiple
enemies) $value) { echo $valuen ; } ?>

Character >     

>

Return to Home Page 311 Building Databases
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.

Try It Out Managing the Characters The next file you re going to create will display a list of the characters in your database. 1. Enter the following code, and save it as charlist.php: alias ASC , 2 => name ASC , 3 => align ASC, alias ASC ); $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die( Could not connect to MySQL database. . mysql_error()); mysql_select_db(SQL_DB, $conn); $sql = SELECT c.id, p.power . FROM char_main c . JOIN char_power p . JOIN char_power_link pk . ON c.id = pk.char_id AND p.id = pk.power_id ; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) { $p[$row[ id ]][] = $row[ power ]; } foreach ($p as $key => $value) { $powers[$key] = implode( , , $value); } } $sql = SELECT c.id, n.alias . FROM char_main c . JOIN char_good_bad_link gb . JOIN char_main n . ON (c.id = gb.good_id AND n.id = gb.bad_id) . OR (n.id = gb.good_id AND c.id = gb.bad_id) ; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_array($result)) { $e[$row[ id ]][] = $row[ alias ]; } foreach ($e as $key => $value) { 306 Chapter 10
We recommend you use shared web hosting services, because many users agree that it is cheap, reliable and customer-satisfying webhost.

This is the rest of the if statement. If there is even one power, a row is created that contains a delete button. If not, the script creates a row that simply states that no powers have yet been entered. $delbutton =

deleting will remove all associated powers
from characters as well — select wisely

; } else { $powerchk =

; $delbutton = ; $cols = 1; } ?> We have left off some of the HTML. We assume you know HTML well enough that we don t need to explain it. As you can see in the
tag, when the user clicks the Add Power or Delete Powers button, you ll be sending values to char_transact.php:
At this point, $powerchk either contains the No Powers display, or the built-up table columns. Either way, the script inserts $powerchk into the table. Note the open and close table definitions (
and

). You didn t add them to $powerchk earlier, but you did add the internal close/open definitions to create the columns as necessary.

In the following, $delbutton either contains the row with the delete button (if powers were found), or it s blank. That is how you control when it shows up, and this is where it s inserted into the table. The following code deals with the add button. Notice that it is called action and that it has a value of Add Power. When submitting a form, PHP passes these values on to the next page. Because you are using the post method on the form, you will have a $_POST variable called action that contains the value of the button. Because of this, and because all of your forms load char_transact.php, all of your buttons are named action and have different values so that you can determine what to do with the data that is sent. We go into more detail about this when we look at char_transact.php. 305 Building Databases
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.

Posted in php | No Comments »