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


PHP Class 'MySQL Operations' released







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.




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





Similar Items

PHP Class 'MySQL Operations' released

Grok Headline matches for PHP Class 'MySQL Operations' released

PHP Class 'Date operations' released


PHP Class 'Date operations' released 01/06/2003 07:35 PM
Class to perform arithmetic operations with dates like add or subtracting days, months or years.

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

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 '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 '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 'EMailRobot' released


PHP Class 'EMailRobot' released 09/03/2002 11:37 AM
E-mail robot, takes letters, parse and forms answer. Simple for customize. http://nemilya.narod.ru/erobot/ - uml diagrams.

PHP Class 'pdf_search' released


PHP Class 'pdf_search' released 08/27/2002 07:55 PM
A class to search text in pdf documents. Not pretending to be useful other than that. But it can easily be extended to a full featured pdf document parser by anyone who chooses so. License: Public Domain Warranty: None

PHP Class 'mysqldb' released


PHP Class 'mysqldb' released 10/16/2002 07:47 PM
mysql_db provides access to MySQL using these methods: open() - connects to database query() - runs SQL query against the connected database last_id() - gets last insert id for the connection close() - close database connection Errors are handled via properties $db->errtype and $db->errstr, which can be tested for.

PHP Class 'utilsClass' released


PHP Class 'utilsClass' released 10/16/2002 07:47 PM
Utils class for phpLib, provide 4 methods to select, insert, update and delete data from database. It requires phpLib properly installed. It's really a simple work, but it was helpful to me, so I thought to make it available.

PHP Class 'BookmarkParser' released


PHP Class 'BookmarkParser' released 10/17/2002 08:03 AM
This class parses IE, Netscape and Opera bookmark files and returns arrays with the bookmark / folder information. STILL BETA! FUNCTIONS: function parseOpera($url, $folderID, $urlFunction, $folderFunction) function parseNetscape($url, $folderID, $urlFunction, $folderFunction) function parseInternetExplorer($url, $folderID, $urlFunction, $folderFunction, $firstCall = true)

PHP Class 'download' released


PHP Class 'download' released 09/03/2002 11:37 AM
This class allows to download files with the appropriate headers. Client web browsers recognize the headers, file and mime type and save to disk or offer to open the file using a local application. Files bigger than a given limit are automatically compressed defore downloading to the client.

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 '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 '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 'CCounter' released


PHP Class 'CCounter' released 09/19/2002 07:56 PM
This class stores all unique ip's in a simple flat text file and increments the count for each unique ip's visit. It allows you to track how many times a single IP has visited your page, how many unique ip's have visited, and the total visits (sum of all unique visits) ... along with telling a visitor what there ID is in the text file (this basically allows you to inform the user that they are visitor X out of Y)

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

Temp Text Size Change


Temp Text Size Change 07/07/2004 10:56 PM
Tech-Recipes Jul 8 2004 3:23AM GMT

Perl Programmer (with exp. in CGI,
MSSQL, and Win32)


Perl Programmer (with exp. in CGI,
MSSQL, and Win32)
01/16/2004 11:33 AM
iATN - United States, California, Brea (2004-01-14)

Change default paper size in groff
applications


Change default paper size in groff
applications
07/26/2004 12:27 PM
If you use groff for any sort of printing, you will discover that Mac OS X ships with the default paper size set to A4. If you use A4 paper,this hint does not apply to you. If you don't, then you need to change your paper si...

Google Cache Page Size Limit Change


Google Cache Page Size Limit Change 04/06/2005 12:30 PM
"Google searches are now returning SERPs showing cached page size greater than 101k. It's been 101k for as long as I can remember."

Perl/Win32/MSSQL Programmer/DBA for
Quality Group


Perl/Win32/MSSQL Programmer/DBA for
Quality Group
07/31/2004 03:49 AM
AFC - United States, TX, Bedford (2004-07-30)

activestate/Win32 + linux, perl +
wxWindows + TCP/IP sockets(POP+SMTP
proxy) new antispam application.
telecommute posn.


