Users select/insert | wpdb | WordPress.org

Hi All,

It’s my first time since a very, very long time using wordpress again and I have some issues with a function I want to create to automate a cronjob.

I’m trying to select the users i have from wp_users table and insert a few values into another table on the same database, but different table (users).

I’ve got so far with this code, but when i run it nothing happens. Not even an error.

Any suggestions are welcomed. Thank you

function wp_users_table_bind(){
global $wpdb;
$secret = mksecret();
$added = time();
$status="confirmed";

$result = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}users" );

foreach( $result as $results ){
$name = $results['user_login'];
$passhash = $results['user_pass'];
$email = $results['user_email'];
}

$wpdb->query("INSERT INTO users (username, passhash, secret, email, status, added) VALUES ($name, $passhash, $secret, $email, $status, $added) 
ON DUPLICATE KEY UPDATE 
username = $name,
passhash = $passhash,
secret = $secret,
email = $email,
status = $status,
added = $added");
$wpdb->insert_id;
}