Guest User

Untitled

a guest
Sep 8th, 2017
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.89 KB | None | 0 0
  1. <?php
  2. $hostname="localhost";
  3. $username="root";  
  4. $password="";      
  5. $database="2my4edge";  
  6. $con=mysqli_connect($hostname,$username,$password,$database);
  7. $sql5="SELECT * FROM `user` WHERE `id`='".$_GET["id"]."'";
  8.  
  9. $res1=mysqli_query($con,$sql5);
  10.  
  11. if (mysqli_num_rows($res1) > 0)
  12. {
  13.            
  14.             while($row1 = mysqli_fetch_array($res1))
  15.             {
  16.                  $id=$row1['0'];
  17.                  $fname=$row1['1'];
  18.                  $lname=$row1['2'];
  19.                  $email=$row1['3'];
  20.                  $pass=$row1['4'];
  21.                  $city=$row1['5'];
  22.                  $uname=$row1['6'];
  23.                  $gender=$row1['7'];
  24.             }  
  25. }  
  26. ?>
  27. <html>
  28. <head>
  29. </head>
  30. <body>
  31. <form name="myform" method="POST" action="./update.php" enctype="multipart/form-data" >
  32. <table border="2" align="center">
  33. <tr><th align="center" colspan="2"><h3> Registration Detail</h3></th></tr>
  34. <tr><td>ID:- </td><td><input type="text"  name="id" value="<?php echo $id;?>" readonly /></td></tr>
  35. <tr><td>First Name:- </td><td><input type="text" name="firstname" value="<?php echo $fname;?>" ></td></tr>
  36. <tr><td>Last Name:- </td><td><input type="text" name="lastname" value="<?php echo $lname;?>"></td></tr>  
  37. <tr><td>E-Mail:- </td><td><input type="text" name="email" value="<?php echo $email;?>"></td></tr>
  38. <tr><td>Password:- </td><td><input type="password" name="password" value="<?php echo $pass;?>"></td></tr>
  39. <tr><td>city:- </td><td><input type="text" name="city" value="<?php echo $city;?>"></td></tr>
  40. <tr><td>Username:- </td><td><input type="text" name="username" value="<?php echo $uname;?>"></td></tr>
  41. <tr><td>Gender:-</td><td><select name="gender">
  42.                         <option value="male"<?php if ($gender == 'male'){ echo"selected=\"selected\"";} ?> >male</option>
  43.                         <option value="female" <?php if ($city == 'female'){ echo"selected=\"selected\"";} ?>>female</option>
  44.                         </select>
  45.             </td></tr>
  46.  
  47. <tr><td COLSPAN="2" ALIGN="CENTER"><input type="submit" value="update" name="update"></td></tr>
  48. </form>
  49. </body>
  50. </html>
Add Comment
Please, Sign In to add comment