PX : databases : common tasks

parent section: databases (0)

TitleAuthorRating Views Last Modified    
excel/php writing dan zarrella -- 6273 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 -- 24663 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 27449 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. -- 13369 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 -- 3777 2005-06-16 13:46:50 [ show ]
Simple database table dump
Input to WHERE 1.0 David Fox -- 11005 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 -- 9601 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 -- 13862 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 -- 13496 1999-07-26 04:20:55 [ show ]
PHP script for converting data from Lotus Notes to SQL statements.
Paginate 1.00 Paul Mann -- 4949 2005-03-25 06:33:41 [ show ]
Pagination function set
PHP INI FIle Class 0.1a Mircho Mirev -- 21870 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 -- 20301 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 -- 11577 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 -- 9912 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.