ทดสอบการเรียก database
Add New Data
";
echo "Number of rows from result: ".mysql_affected_rows()."
";
$num_fields = mysql_num_fields($result);
echo "Number of cols from result: ".$num_fields."
";
$r=0;
echo "";
echo "";
for($i=0; $i < $num_fields; $i++) echo "| ".mysql_field_name($result, $i)." | ";
echo "Edit | ";
echo "
";
while ($name_row = mysql_fetch_row($result)) {
$bgcolor = ($r%2)?" bgcolor=#FFFFFF ":" bgcolor=#AAAAAA ";
echo "";
for($i=0; $i < $num_fields; $i++) print("| $name_row[$i] | ");
print("[ Edit |
Delete ] | ");
echo "
";
$r++;
//print("$name_row[0] -> $name_row[1] $name_row[2] - ".$name_row[3]."---
\n");
}
/*
while ($row = mysql_fetch_object($result)) {
echo "";
print("| $row->std_id | $row->std_fname | $row->std_lname |
$row->std_phone | $row->section | ");
echo "
";
}
*/
//while ($row = mysql_fetch_array($result)) {
// print($row['test_id'].$row['test_name'].$row['test_desc'].$row['test_memo']."---
\n");
//}
echo "
";
?>
Add New Data