File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/_insertuserupdates_045820873.php
Back
<?php include 'dbconfig.php'; $notUploaded = 0; $notUploadedString = ""; $count = 0; $pdo = new PDO("mysql:host=$databasehost;dbname=$databasename", $databaseusername, $databasepassword); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); if (file_exists('USERS.csv')) { $file = fopen('USERS.csv', 'r'); while (($line = fgetcsv($file)) !== FALSE) { if($count == 0){ $sql = "UPDATE tblsettings SET lastupdate='" . $line[0] . "'"; $pdo->exec($sql); } if($count >= 3){ if($line[5] == "RESET" || $line[5] == "INACTIVE"){ $sql = "DELETE FROM usersupdated WHERE uname=" . $line[1]; $pdo->exec($sql); } } $count +=1; } fclose($file); }else{ $notUploadedString .= ' USERS'; $notUploaded += 1; } if($notUploaded == 0){ echo "SUCCESS"; }else{ echo "FAILED"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.04 |
proxy
|
phpinfo
|
Settings