For what I can understand you already have the table in your database. I don’t know how you have named it, but a best practise (for me a must-do practise) is to name it with the same table prefix of wordpress, that’s the one setted in wp-config.php. You also don’t say how this table is … Read more
To answer your exact questions: Yes. Just use MariaDB instead of MySQL. No, it is a straight replacement. The exact details depend heavily upon your exact situation. However, MariaDB is marketed as a compatible MySQL replacement. AFAIK, it works with WordPress with no changes at all.
As far as I know it isn’t used, but to avoid conflicts/problems, other plugins might use it, I’d go with adding a meta to the wp_usermeta table. There is a set of functions for handling that: add_user_meta() get_user_meta() update_user_meta() delete_user_meta() Shouldn’t make a big difference for the functionality you want to implement, but you’re on … Read more
query – you will get sql as argument of the callback. add_filter(‘query’, ‘some_callback_that_change_query’); function some_callback_that_change_query($sql){ remove_filter(‘query’, ‘some_callback_that_change_query’); // your banny wrote add_filter(‘query’, ‘some_callback_that_change_query’); return $sql; }
You said your form is in the main folder? I guess you need to set proper URL for action=””. You could try: action=”<?php echo site_url() . ‘/setLiquorType.php’; ?>” It is best practice to put your form code into functions.php and then leave form action=”” empty. Then you can trigger your form function when the form … Read more
I think there’s a better approach, just create a custom taxonomy that holds the alphanumeric terms, then assign each post to the correct term. You can use the save post action to auto assign posts to correct term on post save: function save_index( $post_id ) { if ( defined( ‘DOING_AUTOSAVE’ ) && DOING_AUTOSAVE ) { … Read more
You can check database function for database here. For the table prefix matter you should use $wpdb->prefix . ‘enam’ and it will return the table prefix. Just add the table name with this. So the total code would be : $yourtablename = $wpdb->prefix . ‘enam’; so your total code could be something like: $wpdb->insert($yourtablename , … Read more
You can easily connect to another DB using the wpdb class: $external_users_db = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); (substituting in your applicable values, of course). From there you can use the get_results, insert, update, and query methods (among others) to do what you need to do, e.g. $external_users_db->get_results( “SELECT ID, username FROM users” );. The … Read more
Yes. Use WP_HOME and WP_SITEURL in your wp-config.php, so the URLs in the database won’t mess (a lot) with local site development. define (‘WP_HOME’, ‘http://local/site/url’); define (‘WP_SITEURL’, ‘http://local/site/url’); Also, some other good practices: Put in your .gitignore things like: wp-config.php wp-content/uploads wp-content/cache wp-content … # Everything that is created by users .htaccess Make a copy … Read more
As try today, truncate is WAY BETTER that DELETE, because DELETE broke the site, and trucate just empty the table, here is the working code : global $wpdb; $wpdb->query(‘TRUNCATE TABLE wp_posts’);