<?php
require("dbconfig.php");
$id0 =$_REQUEST['userid'];
$id1 =$_REQUEST['username'];
$id2 = $_REQUEST['password'];
$id3 =$_REQUEST['firstname'];
$id4=$_REQUEST['lastname'];
$result1 = mysqli_query($connection,"SELECT * FROM usersinfo WHERE username = '$id1'");
$result2 = mysqli_query($connection,"SELECT * FROM usersinfo WHERE password = '$id2'");
$result3 = mysqli_query($connection,"SELECT * FROM usersinfo WHERE firstname = '$id3'");
$result4 = mysqli_query($connection,"SELECT * FROM usersinfo WHERE lastname = '$id4'");
$test1 = mysqli_fetch_array($result1);
$test2 = mysqli_fetch_array($result2);
$test3 = mysqli_fetch_array($result3);
$test4 = mysqli_fetch_array($result4);
$username= $test1['username'] ;
$password= $test2['password'] ;
$firstname= $test3['firstname'];
$lastname=$test4['lastname'];
if(isset($_POST['submit']))
{
$username= $_POST['username'];
$password= $_POST['password'];
$firstname=$_POST['firstname'] ;
$lastname=$_POST['lastname'];
mysqli_query($connection,"UPDATE usersinfo SET username ='$username',password='$password',firstname='$firstname',lastname='$lastname' WHERE id='$id0'")
or die(mysqli_error($connection));
}
mysqli_close($connection);
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css"/>
</head>
<body>
<form name="formuser" method="post" action="">
<div class="message">
<?php if(isset($message))
{
echo $message;
}
?>
</div>
<table border="0" cellpadding="10" cellspacing="0" width="500" align="center" class="tablesaveForm">
<tr class="tableheader">
<td colspan="2">Add new user</td>
</tr>
<?
?>
<tr>
<td><label>UserID</label></td>
<td><input type="text" name="id" class="textFeild" value="<?php echo $id0; ?>"></td>
</tr>
<tr>
<td><label>Username</label></td>
<td><input type="text" name="username" class="textFeild" value="<?php echo $username; ?>"></td>
</tr>
<tr>
<td><label>Password</label></td>
<td><input type="pasword" name="password" class="textFeild" value="<?php echo $password; ?>"></td>
</tr>
<tr>
<tr>
<td><label>First Name:</label></td>
<td><input type="text" name="firstname" class="textFeild" value="<?php echo $firstname; ?>"></td>
</tr>
<tr>
<td><label>Last Name:<label></td>
<td><input type="text" name="lastname" class="textFeild" value="<?php echo $lastname; ?>"></td>
</tr>
<tr>
<td>
<input type="submit" name="submit" value="submit" class="buttonSubmit">
</td>
</tr>
</table>
</form>
<div class="message">
<p><a href="display.php">Read All</a></p>
<p><a href="insert.php">Insert Again</a></p>
<p>© By Zaki Live 2016</p>
</div>
</body>
</html>