PHPBuilder - So you want to use a database in your site? Page 6

RSS Twitter

So you want to use a database in your site? - Page 6

by: Jess Castagnetto
July 30, 2000

In the script above we have two general parsing functions that return a valid SQL comparison statement, these can be extended to cases in which we want to allow the use of operators such as: AND, OR, NOT, etc.
In this script, you saw the use of default values for some of the parsing functions parameters; this allows the invokation of the function with a variable number of said parameters. You will only need to specify the defaulted ones if you need to change them.
We will use the form to search for the keywords "image,reading,creating", in the title of articles written by Matias or Mark or Rasmus, with a publication date of 1999 or later. This will generate the following result:
Query Results
Saving your query for debugging purposes
You searched on articles with the words image,reading,creating in the title; written by Mark Musone OR Mattias Nilsson OR Rasmus Lerdorf published on or after 1999.
and it found: 3 rows
IMAP Mail Reading With PHP3Mark Musone19990207200
Creating your own logfileMattias Nilsson19990302200
Image Creation With PHPRasmus Lerdorf19990124200
The form and the handling script can be modified to allow searching on more variables, or to search for keywords in the title and/or the body of the article, or even to retrieve a keyword matched in the body in a context (for example, get the 2 lines above and below the matching line).
Using a form like this gives control on the information the user can access, and reduces the number of possible SQL queries. If you type straight SQL, you can always make a query that can take (for practical purposes) and infinite amount of time to finish, something you may not want to happen in your site.

« Previous Page
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Jess Castagnetto



(Maximum characters: 1200). You have characters left.