Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/sync-eis-college/api/   drwxr-xr-x
Free 52.33 GB of 127.8 GB (40.95%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     usage.php (2.61 KB)      -rw-r--r--

get('rg_Student');
	// 	$arr = array('isError' => false , 'data' => $posts);
	// 	echo json_encode($arr);
	// 	//print_r($posts);
	// 	//echo $mysql->num_rows(); // number of rows returned
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// // get all post titles and authors
	// try{
	// 	//$posts = $mysql->get('posts', array('title', 'author'));
	// 	// or
	// 	$posts = $mysql->get('posts', 'title,author');
	// 	print_r($posts);
	// 	echo $mysql->last_query(); // the raw query that was ran
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// get one post
	try{
		$host = "localhost";
		$username = "eis_sync";
		$password = "P@ssw0rd@2017";
		
		$mysql = new MySQL($host, $username, $password, $db );

		$post = $mysql->query($sql,true);
		$arr = array('isError' => false , 'data' => $post);
		echo json_encode($arr);
		//print_r($post);
	}catch(Exception $e){
		echo 'Caught exception: ', $e->getMessage();
	}
	
	// // get post with an id of 1
	// try{
	// 	$post = $mysql->where('id', 1)->get('posts');
	// 	// or
	// 	$post = $mysql->where(array('id', 1))->get('posts');
	// 	print_r($post);
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// // get all posts by the author of "John Doe"
	// try{
	// 	$posts = $mysql->where(array('author' => 'John Doe'))->get('posts');
	// 	print_r($posts);
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// // insert post
	// try{
	// 	$mysql->insert('posts', array('title' => 'New Title', 'content' => 'post content', 'author' => 'Matthew Loberg'));
	// 	echo $mysql->insert_id(); // id of newly inserted post
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// // update post 1
	// try{
	// 	$mysql->where('id', 1)->update('posts', array('title' => 'New Title'));
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
	
	// // delete post 1
	// try{
	// 	$mysql->where('id', 1)->delete('posts');
	// }catch(Exception $e){
	// 	echo 'Caught exception: ', $e->getMessage();
	// }
?>
bool(false)