JavaScript, PHP, Ajax, Mac, iPhone and Talk Talk Talk

/**
* parse mysql dump sql
*
* created by 행복한고니 (gonom9@gmail.com)
*/
function parse_sql_dump($str)
{
	$data = $cols = array();
	$in_table = $in_quote = false;
	$lines = explode("\n", $str);
 
	foreach ($lines as $line) {
		$line = trim($line);
		if (!$line) continue;
		if (substr($line,0,2) == '--') continue;
 
		if ($in_table === false) {
			if (preg_match('/^CREATE TABLE `?([a-z0-9_]+)`?/i', $line, $match)) {
				$table = $match[1];
				$data[$table] = array();
				$cols[$table] = array();
				$in_table = true;
				continue;
			} elseif (preg_match('/^INSERT INTO ([a-zA-Z0-9_]+) VALUES \(/i', $line, $match)) {
				$table = $match[1];
				$line  = substr($line, strlen($match[0]));
 
				preg_match_all('/\'[^\'\\\\]*(?:\\\\.[^\'\\\\]*)*\'|[0-9\.]+|NULL/i', $line, $match);
 
				$arr = array();
				foreach ($match[0] as $key=>$value) {
					if (strtolower($value) == 'NULL') $value = 'NULL';
						$arr[$cols[$table][$key]] = $value;
					}
					$data[$table][] = $arr;
				}
			} elseif ($in_table) {
				if ($line{0} == ')') { $in_table = false; continue; }
				if (preg_match('/`?([a-zA-Z0-9_]+)`? ((tiny|small|big)?int|(var)?char|date(time)?|time(stamp)?|enum|set|(tiny|medium|long)?(blob|text)|year|float|double)/i', $line, $match)) {
					$cols[$table][] = $match[1];
				}
				continue;
			}
	}
	return $data;
}