mysql - Read For Learn

Store GA Client ID in User DB

How to display MySQL table data which is stored as an array?

I would like to replace those arrays with real values. Is it possible? I am assuming you want to access and print those two variables which is shown as “Array” in the print out (contact, question_answers_array) Solution as follows – replace your foreach look with below (I didn’t test code but should give you an … Read more

SQL: How to find all attachments that are not used in any posts/pages/custom_post_types

What you seek isn’t truly possible. You can get sort of close, but you cannot definitively say if an attachment is or isn’t in use. We can get somewhere close to a solution, but to do this we will need to process each attachment individually. So first, get a list of all the IDs of … Read more

I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress

I ran into the same problem just now, when I upgraded to PHP 7.4 & removed the older version. If you are on Nginx server, you need to update the configuration file location ~* \.php$ { fastcgi_pass unix:/run/php/php7.4-fpm.sock;

WordPress Bad Request Error 400

Custom post type and custom taxonomy key lenght & query performance

I’m not sure about the sort of precise figures a performance/algorithm researcher would be looking for. However, in terms of actual performance there is no difference. The WP database can take a beating and I’ve done plugins with dozens and dozens of filters and hooks and queries and they still run very very fast. Furthermore, … Read more

Remove escape characters from JSON string pulled from a database

You probably need to decode JSON string to use in the JS code, so something like let parsedItem = <?php echo stripslashes($result->myJson); ?>; Note that you will get JSON object, so no need to call JSON.parse there. I added stripslashes to remove extra \” from json string loaded from database.

Displaying data from custom table

OK, so maybe the above wasn’t worded very well? I have since made some progress as follows: global $wpdb; $current_user = wp_get_current_user(); $uid = $current_user->ID; $fname = $current_user->first_name . ” ” . $current_user->last_name; $email = $current_user->user_email; $studentTable = $wpdb->prefix.’um_metadata’; $result = $wpdb->get_results ( “SELECT * FROM $studentTable WHERE `user_id` = $uid AND ‘um_key’ = ‘student_number’ … Read more

Error establishing a database connection – WordPress setup, everything else is working

Ended up re-creating the db accounts and it worked afterwards.

Mysql update menu_order problem

UPDATE phiz_posts p SET menu_order = 1 WHERE ID NOT IN (SELECT post_id FROM phiz_postmeta WHERE meta_key = ‘_thumbnail_id’) AND post_type=”product” AND post_status=”publish”

+ More