Ultra File Manager

Edit: /home/u523034047/domains/eipcsindia.com/public_html/wap/contacts.php

<?php
require 'config.php';
ensureAdmin();
$msg='';
if(isset($_POST['import'])){
    $f = $_FILES['csv']['tmp_name'];
    if($f && ($handle = fopen($f,'r'))){
        $row=0; $added = 0;
        while(($data = fgetcsv($handle,1000,',')) !== FALSE){
            $row++; if($row==1) continue; // skip header
            $name = trim($data[0]); $phone = preg_replace('/[^0-9+]/','',$data[1]);
            $vars = isset($data[2])?json_encode(['var'=>$data[2]]):null;
            if($phone){
                $stmt = $pdo->prepare('INSERT INTO contacts (name,phone,vars) VALUES (?,?,?)');
                $stmt->execute([$name,$phone,$vars]); $added++;
            }
        }
        fclose($handle);
        $msg = "$added contacts added";
    }
}

$contacts = $pdo->query('SELECT * FROM contacts ORDER BY added_at DESC LIMIT 200')->fetchAll();
?>
<!doctype html><html><head>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
<title>Contacts</title></head><body>
<div class="container mt-3">
<h3>Contacts</h3>
<?php if($msg):?><div class="alert alert-success"><?=$msg?></div><?php endif;?>
<form method="post" enctype="multipart/form-data" class="mb-3">
  <input type="file" name="csv" accept=".csv" required>
  <button name="import" class="btn btn-primary">Import CSV</button>
  <small class="form-text text-muted">CSV format: name,phone,optional_var</small>
</form>
<table class="table table-striped">
<thead><tr><th>Name</th><th>Phone</th><th>Status</th></tr></thead>
<tbody>
<?php foreach($contacts as $c):?>
<tr><td><?=htmlspecialchars($c['name'])?></td><td><?=htmlspecialchars($c['phone'])?></td><td><?=htmlspecialchars($c['status'])?></td></tr>
<?php endforeach;?>
</tbody></table>
</div>
</body></html>

Ukuran: 1.7 KB