activestate/Win32 + linux, perl +
wxWindows + TCP/IP sockets(POP+SMTP
proxy) new antispam application.
telecommute posn.
08/11/2004 03:10 PM
spamzap.com - Telecommute, Telecommute, Telecommute (2004-08-11)

Dependent ComboBox in HTML build with
XSLT


Dependent ComboBox in HTML build with
XSLT
01/10/2003 04:46 AM
Top XML Jan 10 2003 3:38AM ET

HotFix Watch: Win32 Error = 1072 error
appears after you change the SMS 2.0
Service account of a secondary site


HotFix Watch: Win32 Error = 1072 error
appears after you change the SMS 2.0
Service account of a secondary site
12/28/2004 07:03 PM

Meg talks about how times change, people
change, webl0gs change but some things
endure


Meg talks about how times change, people
change, webl0gs change but some things
endure
06/05/2005 11:30 PM
Nostalgia isn't what it used to be

meish.org/014253.php
track this site | 2 links


Dividend change doesn't change
Microsoft's lofty status


Dividend change doesn't change
Microsoft's lofty status
11/04/2003 09:54 AM
Chicago Tribune Nov 4 2003 8:23AM ET

Perl Developer! - Market Leader! -
Perl,MySQL,Apache


Perl Developer! - Market Leader! -
Perl,MySQL,Apache
02/01/2005 09:51 PM
Alan Morris Recruitment - United Kingdom, London (2005-02-01)

Perl/mod Perl developer, portgreSQL
experience


Perl/mod Perl developer, portgreSQL
experience
03/21/2003 12:28 PM
uptime systemlösungen gmbh - Austria, vienna (2003-03-21)

Cultured Perl: Three Essential Perl
Books


Cultured Perl: Three Essential Perl
Books
05/19/2004 09:14 AM
KLB writes "In this article, the author reviews three Perl coding books, bringing you summaries of the key information contained in the books and how the new versions have been updated."

Win32-Exe-0.05


Win32-Exe-0.05 02/16/2004 09:25 AM

Win32-Exe-0.04


Win32-Exe-0.04 02/15/2004 11:45 PM

Win32-MMF-0.07


Win32-MMF-0.07 02/14/2004 11:39 PM

Win32-Exe-0.03


Win32-Exe-0.03 02/14/2004 11:39 PM

Win32-Exe-0.02


Win32-Exe-0.02 02/14/2004 06:32 PM

Win32-MMF-0.06


Win32-MMF-0.06 02/12/2004 11:37 PM

Win32-Exe-0.01


Win32-Exe-0.01 02/13/2004 10:31 PM

Win32-MMF-0.08


Win32-MMF-0.08 02/16/2004 10:46 PM

Win32-Exe-0.06


Win32-Exe-0.06 02/16/2004 10:46 PM

Win32-MMF-0.09e


Win32-MMF-0.09e 05/29/2004 12:22 AM

Win32-MMF-0.05


Win32-MMF-0.05 02/10/2004 04:50 AM

Win32-Die-0.02


Win32-Die-0.02 12/27/2004 01:22 AM

Win32-Die-0.03


Win32-Die-0.03 12/29/2004 01:18 AM

Win32::API 0.40


Win32::API 0.40 03/13/2003 10:16 AM
dada writes "I've just released version 0.40 of Win32::API, the popular tool to import functions from Win32 DLLs. in a blurb, here's what this version can do: automatically define a Perl sub with the name of the imported API (eg. no more ...

Win32-MSI-DB-1.05


Win32-MSI-DB-1.05 09/16/2004 09:36 AM

Win32-MSI-DB-1.04


Win32-MSI-DB-1.04 04/13/2004 06:05 AM

Cultured Perl: Fun with MP3 and Perl,
Part 1


Cultured Perl: Fun with MP3 and Perl,
Part 1
12/16/2003 12:24 PM
Ted writes "Every self-respecting computer and music fan needs to be able to manipulate MP3s -- the defacto standard for recreational digital music use. In ...

PHP Class 'MySQL Operations' released

The following phrases have been identified by the grok system as matching this entry: perl win32::gui combobox change size

















Also check out: