Solved

Dreamweaver Update Data Wizard

Posted on 2013-01-24
5
612 Views
Last Modified: 2013-01-24
Hello
My table list links are refusing to show the data in the update form.

My links are on student_fischas.php under the label `Student` each individual name is supposed to open its relevant data on student_update.php.
Im running wamp server with phpmyadmin version 5.5.24

student_fischas.php
<?php require_once('Connections/totsandt_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_totsandt_db, $totsandt_db);
$query_Recordset1 = "SELECT * FROM parents";
$Recordset1 = mysql_query($query_Recordset1, $totsandt_db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_totsandt_db, $totsandt_db);
$query_rsStudents = "SELECT student, dateofbirth, tel, email FROM parents ORDER BY student ASC";
$rsStudents = mysql_query($query_rsStudents, $totsandt_db) or die(mysql_error());
$row_rsStudents = mysql_fetch_assoc($rsStudents);
$totalRows_rsStudents = mysql_num_rows($rsStudents);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Tots & Teens Resources</title>
<link href="_css/main.css" rel="stylesheet" type="text/css" media="screen, projection" />
</head>
<body id="home">
<div id="wrapper">
  <div id="wrapper2">
<?php include("./_includes/header.php"); ?><br />
<div align="center">
<span class="underline"><a href="student_form.php">Add Student</a></span>
<table border="0" align="center">
  <tr>
    <th>Student</th>
    <th>Birthdate</th>
    <th>Telephone</th>
    <th>Email</th>
  </tr>
  <?php do { ?>
    <tr>
      <td><h1 style="font-size:14px"><a href="student_update.php?id=<?php echo $row_rsStudents['student']; ?>"><?php echo $row_rsStudents['student']; ?></a></h1></td>
      <td><h1 style="font-size:14px"><?php echo $row_rsStudents['dateofbirth']; ?></h1></td>
      <td><h1 style="font-size:14px"><?php echo $row_rsStudents['tel']; ?></h1></td>
      <td><h1 style="font-size:14px"><?php echo $row_rsStudents['email']; ?></h1></td>
    </tr>
    <?php } while ($row_rsStudents = mysql_fetch_assoc($rsStudents)); ?>
</table>
</div>
<br />
<br />


<table align="center">
  <td align="center">
<?php include("./_includes/footer.php"); ?>
</td>
</table>


</body>
</html>
<?php

mysql_free_result($rsStudents);
?>

Open in new window


student_update.php
<?php require_once('Connections/totsandt_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE parents SET student=%s, sex=%s, dateofbirth=%s, placeofbirth=%s, address=%s, cep=%s, tel=%s, email=%s, lastschool=%s, gradecompleted=%s, referredby=%s, mothersname=%s, mothersbusiness=%s, motherstitle=%s, mothersbusinessaddress=%s, motherscep=%s, motherstel=%s, mothersfax=%s, motherscpf=%s, mothersrg=%s, fathersname=%s, fathersbusiness=%s, fatherstitle=%s, fathersbusinessaddress=%s, fatherscep=%s, fatherstel=%s, fathersfax=%s, fatherscpf=%s, fathersrg=%s, dateofentrance=%s, age=%s, teacher=%s, `date`=%s, course1=%s, teacher1=%s, date1=%s, course2=%s, teacher2=%s, date2=%s, familyphysician=%s, familyphysiciantel=%s, medicalplan=%s, medicalplantel=%s, hospital=%s, hospitaltel=%s, allergies=%s, asthma=%s, diabetes=%s, surgery=%s, obs=%s, maybetakenabove=%s, maybetakennearest=%s, shouldbetakenambulance=%s, mayreceiveailments=%s, mayreceivemed=%s, maynotreceivemed=%s, allergictomed=%s, allergictext=%s WHERE id=%s",
                       GetSQLValueString($_POST['student'], "text"),
                       GetSQLValueString($_POST['sex'], "text"),
                       GetSQLValueString($_POST['dateofbirth'], "text"),
                       GetSQLValueString($_POST['placeofbirth'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['cep'], "text"),
                       GetSQLValueString($_POST['tel'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['lastschool'], "text"),
                       GetSQLValueString($_POST['gradecompleted'], "text"),
                       GetSQLValueString($_POST['referredby'], "text"),
                       GetSQLValueString($_POST['mothersname'], "text"),
                       GetSQLValueString($_POST['mothersbusiness'], "text"),
                       GetSQLValueString($_POST['motherstitle'], "text"),
                       GetSQLValueString($_POST['mothersbusinessaddress'], "text"),
                       GetSQLValueString($_POST['motherscep'], "text"),
                       GetSQLValueString($_POST['motherstel'], "text"),
                       GetSQLValueString($_POST['mothersfax'], "text"),
                       GetSQLValueString($_POST['motherscpf'], "text"),
                       GetSQLValueString($_POST['mothersrg'], "text"),
                       GetSQLValueString($_POST['fathersname'], "text"),
                       GetSQLValueString($_POST['fathersbusiness'], "text"),
                       GetSQLValueString($_POST['fatherstitle'], "text"),
                       GetSQLValueString($_POST['fathersbusinessaddress'], "text"),
                       GetSQLValueString($_POST['fatherscep'], "text"),
                       GetSQLValueString($_POST['fatherstel'], "text"),
                       GetSQLValueString($_POST['fathersfax'], "text"),
                       GetSQLValueString($_POST['fatherscpf'], "text"),
                       GetSQLValueString($_POST['fathersrg'], "text"),
                       GetSQLValueString($_POST['dateofentrance'], "text"),
                       GetSQLValueString($_POST['age'], "text"),
                       GetSQLValueString($_POST['teacher'], "text"),
                       GetSQLValueString($_POST['date'], "text"),
                       GetSQLValueString($_POST['course1'], "text"),
                       GetSQLValueString($_POST['teacher1'], "text"),
                       GetSQLValueString($_POST['date1'], "text"),
                       GetSQLValueString($_POST['course2'], "text"),
                       GetSQLValueString($_POST['teacher2'], "text"),
                       GetSQLValueString($_POST['date2'], "text"),
                       GetSQLValueString($_POST['familyphysician'], "text"),
                       GetSQLValueString($_POST['familyphysiciantel'], "text"),
                       GetSQLValueString($_POST['medicalplan'], "text"),
                       GetSQLValueString($_POST['medicalplantel'], "text"),
                       GetSQLValueString($_POST['hospital'], "text"),
                       GetSQLValueString($_POST['hospitaltel'], "text"),
                       GetSQLValueString($_POST['allergies'], "text"),
                       GetSQLValueString($_POST['asthma'], "text"),
                       GetSQLValueString($_POST['diabetes'], "text"),
                       GetSQLValueString($_POST['surgery'], "text"),
                       GetSQLValueString($_POST['obs'], "text"),
                       GetSQLValueString(isset($_POST['maybetakenabove']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['maybetakennearest']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['shouldbetakenambulance']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['mayreceiveailments']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['mayreceivemed']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['maynotreceivemed']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString(isset($_POST['allergictomed']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($_POST['allergictext'], "text"),
                       GetSQLValueString($_POST['id'], "int"));

  mysql_select_db($database_totsandt_db, $totsandt_db);
  $Result1 = mysql_query($updateSQL, $totsandt_db) or die(mysql_error());

  $updateGoTo = "student_fischas.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

$colname_rsUpdate = "-1";
if (isset($_GET['id'])) {
  $colname_rsUpdate = $_GET['id'];
}
mysql_select_db($database_totsandt_db, $totsandt_db);
$query_rsUpdate = sprintf("SELECT id, student, sex, dateofbirth, placeofbirth, address, cep, tel, email, lastschool, gradecompleted, referredby, schooltoattend, mothersname, mothersbusiness, motherstitle, mothersbusinessaddress, motherscep, motherstel, mothersfax, motherscpf, mothersrg, fathersname, fathersbusiness, fatherstitle, fathersbusinessaddress, fatherscep, fatherstel, fathersfax, fatherscpf, fathersrg, dateofentrance, age, course, teacher, `date`, course1, teacher1, date1, course2, teacher2, date2, familyphysician, familyphysiciantel, medicalplan, medicalplantel, hospital, hospitaltel, allergies, asthma, diabetes, surgery, obs, maybetakenabove, maybetakennearest, shouldbetakenambulance, mayreceiveailments, mayreceivemed, maynotreceivemed, allergictomed, allergictext FROM parents WHERE id = %s", GetSQLValueString($colname_rsUpdate, "int"));
$rsUpdate = mysql_query($query_rsUpdate, $totsandt_db) or die(mysql_error());
$row_rsUpdate = mysql_fetch_assoc($rsUpdate);
$totalRows_rsUpdate = mysql_num_rows($rsUpdate);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Tots & Teens Resources</title>
<link href="_css/main.css" rel="stylesheet" type="text/css" media="screen, projection" />
</head>
<body id="home">
<div id="wrapper">
  <div id="wrapper2">
     <?php include("./_includes/header.php"); ?>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<form action="<?php echo $editFormAction; ?>" id="form1" method="POST" name="form1">
<fieldset id="totsandt_fieldset">
<table align="center"><tr align="center"><td><h1 style="color:2A55FF">STUDENT APPLICATION FORM</h1><br /></td></tr></table>
<table align="center"><td><label for="student">NAME:</label><input name="student" type="text" class="underline" id="student" style="width: 590px;" value="<?php echo $row_rsUpdate['student']; ?>"></td>
  <td>Male<input <?php if (!(strcmp($row_rsUpdate['sex'],"m"))) {echo "checked=\"checked\"";} ?> type="radio" name="sex" value="m" />Female<input <?php if (!(strcmp($row_rsUpdate['sex'],"f"))) {echo "checked=\"checked\"";} ?> type="radio" name="sex" value="f" /></td> </tr></table>
    
    <table align="center">
    <td><label for="dateofbirth">DATE OF BIRTH:</label><input name="dateofbirth" type="text" class="underline" id="dateofbirth" style="width: 260px;" value="<?php echo $row_rsUpdate['dateofbirth']; ?>"></td>
    <td><label for="placeofbirth">PLACE OF BIRTH&nbsp;</label><input name="placeofbirth" type="text" class="underline" id="placeofbirth" style="width: 250px;" value="<?php echo $row_rsUpdate['placeofbirth']; ?>"></td>
</table>

<table align="center">
  <td><label for="cep">ADDRESS:</label><input name="address" type="text" class="underline" id="address" style="width: 704px;" value="<?php echo $row_rsUpdate['address']; ?>"></td></table>
    
<table align="center">
  <td><label for="cep">CEP:</label><input name="cep" type="text" class="underline" id="cep" style="width: 212px;" value="<?php echo $row_rsUpdate['cep']; ?>"></td>
    <td><label for="cep">TEL:</label><input name="tel" type="text" class="underline" id="tel" style="width: 212px;" value="<?php echo $row_rsUpdate['tel']; ?>"></td>
  <td><label for="email">E-MAIL:</label><input name="email" type="text" class="underline" id="email" style="width: 212px;" value="<?php echo $row_rsUpdate['email']; ?>"></td></table>
    
<table align="center">
    <td><label for="lastschool">LAST SCHOOL:</label><input name="lastschool" type="text" class="underline" id="lastschool" style="width: 250px;" value="<?php echo $row_rsUpdate['lastschool']; ?>"></td>
  <td><label for="gradecompleted">GRADE COMPLETED:</label><input name="gradecompleted" type="text" class="underline" id="gradecompleted" style="width: 250px;" value="<?php echo $row_rsUpdate['gradecompleted']; ?>"></td></table>
  
<table align="center">
    <td><label for="referredby">REFERRED BY:</label><input name="referredby" type="text" class="underline" id="referredby" style="width: 670px;" value="<?php echo $row_rsUpdate['referredby']; ?>">
  </td></table>
  
  <table align="center">
  <tr>
    <td align="center"><label for="schooltoattend">PLEASE CHECK BELOW THE SCHOOL YOU WISH YOUR CHILD TO ATTEND:</label>
    </td> </tr><tr><td>  
          <input <?php if (!(strcmp($row_rsUpdate['referredby'],"chapel"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="chapel" id="schooltoattend	_0" />
               <label>CHAPEL</label>
  <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"graded"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="graded" id="schooltoattend	_1" />
          GRADED</label>
        <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"paca"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="paca" id="schooltoattend	_2" />
          PACA</label>
        <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"stnicholas"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="stnicholas" id="schooltoattend	_3" />
          ST.NICHOLAS</label>
        <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"stpauls"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="stpauls" id="schooltoattend	_4" />
          ST.PAULS</label>
        <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"globaled"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="globaled" id="schooltoattend	_5" />
          GLOBAL ED.</label>
        <label>
          <input <?php if (!(strcmp($row_rsUpdate['schooltoattend'],"stfrancis"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="schooltoattend	" value="stfrancis" id="schooltoattend	_6" />
          ST.FRANCIS</label></td>
  </tr>
  </table>
 <br /><br />
 
  <table align="center">
  <td><label>MOTHER:</label>
<input name="mothersname" type="text" class="underline" id="mothersname" style="width: 710px;" value="<?php echo $row_rsUpdate['mothersname']; ?>"></td></table>
 
<table align="center">
  <td><label>BUSINESS/FIRM:</label>
<input name="mothersbusiness" type="text" class="underline" id="mothersbusiness" style="width: 295px;" value="<?php echo $row_rsUpdate['mothersbusiness']; ?>"></td><td><label>TITLE:</label>
<input name="motherstitle" type="text" class="underline" id="motherstitle" style="width: 295px;" value="<?php echo $row_rsUpdate['motherstitle']; ?>"></td></table>

  <table align="center">
  <td><label>BUSINESS ADDRESS:</label>
<input name="mothersbusinessaddress" type="text" class="underline" id="mothersbusinessaddress" style="width: 625px;" value="<?php echo $row_rsUpdate['mothersbusinessaddress']; ?>"></td></table>	
  
<table align="center">
  <td><label>CEP:</label>
<input name="motherscep" type="text" class="underline" id="motherscep" style="width: 220px;" value="<?php echo $row_rsUpdate['motherscep']; ?>"></td><td><label>TEL:</label>
<input name="motherstel" type="text" class="underline" id="motherstel" style="width: 220px;" value="<?php echo $row_rsUpdate['motherstel']; ?>"></td><td><label>FAX:</label>
<input name="mothersfax" type="text" class="underline" id="mothersfax" style="width: 220px;" value="<?php echo $row_rsUpdate['mothersfax']; ?>"></td></table>

<table align="center">
    <td><label for="motherscpf">CPF:</label><input name="motherscpf" type="text" class="underline" id="motherscpf" style="width: 361px;" value="<?php echo $row_rsUpdate['motherscpf']; ?>"></td>
<td><label for="mothersrg">RG:</label><input name="mothersrg" type="text" class="underline" id="mothersrg" style="width: 361px;" value="<?php echo $row_rsUpdate['mothersrg']; ?>"></td></table>
<br />
<br />
<table align="center">
  <td><label>FATHER:</label>
<input name="fathersname" type="text" class="underline" id="fathersname" style="width: 715px;" value="<?php echo $row_rsUpdate['fathersname']; ?>"></td></table>
 
  <table align="center">
  <td><label>BUSINESS/FIRM:</label>
<input name="fathersbusiness" type="text" class="underline" id="fathersbusiness" style="width: 295px;" value="<?php echo $row_rsUpdate['fathersbusiness']; ?>"></td><td><label>TITLE:</label>
<input name="fatherstitle" type="text" class="underline" id="fatherstitle" style="width: 295px;" value="<?php echo $row_rsUpdate['fatherstitle']; ?>"></td></table>

  <table align="center">
  <td><label>BUSINESS ADDRESS:</label>
<input name="fathersbusinessaddress" type="text" class="underline" id="fathersbusinessaddress" style="width: 625px;" value="<?php echo $row_rsUpdate['fathersbusinessaddress']; ?>"></td></table>	
  
    <table align="center">
  <td><label>CEP:</label>
<input name="fatherscep" type="text" class="underline" id="fatherscep" style="width: 220px;" value="<?php echo $row_rsUpdate['fatherscep']; ?>"></td><td><label>TEL:</label>
<input name="fatherstel" type="text" class="underline" id="fatherstel" style="width: 220px;" value="<?php echo $row_rsUpdate['fatherstel']; ?>"></td><td><label>FAX:</label>
<input name="fathersfax" type="text" class="underline" id="fathersfax" style="width: 220px;" value="<?php echo $row_rsUpdate['fathersfax']; ?>"></td></table>

<table align="center">
    <td><label for="fatherscpf">CPF:</label><input name="fatherscpf" type="text" class="underline" id="fatherscpf" style="width: 361px;" value="<?php echo $row_rsUpdate['motherscpf']; ?>"></td>
<td><label for="fathersrg">RG:</label><input name="fathersrg" type="text" class="underline" id="fathersrg" style="width: 361px;" value="<?php echo $row_rsUpdate['fathersrg']; ?>"></td></table>
<br />

<br />
<br />
<table align="center">
<tr align="center"><td><h1 style="font-size:23px">MEDICAL RECORD</h1></td><tr>
</table>

<table align="center">
   <td><label for="familyphysician">Family Physician:</label><input name="familyphysician" type="text" class="underline" id="familyphysician" style="width: 295px;" value="<?php echo $row_rsUpdate['familyphysician']; ?>">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td><label for="familyphysiciantel">Tel:</label><input name="familyphysiciantel" type="text" class="underline" id="familyphysiciantel" style="width: 295px;" value="<?php echo $row_rsUpdate['familyphysiciantel']; ?>"></td></table>

<table align="center">
   <td><label for="medicalplan">Medical Plan:</label><input name="medicalplan" type="text" class="underline" id="medicalplan" style="width: 328px;" value="<?php echo $row_rsUpdate['medicalplan']; ?>">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td><label for="hospitaltel">Tel:</label><input name="medicalplantel" type="text" class="underline" id="medicalplantel" style="width: 294px;" value="<?php echo $row_rsUpdate['medicalplantel']; ?>"></td></table>

<table align="center">
   <td><label for="hospital">Hospital:</label><input name="hospital" type="text" class="underline" id="hospital" style="width: 360px;" value="<?php echo $row_rsUpdate['hospital']; ?>">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
<td><label for="hospitaltel">Tel:</label><input name="hospitaltel" type="text" class="underline" id="hospitaltel" style="width: 295px;" value="<?php echo $row_rsUpdate['hospitaltel']; ?>"></td></table>
 
 <table align="left">
<tr align="left"><td><h1 style="font-size:25px"> <br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;History:</h1></td><tr>
</table><br /><br /><br /><br /><br /><br />



<table align="center">
    <td><label for="allergies"><li>Allergies:</li></label><input name="allergies" type="text" class="underline" id="allergies" style="width: 731px;" value="<?php echo $row_rsUpdate['allergies']; ?>"></td></tr></table>
    
<table align="center">
    <td><label for="asthma"><li>Asthma:</li></label><input name="asthma" type="text" class="underline" id="asthma" style="width: 731px;" value="<?php echo $row_rsUpdate['asthma']; ?>"></td></tr></table>
    
<table align="center">
    <td><label for="diabetes"><li>Diabetes:</li></label><input name="diabetes" type="text" class="underline" id="diabetes" style="width: 731px;" value="<?php echo $row_rsUpdate['diabetes']; ?>"></td></tr></table>
 
<table align="center">
    <td><label for="surgery"><li>Surgery:</li></label><input name="surgery" type="text" class="underline" id="surgery" style="width: 731px;" value="<?php echo $row_rsUpdate['surgery']; ?>"></td></tr></table>
  <br />
<br />

<table align="center">
    <td><label for="obs">Obs:</label><input name="obs" type="text" class="underline" id="obs" style="width: 731px;" value="<?php echo $row_rsUpdate['obs']; ?>"></td></tr></table>
    
   <br />
<br />
<table align="left">
<tr align="left"><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<u style="font-size:22px">Please tick below to indicate procedures to be taken.</u><br /></td><tr>
</table><br /><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label style="text-align:left" style="font-size:20px">My Child:</label><br /><br /><br /><br />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['maybetakenabove'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="maybetakenabove" value="maybetakenabove" id="maybetakenabove" />
          May only be taken to the hospital mentioned above</label><br />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['maybetakennearest'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="maybetakennearest" value="maybetakennearest" id="maybetakennearest" />
          May be taken to the nearest hospital</label><br />
          
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['shouldbetakenambulance'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="shouldbetakenambulance" value="shouldbetakenambulance" id="shouldbetakenambulance" />
          Should be taken to hospital using the Medical Plan Ambulance</label><br />


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['mayreceiveailments'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="mayreceiveailments" value="mayreceiveailments" id="mayreceiveailments" />
          May receive minor medications for minor ailments</label><br />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['mayreceivemed'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="mayreceivemed" value="mayreceivemed" id="mayreceivemed" />
          Has no allergy to minor medications such as aspirin</label><br />


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['maynotreceivemed'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="maynotreceivemed" value="maynotreceivemed" id="maynotreceivemed" />
          May not receive minor medications</label><br />


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label>
          <input <?php if (!(strcmp($row_rsUpdate['allergictomed'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="allergictomed" value="allergictomed" id="allergictomed" />
          Is allergic to the following medications&nbsp;<input name="allergictext" type="text" class="underline" id="allergictext" style="width: 280px;" value="<?php echo $row_rsUpdate['allergictext']; ?>"></label><br /><br />
<br /><br />
<table align="left">
<tr align="left"><td><h1 style="font-size:23px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OFFICE USE ONLY</h1><br /></td><tr>
</table><br /><br /><br />
<br />



<table align="center">
   <td><label for="dateofentrance">DATE OF ENTANCE:</label><input name="dateofentrance" type="text" class="underline" id="dateofentrance" style="width: 232px;" value="<?php echo $row_rsUpdate['dateofentrance']; ?>"></td>
<td><label for="age">AGE YEARS-MONTHS</label><input name="age" type="text" class="underline" id="age" style="width: 232px;" value="<?php echo $row_rsUpdate['age']; ?>"></td></table>

<table align="center">
   <td><label for="course">COURSE:</label><input name="oourse" type="text" class="underline" id="course" style="width: 195px;" value="<?php echo $row_rsUpdate['course']; ?>"></td>
<td><label for="teacher1">TEACHER:</label><input name="teacher" type="text" class="underline" id="teacher" style="width: 195px;" value="<?php echo $row_rsUpdate['teacher']; ?>"></td><td><label for="date">DATE:</label><input name="date" type="text" class="underline" id="date" style="width: 195px;" value="<?php echo $row_rsUpdate['date']; ?>"></td></table><table align="center">
   <td><label for="course1">COURSE:</label><input name="course1" type="text" class="underline" id="course1" style="width: 195px;" value="<?php echo $row_rsUpdate['course1']; ?>"></td>
<td><label for="teacher1">TEACHER:</label><input name="teacher1" type="text" class="underline" id="teacher1" style="width: 195px;" value="<?php echo $row_rsUpdate['teacher1']; ?>"></td><td><label for="date">DATE:</label><input name="date1" type="text" class="underline" id="date1" style="width: 195px;" value="<?php echo $row_rsUpdate['date1']; ?>"></td></table>
<table align="center">
   <td><label for="course2">COURSE:</label><input name="course2" type="text" class="underline" id="course2" style="width: 195px;" value="<?php echo $row_rsUpdate['course2']; ?>"></td>
<td><label for="teacher2">TEACHER:</label><input name="teacher2" type="text" class="underline" id="teacher2" style="width: 195px;" value="<?php echo $row_rsUpdate['teacher2']; ?>"></td><td><label for="date2">DATE:</label><input name="date2" type="text" class="underline" id="date2" style="width: 195px;" value="<?php echo $row_rsUpdate['date2']; ?>"></td></table><br />

<table align="center"><td><input type="submit" name="submit" id="submit" value="SUBMIT" class="underline"/></td></table> 
<br />
</fieldset>
 <input name="id" type="hidden" id="id" value="<?php echo $row_rsUpdate['id']; ?>" />
 <input type="hidden" name="MM_update" value="form1" />
</form>
<table align="center"><td align="center">
<?php include("./_includes/footer.php"); ?>
</td>
    </table>

</body>
</html>
<?php
mysql_free_result($rsUpdate);
?>

Open in new window


Connection
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_totsandt_db = "localhost";
$database_totsandt_db = "totsandt_db";
$username_totsandt_db = "root";
$password_totsandt_db = "";
$totsandt_db = mysql_pconnect($hostname_totsandt_db, $username_totsandt_db, $password_totsandt_db) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Open in new window


database totsandt_db.sql
-- phpMyAdmin SQL Dump
-- version 3.4.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 24, 2013 at 12:13 PM
-- Server version: 5.1.65
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `totsandt_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `beginners`
--

CREATE TABLE IF NOT EXISTS `beginners` (
  `ID` int(4) NOT NULL AUTO_INCREMENT,
  `Name` varchar(30) DEFAULT NULL,
  `Date_of_Birth` varchar(10) DEFAULT NULL,
  `Entrance_into_Tots_and_Teens` varchar(10) DEFAULT NULL,
  `Date` varchar(10) DEFAULT NULL,
  `Teacher` varchar(30) DEFAULT NULL,
  `Oral_Expression` varchar(20) DEFAULT NULL,
  `Written_Expression` varchar(20) DEFAULT NULL,
  `Listening_Comprehension` varchar(20) DEFAULT NULL,
  `Reading_Comprehension_and_Skills` varchar(20) DEFAULT NULL,
  `Organizational_Skills` varchar(20) DEFAULT NULL,
  `Ability_to_work_independently` varchar(20) DEFAULT NULL,
  `Ability_to_work_in_a_group` varchar(20) DEFAULT NULL,
  `Respect_teachers_and_classmates` varchar(20) DEFAULT NULL,
  `Classroom_Behavior` varchar(20) DEFAULT NULL,
  `Effort_and_Determination` varchar(20) DEFAULT NULL,
  `Dependability` varchar(20) DEFAULT NULL,
  `Penmanship` varchar(20) DEFAULT NULL,
  `Grammar_Plus_1` varchar(20) DEFAULT NULL,
  `Grammar_is_Great_1_Grammar` varchar(20) DEFAULT NULL,
  `Super_Solvers_Reading Book` varchar(20) DEFAULT NULL,
  `Lights_Camera_Action_Reading_Book)` varchar(20) DEFAULT NULL,
  `Lights_Camera_Action_Workbook` varchar(20) DEFAULT NULL,
  `Word_Book_Grade_3_Vocab_and_Spelling_Book` varchar(20) DEFAULT NULL,
  `Once_Upon_a_Time_Reading_Book)` varchar(20) DEFAULT NULL,
  `The_Brothers_Grimm_Reading_Book` varchar(20) DEFAULT NULL,
  `Days_Absent` varchar(3) DEFAULT NULL,
  `Period` varchar(15) DEFAULT NULL,
  `Comments` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

--
-- Dumping data for table `beginners`
--

INSERT INTO `beginners` (`ID`, `Name`, `Date_of_Birth`, `Entrance_into_Tots_and_Teens`, `Date`, `Teacher`, `Oral_Expression`, `Written_Expression`, `Listening_Comprehension`, `Reading_Comprehension_and_Skills`, `Organizational_Skills`, `Ability_to_work_independently`, `Ability_to_work_in_a_group`, `Respect_teachers_and_classmates`, `Classroom_Behavior`, `Effort_and_Determination`, `Dependability`, `Penmanship`, `Grammar_Plus_1`, `Grammar_is_Great_1_Grammar`, `Super_Solvers_Reading Book`, `Lights_Camera_Action_Reading_Book)`, `Lights_Camera_Action_Workbook`, `Word_Book_Grade_3_Vocab_and_Spelling_Book`, `Once_Upon_a_Time_Reading_Book)`, `The_Brothers_Grimm_Reading_Book`, `Days_Absent`, `Period`, `Comments`) VALUES
(48, 'Lucas Banheti Zuffo', 'Insert dob', 'Insert ent', 'ok', 'Suzanne', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Very Good', 'Very Good', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', 'Not Applicable', '9', 'Afternoon', 'Insert Comments here'),
(47, 'Kanei Sasaki', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(46, 'Julia F. Machado Simao', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(45, 'Beatriz Alcantara', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(44, 'Arthur Rabelo', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(43, 'Arthur Di Croce Wohnrath', '', '', 'asd', 'Suzanne', '', '', '', '', '', '', '', '', '', '', 'Very Good', 'Very Good', '', '', '', '', '', '', '', '', '', 'Afternoon', 'asd'),
(42, 'Aoi Abe', '', '', 'asd', 'Suzanne', '', '', '', '', '', '', '', '', '', '', 'Good', 'Very Good', '', '', '', '', '', '', '', '', '', 'Afternoon', 'okasdjmoaso\r\n'),
(41, 'Stephanie Liu', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(40, 'Sophie Ou', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(39, 'Soo Bin Sung', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(38, 'Rikuto Sasaki', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AM/PM', ''),
(37, 'Min Jae (Brian) Back', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(36, 'Kenzo Yui', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(35, 'Julia Hung Yoshida', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(34, 'Isabelle Pardo', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(33, 'Fernanda Gorinchteyn', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(32, 'Fausto C. Pereira', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(31, 'Eric Jang', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(30, 'Eric Hsu', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(29, 'Deok Young (Daniel) Son', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'AM/PM', ''),
(28, 'Catherine F. Sona', '', '', '', 'Teacher', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(27, 'Beatriz Li Wen CHen', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Morning', ''),
(49, 'Maria Julia Bertussi Leonar', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(50, 'Rafael Fukushima', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(51, 'Raphael Pires', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', ''),
(52, 'Ricardo H. Landgraf Perez', '', '', '', 'Suzanne', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Afternoon', '');

-- --------------------------------------------------------

--
-- Table structure for table `kindergarten`
--

CREATE TABLE IF NOT EXISTS `kindergarten` (
  `ID` int(4) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `D.O.B` varchar(10) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `Entrance into T&T` varchar(10) NOT NULL,
  `Teacher` varchar(30) NOT NULL,
  `Has neat habits` varchar(3) NOT NULL,
  `Cooperates with classmates, shares and takes turns` varchar(3) NOT NULL,
  `Able to complete a given task independently` varchar(3) NOT NULL,
  `Follows directions` varchar(3) NOT NULL,
  `Expresses personal information` varchar(3) NOT NULL,
  `Respects classroom material` varchar(3) NOT NULL,
  `is courteous and cooperative with adults` varchar(3) NOT NULL,
  `Demonstrates appropiate self-discipline and concentration` varchar(3) NOT NULL,
  `Reads CVC words` varchar(3) NOT NULL,
  `Reads sight words` varchar(3) NOT NULL,
  `Recognizes: alike/different` varchar(3) NOT NULL,
  `Has concept of left to right` varchar(3) NOT NULL,
  `Has matching skills` varchar(3) NOT NULL,
  `Recognizes the following capital letters` varchar(3) NOT NULL,
  `Recognizes the following lowercase letters` varchar(3) NOT NULL,
  `Identifies shapes` varchar(3) NOT NULL,
  `Recognizes and reproduces patterns` varchar(3) NOT NULL,
  `Discriminates sizes` varchar(3) NOT NULL,
  `Recognizes numbers from 1 up to 9` varchar(3) NOT NULL,
  `Identifies sets of 1 up to 18` varchar(3) NOT NULL,
  `Roll counts up to 15` varchar(3) NOT NULL,
  `Is able to write name` varchar(3) NOT NULL,
  `Forms numbers correctly` varchar(3) NOT NULL,
  `Gross motor coodination` varchar(3) NOT NULL,
  `Fine motor skills` varchar(3) NOT NULL,
  `Penmanship/Neatness` varchar(3) NOT NULL,
  `Forms the following capital letters correctly` varchar(3) NOT NULL,
  `Forms the following lowercase letters correctly` varchar(3) NOT NULL,
  `Is fluent in English` varchar(3) NOT NULL,
  `Understands basic daily commands in English` varchar(3) NOT NULL,
  `Recites the alphabet` varchar(3) NOT NULL,
  `Identifies colors` varchar(3) NOT NULL,
  `Knows the days of the week` varchar(3) NOT NULL,
  `Knows the months of the year` varchar(3) NOT NULL,
  `Participates during story time` varchar(3) NOT NULL,
  `Names body parts` varchar(3) NOT NULL,
  `Identifies weather` varchar(3) NOT NULL,
  `identifies seasons` varchar(3) NOT NULL,
  `Knows the five senses` varchar(3) NOT NULL,
  `Names Animals` varchar(3) NOT NULL,
  `Days Absent` varchar(3) NOT NULL,
  `Comments` varchar(400) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `nursery`
--

CREATE TABLE IF NOT EXISTS `nursery` (
  `Id` int(4) NOT NULL,
  `Name` varchar(40) NOT NULL,
  `D.O.B` varchar(10) NOT NULL,
  `Entrance into T&T` varchar(10) NOT NULL,
  `Teacher` varchar(40) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `I enjoy work and play` varchar(3) NOT NULL,
  `I work and play well with others` varchar(3) NOT NULL,
  `I wait my turn` varchar(3) NOT NULL,
  `I listen while others speak` varchar(3) NOT NULL,
  `I respect the rights of others/I know how to obey` varchar(3) NOT NULL,
  `I take care of school materials and put them away` varchar(3) NOT NULL,
  `I participate during storytime` varchar(3) NOT NULL,
  `I understand when my teacher speaks English to me` varchar(3) NOT NULL,
  `I can ask and answer questions in English` varchar(3) NOT NULL,
  `I can name foods` varchar(3) NOT NULL,
  `I can name animals` varchar(3) NOT NULL,
  `I can name items o clothing` varchar(3) NOT NULL,
  `I know my opposites` varchar(3) NOT NULL,
  `I can count up to 11` varchar(3) NOT NULL,
  `I know the days of the week` varchar(3) NOT NULL,
  `I indetify weather` varchar(3) NOT NULL,
  `I can name body parts` varchar(3) NOT NULL,
  `I recognize the following letterland characters` varchar(3) NOT NULL,
  `I indetify sounds of the following letterland characters` varchar(3) NOT NULL,
  `I know the following numbers` varchar(3) NOT NULL,
  `I know the following colors` varchar(3) NOT NULL,
  `I know the following shapes` varchar(3) NOT NULL,
  `I can run` varchar(3) NOT NULL,
  `I can kick` varchar(3) NOT NULL,
  `I can jump` varchar(3) NOT NULL,
  `I can cut` varchar(3) NOT NULL,
  `I can paste` varchar(3) NOT NULL,
  `I can color within a shape` varchar(3) NOT NULL,
  `I like music` varchar(3) NOT NULL,
  `I enjoy singing` varchar(3) NOT NULL,
  `I take part in all musical activities` varchar(3) NOT NULL,
  `I respond to rhythms` varchar(3) NOT NULL,
  `I use art materials correctly` varchar(3) NOT NULL,
  `I listen to and follow directions` varchar(3) NOT NULL,
  `I work carefully and neatly` varchar(3) NOT NULL,
  `I eat well and quietly` varchar(3) NOT NULL,
  `I keep reasonably neat and clean` varchar(3) NOT NULL,
  `Comments` varchar(400) NOT NULL,
  `Extra1` varchar(3) NOT NULL,
  `Extra2` varchar(3) NOT NULL,
  `Extra3` varchar(3) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `parents`
--

CREATE TABLE IF NOT EXISTS `parents` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `student` varchar(50) DEFAULT NULL,
  `sex` varchar(1) DEFAULT NULL,
  `dateofbirth` varchar(10) DEFAULT NULL,
  `placeofbirth` varchar(50) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  `cep` varchar(9) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `lastschool` varchar(50) DEFAULT NULL,
  `gradecompleted` varchar(5) DEFAULT NULL,
  `referredby` varchar(20) DEFAULT NULL,
  `schooltoattend` varchar(50) DEFAULT NULL,
  `mothersname` varchar(50) DEFAULT NULL,
  `mothersbusiness` varchar(50) DEFAULT NULL,
  `motherstitle` varchar(20) DEFAULT NULL,
  `mothersbusinessaddress` varchar(50) DEFAULT NULL,
  `motherscep` varchar(8) DEFAULT NULL,
  `motherstel` varchar(16) DEFAULT NULL,
  `mothersfax` varchar(16) DEFAULT NULL,
  `motherscel` varchar(16) DEFAULT NULL,
  `motherscpf` varchar(12) DEFAULT NULL,
  `mothersrg` varchar(12) DEFAULT NULL,
  `fathersname` varchar(50) DEFAULT NULL,
  `fathersbusiness` varchar(50) DEFAULT NULL,
  `fatherstitle` varchar(50) DEFAULT NULL,
  `fathersbusinessaddress` varchar(50) DEFAULT NULL,
  `fatherscep` varchar(12) DEFAULT NULL,
  `fatherstel` varchar(16) DEFAULT NULL,
  `fathersfax` varchar(16) DEFAULT NULL,
  `fatherscel` varchar(16) DEFAULT NULL,
  `fatherscpf` varchar(16) DEFAULT NULL,
  `fathersrg` varchar(16) DEFAULT NULL,
  `dateofentrance` varchar(9) DEFAULT NULL,
  `age` varchar(50) DEFAULT NULL,
  `course` varchar(5) DEFAULT NULL,
  `teacher` varchar(10) DEFAULT NULL,
  `date` varchar(50) DEFAULT NULL,
  `course1` varchar(50) DEFAULT NULL,
  `teacher1` varchar(50) DEFAULT NULL,
  `date1` varchar(50) DEFAULT NULL,
  `course2` varchar(50) DEFAULT NULL,
  `teacher2` varchar(50) DEFAULT NULL,
  `date2` varchar(50) DEFAULT NULL,
  `sibling` varchar(100) DEFAULT NULL,
  `familyphysician` varchar(20) DEFAULT NULL,
  `familyphysiciantel` varchar(9) DEFAULT NULL,
  `medicalplan` varchar(20) DEFAULT NULL,
  `medicalplantel` varchar(9) DEFAULT NULL,
  `hospital` varchar(20) DEFAULT NULL,
  `hospitaltel` varchar(9) DEFAULT NULL,
  `allergies` varchar(50) DEFAULT NULL,
  `asthma` varchar(3) DEFAULT NULL,
  `diabetes` varchar(3) DEFAULT NULL,
  `surgery` varchar(50) DEFAULT NULL,
  `obs` varchar(200) DEFAULT NULL,
  `maybetakenabove` varchar(50) DEFAULT NULL,
  `maybetakennearest` varchar(50) DEFAULT NULL,
  `shouldbetakenambulance` varchar(50) DEFAULT NULL,
  `mayreceiveailments` varchar(50) DEFAULT NULL,
  `mayreceivemed` varchar(50) DEFAULT NULL,
  `maynotreceivemed` varchar(50) DEFAULT NULL,
  `allergictomed` varchar(50) DEFAULT NULL,
  `allergictext` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;

--
-- Dumping data for table `parents`
--

INSERT INTO `parents` (`id`, `student`, `sex`, `dateofbirth`, `placeofbirth`, `address`, `cep`, `tel`, `email`, `lastschool`, `gradecompleted`, `referredby`, `schooltoattend`, `mothersname`, `mothersbusiness`, `motherstitle`, `mothersbusinessaddress`, `motherscep`, `motherstel`, `mothersfax`, `motherscel`, `motherscpf`, `mothersrg`, `fathersname`, `fathersbusiness`, `fatherstitle`, `fathersbusinessaddress`, `fatherscep`, `fatherstel`, `fathersfax`, `fatherscel`, `fatherscpf`, `fathersrg`, `dateofentrance`, `age`, `course`, `teacher`, `date`, `course1`, `teacher1`, `date1`, `course2`, `teacher2`, `date2`, `sibling`, `familyphysician`, `familyphysiciantel`, `medicalplan`, `medicalplantel`, `hospital`, `hospitaltel`, `allergies`, `asthma`, `diabetes`, `surgery`, `obs`, `maybetakenabove`, `maybetakennearest`, `shouldbetakenambulance`, `mayreceiveailments`, `mayreceivemed`, `maynotreceivemed`, `allergictomed`, `allergictext`) VALUES
(112, 'Amalia Simkieuich Dasilva', 'F', '07-05-2008', 'Argentina', 'R Madre Rita Amada De Jesus 72 apt 52b', '04750-021', '23375598', 'beatriz.dasilvacomara@gmail.com', 'Fadelito', 'na', 'Colegio Paca', 'Paca', 'Beatriz Camara Dasilva', 'na', 'na', 'na', 'na', 'na', 'na', '96348218', '356407688-35', '38.854.593-8', 'Alejandro Simkieuich', 'Consultoria em Sistemas', 'na', 'na', 'na', 'na', 'na', '96346673', 'na', 'na', '01-10-201', '', 'Pre-K', 'Monica', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'na', 'na', 'Amil Blue 600 Nacion', 'na', 'Santa Paulo', 'na', 'na', 'Yes', 'na', '', '', '', '', '', '', '', '', '', ''),
(113, 'Lester Andre Chiong Ayllon', 'M', '19-08-2008', 'Sao Paulo', 'Porf Manoelito de Ornelas 130- ap 83', '04719-040', '984742194', 'elianakarin@hotmail.com', 'Casrelinho', 'K-1', 'Paca(Kevin)', 'Paca', 'Eliana Hurtado Chiong', 'Indra Company', 'Consultant', 'Alexander Dumas 2200', 'na', '31546010', 'na', '984742194', '232-722-298-', 'V494293-G', 'Lester Guillermo Cavero Ayllon', 'Fico', 'Consultant', 'Rua Professor Manoelito Ornellas, 130', '04719 040', 'na', 'na', '9874578886', '232.327.878 - 94', '25743932', '19-09-201', '', 'Pre-K', 'Monica', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'na', 'na', 'Unibanco Master/Brad', 'na', 'Albert Einstein', 'na', 'na', 'na', 'na', '', '', '', '', '', '', '', '', '', ''),
(111, 'Aoi Abe', 'F', '06/08/2002', 'Japan', 'Al.Campinas,701.ap 61W,Jardin Paulista,Sao.', '01404-001', '3297-4836', 'N/A', 'Sociedade Japonesa de Educacao e Cultura', '3rd', 'word.nethall.com.br/', 'St. Nicholas', 'Megumi Abe', 'Housewife', 'N/A', 'N/A', 'NA', '3297-4836', 'N/A', '9891-0974', '234.873.008-', 'V744876-1', 'Eitaro Abe', 'Daicolor do Brasil', 'Diretor', 'Av.Piramide,692JD.Inamar,Diadema,Sao Paulo', '09970-330', '4059-7721-R.7118', '4059-7728', '9658-7640', '234;716.018-48', 'V728524-0', '18-Sept-2', '', 'Beg', 'Suzanne', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'Dra.Lidia Mine', '3274-6500', 'N/A', 'N/A', 'Beneficencia Nipo-Br', '32746500', 'N/A', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(114, 'Amanda Jhays Ferreira Mendes Lopes', 'F', '24-09-03', 'Sao Paulo', 'Rua George Williams, 99- Santo Amaro', '04741-180', '29358977', 'lopesfcarla@hotmail.com', 'Santa Maria', '3', 'na', 'na', 'Carla Lopes Ferreira', 'na', 'na', 'na', 'na', 'na', 'na', '75689616', '087.494.088-', '17.196.372', 'Carlos Jose M. Campos Lopes', 'Consultor Nendas. Autonomo', 'na', 'na', 'na', 'na', 'na', '99859977', '082.777.718-35', 'W675839-K', '01-08-201', '', 'Trans', 'Ligia(morn', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'Dra.Silvana Martines', 'na', 'Sul Amedica', 'na', 'Sao Luiz-Morumbi', 'na', 'Mosquito Bite', 'na', 'na', '', '', '', '', '', '', '', '', '', ''),
(115, 'Arthus Di Croce Wohnrath', 'M', '28-09-2002', 'Sao Paulo', 'Rua Verbo Divino, 1061 Torre S Apto 82', '04719-002', '5189-9191', 'patricia@mrcomputer.com.br', 'Pueri Domus', '5th', 'Colegio Pueri Domus', 'Global Ed.', 'Patricia Di Croce Wohnrath', 'Mr.Computer Inf. Lida', 'Socia-proprietaria', 'Rua Alexandre Dumas 2100', '04717-00', '5189-9191', 'na', '8426-4803', '148.984.838-', '20.146.923-6', 'Mauri Abud Wohnrath', 'Mr Computer Inf Lida', 'Socio-proprietario', 'Rua Alexandre Dumas 2100 162', '04717-004', '5189-9191', 'na', '8426-4830', 'na', 'na', '01-02-12', '', 'Beg', 'Suzanne', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'Dr Rogerio P. Fonsec', '5051-0092', 'Bradesco-TOP', 'na', 'Osvaldo Cru', 'na', 'na', 'na', 'na', '', '', '', '', '', '', '', '', '', ''),
(116, 'Allana Kayla Disurno Brasil', 'F', '12-05-07', 'Sao Paulo', 'Rua Cineasta Alberto Cavalcante, 158', '05396075', '82338818', 'prof.harleybrasil@gmail.com', 'NA', 'NA', 'NA', 'NA', 'Ana Yemina Pisurno', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'Harley Furtado Brasil', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '1-02-12', '', 'Pre-K', 'Monica', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(117, 'AKI OKAI', 'M', '08-10-08', 'Japão', 'Rua Mario Amaral 81 apt 51 Paraiso ', '04002020', '97203-1984', 'j.okai@.br.fujitsu.com ', 'Sayuri Preschool', 'NA', 'Kunijuki Suzuki ', 'PACA, GRADED,CHAPEL ', 'MARCI ANNE XIONG', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'JUNGO OKAI', 'FUJITSU DO BRASIL LTDA', 'BUSINESS CONSULTANT', 'TREZE DE MAIO,1633 1°AND EDIFICIO FUJITSU', '01327905', '3265-0704', 'NA', '97203-1984', '235445798-71', 'V832147-8', '17-09-12', '', 'PRE-K', 'MONICA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'NA', 'NA', 'CNPNATE MEDIAL PLAA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(118, 'ALEXANDER HOPE NORTEY', 'M', '15-12-04', 'LUSAKA', 'RUA ARAGUARI 287 APT 91 MOEMA ', '04514040', '+4799879333', 'tryggve.arveschoug@.conax.com.br', 'TRELLEBORG', '2', 'ST.NICHOLAS ', 'ST. NICHOLAS', 'CATHERINE GONDWE ARVESCHOUG', 'NA', 'NA', 'NA', 'NA', '+4799879333', 'NA', 'NA', 'NA', 'NA', 'TRYGGVE ARVESCHOUG', 'CONAX AS', 'SALES MGR', 'MAESTRO CARDIM 1293', 'NA', '+479584689', 'NA', 'NA', 'NA', 'NA', '24-05-12', '', 'T1', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(119, 'ALVIN CHOU', 'M', '07-06-08', 'BRASIL', 'RUA AL.DOS AICAS', '04086001', '5051-0475', 'feulnousepresentesmimi@hotmail.com', 'frist step', 'na', 'KEVEM DO PACA ', 'PACA', 'LEIR YI', 'FEULTEOUSE', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '03-08-11', '', 'PRE-K', 'MONICA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DR.ROSELI', '3884-9988', 'SUL AMERICA ', 'NA', 'INSTITUTO DE PEDIATR', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(120, 'ANNA SOPHIA STOCKLER M''CULLEJ', 'F', '21-10-08', 'RALEIGH,NORTH CAROLINA', 'RUA BENEDITO,873 AP 222 SANTO AMARO ', '04735002', '5523-3178', 'mari.mcaillaj@gmail.com', 'monica''s school', 'NA', 'NA', 'NA', 'MARIANA S.M''CULLAJ', 'COLÉGIO STUEKTER ', 'PARTNER', 'AV.VEREADOR JOSÉ DINEZ,2603', 'NA', '5533-3750', 'NA', '7655-4226', '220325628-12', '45077353', 'MICHAEL ADAM M''CULLAJ', 'VIRIZON TELECOMMUNICATIONS', 'NETCUORK ENGINUR', 'NA', 'NA', 'NA', 'NA', '981601382', 'NA', 'NA', '26-01-11', '', 'PRE-K', 'TOYLA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DRA.IRENE MIURA', '3171-1171', 'OMINT', 'NA', 'EITEIN', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(121, 'ANA JULIA BRUGOS', 'F', '07-11-05', 'RECIFE', 'AV.INTERLAGOS 492 AP121 BL01 CAMPO GRANDE', '04660-000', '3637-4142', 'anafabricia@hotmail.com', 'NA', 'NA', 'MAGISTER  SCHOOL', 'PACA', 'ANA FABRICIA BRUGOS', 'NA', 'NA', 'NA', 'NA', '2848-6611', 'NA', '8367-4040', '962601060-68', '1061654842', 'JULIO MARCEZ BRUGOS', 'UNILEVER', 'PROJECT MENEGER', 'AV.NAÇÕES UNIDAS 14171', '04795100', '2505-4065', 'NA', '8198-4040', '911731910-20', '4066409212', '03-08-11', '', 'KIND', 'ANGELA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DRA.AMRCIA GUERRA RI', '8297-7377', 'UNIMED SUPREMO ', 'NA', 'NA', 'NA', 'CLAVULIM-CLAVULANATO MEDICAMENTO', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(122, 'ARTHUR DE CARVALHO RABELO ', 'M', '07-06-02', 'SÃO PAULO', 'RUA JOÃO DE SOUSA DIAS,515 AP 91 CAMPO BELO ', '04618003', '3539-6992', 'valesskacarvalho@hotmail.com', 'CULTURA INGLESA', 'T3', 'SRA.GLEICE ST.FRANCI', 'ST.FRANCIS', 'VALESCA CARVALHO RABELO ', 'NA', 'NA', 'NA', 'NA', '35396992', 'NA', '9433-2184', '643529271-04', '19797822', 'ROGERIO RABELO ', 'FLGURY', 'DIRETOR EXECUTIVO ', 'AV GEN VALDOMIRO DE LIMA ,508', '04344903', '50147637', 'NA', '92930105', '383193811-34', '1667950', '01-02-12', '', 'T1', 'LIGIA ', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DRA.LUCIA HARUMIGOSH', '30835497', 'SUL AMERICA EXECUTIV', '37595600', 'ALBERT EINSTEIN', 'NA', 'ALEGICO A PROTETOR SOLAR', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(123, 'BEATRIZ LEE', 'F', '22-04-09', 'SÃO PAULO', 'RUA CONSTATINO DE SOUSA 1706', '043605004', '2362-2214', 'solangebae@hotmail.com.br', 'NA', 'NA', 'NA', 'NA', 'SOLANGE B.LEE', 'LITLLE ME ARTIGOS', 'SOCIA DIRETORA ', 'NA', 'NA', 'NA', 'NA', '8593-3358', '284318888-14', 'W081094-Q', 'SEUNG  HYUN LEE', 'SYMNETICS', 'SOCIO GERENTE ', 'NA', 'NA', 'NA', 'NA', '9368-4783', '148078688-88', 'W081094-Q', '01-02-12', '', 'NURSE', 'LUCY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DR.CRISTIAN DORNHAUS', '5538-0099', 'SUL AMERICA ', 'NA ', 'SÃO LUIZ MORUMBI ', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(124, 'BIANCA CALLEGARIO RIBEIRO ', 'F', '02-02-11', 'SÃO PAULO', 'RUA FROREAL COSTA PIMENTA ,24 SANTO AMARO ', '04772-208', '8158-7797', 'FERNANDO@PSU.EDU', 'ELVIRA BRANDAO', 'NURSE', 'MARIA FALCONY', 'NA', 'HELOISA CALLEGARO', 'MCKINSEY', 'ASSOCIATED PRINCIPAL', 'ALEXANDRE DUMAS ,1111', 'NA', 'NA', 'NA', '9628-7921', '2705337898', '195121430', 'FERNANDO MORAIS RIBERO ', 'PHERCOH COACHING&HUMAN DEV', 'OWNE', 'NA', 'NA', 'NA', 'NA', '81587797', '03647332682', '8903886', '01-08-12', '', 'NURSE', 'LUCY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'ROGERIO PEREIRA FONS', '+55119930', 'CIGNA INTERNATIONAL', 'NA', 'ALBERT EINSTEIN /SIR', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(125, 'BRUNA EVANGELHO NORBERTO', 'F', '11-11-97', 'SãO PAULO', 'PROJENOR ALCEU MAYNARD ARAUJO,443  APT 163 ST ARO', '04726-160', '7780-2009', 'marciaevangelho@gmail.com', 'VERTICE', '9 SÉR', 'KAREN  PURI DONUS', 'NA', 'MARCIA M.E. NORBERTO RODRIGUES', 'AG.MARIA MARIA ', 'PUBLICITÁRIA', 'R.MANOEL BORBA,257', 'NA', '2769-1544', 'NA', '7780-0209', '028203457-94', '39100967', 'MARCOS NORBERTO RODRIGUES', 'NORBEVAS', 'ADVOGADO', 'JUIZ DE FORA ', 'NA', '2769-1544', 'NA', '8173-5600', '888196477-53', '072288622-9', '01-03-12', '', 'TEEES', 'HARLEY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DEIRVAL', '5090-0100', 'BRADESCO', 'NA', 'STA CATARINA', 'NA', 'AMOXICILINA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(126, 'BIANCA DE VASCONCELLOS LUZ', 'F', '31-01-11', 'SãO PAULO', 'R.CASA BRANCA 714,APT 72', '01408-000', '8147-0089', 'andressa@saitphjlippe.com.br', 'NA', 'NA', 'ISABELLA PEDROSO', 'NA', 'ANDRESSA DE FARIA VASCONCELLOS', 'SAINT PHYLIPPE ', 'SÓCIA DIRETORA', 'R. VISCONDE DE CASTRO, 261 CAMPO BELO ', '', '2533-3210', '7515-5783', '8147-0089', '128649938-05', '22834392-6', 'DR.MARCIUS MATTOS RIBEIRO LUZ', 'CONSULTÓRIO DE ACUMPUNTURA ', 'DOUTOR', 'R.ESTEVãO  LOPES,103', 'NA', '3821-5155', 'NA', '9628-0303', '895620548-53', '4461738', '01-08-12', '', 'NURSE', 'LUCY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DR.JOCY PRADO', '5051-8147', 'OMINT', 'NA', 'ALBERT EISTEIN', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(127, 'BEATRIZ DUARTE ALCâNTARA', 'F', '28-07-02', 'SãO PAULO', 'R.DAVID EID 1907,BL12 AP 31', '04438-000', '6393-4672', 'dsouza@billabong.com.br', 'PUERI DOMUS', '4 ANO', 'PUERI DOMUS', 'GLOBAL.ED', ' DAIELA DUARTE DE SOUZA', 'ESM BRASIL ', 'SECRETARIA EXECUTIVA', 'R.NATIVIDADE 139', '04513-02', 'NA', 'NA', '6393-4672	', '289217438-47', '23197500-4', 'CARLOS HENRIQUE SILVA ALCANTARA', 'ALIANSCE', 'SUPERINTENDENTE', 'NA', 'NA', 'NA', 'NA', '8403-2337', '250454808-71', '25547754', '01-02-12', '', 'TRANS', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'NA', 'NA', 'ALLINZ/TEMPO SAUDE', 'NA', 'EINSTEN /SãO LUIZ', 'NA', 'PICADA DE INSETO/MEDICACAO NISULID', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(128, 'BEATRIZ LI WEN CHE', 'F', '20-11-99', 'SãO PAULO', 'R.FRACA PINTO 700,AP 61 ', '04016-003', '5539-0328', 'betlig@hotmail.com', 'COLEGIO BANDEIRANTES ', '6 ANO', 'NA', 'NA', 'BETH LIGIA HUANG', 'WINIKE COM ROUPAS ', 'SOCIA GERENTE', 'R CEL OSCARPONTO,619', '04003-00', '3051-3184', 'NA', '9486-6316', '008735747-02', '08035418-6', 'CHEN CHIH HUNG', 'TYOO DECORACOES LTDA', 'SOCIO GERENTE', 'R.RAGEL PESTANA 1578', '03002-000', '3313-0039', 'NA', '7891-3665', '085678298-01', '12333866', '08-08-11', '', 'BEG', 'SUZANNE', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DRA.IRENA MIURA', '8369-7031', 'SULAMERICA ESPECIAL', 'NA', 'SãO LUIZ', 'NA', 'POEIRA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(129, 'CRISTINA RUO HAN WANG', 'F', '30-08-04', 'SãO PAULO', 'AV.CASIMIRODA ROCHA,1257APT 84-A SAUDE', '04047-003', '5584-9279', 'viviane.lin@hotmail.com', 'ETAPA', '2', 'NA', 'NA', 'LIN QIRO JUNH ( ANGELA) ', 'SANXIA COMECIAL LDTA', 'SECRETARIA', 'R NOSSA SENHORA DAS MECES ,600', '04165-01', '2083-2333', '2083-2333', '9852-5585', '218382998-25', 'Y271838-H', 'WANG ', 'SANXIA COMECIAL LDTA', 'GERENTE DE DEPOSITO', 'R NOSSA SENHORA DAS MECES ,600', '04165-010', '2083-2333', '2083-2333', '7727-1815', '228449798-58', 'V331238-8', '14-02-12', '', 'TRANS', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DR.JACK YUNH KHO', '5052-0884', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', 'NA', '', '', '', '', '', '', '', '', '', ''),
(130, 'CHIARA LIANE SAER', 'F', '26-08-08', 'RIO DE JANEIRO', 'R.DIREITA 696', '06708-280', '7709-1413', 'juan_saer@libeleladistribuidora.com.br', 'N/A', 'N/A', 'N/A', 'N/A', 'ANGELA WJSOCKI SAER', 'TOTSTEENS', 'NA', 'R.CONDE DE ITU 597', 'NA', '6299-1134', 'NA', 'NA', '061369277-21', 'V484604-V', 'JUAN CARLOS SAER', 'LIBELULADA DISTRIBUIDORAS DE FRIOS ', 'QUINER', 'R.DIREITO 696', '06708-280', '4612-6024', 'N/A', '7709-1413', '00805605550', '12008045', 'NA', '', 'NURSE', 'LUCY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(131, 'CATHERINE SONDA FARINE', 'F', '07-05-02', 'PORTO ALEGRE R.S', 'R.FEITOI ,469 AP 221 VILA MARIANA ', '04007-002', '3052-1829', 'claudia.sonda@mastersonda.com.br', 'RED BALLAON', 'N/A', 'LEILA', 'N/A', 'CLAUDIA SONDA', 'MASTERATS SUPERMECADOSLTDA', 'DIRETORA COMECIAL', 'FREI CANECA 569', 'N/A', '3472-2200', 'N/A', '9124-1133', '56573430000', '1028517835', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(132, 'DEOK YOUNG SON', 'M', '26-09-03', 'KOREIA ', 'R.DR.JOÃO FERRAZ 59,BELEMZINHO ', '03059-040', '984180394 ', 'hongn.son@sansung.com', 'muwon primar', '3', 'N/A', 'GRADED', 'MIYEON HA ', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'HONGSOON SON', 'IT SDLA', 'IT MANAGER', 'AV. DAS NAÇÃOES  UNIDAS 12901 ANDA 22', '04518000', '55-11-984180394', '56442111', '984180394', '23548151825', 'N/A', '01-08-12', '', 'T1', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(133, 'DANIEL YOSHIHISA FUKUSHIMA ', 'M', '23-04-05', 'SÃO PAULO', 'R. PITANGUEIRA ,228 AP 21 SAUDE', '04052-020', '5581-9034', 'daniela@jacima.com.br ', 'CE PLONEIRO', 'MARTE', 'CHAPEL', 'CHAPEL', 'DANIELA N. IUKUSHIMA', 'YACIMA AT ROUPAS LTDA', 'DIRETORA', 'R.MENDES JUNIOR 148 /160', '03013-01', '2797-9426', 'N/A', '7337-7226', '177897278-00', '118002661', 'EDSON KYOTA FUKUSHIMA', 'YACIMA AT ROUPAS LTDA', 'DIRETORA', 'R.MENDES JUNIOR 148 /160', '03013-010', '2797-9426', 'N/A', '7337-7225', '263394938-07', '8111374', '6-5-08', '', 'KIND', 'VANESSA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'LUCIA HARUMI GOSHI', '38849507', 'SULAMERICA SEGUROS', 'n/a', 'ALBERT EINSTEIN', 'N/A', 'N/', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(134, 'AMANDA THAYS MENDES LOPES', 'F', '24-09-03', 'SÃO PAULO', 'R.GEOGE WILLIANS,99 SANTO AMARO ', '04741-180', '2935-8977', 'LOPESFCARLA@HOTMAIL.COM', 'SANTA MARIA ', '3 ANO', 'N/A', 'N/A', 'CARLA LOPES FERREIRA ', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '97568-9616', '087494088-52', '17196372', 'CARLOS JOSE M.CAMPOS LOPES', 'CONSULTOR DE VENDA  AUTONIMO', 'N/A', 'N/A', 'N/A', '9985-997', 'N/A', 'N/A', '082777718-35', 'W675839-K', '01-08-12', '', 'TRANS', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'DRA . SILVANA MARTIN', 'N/A', 'SUL AMERICA', 'N/A', 'SÃO LUIZ MORUMBI ', 'N/A', 'PICADA DE   INSETOR', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(135, 'MIN SEO JEONG (ANGN/AELINA)', 'F', '12-02-07', 'MOKPO,SOUTH KOREA ', 'R.MARECHAL HASTIMPHILO DE MOURA,338,G 6B', '05641-000', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'HWA JUNG,IM', 'NA', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'CHAN OK ,JEONG', 'EUKOP CAR CARRIERS', 'G.MANAGER', 'R.JOAQUIM FLORIANO ,N72,CONJUNTO 121/122', '04534-000', '3074-2504', 'N/A', '97454-2220', '235524398-03', 'N/A', 'N/A', '', 'N/A', 'N/A', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'EVELINA CAMPOS', '98283-413', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(136, 'MINJAE BACK (BRIAN)', 'M', '16-11-99', 'SEOUL KOREA', 'AV.MIRUNA ,320', '04084-001', 'N/A', 'kaul99.back@gmail.com', 'wonmok middle school', 'N/A', 'N/A', 'CHAPEL/PACA', 'JIYOUNG JUNG', 'HOUSE WIFE', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '95025-6471', 'N/A', 'V85994N-3', 'BONGGI BACK', 'IT CORDINATOR ', 'SR.MANAGER', 'N/A', 'N/A', 'N/A', 'N/A', '9828-70013', '235610948-74', 'V859892-2', '06-11-12', '', 'TEENS', 'HARLEY', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(137, 'ROUHUA DOU (BEATRIZ)', 'F', '19-10-04', 'CHINA', 'R. ALVARADA 1244 AP.21', '04550-004', '9689-2466', 'lucasxiad@yahoo.com.br', 'CHINA', '2', 'CHAPEL', 'CHAPEL', 'YUHONG WANG ', 'COLEGIO DE SAO BENTO ', 'PROFESSORA', 'LARGO SAO BENTO S/N CENTRO', '01029-01', '3328-8799', '3328-8797', '9689-2466', '235602628-28', 'V828430-Q', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', '02-08-12', '', 'T1', 'LIGIA', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'N/A', 'N/A', 'SUL AMERICA ', 'N/A', 'N/A', 'N/A', 'ANTI-BOTICO', 'N/A', 'N/A', '', '', '', '', '', '', '', '', '', ''),
(138, 'asd', 'a', 'f', 'f', 'g', 'f', 'f', 'f', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', '', 'g', 'g', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', '', '', '', '', '', '', '', '', '', ''),
(139, 'asd', 'F', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', '', 'f', 'f', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', 'f', '', '', '', '', '', '', '', '', '', ''),
(140, NULL, 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '');

-- --------------------------------------------------------

--
-- Table structure for table `pre k`
--

CREATE TABLE IF NOT EXISTS `pre k` (
  `ID` int(4) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `D.O.B` varchar(10) NOT NULL,
  `Entrance into T&T` varchar(10) NOT NULL,
  `Teacher` varchar(30) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `I enjoy work and play` varchar(3) NOT NULL,
  `I work and play well with others` varchar(3) NOT NULL,
  `I wait my turn` varchar(3) NOT NULL,
  `I listen while others speak` varchar(3) NOT NULL,
  `I respect the rights of others/I know how to obey` varchar(3) NOT NULL,
  `I take care of school materials and put them away` varchar(3) NOT NULL,
  `I participate during story time` varchar(3) NOT NULL,
  `I understand when my teacher speaks English to me` varchar(3) NOT NULL,
  `I can ask and answer questions in English` varchar(3) NOT NULL,
  `I can name foods` varchar(3) NOT NULL,
  `I can name animals` varchar(3) NOT NULL,
  `I can name items of clothing` varchar(3) NOT NULL,
  `I know my opposites` varchar(3) NOT NULL,
  `I can count to 11` varchar(3) NOT NULL,
  `I know the days of the week` varchar(3) NOT NULL,
  `I indentify weather` varchar(3) NOT NULL,
  `I can name body parts` varchar(3) NOT NULL,
  `I recognize the following capital letters` varchar(3) NOT NULL,
  `I recognize the following lowercase letters` varchar(3) NOT NULL,
  `I identify Sounds of the following letters` varchar(3) NOT NULL,
  `I know the following numbers` varchar(3) NOT NULL,
  `I know the following colors` varchar(3) NOT NULL,
  `I know the following shapes` varchar(3) NOT NULL,
  `I can cut` varchar(3) NOT NULL,
  `I can paste` varchar(3) NOT NULL,
  `I can color within a shape` varchar(3) NOT NULL,
  `I can trace numbers and letters` varchar(3) NOT NULL,
  `I can trace my name` varchar(3) NOT NULL,
  `Penmanship/Neatness` varchar(3) NOT NULL,
  `I like music` varchar(3) NOT NULL,
  `I enjoy singing` varchar(3) NOT NULL,
  `I take part in all musical activities` varchar(3) NOT NULL,
  `I respond to rhythms` varchar(3) NOT NULL,
  `I use art materials correctly` varchar(3) NOT NULL,
  `I listen to and follow directions` varchar(3) NOT NULL,
  `I work carefully and neatly` varchar(3) NOT NULL,
  `I eat well and quietly` varchar(3) NOT NULL,
  `I keep reasonably neat and clean` varchar(3) NOT NULL,
  `Days absent` varchar(3) NOT NULL,
  `Comments` varchar(400) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `teachers`
--

CREATE TABLE IF NOT EXISTS `teachers` (
  `Teachersid` int(4) NOT NULL AUTO_INCREMENT,
  `Username` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  PRIMARY KEY (`Teachersid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`Teachersid`, `Username`, `Password`) VALUES
(1, 'Suzanne', 'Mejia'),
(2, 'Drandall', '55482828');

-- --------------------------------------------------------

--
-- Table structure for table `teens`
--

CREATE TABLE IF NOT EXISTS `teens` (
  `ID` int(4) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `D.O.B` varchar(10) NOT NULL,
  `Entrance into T&T` varchar(10) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `Teacher` varchar(30) NOT NULL,
  `Oral Expression` varchar(3) NOT NULL,
  `Written Expression` varchar(3) NOT NULL,
  `Listening Comprehension` varchar(3) NOT NULL,
  `Reading Comprehension and Sills` varchar(3) NOT NULL,
  `Organizational Skills` varchar(3) NOT NULL,
  `Ability to work independently` varchar(3) NOT NULL,
  `Ability to work in a group` varchar(3) NOT NULL,
  `Respect teachers and classmates` varchar(3) NOT NULL,
  `Classroom Behavior` varchar(3) NOT NULL,
  `Effot/Determination` varchar(3) NOT NULL,
  `Dependability` varchar(3) NOT NULL,
  `Penmanship` varchar(3) NOT NULL,
  `Blueprint One Students Book` varchar(3) NOT NULL,
  `Blueprint One Workbook` varchar(3) NOT NULL,
  `Grammar Two` varchar(3) NOT NULL,
  `Spelling and Vocabulary 4` varchar(3) NOT NULL,
  `Swiss Family Robinson(Reading)` varchar(3) NOT NULL,
  `Tom Sawyer(Reading)` varchar(3) NOT NULL,
  `What Shall I Write(Composition)` varchar(3) NOT NULL,
  `Days Absent` varchar(3) NOT NULL,
  `Comments` varchar(3) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `transition 1`
--

CREATE TABLE IF NOT EXISTS `transition 1` (
  `ID` int(4) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `D.O.B` varchar(10) NOT NULL,
  `Entrance into T&T` varchar(10) NOT NULL,
  `Date` varchar(10) NOT NULL,
  `Teacher` varchar(30) NOT NULL,
  `Oral Expression` varchar(3) NOT NULL,
  `Written Expression` varchar(3) NOT NULL,
  `Listening Comprehension` varchar(3) NOT NULL,
  `Reading Comprehension and Skills` varchar(3) NOT NULL,
  `Organizaitional Skills` varchar(3) NOT NULL,
  `Ability to work independently` varchar(3) NOT NULL,
  `Ability to work in a group` varchar(3) NOT NULL,
  `Respect teachers and classmates` varchar(3) NOT NULL,
  `Classroom Behavior` varchar(3) NOT NULL,
  `Effort/Determination` varchar(3) NOT NULL,
  `Dependability` varchar(3) NOT NULL,
  `Penmanship` varchar(3) NOT NULL,
  `Get set(Reading Book)` varchar(3) NOT NULL,
  `Get Set(Practice Book)` varchar(3) NOT NULL,
  `Sunshine(Reading Book)` varchar(3) NOT NULL,
  `Sunshine(Practice Book)` varchar(3) NOT NULL,
  `Languague Arts(Workbook)` varchar(3) NOT NULL,
  `Spelling(Workbook)` varchar(3) NOT NULL,
  `Mathematics` varchar(3) NOT NULL,
  `Science` varchar(3) NOT NULL,
  `Social Studies` varchar(3) NOT NULL,
  `Days Absent` varchar(3) NOT NULL,
  `Comments` varchar(400) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Open in new window


Thanks in advance
student-fischas.php
student-update.php
totsandt-db.php
totsandt-db.sql
0
Comment
Question by:themasta
  • 3
  • 2
5 Comments
 
LVL 2

Expert Comment

by:axessJosh
Comment Utility
Just to clarify.

When you use the DW wizard to create an update form, it doesn't show data in the table when you test?
0
 

Author Comment

by:themasta
Comment Utility
When I try it on student_update.php it doesn't have a test button, not by accessing it via the intsert menu or the server behavior panel.
It does however show that every input field id `Gets value from FORM.x as Text`

example

'id' Selects Record Using 'FORM.id' as 'Integer'
'student' Gets Value From 'FORM.student' as 'Text'
0
 
LVL 2

Accepted Solution

by:
axessJosh earned 500 total points
Comment Utility
DW is pretty particular when setting up the update form through the wizard.

You have to be sure that you select the correct insert form type to match the DB field type.  e.g. INT, vs VarChar.

I'm not sure what you mean by test button.  Generally, the only way to test the dataset is at the create recordset form.  

Does it test in a browser?
0
 

Author Comment

by:themasta
Comment Utility
I thought by testing you meant using the test button which some windows have when troubleshooting data from tables in the db.
solved it, my query string variable was set to 'students' rather than the primary key 'id'.
0
 

Author Closing Comment

by:themasta
Comment Utility
comment lead me to the solution
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Showing your events from Google Calendar in Google Maps Why? I travel all week and I thought it would be ideal if staff in office knew where I was based on my calendar. (OK real reason: my son wanted to see where I would be working, and I thoug…
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now