封装一个PDO操作mysql的类

class PdoMiao{
	protected $config=array(
		'host'=>'localhost',
		'database'=>'',
		'hostport'=>'3306',
		'charset'=>'utf-8'
	);
	protected $dsn=null;
	protected $user='root';
	protected $passwd='root';
	
	public function __construct($config){
		$dsn=$this->parseDsn($this->config);
		try{
			$this->dsn=new \PDO($dsn,$this->user,$this->passwd);
		}catch(\PDOException $e){
			echo "连接失败:"$e->getMessage();
		}
	
		$this->host=$config['host'];
		$this->user=$config['user'];
		$this->passwd=$config['passwd'];
		$this->charset=$config['charset'];
		$this->database=$config['database'];
	}
	public function parseDsn($config){
		$dsn="mysql:host=".$config['host'].";dbname=".$config['database'];
		if(!empty($config['port'])){
			$dsn.=";port=".$config['port'];
		}
		if(!empty($config['charset'])){
			$dsn.=";charset=".$config['charset'];
		}
		return $dsn;
	}
	public function insert($datas){
		$sql="insert into `miaosha`( `id` ,`phone` ,`number`) values(null,?,?,?)" ;
		$sth=$this->dsn->prepare($sql);
		foreach($datas as $k=>$v){
			$sth->execute($v);
		}
	}
}

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值