<?php
require('C:\xampp\htdocs\wp-load.php');
require_once('C:\xampp\htdocs\wp-admin\includes\media.php');
require_once('C:\xampp\htdocs\wp-admin\includes\file.php');
require_once('C:\xampp\htdocs\wp-admin\includes\image.php');
ini_set('max_execution_time', 500);
$str = file_get_contents("results-users.json");
$myArray = json_decode($str, true);

for($i=0; $i<count($myArray); $i++){
	$id_user=wp_create_user( $myArray[$i]['user_login'], $myArray[$i]['user_pass'], $myArray[$i]['user_email'] );
	if(is_object($id_user)){
		var_dump($id_user);
	}else{
		echo $id_user . " ". $i. $myArray[$i]['user_login'];
	}
	//add_user_meta( $id_user, "first_name", $myArray[$i]['first_name']);
	//add_user_meta( $id_user, "last_name", $myArray[$i]['last_name']);
	$update=wp_update_user( array( 'ID' => $id_user, 'first_name' => $myArray[$i]['first_name'] , 'last_name' => $myArray[$i]['last_name'] ));

	if(is_object($update)){
		echo "errore creazione utente! " . $i. "<br />";
		var_dump($update);
		die;
	}
	add_user_meta( $id_user, "input1", $myArray[$i]['ragione_sociale']);
	add_user_meta( $id_user, "input2", $myArray[$i]['piva']);
	add_user_meta( $id_user, "input3", $myArray[$i]['attivita']);
	//echo $id_user . " ". $i. $myArray[$i]['user_login'];
	if($myArray[$i]['preferiti']!=NULL){
		$posts=array();
		$preferiti=$myArray[$i]['preferiti'];
		for($j=0; $j<count($preferiti); $j++){
			$post_valori=get_post_by_title($preferiti[$j]);
			if($post_valori!=NULL){
				$posts[$j]=$post_valori->ID;
			}else{
				echo "id non esistente in posizione: ".$j. "<br />";

			}
		}
		add_user_meta($id_user, "simplefavorites",array (
			0 =>
			array (
				'site_id' => 1,
				'posts' =>
				$posts,
				'groups' =>
				array (
					0 =>
					array (
						'group_id' => 1,
						'site_id' => 1,
						'group_name' => 'Default List',
						'posts' =>
						$posts,
					),
				),
			),
		));
	}
}
//aggiorno la password
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "Sql1122209_1";

// Creo la connessione al database
$conn = new mysqli($servername, $username,$password,$dbname);
// Controllo la connessione
if ($conn->connect_error) {
    die("Connessione fallita: " . $conn->connect_error);
}
$str = file_get_contents("results-users.json");
$myArray = json_decode($str, true);
for($i=0;$i<count($myArray); $i++){
$password=$myArray[$i]['user_pass'];
$user=$myArray[$i]['user_login'];
$sql = "UPDATE `df_users` SET `user_pass`= '$password' WHERE `user_login`='$user';";
$result = $conn->query($sql);
}
$conn->close();
function get_post_by_title($page_title, $post_type ='prodotto' , $output = OBJECT) {
	global $wpdb;
	$post = $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_title = %s AND post_type= %s", $page_title, $post_type));
	if ( $post )
		return get_post($post, $output);

	return NULL;
}


?>