Multiple Tables Snippets


24 December, 2014   

Example shows here how to select from multiple mySQL tables.

11 February, 2013   

File inputs can have an attribute of "multiple" which then allows multiple files to be selected in the file section dialog box.

This is a very handy query that sorts your tables by their physical size in megabytes. Just be sure to edit the query to include the database name.

30 August, 2011   

Calculates the total size of a MySQL database in KB/MB or GB...

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

23 October, 2012   

MySQL code example to optimize all tables of database

16 October, 2012   

MySQL code example to insert multiple records with one query

Take array and create multiple columns, define divisible by value ($divis) from total results then use modulus within the loop. This example shows multiple columns for unordered list items.

Maxscript UI & Graphical RPManager - Control multiple object properties with single object for

30 December, 2010   

Class to back up entire databases and email them out, or individual tables

12 January, 2012   

Example for Dumping a database to HTML tables

20 March, 2013   

ASP code example to block Multiple IP Addresses

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.

This code will show you how to save data from gridview to xml file

15 July, 2013   

This code will be used to bind an xml file to gridview

Cross Browser Vertically and Horizontally Centered Images in CSS without Tables

13 February, 2014   

Just got inspired last night and decided to start a class to get the screen in "blocks" and check which one has changed to update only those.

12 January, 2014   

This is a pretty simple little snippet, but it help understanding how to use relational tables w/in PHP.

By default Symfony displays forms in tables, with each new input being a table row. If you want to display your forms more semantically with fieldsets and lists, Symfony has a list formatter built in. You can tell an individual form to display as a list using the code below.

PHP code to create a human readable string that will look more close to dictionary words, useful for captchas.