Database

how to SELECT meta values that are not null?

I founded myself my searching: $sql = $wpdb->prepare( ” SELECT meta_value FROM {$wpdb->prefix}commentmeta INNER JOIN {$wpdb->prefix}comments ON {$wpdb->prefix}commentmeta.comment_id = {$wpdb->prefix}comments.comment_ID WHERE comment_post_ID = %d AND meta_key = ‘rating’ AND meta_value IS NOT NULL AND meta_value <> ” “, get_the_ID() ); $results = $wpdb->get_results( $sql );

Troubles when I want to connect to another DB

Use code as below : <?php $myotherdatabase = new wpdb(“username”,”password”,”databasename”,”localhost”); $motscles = “abri”; $query = “SELECT `post_id` FROM `wp_postmeta` WHERE `meta_key` = ‘nom’ AND MATCH (`meta_value`) AGAINST (‘” . $motscles . “‘ IN BOOLEAN MODE)”; $result = $myotherdatabase -> get_results($query, ARRAY_A); foreach ($result as $post) { $pids .= $post->post_id . “,”;// ARRAY_A } echo $pids; … Read more

Getting values from form and saving in database but spaces are inserted instead of form values

<?php /* Template Name: Dummy Practice Page*/?> <div id=”main-content” class=”main-content”> <div class=”main-content-inner”> <form method=”post”> <p><div> <input name=”nametxt” id=”nametxt” type=”text” style=”height:30px; width: 350px; ” maxlength=”5″ placeholder=”Name” required><br> </p></div> <p><div> <input name=”designationtxt” id=”designationtxt” type=”text” style=”height:30px; width: 350px; ” maxlength=”50″ placeholder=”Designation” required><br> </p></div> <p><div> <input name=”descriptiontxt” id=”descriptiontxt” type=”text” style=”height:30px; width: 350px; ” maxlength=”1000″ placeholder=”Description” required><br> </p></div> <input id=”submitbtn” … Read more

What steps do I need to take to install a local copy of a live website?

wp-cli makes use of your wp-config.php credentials to connect to the db, so the fact that you are getting the install screen, and not getting any errors (I assume) when running wp-cli commands says that you seem to have it configured correctly. My only thought would be that your $table_prefix value doesn’t match the tables … Read more

I want to share local developement and staging DB — Is this very smart or very stupid?

WordPress, and many of its plugins, store configuration data in the database. That alone could cause issues for the setup you described, but the urls of every link will also be stored fully canonicalized. So, unless you plan to test your staging setup from “http://localhost“, you will have serious issues trying to click around multiple … Read more

+ More