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 AMThis 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 PMThis 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 PMThis 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 PMThis 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 PMFunctions 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 PMThis 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 PMProvide 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 PMThis 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 PMThis 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 PMAllow 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 PMThis 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 PMThis 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 PMAdd 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 PMInsert 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 PMThis 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 PMThis 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 PMThis 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 AMThis 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 PMThis 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 PMThis 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 PMThis 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 PMA 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 AMThis 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 PMThis 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 PMYou 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 PMFeatures:
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 PMSMS 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 AMSQL 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 PMSMS Query: Query to Select Defined
Packages
SMS Query: Query to Select Defined
Packages
06/08/2004 06:42 PMSMS Query: Query to Show the WBEM
Version
SMS Query: Query to Show the WBEM
Version
05/23/2004 02:01 AMSMS Query: Query to Select ONLY SMS SP2
Clients
SMS Query: Query to Select ONLY SMS SP2
Clients
05/23/2004 05:04 AMSMS 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 PMSMS Query: Query to List by OS and SP
Level
SMS Query: Query to List by OS and SP
Level
05/12/2004 02:54 AMSQL Script: Query Name By Query ID View
SQL Script: Query Name By Query ID View
05/13/2004 12:17 PMNew XML Query Language and Query Engine
New XML Query Language and Query Engine
04/11/2005 02:13 AMXML 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 AMPHP Class 'My Db' released
PHP Class 'My Db' released
06/09/2004 06:55 PMThis 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 PMThis 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 PMIs 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 AMA 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 AMA database querying tool for MySQL servers.
MySQL DHCP Generator 1.0.0
MySQL DHCP Generator 1.0.0
07/13/2004 01:58 PMGenerates 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 AMA 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 PMA 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 AMIn 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 AMIn 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 AMHow 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 AMQuickTip: Getting the SQL Query from the
SMS Query
QuickTip: Getting the SQL Query from the
SMS Query
09/12/2004 05:03 AMMySQL: PHP and MySQL Get a Little Closer
MySQL: PHP and MySQL Get a Little Closer
02/18/2003 04:17 PMMySQL: 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 AMVanAbel.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