<?php

namespace koolreport\querybuilder;

class DB

{

static function table()

{

$params = func_get_args();

$query = new Query();

call_user_func_array(array($query,"from"),$params);

return $query;

}

static function raw($text,$params=null)

{

if($params!=null)

{

foreach($params as $value)

{

if(gettype($value)=="string")

{

$value = DB::escapeString($value);

$text = preg_replace("/\?/", "'$value'", $text, 1);

}

else

{

$text = preg_replace("/\?/", $value, $text, 1);

}

}

}

return array("[{raw}]",$text);

}

static function escapeString($string)

{

$search = array("\\", "\x00", "\n", "\r", "'", '"', "\x1a");

$replace = array("\\\\","\\0","\\n", "\\r", "\'", '\"', "\\Z");

return str_replace($search, $replace, $string);

}

static function call($procedureName,$params=array()) {

$query = new Query();

$query->call($procedureName,$params);

return $query;

}

}