template_dir = dirname( __FILE__ ).'/templates';
$smarty->compile_dir = dirname( __FILE__ ).'/templates_c';
/// Fire when new input is submitted
/// Creating a object
$obj = new tutorial_rakib_device_info($db);
/// Table Data download
if(isset($_POST['submitTable']))
{
$myArray = array(
"deviceID" => $_POST['deviceID'],
"deviceManufacturer" => $_POST['deviceManufacturer'],
"deviceSerial" => $_POST['deviceSerial'],
"deviceModel" => $_POST['deviceModel'],
"deviceRating" => $_POST['deviceRating']
);
$id = $obj->create($myArray);
if($id){
//echo 'user was created. Id=' . $id;
}
}
/// Data retrieved from CSV and save to database
$csvImportMsg = "Import csv file.";
if(isset($_POST['import']))
{
//var_dump($_FILES['file']);
$extension = end(explode(".", $_FILES['file']['name']));
if($extension == 'csv'){
$obj->import($_FILES['file']['tmp_name']);
$csvImportMsg = "Successfully imported
'". $_FILES['file']['name']."'";
//echo '';
}
else{
//echo '';
$csvImportMsg = "Wront File inputed! Please input CSV file.";
}
}
/// Export to CSV all data
if(isset($_POST['exp']))
{
if($obj->export()){
echo "success";
}
else{
echo "pare nai";
}
header('Refresh: 1; url=index.php');
}
//setting Page Limit
if(isset($_POST['numberOfRows']))
{
$Limit = $_POST['rowNum'];
}else{
$Limit = 100;
}
/// For Pagination
$totalRecords = $obj->getTotalIDCount();
// echo "{$totalRecords} users found";
$totalPage = ceil($totalRecords/$Limit);
if(isset($_GET['page'])){
$pageNumber = $_GET['page'];
$offset = ($pageNumber - 1) * $Limit;
}
else{
$pageNumber = 1;
}
if($pageNumber > 5){
$pageStart = $pageNumber-5;
//$pageEnd = $pageStart+5;
}
else{
$pageStart = 1;
}
// if(empty($_POST["searchPageInput"])){
// echo "khali";
// }
// else{
// //$value = $_POST["searchPageInput"];
// echo "Voraa";
// }
/// For updating/editing table data
if(isset($_POST['submitTableEdit'])){
$editedID = $_POST['IDEdit'];
$data = Array (
'deviceID' => $_POST['deviceIDEdit'],
'deviceManufacturer' => $_POST['deviceManufacturerEdit'],
'deviceSerial' => $_POST['deviceSerialEdit'],
'deviceModel' => $_POST['deviceModelEdit'],
'deviceRating' => $_POST['deviceRatingEdit'],
);
$obj->updateData($editedID, $data);
}
// For Deleting table Data
if(isset($_POST['submitTableDelete'])){
$deletedID = $_POST['IDDelete'];
echo "aita value delete er ID: ". $deletedID;
$obj->deleteData($deletedID);
}
/// For data retrived from database
// $myRow = $obj->read(); // This will read all the data.
$myRow = $obj->readPage($pageNumber, $Limit);
$smarty->assign("start", $pageStart);
$smarty->assign("page", $pageNumber);
$smarty->assign("myRow", $myRow);
$smarty->assign("csvImportMsg", $csvImportMsg);
$smarty->assign("totalPage", $totalPage);
$smarty->display('index.tpl');
/// ALTER TABLE tutorial_rakib_device_info AUTO_INCREMENT = 1
?>