What is the proper way to validate and sanitize JSON response from REST API?
I have read the WordPress page about this but didn’t find a solution.
database
Should close $wpdb via $wpdb->close()
I’ve been writing a few custom plugins for my site and I was wondering about the correct way to interact with $wpdb.
My plugin executes a few queries using the global $wpdb connection.
I noticed that a $wpdb->close(); method has been added to WordPress, to close the database connection object.
why update and delete query not worked in custom table?
this is custom template. I wrote crud by using wordpress query to sent data in custom table of database and get from database, insert query worked, but update and delete query not working. Below I give update and delete query, please suggest if anyone knows?
$wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
I am making a database request in wordpress to make this question:
select * from tc_chat_clt;
Is it good practice to use wpdb->query() function?
I am using custom php code to perform data insertion, deletion, updating and other tasks. I am able to insert data into a table in two different ways,
What is my error trying to create a new table in the database?
I tried creating the tables in different ways and I always get the same error:
“Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘( …… at line 1 of the WordPress database for the CREATE TABLE IF NOT query EXISTS”
Adding prefix to WordPress database tables breaks admin capabilities?
I have attempted a few different ways (manually, using Brozzme’s DB Prefix Tools & Addons plugin) to add a prefix to an older WP database (right now table names look like posts instead of wp_posts or stx_posts, etc.).
What structure should post_content have in the database?
Let me start off by saying that I have no WordPress experience at all so I may be asking a really stupid question. What I need to do is transfer a bunch of articles from a old MySQL database to a WordPress site.
Any other way of storing plugin admin data setting
I created a plugin, and used the add_admin_menu() to add some page for users to put their Api keys and secret word.
My page content is just a form to collect those data the users puts in, now my question is apart from sending data to database as to always retrieve them there, is there another place i can store those keys and secret word?
Writing a function for WP Cron to run a SQL command daily
I usually use the events manager in PHP MyAdmin to set up scheduled events but since migrating to WP Engine they do not allow it and I must write a function to use WP Cron instead. What should this look like written as a WP function?