<?
include("general.php");
function name_fill($name) {
if(strlen(trim($name))<3)
{
$is_name = "<font size=2 color=red>required-must be at least 3
characters</font>";
}
return $is_name;
}
function prov_fill($userprovince) {
if($userprovince == "")
{
$is_prov = "<font size=2 color=red>province is a required
field</font>";
}
return $is_prov;
}
function lang_fill($langspoke) {
if($langspoke == "")
{
$is_lang = "<font size=2 color=red>language is a required field</font>";
}
return $is_lang;
}
function sex_fill($sex) {
if($sex == "")
{
$is_sex = "<font size=2 color=red>sex is a required field</font>";
}
return $is_sex;
}
function pass_fill($userpassword) {
if((strlen(trim($userpassword))<5)||(strlen(trim($userpassword))>8))
{
$is_pass = "<font size=2 color=red>required-must be between 5 to 8
characters</font>";
}
return $is_pass;
}
function insert_test($name,$userprovince,$langspoke,$sex) {
global $db;
$query = "insert into
test(name,userprovince,langspoke,sex) values('".$name."','".$userprovince."','".$langspoke."','".$sex."')";
$db ->execute($query);
return last_id;
}
function
select_test(&$namearray,&$userprovincearray,&$langspokearray,&$sexarray,&$test_idarray){
global $db;
$query = "select * from test order by name";
$ls = $db->execute($query);
$namearray = array();
$userprovincearray = array();
$langspokearray = array();
$sexarray = array();
$test_idarray = array();
$rows=$ls->getNumOfRows();
$j=0;
if(!$rows)
return 0;
while(!$ls->EOF) {
$namearray[$j] = $ls->fields["name"];
$userprovincearray[$j] = $ls->fields["userprovince"];
$langspokearray[$j] = $ls->fields["langspoke"];
$sexarray[$j] = $ls->fields["sex"];
$test_idarray[$j] = $ls->fields["test_id"];
$ls->nextRow();
$j++;
}
return $j;
}
?>
<head>
<title> Error Detection Form </title>
</head>
<body bgcolor="#ffffff">
<form method="post" action="edit.php">
<input type="hidden" name="submitted" value="1">
<table
width="500" border="0" cellspacing="2" cellpadding="5" align="center">
<tr>
<td width="125" align="right"><b>Name:</b></td>
<td><input type="text" name="name"><? print(name_fill($name)); ?></td>
</tr>
<tr>
<td width="125" align="right"><b>Province:</b></td>
<td><select name="userprovince" size="1">
<option value="0" selected>Select</option>
<option value="British Columbia">British Columbia</option>
<option value="Alberta">Alberta</option>
<option value="Saskatchewan">Saskatchewan</option>
<option value="Manitoba">Manitoba</option>
<option value="Ontario">Ontario</option>
<option value="Quebec">Quebec</option>
<option value="Newfounland">Newfoundland</option>
<option value="Nova Scotia">Nova Scotia</option>
<option value="New Brunswick">New Brunswick</option>
<option value="P.E.I">Prince Edward Island</option>
</select>
<? print(prov_fill($userprovince)); ?>
</tr>
<tr>
<td width="125" align="right"><b>Languages Spoken:</b></td>
<td>
<input type="checkbox" name="langspoke" value="english">English<br>
<input type="checkbox" name="langspoke" value="french">French<br>
<input type="checkbox" name="langspoke" value="spanish">Spanish<br>
<input type="checkbox" name="langspoke" value="german">German<br>
<input type="checkbox" name="langspoke" value="other">Other<br>
<? print(lang_fill($langspoke)); ?>
</td>
</tr>
<tr>
<td width="125" align="right"><b>Sex:</b></td>
<td><input type="radio" name="sex" value="male">Male<br>
<input type="radio" name="sex" value="female">Female<br>
<? print(sex_fill($sex)); ?>
</td>
</tr>
<tr>
<td width="125" align="right"><b>Password:</b></td>
<td><input
type="password" name="userpassword" size="20" maxlength="12">
<? print(pass_fill($userpassword)); ?>
</td>
</tr>
</table>
<hr colspan="2" noshade></tr>
<table
width="500" border="0" cellspacing="2" cellpadding="5" align="center">
<tr>
<td align="center" colspan="2">
<input type="submit" value="submit">
<input type="reset" value="Clear Form">
</td>
</tr>
</table>
</form>
</body>
<head><title> Test Array </title></head>
<body>
<table>
<tr>
<td> </td>
<td><b>ID</b></td>
<td> </td>
<td><b>Name</b></td>
<td> </td>
<td><b>Province<b></td>
<td> </td>
<td><b>Spoken Language</b></td>
<td> </td>
<td><b>Sex</b></td>
<td> </td>
</tr>
<?
$length=select_test(&$namearray,&$userprovincearray,&$langspokearray,&$sexarray,&$test_idarray);
for($i;$i<$length;$i++){
if($i%2==1)
$bgcolor="bgcolor='#eeeeee'";
else
$bgcolor="bgcolor='#ffffff'";
print("
<tr>
<td> </td>
<td>".$test_idarray[$i]."</td>
<td> </td>
<td>".$namearray[$i]."</td>
<td> </td>
<td>".$userprovincearray[$i]."</td>
<td> </td>
<td>".$langspokearray[$i]."</td>
<td> </td>
<td>".$sexarray[$i]."</td>
<td> </td>
</tr>
");
}
?>
</table>
</body>
