<?php
extract($_POST);
$link = mysql_connect($host, $user, $pass);
if ($link) {
mysql_select_db ($dbase)
or die ("Unable to open ".$dbase);
$query = "DESCRIBE ".$table;
$desc = mysql_query($query)
or die ("DESCRIBE ".$table." FAILED!");
while ($row=mysql_fetch_array($desc, mysql_NUM)){
$name[] = $row[0];
}//end while $row
mysql_free_result($desc);
//
$query = "SELECT * FROM $table";
$result = mysql_query($query)
or die ("SELECT ".$table." FAILED!");
$col = mysql_num_fields($result);
$num = mysql_num_rows($result);
}//end if $link
else {
die ("Unable to connect to DB server");
}//end else $link
?>
<HTML><HEAD><TITLE>Javascript Object</TITLE>
<SCRIPT>
q = "'";
tabl = <?php print "\"$table\"\n" ?>
save = new Array <?php print ("($col+1)\n") ?>
num = <?php print "$num\n" ?>
col = <?php print "$col\n" ?>
nam = new Array(<?php print $col?>)
<?php for ($i=0; $i < $col; $i++){;
print ("nam[$i] = \"$name[$i]\"\n");
}
?>
tableObject = {
kk : 0,
kx : <?php print ("$num,\n");
$i = 0;
while ($row=mysql_fetch_array($result, mysql_NUM)){
if ($i > 0) print (", \nA$i: {");
else print ("A$i: {");
print ("$name[0]:\"$row[0]\"");
for ($j=1; $j < $col; $j++){
print (", $name[$j]:\"$row[$j]\"");
}//end for $col
print ("}");
$i++;
}//end while
?>
}//end table object
</SCRIPT></HEAD>
<BODY>
<?php
mysql_close($link)
or print ("Database connection NOT CLOSE");
print("<TABLE><TR><TD>Database:
<TD><b style='color:red'>$dbase</b>\n");
print ("<TR><TD style='vertical-align:baseline'>Table:
<TD><b style='color:red'>$table</b>\n");
print ("</TABLE>");
?>
<TABLE><TR><TD>
<FORM name="tbl" style="float:left;margin-right:2em;">
<TABLE><TR><TD>record#<TD><INPUT type="text" name="record">
<?php
for ($i=0; $i < $col; $i++){
print ("<TR><TD>$name[$i]
<TD><INPUT type='text' name='$name[$i]'>\n");
}//end for $col
?>
</TABLE>
</FORM>
Buttons usage:
<table>
<tr><td>-<td>DISPLAY<td>displays the next row
<tr><td>-<td>CLEAR<td>clears the table
<tr><td>-<td>RESTORE<td>restores to the values as received from the database
<tr><td>-<td>UPDATE<td>change the content of one or more fields, then click on the button
<tr><td>-<td>DELETE<td>deletes the current row - NO getting back
</table>
</TABLE>
<TABLE><TR><TD>
<FORM name="noaction" style="float:left;">
<BUTTON type="button" value="push" name="display"
onclick='if (tableObject.kk == tableObject.kx)tableObject.kk=0;
tbl.record.value=tableObject.kk+1;
<?php
print("save[0] = tbl.record.value;\n");
for ($j=0; $j < $col; $j++){
print("tbl[$j+1].value=eval(\"tableObject.A\"
+tableObject.kk+\".$name[$j]\");\n");
print ("save[$j+1] = tbl[$j+1].value;\n");
}
?>
tableObject.kk++
final.message.value=""'>
DISPLAY
</BUTTON>
<BUTTON type="button" name="clear"
onclick='for (i=0; i < <?php print "$col+1"; ?>; i++){
tbl[i].value="";
}'
>
CLEAR
</BUTTON>
<BUTTON type="button" name="restore"
onclick='for (i=0; i < <?php print "$col+1"; ?>; i++){
tbl[i].value=save[i];
}'
>
RESTORE
</BUTTON>
</FORM>
<FORM action="PHPSql.php" method="POST" name="updateform" onsubmit="return ok">
<INPUT type="hidden" name="query">
<INPUT type="hidden" name="host" value="<?php print $host ?>">
<INPUT type="hidden" name="user" value="<?php print $user ?>">
<INPUT type="hidden" name="pass" value="<?php print $pass ?>">
<INPUT type="hidden" name="dbase" value="<?php print $dbase ?>">
<BUTTON type='submit' name='update'
onclick='$upd = <?php print ("\"UPDATE $table \"\n"); ?>
s = 0
$set = "SET "
$where= " WHERE "
for (j=0; j < <?php print $col ?>; j++){
if (j > 0) $where += " AND "
$where += nam[j]+"="+q+save[j+1]+q
if (tbl[j+1].value != save[j+1]) {
if (s > 0) $set += ", "
$set += nam[j]+"="+q+tbl[j+1].value+q;
s++
}//end if !=
}//end for col
if (s==0){
final.message.value="NO value is changed!"
query.value = ""
ok = false
}
else {
$query = $upd+$set+$wher;
final.message.value=$query;
query.value = $query
ok = true
}'
>
UPDATE
</BUTTON>
<BUTTON type="submit" name="delete"
onclick='$del = <?php print ("\"DELETE FROM $table WHERE \"\n");?>
for (j=0; j < <?print $col ?>; j++){
if (j > 0) $del += " AND "
$del += nam[j] + "=" + q+save[j+1]+q
}
final.message.value=$del
query.value=$del'
>
DELETE
</BUTTON>
</FORM>
</TABLE>
<TABLE><TR><TD>
<FORM action="PHPModify.html" name="next" style="float:left;">
<TABLE><TR><TD>New table:
<TD><BUTTON type="submit" name="next">NEW</BUTTON>
</TABLE>
</FORM>
<FORM action="TheEnd.html" name="final">
<TABLE><TR><TD>Terminate:
<TD><BUTTON type="submit" name="end">EXIT</BUTTON>
</TABLE>
<INPUT type="text" name="message" size="128" style="margin-top:1em;">
</FORM>
</TABLE>
</BODY></HTML>
|