File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/_insertloanapp_045820873.php
Back
<?php include 'dbconfig.php'; $notUploaded = 0; $notUploadedString = ""; if (file_exists('LOANSAPPLIED.csv')) { $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); $file = fopen('LOANSAPPLIED.csv', 'r'); while (($line = fgetcsv($file,0,"|")) !== FALSE) { $sql = "UPDATE tblloanapp SET status='".$line[7]."' WHERE appID='". $line[5] . "' AND userID='".$line[6]."'" ; $pdo->exec($sql); } fclose($file); }else{ $notUploadedString .= 'LOANSAPPLIED'; $notUploaded += 1; } $date = date_create(date("Y/m/d")); date_sub($date, date_interval_create_from_date_string("365 days")); $date = date_format($date, "Y-m-d"); $sql = "DELETE FROM tblloanapp WHERE DDATE<?"; $stmt= $pdo->prepare($sql); $stmt->execute([$date]); if($notUploaded == 0){ echo "SUCCESS"; }else{ echo "FAILED"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.16 |
proxy
|
phpinfo
|
Settings