mysql_dump.php

<?php
/* this program will dump the aol_log db table with a specific query.
 * you can specific the lower bound of click of the corresponding url.
 * para
 * -TB table name of the aol_log db
 * -query the specific query
 * -low the lower bound of the click count, default is 10
 * -t time t which affected by the lower bound
 * sample command line:
 * php mysql_dump.php -TB smooth_0.0.set.1.train -query prom\ dresses -t 15 -low 10
 */
include_once("connection.php");
mysql_select_db($database_cnn,$b95119_cnn);

$para = ParameterParser($argc, $argv);

$para = DefaultParameter($para);

$query = sprintf("
	select * from `%s` where `query` = '%s' and `%d` >= %d 
	", $para["TB"], $para["query"], intval($para["t"]), intval($para["low"]));

$result = mysql_query($query);
echo $query."\n";
if (mysql_error()){
	fprintf(STDERR,"query = %s\n%s\n", $para["query"], mysql_error());
}
while ($row = mysql_fetch_row($result)){
	//print_r($row);
	for ($i = 0;$i < count($row); $i++){
		echo $row[$i]."\t";
	}
	echo "\n";
}

function DefaultParameter($para){
	$new_para = array();
	if (!isset($para["low"])) {
		$new_para["low"] = "10";
	}
	if (!isset($para["t"])) {
		$new_para["t"] = "15";
	}
	foreach ($para as $i => $value){
		$new_para[$i] = $para[$i];
	}
	return $new_para;
}

function ParameterParser($argc, $argv){
	$para = array();
	for ($i = 0; $i< $argc - 1; $i++){
		$ret = preg_match("/^-(.*)/", $argv[$i], $match);
		if ($ret == 1){
			$para[$match[1]] = $argv[$i+1];
			$i = $i +1;
		}
	}
	return $para;
}
?>