PHP Stuff::query示例

<?php

include "../../config.php";
include "../../library/Database.php";
include "../../library/Model.php";
class Stuff extends Model
{
}
$myStuff = new Stuff();
if (isset($_GET['id'])) {
    $id = mysql_real_escape_string($_GET['id']);
    $stuff = $myStuff->query("SELECT * FROM Profile WHERE UserID = {$id}");
    echo json_encode($stuff[0]["Profile"]);
}

示例#2

显示文件

文件： getcourseinfo.php 项目： nlt-pagoda/pagoda-scratch

<?php

include "../../config.php";
include "../../library/Database.php";
include "../../library/Model.php";
class Stuff extends Model
{
}
$myStuff = new Stuff();
if (isset($_GET['id'])) {
    $id = mysql_real_escape_string($_GET['id']);
    $stuff = $myStuff->query("SELECT CRN,name,section,number FROM Course WHERE CourseID = {$id}");
    echo json_encode($stuff[0]["Course"]);
}