Home › Forums › Back End › can't get form on webpage to post to table/database on remote server › Reply To: can't get form on webpage to post to table/database on remote server
here’s ProcessCustomer.php
<?php
$dbEntries = $_POST;
foreach ($dbEntries as &$entry)
{
$entry = dbString($entry);
}
`if (!checkLength($_POST[‘FirstName’]))
{
$errors[‘FirstName’] = ‘First name omitted.’;
}
else
{
$browserEntries[‘FirstName’] = browserString($_POST[‘FirstName’]);
}
if (!checkLength($_POST[‘LastName’]))
{
$errors[‘LastName’] = ‘Last name omitted.’;
}
else
{
$browserEntries[‘LastName’] = browserString($_POST[‘LastName’]);
}
if (!checkLength($_POST[‘Address’],5,200))
{
$errors[‘Address’] = ‘Address omitted.’;
}
else
{
$browserEntries[‘Address’] = browserString($_POST[‘Address’]);
}
if (!checkLength($_POST[‘City’],1,100))
{
$errors[‘City’] = ‘City omitted.’;
}
else
{
$browserEntries[‘City’] = browserString($_POST[‘City’]);
}
if (!checkLength($_POST[‘State’],1,100))
{
$errors[‘State’] = ‘State omitted.’;
}
else
{
$browserEntries[‘State’] = browserString($_POST[‘State’]);
}
if (!checkLength($_POST[‘Zip’]))
{
$errors[‘Zip’] = ‘Zip code omitted.’;
}
else
{
$browserEntries[‘Zip’] = browserString($_POST[‘Zip’]);
}
if (!checkLength($_POST[‘PhoneNumber’],10,15))
{
$errors[‘PhoneNumber’] = ‘Home phone must be between 10 and 15 characters.’;
}
else
{
$browserEntries[‘PhoneNumber’] = browserString($_POST[‘PhoneNumber’]);
}
`
if ( !checkEmail($_POST[‘Email’]) )
{
$errors[‘Email’] = ‘Email is invalid.’;
}
else
{
$browserEntries[‘Email’] = browserString($_POST[‘Email’]);
}
`if ($_POST[‘PetType’] == 0)
{
$errors[‘PetType’] = ‘PetType not selected.’;
}
else
{
$browserEntries[‘PetType’] = $_POST[‘PetType’];
}
if ($_POST[‘NeuteredOrSpayed’] == “”)
{
$errors[‘NeuteredOrSpayed’] = ‘Neutered or Spayed not selected.’;
}
else
{
$browserEntries[‘NeuteredOrSpayed’] = $_POST[‘NeuteredOrSpayed’];
}
if (!checkLength($_POST[‘PetAge’]))
{
$errors[‘PetAge’] = ‘Pet Age omitted.’;
}
else
{
$browserEntries[‘Zip’] = browserString($_POST[‘PetAge’]);
}
`
?>
<?php
if (!count($errors) && array_key_exists(‘ID’,$_POST))
{
$employeeID = $_POST[‘GroomingID’];
$query = “UPDATE grooming
SET FirstName='” . $dbEntries[‘FirstName’] . “‘,
LastName='” . $dbEntries[‘LastName’] . “‘,
Address='” . $dbEntries[‘Address’] . “‘,
City='” . $dbEntries[‘City’] . “‘,
Region='” . $dbEntries[‘Region’] . “‘,
PostalCode='” . $dbEntries[‘PostalCode’] . “‘,
HomePhone='” . $dbEntries[‘HomePhone’] . “‘,
Email='” . $dbEntries[‘Email’] . “‘,
PetType=” . $dbEntries[‘PetType’] . “‘,
PetName='” . $dbEntries[‘PetName’] . “‘,
NeuteredOrSpayed='” . $dbEntries[‘NeuteredOrSpayed’] . “‘,
PetAge='” . $dbEntries[‘PetAge’];
if ($db->query($query))
{
echo '<div>Record Updated</div>';
}
else
{
echo '<div>Update Failed</div>';
}
}
elseif (!count($errors))
{
$showForm = false;
?>
`<form method=”post” action=”../grooming.php”>
<input type=”hidden” name=”Confirmed” value=”true”>
<?php
echo ‘<h2>Confirm Entries</h2>’;
echo ‘<ol>’;
foreach ($browserEntries as $key=>$entry)
{
if ($key==”PetType”)
{
echo “<li><b>Breed:</b> $breedEntries[$entry]</li>”;
}
else
{
echo “<li><b>$key:</b> $entry</li>”;
}
}
echo ‘</ol>’;
foreach ($dbEntries as $key=>$entry)
{
?>
<input type=”hidden” name=”<?php echo $key ?>”
value=”<?php echo $entry ?>”>
<?php
}
?>
<input type=”submit” value=”Confirm”>
</form>
`
<?php
}
else
{
$dbEntries = $_POST;
}
?>