SimplytheBest MySQL Scripts

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.

Generate a complete backend from a MySql database programmed with the Silex framework.

Elefant CMS provides a modern, minimalist user interface that eliminates clutter and confusion, with a site editor that gets out of your way and is a pleasure to use.