Hello,
I'm trying to create a form that will display the contents of a certain table within my database and then allow me to update multiple records in that table at once. I've gotten the display part to work, but I can't figure out how to get the form to update the database.
Any help would be appreciated.
Thanks 🙂
<?php
include 'conf.php';
include '../lib/wowdb.php';
if ($submit) {
// process form
$link = mysql_connect($db_host, $db_user, $db_passwd) or die ("Could not connect to desired database.");
mysql_select_db($db_name) or die ("Could not select desired database");
// $query = "UPDATE members SET race='$race', about='$about' WHERE member_id='$member_id'";
for ($i = 0; $i < count($_POST['member_id']); $i++)
{
$query = "UPDATE members SET race = '".$_POST['race'.$i]."', about = '".$_POST['about'.$i]."' where id = ".$_POST['member_id'.$i];
}
$result = mysql_query($query) or die(mysql_error());
echo "Thank you! Information entered.\n";
} else {
// Establish our connection and select our database
$link = mysql_connect($db_host, $db_user, $db_passwd) or die ("Could not connect to desired database.");
mysql_select_db($db_name) or die ("Could not select desired database");
$server_name_escape = $wowdb->escape($server_name);
$guild_name_escape = $wowdb->escape($guild_name);
$query = "SELECT guild_id, DATE_FORMAT(update_time, '".$timeformat[$lang]."') from `guild` where guild_name= '$guild_name_escape' and server='$server_name_escape'";
$result = mysql_query($query) or die(mysql_error());
if ($row = mysql_fetch_row($result)) {
$guildId = $row[0];
$updateTime = $row[1];
} else {
die("Could not find guild:'$guild_name' for server '$server_name'. You need to load your guild first and make sure you finished configuration.");
}
$query = "SELECT members.member_id, members.name, members.class, members.race, members.level, members.note, IF(members.note IS NULL or members.note = '', 1, 0) AS nisnull, members.guild_rank, members.guild_title, members.zone, members.about FROM members WHERE guild_id=$guildId AND note NOT LIKE '%$Alt_type%' ORDER BY members.name ASC";
$result = mysql_query($query) or die(mysql_error());
?>
<html>
<head>
<title>XXXXXXXXXXXXXXXX</title>
</head>
<body>
<div align="center">
<table>
<tr>
<td>Name</td>
<td>Race</td>
<td>About</td>
</tr>
<form method="post" action="<?php echo $PHP_SELF;?>">
<?php
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td width="200"><input type="hidden" id="member_id[]" name="member_id[]" value="<?php echo $row['member_id']; ?>"><?php echo $row['name']; ?></td>
<td width="200"><select id="race[]" name="race[]">
<option value="" <?php if ($row['race'] == '') { print('selected'); } ?>>Choose One</option>
<option value="Dwarf" <?php if ($row['race'] == 'Dwarf') { print('selected'); } ?>>Dwarf</option>
<option value="Gnome" <?php if ($row['race'] == 'Gnome') { print('selected'); } ?>>Gnome</option>
<option value="Human" <?php if ($row['race'] == 'Human') { print('selected'); } ?>>Human</option></select>
</td>
<td width="200"><select id="about[]" name="about[]">
<option value="1" <?php if ($row['about'] == '1') { print('selected'); } ?>>Yes</option>
<option value="0" <?php if ($row['about'] == '0') { print('selected'); } ?>>No</option></select>
</td>
</tr>
<?php
}
?>
<tr>
<td align="center" colspan="3">
<br /><br />
<input type="submit" name="submit" value="Submit">
</td>
</tr>
</form>
</table>
</div>
</body>
</html>
<?php
}
?>
