File manager - Edit - /home/familylifersmpc/htdocs/www.familylifersmpc.com/downloaddata_045820873.php
Back
<?php include 'dbconfig.php'; $pdo = new PDO( "mysql:host=$databasehost;dbname=$databasename;charset=$dbChar", $databaseusername, $databasepassword, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_NAMED ] ); if (file_exists("LOANSAPPLIED.csv")) { if (unlink("LOANSAPPLIED.csv")) { } else { } } // (B) CREATE EMPTY CSV FILE ON SERVER $handle = fopen("LOANSAPPLIED.csv", "w"); if ($handle === false) { exit("Error creating $csvFile"); } // (C) GET USERS FROM DATABASE + WRITE TO FILE $stmt = $pdo->prepare("SELECT * FROM tblloanapp"); $stmt->execute(); while ($row = $stmt->fetch()) { fputcsv($handle, $row , "|"); } fclose($handle); echo "SUCCESS";
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings