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


PHP Class 'MySQL Optimizer' released







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.




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





Similar Items

PHP Class 'MySQL Optimizer' released

Grok Headline matches for PHP Class 'MySQL Optimizer' released

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

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

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

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)..."

Optimizer 0.11


Optimizer 0.11 01/04/2004 09:33 AM
A program which helps achieve the highest lossy compression that is visually acc

TCP Optimizer 1.01


TCP Optimizer 1.01 08/06/2004 06:57 PM

System Optimizer X (v4.1)


System Optimizer X (v4.1) 02/10/2004 02:43 AM
By Neema saeedi (Inside Apple via MyAppleMenu)

Regexp-Optimizer-0.13


Regexp-Optimizer-0.13 05/08/2004 06:25 AM

Regexp-Optimizer-0.11


Regexp-Optimizer-0.11 05/03/2004 04:40 PM

Regexp-Optimizer-0.12


Regexp-Optimizer-0.12 05/04/2004 04:43 PM

Disk Optimizer


Disk Optimizer 05/15/2004 11:29 PM
Update

Asmw PC-Optimizer pro v6.12


Asmw PC-Optimizer pro v6.12 12/11/2003 10:49 AM
Asmw PC-Optimizer pro is a collection of over 21 system-maintenance and optimization utility to tune up windows performance. Remove junk files and zero size files to save valuable disk space; Registry Cleaner, to prevent application crashes; Startup Manager, to prevent spy applications from running behind your back; erase your navigation tracks to ensure your privacy; Speed up your Internet connection by up to 300%; and much much more. [Shareware $24.95 15 Days 3.70 MB]

Update: System Optimizer X 4.5


Update: System Optimizer X 4.5 07/14/2004 10:04 AM
The Mac OS X maintenance utility adds an Optimize option to run multiple routines automatically, revamped internals, updated documentation, and other improvements.

Are You a Polyolefin Optimizer? Take
This Quiz!


Are You a Polyolefin Optimizer? Take
This Quiz!
04/16/2004 06:16 AM
Dow Chemicals VP Kurt Swogger has found a way to purify the creative process in R&D.

Electronics Optimizer v0.9.5,Beta


Electronics Optimizer v0.9.5,Beta 05/23/2004 01:57 AM
An electronic circuit analyser.

ComputerBase Mozilla Optimizer 1.1


ComputerBase Mozilla Optimizer 1.1 01/25/2004 12:50 PM

ComputerBase Mozilla Optimizer 1.6.1


ComputerBase Mozilla Optimizer 1.6.1 04/11/2004 05:01 PM

Apache2-SSL-PHP5 and Zend Optimizer


Apache2-SSL-PHP5 and Zend Optimizer 06/05/2005 11:38 PM
Here is an article describing how to install an Apache web server (2.0.x) with SSL and PHP5 (with Zend Optimizer and ionCube Loader) enabled. All software is compiled from the sources. In addition to that, the article also shows how to install the Zend Optimizer and IonCube Loader and use it with your PHP installation. http://www.howtoforge.com/linux_apache2_ssl_php5_zendoptimizer_ioncube loader

Zend: New Optimizer Version Released


Zend: New Optimizer Version Released 02/12/2004 10:10 AM
In a quick note from Zend this morning, they have a new software announcement:

Boost Oracle performance with
intelligent optimizer limits


Boost Oracle performance with
intelligent optimizer limits
02/12/2003 02:06 AM
CNET Feb 12 2003 1:24AM ET

ClickTracks Optimizer Offers Must Have
Reporting for Small Businesses


ClickTracks Optimizer Offers Must Have
Reporting for Small Businesses
03/14/2005 06:29 PM

Search Engine Optimizer Forced To Pay Up
For Failing To Optimize Much


Search Engine Optimizer Forced To Pay Up
For Failing To Optimize Much
08/12/2004 03:18 PM
The search engine optimization business has been battling the perception that it's all a big scam. Many people at various search engines continue to insist that a well created site needs no "search engine optimization" and there are certainly plenty of scamming companies out there that offer SEO services, by which they really mean link-spamming and other sneaky tricks to try to game Google, rather than actually "optimizing" your site for search engines. However, whether bogus or legit, it would seem particularly stupid to promise companies that you could get them into the top ten in listings. In this case, it was stupid, because the company in question didn't get their customers into the top 10 and is now being forced to pay a fine for false advertising. Speaking of which... I have no clue what the normal going rate is for search engine optimization, but anyone who pays a $1,500 setup fee and $90/month for what, in this case, appears to be useless black magic, is clearly throwing money away.

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.

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: PHP and MySQL Get a Little Closer


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

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..."

TCB-mysql-0.2


TCB-mysql-0.2 05/26/2004 04:50 PM

MySQL 5.0


MySQL 5.0 12/29/2003 11:50 PM

Changes in release 5.0.0 (Development): MySQL has released an alpha of version 5.0. They include support for stored procedures, but no views yet.

C lick here to comment on this entry


MySQL 4.0.18


MySQL 4.0.18 05/06/2004 06:50 PM
The world’s most widely used open source database.

Use MySQL.


Use MySQL. 03/11/2003 10:45 AM
If you’re using Movable Type, use MySQL. If you have something against MySQL, use something else, but don’t use DB files. Note: Here comes the rant....

MySQL Log


MySQL Log 09/28/2002 03:31 AM
Add and show the log provide by other classes such as MySQL Connection and MySQL Recordset

PHP Class 'MySQL Optimizer' released

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

















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

YahooFinance: MySQL,
Zend Join Forces to
Strengthen Open
Source Web
Development

D.Net CMS Beta
Released

ADTmag: Open-Source
MySQL DBMS Adds
Clustering Tech

PHP Class 'Form
Classic' released

qpopper-mysql 0.13
released

Adding & Changing
Data in MySQL

Content Architect/IT
Analyst

Perl Application
Developer

Perl IS developer
Intermediate
Developer for an
online market
research company

Senior Perl
Developer wanted in
MN!!

OO CGI/mod_perl
developer

Immediate
Opportunities for
E-Commerce &
Transaction
Processing Co.

Perl / Mason
Application
Architect

PHP and Apache 2.0
PHP Class 'My Query
Report' released

PHP Class 'Email
Sender' released

PHP Class 'MySQL
Operations' released

Implement Bayesian
inference using PHP,
Part 1

PHP Class 'Browse
Edit' released

PHP Class 'Image to
PHP' released

PHP Class 'reGlobal'
released

PHP Class 'gonxtabs'
released

PHP Class 'PHP
Figlet' released

PHP Class 'MySQL
Backup Pro' released

Aqsis Renderer
release 0.9.1
Source, Windows
binary, RPM

PHP Class 'ADSI
Access' released

Switches look to
security to
recapture lost
luster

Tech group urges
action on health
care mandates

Sun kills UltraSparc
V, Gemini chips

Microsoft reins in
Longhorn for 2006
launch

Accounting questions
delay Salesforce IPO

Lindows to Change
Name

BugMeNot.com
Speed Sensing
Traffic Light

Smooth As Silk on
Square Wheels

Happy Birthday,
Internet!

The Exploratorium
System/360 Turns 40
Real Life X-Files
Early Usenet Posts
See the Ether
To the Moon!
Electronic Data
Coverage Insurance

The Endless Mountain
Life With Fedora
Field
FrooglePEG
I'm paying for what
now?

Time to hit the
streets

what is grok?