What's new

Import excel to database problem

L

loktoy

Eternal Poster
Joined
Oct 20, 2014
Posts
1,166
Solutions
2
Reaction
103
Points
496
Age
30
anu po kaya mali o kulang sa code ko..

kasi pag nag iimport ako ng excel pati yun walang laman sa dulo nasasama ..
dapat po kung hanggan saan lang po yun laman ng excel dun lang po sana mag papakita po..
ito code ko po

<?php

include "../config/config.php";



?>
<!DOCTYPE html>
<HTMl:5>
<head>
<title>sample Design</title>
<link rel="stylesheet" href="../Innerjoin/css/bootstrap.css">
<link rel="stylesheet" href="../Innerjoin/css/style.css">
<script src="../Newproject/js/bootstrap.bundle.js"></script>


</head>
<body>

<form method="POST" enctype="multipart/form-data">
<input type="file" name="file" value="">
<br>
<input type="submit" name="btnUpload" value="Upload LDDAP_ADA">
</form>

<?php

if(isset($_POST['btnUpload'])){

echo "<hr>";

echo "<table border='1' width='40%'>";

echo "<tr>

<td width='70%'><b>Payee Name</b></td>
<td width='70%'><b>Particular</b></td>
<td width='70%'><b>Amount</b></td>
<td width='70%'><b>LDDAP-ADA</b></td>
<td width='70%'><b>Date</b></td>
<td width='70%'><b>Status</b></td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>";

$btnStatus = "ENABLED";

$filename = $_FILES['file']['tmp_name'];

if($_FILES['file']['size'] > 0) {

$file = fopen($filename, "r");

$row = 1;

while (($data = fgetcsv($file, 10000, ",")) !== false){
$payeename = $particular = $amount = $lddapada = $date = $status = "";

$payeenameErr = $particularErr = $amountErr = $lddapadaErr = $dateErr = $statusErr = "";

if($row == 1){
$row++;
continue;
}

if(empty($data[0])){
$payeenameErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$payeename = $data[0];
}
if(empty($data[1])){
$particularErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$particular = $data[1];
}
if(empty($data[2])){
$amountErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$amount = $data[2];
}
if(empty($data[3])){
$lddapadaErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$lddapada = $data[3];
}
if(empty($data[4])){
$dateErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$date = $data[4];
}
if(empty($data[5])){
$statusErr = "Product name is empty";

$btnStatus = "DISABLED";

}else {

$status = $data[5];
}


echo "<tr>

<td>$payeename</td>
<td>$particular</td>
<td>$amount</td>
<td>$lddapada</td>
<td>$date</td>
<td>$status</td>
</tr>";
}
}


echo "</table>";

}

?>

</body>
</HTMl:5>
 
Based on your code, it seems that you are importing an Excel file and displaying its contents in a table. However, you mentioned that even the empty cells are included in the table. To fix this issue, you can modify your code as follows:

1. Add a check to skip empty rows:
PHP: 
while (($data = fgetcsv($file, 10000, ",")) !== false){
    if (empty(array_filter($data))) {
        continue;
    }
    // Rest of your code
}
This code checks if all cells in a row are empty. If they are, it skips that row and moves on to the next one.

2. Add a check to skip empty cells in each row:
PHP: 
foreach ($data as $cell) {
    if (empty($cell)) {
        continue 2; // Skip to the next row
    }
    // Rest of your code
}
This code checks if a cell is empty. If it is, it skips that cell and moves on to the next one.

By adding these checks, the empty rows and cells will be skipped, and only the non-empty cells will be displayed in the table.
 

Similar threads

Popular Tags

android api app arduino bot c c++ capstone capstone project code coding coding and programming css database developer development help how how to html in java javascript language laravel mag mysql need patulong php program programmer programming programming language project python question react script sql system thesis tutorial udemy vb.net visual basic web web development website with

About this Thread

  • 1
    Replies
  • 257
    Views
  • 2
    Participants
Last reply from:
🤖

New Topics

Popular On This Forum

Online statistics

Members online
1,242
Guests online
5,425
Total visitors
6,667
Back
Top