. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
| Server IP : 52.223.31.75 / Your IP : 172.31.32.98 [ Web Server : Apache/2.4.66 () OpenSSL/1.0.2k-fips PHP/7.4.33 System : Linux ip-172-31-14-81.eu-central-1.compute.internal 4.14.281-212.502.amzn2.x86_64 #1 SMP Thu May 26 09:52:17 UTC 2022 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE Domains : 4 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/ascii/www/ |
Upload File : |
<?php
$servername = "piattaforma-formazione-apisoft.cqx18uta8i2i.eu-central-1.rds.amazonaws.com";
$username = "root";
$password = "qwet324vfsdgweDa21";
$dbname = "ascii";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT idcliente, codiceFiscale, datanascita FROM cliente WHERE datanascita IS NULL OR datanascita='1970-01-01' OR datanascita='0000-00-00'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "cdf: " . $row["codiceFiscale"]. " - datanascita: " . $row["datanascita"];//."<br>";
$idcliente= $row["idcliente"];
$a_anno = intval($row["codiceFiscale"][6]."".$row["codiceFiscale"][7]);
$a_mese = $row["codiceFiscale"][8];
$a_giorno = intval($row["codiceFiscale"][9]."".$row["codiceFiscale"][10]);
$anno = 1;
if($a_anno<30){
$anno = "20".$a_anno;
}else{
$anno = "19".$a_anno;
}
$giorno = 1;
if($a_giorno>39){ //donna
$giorno = $a_giorno-40;
}else{ //uomo
if($a_giorno<10){
$giorno = "0".$a_giorno;
}else{
$giorno = $a_giorno;
}
}
$mese = 1;
switch($a_mese){
case 'A': $mese = "01"; break;
case 'B': $mese = "02"; break;
case 'C': $mese = "03"; break;
case 'D': $mese = "04"; break;
case 'E': $mese = "05"; break;
case 'H': $mese = "06"; break;
case 'L': $mese = "07"; break;
case 'M': $mese = "08"; break;
case 'P': $mese = "09"; break;
case 'R': $mese = "10"; break;
case 'S': $mese = "11"; break;
case 'T': $mese = "12"; break;
}
$data_nascita = $anno."-".$mese."-".$giorno;
$mod_q = "UPDATE cliente SET datanascita='$data_nascita' WHERE idcliente = $idcliente";
echo " Aggiorno con -> ".$data_nascita.'<br>';
$conn->query($mod_q);
$count++;
}
} else {
echo "0 results";
}
echo $count + " Risultati";
$conn->close();
?>