PHP Scripts and Tools

PHP / MySQL Scripts & Tools


PHP / MySQL Scripts

These scripts work.

They have been sourced from the web, after many (many many) hours of searching and simplifying and adapting,
and I've put them all here in one place to try and help others on the same quest.

An acknowledgement is owed to the ease of use, and the power of PHP, and to the many people who are so adept at writing code, and by backtracking through the web, bookmarks etc I've added the begin source URL wherever possible.

I hope these scripts below help.

Alternate coloured rows in a table
Display 5 rows to a page
2 column display from database
3, 4 or 5, etc column display from database
Mailout from a MySQL database
Create a table in a database and check for errors
PHP popup "email this URL to someone"
PHP with javascript effects like image rollovers, popups
PHP and simple javascript popup on click
Resize and display thumbnails
Resize, display thumbs with javascript popup original large image
Upload images - thumbs and larger images
Simple retrieve records, display result and update MySQL database
Track views of pages and store in MySQL database
Track exits from a page to a URL (record your referrals)
Return day and month as words, eg Tuesday 10 November
Jump to next result in array after querying database
Jump to next result in array after querying database 2
Display MySQL database thumbnail as a link
Several forms on one page simple
Several forms on one page complex
Remove blank space from MYSQL result
Use your server's PHP to mass mailout
Embed JPG in MYSQL database
Retrieve JPG from MYSQL database
Compare records in two tables without using JOIN and then delete orphan records
Website Security Against Hackers: PHP website security quick checksum to let you know if your website is hacked
Website Security Against Hackers: PHP website security checksum, file numbers, and ability to ignore folders in path

 

If you are a purist, or a programmer, or are simply happy finding fault with these offerings, please bear this in mind:
1. The codes work, and are explained carefully enough I hope to be copied and adapted by anyone.
2. The only crticisms that are worth sharing are constructive - then everyone moves to a win/win situation.
3. The incredible help of so many people out there has led to me being able to achieve what I need to.
4. This is just one way of giving it away to keep it <-- as they say :-)

 

PHP / MySQL Tools

SQLion.A fantastic resource if you use any MS data programme like Access or Excel and want to import/export to an online MySQL database. The Exxon website is here.
Download the programme here.