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


PHP Class 'MySQL Query Generator' released







PHP Class 'MySQL Query Generator'
released

PHP Class 'MySQL Query Generator'
released
04/30/2004 07:04 PM

This class is meant to compose MySQL database queries from conditions defined dynamically calling the class functions. It can compose MySQL database queries add, delete, reset conditions and key values used to determine the affected rows.




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





Similar Items

PHP Class 'MySQL Query Generator' released

Grok Headline matches for PHP Class 'MySQL Query Generator' released

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 'Thumbnail Generator' released


PHP Class 'Thumbnail Generator' released 11/10/2003 11:34 PM
This class is meant to generate thumbnails from images in the GIF, JPEG or PNG formats. The images are scaled proportionally assuring that neither the width nor the height exceed a given thumbnail size. It uses the GD lib to resize the images. The thumbnail is generated as true color image in the PNG format.

PHP Class 'Bar Graph generator' released


PHP Class 'Bar Graph generator' released 04/13/2004 06:13 PM
This class is meant to generate bar graphs defined either programatically calling the class functions or using definition file to specify the graph characteristics. The graph definitions file structure is very simple and so it is probably a better way to create graphics on the fly. It supports axis background or border color, title text and color, graph background color, bars background and border colors, padding distances, etc.. Transparent background and transparency levels for the entire image are also supported. The bar graph images are generates in true color in PNG format.

PHP Class 'MySQL SP' released


PHP Class 'MySQL SP' released 04/22/2004 06:54 PM
This class is meant to provide an emulation of stored procedures for MySQL. It uses template files stored on the database client side that contain multiple SQL statements with special marks that identify placeholders that are replaced by procedure arguments when they are executed. The result of the execution of procedure is an array containing either the handles of the result set of the SELECT statements or the number of affected rows of other statements.

PHP Class 'MySQL Collection' released


PHP Class 'MySQL Collection' released 10/22/2002 07:55 PM
Functions of Log +---- log() // Create a log file +---- addLog() // Append one line in the log file +---- show() // Show de log content in HTML format Properties of Connection +---- application // Name of application +---- host // IP or Name of MySQL Server +---- login // Login MySql +---- senha // Password MySQL +---- db // Database +---- admMail // E-mail of Admin +---- log // Instance o log object +---- conID // ID of MySQL Connection Functions of Connection +---- connection() // Inicialize +---- connect() // Conect with MySQL Server return de conID +---- close() // Close Connection Function of RecordSet +---- checkSql() // Protect sql from DROP, CREATE and other +---- select() // Select Query +---- setRow() // Fetch array +---- getLastID() // Return the last inserted ID +---- getFieldName() // Return a name o field +---- fieldsCount () // Number of Fields +---- recordCount() // Number of records +---- exec() // Execute a Inser, Update, Delete and others SQL +---- erase() // Delete one record by ID +---- erases() // Delete various records by Array (Such as checkbox) +---- comboBox() +---- comboBoxBin() +---- insert() // Generate a Insert SQL sentence with POST data +---- update() // Generate a Update SQL sentence with POST data +---- getForm() // Get POST data

PHP Class 'MySQL Abstract' released


PHP Class 'MySQL Abstract' released 05/06/2004 06:44 PM
This is a wrapper class to simplify MySQL queries. It features - Connect to a MySQL server reusing connections previously opened to the same server - Insert or update rows using arrays of fields and values - Delete rows that satisfy a given condition - Retrieve the next unused field id - Emulate sub-selects with NOT IN clause - Select single field values providing a default value in case no row is returned

PHP Class 'MySQL RecordSetdo' released


PHP Class 'MySQL RecordSetdo' released 09/27/2002 07:39 PM
Provide automatic erase by ID, erase by Array, check SQL between other functions. The MySQL Connection is required

PHP Class 'MySQL wrapper' released


PHP Class 'MySQL wrapper' released 05/15/2004 06:44 PM
This is a simple class that encapsulates the functionality of MySQL database access commands. It establishes database connections, executes queries storing the result set handle in a class variable and provides other functions to traverse the result set an retrieve the data returned by the database server.

PHP Class 'MySQL Operations' released


PHP Class 'MySQL Operations' released 04/09/2004 04:05 PM
This is a simple class meant to connect and query a MySQL database. It has functions to connect to a given MySQL database, execute queries, retrieve results and the number or rows.

PHP Class 'MySQL Connection' released


