Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

<?php header('Content-Type: text/html; charset=UTF-8'); date_default_timezone_set("Asia/..

Decoded Output download

<?php 
header('Content-Type: text/html; charset=UTF-8'); 
date_default_timezone_set("Asia/Bangkok"); 
//Create Database 
 
// Get Database Connection 
function DB_Connection() {	 
	 
	$dbhost = "localhost";   
    $dbport = "3306"; 
    $dbuser = "memorys1_diony"; 
    $dbpass = "224422"; 
    $dbname = "memorys1_diony";   
	$dbh = new PDO("mysql:host=$dbhost;port=$dbport;dbname=$dbname", $dbuser, $dbpass);	 
	$dbh -> exec("set names 'utf8' COLLATE 'utf8_general_ci' ");	 
	$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
	return $dbh; 
	 
 
 
 
 
 
 
 
	 
} 
 
function findPrepare($sql){	 
	//set_time_limit(0); 
	try { 
		$db = DB_Connection(); 
        $stmt = $db->prepare($sql);         
        $stmt->execute(); 
    	$str = $stmt->fetchObject(); 
    	$db = null; 
    	return json_encode($str);         
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
function findAll($table){ 
	//set_time_limit(0); 
	$sql = "select * FROM ".$table; 
	try { 
		$db = DB_Connection(); 
		$stmt = $db->query($sql);   
		$list = $stmt->fetchAll(PDO::FETCH_OBJ); 
		$db = null; 
		return json_encode($list); 
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
function finds($sql){	 
	//set_time_limit(0); 
	try { 
		$db = DB_Connection(); 
		$stmt = $db->query($sql);   
		$list = $stmt->fetchAll(PDO::FETCH_OBJ); 
		$db = null; 
		return json_encode($list); 
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
function findByALL($table,$con,$param,$order){ 
	//set_time_limit(0); 
	$sql = "SELECT ".$con." FROM ".$table; 
	if(!empty($param)){ 
		$sql .= "  WHERE ".$param;	 
	} 
 
	if(!empty($order)){ 
		$sql .= "  order by ".$order;	 
	} 
	try { 
		$db = DB_Connection(); 
		$stmt = $db->query($sql);   
		$list = $stmt->fetchAll(PDO::FETCH_OBJ); 
		$db = null; 
		return json_encode($list); 
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
function findByName($table,$param,$order){ 
	//set_time_limit(0); 
	$sql = "SELECT * FROM ".$table; 
	if(!empty($param)){ 
		$sql .= "  WHERE ".$param;	 
	} 
 
	if(!empty($order)){ 
		$sql .= "  order by ".$order;	 
	} 
	try { 
		$db = DB_Connection(); 
		$stmt = $db->query($sql);   
		$list = $stmt->fetchAll(PDO::FETCH_OBJ); 
		$db = null; 
		return json_encode($list); 
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
function lastID(){ 
    $db = DB_Connection(); 
    $id = $db->lastInsertId();   
    $db = null; 
    return $id; 
} 
 
function insertTableLastId($table,$data){ 
	//set_time_limit(0); 
	$fields=""; $values=""; 
	$i=1; 
	foreach($data as $key=>$val) 
	{ 
		if($i!=1) { $fields.=", "; $values.=", "; } 
		$fields.="$key"; 
		$values.="'$val'"; 
		$i++; 
	} 
	$sql = "INSERT INTO $table ($fields) VALUES ($values)"; 
    try { 
        $db = DB_Connection(); 
        $stmt = $db->prepare($sql);         
        $stmt->execute();     
        $id = $db->lastInsertId();   
        $db = null;            
        return '200*'.$id; 
    } catch(PDOException $e) { 
        return '{"error":{"text":'. $e->getMessage() .'}}'; 
    } 
} 
 
function insertTable($table,$data){ 
	//set_time_limit(0); 
	$fields=""; $values=""; 
	$i=1; 
	foreach($data as $key=>$val) 
	{ 
		if($i!=1) { $fields.=", "; $values.=", "; } 
		$fields.="$key"; 
		$values.="'$val'"; 
		$i++; 
	} 
	$sql = "INSERT INTO $table ($fields) VALUES ($values)"; 
    try { 
        $db = DB_Connection(); 
        $stmt = $db->prepare($sql);         
        $stmt->execute(); 
        $db = null; 
        return '200'; 
    } catch(PDOException $e) { 
        return '{"error":{"text":'. $e->getMessage() .'}}'; 
    } 
} 
 
function updateTable($table,$data,$where) 
{			 
	//set_time_limit(0); 
	$modifs=""; 
	$i=1; 
	foreach($data as $key=>$val) 
	{ 
		if($i!=1){ $modifs.=", "; } 
		if(is_numeric($val)) { $modifs.=$key.'='.$val; } 
		else { $modifs.=$key.' = "'.$val.'"'; } 
		$i++; 
	} 
	$sql = ("UPDATE $table SET $modifs WHERE $where"); 
    try { 
        $db = DB_Connection(); 
        $stmt = $db->prepare($sql);         
        $stmt->execute(); 
        $db = null; 
        return '200'; 
    } catch(PDOException $e) { 
    	return '{"error":{"text":'. $e->getMessage() .'}}';       
    } 
} 
 
function deleteTable($table,$where){ 
	//set_time_limit(0); 
    $sql = "DELETE FROM $table WHERE $where"; 
    try { 
        $db = DB_Connection(); 
        $stmt = $db->prepare($sql);         
        $stmt->execute(); 
        $db = null; 
        return '200'; 
    } catch(PDOException $e) { 
    	return '{"error":{"text":'. $e->getMessage() .'}}';       
    } 
} 
 
function createtable($sql){ 
	//set_time_limit(0); 
	try { 
		$db = DB_Connection(); 
		$db->exec($sql);		 
		$db = null; 
		return 'OK'; 
	} catch(PDOException $e) {		 
		return '{"error":{"text":'. $e->getMessage() .'}}';  
	} 
} 
 
 ?>

Did this file decode correctly?

Original Code

<?php
header('Content-Type: text/html; charset=UTF-8');
date_default_timezone_set("Asia/Bangkok");
//Create Database

// Get Database Connection
function DB_Connection() {	
	
	$dbhost = "localhost";  
    $dbport = "3306";
    $dbuser = "memorys1_diony";
    $dbpass = "224422";
    $dbname = "memorys1_diony";  
	$dbh = new PDO("mysql:host=$dbhost;port=$dbport;dbname=$dbname", $dbuser, $dbpass);	
	$dbh -> exec("set names 'utf8' COLLATE 'utf8_general_ci' ");	
	$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	return $dbh;
	







	
}

function findPrepare($sql){	
	//set_time_limit(0);
	try {
		$db = DB_Connection();
        $stmt = $db->prepare($sql);        
        $stmt->execute();
    	$str = $stmt->fetchObject();
    	$db = null;
    	return json_encode($str);        
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

function findAll($table){
	//set_time_limit(0);
	$sql = "select * FROM ".$table;
	try {
		$db = DB_Connection();
		$stmt = $db->query($sql);  
		$list = $stmt->fetchAll(PDO::FETCH_OBJ);
		$db = null;
		return json_encode($list);
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

function finds($sql){	
	//set_time_limit(0);
	try {
		$db = DB_Connection();
		$stmt = $db->query($sql);  
		$list = $stmt->fetchAll(PDO::FETCH_OBJ);
		$db = null;
		return json_encode($list);
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

function findByALL($table,$con,$param,$order){
	//set_time_limit(0);
	$sql = "SELECT ".$con." FROM ".$table;
	if(!empty($param)){
		$sql .= "  WHERE ".$param;	
	}

	if(!empty($order)){
		$sql .= "  order by ".$order;	
	}
	try {
		$db = DB_Connection();
		$stmt = $db->query($sql);  
		$list = $stmt->fetchAll(PDO::FETCH_OBJ);
		$db = null;
		return json_encode($list);
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

function findByName($table,$param,$order){
	//set_time_limit(0);
	$sql = "SELECT * FROM ".$table;
	if(!empty($param)){
		$sql .= "  WHERE ".$param;	
	}

	if(!empty($order)){
		$sql .= "  order by ".$order;	
	}
	try {
		$db = DB_Connection();
		$stmt = $db->query($sql);  
		$list = $stmt->fetchAll(PDO::FETCH_OBJ);
		$db = null;
		return json_encode($list);
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

function lastID(){
    $db = DB_Connection();
    $id = $db->lastInsertId();  
    $db = null;
    return $id;
}

function insertTableLastId($table,$data){
	//set_time_limit(0);
	$fields=""; $values="";
	$i=1;
	foreach($data as $key=>$val)
	{
		if($i!=1) { $fields.=", "; $values.=", "; }
		$fields.="$key";
		$values.="'$val'";
		$i++;
	}
	$sql = "INSERT INTO $table ($fields) VALUES ($values)";
    try {
        $db = DB_Connection();
        $stmt = $db->prepare($sql);        
        $stmt->execute();    
        $id = $db->lastInsertId();  
        $db = null;           
        return '200*'.$id;
    } catch(PDOException $e) {
        return '{"error":{"text":'. $e->getMessage() .'}}';
    }
}

function insertTable($table,$data){
	//set_time_limit(0);
	$fields=""; $values="";
	$i=1;
	foreach($data as $key=>$val)
	{
		if($i!=1) { $fields.=", "; $values.=", "; }
		$fields.="$key";
		$values.="'$val'";
		$i++;
	}
	$sql = "INSERT INTO $table ($fields) VALUES ($values)";
    try {
        $db = DB_Connection();
        $stmt = $db->prepare($sql);        
        $stmt->execute();
        $db = null;
        return '200';
    } catch(PDOException $e) {
        return '{"error":{"text":'. $e->getMessage() .'}}';
    }
}

function updateTable($table,$data,$where)
{			
	//set_time_limit(0);
	$modifs="";
	$i=1;
	foreach($data as $key=>$val)
	{
		if($i!=1){ $modifs.=", "; }
		if(is_numeric($val)) { $modifs.=$key.'='.$val; }
		else { $modifs.=$key.' = "'.$val.'"'; }
		$i++;
	}
	$sql = ("UPDATE $table SET $modifs WHERE $where");
    try {
        $db = DB_Connection();
        $stmt = $db->prepare($sql);        
        $stmt->execute();
        $db = null;
        return '200';
    } catch(PDOException $e) {
    	return '{"error":{"text":'. $e->getMessage() .'}}';      
    }
}

function deleteTable($table,$where){
	//set_time_limit(0);
    $sql = "DELETE FROM $table WHERE $where";
    try {
        $db = DB_Connection();
        $stmt = $db->prepare($sql);        
        $stmt->execute();
        $db = null;
        return '200';
    } catch(PDOException $e) {
    	return '{"error":{"text":'. $e->getMessage() .'}}';      
    }
}

function createtable($sql){
	//set_time_limit(0);
	try {
		$db = DB_Connection();
		$db->exec($sql);		
		$db = null;
		return 'OK';
	} catch(PDOException $e) {		
		return '{"error":{"text":'. $e->getMessage() .'}}'; 
	}
}

Function Calls

header 1

Variables

None

Stats

MD5 8048124af391ba52cdea2d19520282ce
Eval Count 0
Decode Time 101 ms