Using Mysqli bind_param with date and time columns?

by

Like any other string

$stmt = $mysqli->prepare('insert into foo (dt) values (?)');
$dt="2009-04-30 10:09:00";
$stmt->bind_param('s', $dt);
$stmt->execute();

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. How to display errors for my MySQLi query? [duplicate]
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. When should I use MySQLi instead of MySQL?
  6. How to get count of rows in MySQL table using PHP?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. How to test if a MySQL query was successful in modifying database table data?
  12. How can I enable the MySQLi extension in PHP 7?
  13. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  14. How can I use mysqli_fetch_array() twice?
  15. Advantages Of MySQLi over MySQL [closed]
  16. check if the query results empty row mysqli [duplicate]
  17. PHP PDO and MySQLi [duplicate]
  18. using nulls in a mysqli prepared statement
  19. Is mysql_real_escape_string() necessary when using prepared statements?
  20. Updating from MYSQL to MYSQLI [duplicate]
  21. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  22. How to prepare statement for update query? [duplicate]
  23. php password_verify() hash and pass won’t match
  24. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  25. PHP to MySQL SSL Connections
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. PHP prepared statements and transactions in a loop [duplicate]
  29. When should I close a database connection in PHP?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment