stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


PHP Class 'SQL Query' released







PHP Class 'SQL Query' released

PHP Class 'SQL Query' released 05/31/2004 06:41 PM

This class is meant to ease the generation of database queries by composing the SQL statements based on parameters passed dynamically to the class functions. The class can generate SELECT, INSERT, UPDATE and DELETE SQL statements. It has functions to specify the columns involved in the queries, the column values and the conditions that will determine which database table rows will be affected.




This is a GrokNews Entry: (what is grok?)





Similar Items

PHP Class 'SQL Query' released

Grok Headline matches for PHP Class 'SQL Query' released

PHP Class 'SQL wrapper' released


PHP Class 'SQL wrapper' released 03/06/2004 02:00 AM
This is a simple MySQL database access wrapper class. It provides functions to connect to a given MySQL database, execute a SQL query, retrieve the query result data and number of rows.

PHP Class 'SQL to Excel' released


PHP Class 'SQL to Excel' released 04/27/2004 06:56 PM
This package is meant to export spreadsheet information in the Excel XLS format. It consists in a base class that is capable of generating the contents of an XLS file given the values of the spreadsheet cells. There is also a sub-class that can query a MySQL database and use the base class to generate the contents of XLS file with the information of the query result set. The class code and comments are in Portuguese.

PHP Class 'SQL Highlighter' released


PHP Class 'SQL Highlighter' released 02/16/2004 07:54 PM
This class is meant to process a SQL statement text string and reformat it with HTML tags that can highlight different parts of the statement with different colors and styles. The syntax of SQL statements that are supported is defined in external files that can be changed to improve the types of SQL keywords that are recognized and highlighted.

PHP Class 'SQL Data Browsing' released


PHP Class 'SQL Data Browsing' released 05/13/2004 06:25 PM
This package is meant to display MySQL query results in multiple HTML pages. It comes with a class for displaying query results in HTML tables and another class for displaying links to browse between all the query result pages.

PHP Class 'PHP or Java Class Code
Generator' released


PHP Class 'PHP or Java Class Code
Generator' released
03/06/2004 02:00 AM
This package is meant is automate the generation of classes to access databases in Java beans style. It uses the Fast Template engine to process template files that define the skeleton of functions and variables of classes that store and retrieve data object property values from a given database table, getter and setter functions to access those properties and a function to delete a data object row from the respective database table. The package comes with templates to generate classes either in PHP or Java. The PHP template defines code to access data objects in a MySQL database. The Java template defines code to access data objects in any database supported by JDBC.

PHP Class 'Convert Class To HTML Table'
released


PHP Class 'Convert Class To HTML Table'
released
02/10/2004 02:46 AM
This class is meant to display the structure of any class as an HTML table. The class being displayed can have variables that contain objects of other classes or arrays and treats those variables each accordingly.

PHP Class 'Bs_StopWatch.class.php'
released


PHP Class 'Bs_StopWatch.class.php'
released
11/07/2002 07:59 PM
You can take times during a code run and at the end get a time table as HTML or text table. The output will contain total and as delta between each take in microseconds. Free Code; This Class is part of the BlueShoes PHP Application Framework, see blueshoes.org.

PHP Class 'calend.class.php' released


PHP Class 'calend.class.php' released 01/03/2003 07:52 PM
This class generates HTML calendars in the portuguese language. In portuguese: Esta classe gera um calendário em português em HTML.

PHP Class 'Bs_CsvUtil.class.php'
released


PHP Class 'Bs_CsvUtil.class.php'
released
11/08/2002 08:17 PM
Features: supports any separator char sequence, default is semicolon ";". supports separator characters in the values. eg you use a ; as separator, your line may look like blah;hello world;"foo";"foo;bar";"this is a ""string""";got it?;foo as you can see, the values can be in "quotes". if your text uses quotes itself as in the "string" example, they are escaped in ms-style with 2 quotes. and by using quotes we can even have your separator inside the text (example "foo;bar"). line breaks. a csv line may spread over multiple lines using crlf in a field value. see the checkMultiline param and the _checkMultiline() method.

