<?php

class link_mysql{

	private $host,$uid,$pwd,$db,$link,$res;

	function link_mysql($_host,$_uid,$_pwd,$_db){

		$this->host = $_host;

		$this->uid = $_uid;

		$this->pwd = $_pwd;

		$this->db = $_db;

		$this->link = mysql_connect($this->host,$this->uid,$this->pwd);

		mysql_select_db($this->db,$this->link);

	}

	function exec_sql($sql){

		//if you use insert sentence,then you must open your link;

		$res = mysql_query($sql);

		return $res;

	}

}

$obj_link = new link_mysql('localhost','***','***','website');

$res = $obj_link->exec_sql("select * from userinfo");

$str = "[";

while($rows = mysql_fetch_assoc($res)){

	$str = $str."{name:$rows[name],password:$rows[password],age:$rows[age]},";

}

$str = rtrim($str,',') ."]";

echo $str;

?>