DHTMLX DataProcessor不保存对数据库的更改(DHTMLX DataProcessor not saving changes to database)

 我有一个相当简单的DHTMLX页面，我正在努力。 我设法从数据库加载数据并将其显示在DHTMLXGrid中。 但是，当我更改网格中的数据时，数据不会保存到数据库中，因此在重新加载页面时会丢失数据。 
 
 有问题的数据库有三个表：用户，节目和观看。 观看是唯一需要更新的（至少现在），我似乎无法让它工作。 
 
 这是我的“connector.php”文件 
 
<?php
require("codebase/connector/grid_connector.php");
require("codebase/connector/db_mysqli.php");
$servername     = "nope";
$username       = "nope";
$password       = "nope";
$databaseName   = "nope";
$conn = new mysqli($servername, $username, $password,$databaseName);
$query = "SELECT watching.user_ID, watching.show_ID,shows.name, watching.episodeswatched, shows.episodes, (shows.episodes - watching.episodeswatched) AS episodesremaining, watching.dropped, watching.waiting FROM watching INNER JOIN shows ON watching.show_ID = shows.ID INNER JOIN users ON watching.user_ID=users.ID";
$gridConnector = new GridConnector($conn, "MySQLi");
if($gridConnector->is_select_mode())
    $gridConnector->render_complex_sql($query,"ID","name,episodeswatched,episodes,episodesremaining,dropped,waiting","user_ID,show_ID");
else 
{
    $gridConnector->render_table("watching","ID", "episodeswatched,dropped,waiting","user_ID,show_ID");
}
?>
 
 和Javascript的相关部分一起制作处理器和DHTMLXGrid 
 
showsGrid.init();
showsGrid.load("connector.php");
var myDP = new dataProcessor("connector.php")
myDP.enableDataNames(true);
myDP.init(showsGrid);
 
 我尝试使用相同的行来获取数据和更新（render_complex_sqlquery），但除了将问题的行涂成红色之外什么也没做。 至少用这种方法，行保持黑色。 
 
 我错过了什么吗？ 我做错了吗？ 我已经完全被困在这里太久了，我承认失败了。 我查看了我能找到的每个示例和教程，搜索了文档，但没有找到任何帮助。 
 
 忘了GitHub链接： https ： //github.com/lightspeed1001/dhtmlxdemo 

I have a rather simple DHTMLX page that I'm working on. I managed to load data from a database and display it in a DHTMLXGrid. However, when I change data in the grid, the data is not saved to the database and is therefore lost when the page is reloaded.
 
The database in question is three tables: users, shows and watching. watching is the only one that needs updating (right now at least) and I just can't seem to get it to work.
 
This is my "connector.php" file
 
<?php
require("codebase/connector/grid_connector.php");
require("codebase/connector/db_mysqli.php");
$servername     = "nope";
$username       = "nope";
$password       = "nope";
$databaseName   = "nope";
$conn = new mysqli($servername, $username, $password,$databaseName);
$query = "SELECT watching.user_ID, watching.show_ID,shows.name, watching.episodeswatched, shows.episodes, (shows.episodes - watching.episodeswatched) AS episodesremaining, watching.dropped, watching.waiting FROM watching INNER JOIN shows ON watching.show_ID = shows.ID INNER JOIN users ON watching.user_ID=users.ID";
$gridConnector = new GridConnector($conn, "MySQLi");
if($gridConnector->is_select_mode())
    $gridConnector->render_complex_sql($query,"ID","name,episodeswatched,episodes,episodesremaining,dropped,waiting","user_ID,show_ID");
else 
{
    $gridConnector->render_table("watching","ID", "episodeswatched,dropped,waiting","user_ID,show_ID");
}
?>
 
And the relevant parts of the Javascript to make the processor and DHTMLXGrid
 
showsGrid.init();
showsGrid.load("connector.php");
var myDP = new dataProcessor("connector.php")
myDP.enableDataNames(true);
myDP.init(showsGrid);
 
I tried using the same line for fetching data and updating (render_complex_sqlquery) but that does nothing but paint the row in question red. At least with this method the row stays black.
 
Am I missing something? Am I doing something completely wrong? I've been completely stuck here for way too long and I'm admitting defeat. I've looked at every sample and tutorial I could find, scoured the documentation and found no help for this.
 
Forgot the GitHub link: https://github.com/lightspeed1001/dhtmlxdemo

原文：https://stackoverflow.com/questions/26951097