PHP Class 'My DB' released


PHP Class 'My DB' released 02/15/2004 07:40 PM
This class is a simple wrapper around MySQL database acess functions. It provides wrapper functions around most of the PHP MySQL extension function like database, connection, queries execution and result data access, error message retrieval, database creation and locking of tables.

PHP Class 'My Db' released


PHP Class 'My Db' released 06/09/2004 06:55 PM
This package is a SQL database wrapper supporting MySQL, Interbase and MS SQL server. It can establish database server connections, execute SQL queries, retrieve query results into arrays and display query results as HTML tables.

PHP Class 'htmldoc' released


PHP Class 'htmldoc' released 10/11/2002 07:54 AM
Object Library for Creation of PDF Documents out of HTML Pages by using htmldoc as conversion facility.

PHP Class 'BaseDB' released


PHP Class 'BaseDB' released 10/11/2002 07:54 AM
Excellent oo base class for mysql interaction. worth looking at. you must use this as a base class and extend your classes which map to a table name. your tables must have a 'id', 'created' and 'modified' field to work properly and the class takes care of the rest. check it out.

PHP Class 'Spreadsheet_WriteExcel'
released


PHP Class 'Spreadsheet_WriteExcel'
released
09/26/2002 07:29 PM
Class for generating Excel files, based on John McNamara's Spreadsheet::WriteExcel from CPAN. It supports all the basic values for cells. It doesn't support URLs, images (working on it) and charts. It has very basic support for formulas.

PHP Class 'WebWidgets' released


PHP Class 'WebWidgets' released 10/11/2002 07:54 PM
WebWidgets is a library of classes to produce any HTML(XML) documents, create, validate forms. It allow to create any "complicated" forms easy. Any tag is an object. Your can build tags tree by inserting one tag into another and get its content as HTML. Based upon "Composite" OOP patern. Library is very flexible, so your may derive your own classes. Documentation in html format can be downloaded from here: http://scancode.ru/dev/WebWidgets/webwidgets.08.doc.tar.gz (it is not fine:( )

PHP Class 'bstCountdown' released


PHP Class 'bstCountdown' released 10/15/2002 07:15 AM
Display a list of 'days until' a set of events, includes a simple example and a more complex one as child classes. Could easily be extended to multi-user and notifications via email by adding a user table and owner columns. Written to MySQL but db access is simple enough to adapt.

PHP Class 'rhc' released


PHP Class 'rhc' released 10/15/2002 07:15 AM
RHC is actually a few files which give the user the ability to do custom error handling, debugging, and handle database abstraction (currently only through Informix).

PHP Class 'URLHelper' released


PHP Class 'URLHelper' released 10/15/2002 07:15 AM
This class give you access to the http header information and provides some help for retrieving and parsing urls. FUNCTIONS: function isURLAvailable($url) function isValidURLFormat($url, $strict=false) function addHTTPtoURL($url) function getHTTPStatusCode($url) function getRealURL ($url, $simple = true, $method = "HEAD") function getHTTPHeader($url) function getMD5FromURL($url, $estFilesize=500000) function _openHTTPConnection($url, $method = "HEAD")

PHP Class 'color' released


PHP Class 'color' released 10/15/2002 07:15 AM
These class converts colortypes. It supports the following colors formats and types: - CMYK - RGB - Pantone - HEX Codes for HTML

PHP Class 'BarcodeI25' released


PHP Class 'BarcodeI25' released 10/15/2002 07:15 AM
HTML Barcode generator for Interleaved 2 of 5 Codes. Código de barras fator Intercalado 2 de 5, padrão FEBRABAN (BRASIL).

PHP Class 'DBgrid' released


PHP Class 'DBgrid' released 10/10/2002 09:55 AM
Show the result of a mysql query on HTML table. Easy to use. 1 line code. $grid = new DBgrid($result);

