Advertisement
Guest User

Untitled

a guest
Dec 20th, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. $myDb = new mysqli($hostname, $username, $password, $database);
  2.  
  3. if($myDb->connect_errno > 0){
  4. die('Unable to connect to database [' . $myDb->connect_error . ']');
  5. }
  6.  
  7. $statment = $myDb->prepare("INSERT INTO user(name,surname,age)
  8. VALUES (?,?,?)");
  9. $statement->bind_param('s', $_POST['name']);
  10. $statement->bind_param('s', $_POST['surname']);
  11. $statement->bind_param('i', 25);
  12.  
  13.  
  14. $statement->execute();
  15.  
  16. $statement->free_result();
  17.  
  18. Binding parameters failed: (0) Execute failed: (2031) No data supplied for parameters in prepared statement
  19.  
  20. $myDb = new mysqli($hostname, $username, $password, $database);
  21.  
  22. if($myDb->connect_errno > 0){
  23. die('Unable to connect to database [' . $myDb->connect_error . ']');
  24. }
  25.  
  26. $statment = $myDb->prepare("INSERT INTO user(name,surname,age)
  27. VALUES (?,?,?)");
  28. $statement->bind_param('s', $name);
  29. $statement->bind_param('s', $surname);
  30. $statement->bind_param('i', $age);
  31.  
  32. $name = $_POST['name'];
  33. $surname = $_POST['surname'];
  34. $age = 25;
  35.  
  36.  
  37. $statement->execute();
  38.  
  39. $statement->free_result();
  40.  
  41. $myDb = new mysqli($hostname, $username, $password, $database);
  42.  
  43. if($myDb->connect_errno > 0){
  44. die('Unable to connect to database [' . $myDb->connect_error . ']');
  45. }
  46.  
  47. $statement = $myDb->prepare("INSERT INTO user (name,surname,age) VALUES (?,?,25)");
  48. $statement->bind_param('ss', $_POST['name'], $_POST['surname']);
  49.  
  50. $statement->execute();
  51.  
  52. $statement->free_result();
  53. $statement->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement