"Can't connect to database", "201" => "Database not connected", "301" => "SQL statement is empty", "401" => "Second parameter should be array" ); function get_errno(){ return $this->ERR_NO; } function set_errno($str){ $this->ERR_NO = $str; } function get_errmsg(){ return $this->ERR_MSG; } function set_errmsg($str = ""){ $this->ERR_MSG = $str; } function get_isconnected(){ return $this->IS_CONNECTED; } function set_isconnected($boolean){ $this->IS_CONNECTED = $boolean; } // get current SQL statement function get_sql(){ return $this->SQL; } // set SQL statement function set_sql($str){ $this->SQL = $str; } // get database name function get_dbname(){ return $this->DBNAME; } // set database name function set_dbname($str){ $this->DBNAME = $str; } function get_addslashes() { return $this->ADDSLASHES; } function set_addslashes($boolean) { $this->ADDSLASHES = $boolean; } function sql_class($db_host, $db_username, $db_password, $db_name){ $link = @mysql_connect("$db_host", "$db_username", "$db_password"); mysql_set_charset("utf8", $link); if($link){ if(mysql_select_db("$db_name", $link)){ // success to select database $this->set_errmsg(); $this->set_errno(0); $this->set_isconnected(true); $this->set_dbname($db_name); } else{ // fail to select database $this->set_errmsg(mysql_error()); $this->set_errno(102); $this->set_isconnected(false); } } else{ // fail to connect database $this->set_errmsg($this->errmsg[101]); $this->set_errno(101); $this->set_isconnected(false); } } // execute SQL statement function sql_execute(){ if($this->get_errno()){ return false; } if(!$this->get_isconnected()){ $this->set_errmsg($this->errmsg[201]); $this->set_errno(201); return false; } if($this->get_sql() == ""){ $this->set_errmsg($this->errmsg[301]); $this->set_errno(301); return false; } $result = mysql_db_query($this->get_dbname(),$this->get_sql()); if($result) { $this->set_errmsg(); $this->set_errno(0); $this->set_sql(""); return $result; } else{ $this->set_errmsg(mysql_error()); $this->set_errno(302); return false; } } // construct SQL select statement function sql_select($table, $select_fields, $where = "",$order = ""){ $fields = ""; if(gettype($select_fields) == "array") { for($i=0;$i "") { $where_clause = " WHERE $where "; } else { $where_clause = ""; } $this->set_sql("SELECT $fields FROM $table $where_clause $order"); $this->set_errmsg(); $this->set_errno(0); } function sql_insert($table, $insert_fields){ $fields = ""; $values = ""; if(gettype($insert_fields) <> "array") { $this->set_errmsg($this->errmsg[401]); $this->set_errno(401); $this->set_sql(""); return; } $is_magic_quotes = get_magic_quotes_gpc(); while(list($key,$val) = each($insert_fields)){ $fields .= trim($key) . ","; if(!$is_magic_quotes || $this->get_addslashes()){ $values .= "'". addslashes(trim($val)) ."',"; } else{ $values .= "'". trim($val) ."',"; } } $fields = substr($fields,0,strlen($fields) - 1); $values = substr($values,0,strlen($values) - 1); $this->set_sql(sprintf("INSERT INTO %s (%s) VALUES (%s)",$table,$fields,$values)); $this->set_errmsg(); $this->set_errno(0); } function sql_update($table, $update_fields, $where){ if(gettype($update_fields) <> "array") { $this->set_errmsg($this->errmsg[401]); $this->set_errno(401); $this->set_sql(""); return; } $fields = ""; $values = ""; $is_magic_quotes = get_magic_quotes_gpc(); while(list($key,$val) = each($update_fields)){ if(gettype($val) == "array") { $value = trim($val[0]); $operator = trim($val[1]); } else{ $value = trim($val); $operator = ""; } if(!$is_magic_quotes || $this->get_addslashes()){ $value = addslashes($value); } switch($operator) { case "+" : $value = "$key + $value,"; break; case "-" : $value = "$key - $value,"; break; case "*" : $value = "$key * $value,"; break; case "/" : $value = "$key / $value,"; break; default: $value = "'$value',"; } $fields .= trim($key) . " = " . $value ; } $fields = substr($fields,0,strlen($fields) - 1); if(trim($where) <> "") { $this->set_sql(sprintf("UPDATE %s SET %s WHERE (%s)",$table,$fields,$where)); } else{ $this->set_sql(sprintf("UPDATE %s SET %s ",$table,$fields)); } $this->set_errmsg(); $this->set_errno(0); } function sql_delete($table,$where){ if(trim($where) <> "") { $where_clause = " WHERE $where "; } else{ $where_clause = ""; } $this->set_sql("DELETE FROM $table $where_clause"); $this->set_errmsg(); $this->set_errno(0); } function create_table($table_name,$fields,$index = ""){ if(gettype($fields) <> "array") { $this->set_errmsg($this->errmsg[401]); $this->set_errno(401); $this->set_sql(""); return; } $table_fields = ""; while(list($key,$val) = each($fields)){ $type = $val[0]; $other_criteria = $val[1]; $table_fields .= "$key $type $other_criteria,"; } if(gettype($index) == "array"){ for($i=0;$iset_sql("CREATE TABLE $table_name ($table_fields)"); $this->set_errmsg(); $this->set_errno(0); } function sql_fetch_array($result){ return mysql_fetch_array($result); } function sql_num_rows($result){ return mysql_num_rows($result); } } ?> set_win32(); } if(!empty($pathToTemplates)) { $this->set_root($pathToTemplates); } } // end (new) FastTemplate () // ************************************************************ // All templates will be loaded from this "root" directory // Can be changed in mid-process by re-calling with a new // value. function set_root ($root) { $trailer = substr($root,-1); if(!$this->WIN32) { if( (ord($trailer)) != 47 ) { $root = "$root". chr(47); } if(is_dir($root)) { $this->ROOT = $root; } else { $this->ROOT = ""; $this->error("Specified ROOT dir [$root] is not a directory"); } } else { // WIN32 box - no testing if( (ord($trailer)) != 92 ) { $root = "$root" . chr(92); } $this->ROOT = $root; } } // End set_root() // ************************************************************** // Calculates current microtime // I throw this into all my classes for benchmarking purposes // It's not used by anything in this class and can be removed // if you don't need it. function utime () { $time = explode( " ", microtime()); $usec = (double)$time[0]; $sec = (double)$time[1]; return $sec + $usec; } // ************************************************************** // call this function if the OS is WIN32 function set_win32 () { $this->WIN32 = true; } // ************************************************************** // Strict template checking, if true sends warnings to STDOUT when // parsing a template with undefined variable references // Used for tracking down bugs-n-such. Use no_strict() to disable. function strict () { $this->STRICT = true; } // ************************************************************ // Silently discards (removes) undefined variable references // found in templates function no_strict () { $this->STRICT = false; } // ************************************************************ // A quick check of the template file before reading it. // This is -not- a reliable check, mostly due to inconsistencies // in the way PHP determines if a file is readable. function is_safe ($filename) { if(!file_exists($filename)) { $this->error("[$filename] does not exist",0); return false; } return true; } // ************************************************************ // Grabs a template from the root dir and // reads it into a (potentially REALLY) big string function get_template ($template) { if(empty($this->ROOT)) { $this->error("Cannot open template. Root not valid.",1); return false; } $filename = "$this->ROOT"."$template"; $contents = implode("",(@file($filename))); if( (!$contents) or (empty($contents)) ) { $this->error("get_template() failure: [$filename] $php_errormsg",1); } return $contents; } // end get_template // ************************************************************ // Prints the warnings for unresolved variable references // in template files. Used if STRICT is true function show_unknowns ($Line) { $unknown = array(); if (ereg("({[A-Z0-9_]+})",$Line,$unknown)) { $UnkVar = $unknown[1]; if(!(empty($UnkVar))) { @error_log("[FastTemplate] Warning: no value found for variable: $UnkVar ",0); } } } // end show_unknowns() // ************************************************************ // This routine get's called by parse() and does the actual // {VAR} to VALUE conversion within the template. function parse_template ($template, $tpl_array) { while ( list ($key,$val) = each ($tpl_array) ) { if (!(empty($key))) { if(gettype($val) != "string") { settype($val,"string"); } //$template = ereg_replace("{$key}","$val","$template"); $template = str_replace("{".$key."}","$val","$template"); } } if(!$this->STRICT) { // Silently remove anything not already found $template = ereg_replace("\{"."([A-Z0-9_]+)"."\}","",$template); } else { // Warn about unresolved template variables if (ereg("({[A-Z0-9_]+})",$template)) { $unknown = split("\n",$template); while (list ($Element,$Line) = each($unknown) ) { $UnkVar = $Line; if(!(empty($UnkVar))) { $this->show_unknowns($UnkVar); } } } } $template = str_replace("###{###","{",$template); return $template; } // end parse_template(); // ************************************************************ // The meat of the whole class. The magic happens here. function parse ( $ReturnVar, $FileTags ) { $append = false; $this->LAST = $ReturnVar; $this->HANDLE[$ReturnVar] = 1; if (gettype($FileTags) == "array") { unset($this->$ReturnVar); // Clear any previous data while ( list ( $key , $val ) = each ( $FileTags ) ) { if ( (!isset($this->$val)) || (empty($this->$val)) ) { $this->LOADED["$val"] = 1; if(isset($this->DYNAMIC["$val"])) { $this->parse_dynamic($val,$ReturnVar); } else { $fileName = $this->FILELIST["$val"]; $this->$val = $this->get_template($fileName); } } // Array context implies overwrite $this->$ReturnVar = $this->parse_template($this->$val,$this->PARSEVARS); // For recursive calls. $this->assign( array( $ReturnVar => $this->$ReturnVar ) ); } } // end if FileTags is array() else { // FileTags is not an array $val = $FileTags; if( (substr($val,0,1)) == '.' ) { // Append this template to a previous ReturnVar $append = true; $val = substr($val,1); } if ( (!isset($this->$val)) || (empty($this->$val)) ) { $this->LOADED["$val"] = 1; if(isset($this->DYNAMIC["$val"])) { $this->parse_dynamic($val,$ReturnVar); } else { $fileName = $this->FILELIST["$val"]; $this->$val = $this->get_template($fileName); } } if($append) { $this->$ReturnVar .= $this->parse_template($this->$val,$this->PARSEVARS); } else { $this->$ReturnVar = $this->parse_template($this->$val,$this->PARSEVARS); } // For recursive calls. $this->assign(array( $ReturnVar => $this->$ReturnVar) ); } return; } // End parse() // ************************************************************ function FastPrint ( $template = "" ) { if(empty($template)) { $template = $this->LAST; } if( (!(isset($this->$template))) || (empty($this->$template)) ) { $this->error("Nothing parsed, nothing printed",0); return; } else { print $this->$template; } return; } // ************************************************************ function fetch ( $template = "" ) { if(empty($template)) { $template = $this->LAST; } if( (!(isset($this->$template))) || (empty($this->$template)) ) { $this->error("Nothing parsed, nothing printed",0); return ""; } return($this->$template); } // ************************************************************ function define_dynamic ($Macro, $ParentName) { // A dynamic block lives inside another template file. // It will be stripped from the template when parsed // and replaced with the {$Tag}. $this->DYNAMIC["$Macro"] = $ParentName; return true; } // ************************************************************ function parse_dynamic ($Macro,$MacroName) { // The file must already be in memory. $ParentTag = $this->DYNAMIC["$Macro"]; if( (!$this->$ParentTag) or (empty($this->$ParentTag)) ) { $fileName = $this->FILELIST[$ParentTag]; $this->$ParentTag = $this->get_template($fileName); $this->LOADED[$ParentTag] = 1; } if($this->$ParentTag) { $template = $this->$ParentTag; $DataArray = split("\n",$template); $newMacro = ""; $newParent = ""; $outside = true; $start = false; $end = false; while ( list ($lineNum,$lineData) = each ($DataArray) ) { $lineTest = trim($lineData); if("" == "$lineTest" ) { $start = true; $end = false; $outside = false; } if("" == "$lineTest" ) { $start = false; $end = true; $outside = true; } if( (!$outside) and (!$start) and (!$end) ) { $newMacro .= "$lineData\n"; // Restore linebreaks } if( ($outside) and (!$start) and (!$end) ) { $newParent .= "$lineData\n"; // Restore linebreaks } if($end) { $newParent .= "{".$MacroName."}\n"; } // Next line please if($end) { $end = false; } if($start) { $start = false; } } // end While $this->$Macro = $newMacro; $this->$ParentTag = $newParent; return true; } // $ParentTag NOT loaded - MAJOR oopsie else { @error_log("ParentTag: [$ParentTag] not loaded!",0); $this->error("ParentTag: [$ParentTag] not loaded!",0); } return false; } // ************************************************************ // Strips a DYNAMIC BLOCK from a template. function clear_dynamic ($Macro="") { if(empty($Macro)) { return false; } // The file must already be in memory. $ParentTag = $this->DYNAMIC["$Macro"]; if( (!$this->$ParentTag) or (empty($this->$ParentTag)) ) { $fileName = $this->FILELIST[$ParentTag]; $this->$ParentTag = $this->get_template($fileName); $this->LOADED[$ParentTag] = 1; } if($this->$ParentTag) { $template = $this->$ParentTag; $DataArray = split("\n",$template); $newParent = ""; $outside = true; $start = false; $end = false; while ( list ($lineNum,$lineData) = each ($DataArray) ) { $lineTest = trim($lineData); if("" == "$lineTest" ) { $start = true; $end = false; $outside = false; } if("" == "$lineTest" ) { $start = false; $end = true; $outside = true; } if( ($outside) and (!$start) and (!$end) ) { $newParent .= "$lineData\n"; // Restore linebreaks } // Next line please if($end) { $end = false; } if($start) { $start = false; } } // end While $this->$ParentTag = $newParent; return true; } // $ParentTag NOT loaded - MAJOR oopsie else { @error_log("ParentTag: [$ParentTag] not loaded!",0); $this->error("ParentTag: [$ParentTag] not loaded!",0); } return false; } // ************************************************************ function define ($fileList) { while ( list ($FileTag,$FileName) = each ($fileList) ) { $this->FILELIST["$FileTag"] = $FileName; } return true; } // ************************************************************ function clear_parse ( $ReturnVar = "") { $this->clear($ReturnVar); } // ************************************************************ function clear ( $ReturnVar = "" ) { // Clears out hash created by call to parse() if(!empty($ReturnVar)) { if( (gettype($ReturnVar)) != "array") { unset($this->$ReturnVar); return; } else { while ( list ($key,$val) = each ($ReturnVar) ) { unset($this->$val); } return; } } // Empty - clear all of them while ( list ( $key,$val) = each ($this->HANDLE) ) { $KEY = $key; unset($this->$KEY); } return; } // end clear() // ************************************************************ function clear_all () { $this->clear(); $this->clear_assign(); $this->clear_define(); $this->clear_tpl(); return; } // end clear_all // ************************************************************ function clear_tpl ($fileHandle = "") { if(empty($this->LOADED)) { // Nothing loaded, nothing to clear return true; } if(empty($fileHandle)) { // Clear ALL fileHandles while ( list ($key, $val) = each ($this->LOADED) ) { unset($this->$key); } unset($this->LOADED); return true; } else { if( (gettype($fileHandle)) != "array") { if( (isset($this->$fileHandle)) || (!empty($this->$fileHandle)) ) { unset($this->LOADED[$fileHandle]); unset($this->$fileHandle); return true; } } else { while ( list ($Key, $Val) = each ($fileHandle) ) { unset($this->LOADED[$Key]); unset($this->$Key); } return true; } } return false; } // end clear_tpl // ************************************************************ function clear_define ( $FileTag = "" ) { if(empty($FileTag)) { unset($this->FILELIST); return; } if( (gettype($Files)) != "array") { unset($this->FILELIST[$FileTag]); return; } else { while ( list ( $Tag, $Val) = each ($FileTag) ) { unset($this->FILELIST[$Tag]); } return; } } // ************************************************************ // Aliased function - used for compatibility with CGI::FastTemplate // function clear_parse () // { // $this->clear_assign(); // } // ************************************************************ // Clears all variables set by assign() function clear_assign () { if(!(empty($this->PARSEVARS))) { while(list($Ref,$Val) = each ($this->PARSEVARS) ) { unset($this->PARSEVARS["$Ref"]); } } } // ************************************************************ function clear_href ($href) { if(!empty($href)) { if( (gettype($href)) != "array") { unset($this->PARSEVARS[$href]); return; } else { while (list ($Ref,$val) = each ($href) ) { unset($this->PARSEVARS[$Ref]); } return; } } else { // Empty - clear them all $this->clear_assign(); } return; } // ************************************************************ function assign ($tpl_array, $trailer="") { if(gettype($tpl_array) == "array") { while ( list ($key,$val) = each ($tpl_array) ) { if (!(empty($key))) { // Empty values are allowed // Empty Keys are NOT $val = str_replace("{","###{###",$val); $this->PARSEVARS["$key"] = $val; } } } else { // Empty values are allowed in non-array context now. if (!empty($tpl_array)) { $this->PARSEVARS["$tpl_array"] = $trailer; } } } // ************************************************************ // Return the value of an assigned variable. // Christian Brandel cbrandel@gmx.de function get_assigned($tpl_name = "") { if(empty($tpl_name)) { return false; } if(isset($this->PARSEVARS["$tpl_name"])) { return ($this->PARSEVARS["$tpl_name"]); } else { return false; } } // ************************************************************ function error ($errorMsg, $die = 0) { $this->ERROR = $errorMsg; echo "ERROR: $this->ERROR
\n"; if ($die == 1) { exit; } return; } // end error() // ******************************************** function get_file_name_from_template($template_name) { return $this->FILELIST[$template_name]; } // ************************************************************ // ************************************************************ } // End class.FastTemplate.php3 ?>