
Untitled
By: a guest on
Aug 12th, 2012 | syntax:
None | size: 1.91 KB | hits: 9 | expires: Never
Unable to insert second entry on database [closed]
<html>
<body>
<h1 style="color:#03F; font-size: 25px;">Add User</h1>
<hr />
<form method="post" action="manipulate_item.php?id=adduser">
<table>
<tr>
<td><b>Add As:</b></td>
<td><select name="regas" style="width:200px;">
<option>Student</option>
<option>Teacher</option>
</select></td></tr>
<tr>
<td><b>ID Number:</b></td>
<td><input type="text" name="id" style="width:200px;"></td></tr>
</table>
<input type="submit" name="button" id="button" value="Add User" />
<input type="reset" name="button3" id="button3" value="Cancel" />
if(!count($err))
{
$row=mysql_fetch_array(mysql_query("SELECT * FROM tz_members WHERE id='$id' AND regas='$regas'"));
if($row)
{
$err[]='User ID already exists!';
$_SESSION['msg']['reg-err'] = implode('<br />',$err);
}
else
{
$q=mysql_query("INSERT INTO tz_members(regas, id) VALUES('$regas', '$id')");
if(mysql_affected_rows($connect)==1)
{
$_SESSION['msg']['reg-success']='New User Added!';
header("Location:allusers.php");
exit;
}
else
{
$err[]='Cannot insert item.';
$_SESSION['msg']['reg-err'] = implode('<br />',$err);
}
}
}
CREATE TABLE tz_members (
regas varchar(8) collate utf8_unicode_ci NOT NULL,
id int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
$row=mysql_fetch_array(mysql_query("SELECT COUNT(*) as count FROM tz_members WHERE id='$id' AND regas='$regas'"));
if($row['count'] > 0) {
// Rest of your code