thinkphp example tutorial data paging-PHP Tutorial-php.cn

thinkphp example tutorial data paging

WBOY

Release： 2016-07-25 08:53:02

Original

1196 people have browsed it

create table `test` (
`id` int(10) unsigned not null auto_increment,
`name` char(100) not null,
`content` varchar(300) 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' ),
(24, 'age', 'age'),
(23, '123123', '123123'),
(22, '213', '123');

Copy code

2 , create a new thinkphp project. The new version of tp has built-in automatic project directory generation function. Create a new test folder under htdocs (that is, the root directory of your website), put the thinkphp core folder into the test root directory, create a new file index.php in the test root directory, and add the following code:

//Define the thinkphp framework path
define('think_path', './thinkphp');
//Define the project name and path. These 2 sentences are the key points.
define('app_name', 'test');
define('app_path', './test');
// Load the framework entry file
require(think_path."/thinkphp.php");
//Example Create a website application instance
$app = new app();
//Application initialization
$app->run();

Copy the code

Run "http://localhost/test/index .php". You will see the welcome page of thinkphp. Open your test directory again and find that there is an additional test folder in the root directory. 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 The database name test
'db_user'=>'root', //Database user name
'db_pwd'=>'', //Database password
'db_port'=>'3306',
);
? >

Copy code

If you want to turn on debugging mode, please add it to the array: "debug_mode"=>true

3. Implementation of basic page input and output. 1) Open /test/test/lib/action/indexaction.class.php and find:

// This class is automatically generated by the system and is for testing purposes only
class indexaction extends action{
public function index(){
header("content-type:text/html; charset =utf-8");
echo "
^_^ hello, welcomethinkphp< ;/div>";
}
}
?>

Copy code

The index() function in the indexaction class automatically generated by the system is the default homepage calling function. You can use http://localhost/test/index.php or http://localhost/test/index.php/index to access it

2) Ignore him for now. First, a form submission page is needed. Open "/test/test/tpl/default/index/" and create a new file add.html.

Name:
Content:
Submit:< ;/p>

Copy code

After saving, enter http://localhost/test/index.php/index/add, and you will be able to see your new page. Among them, __url__ (url should be capitalized) is converted to the corresponding address /test/index.php/index/. Here is a brief talk about the relationship between templates and actions. For each action, the corresponding template is an html file with the same name. For example, index() under the index class corresponds to default/index/index.html, and add.html obviously corresponds to add() under the index class.

You can access the add.html template by accessing add() (http://localhost/test/index.php/index/add) when there is only add.html but no corresponding add() action. Placeholders under the add.html template will be replaced with corresponding data. (Edited and compiled by Scripting School bbs.it-home.org)

3) From the "action=__url__/insert" of the form, we can see that the action for form processing is /test/index.php/index/insert, so we have to add a new insert action to process the form submission data. Before that, we still have one important thing to do, which is to add a new model file. Through the creation of the model file, we will be able to use convenient methods to operate the database in the insert action. Open the /test/test/lib/model/ folder and create a new file testmodel.class.php. Open it, enter and save the following code

class testmodel extends model {
}
?>

Copy code

This is the basic file for activerecord implementation. The naming rule is to add model after the table in your database. For example, the table to 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{
//Add form data to the database
public function insert() {
//Instantiate the testmodel we just created.
$test = d('test');
if ($test->create()) {
//This is the step to save the form data. thinkphp has done it all.
$test->add();
$this->redirect();
}else{
exit($test->geterror().'[ Return ]');
}
}
}

Copy code

4) Next, you need to add a homepage default display action index() to the indexaction class to call the form data.

public function index() {
//It is still to instantiate our new model corresponding to the corresponding table name. This is an important key for us to perform shortcut table operations.
$test = d('test');
//Are you familiar with this code? Calculate the number of all rows
$count = $test->count('','id');
//The number of rows displayed on each page
$listrows = '3';
//What fields need to be queried
$ fields = 'id,name,content';
//Import paging class/thinkphp/lib/org/util/page.class.php
import("org.util.page");
//Through the constructor of the class to change the parameters of the page. $count is the total number, $listrows is the displayed items on each page.
$p = new page($count,$listrows);
//Set query parameters. For details, see line 1731 of "thinkphp/lib/think/core/model.class.php".
$list = $test->findall('',$fields,'id desc',$p->firstrow.','.$p->listrows);
//The paging class is ready.
$page = $p->show();
//Template output
$this->assign('list',$list);
$this->assign('page',$page);
$this->display();
}

Copy the code

Set a template and create a new index.html under /test/test/tpl/default/index/ (because it corresponds to index() by default . You can assign directly in the program without specifying the template file. Of course, this is configurable. )

Fill in
//Page display, this line
{$page}
//Data Display. The following parameters will be explained in detail soon. It's easy to understand.
Name: {$vo.name}
Content: {$vo.content}

Copy the code

Save, enter http://localhost/test/

The above are the methods and examples of creating pagination in thinkphp. I hope it will be helpful to everyone.