wpdb COALESCE won’t work
I am struggling to get the result using COALESCE from custom table. I need to run a second query if the first results null but wpdb resulting query string itself rather than the result.
mysql
Update post if exist from PHP
I want to publish post from php for automation reasons with dynamic data and cronjob.
Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress
I know that there is a very old answer that details unidentified index but using the methods there I can not figure out how to make isset work with the code I have. It is below but doesnt solve the issue. Plus it my error is paired with the PREPARE error AND the fact that … Read more
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?
How to remove Database Table in WordPress via Function file?
I recently installed Rankmath, I am using different Page Builder, Where the content not readable by the Plugin. So I disabled SEO Analysis from Setting. Now I wonder if we can remove this Table from Daba via functions.php. I think removing this table will improve load time.
How to do database for download stats?
So I have a existing wordpress site and we are building now download section for it. Downloads will be custom post type and files. Now we need to have some stats, like number of downloads per cpt (needed) and who downloaded (logged in users) (nice to have). There would few hundred (2009 users each download few files (3-5) each day.
When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
When I used this code, the result/echo display as I wanted.
MySQL Database User: Which Privileges are needed?
The short installation instruction for WordPress (“5 Minutes”) state that:
Using wpdb to connect to a separate database
I want to connect wpdb to another database. How do I create the instance and pass it the database name/username/password?
the_date() not working
I am using wordpress 3.2 and I did a query post like this: