Yes – absolutely. Simply enter the appropriate hostname and credentials in wp-config.php. Instead of the default localhost use the hostname provided by your database provider. Example: define( ‘DB_HOST’, ‘mysql.example.com:3307’ ); https://codex.wordpress.org/Editing_wp-config.php#Set_Database_Host
Here is an updated version of installer.php which does create the table when activating the plugin. A check has been added to see if the custom table exists before proceeding with the creation of the new table. A version number has been added too. It’s stored in the options table. This will help in the … Read more
It sounds like it would be simpler to go back and fix your initial try: saving an option to a WP-native table rather than creating your own. Try update_option – it creates an option if it doesn’t exist, or updates if it does. This will save you a lot of code and headaches in the … Read more
You can do that with a command in your database: UPDATE `wp_posts` /* Adjust the prefix! */ SET `post_title` = CONCAT( UCASE( /* First letter uppercase */ SUBSTRING( `post_title`, 1, 1 ) ), ”, LCASE( /* The rest in lowercase */ SUBSTRING( `post_title`, 2, LENGTH(`post_title`) ) ) ); If your author has a habit of … Read more
1: You can use Page template and custom WP_Query to show posts from a specific category into a page. 2: you can also achive same thing with shortcode where you will have to create a shortcode containing posts from specific category and paste that shortcode into your page. Update added sample code for custom page … Read more
From the WP Codex: Begin by logging into phpMyAdmin and clicking databases. A list of databases will appear. Click your WordPress database. All the tables in your database will appear. If not, click Structure. Look for wp_users in the Table column. Click on the icon for browse. Locate your Username under user_login Click edit (may … Read more
There’s an UPDATE_TIME column in the TABLES table in the information_schema database. So you can try to get the max from that column with e.g.: SELECT MAX(`UPDATE_TIME`) FROM information_schema.TABLES WHERE TABLE_SCHEMA = ‘dbname’ where we replace ‘dbname’ with the corresponding database name. More related info here on SO. From the MySQL 5.7 docs: UPDATE_TIME displays … Read more
This is the way WordPress does it: SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘custom_field’ ) WHERE wp_postmeta.post_id IS NULL You can do this with WP_Query meta_query and ‘compare’ => ‘NOT EXISTS’.
WordPress does provide you with the ability to save meta data for users, so you could just store the agent’s user id in a meta field of his subscribers, like update_user_meta( $user_id, “agent”, $agent_id ). You can then query those users with the WP_User_Query’s meta_query, e.g. $agents_subscribers = new WP_User_Query( array( ‘meta_key’ => ‘agent’, ‘meta_value’ … Read more
Theoretically No! But practically Yes! Every new framework/CMS now implements some sort of library that adds randomness to the actual password. Its a randomly generated salt in form of a random string or time, etc. That is saved along with the hash password in database. Since theoretically, a collision can occur in any cryptographic function … Read more