PHP _query_assoc示例

示例#1

文件： function.php 项目： a707937337/letsgo_work

/**
 * 获取全部公告列表
 */
function _get_notices()
{
    $result = _query_assoc("select * from letsgo_notice order by releasetime desc");
    foreach ($result as $row) {
        echo '<tr>';
        echo '<td>' . $row["releaseTime"] . '</td>';
        if ($row["type"] == "notice") {
            echo '<td class="content"><a href="/notice.php?id=' . $row["id"] . '">' . $row["title"] . '</a></td>';
        } else {
            echo '<td class="content">' . $row["title"] . '</td>';
        }
        echo '</tr>';
    }
}

示例#2

文件： staffsearch.php 项目： a707937337/letsgo_work

<?php

define('IN_TG', true);
include dirname(__FILE__) . '/configs/configs.php';
require_once $GLOBALS["rootPath"] . '/includes/function.php';
if (empty($_GET["q"])) {
    echo "{\"result\":0,\"data\":0}";
    exit;
}
$sql = "SELECT * FROM letsgo_staff WHERE staffid = '{$_GET['q']}'  OR  `name` LIKE '%" . $_GET['q'] . "%'";
$result = _query_assoc($sql);
//echo "{\"result\":0,\"data\":".json_encode($result)."}";
//echo json_encode($result);
$html = "";
foreach ($result as $row) {
    $html .= '<div class="col-md-2">工号：' . $row["staffId"] . '</div>';
    $html .= '<div class="col-md-2">姓名：' . $row["name"] . '</div>';
    $html .= '<div class="col-md-2">手机：' . $row["telephone"] . '</div>';
    $html .= '<div class="col-md-3">邮箱：' . $row["email"] . '</div>';
    $html .= '<div class="col-md-3">学校：' . $row["college"] . '</div>';
}
echo $html;
exit;
?>