phpMyAdmin is software typically installed by your host and available via your hosting control panel, it is not part of WordPress. A search on web for [your host] phpMyAdmin will probably tell you what you need to do.
Ideally, post meta should never be stored in a serialized form to begin with, thus making it easy to query. If the code uses the standard methods for storing meta instead of self-serializing it, then each item would be in its own row and easily queryable. If the data is stored serialized, then you have … Read more
$wpdb is a global variable. You have to take it into your function’s scope first … global $wpdb; $wpdb->insert(); … or access it per $GLOBALS … $GLOBALS[‘wpdb’]->insert(); And I would use always lowercase keys; this is just a useful convention.
There’s a wpdb class in WordPress for you to be able to read/write DB. To get variable from table, use $wpdb->get_var function. This way: //set current page ID or define ID in another way – depends on your code $my_page_id = get_the_ID(); global $wpdb; $ListingID = $wpdb->get_var( “SELECT listing_id FROM “.$wpdb->prefix.”fsrep_listings WHERE ID = ” … Read more
Look at your conditions: WHERE ( ( (meta_key=’user_school_subjects’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_professional_courses’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_language_tutoring’ AND meta_value LIKE ‘%history%’) OR (meta_key=’user_music_tutoring’ AND meta_value LIKE ‘%history%’) ) AND (meta_key=’user_gender’ AND meta_value=”male”)) There is no way that you can have a meta key matching one of these– user_school_subjects, user_professional_courses, user_language_tutoring, user_music_tutoring … … Read more
SELECT * FROM wp_posts, wp_2_posts, wp_3_posts WHERE wp_posts.post_content LIKE ‘%foo’ OR wp_2_posts.post_content LIKE ‘%foo’ OR wp_3_posts.post_content LIKE ‘%foo’; should do the trick. (Note that in Multisite, there shouldn’t be a wp_1_posts — your root site uses wp_posts etc.)
The function bbp_forum_id() will directly echo its value, you want to use bbp_get_forum_id() which will return the value for use in the context of an API call.
If you’re not using WP’s built in Ajax handlers, which includes things for you, you will need to include the WP core yourself. Try adding define(‘WP_USE_THEMES’, false); global $wpdb; require(BASE_PATH . ‘wp-load.php’); to the top of your file. I should point out that the path to wp-load.php may not be the same and hard coding … Read more
Queries ofcourse. It’s faster… But in this case just please delete you wp site and start with something faster… here is my superfast framework for you… <?php /*Your bunny wrote */ I did tests, 0.0000001 runtime vs WP usually 0.7-2.8 Sarcasm off P/S/ This question have no sence since using direct queries and output of … Read more
I figured out my error in the query, Thank you all guys for responding, I just gave the piece of code <?php global $wpdb; $contactus_table = $wpdb->prefix.”contactus”; //error with the query $sql = “INSERT INTO $contactus_table (firstname, lastname, email, query, reg_date) VALUES (‘$firstName’, ‘$lastName’, ‘$email’, ‘$query’, CURRENT_TIMESTAMP)”; if($wpdb->query($sql)) { $BlogName = get_bloginfo(); echo $BlogName; } … Read more