Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_POST['update']))
- {
- $dbhost = 'host';
- $dbuser = 'user';
- $dbpass = 'password';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- if(! $conn )
- {
- die('Could not connect: ' . mysql_error());
- }
- $name= $_POST['name'];
- $sql = "UPDATE table SET name='$name' WHERE id='$id'";
- mysql_select_db('my_db');
- $retval = mysql_query( $sql, $conn );
- if(! $retval )
- {
- die('Could not update data: ' . mysql_error());
- }
- echo "Success">";
- mysql_close($conn);
- }
- else
- {
- include"db.inc.php";
- $id = $_GET["id"];
- $order = "SELECT * FROM table where id='$id'";
- $result = mysql_query($order);
- $row = mysql_fetch_array($result);
- }
- ?>
- <form id="update" name="update" method="post" role="form" action="">
- <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
- <input name="update" type="submit" id="update" value="Save">
- </form>
- <?php
- }
- ?>
- if(isset($_POST['update']))
- {
- $dbhost = 'host';
- $dbuser = 'user';
- $dbpass = 'password';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- if(! $conn )
- {
- die('Could not connect: ' . mysql_error());
- }
- $name= $_POST['name'];
- mysql_select_db('my_db');
- $sql = "UPDATE table SET name='$name' WHERE id='$id'";
- $retval = mysql_query( $sql, $conn );
- if(! $retval )
- {
- die('Could not update data: ' . mysql_error());
- }
- else{
- echo "Success";}
- mysql_close($conn);
- }
- else
- {
- include"db.inc.php";
- $id = $_GET["id"];
- $order = "SELECT * FROM table where id='$id'";
- $result = mysql_query($order);
- $row = mysql_fetch_array($result);
- }
- ?>
- <form id="update" name="update" method="post" role="form" action="">
- <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
- <input name="update" type="submit" id="update" value="Save">
- </form>
- <?php
- }
- ?>
- $id = $_GET["id"];
- $name= $_POST['name'];
- <form id="update" name="update" method="post" role="form" action="">
- <input type="hidden" id="id" name="id" value="<? echo "$row[id]"?>" />
- <input type="text" id="name" name="name" value="<? echo "$row[name]"?>" />
- <input name="update" type="submit" id="update" value="Save">
- $id = $_GET["id"];
- $name= $_POST['name'];
Add Comment
Please, Sign In to add comment