[RESOLVED] help with .php vs .tpl

planethax

I need help splitting one .php page up into a .tpl and .php

My current .php

<?php

$tpl = new template;
$tpl -> Load("!theme/{$GLOBALS["THEME"]}/templates/nascar/nascars.tpl");
$tpl -> GetObjects();


if (isset($_SESSION["id"])) $tpl->Zone("userStatus", "user");

	else $tpl->Zone("userStatus", "guest");

if (isset($GLOBALS["LOGIN_FAIL_TYPE"])) {
	if ($GLOBALS["LOGIN_FAIL_TYPE"] == "e.password") $loginError = $GLOBALS["OBJ"]["loginError.password"];
	elseif ($GLOBALS["LOGIN_FAIL_TYPE"] == "e.user") $loginError = $GLOBALS["OBJ"]["loginError.username"];
	elseif ($GLOBALS["LOGIN_FAIL_TYPE"] == "e.bruteforce") $loginError = $GLOBALS["OBJ"]["loginError.bruteforce"];
	elseif ($GLOBALS["LOGIN_FAIL_TYPE"] == "e.active") $loginError = $GLOBALS["OBJ"]["loginError.active"];
}

$tpl -> AssignArray(array(
	"login.failMessage" => (isset($loginError)?$loginError:NULL)
));


$tpl -> Flush();

?>

My current .tpl

<!-- header --><!-- /header -->

[COLOR="Red"]Need to insert my table here[/COLOR]

<!-- footer --><!-- /footer -->

Now, the page with the table (I guess some goes in php and some in tpl, but have not figured out how yet as I get a blank page when trying


<?php
include_once('db_conn.php');
$query = "SELECT * FROM `nascar_standings` ORDER BY `rank` ASC";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());

$standings = array();
while($row = mysql_fetch_assoc($result))
{
    $standings[$row['rank']] = $row;
}

?>

<head>
    <title>Nascar Standings</title>



<link href="global.css" rel="stylesheet" type="text/css" />
</head>
<body>
   <table cellspacing="0" border="0" id="DataTable" class="DataTable">
				<tr id="TopTR" class="TopTR">
					<td><img src="pixel.gif" width="24" height="1" alt=""></td>
					<td><img src="pixel.gif" width="26" height="1" alt=""></td>
					<td><img src="pixel.gif" width="124" height="1" alt=""></td>
					<td><img src="pixel.gif" width="44" height="1" alt=""></td>
					<td><img src="pixel.gif" width="44" height="1" alt=""></td>
					<td><img src="pixel.gif" width="44" height="1" alt=""></td>

					<td><img src="pixel.gif" width="38" height="1" alt=""></td>
					<td><img src="pixel.gif" width="34" height="1" alt=""></td>
					<td><img src="pixel.gif" width="34" height="1" alt=""></td>
					<td><img src="pixel.gif" width="40" height="1" alt=""></td>
                    <td><img src="pixel.gif" width="25" height="1" alt=""></td>
					<td id="sLast" class="sLast"><img src="pixel.gif" width="61" height="1" alt=""></td>						
				</tr>
    			<tr>

                <th>Rank</th>
                <th>+/-</th>
                <th>Driver</th>
                <th>Total Points</th>
                <th>Behind</th>
                <th>Starts</th>
                <th>Poles</th>
                <th>Wins</th>
                <th>Top 5</th>
                <th>Top 10</th>
                <th>DNF</th>
                <th class="Last">Winnings</th>
            </tr>
        </thead>
        <tbody id="DataBody">
            <?php
            foreach($standings as $rank => $standing)
            {
                ?>
            <tr class="<?php echo ($standing['in_contention'] == 1 ? 'contendor' : null); ?>">
                <td><?php echo $rank; ?></td>
                <td><?php echo $standing['rank_delta']; ?></td>
                <td><?php echo $standing['driver']; ?></td>
                <td><?php echo $standing['points']; ?></td>
                <td><?php echo $standing['behind']; ?></td>
                <td><?php echo $standing['starts']; ?></td>
                <td><?php echo $standing['poles']; ?></td>
                <td><?php echo $standing['wins']; ?></td>
                <td><?php echo $standing['top5']; ?></td>
                <td><?php echo $standing['top10']; ?></td>
                <td><?php echo $standing['dnf']; ?></td>
                <td><?php echo $standing['winnings']; ?></td>
            </tr>
                <?php
            }
            ?>
        </tbody>
    </table>
    <hr />

