MySQL insert not working on new table

Question

I am doing an insert on the MySQL table "analytics" with the fields "a_id" (PRIMARY and UNIQUE), "a_query" and "a_date".

My code:

function queryanalytics($clsendquery) {
     $datetime = date("Y-m-d H:i:s");
     $connection = connectsql();
     $sql = "INSERT INTO analytics (a_query,a_date) VALUES (?,?)";
     $stmt = $connection->prepare($sql);
     $stmt->bind_param('ss',$clsendquery,$datetime);
     $stmt->execute;
     $stmt->close();
 }

Nothing updates in the database and $stmt->affected_rows returns 0. There are no errors in $stmt->error or $connection->error. When I run the insert in phpMyAdmin it works fine.

I have other selects and inserts that work fine with the same connection, why does this one not? Please help me.

score 2 · Accepted Answer · answered Oct 18 '16 at 03:34

2

$stmt->execute; should be $stmt->execute();

answered Oct 18 '16 at 03:34

Irvin

830
5
13

Welp, I sat at this for 2 days. Thank you so much! – Rohr Oct 18 '16 at 03:37
@Rohr Accept the answer so this question be marked as solved. Thanks! – Irvin Oct 18 '16 at 03:38
Just need to wait 9 minutes it seems. – Rohr Oct 18 '16 at 03:39

MySQL insert not working on new table

1 Answers1