php 链接mysql数据库

class Ms{
	private $host;
	private $user;
	private $pwd;
	private $db_name;
	public function __construct($host,$user,$pwd,$dbName)
	{
		$this->host = $host;
		$this->user = $user;
		$this->pwd = $pwd;
		$this->db_name = $dbName;
	}
	
	public function mysql($sql)
	{
		$con = mysqli_connect($this->host,$this->user,$this->pwd,$this->db_name);
		if(!$con){
			die('Could not connect : '.mysqli_error());
		}

		$result = mysqli_query($con,$sql);
		if (!$result) {
        	printf("Error: %s\n", mysqli_error($con));
        }
        $list = [];
		while ($row = mysqli_fetch_array($result)) {
			array_push($list,$row);
		}
		return $list;
		mysqli_close($con);

	}
}

class menu
{
	
	public function getList()
	{
		$con = new Ms('localhost','root','root','adv5');
		$sql = "select * from cmf_admin_menu";
		$result = $con->mysql($sql);
		echo "<pre>";
		print_r($result);die;
	}

}
$menu = new menu();
echo $menu->getList();

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值