search
Homephp教程php手册thinkphp3.2.3 + PHP5.3 MSSQL2000 class + paging

MSSQL2000
I am a newbie and just started learning TP,

Since I need to use mssql2000, I haven’t found a solution yet,

Combined with the previous php5.2 code, I made one myself,

Masters, don’t spray!

Use native statements
1 Configure MSSQL information
'DB2' => array (
'DB_HOST' => '127.0.0.1',
'DB_NAME' => 'test',
'DB_USER' => 'sa',
'DB_PWD' => '123456',
),

2. Introduce the class and put the attachment under the path /Project/ORG/Util/

import("@.ORG.Util.Mssql");
$mdb = new mssql(C('DB2'));

3 calls:
Pagination=$mdb->get_pages("field","table","condition", "URL address", "number of records")
Number of data items=$mdb->get_num_rows("SELECT statement")
Data set=$mdb->get_list("SELECT statement")
Single piece of data=$mdb->get_one("SELECT statement")

thinkphp3.2.3 + PHP5.3 MSSQL2000 class + paging Mssql.class.rar ( 1.38 KB Download: 17 times )

Statement
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

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!