Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 12th, 2012  |  syntax: None  |  size: 1.91 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Unable to insert second entry on database [closed]
  2. <html>
  3.     <body>
  4.     <h1 style="color:#03F; font-size: 25px;">Add User</h1>
  5. <hr />
  6. <form method="post" action="manipulate_item.php?id=adduser">
  7.     <table>
  8.     <tr>
  9.     <td><b>Add As:</b></td>
  10.     <td><select name="regas" style="width:200px;">
  11.     <option>Student</option>
  12.     <option>Teacher</option>
  13.     </select></td></tr>
  14.     <tr>
  15.     <td><b>ID Number:</b></td>
  16.     <td><input type="text" name="id" style="width:200px;"></td></tr>
  17.     </table>
  18.  
  19. <input type="submit" name="button" id="button" value="Add User" />          
  20. <input type="reset" name="button3" id="button3" value="Cancel" />
  21.        
  22. if(!count($err))
  23.         {
  24.         $row=mysql_fetch_array(mysql_query("SELECT * FROM tz_members WHERE id='$id' AND regas='$regas'"));
  25.             if($row)
  26.             {  
  27.             $err[]='User ID already exists!';
  28.                 $_SESSION['msg']['reg-err'] = implode('<br />',$err);
  29.             }
  30.             else
  31.             {
  32.                 $q=mysql_query("INSERT INTO tz_members(regas, id) VALUES('$regas', '$id')");
  33.                 if(mysql_affected_rows($connect)==1)
  34.                         {
  35.                             $_SESSION['msg']['reg-success']='New User Added!';
  36.                             header("Location:allusers.php");
  37.                             exit;
  38.                         }
  39.                 else
  40.                         {
  41.                             $err[]='Cannot insert item.';
  42.                             $_SESSION['msg']['reg-err'] = implode('<br />',$err);
  43.                         }
  44.             }
  45.  
  46.         }
  47.        
  48. CREATE TABLE tz_members (
  49. regas varchar(8) collate utf8_unicode_ci NOT NULL,
  50. id int(11) NOT NULL,
  51.   PRIMARY KEY  (`id`)
  52. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  53.        
  54. $row=mysql_fetch_array(mysql_query("SELECT COUNT(*) as  count FROM tz_members WHERE id='$id' AND regas='$regas'"));
  55. if($row['count'] > 0) {
  56.    // Rest of your code