LJ Archive

Listing 2. mysql.php

<%//////////// mysql.php ////////////////////////////

include ("class.FastTemplate.php");
$tpl = new FastTemplate(".");

$tpl->define(array( main     => "main.tpl",
                 body        => "body.tpl",
                 table       => "table.tpl",
                 headerdata  => "headerdata.tpl",
                 row         => "row.tpl",
                 rowdata     => "rowdata.tpl",
                 submit      => "submit.tpl",
                 form2       => "form2.tpl"));

$tpl->assign(array( TITLE    => "PHP SQL Code Test Results",
                 SUBMIT_NAME => "SUBMIT",
                 SUBMIT_VAL  => "NEW QUERY",
                 FORM_ACTION => "index.php",
                 STRING1     => "RESULTS OF QUERY: ",
                 QUERY       => "$query",
                 FORM_METHOD => "POST"));

                             //Assumes MySQL.
$user="bill";      //Adjust for your
$host="localhost"; //setup in these
$password="megan"; //three lines.

mysql_connect($host,$user,$password);
mysql_select_db($database);

if(!strcmp($query, "")){
 //if no query, supply a generic one
    $query = "SHOW TABLES";
    }

$query = stripSlashes($query);
$result = mysql_query($query);

// append table header cells to header row.

for ($i = 0; $i < mysql_num_fields($result); $i++) {
    $thval = mysql_field_name($result,$i);
    $tpl->assign(array(HEADERDATA => "$thval"));
    $tpl->parse(HEADER, ".headerdata");
    }

// append row cells to the row, and
// then append rows to table body.

for ($i = 0; $i < mysql_num_rows($result); $i++) {
    $row_array = mysql_fetch_row($result);
    for ($j = 0; $j < mysql_num_fields($result); $j++) {
        $trval =  $row_array[$j];
        $tpl->assign(array(ROWDATA => "$trval"));
        $tpl->parse(ROW, ".rowdata");
        }
    $tpl->parse(ROWS, ".row");
    $tpl->clear("ROW");  //<- comment this line out
    }                    //   observe the results.

$tpl->parse (TABLE, "table");
$tpl->parse (SUBMIT, "submit");

$tpl->assign(array(SUBMIT_NAME => "goodbye",
                   SUBMIT_VAL  => "EXIT PROGRAM"));

$tpl->parse (GOODBYE, "submit");
$tpl->parse (FORM2, "form2");
$tpl->parse (BODY, "body");
$tpl->parse (MAIN, "main");

$tpl->FastPrint();
%
LJ Archive