Related Tables Snippets


12 January, 2014   

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

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

HTML Form using php code that accepts mail related information

12 January, 2012   

Example for Dumping a database to HTML tables

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

24 December, 2014   

Example shows here how to select from multiple mySQL 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

20 June, 2016   

How to find the next X day after a given Date time.

Cross Browser Vertically and Horizontally Centered Images in CSS without Tables

30 December, 2010   

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

09 February, 2011   

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

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.

How to get number of rows in tables of database

07 January, 2016   

The INNER JOIN keyword return rows when there is at least one match in both tables.

24 December, 2013   

This can be used to get ARP mac address from a IP address. Remember that MAC addresses are in ARP tables (volatile), that's why a ping is done first. But i don't know if timing between ping call and ARP call is enough to make sense (of pinging).

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.