sql - Read For Learn

Create Array from data in the OPTIONS table

$all_options = wp_load_alloptions(); $plugin_order_options = array(); foreach( $all_options as $name => $value ) { if(stristr($name, ‘plugin_order_’)) $plugin_order_options[$name] = $value; } print_r($plugin_order_options); In plain English: We load all WP options in $all_options. We copy options from $all_options to $plugin_order_options if their name contains plugin_order_. We print $plugin_order_options. We scratch our head, unhappy with the size of … Read more

SQL error on restoring database

I think the best way to do it is just go direct into your phpmyadmin and export your database

Creates only one table and not the other

dbdelta demands that: You must put each field on its own line in your SQL statement. You must have two spaces between the words PRIMARY KEY and the definition of your primary key. You must use the key word KEY rather than its synonym INDEX and you must include at least one KEY. You must … Read more

Alter the main search query to search posts by coauthor user name

I ended up figuring this out by realizing that I could build a list of coauthor id’s using the template tags that ship with the coauthors plugin. Next, I observed how WordPress core does joins to query by taxonomy, but var_dumping the posts_request on a term archive page. At that point, I just had to … Read more

Link wordpress with a SQl + MongoDB + .NET

Sum of Custom Meta written by Authour

Maybe not the most elegant solution $authorPost = get_posts(array(‘author’ => 1));foreach ($catPost as $post) { setup_postdata($post); $ids[] = get_the_ID(); } $idList = implode(“,”, $ids); //turn the array into a comma delimited list $meta_key = ‘post_view’; $allview = $wpdb->get_var($wpdb->prepare(” SELECT sum(meta_value) FROM $wpdb->postmeta WHERE meta_key = %s AND post_id in (” . $idList . “)”, $meta_key)); … Read more

Insert query not working for non-logged in user

Custom database query to validate data

Assuming that all of your sql column names are correct, something like this should work: if(isset($_POST[‘submit’])){ global $wpdb; $tablename= $wpdb . ‘form_subscribe’; $myrows = $wpdb->get_var( $wpdb->prepare(“SELECT email FROM $tablename WHERE email=%s LIMIT 1″, $_POST[’email’])); if(empty($myrows)){ $data=array( ‘name’ => $_POST[‘fullname’], ‘age’ => $_POST[‘age’], ’email’ => $_POST[’email’] ); $wpdb->insert( $tablename, $data); } else { $status=”User already subscribed”; … Read more

Can not manually create a database ( db, user, pass ) for a plugin

As per GentlemanMax’s comment, you’ll want a table. There’s a really useful guide in the Codex (which also goes into how to do DB upgrades / migrations.) One thing I’d emphasise: make sure to use $wpdb->prefix in the table name because not all sites will have tables beginning wp_*. Also, if you’re ever planning to … Read more

How can I avoid duplicate primary keys in SQL import?

+ More