I think s_ha_dum is in the right track, but I think he got it backwards. You want to: develop/design locally connect to the REMOTE database and work with his content? You need a remote (staging) installation of WordPress, where the client can create/enter his content. You need your local WordPress site (localhost) to point to … Read more
Wordfence blocks the User endpoint from the public. In settings there is a checkbox you can unselect to make it visible in the WP Rest API again.
Yes, you can store your data in your own tables in WordPress database. There are few things that you need to take care of: Make sure your data can’t be really represented using the built-in WordPress content types. Prefix your tables with WordPress Prefix + your prefix. WordPress table prefix is $wpdb->prefix. Use the global … Read more
You answered your own question. You need to include the upgrade.php file which contains that function. Otherwise won’t be loaded on your plugin update and the function won’t exist. require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);
the wp_posts include all post types (post, page, custom post..), and to differentiate between them there is a field called post_type used to specify the name of the current entry whether it’s a page, post or a custom post. Query below will get list of pages SELECT * FROM wp_posts where post_type=”page”;
WordPress will not do any data sanitization for you. It does do sanitization/validation of the default options. You have to pass in the third argument of register_setting and either role your own validation callback or or use one of the builtins. If your options is only going to contain a string, you could do something … Read more
Why not use the SELECT INTO OUTFILE syntax: $wpdb->query(“SELECT * INTO OUTFILE ‘/path/to/file’ FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’ FROM tracking”);
You can override the core wp_authenticate function. You would need to create a custom plugin and declare a new version of wp_authenticate. The function accepts a username and a password and returns a WP $user object. wp_authenticate is a ‘pluggable’ function and it is found in the wp-includes/pluggable.php file.
WordPress database error: [Query was empty] [closed]
You can try using the Genesis-Wordpress(Note: not the framework) project for this. It does more or less what you have described above including, Provisioning (with Ansible) Deployment (with Capistrano) Database Synchronization (with custom Capistrano tasks) It also uses the Vagrant Host Manager to workaround the /etc/hosts issue. So the site is served over port 80. … Read more