使用 PHP /MySQL JavaScript 创建一个简单的 Web 开发测试,但不起作用
create a simple web development test using php /mysql javascript but do not work
我正在使用php MySQL JavaScript创建一个简单的Web开发测试,没有语法错误,但系统无法正常工作
谁能帮我????
索引.html
<html>
<head>
<title>Testing Query</title>
<script type="text/javascript" src="script/client.js"></script>
</head>
<body>
select the desired !
<div>
<p> <input type = "button" id = "requestedSTD" value = "Get All Student" onclick = "GetAllStudents();"/></p>
<p> <input type = "button" id = "requestedSTD" value = "Get Student By ID" onclick = "GetStudentByID(2);"/></p>
</div>
</body>
</html>
客户端.js
function GetAllStudents()
{
var formRequest = new FormData();
formRequest.append('getStudent', "getAllStudent");
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", uploadComplete, false);
xhr.open("GET", 'StudentService/getAllStudent.php');
xhr.send(formRequest);
}
function GetStudentByID(id)
{
var formRequest = new FormData();
formRequest.append('sid', id);
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", uploadComplete, false);
xhr.open("POST", 'StudentService/getStudentByID.php');
xhr.send(formRequest);
}
function uploadComplete(evt)
{
console.log(evt.target.responseText);
}
得到全部学生.php
<?php
require_once '../ConnectionManager.php';
$response = array();
$db = ConnectionManager::getInstance();
$result = mysql_query("SELECT * FROM student") or die(mysql_error());
if(mysql_num_rows($result) >0)
{
$response["student"] = array();
while($roe = mysql_fetch_array($result))
{
$student = array();
$student["ID"] = $row["ID"];
$student["Index"] = $row["Index"];
$student["Name"] = $row["Name"];
array_push($response["student"], $student);
}
$response["success"] = 1;
echo json_encode($response);
}
else
{
$response["success"] = 0;
$response["message"] = "No students found!!";
echo json_encode($response);
}
?>
getStudentByID.php
<?php
require_once '../ConnectionManager.php';
$response = array();
$db = connectionManager::getInstance();
if(isset($_POST["sid"]))
{
$id = $_POST["sid"];
$result = mysql_query("SELECT * FROM student WHERE ID = $id");
if(!empty($result))
{
if(mysql_num_row($result) >0)
{
$row = mysql_fetch_array($result);
$student = array();
$student["ID"] = $row["ID"];
$student["Index"] = $row["Index"];
$student["Name"] = $row["Name"];
$response ["success"] = 1;
$response["$student"] = array();
array_push($reponse["student"], $student);
echo json_encode($response);
}
else
{
$response["success"] = 0;
$response["message"] = "No Student found with this ID!!";
echo json_encode($response);
}
}
else
{
$response["success"] = 0;
$response["message"] = "No Student found with this ID!!";
echo json_encode($response);
}
}
else
{
$response["success"] = 0;
$response["message"] = "Required feild(s) is missing!!";
echo json_encode($response);
}
?>
连接管理器.php
<?php
require_once 'Connection.php';
class ConnectionManager
{
static $connection = null;
public static function getInstance()
{
if(ConnectionManager::$connection == null);
ConnectionManager::$connection = new Connection;
return ConnectionManager::$connection;
}
private function __construct()
{
}
private function __clone()
{
}
}
?>
连接.php
<?php
class Connection
{
function __construct()
{
$this->connect();
}
function __destruct()
{
$this->close();
}
function connect()
{
require_once __DIR__ . '/db_config.php';
$connection = mysql_connect(SERVER, USER, PASSWORD) or die(mysql_error());
$dbConnect = mysql_select_db(DATABASE) or die(mysl_error());
return $connection;
}
function close()
{
mysql_close();
}
}
?>
db_config.php
<?php
define('USER', "***");
define('PASSWORD', "***");
define('DATABASE', "studentservice");
define('SERVER', "localhost");
?>
当我按下"获取所有学生"按钮时,控制台显示此文本
控制台日志
GET http://localhost/studentservice/StudentService/getAllStudent.php
200 OK
20ms
client.js (line 9)
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: array_push() expects parameter 1 to be array, null given in C:'wamp'www'studentservice'StudentService'getAllStudent.php on line <i>18</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0018</td><td bgcolor='#eeeeec' align='right'>677800</td><td bgcolor='#eeeeec'>{main}( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0054</td><td bgcolor='#eeeeec' align='right'>708704</td><td bgcolor='#eeeeec'><a href='http://www.php.net/array_push' target='_new'>array_push</a>
( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>18</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: array_push() expects parameter 1 to be array, null given in C:'wamp'www'studentservice'StudentService'getAllStudent.php on line <i>18</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0018</td><td bgcolor='#eeeeec' align='right'>677800</td><td bgcolor='#eeeeec'>{main}( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0057</td><td bgcolor='#eeeeec' align='right'>709072</td><td bgcolor='#eeeeec'><a href='http://www.php.net/array_push' target='_new'>array_push</a>
( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>18</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: array_push() expects parameter 1 to be array, null given in C:'wamp'www'studentservice'StudentService'getAllStudent.php on line <i>18</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0018</td><td bgcolor='#eeeeec' align='right'>677800</td><td bgcolor='#eeeeec'>{main}( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0057</td><td bgcolor='#eeeeec' align='right'>709216</td><td bgcolor='#eeeeec'><a href='http://www.php.net/array_push' target='_new'>array_push</a>
( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>18</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: array_push() expects parameter 1 to be array, null given in C:'wamp'www'studentservice'StudentService'getAllStudent.php on line <i>18</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0018</td><td bgcolor='#eeeeec' align='right'>677800</td><td bgcolor='#eeeeec'>{main}( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>0</td></tr>
<tr><td bgcolor='#eeeeec' align='center'>2</td><td bgcolor='#eeeeec' align='center'>0.0059</td><td bgcolor='#eeeeec' align='right'>709360</td><td bgcolor='#eeeeec'><a href='http://www.php.net/array_push' target='_new'>array_push</a>
( )</td><td title='C:'wamp'www'studentservice'StudentService'getAllStudent.php' bgcolor='#eeeeec'>..'getAllStudent.php<b>:</b>18</td></tr>
</table></font>
{"student":[],"Array":null,"success":1}
getAllStudent.php第18行array_push($reponse["student"], $student);
中的拼写错误
正确:array_push($response["student"], $student);
相关文章:
- Web编程,简单但适用于机器人项目
- 从简单的html页面调用实时Web服务.
- 无法获取使用 HTML 简单登录到 PHP Web 服务的数据
- 为移动游戏找到一个简单的 Web 服务器框架
- 尝试使用phonegap对我现有的Web应用程序进行简单的登录
- 如何将简单的 jquery 滑块添加到 SharePoint 2010 Web 部件
- 基本的 dojo 1.7 简单的 Web 应用程序,具有优雅的基础架构(例如 Dojo 样板)
- 简单的用户Web界面,带有Python中的表条目
- AngularJS $http.post ASP.NET 具有简单类型参数的 Web API 控制器
- 节点.js简单的 Web 服务器请求生命周期
- 使用 PHP /MySQL JavaScript 创建一个简单的 Web 开发测试,但不起作用
- 测试浏览器是否支持 Web 音频 API 的简单方法
- 简单的web服务器示例-为什么我必须将属性名称加引号
- 如何在c#MVC web项目中制作一个简单的事件日历
- 实现简单web服务项目的最简单方法
- 我的node.js简单web服务器没有'无法访问父文件夹
- 我应该在启动之前构建我的简单web应用程序吗
- 与Maven相比,构建Java Web应用程序的更好、更简单、更现代的方法是什么?
- 非常简单的并发安全web平台
- 适合简单的交互式web应用程序的工具