/home/mip/public_html_/old_mip/func-select.php
<?php
//require the configurations for mysql connections.
require_once("config.php");
/* The collection of functions that query the database in select statement. */
function cmd_guid(){
global $SERVER_ADDR;
$loc_guid = strtoupper(md5(uniqid(rand(),1)));
return ($loc_guid);
}
/* The function getdata() get all the data in a table. */
function getdata($query)
{
$db = db_connect();
echo mysql_error();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$count = 1;
mysql_set_charset('utf8');
@$result = mysql_query($query, $db);
@$num_rows = mysql_num_rows($result);
if ($num_rows > 0)
{
while ($myrow = mysql_fetch_array($result))
{
foreach($myrow as $key => $value)
{
if (!is_numeric($key))
{
$row[$key]=stripslashes($value);
}
}
$array1[$count] = $myrow;
$count++;
}
return $array1;
} //end of if ($num_rows > 0).
else return $array1;
} //end of function getdata($query).
//select one field only.
function getdata_one($select,$table,$field,$value)
{
//extract from the database all users.
if (!($conn = db_connect()))
return false;
$sql = "select $select from $table where $field = ";
if (is_numeric($value)){$sql .= " $value";}
else {$sql .= " '$value'";}
$result = mysql_query($sql);
if (!$result || (mysql_num_rows($result)<=0))
return false;
$ans = mysql_fetch_array ($result);
foreach ($ans as $key => $value)
{
$ans[$key]=stripslashes($value);
}
return $ans;
} //end of function getdata_one($select,$table,$field,$value).
/* The function getname() get the equivalent name of an id */
function getname($id,$table,$field)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "select name from $table where $field=$id";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
return $myrow[0];
}//end of function getname.
/* The function getname() get the equivalent name of an id */
function getfield($what,$table,$field,$id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "select $what from $table where $field='$id'";
$result = mysql_query($query,$db);
$myrow = @mysql_fetch_array($result);
return $myrow[0];
} //end of function getname.
/* The function get_applicantname() get the equivalent name of an applicant_id */
function get_applicantname($applicant_id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "select (concat(lname,', ',fname,' ',mname)) as applicant_name from personal where applicant_id='$applicant_id'";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
return $myrow[0];
} //end of function get_applicantname.
/* The function get_num_applied in a campaign or a job order()*/
function get_num_applied($job_order_id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "SELECT count(job_order_id) as num
FROM process
WHERE job_order_id=$job_order_id";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
if($result) return $myrow[num];
else return 0;
}// end of function get_num_applied().
/* The function get_num_vacancies in a campaign or a job order()*/
function get_num_vacancies($job_order_id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "SELECT (SUM(no_of_male + no_of_female + no_of_coed)) as num_vacancies
FROM jo_position
WHERE job_order_id=$job_order_id";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
if($result) return $myrow[num_vacancies];
else return 0;
}// end of function get_num_vacancies().
/* The function get_num_applied in a campaign or a job order()*/
function get_num_applied_invisa($visa_id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "SELECT count(visa_id) as num
FROM process
WHERE visa_id=$visa_id";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
if($result) return $myrow[num];
else return 0;
}// end of function get_num_applied().
/* The function get_num_vacancies in a campaign or a job order()*/
function get_num_vacancies_invisa($visa_id)
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "SELECT (SUM(no_of_male + no_of_female + no_of_coed)) as num_vacancies
FROM visa_position
WHERE visa_id=$visa_id";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
if($result) return $myrow[num_vacancies];
else return 0;
}// end of function get_num_vacancies().
/* The function get_count() get the equivalent number records in a table*/
function get_count($table,$field=1,$id=1,$and="")
{
$db = db_connect();
if (!$db)
{
echo "Error connecting to database.</center>\n";
exit;
}
$query = "select count(*) from $table where $field='$id' $and";
$result = mysql_query($query,$db);
echo mysql_error();
$myrow = mysql_fetch_array($result);
return $myrow[0];
}// end of function getname.
/* Function to connect to the database */
function db_connect()
{
global $db_host ,$db_name, $db_username, $db_password;
$result = @mysql_pconnect("$db_host", "$db_username","$db_password");
if (!$result) return false;
if (!@mysql_select_db("$db_name")) return false;
return($result);
} //end of function db_connect().
/* Function to check if the visitor is a valid user. */
function login($username, $password)
{
$db = db_connect();
if (!$db)
{
echo "Can't connect to the MySQL database...";
exit;
}
$query = "SELECT username, accessid FROM users WHERE username='$username' AND password=password('$password')";
$result = mysql_query($query,$db);
$myrow = mysql_fetch_array($result);
if($myrow[username]==1)
repair_tables(); // function of repair_tables().
if (!$result) return 0;
elseif (mysql_num_rows($result)>0) return $myrow[accessid];
else return 0;
} //end of function login($username, $password).
function repair_tables()
{
$db = db_connect();
if (!$db)
{
echo "Can't connect to the MySQL database...";
exit;
}
mysql_query("REPAIR TABLE city",$db);
mysql_query("REPAIR TABLE area",$db);
mysql_query("REPAIR TABLE users",$db);
mysql_query("REPAIR TABLE dealer",$db);
mysql_query("REPAIR TABLE dealer_area",$db);
mysql_query("REPAIR TABLE user_access",$db);
return 1;
} //end of function repair_tables().
function dateformat($mysqldate,$longmonth=0,$shortyear=0){
list($year,$month,$day) = explode("-", $mysqldate);
settype($year, "integer");
settype($month, "integer");
settype($day, "integer");
if($month){
if($longmonth) $return_date = date("F",mktime(0,0,0,$month,1,1));
else $return_date = date("M",mktime(0,0,0,$month,1,1));
}
if($day) $return_date .= " $day,";
if($year){
if($shortyear) $return_date .= " ".substr($year,-2);
else $return_date .= " $year";
}
if($return_date)
return $return_date;
else return;
}
function get_numpercol($num_array,$cols){
$num = ceil($num_array/$cols);
return $num;
}
function addbreaks($string){
return str_replace("\r","<br>",$string);
}
function do_form_row($position=" ",$number=" ",$description=" ")
{
if($concat==""||$concat2==""||$concat3=="")
return;
else {
$row ="<tr>
<td valign=top>".$position."</td>
<td align=center valign=top>".$number."</td>
<td>".$description."</td>
</tr>";
return $row;
}
}
function getRealIpAddr()
{
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
return $ip;
}
//mail function
function sendViaMailer($data)
{
/*================================
HOST FOLDER
WORKABROAD = wamailserver
JOBOPENINGS = jomailserver
SEMANJOBSITE = sjmailserver
==================================*/
$hostfolder = "jomailserver";
$url = 'http://50.23.73.14/~qxsender/'.$hostfolder.'/sendmail.php';
/*================================
GET USER IP ADDRESS FOR LOG
==================================*/
if (!empty($_SERVER['HTTP_CLIENT_IP'])) //check ip from share internet
{
$ip=$_SERVER['HTTP_CLIENT_IP'];
}
elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) //to check ip is pass from proxy
{
$ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
}
else
{
$ip=$_SERVER['REMOTE_ADDR'];
}
define("HASH_STR_CODE", base64_encode("0LVMB19Q4P~"),true);
if(is_array($data['to']))
{
$data['to'] = '';
foreach($data['to'] as $key => $val)
{
$data['to'].= $val.", ";
}
}else{
$data['to'] = str_replace(" ","",$data['to']);
$data['to'] = str_replace(",",", ",$data['to']);
}
$fields = array(
'subject' => urlencode($data['subject']),
'msg' => urlencode($data['msg']),
'from' => urlencode($data['from']),
'from_name' => urlencode($data['from_name']),
'to' => urlencode($data['to']),
'cc' => urlencode($data['cc']),
'bcc' => urlencode($data['bcc']),
'ip' => urlencode($ip),
'replyto' => urlencode($data['replyto'])
);
$base64_data = "";
if( $fields )
{
foreach($fields as $key => $val)
{
if($key != 'msg')
{
$base64_data.= base64_encode($val);
}
}
}
$hash = sha1($base64_data.HASH_STR_CODE);
$fields['token'] = $hash;
//url-ify the data for the POST
foreach($fields as $key=>$value) { $fields_string .= $key.'='.$value.'&'; }
rtrim($fields_string, '&');
//open connection
$ch = curl_init();
//set the url, number of POST vars, POST data
curl_setopt($ch,CURLOPT_URL, $url);
curl_setopt($ch,CURLOPT_POST, count($fields));
curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string);
curl_setopt($ch,CURLOPT_RETURNTRANSFER, true);
//execute post
$result = curl_exec($ch);
//close connection
curl_close($ch);
return 1;
}
function randomstr($length = 7) {
return substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, $length);
}
?>