Caching multiple templates into an array...

Big_Wilhelm

Hello, I am trying to come up with a way of retrieving multiple templates in a comma delimitted string using only one query.

Something like this:

$temps = getTemplates("1", "base:main,index:welcome,index:footer");

Where "base:main", "index:welcome" and "index:footer" are all names of records stored in the template table.

What I want this to do is explode the second parameter of the getTemplates function into an array and build a query string that will retrieve the templates using only one query.

Then return the result so I can call up templates like so:

$temps['base:main'];

Since they are cached into an array as a result of the function. Any guidance or techniques would be helpful! Thx!

Weedpacket

explode() on the comma, wrap a "fieldname='[whatever]'" around each element, then join() them with an " OR "? Maybe wrap that in a pair of ( ), so that you can follow it with suitable AND conditions, and shove the whole lot into your WHERE clause.

Big_Wilhelm

You mean something like this:

function getTemplates($theme, $templates){

$templates = str_replace(',', '\',\'', $templates);

$limit = count(explode(",", $templates));

for($i = 0; $i < $limit; $i++){

	$string .= "OR tmp_code = '{$templates[$i]}' ";		

}

$q = mysql_query("SELECT SQL_BIG_RESULT * FROM tbltemplates WHERE tmp_theme = '{$theme}' {$string} LIMIT {$limit}") or die(mysql_error());

$r = mysql_fetch_array($q);

return $r;
}

It only fetches the last template specified. Right now I'm using the one below, it works great, but I uses too many queries:

function getTemplates($theme, $temps=array()){

foreach(explode(",",  $temps) as $tempname){

	$q = mysql_query("SELECT tmp_code, tmp_output, tmp_theme FROM tbltemplates WHERE tmp_theme = '{$theme}' AND tmp_code = '{$tempname}'");

	$r = mysql_fetch_array($q);

	$r['tmp_output'] = stripslashes($r['tmp_output']);

	$cache[$tempname] = $r['tmp_output'];

}

   return $cache;

}

Big_Wilhelm

n/m I got it! I totally cut execution time over half of what it was before!

function getTemplates($theme, $temps=array()){

$var = explode(",",  $temps);

$limit = count($var);

$includes = str_replace(',', '\',\'', $temps);

$q = query("SELECT tmp_code, tmp_output, tmp_theme FROM tbltemplates WHERE tmp_theme = '{$theme}' AND tmp_code IN ('{$includes}') LIMIT {$limit}");

while($r = mysql_fetch_array($q)){

	$r['tmp_output'] = stripslashes($r['tmp_output']);

	$cache[$r['tmp_code']] = $r['tmp_output'];

}

   return $cache;

}