The following should do the trick: global $wpdb ; // get the post_ids from the custom table $sql = “SELECT listing_id FROM {$wpdb->prefix}wpdbdp_listing_fees WHERE fee_id = %d” ; $sql = $wpdb->prepare ($sql, 4) ; $post_ids = $wpdb->get_col ($sql) ; // get the custom posts from the posts table $args = array ( ‘post__in’ => $post_ids, … Read more
Custom queries will be better choice for you. I hope this will help you to start WordPress custom queries
So the best way here would be for your other system to “call” WordPress any time something changes… You could build a WordPress plugin that listens for a specific ajax call and upon receiving the new data, it could create / update the custom post type in your WordPress site. Some things to remember: Make … Read more
After renaming MySQL database, I can no longer access my Blog page
Sounds like a single “book” post type would be most appropriate. You could then add custom postmeta, which does not require Advanced Custom Fields. I would create the post type and custom fields first, test them out to make sure they’re saving appropriately to the database. Then, you can do a foreach loop for each … Read more
What about something like this ? $custom_row = array(array(‘race_id’ => ‘1’, ‘race_name’ => ‘2’, ‘race_date’ => ‘3’)); $races = $wpdb->get_results(” select r.race_name ,r.race_id ,date_format(r.race_date,’%c.%d.%Y’) race_date from race_calendar r order by r.race_date; “, ARRAY_N); $merged_arr = array_merge($custom_row, $races); foreach ( $merged_arr as $race ) { echo $race[‘race_id’] . ‘,’ . $race[‘race_name’] . ‘,’ . $race[‘race_date’]; } … Read more
spambot registering without providing email or password, bypassing registration process
How to change link in all posts?
I wasn’t thorough enough initially. Old wp-config.php files were found in my downloads folder. It looked like these files came from the zip file Duplicator created when copying my live site. These files contained config information to my live site database. After deleting them, the problem has gone away.
One option would be to create a custom page template. Within that template, you can check for POSTed variables. Something to the effect of: <?php /* * Template Name: Login form */ if(!empty($_POST[‘username’])) { // check credentials and if valid display data } else { // display login form } Once you’ve created this file … Read more