630Part IVConnectionsThe Cartoons DatabaseWe d like to be (Ipower web hosting) able

630Part IVConnectionsThe Cartoons DatabaseWe d like to be able to add some cartoons and characters to our database using a handy Web- entry system. We ve deliberately oversimplified our example to get through the key conceptsquickly, so it should be fairly easy to put together a system that allows us to achieve thistask. Listing 34-1 shows a welcoming page to our Cartoons database. Listing 34-1:index.php

Cartoons and Characters Database

Welcome to the cartoons and characters database. Existingentries are provided below. Use the provided functions to getmore details and to edit, add or delete entries.

0) { print(

); print(

); while ($sRow = pg_fetch_object($sResult)) { print(

); $tSql = select * from characters where id = $sRow->id ; $tResult = pg_query($tSql); print(

); } print(

ID Cartoon Characters
$sRow->id $sRow->cartoon ); while ($tRow = pg_fetch_object($tResult)) { print( $tRow->character ); } print(

); } else { print(

There are not currently any records in thecartoon database.

); }
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.

Leave a Reply