thinkphp Example Tutorial Data paging

CREATE TABLE ' Test ' ( ' id ' int (ten) unsigned NOT NULL auto_increment, ' Name ' char (+) is not NULL, ' content ' varchar (not NULL), Primary KEY (' ID ') ) Engine=myisam default Charset=utf8 auto_increment=27; INSERT INTO ' test ' (' id ', ' name ', ' content ') values (19, ' 123 ', ' 123 '), (20, ' 1231 ', ' 123123123 '), (21, ' 123123 ', ' 123123123 '), (26, ' 24 ', ' 123123 '), (25, ' 321123 ', ' 321123 '), ("Age", "age"), (23, ' 123123 ', ' 123123 '), (22, ' 213 ', ' 123 '); Copy Code 2, create a new thinkphp project. The new TP has built-in project auto-generated directory functionality. Create a new test folder under Htdocs (that is, your Web site root), put the thinkphp Core folder in the test root directory, and create a new file index.php in the test root directory, adding the following code: Defining thinkphp Frame paths Define (' Think_path ', './thinkphp '); Define the project name and path. These 2 sentences are the focus. Define (' app_name ', ' test '); Define (' App_path ', './test '); Loading Frame Entry File Require (Think_path. " /thinkphp.php "); Instantiate an instance of a Web site application $app = new app (); Application initialization $app->run (); Copy Code Run "http://localhost/test/index.php". You will see the Welcome page of thinkphp. Then open your test directory to see, found in the root of a test folder, at this time, your project directory has been generated. Open the/test/test/conf/directory, create a new "config.php", and configure the database connection. Return Array ( ' Db_type ' = ' mysql ', ' db_host ' = ' localhost ', ' db_name ' = ' test ',//New database name test ' Db_user ' = ' root ',//database user name ' Db_pwd ' = ', '//Database password ' Db_port ' = ' 3306 ', ); ?> Copy Code If you want to turn on debug mode, add: "Debug_mode" to the array =>true 3, the implementation of basic page input and output. 1) Open/test/test/lib/action/indexaction.class.php, find: This class is automatically generated by the system and is intended for testing purposes only Class Indexaction extends action{ Public Function index () { Header ("content-type:text/html; Charset=utf-8 "); echo "^_^ Hello, Welcome to use thinkphp"; } } ?> Copy Code The index () function in the Indexaction class that is automatically generated by the system is the default first page call function. You can use http://localhost/test/index.php or Http://localhost/test/index.php/index to visit him. 2) temporarily regardless of him. First, a form submission page is required. Open "/test/test/tpl/default/index/" and create a new file add.html. Copy Code Once saved, enter Http://localhost/test/index.php/index/add and you will be able to see your new page. where __url__ (the URL to capitalize) is converted to the corresponding address/test/index.php/index/. Here's a brief look at the relationship between the template and the action. Each action, the corresponding template is the same name as the HTML file. For example, index () under the Index class, corresponding to default/index/index.html, and add.html, is obviously corresponding to the index class of Add (). You can access the add.html template in the form of Access Add (Http://localhost/test/index.php/index/add) in the case of only add.html without the corresponding add () action. Placeholders under the add.html template are replaced with the corresponding data. (Script Academy editing and finishing bbs.it-home.org) 3) from the "Action=__url__/insert" in the form, we can see that the action of the form processing is/test/index.php/index/insert, so we have to add insert action to process the form submission data. Until then, we have one more important thing to do, which is to add the model file. Through the creation of the model file, we will be able to use the Insert action in a convenient way to manipulate the database open the/test/test/lib/model/folder, new file testmodel.class.php. Open him, enter and save the following code Class Testmodel extends Model { } ?> Copy Code This is the basic file that ActiveRecord implements. A naming convention is a table in your database that is appended to the model. For example, the table that will be used is test, the file name must be testmodel.class.php, and the class name under the file must be Testmodel. Then, go back to the indexaction.class.php file, delete the original code, and add: Class Indexaction extends action{ Adding form data to a database Public Function Insert () { Instantiate the Testmodel we just built. $test = d (' Test '); if ($test->create ()) { Save the form data in this step. The thinkphp have all been done. $test->add (); $this->redirect (); }else{ Exit ($test->geterror (). ' [Return] '); } } } Copy Code 4) Next, you need to add a home page default display action index () in the Indexaction class to invoke the form data. Public Function index () { It is still the model that we created for the corresponding table name. This is the key to our quick table operation. $test = d (' Test '); Are you familiar with this piece of code? Count All Rows $count = $test->count (' ', ' id '); Number of lines displayed per page $listrows = ' 3 '; Which fields to query $fields = ' id,name,content '; Import a paging class/thinkphp/lib/org/util/page.class.php Import ("Org.util.page"); The parameters of the page are changed by the constructor of the class. $count is the total, $listrows the display entry for each page. $p = new Page ($count, $listrows); Set the query parameters. See "thinkphp/lib/think/core/model.class.php" for more than 1731 lines. $list = $test->findall (', $fields, ' id desc ', $p->firstrow. ', '. $p->listrows); The paging class is done. $page = $p->show (); Template output $this->assign (' list ', $list); $this->assign (' page ', $page); $this->display (); } Copy Code Set up a template to create a new index.html under/test/test/tpl/default/index/(because the default corresponds to index (). The program can be directly assign. Instead of specifying a template file. Of course, this can be configured. ) Fill Pagination shows that this line {$page} Data display. The following parameters will be explained shortly. It is well understood. Name: {$vo. Name} Contents: {$vo. Content} Copy Code Save, enter http://localhost/test/ The above is thinkphp to make pagination method and examples, I hope to help you.