PHP Class 'CISVC' released


PHP Class 'CISVC' released 01/16/2004 11:05 AM
This class is meant to encapsulate the APIs around the COM object for Microsoft Indexing service (CISVC). The class can perform the search query, output the search results split in multiple pages and also a navigation let the user go back and forth between the presented search results pages.

PHP Class 'morse' released


PHP Class 'morse' released 09/28/2002 07:48 PM
Short class for encoding or decoding morse signs input: this is my 1st morse output: - .... .. ... .. ... -- -.-- .---- ... - -- --- .-. ... .

PHP Class 'burnauth' released


PHP Class 'burnauth' released 09/29/2002 08:10 PM
Burning Auth is a script to handle user authenticated access to php scripts. The goal is quite simple: protect from unauthorized access those pages who need to be kept under admin control, such as data/content administration and/or members only areas on a website. Security is achieved through a database authentication and mantained with a Session variable set to the authenticated user's name. Every page can be protected including the file 'shield.php'; at the beginning of it.

PHP Class 'mixer' released


PHP Class 'mixer' released 10/01/2002 09:17 AM
color mixer for vga (16 colors) - the class create a form for change backgroundcolor

PHP Class 'Pagination' released


PHP Class 'Pagination' released 01/10/2004 07:54 PM
This package is a set of classes is meant to generate navigation bars to display database query result sets split in multiple pages. The packake is based on the factory design pattern that is used to create objects of specific classes to provide the result set pagination support with different databases.

PHP Class 'numeroaletra' released


PHP Class 'numeroaletra' released 10/01/2002 10:18 AM
Extensión de la clase number2words de Bas Jobsen (bas@startpunt.cc) con la traducción de numeros a letras en español y de numeros a euros

PHP Class 'COutLook' released


PHP Class 'COutLook' released 10/01/2002 10:18 AM
This class reads messages from the Inbox and Oubox of an Outlook local profile through CDO (Colaboration Data Objects). The class only works under Windows.

PHP Class 'DCalendar' released


PHP Class 'DCalendar' released 10/08/2002 07:09 AM
Show a calendar with options view year, month and today link. Dynamic events with diferent color

PHP Class 'ms_dbx_reader' released


PHP Class 'ms_dbx_reader' released 10/01/2002 07:38 PM
Microsoft DBX file reader /such as Outlook Express Mailbox database files/ Author: Zeos

PHP Class 'db_view' released


PHP Class 'db_view' released 10/08/2002 07:08 AM
"db_view" provides: * An abstraction class and helpers for multi-tabled Mysql data. (init, select, select_row, count, insert, update, delete) * Atomic multi-table updates, inserts, deletes eg: update items, month set items.price=month.price where items.id=month.id; Also primitive non-atomic (=insecure) rollbacks. * Functions, Triggers and Defaults per action (select, update, insert, delete; before or after) * Rich logging and debugging facilities.

PHP Class 'MkDir' released


PHP Class 'MkDir' released 05/16/2004 07:21 PM
This is a simple class for creating directories in the local file system or in a remote server file system using a FTP connection.

PHP Class 'phplibTemplateExtention'
released


PHP Class 'phplibTemplateExtention'
released
10/08/2002 07:09 AM
phplib has template.inc - a template class for php to utilize templates. This is an extension to the class Template needing less code by: Automatic detection and declaration of blocks Automatic "blanking" of unused blocks Blocks automatically declaired in proper nested order. All calls to set up template/file/paths/names in the class call. - LGPL / GPL - phplibs license anyway - its their template class - I just extended it to make my life a little easier.

PHP Class 'cellroll_lib' released


PHP Class 'cellroll_lib' released 10/15/2002 08:29 PM
Very simple class for faster building of table-rollovers (changing bgcolor for rows or cells) js-scripts

PHP Class 'MyTemplate' released


