PHP Stuff::query Exemples

Exemple #1

Fichier : getprofile.php Projet : 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 * FROM Profile WHERE UserID = {$id}");
    echo json_encode($stuff[0]["Profile"]);
}

Exemple #2

Fichier : getcourseinfo.php Projet : 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"]);
}