PDO help class PDO class PHP database processing layer PDO dbhelper

Source: Internet
Author: User

<? Php <br/> define ("db_server", "127.0.0.1"); <br/> define ("db_port", 3306); <br/> define ("db_catalog ", "test"); <br/> define ("db_userid", "root"); <br/> define ("db_password ",""); <br/> class Dal {<br/> Private Static $ __queries = 0; <br/> Private Static $ __pdo = NULL; <br/> Private Static function connect () {<br/> If (isset (Self ::__ PDO) return; <br/> try {<br/> $ DSN = "MYSQL: host = ". db_server. "; Port = ". db_port. "; d Bname = ". db_catalog; <br/> Self: $ __pdo = new PDO ($ DSN, db_userid, db_password); <br/>} catch (pdoexception $ E) {<br/> raiseerror ($ E ); <br/>}< br/>/** <br/> * @ Param <type> $ SQL <br/> *@ param <type> $ Params <br/> * @ return <type> $ stmt <br/> * $ stmt = $ DBH-> prepare ("insert into registry (name, value) values (?, ?) "); <Br/> * $ stmt-> bindparam (1, $ name); <br/> * $ stmt-> bindparam (2, $ value ); <br/> * // insert one row <br/> * $ name = 'one'; <br/> * $ value = 1; <br/> * $ stmt-> execute (); <br/> * $ SQL = "select * From samplemarry where userid =? "; <Br/> * $ arr [0] = $ userid; <br/> * return Dal: getall ($ SQL, $ ARR ); <br/> */<br/> Private Static function execute ($ SQL, $ Params) {<br/> Self: connect (); <br/> try {<br/> $ stmt = self ::__ PdO-> prepare ($ SQL); <br/> if ($ Params! = NULL) {<br/> If (is_array ($ Params) | is_object ($ Params) {<br/> $ I = 1; <br/> foreach ($ Params as $ PARAM) {<br/> $ stmt-> bindvalue ($ I ++, $ PARAM ); <br/>}< br/>}else {<br/> $ stmt-> bindvalue (1, $ Params ); <br/>}< br/> if ($ stmt-> execute () {<br/> Self ::__ __ queries ++; <br/> return $ stmt; <br/>} else {<br/> $ err = $ stmt-> errorinfo (); <br/> throw new pdoexception ($ err [2], $ err [1]); <br/>}< br/>} Catch (pdoexception $ e) {<br/> raiseerror ($ E ); <br/>}< br/> /************************* **************************************** * ****** <br/> Public Function start <br/> ********************** **************************************** * *********/<br/> // For insert start <br/> Public static function insert ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return self ::__ P Do-> lastinsertid (); <br/>}< br/>/** <br/> * @ Param <type> $ table <br/> * @ Param <type> $ entity <br/> * @ return <type> <br/> $ DATA = new stdclass; <br/> $ data-> samplebook_id = $ bookid; <br/> $ data-> userid = $ userid; <br/> $ data-> educationtype = "school "; <br/> $ data-> name = $ scoolname; <br/> $ data-> subject = ""; <br/> $ data-> attendeddate = strtotime ($ startdate); <br/> $ data-> finisheddate = strtotime ($ end Date); <br/> return Dal: createrecord ("sampleeducation", $ item); <br/> */<br/> Public static function createrecord ($ table, $ entity) {<br/> $ F = array (); <br/> $ v = array (); <br/> $ C = 0; <br/> foreach ($ entity as $ prop => $ Val) {<br/> $ f [] = $ prop; <br/> $ V [] = $ val; <br/> $ C ++; <br/>}< br/> $ SQL = "insert into $ table (". implode (",", $ F ). ") values (". trim (str_repeat ('?, ', $ C ),","). ")"; <br/> return self: insert ($ SQL, $ V ); <br/>}< br/> // For insert end <br/> // For Delete start <br/>/** <br/> * @ Param <type> $ SQL <br/> * @ Param <type> $ Params <br/> * @ return <type> <br/> $ SQL = "delete from samplelived where id =? "; <Br/> $ arr [] = $ ID; <br/> Dal: delete ($ SQL, $ ARR ); <br/> */<br/> Public static function Delete ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return $ stmt-> rowcount (); <br/>}< br/> Public static function remove ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return $ stmt-> rowcount (); <br/>}< br/> // For Delete end <br/> // For Update start <br/> Public St Atic function Update ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params ); <br/> return $ stmt-> rowcount (); <br/>}< br/> Public static function UpdateRecord ($ table, $ entity, $ pkdfiledname) {<br/> $ F = array (); <br/> $ v = array (); <br/> foreach ($ entity as $ prop => $ Val) {<br/> if ($ prop = $ pkdfiledname) continue; <br/> $ f [] = $ prop. "=? "; <Br/> $ V [] = $ val; <br/>}< br/> $ V [] = $ entity-> $ pkdfiledname; <br/> $ SQL = "Update $ table set ". trim (implode (',', $ F ),','). "where $ pkdfiledname =? "; <Br/> return self: Update ($ SQL, $ V ); <br/>}< br/> // for update end <br/> // for query start <br/> Public static function query ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return New dbrecordset ($ stmt ); <br/>}< br/> Public static function getone ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return $ stmt-> fetchcolumn (); <br/>}< br/> Public static func Tion getrow ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params ); <br/> return $ stmt-> fetch (PDO: fetch_obj); <br/>}< br/> Public static function getall ($ SQL, $ Params = NULL) {<br/> $ stmt = self: Execute ($ SQL, $ Params); <br/> return $ stmt-> fetchall (PDO: fetch_assoc ); <br/>}< br/> // for query end <br/> // for transaction start <br/> Public static function begintransaction () {<br/> return self :: $ __Pdo-> begintransaction (); <br/>}< br/> Public static function rollback () {<br/> return self :: $ __pdo-> rollback (); <br/>}< br/> Public static function commit () {<br/> return self :: $ __pdo-> commit (); <br/>}< br/> // for transaction end <br/> Public static function pagination ($ countsql, $ selectsql, $ Params, & $ pagenow, $ pagesize, & $ count) {<br/> if ($ pagenow <= 0) $ pagenow = 1; <br/> $ COUNT = self: getone ($ Co Untsql, $ Params); <br/> $ pagecount = Ceil ($ count/$ pagesize); <br/> if ($ pagenow> $ pagecount) $ pagenow = $ pagecount; <br/> if ($ pagenow <= 0) $ pagenow = 1; <br/> $ offset = ($ pageNow-1) * $ pagesize; <br/> $ SQL = $ selectsql. 'limit '. $ offset. ','. $ pagesize; <br/> return self: Query ($ SQL, $ Params ); <br/>}< br/> /****************************** **************************************** ** <br/> Public Function end <br/> ****** **************************************** *************************/<Br/>}< br/> class dbrecordset {< br/> private $ pdostatement; <br/> public function _ construct (& $ stmt) {<br/> $ this-> pdostatement = & $ stmt; <br/> $ this-> pdostatement-> setfetchmode (PDO: fetch_obj); <br/>}< br/> Public Function next () {<br/> return $ this-> pdostatement-> fetch (); <br/>}< br/> public function count () {<br/> // for my SQL pdostatement will return the number of rows in the resultset <br/> return $ this-> pdostatement-> rowcount (); <br/>}< br/> Public Function getallrows () {<br/> return $ this-> pdostatement-> fetchall (); <br/>}< br/> Public Function columncount () {<br/> return $ this-> pdostatement-> columncount (); <br/>}< br/> Public Function free () {<br/> $ this-> pdostatement = NULL; <br/>}< br/> public function __ Destruct () {<br/> $ this-> free (); <br/>}< br/>?> 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.