Page 2 - help : looping for template

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

#16

October 22nd, 2005, 06:03 PM

clericvash

Join Date: Apr 2007

Location: plymouth, devon, uk

Posts: 14

Time spent in forums: < 1 sec
Reputation Power: 0

RE: help : looping for template

I don't see where it says to actually use the block though?

Surly you need to say something like use_block('song_list') or else it wont appear?

#17

October 22nd, 2005, 09:15 PM

BassFace

Join Date: Apr 2007

Location: Denver, Colorado USA

Posts: 9

Time spent in forums: < 1 sec
Reputation Power: 0

RE: help : looping for template

It's in there - where it says $page->replace_block_tags(etc....);

php Code:

Original - php Code

 
// query for the songs loop and call to the replace_block_tags function for this block only
$songs_sql = "SELECT * FROM album_info WHERE product_id = '$pid' ORDER BY track_number";
$songs_query = mysql_query($songs_sql);
 
$page->replace_block_tags("songs_block", $songs_query);
 
mysql_free_result($songs_query);
 
// send array of non looping query results to the template for display
$page->replace_tags(array(
    'band_id' => $product['band_id'],
    'band_name' => strtoupper($product['band_name']),
    'product_cat' => strtoupper($product['product_cat']),
    'product_title' => strtoupper($product['product_title']),
    'image_path' => $product['band_name']."/images/",    
    'album_cover' => $product['product_img'],
    'band_photo' => $product['band_photo'] ,
    'footer' => 'footer.php'
    )); 
 
// output the results = send to browser!
$page->output();
?>

#18

November 3rd, 2005, 01:01 AM

BassFace

Join Date: Apr 2007

Location: Denver, Colorado USA

Posts: 9

Time spent in forums: < 1 sec
Reputation Power: 0

RE: help : looping for template

