Billybonga
IS-IT--Management
I'm working on a project where i have a "Census" database running in Mysql. Its fields are:
ID|Name|Surname|Townland|Area|county|code|group|tel|mobile|email|notes
I'm having a problem in that when I submit and new record using my php form, only ID|Name|Surname|Townland|Area|county get added to the database.
The submit code is as follows:
Can anyone see what is wrong ??
Thanks for your help
ID|Name|Surname|Townland|Area|county|code|group|tel|mobile|email|notes
I'm having a problem in that when I submit and new record using my php form, only ID|Name|Surname|Townland|Area|county get added to the database.
The submit code is as follows:
Code:
<?
echo "<table width=\"100%\"><tr>\n"; // Table 1 - SHOW DATABASE
echo "<td align=center class=big>Parish Census List</td></tr><tr>\n";
//echo "<td width=\"20%\" valign=top align=center>\n";
$view="dname";
$prim="";
echo "<td width=\"100%\" valign=top align=center>";// Table 3 - SHOW TABLE Desription
$view="fields";
if (isset($table)&&$table!="none") {
if ($usort=="ID") { $sql = "SELECT * FROM ".$table." ORDER BY ID ASC"; }
elseif ($usort=="christian_name") { $sql = "SELECT * FROM ".$table." ORDER BY christian_name ASC"; }
elseif ($usort=="surname") { $sql = "SELECT * FROM ".$table." ORDER BY surname ASC"; }
elseif ($usort=="townland") { $sql = "SELECT * FROM ".$table." ORDER BY townland ASC"; }
elseif ($usort=="area") { $sql = "SELECT * FROM ".$table." ORDER BY area ASC"; }
elseif ($usort=="county") { $sql = "SELECT * FROM ".$table." ORDER BY county ASC"; }
elseif ($usort=="code") { $sql = "SELECT * FROM ".$table." ORDER BY code ASC"; }
elseif ($usort=="group") { $sql = "SELECT * FROM ".$table." ORDER BY group ASC"; }
elseif ($usort=="Tel") { $sql = "SELECT * FROM ".$table." ORDER BY Tel ASC"; }
elseif ($usort=="Mobile") { $sql = "SELECT * FROM ".$table." ORDER BY Mobile ASC"; }
elseif ($usort=="eMail") { $sql = "SELECT * FROM ".$table." ORDER BY eMail ASC"; }
elseif ($usort=="Notes") { $sql = "SELECT * FROM ".$table." ORDER BY Notes ASC"; }
elseif ($usort=="") { $sql= "SELECT * FROM ".$table; }
else { $sql= "SELECT * FROM ".$table; }
$r = mysql_query ($sql);
if(!$r) { mysql_error(); exit; }
if (mysql_num_rows($r)) {
$numFields = mysql_num_fields( $r );
$Table = new ShowTable ($r,$sql); // View Table 3
$Table->DrawBody();
$view="field";
srand ((double) microtime() * 100000000);
$randval = rand();
echo $HeadTable."<tr><td align=center bgcolor=$bg1 class=head>\n";
echo "<a href=\"?dname=$dname&table=$table&act=show&ran=".$randval."\" class=head>[ Select one Record to Modify ]</a> |\n";
echo "<a href=\"?dname=$dname&table=$table&act=add&ran=".$randval."\" class=head>[ Add Record ]</a>\n";
echo "</td></tr></table>\n";// Table 4 - SHOW TABLE
if ($act=="show") ViewTable ($dname,$table); // View Table 4
elseif ($act=="add") AddRec ($dname,$table);
elseif ($act=="edit") EditRec ($dname,$table,$pfname,$pfvalue);
elseif ($act=="query") NewQuery ($dname,$table);
elseif ($act=="doquery") DoQuery ($dname,$table,$sqlquery);
elseif ($act=="del") {
$sql="DROP TABLE $table";
$re1 = mysql_query ($sql);
if ($re1) echo "<br>Delete complete!\n";
else {echo $sql."<br>\n".mysql_error(); exit; }
}
elseif ($act=="editnow") {
if ($Submit=="Delete") {
$sql = "DELETE FROM $table WHERE ".$pfname."=".$pfvalue;
$re1 = mysql_query ($sql);
if ($re1) echo "<br>Delete complete!\n";
else {echo $sql."<br>\n".mysql_error(); exit; }
}
else {
$sql = "SELECT * FROM ".$table." LIMIT 1";
$re1 = mysql_query ($sql);
for ($j=0;$j<mysql_num_fields($re1);$j++) {
$an[$j]=mysql_field_name($re1,$j);
$at[$j]=mysql_field_type($re1,$j);
}
$sql1 = "UPDATE $table SET ";
for ($j=0;$j<mysql_num_fields($re1);$j++) {
if (!ereg("auto_inc",mysql_field_flags($re1,$j)) && $$an[$j]!="") {
$sql1.= $an[$j]."=";
if (ereg("int",$at[$j]) || ereg("float",$at[$j]))
$sql1.= $$an[$j].",";
else $sql1.= "'".$$an[$j]."',"; } }
$sql = substr($sql1,0,(strlen($sql1)-1))." WHERE ".$pfname."=".$pfvalue;
$re2 = mysql_query ($sql);
if ($re2) echo "<br>Update complete!\n";
else {echo $sql."<br>\n".mysql_error(); exit; }
} }
elseif ($act=="addnow") {
$sql = "SHOW fields FROM $table FROM $dname";
$r2 = mysql_query ($sql);
for ($j=0;$j<mysql_num_rows($r2);$j++)
if ($F=mysql_fetch_array($r2)) {
$an[$j]= $F['Field'];
$at[$j]= ereg_replace("([()0-9]+)","",$F['Type']);
$af[$j]= $F['Extra'];
if ($F['Key']=="PRI") $nam=$F['Field'];
}
$sql1 = "INSERT INTO $table (";
for ($j=0;$j<mysql_num_fields($r2);$j++)
if (!ereg("auto_inc",$af[$j]) && $$an[$j]!="")
$sql1.= $an[$j].",";
$sql = substr($sql1,0,(strlen($sql1)-1)).") VALUES (";
for ($j=0;$j<mysql_num_fields($r2);$j++)
if (!ereg("auto_inc",$af[$j]) && $$an[$j]!="")
if (ereg("int",$at[$j]) || ereg("float",$at[$j]))
$sql.= $$an[$j].",";
else $sql.= "'".$$an[$j]."',";
$sql = substr($sql,0,(strlen($sql)-1)).")";
$re2 = mysql_query ($sql);
if ($re2) echo "<br>Save complete!\n";
else {echo $sql."<br>\n".mysql_error(); exit; }
}
}
else echo "<br><br><font color=red>No fields found in table <b>$table</b> in DB <b>$dname</b>!</font><br>";
}
echo "</td></tr>";
echo "<tr><td class=sml align=center><br><br>";
//echo "Admin: <a href=\"mailto:\" class=sml></a><br>";
echo "</td>";
echo "<td></td></tr>";
echo "</table>";
?>Can anyone see what is wrong ??
Thanks for your help