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);
