MySQL rijen omzetten naar kolommen in Smarty
code: club.php
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
// Include global file & classes
require_once('./global.inc.php');
$pagetitle = "Club";
$smarty = new Smarty; // Maak object
$smarty->assign("Name","BC Netwerk");
$smarty->assign('pagetitle',$pagetitle);
$smarty->display('club.tpl');
$sql = "SELECT omschrijving,groep,voornaam,tussenvoegsel,achternaam,adres,telefoon,mobiel
FROM jobs, members
WHERE members.memberid=jobs.memberid ORDER BY jobid";
$result = mysql_query($sql);
$aantalrijen=3;
$teller=0;
echo '<table><tr>';
while ($regel=mysql_fetch_array($result))
{
echo '<td>';
echo $regel[0]."<br>\n";
echo $regel[2]." ".$regel[3]." ".$regel[4]."<br>\n";
echo $regel[5]."<br>\n";
echo "Tel.:" ." ".$regel[6]."<br>\n";
echo "Mob.:" ." ".$regel[7];
echo '</td>';
$teller++;
if ($teller%$aantalrijen==0)
{ echo "</tr><tr>";
}
}
echo '</tr></table>';
?>
// Include global file & classes
require_once('./global.inc.php');
$pagetitle = "Club";
$smarty = new Smarty; // Maak object
$smarty->assign("Name","BC Netwerk");
$smarty->assign('pagetitle',$pagetitle);
$smarty->display('club.tpl');
$sql = "SELECT omschrijving,groep,voornaam,tussenvoegsel,achternaam,adres,telefoon,mobiel
FROM jobs, members
WHERE members.memberid=jobs.memberid ORDER BY jobid";
$result = mysql_query($sql);
$aantalrijen=3;
$teller=0;
echo '<table><tr>';
while ($regel=mysql_fetch_array($result))
{
echo '<td>';
echo $regel[0]."<br>\n";
echo $regel[2]." ".$regel[3]." ".$regel[4]."<br>\n";
echo $regel[5]."<br>\n";
echo "Tel.:" ." ".$regel[6]."<br>\n";
echo "Mob.:" ." ".$regel[7];
echo '</td>';
$teller++;
if ($teller%$aantalrijen==0)
{ echo "</tr><tr>";
}
}
echo '</tr></table>';
?>
tabelcode: club.tpl
<table class="headlinetable-sp" style="margin-top:15px;">
{section name=... loop=$...}
<tr>
<td class="second"></td>
</tr>
{/section}
</table>
Meerdere suggesties zijn welkom. BVD Auke.