PHP Class 'MySQL Connection' released 09/27/2002 07:39 PM
Allow developers connect with MySQL Server with Log generate. Log class is required. See my classes

PHP Class 'Mysql DBObj' released


PHP Class 'Mysql DBObj' released 06/05/2004 06:18 PM
This class is meant to simplify the composition and execution of MySQL database SELECT queries. It has functions that can establish the database connection and others to specify the query conditions, columns to sort the results, result row limits and execute the queries.

PHP Class 'MySQL Optimizer' released


PHP Class 'MySQL Optimizer' released 04/09/2004 04:05 PM
This class is meant to analyze, optimize or repair tables of a MySQL database. The class is capable of connecting to a given MySQL database, extract the list of names of tables, and perform one of the three operations in all tables. The results are outputted in an HTML table.

PHP Class 'MySQL Log' released


PHP Class 'MySQL Log' released 09/28/2002 07:48 PM
Add and show the log provide by other classes such as MySQL Connection and MySQL Recordset

PHP Class 'MySQL to XML - XML to MySQL'
released


PHP Class 'MySQL to XML - XML to MySQL'
released
10/02/2002 08:10 PM
Insert XML in MySQL and export MySQL to XML. The class XMLFile and my other class such as MySQL Connection, MySQL RecordSet and MySQL Log are required.

PHP Class 'MySQL Parser' released


PHP Class 'MySQL Parser' released 03/08/2004 11:06 PM
This class is meant to parse boolean expressions like (item1 AND item2 AND NOT (item3 OR item4)) and converts them into MySQL full text search conditions like (+item1 +item2 -(item3 item4)).

PHP Class 'MySQL stored procedures'
released


PHP Class 'MySQL stored procedures'
released
05/07/2004 07:06 PM
This class emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures. It executes simple queries defined within a named block, known as "stored procedure". The query syntax within a stored procedure is compliant with standard SELECT, INSERT, DELETE and UPDATE MySQL queries, but it does not accept sub-select queries like "INSERT ... SELECT". Every stored procedure can have parameters that must be initialized before the execution. Here is the of provided functionality: - Loading and saving stored procedures on disk files. - Procedure execution - Dumping in HTML format the code of loaded procedures - All the methods not implemented have a proprietary license

PHP Class 'MySQL Backup Pro' released


PHP Class 'MySQL Backup Pro' released 04/09/2004 04:05 PM
This package is meant to provide backup and restore services of MySQL databases. It provides a friendly tab based user interface that lets the users create backups of given MySQL databases to files, listing previously generated backups, restore a given backup and deleting backup files. Currently this package requires PHP with the bzip extension enabled to generate compressed backup files. It also uses the gonxtabs class to create an user-friendly navigation menu.

PHP Class 'Mysql record set' released


PHP Class 'Mysql record set' released 10/29/2003 12:10 AM
This class gives you the possibility to navigate through MySQL record sets and manipulate the stored information. It just takes a SELECT statement and the class takes care of the other operations that you may want to perform, like for instance: updating records, deleting records, adding a new record, filter records according to a criteria. The class is meant to be used by those who just want easy access to their database table records and do not want to deal SQL too much.

PHP Class 'My Query Report' released


PHP Class 'My Query Report' released 04/09/2004 04:05 PM
This is a simple class that can connect to a MySQL database, execute an SQL query, retrieve the result set rows and display it in a proper report format with different color flavors. The class establishes a connection to MySQL and selects the named database. It executes the query using the query string passed. From the result set, the class extracts the number of rows, the number of columns, the names of each column in the result set. Using these and color theme passed as parameter, colorful reports are generated.

PHP Class 'Freshmeat project query
class' released


PHP Class 'Freshmeat project query
class' released
10/31/2002 07:32 PM
This class is able to query the Freshmeat site to retrieve information on Open Source projects with records there. It features: - Retrieval of project information from records provided by Freshmeat in XML. - Parsing project XML records to extract all the relevant data. - Caches retrieved project information in disk files for at least the next day to avoid retrieving the same data again before it could have been updated.

Freshmeat project query class


Freshmeat project query class 10/31/2002 06:31 PM
This class is able to query the Freshmeat site to retrieve information on Open Source projects with records there. It features: - Retrieval of project information from records provided by Freshmeat in XML. - Parsing project XML records to extract all the relevant data. - Caches retrieved project information in disk files for at least the next day to avoid retrieving the same data again before it could have been updated.

