Bombay Stock Exchange (BSE) Index

busy with joomla multisite project

now days im busy with joomla multi site project at work, customizing all core joomla components, modules n mambots (plugins) to control all sites with a single joomla installation and single control panel.

In past days we have workout a page impression sharing php mysql script to share page impression with many user types, we developed this script mainly for google adsense but you can use it for any purpose to sharing page impression to user types; also do some hands on Cake PHP exploring it.

And one sad news since i write here again our cute doggy "Honey" passes away on Saturday 18 August, i will put a pic of her here soon, a really wise doggy.

PHP function to backup MySql Database

Yesterday i try to find a PHP script to backup MySql Database, i search a lot but finds only few, here a good one script i find it, hope this help someone to, here is it...

function mysqlbackup($host,$dbname, $uid, $pwd, $output, $structure_only)
{

//this function creates a text file (or output to a HTTP connection), that when parsed through MYSQL's telnet client, will re-create the entire database

//Parameters:
// $host: usually "localhost" but depends on where the MySQL database engine is mounted
// $dbname : The MySQL database name
// $uid : the database's username (not your account's), leave blank if none is required
// $pwd : the database's password
// $output : this is the complete filespec for the output text file, or if you want the result SQL to be sent back to the browser, leave blank.
// $structure_only : set this to true if you want just the schema of the database (not the actual data) to be output.

// **************
// IMPORTANT: If you use this function, for personal or commercial use, AND you feel an overwhelming sense of gratitude that someone actually took the time and wrote it,
// immediately go to your paypal account and send me $10 with a small comment of how and how much it helped! Set the payment recipient to woodystanford@yahoo.com .
// **************

if (strval($output)!="") $fptr=fopen($output,"w"); else $fptr=false;

//connect to MySQL database
$con=mysql_connect("localhost",$uid, $pwd);
$db=mysql_select_db($dbname,$con);

//open back-up file ( or no file for browser output)

//set up database
out($fptr, "create database $dbname;\n\n");

//enumerate tables
$res=mysql_list_tables($dbname);
$nt=mysql_num_rows($res);

for ($a=0;$a<$nt;$a++)
{
$row=mysql_fetch_row($res);
$tablename=$row[0];

//start building the table creation query
$sql="create table $tablename\n(\n";

$res2=mysql_query("select * from $tablename",$con);
$nf=mysql_num_fields($res2);
$nr=mysql_num_rows($res2);

$fl="";

//parse the field info first
for ($b=0;$b<$nf;$b++)
{
$fn=mysql_field_name($res2,$b);
$ft=mysql_fieldtype($res2,$b);
$fs=mysql_field_len($res2,$b);
$ff=mysql_field_flags($res2,$b);

$sql.=" $fn ";

$is_numeric=false;
switch(strtolower($ft))
{
case "int":
$sql.="int";
$is_numeric=true;
break;

case "blob":
$sql.="text";
$is_numeric=false;
break;

case "real":
$sql.="real";
$is_numeric=true;
break;

case "string":
$sql.="char($fs)";
$is_numeric=false;
break;

case "unknown":
switch(intval($fs))
{
case 4: //little weakness here...there is no way (thru the PHP/MySQL interface) to tell the difference between a tinyint and a year field type
$sql.="tinyint";
$is_numeric=true;
break;

default: //we could get a little more optimzation here! (i.e. check for medium ints, etc.)
$sql.="int";
$is_numeric=true;
break;
}
break;

case "timestamp":
$sql.="timestamp";
$is_numeric=true;
break;

case "date":
$sql.="date";
$is_numeric=false;
break;

case "datetime":
$sql.="datetime";
$is_numeric=false;
break;

case "time":
$sql.="time";
$is_numeric=false;
break;

default: //future support for field types that are not recognized (hopefully this will work without need for future modification)
$sql.=$ft;
$is_numeric=true; //I'm assuming new field types will follow SQL numeric syntax..this is where this support will breakdown
break;
}

//VERY, VERY IMPORTANT!!! Don't forget to append the flags onto the end of the field creator

if (strpos($ff,"unsigned")!=false)
{
//timestamps are a little screwy so we test for them
if ($ft!="timestamp") $sql.=" unsigned";
}

if (strpos($ff,"zerofill")!=false)
{
//timestamps are a little screwy so we test for them
if ($ft!="timestamp") $sql.=" zerofill";
}

if (strpos($ff,"auto_increment")!=false) $sql.=" auto_increment";
if (strpos($ff,"not_null")!=false) $sql.=" not null";
if (strpos($ff,"primary_key")!=false) $sql.=" primary key";

//End of field flags

if ($b<$nf-1)
{
$sql.=",\n";
$fl.=$fn.", ";
}
else
{
$sql.="\n);\n\n";
$fl.=$fn;
}

//we need some of the info generated in this loop later in the algorythm...save what we need to arrays
$fna[$b]=$fn;
$ina[$b]=$is_numeric;

}

out($fptr,$sql);

if ($structure_only!=true)
{
//parse out the table's data and generate the SQL INSERT statements in order to replicate the data itself...
for ($c=0;$c<$nr;$c++)
{
$sql="insert into $tablename ($fl) values (";

$row=mysql_fetch_row($res2);

for ($d=0;$d<$nf;$d++)
{
$data=strval($row[$d]);

if ($ina[$d]==true)
$sql.= intval($data);
else
$sql.="\"".mysql_escape_string($data)."\"";

if ($d<($nf-1)) $sql.=", ";

}

$sql.=");\n";

out($fptr,$sql);

}

out($fptr,"\n\n");

}

mysql_free_result($res2);

}

if ($fptr!=false) fclose($fptr);
return 0;

}

function out($fptr,$s)
{
if ($fptr==false) echo("$s"); else fputs($fptr,$s);
}
?>

Copy the above function into a file called "mysqlbackup.h" and invoke it with the following script:

include("mysqlbackup.h");
mysqlbackup("localhost","yerdatabase","yerusername","yerpassword","/home/sites/site90/web/backup/sqldata.txt", true);
?>

The database's structure has been saved to "/home/sites/site90/web/backup/sqldata.txt" FTP download it at your convenience.

Joomla World diping in n out :)

its takes me 11 days to write again here, busy now days with some new cool projects, one on Joomla and today is a special day again for me and ashish, my friend, a cool guy, we find our way in Joomla, a way to add multi domain functionality in Joomla Content Component, Cheers... soon coming back with some cool work.

07-07-07 or 007

today is a special date, i just think to start my blog on this very special day, i will try to manage this blog on regular intervals, lets see and 07-07-07 or 007 just a joke which follow this thought automatically, here we go...