I can’t separate the array by commas
I have a problem I cannot separate the array by commas if I put the implode it only shows the first number and not the […]
mysql
Display a number value from mysql query in WP
Anyone have a suggestion on how I can display the result of a SQL query in a WP post or page? The query statement is […]
Improve performance by removing unnecessary database queries
I’ve just found out that main page of custom theme im developing does 150 db queries on every load (what takes even 2.5 seconds). Many […]
I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
My database tables become corrupted so for fixing them I restored data and It shows an error #1067 – Invalid default value for ‘user_registered’ how […]
SQL to join u3g_users & u3g_meta_value with repeating data
I’m using the below SQL to create a table from wordpress user information joining data in u3g_users and u3g_metavalue. The code as it is shows […]
Set a cron job to delete a specific database table table every midnight
my name is frank, i have been trying to create a cronjob that will be deleting a database table every 12 midnight but i found […]
How to edit custom table data in frontend
I am trying to edit the data from the table in the frontend. when I click the edit the form doesn’t anything it show only […]
How to dynamically generate forms from a template, based on user input in the admin area?
I write to the community with the hope that someones can show me the correct way to solve my issue. I’m trying to create a […]
PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
Recently I updated my websites php from 5.6 to 7.2 but afterwards my website sometimes/often shows the internal server error message. I set debug to […]
MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
Usingthe following shortcode function, I have the code building a table by querying the DB. That all works fine. BUT when I add any type […]
Usermeta data unserialize, extract and display in table in WordPress
I would like to know how to extract data from WordPress, unserialize and show it in a table. Below is my starting point. The columns […]
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 […]