freshmeat Project Query Class 2003.11.02


freshmeat Project Query Class 2003.11.02 11/04/2003 11:41 PM
A PHP class that retrieves data from freshmeat.

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 '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_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 '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.

SMS Query: SQL Query to Select Hardware
and Software Components


SMS Query: SQL Query to Select Hardware
and Software Components
05/29/2004 12:19 PM

SMS Query: Query to Show Servers
Rebooted Within Last 30 Days


SMS Query: Query to Show Servers
Rebooted Within Last 30 Days
05/08/2004 06:21 AM

SQL Query: Query to Delete a Machine
From the SMS Database


SQL Query: Query to Delete a Machine
From the SMS Database
08/16/2004 06:29 PM

SMS Query: Query to Select Defined
Packages


SMS Query: Query to Select Defined
Packages
06/08/2004 06:42 PM

SMS Query: Query to Show the WBEM
Version


SMS Query: Query to Show the WBEM
Version
05/23/2004 02:01 AM

SMS Query: Query to Select ONLY SMS SP2
Clients


SMS Query: Query to Select ONLY SMS SP2
Clients
05/23/2004 05:04 AM

SMS Query: Query to Find Systems With
THIS but Not THAT


SMS Query: Query to Find Systems With
THIS but Not THAT
07/31/2004 10:17 PM

SMS Query: Query to List by OS and SP
Level


SMS Query: Query to List by OS and SP
Level
05/12/2004 02:54 AM

SQL Script: Query Name By Query ID View


SQL Script: Query Name By Query ID View 05/13/2004 12:17 PM

New XML Query Language and Query Engine


New XML Query Language and Query Engine 04/11/2005 02:13 AM
XML makes it easy to define document types, easy to author and manage documents over multiple platforms, such as Windows or UNIX, and easy to transmit and share them across the Web. [PRWEB Apr 11, 2005]

SMS Query: Query to Find Systems Without
THIS or THAT


SMS Query: Query to Find Systems Without
THIS or THAT
06/16/2004 08:34 AM

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 '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.
Grok Description matches for PHP Class 'MySQL Query Generator' released
GrokA matches for PHP Class 'MySQL Query Generator' released

Mysql Query Speed


Mysql Query Speed 02/01/2005 09:16 PM
Is it true that the more fields to select in the SELECT query, it will slow down the query?

MySQL Query Browser 1.1.5


MySQL Query Browser 1.1.5 01/07/2005 12:37 AM
A database querying tool for MySQL servers.

MySQL Query Browser 1.0.7-beta


MySQL Query Browser 1.0.7-beta 09/01/2004 09:55 AM
A database querying tool for MySQL servers.

MySQL DHCP Generator 1.0.0


MySQL DHCP Generator 1.0.0 07/13/2004 01:58 PM
Generates dhcpd.conf files from a MySQL database.

MySQL C++ code generator 1.3.2


MySQL C++ code generator 1.3.2 08/05/2004 06:46 AM
A utility that converts SQL tables to C++ classes.

MySQL C++ code generator 1.3.3


MySQL C++ code generator 1.3.3 08/16/2004 10:25 PM
A utility that converts SQL tables to C++ classes.

MySQL C++ code generator 1.6 (Default
branch)


MySQL C++ code generator 1.6 (Default
branch)
04/12/2005 05:18 PM
The MySQL C++ code generator (sql2class) utility is a code generation tool to convert output from the MySQL tool mysqldump to simple C++ classes. For each database table, one C++ class will be generated containing member variables for each column, as well as methods to read / insert / update records and also return the record as XML.
Changes:
Uses a unique index to generate update / erase methods if the primary index is not available. If no primary / unique index is available, then update / erase methods for that table are not generated.

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php


EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php
12/16/2002 04:17 PM
"Stefan Esser from the PHP.net project discovered two vulnerabilities in MySQL which range from crashing the server to executing arbitrary code as the user under which the MySQL daemon runs (mysql)..."

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall


SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall
02/01/2005 09:06 PM
"None of the legal attacks on open source or Linux have been successful. None of that stuff has gone anywhere. That's the biggest story..."

MySQL: MySQL Administrator Announced


MySQL: MySQL Administrator Announced 01/22/2004 10:26 AM
In a startling new note from the MySQL development team, information about their newest application has been posted on their site.

MySQL: MySQL Administrator Now Availible


