- Messages
- 8
- Reaction score
- 0
- Points
- 16
pa help naman mga sir/mam, need kong mag upload ng data from excel baka po may tutorial kau dyan
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
Good day mga Sir;
Self study po ako sa web developing ask ko lang kung pano ung code sa php para mag connect ng database at insert query ? Gagawa sana ako ng log in ..
Maraming salamat sa lahat.
May binubuo po kasi akong dashboard para sa business namin. PHP based customer dashboard siya, ang tanong ko po if possible po bang gumawa ng dashboard na may SMS feature?
Hello there! Sino po mga freelance web developer dyan? Tanong lang po, magkano po ba ang pagawa ng isang website for business? Thanks po!
- - - Updated - - -
paano ba yan miss?
Php user po.. Guys patulong nmn.. 2 weeks ko ng inaaral,, d ko pa rin maayos.. d kc nababasa ung laman ng Excel File kapag naUpload.. pero kapag sa local using Xampp eh pwd nmn.. ung database nanggagaling sa Domain.. Cpanel ang gamit... . d ko na alam ang gagawin... lapit na final Defense... patulong nmn po.. pls..
<?php
// [COLOR="#FF0000"]use Box\Spout\Reader\ReaderFactory;[/COLOR]
use Box\Spout\Reader\Common\Creator\ReaderEntityFactory;
require_once './spout-3.1.0/src/Spout/Autoloader/autoload.php';
if(!empty($_FILES['excelfile']['name'])){
$pathinfo = pathinfo($_FILES['excelfile']['name']);
if(($pathinfo['extension'] == 'xlsx' || $pathinfo['extension'] == 'xls')
&& $_FILES['excelfile']['size'] > 0)
{
$file = $_FILES['excelfile']['tmp_name'];
// [COLOR="#FF0000"]$reader = ReaderFactory::create(Type::XLSX);[/COLOR]
$reader = ReaderEntityFactory::createXLSXReader();
$reader->open($file);
foreach ($reader->getSheetIterator() as $sheet) {
foreach ($sheet->getRowIterator() as $row) {
// do stuff with the row
$cells = $row->getCells();
}
}
$reader->close();
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<form method="POST" enctype="multipart/form-data">
<input type="file" name="excelfile" accept=".xlsx,.xls"/>
<button type="submit">Submit</button>
</form>
</body>
</html>
file_uploads = On