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>
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>