Мне нравится передавать параметр ID в php, чтобы я мог получить определенную строку базы данных sql внутри скрипта.
Параметр ID доступен в URL, например (Http: //localhost/RoutingAngularJS/index.php#/students/1). Эта последняя цифра 1 является идентификатором строки в базе данных, чтобы можно было получить информацию о человеке в этой строке.
$ routeParams используется в контроллере как
var app = angular.module("Demo", ["ngRoute"])
.config(function($routeProvider){
$routeProvider
.
.when("/students/:id", {
templateUrl:"Templates/studentDetails.html",
controller:"studentDetailsController"})
})
.controller("studentDetailsController", function ($scope, $http, $routeParams) {
$http({
url:"api/ReadOneStudent.php",
params:{id:$routeParams.id},
method: "get"
}).then(function(response){
$scope.student = response.records;
})
});
Мой файл ReadOneStudent.php
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
// include database and object files
include_once 'database.php';
include_once 'Students.php';
// instantiate database and product object
$database = new Database();
$db = $database->getConnection();
// initialize object
$student = new Students($db);
// get id of product to be edited
//$data = json_decode(file_get_contents("php://input"));
// set ID property of product to be edited
$student->id = ????;
// read the details of product to be edited
$student->readOneStudent();
// create array
$student_arr[] = array(
"id" => $student->id,
"name" => $student->name,
"gender" => $student->gender,
"city" => $product->city
);
echo '{"records":[' . $student_arr . ']}';
// make it json format
//print_r(json_encode($student_arr));
?>
Мне нравится передавать id в $ student-> id, теперь с ????.
Спасибо
РЕДАКТИРОВАТЬ:
var app = angular.module("Demo", ["ngRoute"])
.config(function($routeProvider){
$routeProvider
.
.when("/students/:id", {
templateUrl:"Templates/studentDetails.html",
controller:"studentDetailsController"})
})
.controller("studentDetailsController", function ($scope, $http, $routeParams) {
$http({
url:"api/ReadOneStudent.php",
params:$routeParams,
method: "get"
}).then(function(response){
$scope.student = response.data;
})
});
ReadOneStudent.php
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
// include database and object files
include_once 'database.php';
include_once 'Students.php';
// instantiate database and product object
$database = new Database();
$db = $database->getConnection();
// initialize object
$student = new Students($db);
// get id of product to be edited
//$data = json_decode(file_get_contents("php://input"));
// set ID property of product to be edited
if (!isset($_GET['id'])) {
http_response_code(400); // bad request
exit;
}
$student->id = $_GET['id'];
// read the details of product to be edited
$found = $student->readOneStudent(); // assuming this returns something useful
if (!$found) {
http_response_code(404);
exit;
}
// create array
// Seeing as this is called "read ONE student", why return an array?
header('Content-type: application/json');
echo json_encode([
'id' => $student->id,
'name' => $student->name,
'gender' => $student->gender,
'city' => $student->city
]); // maybe you can even just use json_encode($student)
exit;
// make it json format
//print_r(json_encode($student_arr));
?>
Students.php
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
class Students{
// database connection and table name
private $conn;
private $table_name = "tblStudents";
// object properties
public $id;
public $name;
public $gender;
public $city;
// constructor with $db as database connection
public function __construct($db){
$this->conn = $db;
}
public function readOneStudent(){
// query to read single record
$query = "SELECT
id, name, gender, city
FROM
" . $this->table_name . "WHERE
id = ?
LIMIT
0,1";
// prepare query statement
$stmt = $this->conn->prepare( $query );
// bind id of product to be updated
$stmt->bindParam(1, $this->id);
// execute query
$stmt->execute();
// get retrieved row
$row = $stmt->fetch(PDO::FETCH_ASSOC);
// set values to object properties
$this->name = $row['name'];
$this->gender = $row['gender'];
$this->city = $row['city'];
}
}
?>
Есть некоторые странные вещи, которые вы делаете здесь. Во-первых, ваш PHP
Students.php — делать readOneStudent()
верните что-нибудь полезное
if (!$row = $stmt->fetch(PDO::FETCH_ASSOC)) {
return false;
}
// set values to object properties
$this->name = $row['name'];
$this->gender = $row['gender'];
$this->city = $row['city'];
$stmt->closeCursor();
return true;
ReadOneStudent.php — отвечать полезными статусами и JSON
if (!isset($_GET['id'])) {
http_response_code(400); // bad request
exit;
}
$student->id = $_GET['id'];
if (!$student->readOneStudent()) {
http_response_code(404);
exit;
}
// Seeing as this is called "read ONE student", why return an array?
header('Content-type: application/json');
echo json_encode([
'id' => $student->id,
'name' => $student->name,
'gender' => $student->gender,
'city' => $student->city
]); // maybe you can even just use json_encode($student)
exit;
Далее я бы использовал resolve
свойство в конфигурации маршрута
$routeProvider.when("/students/:id", {
templateUrl: "Templates/studentDetails.html",
controller:"studentDetailsController",
resolve: {
student: function($routeParams, $http) {
return $http.get('api/ReadOneStudent.php', {
params: {id: $routeParams.id}
}).then(function(response) {
return response.data
});
}
}
})
и, наконец, в вашем контроллере
.controller('studentDetailsController', function($scope, student) {
$scope.student = student;
})
Попробуй использовать $_GET['id']
получить доступ к GET с ключом Я бы в PHP