$user_tz = ''; $connect = new db(); $connect->db_connect(); $controller = new fucn(); //$date1 = '2013-06-05'; //$date2 = '2013-06-27'; if (isset($_REQUEST['id'])) { $placeId = $_REQUEST['id']; $sql = "SELECT name,email FROM businessCustomer_{$placeId} WHERE follow = 1 AND email <> '' GROUP BY email ORDER BY id DESC"; $result = mysql_query($sql) or die(mysql_error()); $ratingTextTemp = array('Name', 'Email'); $array_col = array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"); $r = 0; $c = 1; foreach ($ratingTextTemp as $val) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue($array_col[$r++] . $c, encodequote($val)); } $c = 3; while ($row = mysql_fetch_object($result)) { $r = 0; $colrow = array($row->name, $row->email); foreach ($colrow as $val) { $objPHPExcel->setActiveSheetIndex(0)->setCellValue($array_col[$r++] . $c, $val); } $c++; } $filename = 'followers.xlsx'; $objPHPExcel->getActiveSheet()->setTitle('data'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename="' . $filename . '"');
$txtpoor = encodequote($_REQUEST['txtpoor']); $txtfair = encodequote($_REQUEST['txtfair']); $txtgood = encodequote($_REQUEST['txtgood']); $txtexc = encodequote($_REQUEST['txtexc']); $obj = array('vpoor' => $txtvpoor, 'poor' => $txtpoor, 'fair' => $txtfair, 'good' => $txtgood, 'excellent' => $txtexc); //echo json_encode($obj); echo $json = array2json($obj); $sql = "UPDATE businessCustom SET ratingText= '" . $json . "' WHERE customPlaceId = {$placeId}"; } else { if ($case == 6) { $obj = array('btnshare' => array(encodequote($_REQUEST['txt-share'])), 'share' => array(encodequote($_REQUEST['txtshare1'])), 'logout' => array(encodequote($_REQUEST['txt-logout'])), 'follow' => array(encodequote($_REQUEST['follow-no']), encodequote($_REQUEST['follow-yes'])), 'cambtnoption' => array(encodequote($_REQUEST['btncam1']), encodequote($_REQUEST['btncam2']), encodequote($_REQUEST['btncam3']), encodequote($_REQUEST['btncam4'])), 'campdetails' => array(encodequote($_REQUEST['txt-camdetails'])), 'btnwidget' => array(encodequote($_REQUEST['txt-widget']))); echo $json = array2json($obj); $sql = "UPDATE businessCustom SET button= '" . $json . "' WHERE customPlaceId = {$placeId}"; } else { if ($case == 7) { $obj = array('logoutT' => encodequote($_REQUEST['txtbox9']), 'logoutB' => encodequote($_REQUEST['txtbox10']), 'followT' => encodequote($_REQUEST['txtbox11']), 'followB' => encodequote($_REQUEST['txtbox12']), 'share' => encodequote($_REQUEST['txtbox3']), 'shareB' => encodequote($_REQUEST['txtbox22']), 'sharedT' => encodequote($_REQUEST['txtbox26']), 'sharedB' => encodequote($_REQUEST['txtbox27'])); $json = array2json($obj); $sql = "UPDATE businessCustom SET messageBox= '" . $json . "' WHERE customPlaceId = {$placeId}"; } else { if ($case == 8) { $obj = ''; if ($_REQUEST['check'] != '') { $obj = explode(',', $_REQUEST['check']); echo $json = array2json($obj); } $sql = "UPDATE businessCustom SET selectedItems= '" . $json . "' WHERE customPlaceId = {$placeId}"; } else { if ($case == 9) { $obj = ''; $json = ''; if ($_REQUEST['check']) {