Organize and share your code snippets

07 2010 14

MySQL table optimize table cron job

<?php
/**
 * Runs the query "OPTIMIZE TABLE" on each database and table
 * 
 * @author Marc Steinert <marc@bithub.net>
 * @version $Id$
 * @link http://bithub.net/
 */
 
// MySQL Data
define('SQL_HOST', '127.0.0.1');
define('SQL_USER', 'root');
define('SQL_PASS', 'xxxxxx');
 
 
$link = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS);
$allDbsResult = mysql_query("SHOW DATABASES", $link);
 
while(($databaseRow = mysql_fetch_assoc($allDbsResult))) {
	// Select the found database
	mysql_select_db($databaseRow['Database'], $link);
 
	$alltablesResult = mysql_query("SHOW TABLES", $link);
 
	while (($table = mysql_fetch_assoc($alltablesResult))) {
		foreach ($table as $db => $tablename) {
 
			echo "OPTIMIZE TABLE '".$tablename."'";
 
			if (mysql_query("OPTIMIZE TABLE ".$tablename.""))
			{
				echo " - done'n";
			}
			else
			{
				echo " - failed'n";
			}
	   }
	}
}
die;

This script connects to a MySQL server and runs the command "optimize table" on each database and table on the MySQL server .

Tags

MySQL PHP optimize table

07 2010 07

Simple PHP templating engine with extract

<?php
 
class Template {
 
	private $_bound = array();
 
	private $_file;
 
 
    public function __construct($tplName, $tplDir = '' ) {
        // Define template directory
        if ($tplDir == '' && defined('TEMPLATE_DIR')) {
            $tplDir = TEMPLATE_DIR;
		}
 
        // Add trailing slash
        if (substr( $tplDir, strlen($tplDir) - 1, 1 ) != '/' && $tplDir != '' ) {
            $tplDir .= '/';
		}
 
        // Get templates contents
        $this->_file = $tplDir.$tplName;
    }
 
    public function set($name, $value = null) {
        // Bind associative array
        if(is_array($name)) {
			foreach ($name as $key => $value) {
				$this->_bound[$key] = $value;
            }
        } else {
			// If instance of self then save as reference
            if ($value instanceof self) {
				$this->_bound[$name] = &$value;
			} else {
				$this->_bound[$name] = $value;
			}
        }
    }
 
    public function parse() {
        // Parse templates and bind to variables
        foreach ($this->_bound as $key => $value) {
            if ($value instanceof self) {
				$value = $value->parse();
            }
 
            $$key = $value;
        }
 
        // Start outputbuffering
        ob_start();
 
        // Include template
        if (file_exists($this->_file)) {
            require($this->_file);
        } else {
            return false;
		}
 
        // Stop buffering and get its contents
        return ob_get_clean();
    }
}

Simple template engine in PHP, which uses extract to set variables in the output. Example: $pTemplate = new Template('template.php'); $pTemplate->set('title', 'Here is a title'); echo $pTemplate->parse(); Contents of template.php: <title><?php echo $title;?></title>

Tags

PHP template extract variables templating

06 2010 08

Javascript

anonymous

1

Test if browser is Internet Explorer in Javascript

function isIE {
	var name = 'MSIE';
 
	var agent = navigator.userAgent.toLowerCase();  
 
	return (agent.indexOf(name.toLowerCase()) > - 1);
}

This function tests, if the browser that is viewing the site, is some version of the internet explorer

Tags

internet explorer javascript user agent

<< older

snippetsmania.com

Post and share your code snippets

07 2010 14

Java

0

test

07 2010 07

PHP

1

MySQL table optimize table cron job

Tags

07 2010 07

CSharp

1

Read File Permissions in C#

Tags

07 2010 07

PHP

1

Simple PHP templating engine with extract

Tags

06 2010 08

Javascript

1

Test if browser is Internet Explorer in Javascript

Tags

Most popular snippets

Most
Recent

Post and share your code snippets

07 2010 14

07 2010 07

Tags

07 2010 07

Tags

07 2010 07

Tags

06 2010 08

Tags

Languages

Most popular snippets

MostRecent

Subscribe to RSS

Most
Recent