planethax

I am thinkng it must be something like this in the .php

$tpl -> Zone("standings", "enabled");
	<?php
                foreach($standings as $rank => $standing)
                {
                    ?>
                <tr class="<?php echo ($standing['in_contention'] == 1 ? 'contendor' : null); ?>">
                    <td><?php echo $rank; ?></td>
                    <td><?php echo $standing['rank_delta']; ?></td>
                    <td><?php echo $standing['driver']; ?></td>
                    <td><?php echo $standing['points']; ?></td>
                    <td><?php echo $standing['behind']; ?></td>
                    <td><?php echo $standing['starts']; ?></td>
                    <td><?php echo $standing['poles']; ?></td>
                    <td><?php echo $standing['wins']; ?></td>
                    <td><?php echo $standing['top5']; ?></td>
                    <td><?php echo $standing['top10']; ?></td>
                    <td><?php echo $standing['dnf']; ?></td>
                    <td><?php echo $standing['winnings']; ?></td>
                </tr>
                    <?php
                }
                ?>

and
<zone standing>
</zone standing>
in tpl?

But I just can't find the correct combo?

NogDog

Without knowing how your templating system works, I don't know the answer. If you are using a particular 3rd-party templating system, you might want to let us know, in case someone else here is familiar with it.

planethax

it is phpizabi social networking
however its not very popular.
I am still trying the ol' trial and error method lol.

Thanx for reply

planethax

Well I found this article
http://www.phpizabi.net/index.php?L=support.kbarticle&id=3227
which said

In home.tpl, add; {my.tag}

In home.php add; $tpl -> AssignArray(array('my.tag' => 'This is the text that will appear'));

Assignments ($tpl -> Assign...) should be added BEFORE any Flush ($tpl -> Flush()) order in the PHP files.

so I put

