Smarty

asd_pl · Smarty n00b Joined: 09 Nov 2003 Posts: 2

How to display results of this code using smarty?

[php:1:6aa225f577]<?php
$query = "SELECT * FROM ug_users";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){
echo "<hr>";
echo "ID: $row[ug_id] ";
echo "Login: $row[ug_login] ";
echo "Nick: $row[ug_nick] ";
echo "Level: $row[ug_level] ";
echo "Pass: $row[ug_pass] ";
echo "Data Rejestracji: $row[ug_reg_date] ";
echo "Opis: $row[ug_about] ";
echo "Administracja: ";
echo "<a href=\"asd?action=user_edit&id=$row[ug_id]\">Edit</a> <a href=\"asd?action=user_delete&id=$row[ug_id]\">Delete</a> <a href=\"asd?action=user_ban&id=$row[ug_id]\">Ban</a> ";

}

?>[/php:1:6aa225f577]

Thanks for help

boots · Posted: Sun Nov 09, 2003 4:35 pm Post subject:

Hi asd_pl!

Please, read the docs before asking and try a few tutorials. You should find that there is a very short learning curve to getting started. If you look at Smarty's home page you will see a few handy links in the left-hand navigation bar including: documentation and even a crash course.

There are many tutorials already available on the web. Virtually all of the popular PHP/coding sites (and many less pouplar sites) have at least one Smarty sample. For example, try this tutorial at CodeForSoup -- it seems to be fairly much in the same range as what you are looking for.

This is what google says about smarty mysql tutorial.

There are also several examples right here at the forum if you do a search on mysql such as this one: foreach of section, that is the question.

HTH

corre · Smarty n00b Joined: 09 Nov 2003 Posts: 1

To use echo like this is hard work, especially as you wont see a thing in a editor