<?php
if ($_GET['action'] == 'save')
{
// place your code here to handle the form
}
else
{
//otherwise display form.
?>
<html>
<head></head>
<body>
<form method="post" action="?action=save">
<!- your form stuff here
</form>
</body>
</html>
<?php
switch($_POST['action']) {
case "save":
// place your code here to handle the form
break;
case "delete":
// you could delete a record or something here
break;
default:
//catchall default
?>
<html>
<head></head>
<body>
<form method="post" action="save">
<!- your form stuff here
</form>
</body>
</html>
<?php
}
?>// the key is passed through the url with the name of the keyfield
list($tablekey, $keyvalue) = each($HTTP_GET_VARS);
//array for attaching the keynames to the corresponding tablenames
$tablearray=array();
$tablearray[arid]='artisttable';
$tablearray[clid]='clienttable';
$tablearray[cltid]='clienttypetable';
$tablearray[orid]='ordertable';
$tablearray[orlid]='orderlinestable';
//loop through the posted variables
//formfieldnames must be corresponding to tablefieldnames
//in case of array than arrayname must be corresponding fieldname
while ( list($field, $value) = each ($HTTP_POST_VARS)) {
if ($field <> "Submit" ){
if (is_array($value)){
$arrayLength = count($value);
$temparray=array_values($value);
for ($i = 0; $i < $arrayLength; $i++){
$temp=$temp .$temparray[$i] .";";
}
$fieldlines=$fieldlines .$field ."='" .$temp ."',";
}else{
$fieldlines=$fieldlines .$field ."='" .$value ."',";
}
}
}
$fieldlines=substr($fieldlines,0,strlen($fieldlines)-1); // get rid of the last ,
if (!empty($keyvalue)) //if no key in the url then consider it an insert statement
{
$query="UPDATE " . $tablearray[$tablekey] ." SET " . $fieldlines . " WHERE " . $tablekey ."='$keyvalue'";
}
else
{
$query="INSERT INTO " . $tablearray[$tablekey] . " SET ". $fieldlines;
}
$rs=mysql_query($query,$conn);<form method="post" action="?action=save">
<input type="hidden" name="key" value="<?= $key ?>">
</form>
while ( list($field, $value) = each ($HTTP_POST_VARS)) {
if ($field <> "Submit" ){
if (is_array($value)){
$arrayLength = count($value);
$temparray=array_values($value);
for ($i = 0; $i < $arrayLength; $i++){
$temp=$temp .$temparray[$i] .";";
}
$fieldlines=$fieldlines .$field ."='" .$temp ."',";
}else{
if (($field != "keyvalue") OR ($field != "tablekey" ))
{
$fieldlines=$fieldlines .$field ."='" .$value ."',";
}
if($field=="tablekey") {$tablekey=$value;}
if($field=="keyfield") {$keyfield=$value;}
}
}
}
would do. If either disjunct (the things being operated on by the "||" is true, then the script outputs. But the field can be named only one name or the other, so at least one of the disjuncts will always evaluate to true. would have to be not either of the two names. This is what you want. but I try again
;