Php oop insert date/time in database

Question

I am currently learning OOP, but I can't figure out how to insert date into database. I have tried:

$time=date('now');
$time=date("timestamp");
$time=date("Y-m-d H:i:s");
$time=date("m/d/y g:i A");

When I submit I get error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2014-03-11 14:18:07'' at line 1

I can't figure this out. Before I did use:

$result = mysql_query ("INSERT INTO test (title,url,time) VALUES ('$title','$url',now())");

I tried to use now() , but it does not seem to work. :/

Update:

Insert:

public function insert($cat,$title,$article,$author,$image,$time)
{
    $sql=mysql_query("INSERT INTO blog_posts(cat, title, article, time, author, image) VALUES('$cat', '$title', '$article', '$author', '$image, '$time'");
    if(!$sql)
    {
        echo mysql_error();
    }
}

proccess file:

  $cat=$_POST['cat'];
    $title=$_POST['title'];
    $article= $_POST['article'];
    $author=$_POST['author'];
    $image=$_POST['image'];
    $time= date( 'Y-m-d H:i:s' );

    $n=new db();
    $n->connect();
    $n->insert($cat,$title,$article,$author,$image,$time);

possible duplicate of [MYSQL/PHP: insert current date time using now() in field](http://stackoverflow.com/questions/9841336/mysql-php-insert-current-date-time-using-now-in-field) — mamdouh alramadan, Mar 11 '14 at 14:30
duplicate of http://stackoverflow.com/questions/9841336/mysql-php-insert-current-date-time-using-now-in-field — mamdouh alramadan, Mar 11 '14 at 14:30

score 1 · Answer 1 · answered Mar 11 '14 at 14:40

1

You're missing a quote:

'$author', '$image, '$time'"
               ^^^^^
                HERE

INSERT INTO blog_posts(cat, title, article, time, author, image) VALUES('$cat', '$title', '$article', '$author', '$image', '$time'"

Your parameters are also out of order.

Columns: cat, title, article, time, author, image
Values: '$cat', '$title', '$article', '$author', '$image', '$time'

answered Mar 11 '14 at 14:40

John Conde

217,595
99
455
496

Did you verify that missing quote is there? – John Conde Mar 11 '14 at 14:43
I did! Still no luck. – MeChris Mar 11 '14 at 14:46

score 0 · Accepted Answer · answered Mar 11 '14 at 14:42

Forget about the mysql_* functions.

If you want to create future-proof applications you will use PDO. This is OOP.

$db = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASS);
$db->exec('SET NAMES utf8'); // Set this transfer's charset to utf-8

$title = 'here is a title';
$url = 'here is a URL';
$time= date( 'Y-m-d H:i:s' ); // I dont know what type the time column is. (date, datetime, timestamp)-> ??

$prepare = $db->prepare("INSERT INTO test (title, url, time) VALUES (:title, :url, :time)");
$prepare->bindParam(':title', $title);
$prepare->bindParam(':url', $url);
$prepare->bindParam(':time', $time);

$prepare->execute(); // Run the query, in this case, insert!

If the time column is of type date or datetime, you can use NOW() or CURDATE() like so:

$prepare = $db->prepare("INSERT INTO test (title, url, time) VALUES (:title, :url, NOW())");

score -1 · Answer 3 · answered Mar 11 '14 at 14:28

-1

theres nothing to do with objects in this code.

and the first snippet of code is bascily overwriting all over so its left with the latest. what exactly are you trying to achieve? could you post some more of your code?

if you wish to use mysql OBJECT oriented, use MySQLi or PDO driver.

answered Mar 11 '14 at 14:28

bountyh

165
9

1

This should be a comment. It is not an answer. – John Conde Mar 11 '14 at 14:36
well the problem is i cannot comment as of the moment, and i was asking for more info so i could try to solve he's problem :( – bountyh Mar 11 '14 at 14:39

Php oop insert date/time in database

3 Answers3