Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $con = mysql_connect("localhost","myuser","mypass");
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db("mydb", $con);
- if(!isset($_POST['submit'])){
- $q = "SELECT * FROM person WHERE id = $_GET[id]";
- $result = mysql_query($q) or die(mysql_error());
- $person = mysql_fetch_array($result);
- }
- ?>
- <h1>You are Modifying A Record</h1>
- <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
- Name:<input type="text" name="myname" id="myname" value ="<?php echo $person['name']; ?>" /> <br />
- Description: <input type="text" name="mydescription" id="mydescription" value ="<?php echo $person['description']; ?>" /> <br />
- <input type="hidden" name="id" value="<?php echo $_GET['id']; ?>" />
- <input type="submit" name="submit" value="Modify" />
- </form>
- <?php
- if(isset($_POST['submit'])){
- $q = "UPDATE person SET `name`='$_POST[myname]', `description`='$_POST[mydescription]' WHERE id = $_POST[id]";
- mysql_query($q) or die(mysql_error());
- //header('Location: select.php');
- echo 'User has been modified successfully!';
- }else{
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement