phpBB.nl

Code: Selecteer alles

<?php 

// DEFAULT PAGE 
    
    default: 

    // Categorien Zoeken.. 
    $sSQL = 'SELECT id, name FROM site_links_cat'; 
    $rResult = mysql_query($sSQL); 

    if(!$rResult) { 
        if(DEBUG_MODE) { 
            echo("Er ging iets fout met de query: ".mysql_error()." (".$sSQL.")"); 
        } 
    } 
    else { 
        while ($row = mysql_fetch_assoc($rResult)) { 
            $template->assign_block_vars('cat', array( 
            'ID'    => $row['id'], 
            'NAME'    => $row['name'] 
            )); 

            $id = $row['id']; 

            // Links per Categorie zoeken.. 
            $aSQL = "SELECT id, name, description, clicks FROM site_links_data WHERE cid =  " . $id . " "; 
            $tResult = mysql_query($aSQL); 

            if(!$tResult) { 
                if(DEBUG_MODE) { 
                    echo("Er ging iets fout met de query: ".mysql_error()." (".$sSQL.")"); 
                } 
            } 
            else { 
                while ($arow = mysql_fetch_assoc($tResult)) { 
                    $template->assign_block_vars('link', array( 
                    'ID'            => $arow['id'], 
                    'NAME'            => $arow['name'], 
                    'DESCRIPTION'    => $arow['description'], 
                    'CLICKS'        => $arow['clicks'] 
                    )); 
                } 
            } 
        } 
    } 

    page_header('Links'); 

    $template->set_filenames(array('body' => 'links_body.html',)); 
?> 

////////// HTML:

<!-- INCLUDE overall_header.html --> 
<hr> 
<div class="panel"> 
<div class="inner"><span class="corners-top"><span></span></span> 
<div class="content" align="left"> 
<p> 
<table width="100%" valign="top" class="row2" cellpadding="0" cellspacing="0" style="border: 1px black solid;"> 
<tr><td colspan="2" class="cat" align="left">Links Database</td><td class="cat"></td></tr> 
<tr><td height="4"></td></tr> 
<!-- BEGIN cat --> 
<tr align="left"><td> 
&nbsp;{cat.NAME} 
<!-- BEGIN link --> 
&nbsp;->{link.NAME} 
<!-- END link --> 
</td></tr> 
<tr><td><td height="5"></td></tr> 
<!-- END cat --> 
<tr><td><td height="4"></td></tr> 
</tr> 
<tr> 
<td colspan="2" class="catb">&nbsp;</td><td class="catb"></td> 
</tr> 
</table> 

</p> 
</div> 
<hr> 
<span class="corners-bottom"><span></span></span></div> 
</div> 
<!-- INCLUDE jumpbox.html --> 
<!-- INCLUDE overall_footer.html --> 


////////////// DATABASE

-- 
-- Tabel structuur voor tabel `site_links_cat` 
-- 

CREATE TABLE `site_links_cat` ( 
`id` mediumint(8) NOT NULL auto_increment, 
`name` varchar(255) NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; 

-- 
-- Gegevens worden uitgevoerd voor tabel `site_links_cat` 
-- 

INSERT INTO `site_links_cat` VALUES (1, 'Kopen & Verkopen'); 
INSERT INTO `site_links_cat` VALUES (2, 'Volkswagen'); 

-- -------------------------------------------------------- 

-- 
-- Tabel structuur voor tabel `site_links_data` 
-- 

CREATE TABLE `site_links_data` ( 
`id` mediumint(8) NOT NULL auto_increment, 
`cid` mediumint(8) NOT NULL default '0', 
`name` varchar(255) NOT NULL default '', 
`description` mediumtext NOT NULL, 
`clicks` mediumint(8) NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; 

-- 
-- Gegevens worden uitgevoerd voor tabel `site_links_data` 
-- 

INSERT INTO `site_links_data` VALUES (1, 1, 'Marktplaats', 'De grootste (ver)koop site van Nederland.', 0); 
INSERT INTO `site_links_data` VALUES (2, 2, 'Volkswagen Nederland', 'De officiële website van Volkswagen Nederland.', 0);