Advertisement
Guest User

Untitled

a guest
Apr 11th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.15 KB | None | 0 0
  1. Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:xampphtdocsSLRUpdate S110 PC01.php on line 24
  2. Could not Update data:
  3.  
  4. <?php
  5.  
  6. $host="localhost"; // Host name
  7. $username="root"; // Mysql username
  8. $password=""; // Mysql password
  9. $db_name="slr"; // Database name
  10. $tbl_name="s110_pc01"; // Table name
  11.  
  12. // Connect to server and select database.
  13. $link = mysqli_connect("$host", "$username", "$password")or die("cannot connect");
  14. mysqli_select_db($link, $db_name)or die("cannot select DB");
  15.  
  16. // Get values from form
  17. $soft_name=$_POST['soft_name'];
  18. $installed_date=$_POST['installed_date'];
  19. $expiry_date=$_POST['expiry_date'];
  20. $product_key=$_POST['product_key'];
  21.  
  22.  
  23. $sql = "UPDATE SET soft_name='$_POST[soft_name]', installed_date='$_POST[installed_date]', expiry_date='$_POST[expiry_date]', product_key='$_POST[product_key]' WHERE soft_id='$_POST[soft_id]'";
  24. $result=mysqli_query($link,$sql);
  25. if(! $result )
  26. {
  27. die('Could not Update data: ' . mysqli_error());
  28. }
  29. echo "Successfully updatedn";
  30. mysqli_close($con);
  31. ?>
  32. <input type="button"value="Finish"onclick="window.location.href='Update S110 PC01 Data.php'">
  33. </form>
  34. </table>
  35. </div>
  36. </body>
  37. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement