Whats the best practise on how to store json data from a custom settings page?
Whats the best practise on how to store json data from a custom settings page?
Database
How to insert a value to decimal type field using wpdb->prepare?
How to insert a value to decimal type field using wpdb->prepare?
How to get the full stack trace for WordPress “table doesn’t exist” error in debug.log?
You are not seeing a stack trace because this information is being logged via the error_log() function within the wpdb::print_error() method. error_log() simply sends a message to the logs. The behaviour you’re expecting with a full stack trace would require trigger_error() to be used.
get posts whether meta_key exists or not
Thanks to @Hobo’s answer which gave me the clue for moving pm2 condition to the join statement SELECT p.ID, p.post_content, p.post_title, p.post_excerpt, pm1.meta_value as meal_date, pm2.meta_value as meal_plan, t.name as meal_type FROM wp_posts AS p LEFT JOIN wp_term_relationships AS r ON (p.ID = r.object_id) INNER JOIN wp_term_taxonomy AS x ON (r.term_taxonomy_id = x.term_taxonomy_id) INNER JOIN … Read more
is it right choose to connect database in template page directly in WordPress site?
If you make data manipulations with mysqli_connect() right, according to database structure etc, it will not break your site. But it’s more safe and logical to use build-in functions to manipulate database data. (Some standarts exists). WordPress has a lot of functions, which allows you to manipulate each wp table’s data. Here are some simple … Read more
Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
You can use below WordPress function to sanitize the value: sanitize_text_field( $_POST[‘keyword’] ); You can also check more detail here: https://developer.wordpress.org/reference/functions/sanitize_text_field/
Wpdb query with dynamic table name
I will start with the question. From the sql error output we see this SELECT * FROM WHERE dbID = 719 This tells us that $sanitized_search_language has no value, so check it first. Now for the BIG problem with this query! You used get_results with a sql query that has variables as is, get_results doesn’t … Read more
Deleting empty meta key values
Deleting empty meta key values
User set date and time from frontend doesn’t get stored into database
Got it to work by formatting the $dateAndTime string like this before binding it: $formattedDateAndTime = date(“Y-m-d H:i:s”, strtotime($dateAndTime));
SELECT rows between two datetimes when the range is dynamic [closed]
That error itself is not specific to WordPress, which means even if you used phpMyAdmin or the MySQL command line interface to execute the same query with the dates not enclosed in quotes, you would still get the same error. Therefore for string literals like the 2021-06-01 04:00:00 (a DATETIME literal) in the error, you … Read more