Advertisement
Guest User

Untitled

a guest
May 10th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. <?
  2. $IdVar = $_POST['rowId'];
  3. $DataVar = $_POST['NewData'];
  4.  
  5.  
  6.  
  7. $server = "localhost"; // MySQL hostname
  8. $username = "xxxxxx"; // MySQL username
  9. $password = "xxxxxx"; // MySQL password
  10. $dbname = "test"; // MySQL db name
  11.  
  12. $db = mysql_connect($server, $username, $password) or die(mysql_error());
  13. mysql_select_db($dbname) or die(mysql_error());
  14.  
  15.  
  16. $result = mysql_query("update testDb SET username ='$DataVar' WHERE ID = '$IdVar'");
  17. if (!$result) {
  18. die('Invalid query: ' . mysql_error());
  19. }
  20.  
  21. echo "Success";
  22.  
  23. ?>
  24.  
  25. echo ( mysql_affected_rows() > 0 ) ? "Success update" : "No rows update";
  26.  
  27. $result = mysql_query("update testDb SET username ='$DataVar' WHERE ID = '$IdVar'");
  28.  
  29. if(mysql_errno($db)!=0) echo "Something went wrong";
  30.  
  31. $result = mysql_query("update testDb SET username ='Rolf' WHERE ID = '3'")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement