php - Database fields defaulting to a certain value -
i have form allows me add together users database.
when add together new record , come in each field info , submit, adds info database
however when effort update specific record , press submit memberid field automatically set value , im not sure may coming (see here http://imgur.com/mk07epa)
i have looked throughout code , cant seem find what's causing it.
upon trying update or delete records after first update, next error messages: (http://imgur.com/qs0iqki)
add code
<!doctype html> <html> <head><title>insert users</title></head> <body> <h2>insert user confirmation</h2> <form action="<?php $_server['php_self']?>" method="post"/> <br> <?php include('connection.php'); echo "<label for='memberid' >member id:</label>"; echo "<input type='text' name='memberid' id='memberid' />"; echo "<br /><br />"; echo "<label for='username' >username:</label>"; echo "<input type='text' name='username' id='username' />"; echo "<br /><br />"; echo "<label for='password' >password:</label>"; echo "<input type='password' name='password' id='password' />"; echo "<br /><br />"; echo "<label for='fname' >firstname:</label>"; echo "<input type='text' name='fname' id='fname' />"; echo "<br /><br />"; echo "<label for='lname' >lastname:</label>"; echo "<input type='text' name='lname' id='lname' />"; echo "<br /><br />"; echo "<label for='address' >address:</label>"; echo "<input type='text' name='address' id='address' />"; echo "<br /><br />"; echo "<label for='email' >email:</label>"; echo "<input type='text' name='email' id='email' />"; echo "<br /><br />"; echo "<input type='submit' name='submit' value='submit' />"; echo "<input type='reset' value='clear' />"; echo "<br /><br />"; ?> </form> </section> <a href="home.php">back home</a><br/> <?php if(!isset($_post['submit'])) { echo 'please register'; } else { $memberid = $_post['memberid']; $username = $_post['username']; $password = $_post['password']; $fname = $_post['fname']; $lname = $_post['lname']; $address = $_post['address']; $email = $_post['email']; $query = "insert `members` (memberid, username, password, firstname, lastname, address, email) values ('$memberid', '$username', '$password', '$fname', '$lname', '$address', '$email')"; mysqli_query($connection, $query) or die(mysqli_error($connection)); $rc = mysqli_affected_rows($connection); if ($rc==1) { echo '<h4>the database has been updated next details: </h4> '; echo 'memberid: '.$memberid.'<br />'; echo 'username: '.$username.'<br />'; echo 'password: '.$password.'<br />'; echo 'first name: '.$fname.'<br />'; echo 'last name: '.$lname.'<br />'; echo 'address: '.$address.'<br />'; echo 'email: '.$email.'<br />'; } else { echo '<p>the info not entered database time.</p>'; } } ?> </body> </html> view code
<?php require_once('connection.php'); $query = 'select * members order memberid'; include('includes/query.php'); echo '<table>'; echo '<tr>'; echo ' <th>memberid</th> <th>username </th> <th>password</th> <th>firstname</th> <th>lastname</th> <th>email</th> <th>address</th>'; echo '</tr>'; foreach ($rows $row) { echo '<tr>'; echo '<td>' . $row['memberid'] . '</td>'; echo '<td>' . $row['username'] . '</td>'; echo '<td>' . $row['password'] . '</td>'; echo '<td>' . $row['firstname'] . '</td>'; echo '<td>' . $row['lastname'] . '</td>'; echo '<td>' . $row['email'] . '</td>'; echo '<td>' . $row['address'] . '</td>'; echo '<td> <a href="confirm_delete.php?memberid=' . $row['memberid'] . '">delete</a> </td>'; echo '<td> <a href="update_member_form.php?memberid=' . $row['memberid'] . '">update</a> </td>'; echo '</tr>'; } echo '</table>'; ?> update code
<?php require_once('connection.php'); if(!isset($_post['submit'])) { echo "unauthorised access"; } else { $memberid = $_post['memberid']; $username = $_post['username']; $password = $_post['password']; $firstname = $_post['firstname']; $lastname = $_post['lastname']; $email = $_post['email']; $address = $_post['address']; $query = "update members set memberid = '#memberid', username = '$username', password = '$password', firstname = '$firstname', lastname = '$lastname', email = '$email', address = '$address' memberid = '$memberid'"; $result = mysqli_query($connection, $query) or die (mysqli_error($connection)); $rc = mysqli_affected_rows($connection); if($rc == 1) { echo "<p>you have updated memberid: {$memberid} business relationship details</p>"; echo "<p><a href='view_records.php'>back user list</a> </p>"; } else { echo "<p>no changes made.</p>"; echo "<p><a href='view_records.php'>back user list</a> </p>"; } } ?> delete code
<?php require_once('connection.php'); $memberid = $_get['memberid']; $query = "delete members memberid = '$memberid';"; $result = mysqli_query($connection, $query) or die (mysqli_error($connection)); $rc = mysqli_affected_rows($connection); if($rc == 1) { echo "<p>you have removed memberid: {$memberid} database</p>"; echo "<a href='list_delete_update_users.php'>back user list</a>"; } else { echo "<p>no record deleted</p>"; echo "<a href='view_records.php'>back user list</a>"; } ?>
see line in update code:
$query = "update members set memberid = '#memberid', username = '$username', password = '$password', firstname = '$firstname', lastname = '$lastname', email = '$email', address = '$address' memberid = '$memberid'"; solution: got variable via post in $memberid while updating using #memberid. might 1 of problems.
php sql forms
No comments:
Post a Comment