Передача параметра ID из URL в скрипт php с использованием $ routeParams в AngularJS?

Мне нравится передавать параметр 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'];
}
}

?>

1

Решение

Есть некоторые странные вещи, которые вы делаете здесь. Во-первых, ваш 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;
})
1

Другие решения

Попробуй использовать $_GET['id'] получить доступ к GET с ключом Я бы в PHP

1

По вопросам рекламы ammmcru@yandex.ru
Adblock
detector