You’re must load WP-load function To do that you need to require wp-load file, so if, your custom file is in theme it shoudl look like somethink like that: $wp_load = ‘../../../../../wp-load.php’; if ( file_exists( $wp_load ) ) { require_once( $wp_load ); }else{ die(‘no-load’); } You could also set const SHORTINIT to true to minimalize … Read more
This code is working for me with no “WordPress database error” messages: if ( $wpdb->get_var( $wpdb->prepare( “SHOW TABLES LIKE %s”, $table_name ) ) === $table_name ) { error_log( ‘Table exists’ . ‘: ‘ . print_r( $table_name, true ) ); } else { error_log( ‘Table does not exist’ . ‘: ‘ . print_r( $table_name, true ) … Read more
It appears as though you’re altering the users table – this is a WordPress core table (if using the wp_ prefix) and this is probably not a good idea – create a separate table with an ID foreign key to avoid potential problems. Use $wpdb->prefix to get the prefix that’s actually being used on a … Read more
mysql_fetch_object() was deprecated in PHP 5.5 and fully removed in PHP 7.0, which is probably why it no longer works for you. It’s always better to use WP functions – often they are wrappers for something in PHP (or elsewhere), but by using the WP wrapper version, it usually protects you from deprecation (since the … Read more
This is a code review question more than a WordPress question. Please post these in the Code Review Stack Exchange in the future. You have a couple things wrong or not according to best practices. Comments inline for where I made changes. $cr_table_array = array( array( ‘data_field’ => ‘id’, // Add primary key here to … Read more
I don’t know of a plugin that allows you to do this out of the box, but as you are (/seem to be) comfortable with database manipulation, I’ve outlined below how you can achieve what you want using custom coding. You can run custom queries using the wpdb-class. There are a few posts on WPSE/SO … Read more
The short answer is yes. Having a secure username and password is paramount to keeping your site secure.
Your SQL doesn’t look right. It should be more like $prep = $wpdb->prepare( “SELECT * FROM {$table_name} WHERE name LIKE ‘%s'”, $city );
There are a few things to note: there is no error checking on wp_insert_user, so there’s no way to know if it failed and why wp_insert_user can be used to set the role etc, the follow up calls aren’t needed, if you read the official docs, there are parameters for those fields Never modify the … Read more
Maybe if you configured the wp-config.php file like the documentation says (see https://wordpress.org/support/article/editing-wp-config-php/ ) Sample wp-config.php file (database section), per the above link: // ** MySQL settings – You can get this info from your web host ** // /** The name of the database for WordPress */ define( ‘DB_NAME’, ‘database_name_here’ ); /** MySQL database … Read more