PHP mainpage_query Examples

Example #1

File: ajax_finalMassDell.php Project: peskovsb/MailAppTesting

		$tb->execute(array(':login'=>$username));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}	
	function writeLoging($inneruserId,$rzlt){
		$sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"мн. удаление",:rzlt,"1","'.$_SERVER["REMOTE_ADDR"].'")';
		$tb = $this->dbIt->connection->prepare($sql);
		$tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt));
	}
}

//print_r($_GET);

$count=0;

$dellData = new mainpage_query();
foreach($_GET as $DelUsers){
	$count++;
		$userGet = $dellData -> getDatafromtableUsers($DelUsers);
	if(count($_GET)==$count){
		$email .= $userGet['login'];
	}else{
		$email .= $userGet['login'] .', ';
	}
	$dellData ->Deletefromtable($DelUsers);	
}
$dellData ->writeLoging($_SESSION['user_id'],$email);
?>

Example #2

File: ajax_dbGrp_cor.php Project: peskovsb/MailAppTesting

			}else{
				if(strlen($nameGroup)=='0'){
					$this->rezArr[0]['level']['mistakeIU'] = 'mistake';
					$this->rezArr[0]['level']['msg'] = 'Группа не должна быть с пустым названием';
					$mistake = 1;
				}else{
					$this->rezArr[0]['level']['mistakeIU'] = 'nomistake';
				}
			}
		}
		
		if($grp_view2 != 'on' AND $grp_view != 'on' AND $grp_view3 != 'on'){
			$this->rezArr[0]['view']['mistakeIU'] = 'mistake';
			$this->rezArr[0]['view']['msg'] = 'Нужно выбрать одну из галочек просмотр';
			$mistake = 1;
		}else{
			$this->rezArr[0]['view']['mistakeIU'] = 'nomistake';
		}
			
			return $this->rezArr;	
				
	}	
}
$getData = new mainpage_query();
$arrGetter = $getData ->getAllfromtable($FirstNameGroup,$nameGroup,$grp_createuser,$grp_view,$grp_view2,$grp_correct,$grp_correct2,$grp_createuser2,$grp_view3);
echo json_encode($arrGetter);



?>

Example #3

File: ajax_list_mainpage.php Project: peskovsb/MailAppTesting

