1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
<?php
$armundia = mysqli_connect("62.173.164.209","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_canc = "DELETE from utentiportale " or die("Error in the consult.." . mysqli_error($aiba));
$risultato = $aiba->query($query_canc);
$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));
}
?>
|