How can I use a MySQL function in my PHP query code?

Question

I'm trying to convert a string "date" value from a submitted form into an actual date while doing my insert query. I thought I could use the MySQL function str_to_date, but I'm getting an error message.

Here's my code; this is a Joomla site, so the JRequest::getVar calls are joomla's way of getting submitted _post variables.

$query = "insert into jos_customers_addresses (customer_id,nickname,birthdate)
values ("
        .$db->quote($userAcctID).","
        .$db->quote($nickname).","
        .$db->quote(STR_TO_DATE(JRequest::getVar('birthdate'),'%m/%d/%Y'))
.")";

I've also tried the birthdate line without the $db->quote, but got the same error. The error message is:

Fatal error: Call to undefined function STR_TO_DATE() in /var/www/html/mysite.com/components/com_arrcard/models/checkoutpay.php on line 156

where line 156 is the line containing the str_to_date call. Any ideas?

Ignacio Vazquez-Abrams · Accepted Answer · 2010-11-16 17:11:07Z

3

Put it in the query, not the code.

."STR_TO_DATE(".$db->quote(JRequest::getVar('birthdate')).",'%m/%d/%Y')"

answered Nov 16, 2010 at 17:11

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I use a MySQL function in my PHP query code?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related