I have a simple back end PHP that modifies info stored in a MySQL db. Its actually contact information for distributors of our products.
I am using enum for several fields, but I have to type "yes" or "no" into the text field to manipulate the actual db. How can I do this with a check button or pull down menu? if I change the input type, it no longer populates from the db, much less allows me to modify!
the "admin" page I created looks like this (sorry, it's long)
Code:
<html>
<title>Admin Console</title>
<body>
<?php
$db = mysql_connect("X", "X", "X");
mysql_select_db("ortonceramic_com_-_dist",$db);
if ($submit) {
// here if no ID then adding else we're editing
if ($id) {
$sql = "UPDATE alldist SET company='$company', street='$street', city='$city', state='$state', zip='$zip', phone='$phone', fax='$fax', email='$email', web='$web', bar='$bar', small='$small', large='$large', self='$self', vent='$vent', control='$control', acc='$acc', country='$country', contact='$contact' WHERE id=$id";
} else {
$sql = "INSERT INTO alldist (company, street, city, state, zip, phone, fax, email, web, bar, small, large, self, vent, control, acc, country, contact) VALUES ('$company', '$street', '$city', '$state', '$zip', '$phone', '$fax', '$email', '$web', '$bar', '$small', '$large', '$self', '$vent', '$control', '$acc', '$country', '$contact')";
}
// run SQL against the DB
$result = mysql_query($sql);
echo "<p>Record updated/edited!<br><br><a href=\"distadmin.php\">Return to Admin Console</a></p>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM alldist WHERE id=$id";
$result = mysql_query($sql);
echo "<p>Record deleted!<br><br><a href=\"distadmin.php\">Return to Admin Console</a></p>";
} else {
// this part happens if we don't press submit
if (!$id) {
// print the list if there is not editing
?><div id="adminr"><table border="0" cellpadding="5"><tr><td><h1>Search by International:</h1></td>
<td valign="top"><form method="post" action="<?php echo $PHP_SELF?>">
<select name="intl">
<option value="%">Pick Country</option>
<optgroup label="Africa">
<option value=%Africa>South Africa</option>
</optgroup>
<optgroup label="Asia">
<option value=India>India</option>
<option value=Indonesia>Indonesia</option>
<option value=Japan>Japan</option>
<option value=%China>Peoples Republic of China</option>
<option value=Philippines>Philippines</option>
<option value=%Arabia>Saudi Arabia</option>
<option value=%Korea>South Korea</option>
<option value=Taiwan>Taiwan</option>
<option value=Thailand>Thailand</option>
<option value=Turkey>Turkey</option>
<option value=Yugoslavia>Yugoslavia</option>
</optgroup>
<optgroup label="Australia">
<option value=%Australia>Australia</option>
<option value=%Zealand>New Zealand</option>
</optgroup>
<optgroup label="Europe">
<option value=Austria>Austria</option>
<option value=Bulgaria>Bulgaria</option>
<option value=Croatia>Croatia</option>
<option value=Denmark>Denmark</option>
<option value=Finland>Finland</option>
<option value=France>France</option>
<option value=Germany>Germany</option>
<option value=Italy>Italy</option>
<option value=Netherlands>Netherlands</option>
<option value=Norway>Norway</option>
<option value=Poland>Poland</option>
<option value=Portugal>Portugal</option>
<option value=Slovenia>Slovenia</option>
<option value=Spain>Spain</option>
<option value=Sweden>Sweden</option>
<option value=Switzerland>Switzerland</option>
<option value=%Kingdom>United Kingdom</option>
</optgroup>
<optgroup label="North America">
<option value=Canada>Canada</option>
<option value=%Based>US Based</option>
</optgroup>
<optgroup label="South America">
<option value=Argentina>Argentina</option>
<option value=Brazil>Brazil</option>
<option value=Chile>Chile</option>
<option value=Colombia>Colombia</option>
<option value=Ecuador>Ecuador</option>
<option value=Mexico>Mexico</option>
<option value=Peru>Peru</option>
<option value=Venezuela>Venezuela</option>
</optgroup>
</select>
<input type="submit" name="submit3" value="Go">
</form></td>
<tr><td colspan="2"><hr></td></tr>
<tr><td><h1>Search by Domestic:</h1></td>
<td valign="top"><form method="post" action="<?php echo $PHP_SELF?>">
<select name="van">
<option value="%">Pick State</option>
<option value=AL>Alabama</option>
<snip>
<option value=WY>Wyoming</option>
</select>
<input type="submit" name="submit2" value="Go">
</td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>
<?php
$result = mysql_query("SELECT * FROM alldist WHERE country like '$intl' or state like '$van' ORDER BY company",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?id=%s\">%s</a> - \n", $PHP_SELF, $myrow["id"], $myrow["company"]);
printf("<a href=\"%s?id=%s&delete=yes\">(remove)</a><br>", $PHP_SELF, $myrow["id"]);
printf("<br>");
}
}
?>
</div>
<div id="adminl">
<h1>Add a New Contact:</h1>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($id) {
// editing so select a record
$sql = "SELECT * FROM alldist WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$company = $myrow["company"];
$street = $myrow["street"];
$city = $myrow["city"];
$state = $myrow["state"];
$zip = $myrow["zip"];
$phone = $myrow["phone"];
$fax = $myrow["fax"];
$email = $myrow["email"];
$web = $myrow["web"];
$bar = $myrow["bar"];
$small = $myrow["small"];
$large = $myrow["large"];
$self = $myrow["self"];
$vent = $myrow["vent"];
$control = $myrow["control"];
$acc = $myrow["acc"];
$country = $myrow["country"];
$contact = $myrow["contact"];
// print the id for editing
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"><padmin>Company:</padmin></td><td><input type="Text" name="company" size="35" value="<?php echo $company ?>"></td></tr>
<tr>
<td align="right"><padmin>Contact:</padmin></td><td><input type="Text" name="contact" size="25" value="<?php echo $contact ?>"></td></tr>
<tr>
<td align="right"><padmin>Street:</padmin></td><td><input type="Text" name="street" size="25" value="<?php echo $street ?>"></td></tr>
<tr>
<td align="right"><padmin>City:</padmin></td><td><input type="Text" name="city" size="20" value="<?php echo $city ?>"></td></tr>
<tr>
<td align="right"><padmin>State:</padmin></td><td><input type="Text" name="state" size="10" value="<?php echo $state ?>"></td></tr>
<tr>
<td align="right"><padmin>Country:</padmin></td><td><input type="Text" name="country" size="25" value="<?php echo $country ?>"></td></tr>
<tr>
<td align="right"><padmin>Zip:</padmin></td><td><input type="Text" name="zip" size="10" value="<?php echo $zip ?>"></td></tr>
<tr>
<td align="right"><padmin>Phone:</padmin></td><td><input type="Text" name="phone" size="15" value="<?php echo $phone ?>"></td></tr>
<tr>
<td align="right"><padmin>Fax:</padmin></td><td><input type="Text" name="fax" size="15" value="<?php echo $fax ?>"></td></tr>
<tr>
<td align="right"><padmin>email:</padmin></td><td><input type="Text" name="email" size="30" value="<?php echo $email ?>"></td></tr>
<tr>
<td align="right"><padmin>Web:</padmin></td><td><input type="Text" name="web" size="30" value="<?php echo $web ?>"></td></tr>
<tr>
<td align="right"><padmin>Bars:</padmin></td><td><input type="text" name="bar" size="5" value="<?php echo $bar ?>"></td></tr>
<tr>
<td align="right"><padmin>Small Cones:</padmin></td><td><input type="text" name="small" size="5" value="<?php echo $small ?>"></td></tr>
<tr>
<td align="right"><padmin>Large Cones:</padmin></td><td><input type="text" name="large" size="5" value="<?php echo $large ?>"></td></tr>
<tr>
<td align="right"><padmin>Self Supporting Cones:</padmin></td><td><input type="text" name="self" size="5" value="<?php echo $self ?>"></td></tr>
<tr>
<td align="right"><padmin>Vents:</padmin></td><td><input type="text" name="vent" size="5" value="<?php echo $vent ?>"></td></tr>
<tr>
<td align="right"><padmin>Controllers:</padmin></td><td><input type="text" name="control" size="5" value="<?php echo $control ?>"></td></tr>
<tr>
<td align="right"><padmin>Accessories:</padmin></td><td><input type="text" name="acc" size="5" value="<?php echo $acc ?>"></td></tr>
<tr>
<td align="center" colspan="2"><input type="Submit" name="submit" value="Save"></td></tr>
</table></form></div>
<?php
}
?>
</body>
</html>
checkbutton to interface with MySQL?
Linear Mode
