Use Zend_Db to replace propel and doctring data abstraction layer (I)-PHP source code

Source: Internet
Author: User
Use Zend_Db to replace propel and doctring data abstraction layer (1)
 '2017. 0.0.1 ', 'username' => 'root', 'password' => 'sa', 'dbname' => 'test'); $ dbh = Zend_Db :: factory ('pdo _ mysql', $ params); Zend_Db_Table: setdefaadapter adapter ($ dbh ); // set the default adapter for all Zend_Db_Table objects. // you only need one Db object and one adapter object. // no-mvc mode is used here if it is a standard zend application // even the adapter does not require ZEND_CONSOLE to complete the work class Albums extends Zend_Db_Table {}# you can do nothing to directly use the Zend_Db_Table # method crud... // Next let's assume that the connected database has a music list named albums $ albums = new Albums (); echo "test get the data from test. from MySQL-5.5.m6
"; // The result set returned by rs is a default Zend_Db_Table_Row object foreach ($ albums-> fetchAll () as $ row) {echo"

". Htmlspecialchars ($ row-> id)." ". htmlspecialchars ($ row-> artist)."'s ". htmlspecialchars ($ row-> title ).".

\ N "; $ row-> save ();}/** 1 student friend's, she came to my concert. 2 Huang Xiaoyu's is not that simple. 3. 4 Wang Feng's spring. 5 Paolo Nutine 'ssunny Side Up.6 Andre attack' sHeligoland. 7 Beatles 'simage. 8 Beatles 'shey Jude.9 Faye Wong-"you Faye Wong so I Faye Wong"'s red beans, because of love. 10 Johnny depp's arrival in London. * /// now we can modify the tenth data record to change London to the green fariy // It is easy to modify the row data: you only need to modify the class attributes according to the general method. call the save () method to save the changed result to the data table. // There are many ways to do this, such as declaring a new // Zend_Db_Statement, but I like the simple method $ row = $ albums-> fetchRow ('Id = "10 "'); $ row-> title = 'The Green Fairy, I like UK-London style'; $ row-> save ();/** test get The data from test. albums from MySQL-5.5.m61 Zhang Xueyou's coming to my concert. 2 Huang Xiaoyu's is not that simple. 3. 4 Wang Feng's spring. 5 Paolo Nutine 'ssunny Side Up.6 Andre attack' sHeligoland. 7 Beatles 'simage. 8 Beatles 'shey Jude.9 Faye Wong-"you Faye Wong so I Faye Wong"'s red beans, because of love. 10 Johnny Depp' sThe Green Fairy, I like UK-London style. * **/$ row = $ albums-> find ('3'); $ row [0]-> title = "Chrysanthemum's Summer"; // note: row itself is a Zend_Db_Table_RowSet set $ row [0]-> save (); # However, the set is an array mapped to a single element or a row object has save () method // more and more like simple things such as VIM such as PHP Python // There is only one thing to note. you cannot modify the ID. this will throw an exception at the DB level/*** test get the data from test. albums from MySQL-5.5.m61 Zhang Xueyou's coming to my concert. 2 Huang Xiaoyu's is not that simple. 3. the summer of Jiu Shi's chrysanthemum. 4 Wang Feng's spring. 5 Paolo Nutine 'ssunny Side Up.6 Andre attack' sHeligoland. 7 Beatles 'simage. 8 Beatles 'shey Jude.9 Faye Wong-"you Faye Wong so I Faye Wong"'s red beans, because of love. 10 Johnny Depp' sThe Green Fairy, I like UK-London style **/

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.