本文整理匯總了PHP中connection::setsql方法的典型用法代碼示例。如果您正苦於以下問題：PHP connection::setsql方法的具體用法？PHP connection::setsql怎麽用？PHP connection::setsql使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類connection的用法示例。
在下文中一共展示了connection::setsql方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: connection
<?php
header('Content-Type: application/json; charset=utf-8');
require_once 'connection.php';
session_start();
if (isset($_SESSION['userid'])) {
$user = $_SESSION['userid'];
$connect = new connection();
$connect->connect();
$number = $connect->escapestring($_GET["number"]);
$sql = "SELECT `mailid`,`senderid`,`empfaengerid`,`text` FROM `mail` WHERE (`senderid` = " . $user . " OR `empfaengerid` = " . $user . ") order by `gesendet` LIMIT " . $number;
$connect->setsql($sql);
$row = $connect->getmap();
echo json_encode($row);
}示例2: connection
<?php
header('Content-Type: application/json; charset=utf-8');
require_once 'connection.php';
$user = $_GET["user"];
$connect = new connection();
$connect->setsql("SELECT * FROM `profil` WHERE id=" . $user);
$connect->connect();
$row = $connect->getarray();
if ($row['sex'] == '0') {
$sex = "keine Angabe";
}
if ($row['sex'] == '1') {
$sex = "Männlich";
}
if ($row['sex'] == '2') {
$sex = "Weiblich";
}
if ($row['orientierung'] == '0') {
$ori = "keine Angabe";
}
if ($row['orientierung'] == '1') {
$ori = "Heterosexuel";
}
if ($row['orientierung'] == '2') {
$ori = "Homosexuel";
}
if ($row['orientierung'] == '3') {
$ori = "Bisexuel";
}
if ($row['orientierung'] == '4') {