Using loops in custom pages.

[GriZzm0]

I'm using https://vborg.vbsupport.ru/showthread.php?t=62164 to creat my own custom page. I've changed some parts thoo. I use this code instead.

eval('$HTML = "' . fetch_template($templatename) . '";');
eval('print_output("' . fetch_template($shelltemplatename) . '");');

And I've been playing around a littlebit to learn.

if ($_REQUEST['do'] == 'addrequest') {
	$templatename = 'job_add_request';

	$walle = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "jobs WHERE id = 1");
	eval('$test = "'. $walle[test] .'";');
}

Thats what I came up with. It will print out the field "test" from the row with id 1. What if I want to print out all the rows? How do I use a loop in this code?
I would like the $test variable in the template to print out the result from "SELECT * FROM " . TABLE_PREFIX . "jobs". And perhaps some html around the result itself. Like. <div>$test</div><div>$test</div> etc.. Anyone know how to do that?

[CyberRanger]

You need to use two templates. The first one formats the individual records. The second one outputs the final result.

PHP Code:

    $result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "jobs WHERE 1 = 1 ");
    if ($db->num_rows($result) > 0)
    {
      while ($sub = $db->fetch_array($result))
        {
        exec_switch_bg();// alternate bgcolor
        eval('$wall .= "' . fetch_template('job_add_request_subbit') . '";');
        }
        eval('$wall .= "' . fetch_template('job_add_request') . '";');
    } 


The template 'job_add_request_subbit' would have something like:

<div>$sub['test']</div>

while the template 'job_add_request' would be something like:

My Results

{$wall}

[GriZzm0]

Originally Posted by CyberRanger

You need to use two templates. The first one formats the individual records. The second one outputs the final result.

PHP Code:

    $result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "jobs WHERE 1 = 1 ");
    if ($db->num_rows($result) > 0)
    {
      while ($sub = $db->fetch_array($result))
        {
        exec_switch_bg();// alternate bgcolor
        eval('$wall .= "' . fetch_template('job_add_request_subbit') . '";');
        }
        eval('$wall .= "' . fetch_template('job_add_request') . '";');
    } 


The template 'job_add_request_subbit' would have something like:

<div>$result['test']</div>

while the template 'job_add_request' would be something like:

My Results

{$wall}

Thanks. You made one mistake thoo. It should be $sub in the templates. Not $result.

[CyberRanger]

Originally Posted by GriZzm0

Thanks. You made one mistake thoo. It should be $sub in the templates. Not $result.

Oops! Fixed - that's the danger of copy-paste-edit! :-) Oh ... and the "exec_switch_bg();" should be taken out unless you put the results in a table, etc.

[GriZzm0]

Ok, yet another problem. I would like to print out 6 categories from the databas.

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "jobs WHERE act = 1");

Then I would like to get the content inside the categories.

$resultRequest = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "jobs WHERE act = 0 and category = '". $category['category'] ."' LIMIT 5");

Then I would like to print it out like this.

+-----------------------+-----------------------+-----------------------+
|	Category 1	|	Category 2	|	Category 3	|
+-----------------------+-----------------------+-----------------------+
|	Content in	|	Content in	|	Content in	|
|	Category 1	|	Category 2	|	Category 3	|
+-----------------------+-----------------------+-----------------------+
|	Category 4	|	Category 5	|	Category 6	|
+-----------------------+-----------------------+-----------------------+
|	Content in	|	Content in	|	Content in	|
|	Category 4	|	Category 5	|	Category 6	|
+-----------------------+-----------------------+-----------------------+

Anyone have any idea on how to do that?