i checked the database and noticed that every date is stored in a format like 2016-07-11. i did not found any date like 2016/07/11 but maybe some other plug-ins use it but none of my plug-ins use it every date like 2016/07/11 was in the link so i think you can do it by search … Read more
A goddamn cache. I thought I deleted it. Thanks @JackJohansson
WordPress Posts are not stored in a single table. Postmeta is stored elsewhere, and of course each table has its own format. If you ever publish content directly in WordPress (posts, pages, attachments, etc.) you could quickly run into issues with post IDs. Even if not, it would potentially require some fairly significant data manipulation … Read more
import posts with dutch/special letters
Make an Items attribute searchable (taxonomy using existing attribute)
I tried this in local, and I think you have multiple fields inside $fields so I’ve added them in array. Just look at the code below; it works fine as tested: add_action(‘your_hook’, ‘createTableFromFields’); function createTableFromFields($tablename) { $wpdb = $this->db; $tablename = $wpdb->prefix . $tablename; $fields = array(‘PersonID’,’LastName’); $sql=”CREATE TABLE IF NOT EXISTS %s (id INT(6) … Read more
charset problem with new custom table
Add update or delete database records using custom post type
Need to store custom user information (many-many relationsips), preferably not as user meta
You can used below code to get results from the database in wordpress. global $wpdb, $posts; $prefix = $wpdb->prefix; $query = $wpdb->get_results(“SELECT * FROM {$prefix}states”); if($query){ echo ‘<select><option value=”select”>Select</option>’; foreach ($query as $value) { echo ‘<option value=”‘.$value->ID.'”>’.$value->ID.'</option>’; } echo “</select>”; }