| Server IP : 80.211.21.168 / Your IP : 216.73.217.33 Web Server : Apache System : Linux alex-webdesign.it 3.10.0-1160.119.1.el7.tuxcare.els22.x86_64 #1 SMP Mon Aug 18 06:07:12 UTC 2025 x86_64 User : admin_japan ( 10003) PHP Version : 8.2.32 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/cerchijapan.it/cerchiracing.it/aurez/ |
Upload File : |
<?php
$filename = "rest.csv";
$csvData = file_get_contents($filename);
$lines = explode(PHP_EOL, $csvData);
$array = array();
foreach ($lines as $line) {
$array[] = str_getcsv($line,'|');
}
$tot_giorni=count($array);
$tot_giorni;
$user="admin_aurelz";
$pass='Diocanaglia1994!';
$db = new PDO('mysql:host=localhost;dbname=admin_aurelz', $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") );
for($i=1;$i<$tot_giorni;$i++){
$id=$array[$i][0];
$all=$array[$i][1];
$date=$array[$i][2];
var_dump($date);
$sql2="INSERT INTO 'ps_presta_product_restriction' 'id_product'='$id', 'allowed_payments'='$all', 'date_add'='$date', 'date_upd'='$date'";
$query2=$db->prepare($sql2);
$query2->execute();
}
?>