File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/insertuserupdates_045820873.php
Back
<?php include 'dbconfig.php'; $notUploaded = 0; $notUploadedString = ""; try { $pdo = new PDO( "mysql:host=$databasehost;dbname=$databasename", $databaseusername, $databasepassword, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_LOCAL_INFILE => true ] ); if (!file_exists('USERS.csv')) { $notUploadedString .= ' USERS'; $notUploaded += 1; } else { $file = fopen('USERS.csv', 'r'); $deleteUsers = []; // ---- LINE 1: AS OF line ---- $asOfLine = fgetcsv($file, 0, "|"); if ($asOfLine !== FALSE && isset($asOfLine[0])) { // Extract the date string after "AS OF: " $lastUpdate = str_replace("AS OF: ", "", $asOfLine[0]); $stmt = $pdo->prepare("UPDATE tblsettings SET lastupdate = ?"); $stmt->execute([$lastUpdate]); } // ---- LINE 2: blank line ---- fgetcsv($file, 0, "|"); // ---- LINE 3: header row ---- fgetcsv($file, 0, "|"); // ---- DATA ROWS ---- while (($line = fgetcsv($file, 0, "|")) !== FALSE) { // Ensure row has at least 6 columns if (count($line) < 6) { continue; } // STATUS is column index 5 if ($line[5] === "RESET" || $line[5] === "INACTIVE") { $deleteUsers[] = $line[1]; // PBNO column } } fclose($file); // ---- Batch delete (1000 per chunk) ---- if (!empty($deleteUsers)) { $chunks = array_chunk($deleteUsers, 1000); foreach ($chunks as $chunk) { $placeholders = implode(',', array_fill(0, count($chunk), '?')); $stmt = $pdo->prepare("DELETE FROM usersupdated WHERE uname IN ($placeholders)"); $stmt->execute($chunk); } } } echo ($notUploaded === 0) ? "SUCCESS" : "FAILED"; } catch (PDOException $e) { echo "FAILED: " . $e->getMessage(); }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings