Code: Select all
$bandid = '1';
$query = "SELECT * FROM bands WHERE bandid='$bandid'";
$result = mysql_query($query)
or die ("Couldn't bring up band.");
$row = mysql_fetch_array($result);
extract($row);
echo "<form method='post' action='testingpage2.php'>
<table width='59%' border='0' cellspacing='0' cellpadding='1'>
<tr>
<td>bandname</td>
<td><input name='bandname' type='text' size='50' maxlength='50' value='$bandname'></td>
</tr>
<tr>
<td>contact (first & last name)</td>
<td><input name='contact' type='text' size='50' maxlength='40' value='$contact'></td>
</tr>
<tr>
<td>phone number</td>
<td><input name='phone' type='text' size='10' maxlength='10' value='$phone'>
click to release phone number
<input type='checkbox' name='phonerel' value='1'><input type='hidden' name='bandid' value='$bandid'</td>
</tr>
<tr>
<td>email address:</td>
<td><input name='email' type='text' size='30' maxlength='60' value='$email'>
click to release email
<input type='checkbox' name='emailrel' value='1'></td>
</tr>
<tr>
<td>website (include http):</td>
<td><input name='website' type='text' size='50' maxlength='90' value='$website'>
</td>
</tr>
<tr>
<td>select category:</td>
<td>
<select name='catid'>
<option value='1' selected>rock/alternative/indie</option>
<option value='2'>punk/hardcore</option>
<option value='3'>metal/hard rock/grindcore</option>
<option value='4'>folk/acoustic/songwriter</option>
<option value='5'>ska/reggae/funk</option>
</select>
.................
<input type='submit' name='Submit' value='Submit'></td>
</tr>
</table>
</form>";
?>
</body>
</html>
That would be the first page minus password/user information. And as follows would be testingpage2.php:
Code: Select all
$label_array = array ("bandname" => "bandname",
"website" => "website",
"email" => "email",
"phonerel" => "phonerel",
"emailrel" => "emailrel",
"contact" => "contact",
"catid" => "catid",
"phone" => "phone",
"bandid" => "bandid");
foreach ($HTTP_POST_VARS as $key => $value)
$bandname = trim($bandname);
$bandname = strip_tags($bandname);
$contact = trim($contact);
$contact = strip_tags($contact);
$phone = trim($phone);
$phone = strip_tags($phone);
$website = trim($website);
$website = strip_tags($website);
$email = trim($email);
$email = strip_tags($email);
$query = "UPDATE bands SET phone='$phone' WHERE bandid='$bandid'";
$query = "UPDATE bands SET contact='$contact' WHERE bandid='$bandid'";
$query = "UPDATE bands SET website='$website' WHERE bandid='$bandid'";
$query = "UPDATE bands SET email='$email' WHERE bandid='$bandid'";
$query = "UPDATE bands SET bandname='$bandname' WHERE bandid='$bandid'";
$query = "UPDATE bands SET phonerel='$phonerel' WHERE bandid='$bandid'";
$query = "UPDATE bands SET emailrel='$emailrel' WHERE bandid='$bandid'";
$result = mysql_query($query)
or die ("Couldn't update band listing at this time.");
echo "Your band listing has been modified.<br>";
?>
</body>
</html>