Can anybody tell me why is the record not inserted? This is my one page :-\[code\]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> </head> <body> <form action="Adduser.php" method="post"> <center> <table> <tr> <td> Username : </td> <td> <input type="text" id="username" /> </td> </tr> <tr> <td> Password : </td> <td> <input type="text" id="password"/> </td> </tr> <tr> <td> Email Address : </td> <td> <input type="text" id="emailaddress"/> </td> </tr> <tr> <td> Address : </td> <td> <input type="text" id="Address"/> </td> </tr> <tr> <td colspan="2"> <input type="Submit" name="submit" value="http://stackoverflow.com/questions/3329894/Add"/> </td> </tr> </table> </center> <?php mysql_connect('localhost', 'root', ''); mysql_select_db('user'); $query = mysql_query("Select * from tbluser"); echo "<center>"; echo '<table style="border:solid 2px black;">'; while(($row = mysql_fetch_array($query)) != NULL) { echo '<tr>'; echo '<td>' . $row['UserName'] . '</td>'; echo '<td>' . $row['Password'] . '</td>'; echo '<td>' . $row['EmailAddress'] . '</td>'; echo '<td>' . $row['Address'] . '</td>'; echo '</tr>'; } echo '</table>'; echo "</center>"; ?> </form> </body></html>\[/code\]Problem lies here (this is Adduser.php) :-\[code\] var_dump($_POST); if(isset ($_POST['submit'])){ $username = trim($_POST['username']); $password = trim($_POST['password']); $emailaddress = trim($_POST['emailaddress']); $address = trim($_POST['address']); $query = "INSERT INTO tbluser (UserName,Password,EmailAddress,Address) Values ('" . $username . "','" . $password . "','" . $emailaddress . "','" . $address . "')"; mysql_query($query); } ?>\[/code\]The if condition never gets executed. Can anybody tell me why is it not working? The \[code\]$_POST\[/code\] array contains nothing when printed via \[code\]var_dump\[/code\]
mysql php crud problem
- Thread starter devils553
- Start date