PHP Class 'MyTemplate' released 10/15/2002 08:29 PM
MyTemplate is very powerful template engine. It allows including a nested template file directly into another template file and automaticaly parse it in any template in set. Working with dinamic blocks is so easy. Only assign block variables and get result. You do not need to parse each block 'manualy'. Automaticaly parses PHP constant and global variables into templates. Supports multiply template directories. You'll like it :) Your code will become shorter :)

PHP Class 'DcSessionManager ' released


PHP Class 'DcSessionManager ' released 05/14/2004 07:21 PM
This class is meant to manage sessions storing the information about their state in a MySQL database table. It generates an hash with 64 characters that is used to identify each session and may be passed between pages using cookies or request variables. This class has security in mind, providing means to prevents session hijack by using 2 hashes (double crypted) in only one "session". You can store more than 5kbytes of data in each session. The class provides other features, like: - Explicitly creating and destroing session - Register and deleting a session value - Check if a session key value is assigned

PHP Class 'page_handle' released


PHP Class 'page_handle' released 10/28/2002 08:29 PM
A template engine geared to be able to display data without much hassle in PHP code, just fetching of data and giving it to the template engine. Create HTML templates with the data's keywords

PHP Class 'mimetype' released


PHP Class 'mimetype' released 10/28/2002 08:29 PM
This class enables PHP scripts to determine the mime type of a file based on file extension, useful for PHP versions without access to other utilities that determine mime type. Built from the Apache mime type file.

PHP Class 'CSQLite' released


PHP Class 'CSQLite' released 05/14/2004 07:21 PM
This class is a wrapper to access SQLite file databases using SQLite extension for PHP 5. The functions are similar to those used to access MySQL databases: open, query, fetch_row and get_num_rows.
Grok Description matches for PHP Class 'SQL Query' released
GrokA matches for PHP Class 'SQL Query' released

PHP Class 'SQL Query' released

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

PHP Class 'File
Split' released

Reports: HP To Boost
Backing of Open
Source

HP adds JBoss, MySQL
support

HP Throws Weight
Behind MySQL, JBoss

MPGEDIT 0.71dev
(Development)

Grace 5.1.15
gnuPod 0.95rc1
CanIt 2.1 (Stable)
Varuna Converter 0.6
Flawfinder 1.25
JooTemplates 1.0b2
Pappagallo 1.0
betrachter 1.0
Shankamala 0.1
In Oregon, Choosing
Death Over Suffering

Saving a Reef for
the Fish, and the
People

A Drink? The Ice Is
Vintage

Constant as the
North Star? More
Like Fickle

Tell the Doctor All
Your Problems, but
Keep It to Less Than
a Minute

The New H.I.V. Test
Offers Quicker
Results, but the
Same Agony

How Household Junk
Can Grow Into
Mountains

Treatment:
Unexpected Benefit
for Diabetics

Screening: False
Positives in
Mammograms

On Terms of Her
Choosing, a Woman
Ends Her Life

A Great Spanish
Explorer, Blown Off
Course From Fame

Hippos at the Beach?
Penguin Problems
Abstinence-Only:
Does It Work?

Big Belly, Big Shoes
Maddux Pitches Cubs
Past Astros, 3-1
(AP)

Iraq seeks to ease
water shortage

Experiences of the
day

PressThink Passes
The Quarter Million
Mark

Fiat Struggles to
Steady Itself During
Turmoil

Thunderbirds and
Memories

RTC launches
computerised
information system

Symbian loophole
'threatens operator
revenue'

Intel:
Architecturing the
Era of Tera

Federal agency
faulted for weak
security

Our job is to
promote Internet
use: Dayanidhi Maran

Planet Venus will
cross face of sun

AMD and Intel
Performance Plateau
Ripple Effect

Google too
Motorolas India
Software Centre To
Develop Mobile
Handsets

Lucire enters the
real world

Adrian Mole: the
text-adventure game

I'm nominated for
the Sunburst Award!

William Hung sings
at a Jays game

John Shirley reports
from BayCon

Titanium Face Plate
for NTT Docomo P900i

what is grok?