A PHP PDO MySQL operation class

/** * PDO operation * Created by Phpstorm. * User:sumiaowen * date:13-11-28 * Time: 9:12 * To change this template use File | Settings | File Templates. */ Class pdo_db { Private $dns = null; private $username = null; Private $password = null; private $conn = null; private static $_instance = null; Private Function __construct ($params = Array ()) { $this->dns = $params [' DNS ']; $this->username = $params [' username ']; $this->password = $params [' Password ']; $this->_connect (); } Private Function __clone () {} Public Function get_instance ($params = Array ()) { if (! ( Self::$_instance instanceof Self)) { Self::$_instance = new self ($params); } return self::$_instance; } Private Function _connect () { Try { $this->conn = new PDO ($this->dns, $this->username, $this->password); $this->conn->query (' Set names UTF8 '); } catch (Pdoexception $e) { Exit (' Pdoexception: '. $e->getmessage ()); } } /** * Query an SQL statement * @param string $sql * @param array $parameters parameters that need to be bound * @param int $option * @return Array */ Public Function query ($sql, $parameters = Array (), $option = PDO::FETCH_ASSOC) { $stmt = $this->conn->prepare ($sql); $stmt->execute ($parameters); $tmp = Array (); while ($row = $stmt->fetch ($option)) { $tmp [] = $row; } return $tmp; } /** * Insert a piece of data * @param string $sql * @param array $parameters * @return int 1 or 0 returns the number of rows affected */ Public Function Insert ($sql, $parameters = Array ()) { $stmt = $this->conn->prepare ($sql); $stmt->execute ($parameters); return $stmt->rowcount (); } /** * Update One piece of data * @param string $sql * @param array $parameters * @return int 1 or 0 returns the number of rows affected */bbs.it-home.org Public Function Update ($sql, $parameters = Array ()) { $stmt = $this->conn->prepare ($sql); $stmt->execute ($parameters); return $stmt->rowcount (); } /** * Delete One piece of data * @param string $sql * @param array $parameters * @return int 1 or 0 returns the number of rows affected */ Public Function Delete ($sql, $parameters = Array ()) { $stmt = $this->conn->prepare ($sql); $stmt->execute ($parameters); return $stmt->rowcount (); } } Copy Code Code link Address: Https://github.com/sumiaowen/mynotes/tree/master/pdo_mysql_class

