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

Home

Backend Development

PHP Tutorial

thinkphp example tutorial data paging

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 25, 2016 am 08:53 AM

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.

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Nordhold: Fusion System, Explained

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1664

CakePHP Tutorial

1423

Laravel Tutorial

1321

PHP Tutorial

1269

C# Tutorial

1249

Related knowledge

PHP and Python: Comparing Two Popular Programming Languages Apr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1? Apr 17, 2025 am 12:06 AM

In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.

PHP in Action: Real-World Examples and Applications Apr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP: A Key Language for Web Development Apr 13, 2025 am 12:08 AM

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7

The Enduring Relevance of PHP: Is It Still Alive? Apr 14, 2025 am 12:12 AM

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

How does PHP type hinting work, including scalar types, return types, union types, and nullable types? Apr 17, 2025 am 12:25 AM

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

PHP and Python: Code Examples and Comparison Apr 15, 2025 am 12:07 AM

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP vs. Other Languages: A Comparison Apr 13, 2025 am 12:19 AM

PHP is suitable for web development, especially in rapid development and processing dynamic content, but is not good at data science and enterprise-level applications. Compared with Python, PHP has more advantages in web development, but is not as good as Python in the field of data science; compared with Java, PHP performs worse in enterprise-level applications, but is more flexible in web development; compared with JavaScript, PHP is more concise in back-end development, but is not as good as JavaScript in front-end development.

See all articles