 |
|
<?php
session_start();
error_reporting(E_ALL & ~E_NOTICE);
function populate_select($table,$fields_id,$fields_value,$selected){
$conn=db_connect(HOST,USER,PASS,DB,PORT);
$sql="Select $fields_id,$fields_value From $table Order By $fields_value";
$results=mkr_query($sql,$conn);
while ($row = fetch_object($results)){
$SelectedCountry=($row->$fields_id==$selected) ? " selected" : "";
echo "<option value=" . $row->$fields_id . $SelectedCountry . ">" . $row->$fields_value . "</option>";
//($row->$fields_id==$selected) ? 'selected' : '';
}
free_result($results);
}
function signon(){
echo "<input name=\"login\" type=\"submit\" value=\"";
echo !isset($_COOKIE['data_login']) ? "Login" : "Logout";
echo "\"/></input><br>";
//echo "<font color=\"#339999\">Signed in as: " . $_COOKIE['data_login'] . "</font>";
echo "<font color=\"#339999\">Signed in as: " . "<br/>" .$_SESSION["employee"] . "</font>";
}
function delete_copy() {
/* makes connection */
$conn=db_connect(HOST,USER,PASS,DB,PORT);
/* Creates SQL statement to retrieve the copies using the releaseID */
$sql = "DELETE FROM $file WHERE $recordid =" . $_POST['ID'];
$results=mkr_query($sql,$conn);
$msg[0]="Sorry ERROR in deletion";
$msg[1]="Record successful DELETED";
AddSuccess($results,$conn,$msg);
/* Closes connection */
mysql_close ($conn);
/* calls get_data */
//get_data();
}
class formValidator{
private $errors=array();
public function __construct(){}
// validate empty field
public function validateEmpty($field,$errorMessage,$min=1 ,$max=32){
if(!isset($_POST[$field])||trim($_POST[$field])==''||strlen($_POST[$field])<$min||strlen($_POST[$field])>$max){
$this->errors[]=$errorMessage;
}
}
// validate integer field
public function validateInt($field,$errorMessage){
if(!isset($_POST[$field])||!is_numeric($_POST[$field])||intval($_POST[$field])!=$_POST[$field]){
$this->errors[]=$errorMessage;
}
}
// validate numeric field
public function validateNumber($field,$errorMessage){
if(!isset($_POST[$field])||!is_numeric($_POST[$field])){
$this->errors[]=$errorMessage;
}
}
// validate if field is within a range
public function validateRange($field,$errorMessage,$min=1,$max=99){
if(!isset($_POST[$field])||$_POST[$field]<$min||$_POST[$field]>$max){
$this->errors[]=$errorMessage;
}
}
// validate alphabetic field
public function validateAlphabetic($field,$errorMessage){
if(!isset($_POST[$field])||!preg_match("/^[a-zA-Z]+$/",$_POST[$field])){
$this->errors[]=$errorMessage;
}
}
// validate alphanumeric field
public function validateAlphanum($field,$errorMessage){
if(!isset($_POST[$field])||!preg_match("/^[a-zA-Z0-9]+$/",$_POST[$field])){
$this->errors[]=$errorMessage;
}
}
// validate email - does not work on windows machine
public function validateEmail($field,$errorMessage){
if(!isset($_POST[$field])||!preg_match("/.+@.+\..+./",$_POST[$field])||!checkdnsrr(array_pop(explode("@",$_POST[$field])),"MX")){
$this->errors[]=$errorMessage;
}
}
// check for errors
public function checkErrors(){
if(count($this->errors)>0){
return true;
}
return false;
}
// return errors
public function displayErrors(){
$errorOutput='<ul>';
foreach($this->errors as $err){
$errorOutput.='<li>'.$err.'</li>';
}
$errorOutput.='</ul>';
return $errorOutput;
}
}
//todo - customize
function findguest($search){
global $conn,$guests;
$search=$search;
//check on wether search is being done on idno/ppno/guestid/guestname
$sql="Select guests.guestid,guests.lastname,guests.firstname,guests.middlename,guests.pp_no,
guests.idno,guests.countrycode,guests.pobox,guests.town,guests.postal_code,guests.phone,
guests.email,guests.mobilephone,countries.country
From guests
Inner Join countries ON guests.countrycode = countries.countrycode where guests.guestid='$search'";
$results=mkr_query($sql,$conn);
$guests=fetch_object($results);
}
function AddSuccess($results,&$conn,$msg){
if ((int) $results==0){
//should log mysql errors to a file instead of displaying them to the user
echo 'Invalid query: ' . mysql_errno($conn). "<br>" . ": " . mysql_error($conn). "<br>";
echo "<div align=\"center\"><h1>$msg[0]</h1></div>";
}else{
echo "<div align=\"center\"><h1>$msg[1]</h1></div>";
//return(AddSuccess);
}
}
function paginate($nRecords){
$strOffSet=$_SESSION["strOffSet"];
switch ($_POST["Navigate"]){
case "<<":
$strOffSet=0;
break;
case "<":
if ($strOffSet>$nRecords){
$strOffSet=$strOffSet-1;
}else{
$strOffSet=0;
}
//$strPage = $strPage==0 ? 1 : $strPage; //checks to see that page numbers don't go to neg
break;
case ">":
if ($strOffSet<$nRecords){
$strOffSet=$strOffSet+1;
}else{
$strOffSet=$nRecords-1;
}
break;
case ">>":
$strOffSet=$nRecords;
break;
default:
$strOffSet = $strOffSet==0 ? 0 : $strOffSet;
}
$_SESSION["strOffSet"]=$strOffSet; //counts offset values
}
?>
Parse error: parse error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in d:\appserv\www\hotelmis\functions.php on line 41
Tag : - - - -
|
|
|
 |
 |
 |
 |
| Date :
16 ม.ค. 2550 16:30:58 |
By :
deknakhon |
View :
2407 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
