Insert Query Help!

[Freid001]

I'm not sure what I am doing wrong here but when I run the code it just does nothing. It is supposed to insert new data into the data base but it just does nothing. Not sure why. But if I insert text values not variables it works fine.

 

$time = now();
$sql = "INSERT INTO `posts` (`title`,`image`,`text`,`author`,`date`) VALUES('$title ', '$image', '$text', '$user', '$time')";
$k = $db->prepare($sql);
$k->execute();

 

 

Thanks

[jazzman1]

I think that now() is not a php function is a sql one.

[TOA]

I think that now() is not a php function is a sql one.

 

You are correct

 

OP: try this

$sql = "INSERT INTO `posts` (`title`,`image`,`text`,`author`,`date`) VALUES('$title ', '$image', '$text', '$user', NOW())";
$k = $db->prepare($sql);
$k->execute();

[Freid001]

I have tried to use that but it still does not work.

[TOA]

I have tried to use that but it still does not work.

 

What does that mean?

[Freid001]

Its really wired. When I use the code it works fine if I am inserting just string values. But then when I use variables it just doesn't work for some reason. I not understand why?

[TOA]

But what does 'doesn't work' mean? You get a white page? No results in your db? What?

[Freid001]

I am just getting no result/new entry in the data base if I am inserting variable values. But if I insert just string values it works.

Edited December 19, 2012 by Freid001

[Jessica]

When you echo the SQL what does it say?

Check out the link in my signature on debugging SQL

[Freid001]

When you echo the SQL what does it say?

Check out the link in my signature on debugging SQL

 

I have have used that but it returns nothing just a blank page.

[PFMaBiSmAd]

This is slightly off topic, but why are you using a prepared query statement, but putting php variables directly into the query statement. That defeats the purpose of using a prepared query statement.

[Jessica]

 

 

I have have used that but it returns nothing just a blank page.

Then you need to turn on error reporting to E_ALL.

And PFMaBiSmAd is 100% right.

[Freid001]

Yes I know I did also try using this which is a proper prepared statement I think. But this doesn't work either and I have the same problem. With that code too.

$query = "INSERT INTO posts(`post_title`,`post_image`,`post`,`author`,`time`) VALUES(':post_title', ':post_image', ':$post', ':$user' ,':$time')";

$a=k = $db->prepare($query);
$k->execute(array(':post_title'=>$post_title,':post_image'=>$post_image,':post'=>$post,':user'=>$user,':time'=>$time));

[Freid001]

This is slightly off topic, but why are you using a prepared query statement, but putting php variables directly into the query statement. That defeats the purpose of using a prepared query statement.

 

Yes I know I did also try using this which is a proper prepared statement I think. But this doesn't work either and I have the same problem. With that code too.

$query = "INSERT INTO posts(`post_title`,`post_image`,`post`,`author`,`time`) VALUES(':post_title', ':post_image', ':$post', ':$user' ,':$time')";

$a=k = $db->prepare($query);
$k->execute(array(':post_title'=>$post_title,':post_image'=>$post_image,':post'=>$post,':user'=>$user,':time'=>$time));

Edited December 19, 2012 by Freid001

[Jessica]

In your SQL you are doing ':$post', when it should be :post

 

You NEED to turn on error reporting.

[Freid001]

Ok using this code I can now insert values in to the data base but the value inserted in is :title etc. not the variable value.

 

//Add data to database
$query = "INSERT INTO posts(`title`,`image`,`post`,`author`,`time`) VALUES(':title', ':image', ':post', ':user' ,':time')";
$a = $db->prepare($query);
$a->execute(array(':title'=>$post_title,':image'=>$post_image,':post'=>$post_text,':user'=>$user,':time'=>$time));

Edited December 19, 2012 by Freid001

[Jessica]

In your SQL you are doing ':$post', when it should be :post

 

You NEED to turn on error reporting.

 

So now you have ':post'. Still not right.

[Freid001]

Excellent! It is working now thanks for your help!