cued

Back Back Up Advanced Editor

<?php
// Login Function
	function confirmUser($username, $password, $connmysql){
		
	   	if(!get_magic_quotes_gpc()) {
			$username = addslashes($username);
	   	}
		$result = db_query ("select pasSworD from users where userNamE = '".$username."' OR usereMaiL = '".$username."'", $connmysql);
	   	if(!$result || (mysqli_num_rows($result) < 1)){
			return 1; 
	   	}
		$dbarray = mysqli_fetch_array($result);
		$dbarray['pasSworD'] = stripslashes($dbarray['pasSworD']);
		$password = stripslashes($password);

if($password == $dbarray['pasSworD']){
		  	return 0; 
		} else {
		  	return 2; 
		}
	}
	
// DB Query		
	function db_query($query1, $connmysql)
	{
		$result = mysqli_query($connmysql, $query1);
		if (!$result) {
			$errno = mysqli_errno($connmysql);
			$error = mysqli_real_escape_string(mysqli_error($connmysql));
			$query = mysqli_real_escape_string($query1);
			$dt = date('Y-m-d H:i:s');
			mysqli_query($connmysql, "INSERT INTO error_log VALUES ('$dt', NULL, $errno, '$error', '$query1')");
		}
		return $result;
	}	
// Pagination Function	
	function paginationAll($query,$totalRecord,$section='',$page,$perpage='50'){
		
		$page=($page==0?1:$page);
		$start=($page-1)*$perpage;
		$prev=$page-1;
		$next=$page+1;
		$lastPage=ceil($totalRecord/$perpage);
		$pagination='';
		if($lastPage>1){
			if($page>1){
				$pagination.='<li><a href="?section='.$section.'&page="'.$prev.'""><</a></li>';
			}
			for($i=1;$i<=$lastPage;$i++){
				if($i==$page){
					$pagination.='<li><a class="current">'.$i.'</a></li>';
				}else{
					$pagination.='<li><a href="?section='.$section.'&page='.$i.'">'.$i.'</a></li>';
				}
			}
		}
		$retArr[0]=$start;
		$retArr[1]=$pagination;
		$retArr[2]=$lastPage;
		$retArr[3]=$perpage;
		
		return $retArr;
	}