How to use the DBSQL class

This article is about how to use the DBSQL class. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

There are two ways to get DBSQL:

-since DBSQL is part of PHPLIB, you can download a copy of PHPLIB from this site or http://phplib.netuse.de

-download the DBSQL class directly from this site. I have made it independent and made some minor modifications. Download address: http://www.phpuser.com/programs_and_code/codedetail.php?id=3

Modify the DBSQL file.

Open the file, find about 138lines, and change the four variables such as $Host,$Database,$User,$Password to the values on your machine.

How to use the DBSQL class

It's simple enough to come in handy. Here's a typical example (let's assume that the DBSQL class is stored in the db.php file):

01require "db.php"

02$ db=newDBSQL

03$ db- > connect ()

04if ($db- > Link_ID)

{

05$ db- > query ("SELECTid,nameFROMcontactWHEREid > 100ANDid"