Tools, FAQ, Tutorials:
Quoting Date and Time Values in PHP
How To Quote Date and Time Values in SQL Statements in PHP?
✍: FYIcenter.com
If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first one uses a hard-code date value. The second one uses the date() function to return a date value.
<?php include "mysql_connection.php"; $notes = "Added long time ago!"; $time = "1999-01-01 01:02:03"; $sql = "INSERT INTO fyi_links (id, url, notes, time) VALUES (" . " 301, 'www.netscape.com', '".$notes."', '".$time."')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } $notes = "Added today!"; $time = date("Y-m-d H:i:s"); $sql = "INSERT INTO fyi_links (id, url, notes, time) VALUES (" . " 302, 'www.myspace.com', '".$notes."', '".$time."')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted.
⇒ Performing Key Word Search in PHP
2016-10-19, 2441🔥, 0💬
Popular Posts:
How to add request query string Parameters to my Azure API operation to make it more user friendly? ...
How to use the "return-response" Policy statement to build the response from scratch for an Azure AP...
How To Access a Global Variable inside a Function? in PHP? By default, global variables are not acce...
Can You Add Values to an Array without Keys in PHP? Can You Add Values to an Array with a Key? The a...
How to build a test service operation to dump everything from the "context.Request" object in the re...