Basically, i use Contact Form 7 and it’s third party extension for storing values in database i.e.: https://wordpress.org/plugins/contact-form-cfdb7/. Or, if you want to create a custom form and store the value in database you can Create a Custom Post Type and use wp_insert_post() function to insert your respective values.
OK, so the problem is pretty clear to explain. These posts are sorted as three different groups: ‘yes’ ” null That’s because empty value (”) is not the same as null (not existing values). One way to solve it will be to use custom posts_orderby filter. You can use case statement: order by case when … Read more
Summary: WordPress does run date_default_timezone_set( ‘UTC’ );. It does have a timezone option modifiable by the admins and retrieved using get_option( ‘timezone_string’ ). However, none of that has any effect on the query run through $wpdb. You should get the same results from $wpdb as if you had run the MySQL query without WordPress. Details … Read more
There’s the WordPress meta API for retrieving meta values from the wp_postmeta table, but the API doesn’t provide a function for retrieving the post ID (post_id value), but you can use custom SQL as in your code. However, $wpdb->get_col() returns an array of values (upon success), so that’s why you get the “Array” when you … Read more
Looking at your query, I see lots of stuff like wp_posts.post_content LIKE ‘%اهمية%’. You should know that column LIKE ‘%matchstring%’ is a notorious MySQL performance-killer. If you can change your operations to use column LIKE ‘matchstring%’ (with no leading %) this will get better. Or, maybe it makes sense for you to adopt a search … Read more
see: How To Modify New Sub Blog Immediately When Super Administrator Creates It? The code I wanted to post I unfortunately could not post beacause “body is limited to 30000 characters; you entered 62367” so … the following filters are handy (from WordPressMU plugin for site admin to set defaults for new blogs, Deanna Schneider) … Read more
WPMUdev has a Multi-DB plugin but you won’t see any performance gains from splitting your database up unless you have a very high volume of sites with thousands of tables. From the plugin instructions: Step 1: Decide how many databases you want (16, 256, 4096) So, how do you know that this plugin is necessary … Read more
Got a partial solution, but requires VPS to run it as shared hosting has a restriction on what you can do with a cursor. Anyway, DROP PROCEDURE IF EXISTS `update_all_options`; DELIMITER // CREATE PROCEDURE update_all_options( IN db varchar(255), IN theoption varchar(255), IN set_val VARCHAR(255) ) BEGIN DECLARE table_val VARCHAR(255); — Declare variables used just for … Read more
Here is a bait-and-switch approach to deleting all those rows: CREATE TABLE wp_posts_new LIKE wp_posts; ALTER TABLE wp_posts_new DISABLE KEYS; INSERT INTO wp_posts_new SELECT * FROM wp_posts WHERE post_type’http’ AND post_title<>’GET http://twitter.com/statuses/user_timeline/@xcentric.json?count=100′; ALTER TABLE wp_posts_new ENABLE KEYS; ALTER TABLE wp_posts RENAME wp_posts_old; ALTER TABLE wp_posts_new RENAME wp_posts; Now start using you website. When you are … Read more
Meta queries are essentially wrapper for ease of setup, but end results is part of SQL query to run on MySQL database. These operators are those of MySQL, see in documentation: LIKE operator (performs pattern matching) IN() function (checks if value is in set)