Reply to thread

Message

<blockquote data-quote="Zaka" data-source="post: 396864" data-attributes="member: 12728">First of all I would suggest that you don't mix params with pure data. Now for the answer I think you get an error because you don't define the 3rd value in bindParam which is the data type. Personally I just use array inside of execute which is much easier. I would do it as follows.[PHP]$stmm = $dbh-&gt;prepare(&quot;INSERT INTO hk_logs (staff, action, timestamp) VALUES (:username, :action, :timestamp));$params = [&nbsp; &nbsp; &quot;username&quot; =&gt; $_SESSION['username'],&nbsp; &nbsp; &quot;action&quot; =&gt; &quot;Logged in Successfully&quot;,&nbsp; &nbsp; &quot;timestamp&quot; =&gt; time()];$stmm-&gt;execute($params);[/PHP]EDIT: It could also be the fact that you use time() directly. I don't know why, but sometimes I've gotten errors when I've used time() directly instead of saving it to a variable and then append the variable instead.</blockquote>

[QUOTE="Zaka, post: 396864, member: 12728"] First of all I would suggest that you don't mix params with pure data. Now for the answer I think you get an error because you don't define the 3rd value in bindParam which is the data type. Personally I just use array inside of execute which is much easier. I would do it as follows. [PHP]$stmm = $dbh->prepare("INSERT INTO hk_logs (staff, action, timestamp) VALUES (:username, :action, :timestamp)); $params = [ "username" => $_SESSION['username'], "action" => "Logged in Successfully", "timestamp" => time() ]; $stmm->execute($params); [/PHP] [B]EDIT:[/B] It could also be the fact that you use time() directly. I don't know why, but sometimes I've gotten errors when I've used time() directly instead of saving it to a variable and then append the variable instead. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members