How to get this PHP code into a template

[RoutineX]

I've been doing some reading and apparently you can't use PHP directly in the templates. The php code works perfectly standalone, but wanted to integrate it in a vBulletin template. I've made a plugin in global_start with the php code I want to use, but wasn't sure what to do next (if that even was right). I also read some in the API documentation, but didn't manage to get any further with that.

What I want to do is basically just connect to a database, selecting everything from a table and displaying it in a table(html) and print row for row.

Below is the code of what I'm going to do (just edited the values).

Hope anyone can help :)


require ('auth.php');

$res = mysql_query("SELECT * FROM TableName",$db);
$test = 1;

if($rad = mysql_fetch_array($res))
{
echo'
<table width="642" border="0" cellspacing="0">
<tr bordercolor="#CCFF33">
<td width="XX"><strong>Topic 1</strong></div></td>
<td width="XX"><strong>Topic 2</strong></div></td>
</tr>
';
do {
printf("<tr bordercolor=\"#CCFF33\">
<td background=\"XXX.jpg\">%s</td>
<td background=\"XXX.jpg\">%s</td>
<td background=\"XXX.jpg\">%s</td>
</tr>\n",

$test,
$rad["Topic 1"],
$rad["Topic 2"]);
$test++;
}
while ($rad = mysql_fetch_array($res));
echo "</table>\n";
}
?>

[LWillmann]

What if you assign the HTML to a variable in your code above, in the if statement, then just place a reference to the variable name in the template where you want it.


<?php
require ('auth.php');

$res = mysql_query("SELECT * FROM TableName",$db);
$test = 1;

if($rad = mysql_fetch_array($res))
{
$output = ' <table width="642" border="0" cellspacing="0">
<tr bordercolor="#CCFF33">
<td width="XX"><strong>Topic 1</strong></div></td>
<td width="XX"><strong>Topic 2</strong></div></td>
</tr>
';
do {
$output .= '<tr bordercolor="#CCFF33">
<td background="XXX.jpg">'.$test.'</td>
<td background="XXX.jpg">'.$rad["Topic 1"].'</td>
<td background="XXX.jpg">'.$rad["Topic 2].'</td>
</tr>\n';
$test ++;
}
while ($rad = mysql_fetch_array($res));
$output .= "</table>\n";
}
else
{
$output = "";
}
?>


Then in your temaplate, you should be able to call a reference to $output and it will hopefully work for you. This should at least be a start in the right direction.

[SuperJETT]

That worked perfectly for my page I was working on too.

Just to make it a tad clearer for people like myself:
In your .php page, have the output go into a variable (using the above custom page code) just above where you call the template you want it inserted into. Then in the template call that variable to stick it's html in.