1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug / restapi / Core /
Filename : Database.php
back
<?php
require 'phpmailer/PHPMailerAutoload.php';
require 'phpmailer/emailtemplate.php';
class Database {	
	public $con;
	
	public function __construct(){
		$host = "localhost";
		$database = "mcspunei_multimatri";
		$user ="mcspunei_shubham";
		$password ="h63fg@mywqhD";
		$this->con=mysqli_connect($host,$user,$password,$database) or die("Could not connect to database");
	}
	
	public function que($query){
		if(!mysqli_query($this->con,$query)){
			$err2 = mysqli_error($this->con);
			echo "$err2";
			exit;			 
		}
		return true;
	}
	public function Extract_Single($query){
        $x = 0;
        mysqli_real_escape_string($this->con,$query); 
		$result = mysqli_query($this->con,$query);
		while($row=mysqli_fetch_array($result,MYSQLI_BOTH)){
            $q[$x] = $row[0];
            $implode[] = $q[$x] ;
            $x++;
        }
        mysqli_free_result($result);
        return @implode(',', $implode);
    }
	
	public function num_rows($query){
		$result = mysqli_query($this->con,$query);
        $row=mysqli_num_rows($result);
        return $row;
	}
	
	public function retid($query){
		if(!mysqli_query($this->con,$query)){
			$err2 = mysqli_error($this->con);
			echo "$err2";
			exit;			
		}
	//	$result = mysqli_query($this->con,$query);
		$result=mysqli_insert_id($this->con);
		return $result;
	}

	public function fetch($query){
		$result = mysqli_query($this->con,$query);
		$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
		return $row;
	}
	
	public function fetch_all($query){
		$result = mysqli_query($this->con,$query);
		$i=0; $row1=array();
		while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){
		$row1[$i]= $row;
		$i++;
		}
		return $row1;
	}
	
	function escap($strval){
		$ret=trim(mysqli_real_escape_string($this->con,$strval)); 
		return $ret;
	}
	
	public function getCountryid($countryname){
		
		$query="select country_id from country where country_name='$countryname'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['country_id'];
	}
	
	public function getStateid($statename){
		$query="select state_id from state where state_name='$statename'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['state_id'];
	}
	public function getCityid($cityname){
		$query="select city_id from city where city_name='$cityname'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['city_id'];
	}
	
	public function getCountryname($countryid){
		$query="select country_name from country where country_id='$countryid'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['country_name'];
	}
	
	public function getStatename($stateid){
		$query="select state_name from state where state_id='$stateid'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['state_name'];
	}
	public function getCityname($cityid){
		$query="select city_name from city where city_id='$cityid'";
		$result=mysqli_query($this->con,$query);
		$row=mysqli_fetch_array($result,MYSQLI_BOTH);
		return $row['city_name'];
	}
        public function email($from,$to,$subject,$msg){
		$from="office@shubhamangal.co.in";
		$mail = new PHPMailer;	
		$mail->IsSMTP();                           
		$mail->SMTPDebug = false;
		$mail->SMTPAuth = true; 
		$mail->SMTPSecure = 'ssl';
		$mail->Host = 'mail.shubhamangal.co.in';  
		$mail->Port = 465;  
		$mail->IsHTML(true);     
		$mail->Username = $from;         
		$mail->Password = 'EG[$ATo]q{5a';                         
		$mail->setFrom($from, 'Doctor Search');      
		$mail->Subject = $subject;
		$mail->Body    = $msg;
		$mail->addAddress($to, 'User');   
		
		if(!$mail->send()) {
			$ret = 'Mailer Error: ' . $mail->ErrorInfo;
		} else {
			$ret = "scs";
		}
		return $ret;
	}
}

while(list($key,$value)=@each($_POST)){
	$$key=trim(addslashes($value));
}
while(list($key,$value)=@each($_GET)){
    $$key=trim(addslashes($value));
}	


?>