Файловый менеджер - Редактировать - /home/d46091/e-udyogaadhaar.com/a.php
Назад
<style> table, th, td { border: 1px solid black; border-collapse: collapse; } th, td { padding: 5px; text-align: left; } </style> <?php include_once('./config.php'); $sql_select_msme = "SELECT m.id,m.applicant_name,m.mobile_number,m.email_id, c.cid, c.uid, c.table_name FROM msme_form m INNER JOIN cid c ON m.id = c.uid WHERE m.payment_status='Unpaid'ORDER BY m.id DESC LIMIT 500"; $result_msme = $conn->query($sql_select_msme); while($row = $result_msme->fetch_assoc()){ $data[] = $row; } // echo'<pre>'; // print_r($data); ?> <?php foreach($data as $rows){ ?> <?php date_default_timezone_set('Asia/Kolkata'); $date = date('Y-m-d'); $time = date('H:i:s'); $sql=" INSERT INTO test ( form_id, name, email, mobile, cuid, cid, created_date, created_time ) VALUES ( '".$rows['id']."', '".$rows['applicant_name']."', '".$rows['email_id']."', '".$rows['mobile_number']."', '".$rows['uid']."', '".$rows['cid']."', '".$date."', '".$time."' )"; if (!$result = $conn->query($sql)) { die('There was an error running the query [' . $conn->error . ']'); } } ?> </table>
| ver. 1.4 |
Github
|
.
| PHP 8.1.32 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка