/** * sql语句查询封装 * @param $sql : sql语句 * @param $array :sql语句的参数 */ function sqlQuery($sql, $array) { $dbInfo = DBInfo::getInstance(); $dsn = "{$dbInfo->dbms}:host={$dbInfo->host};dbname={$dbInfo->dbName}"; try { $dbh = new PDO($dsn, $dbInfo->user, $dbInfo->pass); //初始化一个PDO对象 echo "连接成功<br/>"; $sth = $dbh->prepare($sql); $sth->execute($array); $result = $sth->fetchAll(); return $result; } catch (PDOException $e) { die("Error!: " . $e->getMessage() . "<br/>"); } }