After living with this class for a few weeks, I've run into a few issues and have found (as far as I know) solutions, so I thought I'd share the new code here.
I also cleaned up the code a little bit, and added alternating background colors for table rows output in the looped blocks. (I'll explain it at the bottom...)

Problems found:
PARSE ISSUE
If any tag data was a file name - even a file you didn't want parsed, like an image imagefile.jpg, the template engine would attempt to parse the file and it would break.
Solved by allowing only files with extension php to be sent to the parse function.

REGEX ISSUE
Again with file names, but in the template file this time, not in the tags. Any dot (.) in the looping sections in the template file would break the preg_match() function used to pull the parts of the template that would be sent to the block looping function. So if you had a link, like nextpage.php, within the section to be looped, it would break. Changed the regular expression used from ([^.]+) to ([^*]+) and it seems to work now.

Here's the new template class file in it's entirety:

php Code:

Original - php Code

<?php
class Page{
  var $page;

function Page($template = "/templates/template.tpl") {
		$this->page = (is_file($template)) ? file_get_contents($template) : die("Template file $template not found."); 
	}

function parse($file) {
  	clearstatcache(); // clears info gathered from -- $path_parts = pathinfo($data); -- in replace_block_tags function
	  ob_start();
    include($file);
    $buffer = ob_get_clean();
    return $buffer;
  }

function get_block($block){
    preg_match ('#([^*]+)#',$this->page,$this->return);
    $code = str_replace ('', "", $this->return[0]);
    $code = str_replace ('', "", $code);
    return $code;
	}

function output() {
    print $this->page;
  }

}
?>

 
<?php
class Page{
  var $page;
 
  function Page($template = "/templates/template.tpl") {
        $this->page = (is_file($template)) ? file_get_contents($template) : die("Template file $template not found."); 
    }
 
  function parse($file) {
    clearstatcache(); // clears info gathered from -- $path_parts = pathinfo($data); -- in replace_block_tags function
      ob_start();
    include($file);
    $buffer = ob_get_clean();
    return $buffer;
  }
 
  function replace_tags($tags = array()) {
    foreach ($tags as $tag => $data) {
      $path_parts = pathinfo($data);
            $ext = $path_parts['extension'];
            $data = ( is_file($data) &&  $ext == 'php') ? $this->parse($data) : $data;
      $this->page = str_replace("{" . $tag . "}", $data, $this->page);
      }
    }
 
  function get_block($block){
    preg_match ('#<!-- START '. $block . ' -->([^*]+)<!-- END '. $block . ' -->#',$this->page,$this->return);
    $code = str_replace ('<!-- START '. $block . ' -->', "", $this->return[0]);
    $code = str_replace ('<!-- END '  . $block . ' -->', "", $code);
    return $code;
    }
 
function replace_block_tags($blockname, $query, $alt = false, $bg1 = "#EFEFEF", $bg2 = "#FEFEFE") {
    $this->blockcode = $this->get_block($blockname);
    while ($tags = mysql_fetch_assoc($query)) {
        // if $alt is set to true, alternate row background color - use like <tr bgcolor="{bgcolor}">, else leave bgcolor empty
        if($alt == true) {
            if ($this->bgcolor == $bg1): 
                    $tags['bgcolor']=$bg2; $this->bgcolor=$bg2; 
                else: 
                    $tags['bgcolor']=$bg1; $this->bgcolor=$bg1; 
                endif;
        } else {
            $tags['bgcolor']='';
        }
        $block = $this->blockcode;
            foreach ($tags as $tag => $data) {
                $path_parts = pathinfo($data);
                $ext = $path_parts['extension'];
                $data = ( is_file($data) &&  $ext == 'php') ? $this->parse($data) : $data;
                $block = str_replace("{" . $tag . "}", $data, $block);
        } 
      $this->block_page .= $block ."n";
        }
    $this->page = str_replace($this->return[0], $this->block_page, $this->page);
    unset($this->block_page); 
}
 
  function output() {
    print $this->page;
  }
 
}
?>

Now for the replace_block_tags additions:
It uses this format:

php Code:

Original - php Code
$page->replace_block_tags("block to be looped", $db_query_for_loop_data, alternate_bg true/false, $bgcolor1,$bgcolor2)

$page->replace_block_tags("block to be looped", $db_query_for_loop_data, alternate_bg true/false, $bgcolor1,$bgcolor2)

You can set default bg colors to alternate right here in the class, just replace

php Code:

Original - php Code
$bg1 = "#EFEFEF", $bg2 = "#FEFEFE"

$bg1 = "#EFEFEF", $bg2 = "#FEFEFE"

with the colors you want.
To make it not alternate, just call it like before, with the first 2 parameters only:

php Code:

Original - php Code
$page->replace_block_tags("band_block", $band_list_query);

$page->replace_block_tags("band_block", $band_list_query);

To make it alternate with the default colors, do it with the first 3 parameters:

php Code:

Original - php Code
$page->replace_block_tags("band_block", $band_list_query, true);

$page->replace_block_tags("band_block", $band_list_query, true);

To have it alternate and use custom colors, send it all 5 parameters:

php Code:

Original - php Code
$page->replace_block_tags("band_block", $band_list_query, true, "red", "blue");

$page->replace_block_tags("band_block", $band_list_query, true, "red", "blue");

php Code:

Original - php Code
$page->replace_block_tags("band_block", $band_list_query, true, "#FF0000", "#0000FF");

$page->replace_block_tags("band_block", $band_list_query, true, "#FF0000", "#0000FF");

Hope someone else finds this useful, I'm pretty satisfied with it now, and it's still pretty simple to use.

#19

November 3rd, 2005, 09:55 AM

PlaGuE

Join Date: Apr 2007

Location: Edmonton Alberta Canada

Posts: 16

Time spent in forums: < 1 sec
Reputation Power: 0

RE: help : looping for template

i know this topic is probably very old.. and i may be bumping it... but, i need help. And any help is apperciated.

im using

php Code:

Original - php Code
$sql = "SELECT * FROM members"; $query = mysql_query($sql); $count = mysql_count_rows($query); $page->replace_block_tags("members",$query,$count);

$sql = "SELECT * FROM members";
$query = mysql_query($sql);
$count = mysql_count_rows($query);
 
$page->replace_block_tags("members",$query,$count);

modified from

php Code:

Original - php Code
$sql = "SELECT * FROM `poll_choices` WHERE `poll_id` = '" . $poll_info['id'] . "'"; $query = mysql_query($sql); $count = mysql_count_rows($query); $tp->replace_block_tags("choices",$query,$count);

 
$sql = "SELECT * FROM `poll_choices` WHERE `poll_id` = '" . $poll_info['id'] . "'";
$query = mysql_query($sql);
$count = mysql_count_rows($query);
 
$tp->replace_block_tags("choices",$query,$count);

And

php Code:

Original - php Code

 
<?php
class Page{
  var $page;
 
  function Page($template = "index.tpl") {
    if (is_file($template))
      $this->page = implode("", file($template));
    else
      die("Template file $template not found.");
  }
 
  function parse($file) {
    ob_start();
    include($file);
    $buffer = ob_get_contents();
    ob_end_clean();
    return $buffer;
  }
 
  function replace_tags($tags = array()) {
    if (sizeof($tags) > 0)
      foreach ($tags as $tag => $data) {
        $data = (is_file($data)) ? $this->parse($data) : $data;