原生pdo链接数据库的方法

//开始链接这是链接sqlserver的，mysql只需将下面sqlsrv改成mysql就行。

try{
  	$db = new PDO("sqlsrv:Server=localhost,1433;Database=mydb","root","password");
}catch (PDOException $e){
    //$content = iconv("UTF-8","gbk",$e->getMessage()); 
    echo "数据库连接失败：".$e->getMessage();
}

//mysql为例

 try{
 		$pdo=new PDO("mysql:host=localhost:3306;dbname=mydb","root","password");
 }catch (PDOException $e){
		echo "数据库连接失败：".$e->getMessage();
 }

//增
$sql= “INSERT INTO SJCJQK ( BTMC, BTBH,BTBH1,BTDH,BTDZ,BTMA ) VALUES (‘谢’, ‘0000’,‘5646’,‘131’,‘西安1’,‘0’)”;
$rt = $pdo->exec($sql);

//删
$sql= "DELETE FROM SJCJQK WHERE recno =3499 ";
$rt = $pdo->exec($sql);

//查全部
$sql="select recno from sjcjqk ";

var_dump(fetch_All($sql,$pdo));

//查单条
$sql="select recno from sjcjqk where recno=3498 ";

var_dump(fetch_Find($sql,$pdo));

//改
$sql= "UPDATE SJCJQK SET BTMC = 65785 WHERE recno =3499 ";
$rt = $pdo->exec($sql);

//增删改查，因为原生的会查出两条，我封装了一下如下：

function fetch_All($sql,$pdo){
    $rt = $pdo->query($sql);
    if($rt){
        $res = $rt->fetchAll();
        if($res){
            foreach ($res as $k=>$val){
                foreach ($val as $key=>$v){
                    if(is_numeric($key))
                    {
                        unset($res[$k][$key]);
                    }
                }
            }
        }
    }else{
        return array();
    }
   		 return $res;
}


function fetch_Find($sql,$pdo){
    $rt = $pdo->query($sql);
    if($rt){
        $res = $rt->fetch();
        if($res){
            foreach ($res as $key=>$v){
                if(is_numeric($key))
                {
                    unset($res[$key]);
                }
            }
        }
    }else{

        return array();
    }

    return $res;
}

//删除字符串中的所有空格

function trimall($str){
    $string = preg_replace("/(\s|\&nbsp\;|　|\xc2\xa0)/","",$str);
    return $string;
}