:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/demo/book/**
:: Editing File: index.php
<?php include 'config.php'; ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet"> <title>Person Details</title> <style> * { margin: 0; padding: 0; box-sizing: border-box; } .container { display: flex; width: 90%; border: 2px solid #ccc; overflow: hidden; padding:20px 10px; } .left-side { width: 50%; background-color: #eee; display: flex; justify-content: center; align-items: center; margin:0px 10px; } .left-side img { width: 100%; height: 100%; object-fit: cover; } .right-side { width: 50%; margin:0px 10px; display: flex; flex-direction: column; justify-content: space-between; } .section { border: 1px solid #ddd; /*margin-bottom: 15px;*/ background-color: #fff; } .section h2 { margin-bottom: 10px; padding:10px; font-size: 18px; color: #000; text-transform: capitalize; } .section p { font-size: 14px; color: #000; } .basic-details { background-color: yellow; color: black !important; } /* Address Section - Yellow background, Black text */ .address { background-color: #c3d5ff; color: black; } /* Business Section - Yellow background, Black text */ .business { background-color: #c3d5ff; color: black; } .family_id { font-size:13px !important; margin-left:10px !important; font-weight:900; } .text-center { text-align:center; } .details p { padding:5px; margin-left:5px; } .content p { line-height: 20px; padding: 0px 40px 10px 40px; } /* Family Details Table */ .family-details { width:100%; } table { width: 100%; border-collapse: collapse; font-size: 12px; } table, th, td { border: 1px solid blue; } .family-details tr { border:0px !important; } th, td { padding: 10px; text-align: left; } th { background-color: #c3d5ff; font-weight: bold; } </style> </head> <body> <!-- Button to Generate Excel --> <div class="text-center my-3"> <button class="btn btn-primary" onclick="generateExcel()">Download Excel</button> </div> <?php // $lead="SELECT * FROM book"; //$lead = "SELECT * FROM `book` WHERE Sr_No = 22 ORDER BY CAST(`Sr_No` AS UNSIGNED) ASC"; $lead = "SELECT * FROM book WHERE CAST(Sr_No AS UNSIGNED) BETWEEN 1 AND 425 ORDER BY CAST(Sr_No AS UNSIGNED) ASC ;"; $stmt_lead=$conn->query($lead); $client_lead = $stmt_lead->fetchAll(); foreach ($client_lead as $row) { ?> <div class="person_1 family-data" id="<?php echo $row['Sr_No'];?>"> <div class="container "> <!-- Left Side: Image --> <div class="left-side"> <img src="Family.jpg" alt="Person Image"> </div> <!-- Right Side: Details --> <div class="right-side"> <div class="section details"> <h2 class="basic-details"><?php echo $row['First_Name'];?> <?php echo $row['Father_Name'];?> <?php echo $row['Surname'];?> <span class="family_id">ID:<?php echo $row['Sr_No'];?> </span></h2> <p>Gujarat: <b><?php echo $row['Village_Gujarat'];?></b></p> <p>Kutch: <b><?php echo $row['Village_Kutch'];?></b></p> <p>Mob. No: <b><?php echo $row['Mobile'];?></b></p> </div> <div class="section content"> <h2 class="address text-center">Address</h2> <p class="text-center"><?php echo $row['Current_Address'];?></p> </div> <div class="section content"> <h2 class="business text-center">Business Group</h2> <p class="text-center"> <?php echo $row['Occupation'];?> </p> </div> </div> </div> <div class="container"> <!-- Family Details Table --> <div class="family-details"> <table id="familyTable"> <thead> <tr> <th>#</th> <th>Name</th> <th>Relation</th> <th>Birth Date</th> <th>Age</th> <th>Marital Status</th> <th>Nihani</th> <th>Blood</th> <th>Occupation</th> <th>Education</th> <th>Studying at</th> <th>Studying City</th> <th>Mobile</th> </tr> </thead> <tbody> <?php $i = 1; ?> <tr> <td><?php echo $i; ?></td> <td><?php echo $row['First_Name'];?> <?php echo $row['Father_Name'];?> <?php echo $row['Surname'];?></td> <td><?php echo $row['Relation'];?></td> <td><?php echo $row['DOB'];?></td> <td><?php echo $row['Age'];?></td> <td><?php echo $row['Marital_Status'];?></td> <td></td> <td><?php echo $row['Blood'];?></td> <td><?php echo $row['Occupation'];?></td> <td><?php echo $row['Education'];?></td> <td></td> <td></td> <td><?php echo $row['Mobile'];?></td> </tr> <?php if (isset($row['p1_First_Name']) && !empty($row['p1_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p1_First_Name'];?> <?php echo $row['p1_Father_Name'];?> <?php echo $row['p1_Surname'];?></td> <td><?php echo $row['p1_Relation'];?></td> <td><?php echo $row['p1_DOB'];?></td> <td><?php echo $row['p1_Age'];?></td> <td><?php echo $row['p1_Marital_Status'];?></td> <td><?php echo $row['p1_nyani'];?></td> <td><?php echo $row['p1_Blood'];?></td> <td><?php echo $row['p1_Occupation'];?></td> <td><?php echo $row['p1_Education'];?></td> <td></td> <td></td> <td><?php echo $row['p1_mobile'];?></td> </tr> <?php } ?> <?php if (isset($row['p2_First_Name']) && !empty($row['p2_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p2_First_Name'];?> <?php echo $row['p2_Father_Name'];?> <?php echo $row['p2_Surname'];?></td> <td><?php echo $row['p2_Relation'];?></td> <td><?php echo $row['p2_DOB'];?></td> <td><?php echo $row['p2_Age'];?></td> <td><?php echo $row['p2_Marital_Status'];?></td> <td><?php echo $row['p2_nyani'];?></td> <td><?php echo $row['p2_Blood'];?></td> <td><?php echo $row['p2_Occupation'];?></td> <td><?php echo $row['p2_Education'];?></td> <td><?php echo $row['p2_Studying_at'];?></td> <td><?php echo $row['p2_study_city'];?></td> <td><?php echo $row['p2_mobile'];?></td> </tr> <?php } ?> <?php if (isset($row['p3_First_Name']) && !empty($row['p3_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p3_First_Name'];?> <?php echo $row['p3_Father_Name'];?> <?php echo $row['p3_Surname'];?></td> <td><?php echo $row['p3_Relation'];?></td> <td><?php echo $row['p3_DOB'];?></td> <td><?php echo $row['p3_Age'];?></td> <td><?php echo $row['p3_Marital_Status'];?></td> <td><?php echo $row['p3_nyani'];?></td> <td><?php echo $row['p3_Blood'];?></td> <td><?php echo $row['p3_Occupation'];?></td> <td><?php echo $row['p3_Education'];?></td> <td><?php echo $row['p3_Studying_at'];?></td> <td><?php echo $row['p3_study_city'];?></td> <td><?php echo $row['p3_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p4_First_Name']) && !empty($row['p4_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p4_First_Name'];?> <?php echo $row['p4_Father_Name'];?> <?php echo $row['p4_Surname'];?></td> <td><?php echo $row['p4_Relation'];?></td> <td><?php echo $row['p4_DOB'];?></td> <td><?php echo $row['p4_Age'];?></td> <td><?php echo $row['p4_Marital_Status'];?></td> <td><?php echo $row['p4_nyani'];?></td> <td><?php echo $row['p4_Blood'];?></td> <td><?php echo $row['p4_Occupation'];?></td> <td><?php echo $row['p4_Education'];?></td> <td><?php echo $row['p4_Studying_at'];?></td> <td><?php echo $row['p4_study_city'];?></td> <td><?php echo $row['p4_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p5_First_Name']) && !empty($row['p5_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p5_First_Name'];?> <?php echo $row['p5_Father_Name'];?> <?php echo $row['p5_Surname'];?></td> <td><?php echo $row['p5_Relation'];?></td> <td><?php echo $row['p5_DOB'];?></td> <td><?php echo $row['p5_Age'];?></td> <td><?php echo $row['p5_Marital_Status'];?></td> <td><?php echo $row['p5_nyani'];?></td> <td><?php echo $row['p5_Blood'];?></td> <td><?php echo $row['p5_Occupation'];?></td> <td><?php echo $row['p5_Education'];?></td> <td><?php echo $row['p5_Studying_at'];?></td> <td><?php echo $row['p5_study_city'];?></td> <td><?php echo $row['p5_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p6_First_Name']) && !empty($row['p6_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p6_First_Name'];?> <?php echo $row['p6_Father_Name'];?> <?php echo $row['p6_Surname'];?></td> <td><?php echo $row['p6_Relation'];?></td> <td><?php echo $row['p6_DOB'];?></td> <td><?php echo $row['p6_Age'];?></td> <td><?php echo $row['p6_Marital_Status'];?></td> <td><?php echo $row['p6_nyani'];?></td> <td><?php echo $row['p6_Blood'];?></td> <td><?php echo $row['p6_Occupation'];?></td> <td><?php echo $row['p6_Education'];?></td> <td><?php echo $row['p6_Studying_at'];?></td> <td><?php echo $row['p6_study_city'];?></td> <td><?php echo $row['p6_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p7_First_Name']) && !empty($row['p7_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p7_First_Name'];?> <?php echo $row['p7_Father_Name'];?> <?php echo $row['p7_Surname'];?></td> <td><?php echo $row['p7_Relation'];?></td> <td><?php echo $row['p7_DOB'];?></td> <td><?php echo $row['p7_Age'];?></td> <td><?php echo $row['p7_Marital_Status'];?></td> <td><?php echo $row['p7_nyani'];?></td> <td><?php echo $row['p7_Blood'];?></td> <td><?php echo $row['p7_Occupation'];?></td> <td><?php echo $row['p7_Education'];?></td> <td><?php echo $row['p7_Studying_at'];?></td> <td><?php echo $row['p7_study_city'];?></td> <td><?php echo $row['p7_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p8_First_Name']) && !empty($row['p8_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p8_First_Name'];?> <?php echo $row['p8_Father_Name'];?> <?php echo $row['p8_Surname'];?></td> <td><?php echo $row['p8_Relation'];?></td> <td><?php echo $row['p8_DOB'];?></td> <td><?php echo $row['p8_Age'];?></td> <td><?php echo $row['p8_Marital_Status'];?></td> <td><?php echo $row['p8_nyani'];?></td> <td><?php echo $row['p8_Blood'];?></td> <td><?php echo $row['p8_Occupation'];?></td> <td><?php echo $row['p8_Education'];?></td> <td><?php echo $row['p8_Studying_at'];?></td> <td><?php echo $row['p8_study_city'];?></td> <td><?php echo $row['p8_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p9_First_Name']) && !empty($row['p9_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p9_First_Name'];?> <?php echo $row['p9_Father_Name'];?> <?php echo $row['p9_Surname'];?></td> <td><?php echo $row['p9_Relation'];?></td> <td><?php echo $row['p9_DOB'];?></td> <td><?php echo $row['p9_Age'];?></td> <td><?php echo $row['p9_Marital_Status'];?></td> <td><?php echo $row['p9_nyani'];?></td> <td><?php echo $row['p9_Blood'];?></td> <td><?php echo $row['p9_Occupation'];?></td> <td><?php echo $row['p9_Education'];?></td> <td><?php echo $row['p9_Studying_at'];?></td> <td><?php echo $row['p9_study_city'];?></td> <td><?php echo $row['p9_mobile'];?></td> </tr><?php } ?> <?php if (isset($row['p10_First_Name']) && !empty($row['p10_First_Name'])) { ?> <tr> <td><?php echo ++$i; ?></td> <td><?php echo $row['p10_First_Name'];?> <?php echo $row['p10_Father_Name'];?> <?php echo $row['p10_Surname'];?></td> <td><?php echo $row['p10_Relation'];?></td> <td><?php echo $row['p10_DOB'];?></td> <td><?php echo $row['p10_Age'];?></td> <td><?php echo $row['p10_Marital_Status'];?></td> <td><?php echo $row['p10_nyani'];?></td> <td><?php echo $row['p10_Blood'];?></td> <td><?php echo $row['p10_Occupation'];?></td> <td><?php echo $row['p10_Education'];?></td> <td><?php echo $row['p10_Studying_at'];?></td> <td><?php echo $row['p10_study_city'];?></td> <td><?php echo $row['p10_mobile'];?></td> </tr><?php } ?> <!-- Additional family members can be added here --> </tbody> </table> </div> </div> </div> <?php } ?> <!-- JavaScript for Excel Generation --> <script> function generateExcel() { const rows = document.querySelectorAll('.family-data, #familyTable'); let csvContent = ''; rows.forEach(section => { if (section.tagName === 'TABLE') { const tableRows = section.querySelectorAll('tr'); tableRows.forEach(row => { const cols = row.querySelectorAll('th, td'); const rowData = Array.from(cols).map(col => `"${col.innerText}"`).join(','); csvContent += rowData + '\n'; }); } else { const details = section.querySelectorAll('p, h2'); details.forEach(detail => { csvContent += `"${detail.innerText}"\n`; }); csvContent += '\n'; } }); const blob = new Blob([csvContent], { type: 'text/csv' }); const link = document.createElement('a'); link.href = URL.createObjectURL(blob); link.download = 'Family_Details.csv'; link.click(); } </script> <!-- Bootstrap JS --> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>