File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/insertnotifications_045820873.php
Back
<?php include 'dbconfig.php'; $notUploaded = 0; $notUploadedString = ""; $pdo = new PDO("mysql:host=$databasehost;dbname=$databasename", $databaseusername, $databasepassword,array(PDO::MYSQL_ATTR_LOCAL_INFILE => true)); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); if (file_exists('NOTIFICATIONS.csv')) { $sql = "TRUNCATE TABLE tblnotif"; $pdo->exec($sql); $pdo->exec("LOAD DATA LOCAL INFILE 'NOTIFICATIONS.csv' INTO TABLE tblnotif FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 3 LINES (ID, USERID, TITLE, DESCRIPTION, CLICKED, DDATE)"); }else{ $notUploadedString .= ' NOTIFICATIONS,'; $notUploaded += 1; } if($notUploaded == 0){ echo "SUCCESS"; }else{ echo "FAILED"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.25 |
proxy
|
phpinfo
|
Settings