PX : databases : common tasks

parent section: databases (0)

TitleAuthorRating Views Last Modified    
excel/php writing dan zarrella -- 6303 2003-01-21 16:02:51 [ link ]
this php script will dump data from SQL table (MySQL, supply your own SQL query) to a microsoft excel (.xls) file. The Excel file is specified as such by a set of headers, defining content. using php's header() function, also the rows and columns of the excel file are defined by tab and new line chars.
Class QueryGenerator v.1.2 Ed Williams -- 24695 1999-05-06 06:19:34 [ show ]
Generates select query strings for a MySQL (may work on others!) database search.Currently supports case sensitive and fullword match. This class can be easily extended to make a search engine class.
DB Items Search 0.10 Kevin Clevenger 1.0 27482 1999-05-26 01:36:24 [ show ]
A quick and dirty search script for pulling catalog items from a MySQL database. Supports the use of 'And' or 'Or' or 'Not' between keywords
DB Query 2.0 Anil Raj P.S. -- 13401 2000-07-24 11:15:07 [ show ]
This module is for executing queries and fetching the result for MySql Database. This will be a very handy tool for a programmer who knows to write Sql Queries. I hope this will avoid the need of waiting for Back End control pannel to start working with MySql Data Base.
dbdump 1 Andrew -- 3802 2005-06-16 13:46:50 [ show ]
Simple database table dump
Input to WHERE 1.0 David Fox -- 11037 1999-09-27 15:36:38 [ show ]
The b_parse function takes a database field and a query string and returns a WHERE clause for use in a database query. It supports "AND", "NOT" and "OR" keywords in the query string, but also supports quoting of "exact phrases" to match.
makeSQLList() 1.0 Colin Viebrock -- 9628 1998-12-22 12:09:31 [ show ]
Takes an array and returns a string, suitable for inputing in an SQL statement
Next, Previous, and direct links to each page # Matt Whitted -- 13893 2000-02-03 01:16:03 [ show ]
This is the code that I use to get xxx entries per page from a database. It also provides direct page links (i.e. if there are 3 pages of db entries, you will see Prev 1 2 3 Next).
Notes2SQL 0.0.1 Hans Schou -- 13527 1999-07-26 04:20:55 [ show ]
PHP script for converting data from Lotus Notes to SQL statements.
Paginate 1.00 Paul Mann -- 4980 2005-03-25 06:33:41 [ show ]
Pagination function set
PHP INI FIle Class 0.1a Mircho Mirev -- 21903 1999-05-25 05:32:38 [ show ]
A Simpe Ini File Implementation to keep settings in a simple file instead of in a DB.
PHP mailing list 1.0 David Fox -- 20332 1999-10-01 11:24:12 [ show ]
Users sign up on one page w/name and email. Email is checked for auth. Name and email added to Mysql database. "Broadcaster" fills out a form page with header, body, and footer of the email. Header and footer are saved for later. Mail is sent to all users in the database with a personal "Dear (name they entered)" at the top of the email. Sender can upload text, log off, and the script will continue to send out all emails. Sleep function for slowing down send rate. Log file written upon script completion of unsendable emails. Uses php mail() function (sendmail).
Simple PHP Page Counter 1 Brendan McKenzie -- 11608 2000-04-10 21:19:10 [ link ] [ show ]
This is just a simple user counter, just counts the amount of users for however many times someone visits, so it goes up 1 every visit (so it could go up quickly)
Simple Pictures 1.0 Ben O'Neill -- 9938 2000-03-12 15:12:22 [ show ]
Displays an image, so you can use <IMG>.

Comments or questions?
PX is running PHP 5.2.17
Thanks to Miranda Productions for hosting and bandwidth.
Use of any code from PX is at your own risk.