Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- ?>
- <?php
- $host="localhost"; // Host name
- $username="root"; // Mysql username
- $password=""; // Mysql password
- $db_name="library"; // Database name
- $tbl_name="users"; // Table name
- // Connect to server and select database.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- // get value of id that sent from address bar
- $id=$_GET['username'];
- // Retrieve data from database
- $result=mysql_query("DELETE FROM $tbl_name where username='".$_SESSION['username']."'");
- $row=mysql_fetch_assoc($result);
- ?>
- <table width="400" border="0" cellspacing="1" cellpadding="0">
- <tr>
- <form name="form1" method="post" action="update_ac.php">
- <td>
- <table width="100%" border="0" cellspacing="1" cellpadding="0">
- <tr>
- <td> </td>
- <td colspan="3"><strong>Update data in mysql</strong> </td>
- </tr>
- <tr>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- <td align="center"> </td>
- </tr>
- <tr>
- <td align="center"> </td>
- <td align="center"><strong>Userame</strong></td>
- <td align="center"><strong>Name</strong></td>
- <td align="center"><strong>Lastname</strong></td>
- <td align="center"><strong>Grade</strong></td>
- <td align="center"><strong>Field</strong></td>
- <td align="center"><strong>Email</strong></td>
- <td align="center"><strong>Mobile</strong></td>
- </tr>
- <tr>
- <td> </td>
- <td align="center">
- <input name="name" type="text" id="name" value="<? echo $row2['username']; ?>">
- </td>
- <td align="center">
- <input name="name" type="text" id="name" value="<? echo $row2['name']; ?>">
- </td>
- <td align="center">
- <input name="lastname" type="text" id="lastname" value="<? echo $row2['family']; ?>" size="15">
- </td>
- <td>
- <input name="email" type="text" id="email" value="<? echo $row2['gradel']; ?>" size="15">
- </td>
- <td><input name="email" type="text" id="email" value="<? echo $row2['field']; ?>" size="15">
- </td>
- <td>
- <input name="email" type="text" id="email" value="<? echo $row2['email']; ?>" size="15">
- </td>
- <td>
- <input name="email" type="text" id="email" value="<? echo $row2['email']; ?>" size="15">
- </td>
- </tr>
- <tr>
- <td> </td>
- <td>
- <input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>">
- </td>
- <td align="center">
- <input type="submit" name="Submit" value="Submit">
- </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td> </td>
- </tr>
- </table>
- </td>
- </form>
- </tr>
- </table>
- <?php
- // close connection
- mysql_close();
- ?>
- <?php
- session_start();
- if(!session_is_registered(myusername)){
- header("location:Main.php");
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Untitled Document</title>
- </head>
- <body>
- <?php
- $host="localhost"; // Host name
- $username="root"; // Mysql username
- $password=""; // Mysql password
- $db_name="library"; // Database name
- $tbl_name="users"; // Table name
- // Connect to server and select database.
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- // get value of id that sent from address bar
- $id=$_GET['username'];
- // Retrieve data from database
- $result=mysql_query("UPDATE FROM $tbl_name where username='".$_SESSION['username']."'");
- $sql="UPDATE $tbl_name SET
- family='$family', grade='$grade' ,field='$field',email='$email',mobile='$mobile'
- WHERE username='".$_SESSION['username']."'";
- $result=mysql_query($sql);
- if($result){
- echo '<script type="text/javascript">';
- echo 'alert("Update SuccessFully !!");';
- echo 'window.location.href = "Personalpage.php";';
- echo '</script>';
- }
- else {
- echo "ERROR";
- }
- ?>
- <?php
- // close connection
- mysql_close();
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement