我正在尝试更新数据库中的记录而不刷新表单.我有grid.php页面,用于显示和更新记录的表单.然后,我有UPDATE查询的文件update.php.第三个文件是带有
AJAX代码的js1.js.如果我通过action = update.php将grid.php映射到update.php,则更新查询效果很好.但是一旦我尝试包含js1.js文件以防止表单刷新,它就会停止工作.
代码如下:
grid.php
require_once 'header.php';
if (!$loggedin) die();
$query = "SELECT SpringMgmt.SpringMgmtID,
SpringMgmt.SpringMgmtActiveYear,
SpringMgmt.PoolID,
SpringMgmt.Notes,
SpringMgmt.SOIEstSubmitted,
SpringMgmt.EstAdditional,
SpringMgmt.SOIMeetingScheduled,
Pool.Pool,
Pool.AreaManager,
Employees.EmployeeID,
Employees.FirstName
FROM SpringMgmt
INNER JOIN Pool ON SpringMgmt.PoolID = Pool.PoolID
INNER JOIN Employees ON Employees.EmployeeID = Pool.AreaManager ";
$result = mysql_query($query);
echo "OK