PHP recurse_sections Examples

Example #1

File: panel.php Project: amcgregor/resumewriter

function scansections()
{
    global $sections;
    global $userid;
    $sql = sprintf("SELECT * FROM sections WHERE user=%d AND subsection=0 ORDER BY `order`", $userid);
    $sections = recurse_sections(db_query($sql));
}

Example #2

File: mysql.php Project: amcgregor/resumewriter

function recurse_sections($result)
{
    global $userid;
    $sections = array();
    while ($row = mysql_fetch_assoc($result)) {
        $sql = sprintf("SELECT * FROM sections WHERE user=%d AND subsection=%d ORDER BY `order`", $userid, $row['id']);
        $row['subsections'] = recurse_sections(db_query($sql));
        $sections[] = $row;
    }
    return $sections;
}

Example #3

File: preview.php Project: amcgregor/resumewriter

<?php

ob_start("ob_gzhandler");
include "../includes/structure.php";
$userid = 1;
// Read some database information about the current user... cookies anyone?
db_connect();
$sql = sprintf("SELECT * FROM users WHERE id=%d LIMIT 1", $userid);
$result = db_query($sql);
$user = mysql_fetch_assoc($result);
// Get the list of main sections, and subsections of each... gah.
$sql = sprintf("SELECT * FROM sections WHERE user=%d AND subsection=0 ORDER BY `order`", $userid);
$sections = recurse_sections(db_query($sql));
$_body = " background=\"images/preview.png\"";
include "templates/template." . $user['template'] . ".php";