Advertisement
Guest User

Untitled

a guest
Apr 10th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. Notice: Undefined index: soft_id in C:xampphtdocsSLRUpdate S110 PC01.php on line 14
  2.  
  3. Notice: Undefined index: soft_name in C:xampphtdocsSLRUpdate S110 PC01.php on line 15
  4.  
  5. Notice: Undefined index: installed_date in C:xampphtdocsSLRUpdate S110 PC01.php on line 16
  6.  
  7. Notice: Undefined index: expiry_date in C:xampphtdocsSLRUpdate S110 PC01.php on line 17
  8.  
  9. Notice: Undefined index: product_key in C:xampphtdocsSLRUpdate S110 PC01.php on line 18
  10.  
  11. Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:xampphtdocsSLRUpdate S110 PC01.php:22 Stack trace: #0 {main} thrown in C:xampphtdocsSLRUpdate S110 PC01.php on line 22
  12.  
  13. <?php
  14. $servername = "localhost";
  15. $username = "root";
  16. $password = "";
  17. $dbname = "slr";
  18.  
  19. // Create connection
  20. $conn = new mysqli($servername, $username, $password, $dbname);
  21. // Check connection
  22. if ($conn->connect_error) {
  23. die("Connection failed: " . $conn->connect_error);
  24. }
  25.  
  26. $soft_id = $_POST['soft_id'];
  27. $soft_name = $_POST['soft_name'];
  28. $installed_date = $_POST['installed_date'];
  29. $expiry_date = $_POST['expiry_date'];
  30. $product_key = $_POST['product_key'];
  31.  
  32. $sql = "UPDATE s110_pc01 ". "SET soft_name = $soft_name ".
  33. "WHERE soft_id = $soft_id" ;
  34. $retval = mysql_query( $sql, $link );
  35.  
  36.  
  37. if($retval ) {
  38. echo "Updated data successfullyn";
  39. } else {
  40. die('Could not update data: ' . mysql_error());
  41. mysql_close($link);
  42. }
  43. ?>
  44. <form method = "post" action = "<?php $_PHP_SELF ?>">
  45. <table width = "400" border =" 0" cellspacing = "1"
  46. cellpadding = "2">
  47.  
  48. <tr>
  49. <td width = "100">Software ID</td>
  50. <td><input name = "soft_id" type = "text"
  51. id = "soft_id"></td>
  52. </tr>
  53.  
  54. <tr>
  55. <td width = "100">Software Name</td>
  56. <td><input name = "soft_name" type = "text"
  57. id = "soft_name"></td>
  58. </tr>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement