Replace this: $result = $wpdb->get_row(“SELECT * FROM wp44_predefined_address WHERE ‘UPPER(Address1)’ LIKE ‘UPPER(%s)'”, $myinput); with this: (just choose the appropriate $like based on your requirements) // Properly generate the LIKE query. $like=”%” . $wpdb->esc_like( $myinput ) . ‘%’; // e.g. ‘%input%’ //$like=”%” . $wpdb->esc_like( $myinput ); // e.g. ‘%input’ //$like = $wpdb->esc_like( $myinput ) . ‘%’; … Read more
I would implement this as such: Album is a Custom Post Type (CPT). Release date, stores, and store details are post meta-data for the Album CPT. Meta-data can be structured, so one option would be to store all of an album’s store data as an array of associative arrays similar to the following: // You … Read more
Find out the ID of the category that you want to assign. You’ll see it in the URL when editing the category (URL will be something like ?taxonomy=category&tag_ID=3&post_type=post, here 3 is the ID) Assuming that the ID is 3, you can now run this query in your database (eg via PHPMyAdmin) INSERT IGNORE INTO wp_term_relationships … Read more
You can reupload files via ftp, i believe you did via cpanel and filenames corrupted. Also you can use plugin like this https://wordpress.org/plugins/clean-image-filenames/
Add this code to functions.php. It should add meta value to posts from given category. You can use hardcoded category slug/ID, but maybe it would be better to store it in options table and allow to change from dashboard. Change “ID”https://wordpress.stackexchange.com/”category_slug” to your own. /** * @param int $post_ID Post ID. * @param WP_Post $post_after … Read more
Untested, but I believe you can do something like this: add_action( ‘init’, function() { // since were editing content, we want to be very very careful // well do a dry run output first to make sure were doing what we want $dryrun = true; // Regex pattern finds anything between the X and Y … Read more
This is the query generated by the internal search function on WordPress. It is criticised for being inefficient, and there are a few drop-in replacements available as plugins. You may be able to find something that helps you by doing more research around these. For example: https://themeisle.com/blog/improve-internal-search-in-wordpress/ https://winningwp.com/best-wordpress-search-plugins/ I don’t have a specific recommendation to … Read more
Looking at the SQL query in $createSQL, ENGINE=InnoDB” . $wpdb->get_charset_collate() . ” AUTO_INCREMENT=1; yields to: Error in query (1286): Unknown storage engine ‘InnoDBDEFAULT’ To fix it, add a space between the ENGINE=InnoDB (the storage engine) and ” . $wpdb->get_charset_collate() (the charset). You have defined the column id as AUTO_INCREMENT, but the column is not a … Read more
I would have preferred to put this as a comment, but space does not allow for it so sorry about that. It might help you rather than being an answer. I am using ‘product’, but it could just as easy be ‘post’. function update_all() { $args = array( ‘post_type’ => ‘product’, ‘posts_per_page’ => -1, ); … Read more
If you don’t have backup and you need to restore or undo your changes then there is only one way. You have to contact your hosting provider, ask them if they have old database backup. Generally they keep backups. If they will have then request them to restore. Hope this helps!