The default search is handled by WP_Query mostly by a method called parse_search(), which is triggered by the s parameter. You can search the source of WP_Query for is_search and piece together a few other bits and pieces. Or you can just create a query… $s = new WP_Query(array(‘s’ => ‘test’)); … dump the SQL… … Read more
First, you’re using prepare() wrong. Should be this: $wpdb->prepare(“SELECT Active FROM testers WHERE user_id = %s”, $user_id) Or even better (%d) represents numeric value as oppose to %s which is string: $wpdb->prepare(“SELECT Active FROM testers WHERE user_id = %d”, $user_id) If you have any debugging enabled, it will throw an error from your code. Which … Read more
Coming from a different angle, have you looked into adding indexes to the relevant tables to maximize efficiency? Sometimes the right index can make an amazing difference, even when the files aren’t particularly large. When they are as big as yours the difference could be all you need. You mentioned that you host the server … Read more
If you’ve got access to the mysql database, you can change the grant tables directly: UPDATE mysql.user SET Host=”%” WHERE Host=”localhost” AND User=”username”; …and an analogous UPDATE-statement to change it back. Also you might need to make changes to the mysql.db table as well: UPDATE mysql.db SET Host=”%” WHERE Host=”localhost” AND User=”username”; and then flush … Read more
Since there are going to be more than one post (lesson) per user, your code would be more like this: <?php if ( is_user_logged_in() ) { $user_ID = get_current_user_id(); $post_ID = get_the_ID(); $viewed = get_user_meta( $user_ID, ‘viewed_lesson_tracking’, true); if(empty($viewed)){ $viewed = array(); } $viewed[] = $post_ID add_user_meta( $user_ID, ‘viewed_lesson_tracking’, $viewed ); // tracks that user … Read more
WordPress absolutely does need “DELETE“, otherwise it has no way to delete posts or tags or options rows or anything else. The “DROP” command is sometimes used during upgrades, although it’s been a long time. The last time I think it was used was during the WordPress 2.3 update, which removed the assorted categories tables … Read more
there are two possible injection vectors, server side and client side server side – Just don’t write your own SQL and use the more high level DB access APIs, in your case probably update_option. If you must to access the DB at lower level make sure the API use wpdb::prepare while generating the SQL, which … Read more
I think you will require to custom develop some part of it but most of it can be done with Contact Form 7 plugin. You can create forms with upload fields very easily in Contact Form 7. And you can make it visible for loggenin users only like this. <?php if ( is_user_logged_in() ) { … Read more
Ditto Otto – Q: “What is your suggestion on running a large database?” A: Don’t do it on shared hosting. Shared hosts have CPU limits, so any queries run on a database that large will be slow or time out. Shared hosts also have database size limits, so your database with 500K posts may be … Read more
Why do your own database queries? Use the WP functions to do it for you. $empid = (int) $_REQUEST[’empid’]; $name = get_user_meta($empid, ‘first_name’, true) . ‘ ‘ . get_user_meta($empid, ‘last_name’, true);