<? 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/>?>