PHP ShowPromos примеры использования

Пример #1

Файл: promos.php Проект: BackupTheBerlios/soopa

function ViewPromo()
{
    global $xoopsDB, $myts;
    $idp = $_GET['idp'];
    if ($idp <= 0) {
        ShowPromos();
        die;
    }
    include_once 'functions.php';
    $result = $xoopsDB->query("SELECT * FROM {$tpromos} WHERE id_promo='{$idp}'");
    $num = $xoopsDB->getRowsNum($result);
    if ($num <= 0) {
        redirect_header('promos.php', 1, _AM_NOEXIST);
        die;
    }
    $row = $xoopsDB->fetchArray($result);
    xoops_cp_header();
    ShowNav();
    echo "<table width='100%' class='outer' cellspacing='2'>\n\n\t\t\t<tr><th colspan='2'>{$row['nombre']}</th></tr>\n\t\t\t<tr><td class='even' align='center'>";
    if ($row['img'] != '') {
        echo "<img src='{$row['img']}' border='0'>";
    }
    echo "<br><br>\n\t\t\t<a href='promos.php?op=mod&amp;idp=" . $idp . "'>" . _AM_MODIFY . "</a><br>\n\t\t\t<a href='promos.php?op=del&amp;idp=" . $idp . "'>" . _AM_DELETE . "</a></td>\n\t\t\t<td class='odd' align='left'>" . $myts->makeTareaData4Show($row['longdesc']) . "<br><br>\n\t\t\t<strong>" . _AM_FORMPRICE . "</strong> {$row['precio']}<br>\n\t\t\t<strong>" . _AM_FORMCODE . "</strong> <span style='font-family: courier'>{$row['codigo']}</a><br>\n\t\t\t</td></table><br>";
    echo "<table width='100%' class='outer' cellspacing='2'>\n\n\t\t\t<tr><th colspan='2'>" . _AM_ASSIGNED . "</th></tr>";
    $result = $xoopsDB->query("SELECT * FROM {$tprorel} WHERE id_promo='{$idp}'");
    while ($row = $xoopsDB->fetchArray($result)) {
        echo "<tr><td class='even' align='left'>\n\t\t\t\t\t<a href='services.php?op=view&amp;ids=" . $row['id_srv'] . "'>" . ServiceName($row['id_srv']) . "</a></td>\n\n\t\t\t\t\t<td class='even' align='center'>\n\t\t\t\t\t<a href='services.php?op=mod&amp;ids=" . $row['id_srv'] . "'>" . _AM_MODIFY . "</a></td></tr>";
    }
    echo "  </table>";
    xoops_cp_footer();
}

Пример #2

Файл: sales.php Проект: BackupTheBerlios/soopa

    }
    echo "</table>";
    xoops_cp_footer();
}
function ShowServs()
{
    global $xoopsDB;
    include 'functions.php';
    $result = $xoopsDB->query("SELECT * FROM {$tvensrv} ORDER BY id_srv");
    xoops_cp_header();
    ShowNav();
    echo "<table width='100%' class='outer' cellspacing='1'>\n\t\t\t<tr><th colspan='4'>" . _AM_SERVS_LIST . "</th></tr>";
    while ($row = $xoopsDB->fetchArray($result)) {
        echo "<tr class='even'><td align='left'>\n\t\t\t  <a href='promos.php?op=view&amp;idp={$row['id_promo']}'>" . ServiceName($row['id_srv']) . "</a></td>\n\t\t\t  <td align='center'>" . date("d/m/Y h:i:s", $row['fecha']) . "</td>\n\t\t\t  <td align='center'>{$row['buyermail']}</td>\n\t\t\t  <td align='center'><a href='sales.php?op=promos&amp;action=del'>" . _AM_DELETE . "</a></td>\n\t\t\t  </tr>";
    }
    echo "</table>";
    xoops_cp_footer();
}
/****************************************************/
$op = $_GET['op'];
if ($op == '') {
    $op = $_POST['op'];
}
switch ($op) {
    case 'promos':
        ShowPromos();
        break;
    case 'srvs':
        ShowServs();
        break;
}