[Resolved] Outputting these 4 sets of data

TheMayhem

Alright a day ago I posted about putting templates on my database... Now that I have them, a person showed me the easiest way to call upon these 4 templates as below.

$query = mysql_query(Select * From templates);

while ($t = mysql_fetch_array($query)) {

$templates[$t['header']] = $t['header'];
$templates[$t['index']] = $t['index'];
$templates[$t['modcolumn']] = $t['modcolumn'];


$templates[$t['footer']] = $t['footer'];


}

mysql_free_result($query);

So all four are text stored files in the db... My question is what would be the easiest way to call upon those and actually ouput them correctly?

devinemke

is the template system just those 4 in a single database record? if so you don't really need a loop. plus your code puts the entire template string as both the key and value of the array. this makes it pretty dificult to use them.

honestly, i don't see what the added value of storing these in a database is. if you have just 4 templates, just store them as files.

TheMayhem

Originally posted by devinemke
is the template system just those 4 in a single database record? if so you don't really need a loop. plus your code puts the entire template string as both the key and value of the array. this makes it pretty dificult to use them.

honestly, i don't see what the added value of storing these in a database is. if you have just 4 templates, just store them as files.

I just used those 4 templates as a base, in the end there could be at times close to 20 per page. While you might not see the value I have been assured for the type of project I am taking that this is the best way for the project but in normal cases I should be doing in file wise. Any ideas on how I could get an ouput with these 4?

devinemke

well, as i already pointed out you are using the entire template string as both the key and value of the array. if the 4 templates are all in a single database record then you don't need the loop at all:

$result = mysql_query('SELECT * FROM templates');
$templates = mysql_fetch_assoc($result);

now you can refer to the 4 as:

echo $templates['header'];
echo $templates['index'];
// etc...

TheMayhem

Originally posted by devinemke
well, as i already pointed out you are using the entire template string as both the key and value of the array. if the 4 templates are all in a single database record then you don't need the loop at all:
$result = mysql_query('SELECT * FROM templates');
$templates = mysql_fetch_assoc($result);
now you can refer to the 4 as:
echo $templates['header'];
echo $templates['index'];
// etc...
[/B]

I wish it was that easy but these are different rows in the same table.

Such as ID: 1 header TEXT FOR HEADER
Such as ID: 2 index TEXT FOR INDEX

And so forth...

devinemke

let's back up. what is the exact data structure of the table with templates in it?

TheMayhem

table name: templates
columns: id, name, text,

Current Rows of data
header
index
modcolumn
footer

I know I could just use a query for each and every row but I do not want to have 25 added queries to a page with already 15 queries. That's why i think the other person suggested the while statement.

devinemke

if you are reasonably sure that all the "names" will be unique:

$result = mysql_query('SELECT * FROM templates');
while ($row = mysql_fetch_assoc($result))
{
	$templates[$row['name']] = $row['text'];	
}

echo $templates['header'];
echo $templates['index'];

otherwise you will have to use "id" as the array keys.