<?php 

$armundia = mysqli_connect("192.168.200.18","aiba2","K3HD8nQdVCXj6wz","aiba") or die("Error " . mysqli_error($armundia)); 
$aiba 	  = mysqli_connect("127.0.0.1","aibaweb","Qp9k1z2^","aiba_web") or die("Error " . mysqli_error($aiba)); 

$query = "SELECT * FROM utentiportale" or die("Error in the consult.." . mysqli_error($armundia)); 
$result = $armundia->query($query); 

while($row = mysqli_fetch_array($result)) 
{ 
	$crypt = password_hash($row['password'], PASSWORD_DEFAULT);
	$q_insert = "INSERT INTO utentiportale (id,id_profilo,username,password,crypt_pass,nome,email,livello_sito,naccessi)
				VALUES ( 	'".$row['id']."',
							'".$row['id_profilo']."', 
							'".$row['username']."',
							'".$row['password']."',
							'".$crypt."',
							'".addslashes($row['nome'])."',
							'".$row['email']."',
							'".$row['livello_sito']."',
							'".$row['naccessi']."'
							)

	ON DUPLICATE KEY UPDATE  
		id_profilo='".$row['id_profilo']."',
		username='".$row['username']."',
		password='".$row['password']."',
		crypt_pass='".$crypt."', 
		nome='".addslashes($row['nome'])."',
		email='".$row['email']."',
		livello_sito='".$row['livello_sito']."',
		naccessi='".$row['naccessi']."'"  or die("Error in the consult.." . mysqli_error($aiba)); 

	$aiba->query($q_insert) or die("Error " . mysqli_error($aiba)); 
} 
?>