Database

I have include wp-config, should I add global $wpdb also?

If you need a processing endpoint with access to the WordPress API, use the admin_post_ action and eliminate the need to manually include wp-config.php or any other WordPress files. // add for logged-in visitors add_action( ‘admin_post_your_action’, ‘prefix_your_action_function’ ); // for non logged-in visitors add_action( ‘admin_post_nopriv_your_action’, ‘prefix_your_action_function’ ); function prefix_your_action_function() { global $wpdb; // your processing … Read more

How to get Attachments(image) with specific width\height ratio

The _wp_attachment_metadata stores serialized data. It’s not meant to be used directly in queries to match results. Instead hook add_attachment action and store original image’s dimensions into separate post meta properties. After you’re happy with how it works follow Rarst’s advice and find a way to walk all existent image attachments and generate those meta … Read more

Weird characters displayed when importing WordPress MySQL db

Can you try setting the DB Charset within wp-config.php? define(‘DB_CHARSET’, ‘utf8_general_ci’); define(‘DB_COLLATE’, ‘utf8_general_ci’); Have a read of this first though: https://codex.wordpress.org/Editing_wp-config.php It can cause problems to an already existing blog to add those lines into wp-config.php, so use with caution. Are you importing this through WordPress or manually through something like PhpMyAdmin? Also, are all … Read more

Create Tables in WordPress

Since you are a first timer (Welcome to the WordPress World, by the way) an easy way to achieve that is using plugins. For forms, I recommend Contact Form 7 (https://wordpress.org/plugins/contact-form-7/). It will allows you to create almost any type of form. To record the data into database and display as table, you can use … Read more

Query does not filter duplicate _sku numbers

I haven’t tested this, but this should give you the count of skus for each post_id: SELECT post_id, COUNT(`post_id`) AS sku_count FROM `wp_postmeta` WHERE `meta_key` LIKE ‘%sku%’ GROUP BY `post_id` To have it return only rows where the count is greater than one is trickier. Off the top of my head I’d probably use the … Read more

+ More