public $name, $password, $id; } $fruit = array('a' => 'apple', 'b' => 'banana', 'c' => 'cranberry'); reset($fruit); while (list($key, $val) = each($fruit)) { echo "{$key} => {$val}\n"; $test = "test:"; $test .= "huh"; echo $test; } require_once 'opendb.php'; require_once 'employee/crud.php'; require_once 'employee/show.php'; $key_array = array('name' => 'Tennis2000'); $col = array('name', 'date'); $result = RowRetrieve($database, "event", $col, $key_array); TableShow($result); /* $table = "event"; $key_array = array('name' => 'Tennis2001', 'date' => '2000-12-31'); $update_array = array('fee' => 1000, 'name' => 'Tennis2001'); $create_array = array( 'name' => 'Tennis2005', 'date' => '2004-12-31', 'minlimit' => 6, 'maxlimit' => 7, 'fee' => 12, 'budget' => 200, 'dept' => 0); RowCreate($database, "event", $create_array);
<?php include '../opendb.php'; include 'crud.php'; include 'show.php'; //$result=TableRetrieve($database, 'event'); $fields = array("name", "date", "minlimit", "maxlimit", "budget", "fee", "dept"); $pkey = array("name" => "Tennis2000", "date" => "1999-12-31"); $result = RowRetrieve($database, 'event', $fields, $pkey); RowShow($result);