File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/insertusersecurity_045820873.php
Back
<?php include 'dbconfig.php'; try { $pdo = new PDO( "mysql:host=$databasehost;dbname=$databasename", $databaseusername, $databasepassword, array(PDO::MYSQL_ATTR_LOCAL_INFILE => true) // enable fast CSV import ); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // 1. Create temporary table $pdo->exec("CREATE TEMPORARY TABLE tmp_users ( uname VARCHAR(255) PRIMARY KEY, password VARCHAR(255) )"); // 2. Load CSV into temporary table $csvFilePath = __DIR__ . "/USERS.csv"; $pdo->exec(" LOAD DATA LOCAL INFILE '{$csvFilePath}' INTO TABLE tmp_users FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES (@dummy, uname, @password) SET password = SHA2(@password, 256) "); // 3. Bulk update main table in one query $pdo->exec(" UPDATE users u JOIN tmp_users t ON u.uname = t.uname SET u.password = t.password "); echo "SUCCESS"; } catch (PDOException $e) { echo "FAILED: " . $e->getMessage(); }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.27 |
proxy
|
phpinfo
|
Settings