class mainpage_query{
	public $arrBest;
	public $db;
	function __construct(){
		$this->db = new Database();
	}
	function getAllfromtable($sql){
		
		$tb = $this->db->connection->prepare($sql);
		$tb->execute();
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}
$getData = new mainpage_query();
$arrLogin = $getData -> getAllfromtable($sql);

$arrList = array();
$counter = 0;
foreach($arrLogin as $Items){
	$arrList[] = $Items;
}
foreach($arrList as $arItMs){
	//if(date("m-d-Y",  strtotime($arItMs['userdate']) === '01-01-1970')){
		//$arrList[$counter]['userdate'] = '00-00-0000';
	//}else{
	
		$arrList[$counter]['userdate'] = date("d-m-Y",  strtotime($arItMs['userdate']));
	if(date("d-m-Y",  strtotime($arItMs['userdate'])) == '01-01-1970'){$arrList[$counter]['userdate'] = '00-00-0000';}	
	//}

Example #4

File: ajax_login_validate_corr_subm.php Project: peskovsb/MailAppTesting

class mainpage_query{
	public $arrBest;
	public $db;
	function __construct(){
		$this->db = new DatabaseItDept();
	}
	function getLoginfromtable($login_request){
		$sql = 'SELECT * FROM inner_users WHERE user_login = :login';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':login'=>$login_request));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}
$getData = new mainpage_query();
$takeUser = $getData ->getLoginfromtable($login_request);

//--userPHPvalidation
if($takeUser['user_id'] AND $takeUser['user_id'] != $loginid_before){
	$rezArr[0]['login']['exitsIU'] = 'noway';
	$rezArr[0]['login']['mistakeIU'] = 'mistake';
	$rezArr[0]['login']['msg'] = 'Такой логин уже есть в системе';
}else{
	$rezArr[0]['login']['exitsIU'] = 'goyes';
		if(preg_match("/[\s,*?&^%><+\$№#`~=!АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯабвгдеёжзийклмнопрстуфхцчшщъыьэюя]/", $login_request)){
			$rezArr[0]['login']['mistakeIU'] = 'mistake';
			$rezArr[0]['login']['msg'] = 'Логин не должен использовать знаки русского алфавита и различные символы';
		}else{
			if(strlen($login_request)<='3'){
				$rezArr[0]['login']['mistakeIU'] = 'mistake';

Example #5

File: ajax_autoload_alias.php Project: peskovsb/MailAppTesting

		$this->db = new Database();
	}
	function getAllfromtable($email_request){
		$sql = 'SELECT `user_id`,`email` FROM users WHERE email LIKE :email';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':email'=>'%'.$email_request.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

//-- Relevant Search Starts
if($email_request){

//-- Get Data From Main Class & Func
$getData = new mainpage_query();
$arremail = $getData ->getAllfromtable($email_request);

$mainResult[] = $arremail;
$counter=0;
	foreach($mainResult[0] as $Items){
		if (preg_match("/^$email_request/", $Items['email'])) {
			$matchArr[$counter]['user_id'] = $Items['user_id'];
			$matchArr[$counter++]['email'] = $Items['email'];
		}
	}
	
	//-- sort this array ASC
	if($matchArr){
		asort($matchArr);
	}

Example #6

File: ajax_fin_del.php Project: peskovsb/MailAppTesting

<?
require '../../db.php';

$param = $_GET['finDel'];

class mainpage_query{
	public $arrBest;
	public $db;
	function __construct(){
		$this->db = new DatabaseItDept();
	}
	function Deletefromtable($param){
		$sql = 'DELETE FROM inner_users WHERE user_id=:user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$param));
	}
}


$dellData = new mainpage_query();
$dellData ->Deletefromtable($param);
?>

Example #7

File: ajax_del.php Project: peskovsb/MailAppTesting

	public $arrBest;
	public $arrCheckRepl;
	public $db;
	function __construct(){
		$this->db = new DatabaseItDept();
	}

	function getDatafromtable($login_request){
		$sql = 'SELECT * FROM inner_users WHERE user_id = :loginID';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':loginID'=>$login_request));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}		
}
$getData = new mainpage_query();

$getter = $getData ->getDatafromtable($user_id);
?>

<!-- Rezult adding to the DB Showing -->
<div class="delete-user-fancy-box" style="width:260px;">
	<div class="header-delete-user-fancybox">Вы уверены, что хотите удалить именно этого пользователя?</div>
	<div class="result-blocks"><b>id пользователя: </b><b style="color:#0044cc"><?php 
echo $getter['user_id'];
?>
</b></div>
	<div class="result-blocks"><b>login: </b> <b style="color:#0044cc"><?php 
echo $getter['user_login'];
?>
</b></div>

Example #8

File: ajax_login_dbcorr.php Project: peskovsb/MailAppTesting

		$sql = 'UPDATE inner_users SET user_login=:login, user_level=:level, user_name=:name, user_surname=:surname, active=:active WHERE user_id=:user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$loginid_before,':login'=>$login_request,':level'=>$field_inner_levels,':name'=>$field_inner_name,':surname'=>$field_inner_surname,':active'=>$field_inner_active));
	}
	function PassCorrect($pass_write,$loginid_before,$salt){
		$sql = 'UPDATE inner_users SET user_pass=:pass, salt=:salt WHERE user_id=:user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':pass'=>$pass_write,':salt'=>$salt,':user_id'=>$loginid_before));
	}		
	function SidCorrect($loginid_before){
		$sql = 'UPDATE inner_users SET sid=1 WHERE user_id=:user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$loginid_before));
	}		
}
$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($login_request,$field_inner_levels,$field_inner_surname,$field_inner_name,$loginid_before,$field_inner_active);

