File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/_insertusers_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('USERS.csv')) { $sql = "DELETE FROM users"; $pdo->exec($sql); $pdo->exec("LOAD DATA LOCAL INFILE 'USERS.csv' INTO TABLE users FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' IGNORE 3 LINES (id, uname, password, updationDate, cname, status);"); }else{ $notUploadedString .= ' USERS,'; $notUploaded += 1; } if($notUploaded == 0){ echo "SUCCESS"; }else{ echo "FAILED"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.2 |
proxy
|
phpinfo
|
Settings