Today, I have a issue in $wpdb.
I used
$result = $wpdb->get_var(
$wpdb->prepare(
"SELECT DATE_FORMAT(report_date, '%d-%m-%Y') FROM table WHERE report_id = %d",
$report_id
)
);
The above code not works because of %d in DATE_FORMAT. How i solved this issue in wordpress
Today, I have a issue in $wpdb.
I used
$result = $wpdb->get_var(
$wpdb->prepare(
"SELECT DATE_FORMAT(report_date, '%d-%m-%Y') FROM table WHERE report_id = %d",
$report_id
)
);
The above code not works because of %d in DATE_FORMAT. How i solved this issue in wordpress
Share Improve this question asked Apr 8, 2014 at 18:07 Tamil Selvan CTamil Selvan C 3977 silver badges22 bronze badges1 Answer
Reset to default 5From the Codex page for the WPDB class:
[...] the
prepare
method [...] supports both asprintf()
-like andvsprintf()
-like syntax.
Having a look at PHP's documentation for sprintf()
:
##Example 6 ...
// notice the double %%, this prints a literal '%' character
So you can use
$result = $wpdb->get_var(
$wpdb->prepare(
"SELECT DATE_FORMAT(report_date, '%%d-%%m-%%Y') FROM table WHERE report_id = %d",
$report_id
)
);
for your purposes.