//if pass strlength>5 and all the Condtions srart function

if(strlen($field_inner_pass)>5){
	$arrLogin = $getData ->PassCorrect($pass_write,$loginid_before,$salt);
}

if($field_inner_active == 0){
	$getData -> SidCorrect($loginid_before);
}

//$getter = $getData ->getDatafromtable($login_request);

/*$levels = array(

Example #9

File: ajax_massdelete_login_fancy_alias.php Project: peskovsb/MailAppTesting

class mainpage_query{
	public $arrBest;
	public $db;
	function __construct(){
		$this->db = new Database();
	}
	function getAllfromtable($param){
		$sql = 'SELECT * FROM aliases WHERE alias_id = :alias_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':alias_id'=>$param));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

$getData = new mainpage_query();
foreach($_GET as $DelUsers){
	$arrUsers[] = $getData ->getAllfromtable($DelUsers);
}

//-- make string
$cnt = 0;
$string = '';
foreach($_GET as $userDellNumbers){
$cnt++;
	if($cnt == count($_GET)){
		$string .= 'del_user_'. $cnt . '=' . $userDellNumbers;
	}else{
		$string .= 'del_user_'. $cnt . '=' . $userDellNumbers . '&' ;
	}
	

Example #10

File: ajax_list_search.php Project: peskovsb/MailAppTesting

		$tb->execute(array(':keyword'=>'%'.$search.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
	function getAllfromtableSername($search,$blocked){
		$sql = 'SELECT *, DATE_FORMAT(userdate,"%d-%m-%Y") as userdate FROM users WHERE'.$blocked.' sername LIKE :keyword';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':keyword'=>'%'.$search.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

if($search){

$getData = new mainpage_query();

if($methodSearch=='login'){
$arrSearch = $getData ->getAllfromtableLogin($search,$blocked);
}

if($methodSearch=='email'){
$arrSearch = $getData ->getAllfromtableEmail($search,$blocked);
}

if($methodSearch=='name'){
$arrSearch = $getData ->getAllfromtableName($search,$blocked);
}

if($methodSearch=='sername'){
$arrSearch = $getData ->getAllfromtableSername($search,$blocked);

Example #11

File: cron_deleter.php Project: peskovsb/MailAppTesting

require 'db.php';

class mainpage_query{
	public $arrBest;
	public $items;
	public $db;
	function __construct(){
		$this->db = new Database();
	}
	function deleteRows(){
		$sql = 'SELECT * FROM aliases WHERE DATE_FORMAT(aliasdateto, "%Y-%m-%d") < DATE_FORMAT(NOW(), "%Y-%m-%d") AND aliasdateto!="0000-00-00 00:00:00"';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute();
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		foreach($this->arrBest as $Items){
		$userName = $Items['username'].'@bioline.ru';
			$sql = 'UPDATE bcc SET active=0 WHERE bcc_name = :bcc_name';
			$tb = $this->db->connection->prepare($sql);
			$tb->execute(array(':bcc_name'=>$userName));
		}
		
		//--DELLPART
		$sql = 'DELETE FROM aliases WHERE DATE_FORMAT(aliasdateto, "%Y-%m-%d") < DATE_FORMAT(NOW(), "%Y-%m-%d") AND aliasdateto!="0000-00-00 00:00:00"';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute();
	}
}


$dateWork = new mainpage_query();
$dateWork->deleteRows();

Example #12

File: ajax_login_list_grp.php Project: peskovsb/MailAppTesting

		}
		$tb = $this->db->connection->prepare($sql);
		$tb->execute();
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		$count = 0;
		$this->arrModify = $this->arrBest;
		foreach($this->arrBest as $Items){
			$sql = 'SELECT * FROM operations WHERE oper_connect_id = :oper_id';
			$tb = $this->db->connection->prepare($sql);
			$tb->execute(array(':oper_id'=>$Items['level_id']));
			$this->arrChecked = $tb->fetch(PDO::FETCH_ASSOC);
			
			
			$this->arrModify[$count]['oper_create_post'] = $this->arrChecked['oper_create_post'];
			$this->arrModify[$count]['oper_view_post'] = $this->arrChecked['oper_view_post'];
			$this->arrModify[$count]['oper_correct_post'] = $this->arrChecked['oper_correct_post'];
			$this->arrModify[$count]['oper_create_forw'] = $this->arrChecked['oper_create_forw'];
			$this->arrModify[$count]['oper_view_forw'] = $this->arrChecked['oper_view_forw'];
			$this->arrModify[$count]['oper_correct_forw'] = $this->arrChecked['oper_correct_forw'];
			$this->arrModify[$count]['komment_group'] = $this->arrChecked['komment_group'];
			$count++;
		}
		return $this->arrModify;
	}	
}
$getData = new mainpage_query();

$getter = $getData ->getDatafromtable($showlist);

echo json_encode($getter);
?>

Example #13

File: ajax_finalCorrect.php Project: peskovsb/MailAppTesting

			$sername = $userData['staff_lastname'];
			$username = $userData['staff_name'];
		}		
		
		$sql = 'UPDATE users SET login=:login, password=:password, email=:email, sername=:sername, name=:username, mailbox=:mailbox, userdate=:userdate, domain_id=:domain_id, active=:active, staff_id=:staff_id WHERE user_id=:user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$user_id,':login'=>$login,':password'=>$password,':email'=>$email,':username'=>$username,':sername'=>$sername,':mailbox'=>$mailbox,':userdate'=>date('Y-m-d',strtotime($userdate)),':domain_id'=>$domain_id,':active'=>$active,':staff_id'=>$profile_create));
		/*$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;*/
	}	
	function writeLoging($inneruserId,$rzlt){
		$sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"редактирование",:rzlt,"1","'.$_SERVER["REMOTE_ADDR"].'")';
		$tb = $this->dbIt->connection->prepare($sql);
		$tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt));
	}
	function writeLogingBlocking($inneruserId,$rzlt){
		$sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`) VALUES (NOW(),:login_id,"блокирование",:rzlt,"1")';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt));
	}
}

$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($user_id,$login,$password,$email,$username,$sername,$mailbox,$userdate,$domain_id,$active,$profile_create);

$getData ->writeLoging($_SESSION['user_id'],$login);

if(empty($active)){
	$getData ->writeLogingBlocking($_SESSION['user_id'],$login);
}
?>

Example #14

File: ajax_correct_login_fancy_alias.php Project: peskovsb/MailAppTesting

	}
	function getTextData(){
		$sql = 'SELECT `active`,`bcc_autoreply_text` FROM bcc WHERE bcc_name = :reply_login';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':reply_login'=>$this->arrBest['username'].'@bioline.ru'));
		$this->arrC = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrC;
	}
}

function br2nl($string)
{
	return str_replace("<br />","\r\n", $string);
}

$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($param);
$arrMsg = $getData ->getTextData();
?>

<div class="delete-user-fancy-box">
<?

//explode Array
$arrExpld = explode(',',$arrLogin['alias']);


	if($arrMsg['active']=='1'){
		$chkBox = '1';
	}
?>

Example #15

File: ajax_list_search_htmlout.php Project: peskovsb/MailAppTesting

		$tb->execute(array(':keyword'=>'%'.$search.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
	function getAllfromtableEmail($search){
		$sql = 'SELECT *, DATE_FORMAT(userdate,"%d-%m-%Y") as userdate FROM users WHERE email LIKE :keyword';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':keyword'=>'%'.$search.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

if($search){

$getData = new mainpage_query();

if($methodSearch=='login'){
$arrSearch = $getData ->getAllfromtableLogin($search);
}

if($methodSearch=='email'){
$arrSearch = $getData ->getAllfromtableEmail($search);
}

if(count($arrSearch)==0){
	$arrSearch['mistake'] = 'mistake';
}else{

}

Example #16

File: ajax_lists.php Project: peskovsb/MailAppTesting

		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':location_id'=>$param));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
	
	function getMail($param){		
		$sql = 'SELECT * FROM users WHERE staff_id = :staff_id';
		$tb = $this->dbMail->connection->prepare($sql);
		$tb->execute(array(':staff_id'=>$param));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

$getData = new mainpage_query($pagiPage,$limit,$typePage,$_POST['staff_option'],$searchData);

$getter = $getData ->getDatafromtable($_POST['valComp_filt'],$_POST['valDep_filt'],$_POST['valLoca_filt']);

$counter = 0;
foreach($getter as $arItMs){
$companyName = $getData -> getCompanyById($arItMs['staff_company_id']);
$depName = $getData -> getDepById($arItMs['staff_depart_id']);
$grName = $getData -> getGroupyById($arItMs['staff_group_id']);
//$avatar = $getData -> getAvatar($arItMs['staff_lastname'],$arItMs['staff_name'],$arItMs['staff_secondname']);
$locaName = $getData -> getLocation($arItMs['staff_location']);
$UserMail = $getData -> getMail($arItMs['staff_id']);
	$getter[$counter]['staff_company_id'] = $companyName['company_name'];
	$getter[$counter]['staff_depart_id'] = $depName['department_name'];
	if($arItMs['staff_ats']=='0'){$getter[$counter]['staff_ats'] = '';}
	if($arItMs['staff_group_id']=='0'){$getter[$counter]['staff_group_id'] = '';}else{

Example #17

File: ajax_finalCorrect_alias.php Project: peskovsb/MailAppTesting

		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':reply_login'=>$username,':reply_msg'=>$repl_msg));
	}
	function ChangeChk($username,$autoCheck){
		$sql = 'UPDATE bcc SET active=:active_chk WHERE bcc_name = :reply_login';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':reply_login'=>$username,':active_chk'=>$autoCheck));
	}
	function writeLoging($inneruserId,$rzlt){
		$sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"редактирование",:rzlt,"2","'.$_SERVER["REMOTE_ADDR"].'")';
		$tb = $this->dbIt->connection->prepare($sql);
		$tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt));
	}	
}

$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($user_id,$username,$datefrom,$email,$datefrom,$dateto);

$getData ->writeLoging($_SESSION['user_id'],$username);

//--auto replay msg
	$arrCheck = $getData ->checkIfExAutoReply($bcc_names);
		if($arrCheck['bcc_id']){
			if(!$repl_msg==''){
				$getData ->UpdAutoReply($bcc_names,$repl_msg);
			}
			$arrChkBox = $getData -> ChangeChk($bcc_names,$autoCheck);
		}else{
			$arrInsertRepl = $getData ->writeInAutoReply($bcc_names,$bcc_maps,$repl_msg,$autoCheck);
		}		

Example #18

File: ajax_finalDell_alias.php Project: peskovsb/MailAppTesting

		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':alias_id'=>$param));
		

	}
	function getDatafromtableUsers($username){
		$sql = 'SELECT * FROM aliases WHERE alias_id = :login';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':login'=>$username));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}	
	function writeLoging($inneruserId,$rzlt){
		$sql = 'INSERT INTO loging (`tmlog`,`login_id`,`moving`,`rzlt`,`vargroup`,`ipuser`) VALUES (NOW(),:login_id,"удаление",:rzlt,"2","'.$_SERVER["REMOTE_ADDR"].'")';
		$tb = $this->dbIt->connection->prepare($sql);
		$tb->execute(array(':login_id'=>$inneruserId,':rzlt'=>$rzlt));
	}	
}

//print_r($_GET);
$dellData = new mainpage_query();

$userGet = $dellData -> getDatafromtableUsers($param);

$dellData -> writeLoging($_SESSION['user_id'],$userGet['username']);

$dellData ->Deletefromtable($param);
?>

Example #19

File: ajax_group_correct.php Project: peskovsb/MailAppTesting

	function __construct(){
		$this->db = new DatabaseItDept();
	}
	
	function getAllfromtable($idGroup,$nameGroup,$grp_createuser,$grp_view,$grp_view2,$grp_correct,$grp_correct2,$grp_createuser2,$komment_group,$grp_createuser3,$grp_view3,$grp_correct3){
		if($grp_view == 'on'){$grp_view='1';}else{$grp_view='0';}
		if($grp_view2 == 'on'){$grp_view2='1';}else{$grp_view2='0';}
		if($grp_view3 == 'on'){$grp_view3='1';}else{$grp_view3='0';}
		if($grp_correct == 'on'){$grp_correct='1';}else{$grp_correct='0';}
		if($grp_correct2 == 'on'){$grp_correct2='1';}else{$grp_correct2='0';}
		if($grp_correct3 == 'on'){$grp_correct3='1';}else{$grp_correct3='0';}
		if($grp_createuser == 'on'){$grp_createuser='******';}else{$grp_createuser='******';}
		if($grp_createuser2 == 'on'){$grp_createuser2='1';}else{$grp_createuser2='0';}
		if($grp_createuser3 == 'on'){$grp_createuser3='1';}else{$grp_createuser3='0';}
		
		//echo $grp_view3;
		
			//-- WRITING DB
			$sql = 'UPDATE levels SET level_name = :level_name WHERE level_id = :level_id';
			$tb = $this->db->connection->prepare($sql);
			$tb->execute(array(':level_id' => $idGroup,':level_name'=>$nameGroup));	
			
			$sql = 'UPDATE operations SET oper_view_staff = :oper_view_staff, oper_correct_staff = :oper_correct_staff, oper_create_staff = :oper_create_staff, oper_create_post = :oper_create_post,oper_view_post = :oper_view_post,oper_correct_post = :oper_correct_post,oper_create_forw = :oper_create_forw,oper_view_forw = :oper_view_forw,oper_correct_forw = :oper_correct_forw,komment_group = :komment_group WHERE oper_connect_id = :oper_connect_id';
			$tb = $this->db->connection->prepare($sql);
			$tb->execute(array(':oper_connect_id'=>$idGroup,':oper_create_post'=>$grp_createuser,':oper_view_post'=>$grp_view,':oper_correct_post'=>$grp_correct,':oper_create_forw'=>$grp_createuser2,':oper_view_forw'=>$grp_view2,'oper_correct_forw'=>$grp_correct2,'komment_group'=>$komment_group,':oper_create_staff'=>$grp_createuser3,':oper_view_staff'=>$grp_view3,':oper_correct_staff'=>$grp_correct3));	
	}	
}
$getData = new mainpage_query();
$arrGetter = $getData ->getAllfromtable($idGroup,$nameGroup,$grp_createuser,$grp_view,$grp_view2,$grp_correct,$grp_correct2,$grp_createuser2,$komment_group,$grp_createuser3,$grp_view3,$grp_correct3);
?>

Example #20

File: ajax_login_dbwrite.php Project: peskovsb/MailAppTesting

	function getDatafromtable($login_request){
		$sql = 'SELECT * FROM inner_users WHERE user_login = :login ORDER BY user_id DESC';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':login'=>$login_request));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}	
	function getDataGrps($grpLevel){
		$sql = 'SELECT * FROM levels WHERE level_id = :level';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':level'=>$grpLevel));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}		
}
$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($login_request,$pass_write,$field_inner_levels,$salt,$field_inner_surname,$field_inner_name);

$getter = $getData ->getDatafromtable($login_request);
$getterGrp = $getData ->getDataGrps($getter['user_level']);
?>

<!-- Rezult adding to the DB Showing -->
<div class="content-wrapper-alias" style="display: block;">
<h1 class="result-header">Рузультат добавления в базу данных</h1>

	<div class="result-blocks"><b>id пользователя: </b><b style="color:#0044cc"><?php 
echo $getter['user_id'];
?>
</b></div>
	<div class="result-blocks"><b>username: </b><?php 

Example #21

File: ajax_autoload_username.php Project: peskovsb/MailAppTesting

		$this->db = new Database();
	}
	function getAllfromtable($login_request){
		$sql = 'SELECT `user_id`,`login` FROM users WHERE login LIKE :login';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':login'=>'%'.$login_request.'%'));
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

//-- Relevant Search Starts
if($login_request){

//-- Get Data From Main Class & Func
$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($login_request);

$mainResult[] = $arrLogin;
$counter=0;
	foreach($mainResult[0] as $Items){
		if (preg_match("/^$login_request/", $Items['login'])) {
			$matchArr[$counter]['user_id'] = $Items['user_id'];
			$matchArr[$counter++]['login'] = $Items['login'];
		}
	}
	
	//-- sort this array ASC
	if($matchArr){
		asort($matchArr);
	}

Example #22

File: ajax_login_list_logs.php Project: peskovsb/MailAppTesting

	function getDatafromtable(){
		$this->pagiPage = ($this->pagiPage-1) * $this->limit;
		$sql = 'SELECT * FROM loging ORDER BY id DESC LIMIT '.$this->pagiPage.','.$this->limit;
		$tb = $this->db->connection->prepare($sql);
		$tb->execute();
		$this->arrBest = $tb->fetchAll(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}	
	function getUserById($userid){
		$sql = 'SELECT * FROM inner_users WHERE user_id = :user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$userid));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}		
}
$getData = new mainpage_query($pagiPage,$limit);

$getter = $getData ->getDatafromtable();

$counter = 0;
foreach($getter as $arItMs){
$userLogin = $getData -> getUserById($arItMs['login_id']);	
if(!$getter[$counter]['ipuser']){$getter[$counter]['ipuser'] = '******';} 
		$getter[$counter]['login_id'] = $userLogin['user_login'];
		$getter[$counter]['tmlog'] = date("d-m-y H:i:s",  strtotime($arItMs['tmlog']));
	$counter ++;
}

echo json_encode($getter);
?>

Example #23

File: ajax_alias_mainform.php Project: peskovsb/MailAppTesting

class mainpage_query{
	public $arrBest;
	public $db;
	function __construct(){
		$this->db = new Database();
	}
	function getAllfromtable($param){
		$sql = 'SELECT * FROM aliases WHERE alias_id = :alias_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':alias_id'=>$param));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}
}

$getData = new mainpage_query();
$arrLogin = $getData ->getAllfromtable($param);

?>

<div class="delete-user-fancy-box">
<?

//explode Array
$arrExpld = explode(',',$arrLogin['alias']);
?>
<form id="a_makeForm" action="#" method="POST">
	<table>
		<tr>
			<td><label for="cor_username">username</label></td>
			<td style="position:relative;">

Example #24

File: ajax_filter.php Project: peskovsb/MailAppTesting

		if($this->arrUserLogin['user_id']){
			return $this->arrUserLogin;
		}else{
			$this->arrUserLogin['user_id'] = $userId;
		}
		
	}	
	function getUserById($userid){
		$sql = 'SELECT * FROM inner_users WHERE user_id = :user_id';
		$tb = $this->db->connection->prepare($sql);
		$tb->execute(array(':user_id'=>$userid));
		$this->arrBest = $tb->fetch(PDO::FETCH_ASSOC);
		return $this->arrBest;
	}		
}
$getData = new mainpage_query($pagiPage,$limit);


if($_GET['IU-filteruser']){
	$arrUser = $getData->getUserLogin($_GET['IU-filteruser']);
}

$arrData = $getData->getDatafromtable($_GET['IU-filtercats'],$_GET['IU-filtermoves']);

$count = 0;
foreach($arrData as $arrItems){
	$arrAll[] = $arrItems;
	if($_GET['IU-filteruser']){	
		if(!$arrAll[$count]['ipuser']){$arrAll[$count]['ipuser'] = '******';} 	
		$arrAll[$count]['login_id'] = $arrUser['user_login'];
		$arrAll[$count]['login_search'] = $arrUser['user_login'];