Relational 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

12 January, 2012   

Example for Dumping a database to HTML tables

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

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.

31 October, 2011   

Declarations: Option Explicit On Imports System.Data.OleDb

14 December, 2013   

The goal of a reset stylesheet is to reduce browser inconsistencies in things like default line heights, margins and font sizes of headings, and so on.

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.