SimplytheBest MySQL Scripts

PHP sample code how to populate a jPlayer playlist from a MySQL database.

This PHP snippet receives the member ID from a form or from a link and retrieves the wanted data from the database, sends the e-mail and ends with one of two options.

To extract a random record from f.e. a MySQL table you can use this sample PHP code to get you going. The snippet uses rand() to generate a random number and LIMIT to select the record from the SQL table.

This PHP snippet shows you how to generate RSS Feeds from MySQL database records on the fly. Easy and straightforward.

PHP snippet to connect to a MySQL database using a file for the connection and an include statement in the page needing to connect.

This is a PHP snippet that shows how to extract the latest additions (What's New) from a MySQL table using PHP.

How to join results from one MySQL table while counting matching records in another table and sorting the result according to the count of the 2nd table using PHP.

A no-frills chainable interface for constructing mutable MySQL queries procedurally in Node.js.