$tpl -> AssignArray(array('standing' => '<?php
                foreach($standings as $rank => $standing)
                {
                    ?>
                <tr class="<?php echo ($standing['in_contention'] == 1 ? 'contendor' : null); ?>">
                    <td><?php echo $rank; ?></td>
                    <td><?php echo $standing['rank_delta']; ?></td>
                    <td><?php echo $standing['driver']; ?></td>
                    <td><?php echo $standing['points']; ?></td>
                    <td><?php echo $standing['behind']; ?></td>
                    <td><?php echo $standing['starts']; ?></td>
                    <td><?php echo $standing['poles']; ?></td>
                    <td><?php echo $standing['wins']; ?></td>
                    <td><?php echo $standing['top5']; ?></td>
                    <td><?php echo $standing['top10']; ?></td>
                    <td><?php echo $standing['dnf']; ?></td>
                    <td><?php echo $standing['winnings']; ?></td>
                </tr>
                    <?php
                }
                ?>'));

Before


$tpl -> Flush();

?>

in the php ( and {standing} in tpl) but that code in php blanks out that section.

Can anyone one see what I have done wrong?

planethax

if I have

$tpl -> AssignArray(array('standing' => 'my text goes here'));

all sections print and has "my text goes here"

but if I have

$tpl -> AssignArray(array('standing' => '<?php
                foreach($standings as $rank => $standing)
                {
                    ?>
                <tr class="<?php echo ($standing['in_contention'] == 1 ? 'contendor' : null); ?>">
                    <td><?php echo $rank; ?></td>
                    <td><?php echo $standing['rank_delta']; ?></td>
                    <td><?php echo $standing['driver']; ?></td>
                    <td><?php echo $standing['points']; ?></td>
                    <td><?php echo $standing['behind']; ?></td>
                    <td><?php echo $standing['starts']; ?></td>
                    <td><?php echo $standing['poles']; ?></td>
                    <td><?php echo $standing['wins']; ?></td>
                    <td><?php echo $standing['top5']; ?></td>
                    <td><?php echo $standing['top10']; ?></td>
                    <td><?php echo $standing['dnf']; ?></td>
                    <td><?php echo $standing['winnings']; ?></td>
                </tr>
                    <?php
                }
                ?>'));

then the tpl is blank, so it must be the structure I am messing up,

any advice?

planethax

I think it just may be syntax/punctuation, but too much of a newb to know myself lol.

I have been trying many different combos, but no luck so far.

planethax

I am 90% sure it has to do with they way I am having the ' and " etc inbetween the main ' ' but just not sure how to do it.

planethax

Can anyone help me with this?
I am not sure how the syntax goes?

Thanx

Weedpacket

You're putting PHP code into a string. It's not going to do any good there. You're trying to output HTML when what you're wanting to do is put it in a variable.

$standing_text = "";
foreach($standings as $rank=>$standing)
{
	$standing_text .= '<tr '.($standing[$in_contention]==1 ? 'class="contender"' : '').'>';
	$standing_text .= '<td>'.$rank.'</td>';
	foreach(array('rank_delta', 'driver', 'points', 'behind', 'starts', 'poles', 'wins', 'top5', 'top10', 'dnf', 'winnings') as $stat)
	{
		$standing_text .= '<td>'.$standing[$stat].'</td>';
	}
	$standing_text .= '</tr>';
}

$tpl -> AssignArray(array('standing' => $standing_text));

planethax

Thanx Weedpacket, that helped a lot, but I still have one problem I can not seem to overcome.
The previous code seems to loose the "class = contender" ?

The page source is as follows

<tr ><td>1</td><td>-</td><td>Tony Stewart</td><td>3564</td><td>Leader</td><td>0</td><td>4</td><td>3</td><td>13</td><td>18</td><td>0</td><td>$5,284,245</td></tr><tr ><td>2</td><td>+1</td><td>Jimmie Johnson</td><td>3344</td><td>220</td><td>0</td><td>1</td><td>3</td><td>9</td><td>15</td><td>1</td><td>$4,901,747</td></tr><tr ><td>3</td><td>-1</td><td>Jeff Gordon</td><td>3310</td><td>254</td><td>0</td><td>1</td><td>1</td><td>11</td><td>16</td><td>1</td><td>$4,593,473</td></tr><tr ><td>4</td><td>+1</td><td>Denny Hamlin</td><td>3141</td><td>423</td><td>0</td><td>0</td><td>1</td><td>8</td><td>12</td><td>1</td><td>$3,331,789</td></tr><tr ><td>5</td><td>-1</td><td>Carl Edwards</td><td>3110</td><td>454</td><td>0</td><td>0</td><td>0</td><td>7</td><td>11</td><td>1</td><td>$3,997,332</td></tr><tr ><td>6</td><td>-</td><td>Kurt Busch</td><td>3103</td><td>461</td><td>0</td><td>0</td><td>1</td><td>6</td><td>13</td><td>1</td><td>$3,245,734</td></tr><tr ><td>7</td><td>+2</td><td>Ryan Newman</td><td>2995</td><td>569</td><td>0</td><td>1</td><td>0</td><td>5</td><td>10</td><td>0</td><td>$3,573,609</td></tr><tr ><td>8</td><td>+2</td><td>Greg Biffle</td><td>2986</td><td>578</td><td>0</td><td>0</td><td>0</td><td>8</td><td>11</td><td>2</td><td>$3,408,834</td></tr><tr ><td>9</td><td>-2</td><td>Juan Pablo Montoya</td><td>2975</td><td>589</td><td>0</td><td>1</td><td>0</td><td>1</td><td>11</td><td>0</td><td>$3,508,994</td></tr><tr ><td>10</td><td>+2</td><td>Mark Martin</td><td>2971</td><td>593</td><td>0</td><td>5</td><td>4</td><td>7</td><td>12</td><td>3</td><td>$3,670,628</td></tr><tr ><td>11</td><td>-3</td><td>Kasey Kahne</td><td>2963</td><td>601</td><td>0</td><td>0</td><td>1</td><td>4</td><td>9</td><td>0</td><td>$3,858,310</td></tr><tr ><td>12</td><td>-1</td><td>Matt Kenseth</td><td>2945</td><td>619</td><td>0</td><td>1</td><td>2</td><td>4</td><td>9</td><td>1</td><td>$5,263,952</td></tr><tr ><td>13</td><td>+2</td><td>Kyle Busch</td><td>2911</td><td>653</td><td>0</td><td>1</td><td>4</td><td>6</td><td>8</td><td>2</td><td>$4,510,376</td></tr><tr ><td>14</td><td>-1</td><td>Brian Vickers</td><td>2906</td><td>658</td><td>0</td><td>6</td><td>1</td><td>4</td><td>11</td><td>3</td><td>$3,382,694</td></tr><tr ><td>15</td><td>-1</td><td>Clint Bowyer</td><td>2833</td><td>731</td><td>0</td><td>0</td><td>0</td><td>4</td><td>10</td><td>1</td><td>$3,160,959</td></tr><tr ><td>16</td><td>-</td><td>David Reutimann</td><td>2785</td><td>779</td><td>0</td><td>2</td><td>1</td><td>4</td><td>7</td><td>0</td><td>$3,508,569</td></tr><tr ><td>17</td><td>-</td><td>Marcos Ambrose</td><td>2639</td><td>925</td><td>0</td><td>0</td><td>0</td><td>4</td><td>7</td><td>2</td><td>$3,016,439</td></tr><tr ><td>18</td><td>-</td><td>Jeff Burton</td><td>2568</td><td>996</td><td>0</td><td>0</td><td>0</td><td>2</td><td>6</td><td>2</td><td>$3,649,887</td></tr><tr ><td>19</td><td>-</td><td>Joey Logano</td><td>2487</td><td>1077</td><td>0</td><td>0</td><td>1</td><td>1</td><td>5</td><td>2</td><td>$3,745,747</td></tr><tr ><td>20</td><td>-</td><td>Casey Mears</td><td>2478</td><td>1086</td><td>0</td><td>0</td><td>0</td><td>0</td><td>3</td><td>0</td><td>$2,754,038</td></tr><tr ><td>21</td><td>-</td><td>Dale Earnhardt Jr.</td><td>2416</td><td>1148</td><td>0</td><td>0</td><td>0</td><td>2</td><td>5</td><td>3</td><td>$2,934,939</td></tr><tr ><td>22</td><td>-</td><td>Jamie McMurray</td><td>2403</td><td>1161</td><td>0</td><td>0</td><td>0</td><td>0</td><td>3</td><td>2</td><td>$2,752,904</td></tr><tr ><td>23</td><td>+1</td><td>Martin Truex Jr.</td><td>2314</td><td>1250</td><td>0</td><td>1</td><td>0</td><td>0</td><td>3</td><td>2</td><td>$3,242,902</td></tr><tr ><td>24</td><td>-1</td><td>Kevin Harvick</td><td>2300</td><td>1264</td><td>0</td><td>0</td><td>0</td><td>2</td><td>3</td><td>2</td><td>$4,320,009</td></tr><tr ><td>25</td><td>-</td><td>AJ Allmendinger</td><td>2258</td><td>1306</td><td>0</td><td>0</td><td>0</td><td>1</td><td>3</td><td>0</td><td>$2,847,933</td></tr>

Thank you again!

planethax

AHHHHH
I think I am starting to get this.

I changed

 $standing_text .= '<tr '.($standing[$in_contention]==1 ? 'class="contender"' : '').'>';

$standing_text .= '<tr class='.($standing['in_contention'] == 1 ? 'contendor' : null).'>';

This works, but can anyone see any errors? will my changes cause any issues later on down the road?

Thanx.

Weedpacket

Well, if the guy is not in contention you'll get a bogus

<tr class=>

tag, which is bad HTML. Putting the quotes back around the attribute values (not quoting attribute values is a Bad Thing) would result in <tr class=""> which is at least valid, but redundant.

planethax wrote:
This works, but can anyone see any errors?

Apart from misspelling "contender"?

planethax

So this would be better?

    $standing_text .= '<tr '.($standing['in_contention'] == 1 ? 'class="contender"' : null).'>';

planethax

Thank you for your help.
I am marking this one resolved, however, if you see an error or bad coding that I should change, please let me know.

Thank you again!