PHP bindParam with mysql function

Question

Is it possible to use OOP of PHP where I could bind_param with mysql build-in functions?

I have a following code which gives me an error of:

Fatal error:  Call to undefined function FROM_UNIXTIME() in...

And the code is:

$sql = $connection->prepare("INSERT INTO table_name (value1, value2, value3)
                             VALUES (?, ?, ?)");

$sql->bind_param('sss', $value1, $value2, FROM_UNIXTIME(" . $value3) . "));
$db -> query($sql, $connection);

As far as I understand from the error PHP does not offer FROM_UNIXTIME() method therefore my problem is that bind_param compiles string from my query into some-kin-of code which then is sent to mysql db. As where I could sent FROM_UNIXTIME as a string in a query then mysql would understand that method and act accordingly.

Anyway how can I run such a query with bind_param? I tried to convert my date-time to timestamp and put the output into the query but mysql shows only zeros in the table.

`VALUES (?, ?, FROM_UNIXTIME(?))` – u_mulder Nov 08 '15 at 11:17 — u_mulder, Nov 08 '15 at 11:17
Can you post it as answer because it works!!! – Lenny Nov 08 '15 at 11:19 — Lenny, Nov 08 '15 at 11:19

score 1 · Accepted Answer · answered Nov 08 '15 at 11:21

1

If you want to use placeholders as arguments of mysql-functions - do it:

$sql = $connection->prepare("INSERT INTO table_name (value1, value2, value3) VALUES (?, ?, FROM_UNIXTIME(?))");
$sql->bind_param('sss', $value1, $value2, $value3);

answered Nov 08 '15 at 11:21

u_mulder

54,101
5
48
64

PHP bindParam with mysql function

1 Answers1