PHP get_position_list_save_view Examples

Example #1

File: mod_goods_type.php Project: haogm123/ydoa

function get_position_list_save_view($fatherid = 0, $selid = 0, $layer = 0, $ac, $fileurl)
{
    global $db;
    $sql = "SELECT * FROM " . DB_TABLEPRE . "goods_type where father='{$fatherid}'    ORDER BY id Asc";
    $query = $db->query($sql);
    if (count($query) > 0) {
        for ($i = 0; $i < $layer; $i++) {
            $str .= "&nbsp;&nbsp;&nbsp;&nbsp;";
        }
        while ($row = $db->fetch_array($query)) {
            $rsfno = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "goods_type where father='" . $row[id] . "'    ORDER BY id asc limit 0,1");
            echo '<tr class="hover">';
            echo '<td class="td25"></td>';
            echo '<td class="td25">' . get_realname($row['uid']) . '';
            echo '<td><div class="board">' . $str . $row['title'] . '</div></td>';
            echo '<td width="160">';
            get_urlkey("编辑", "admin.php?ac=goods_type_edit&do=edit&fileurl=goods&id=" . $row['id'] . "", "" . $row['uid'] != $_USER->id);
            if ($rsfno[id] == '') {
                echo '&nbsp;|&nbsp;';
                get_urlkey("删除", "admin.php?ac=goods_type&fileurl=goods&do=delete&id=" . $row['id'] . "", "" . $row['uid'] != $_USER->id);
            }
            echo '</td></tr>';
            if ($rsfno[id] != '') {
                get_position_list_save_view($row['id'], $selid, $layer + 1, $ac, $fileurl);
            }
        }
    }
    return;
}

Example #2

File: function_mana.php Project: haogm123/ydoa

function get_position_list_save_view($fatherid = 0, $selid = 0, $layer = 0, $ac, $fileurl)
{
    global $db;
    $sql = "SELECT * FROM " . DB_TABLEPRE . "position where father='{$fatherid}' ORDER BY id Asc";
    $query = $db->query($sql);
    if (count($query) > 0) {
        for ($i = 0; $i < $layer; $i++) {
            $str .= "&nbsp;&nbsp;&nbsp;&nbsp;";
        }
        while ($row = $db->fetch_array($query)) {
            $rsfno = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "position where father='" . $row[id] . "' ORDER BY id asc limit 0,1");
            echo '<tr class="hover"><td class="td25"></td>';
            echo '<td class="td25"><input type="hidden" name="id[]" value="' . trim($row[id]) . '" />' . trim($row[id]) . '</td>';
            echo '<td><div id="cb_' . trim($row[id]) . '" class="childboard">';
            echo '' . $str . '<input type="text" name="name[' . trim($row[id]) . ']" ';
            echo 'value="' . trim($row[name]) . '" style="width:160px;" class="txt" />';
            echo '</div></td>';
            echo '<td class="td25 lightfont"></td>';
            echo '<td class="td23">' . trim($row['date']) . '</td>';
            echo '<td width="160">';
            echo '<a href="admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=update&id=' . trim($row[id]) . '&fid=' . trim($row[father]) . '" class="act">删除</a></td></tr>';
            if ($rsfno[id] != '') {
                get_position_list_save_view($row['id'], $selid, $layer + 1, $ac, $fileurl);
            }
        }
    }
    return;
}