Show mysql query using Smarty php

Question

I'm making a blog as a school project and is a bit stuck.

One of the requirements for the project is to use smarty, and this is totally new to me.

My problem is that I want to assign the "blog-posts" from my database to smarty variables. My approach is like this:

<?php
require_once('connect_db.php');
$result = $db->query("SELECT * FROM Innlegg");
while ($row = $result->fetch_assoc())
{print ("<h1>" . $row["forfatter"] . "</h1>");
print ($row["innhold"]);}
?>

Now i just print out "forfatter" from "Innlegg". How is this done by using smarty?

Perhaps you should read the Smarty documentation before starting your project. — René Höhle
– René Höhle, Commented Apr 12, 2012 at 15:47

middus · Accepted Answer · 2012-04-12 15:43:29Z

4

Try reading the Smarty FAQ first.. its very straightforward

$list=array();
while ($row = $result->fetch_assoc()) {
    $list[]=$row;
}

$smarty = new Smarty(); //maybe some configuration ?
$smarty->assign('list', $list);
$smarty->fetch('index.tpl');

and inside smarty index.tpl template file

{foreach from=$list item=row}
    <h1>{$row.forfatter}</h1>
    {$row.innhold}
{/foreach}

edited Apr 12, 2012 at 15:43

middus

9,1291 gold badge34 silver badges33 bronze badges

answered Apr 12, 2012 at 15:27

Artjom Kurapov

6,1554 gold badges34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Show mysql query using Smarty php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related