MySQL: MySQL Administrator Now Availible 02/12/2004 10:10 AM
In a new note passed along to me from MarkL this morning, there's some new information about the admin tool that the MySQL folks have created.

Clockwatchers Web Hosting - MySQL
Tutorial - Import & Export Database


Clockwatchers Web Hosting - MySQL
Tutorial - Import & Export Database
05/24/2004 12:12 AM
How to import or export a MySQL database

clockwatchers.com/mysql_dump.html
track this site | 4 links


SMS Query: Query for All Systems with
WMI v1.5


SMS Query: Query for All Systems with
WMI v1.5
05/16/2004 05:16 AM

QuickTip: Getting the SQL Query from the
SMS Query


QuickTip: Getting the SQL Query from the
SMS Query
09/12/2004 05:03 AM

MySQL: PHP and MySQL Get a Little Closer


MySQL: PHP and MySQL Get a Little Closer 02/18/2003 04:17 PM

MySQL: MySQL 4.0.20 Released


MySQL: MySQL 4.0.20 Released 05/20/2004 06:59 PM
"MySQL 4.0.20, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: MySQL 5.0.0 Has Been Released


MySQL: MySQL 5.0.0 Has Been Released 12/26/2003 07:47 PM
"MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released..."

Fulltime OffShore Independent Developers
- Perl & HTML-Template,
MySQL-PostgreSQL, Linux for USA
eCommerce Clients


Fulltime OffShore Independent Developers
- Perl & HTML-Template,
MySQL-PostgreSQL, Linux for USA
eCommerce Clients
11/18/2003 12:18 AM
VanAbel.Com - OffShore (2003-11-17)

SMS WQL Query Builder Object Type
Available Fields Samples


SMS WQL Query Builder Object Type
Available Fields Samples
12/26/2004 01:47 AM

PHP Class 'MySQL Query Generator' released

The following phrases have been identified by the grok system as matching this entry: "export mysql""csv""php" php mysql query builder sql "query generator" php multiple update using checkbox xls generator php class mysql php mysql query generator "display mysql query" html perl php mysql export xls php query generator

















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 'Config
Tool' released

Looking for Ad
Managment Package

lightcycles!
XML vendors set to
unveil gigabit
speeds

JBoss?s Fleury: The
benevolent dictator
is good for Java

What Is Web
Accessibility?

Mountaintop Corners
Crew Returns to
Earth From Space
Station (AP)

Open Mortal 0.7
Clamor 0.0.21
Omega -- the Erik
Francis edition
0.90.4 (Development)

EtherDam 0.2
Seagull PHP
Application
Framework 0.3.7

TheStreet: Lindows
Hopes to Capitalize
on Linux Fervor, IPO
Revival

Hardware Players Get
First Shot at
Longhorn

A Year On, Bush
Acknowledges 'Tough
Times' in Iraq
(Reuters)

'Nightline' War Dead
List Causes Uproar
(AP)

Nightline's Next
Move

'Tony Martin law' is
blocked

Iraqi soldiers move
into Falluja

Dazzling entry for
new EU members

Sun's Opteron box
defies European
power supply
standards

3Com to Roll Out New
Network Management
Tool

Astrophysical
Virtual Observatory

The world's second
biggest
supercomputer?

Metal Storm to
Demonstrate
Weaponized UAV

exiftags 0.99
MP3 Streaming
DownSampler for PHP
2.0

GalaxyHack 0.4
GKrellM 2.1.28 (GTK
2.0)

GQview 1.4.3
(Stable)

Fink 0.7.0
CVS_SNAP-20043004
(CVS)

Workrave 1.6.0
Dryad Milestone 1
DCP-Portal 6.1
(Final)

CBT Combo 0.1.3
3 Million PSPs In
the First 3 Months

Worm warning
intensifies

Random, April-fresh
obscenities hidden
in XML file on
deodorant website

Williams Is
Acquitted on
Manslaughter Charge

RTLAD Dryad
Sandcrawler Order
Status

Naboo Final Conflict
At Amazon

2004 Hallmark
Keepsake Ornaments

Star Wars Weekends
2004 Collectibles

Dark Horse Comics
Gallery Update:
Shadows Of The
Empire

EP3: Marketing Plan
Revealed

Woman Allegedly
Exposes Breasts on
Stage (AP)

Man Jumps Off Salt
Lake City Building
(AP)

Tennessee Rejects
Napster's Music
Offer

what is grok?