while($row = mysql_fetch_array($m_query, MYSQL_ASSOC)) {
$arr2[] = array('name_test' => $row['name_test'], 'answer_id' => $row['answer_id'], 'answer_id_2' => $row['answer_2']);
}
echo json_encode($arr2);
Только с библиотекой mysqli.
while($row = mysql_fetch_array($m_query, MYSQL_ASSOC)) {
$arr2[] = array('name_test' => $row['name_test'], 'answer_id' => $row['answer_id'], 'answer_id_2' => $row['answer_2']);
}
echo json_encode($arr2);
Цитата (Dimaz @ 3.01.2013 - 17:24) |
То есть если я использую подготовленные выражения этот метод использовать нельзя? |
<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
include("user_auth.php");
$user_id = $_COOKIE['viewer_id'];
$tests = $_POST['tests'];
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if (!mysqli_connect_errno()) {
if($tests){
$stmt = $mysqli->prepare("SELECT cabinet.name_test, cabinet.formula, a1.answer_id as answer_id, a2.answer_id as answer_id2 FROM cabinet JOIN answers a1 ON a1.test_id = cabinet.test_id AND a1.user_id = ? AND a1.friend_id = ? LEFT JOIN answers a2 ON a2.test_id = cabinet.test_id AND a2.user_id = ? GROUP BY answer_id ORDER BY a1.id");
$stmt->bind_param('iii', $user_id, $tests, $tests);
$stmt->execute();
//$stmt->bind_result($name_test, $formula, $answer_id, $answer_id2);
$result = $stmt->get_result();
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
$arr[] = $row;
}
echo json_encode($arr);
}
}
else {
echo "Не удалось установить подключение к базе данных";
}
?>