Javascript 运行 PHP 函数来更新/插入 SQL

Question

我遇到了一些小问题，我有这个 JavaScript 来更新 VLC webplugin 的流，现在我真的想将一些数据插入我的数据库中，以记录有多少人正在观看。

这是我的 JavaScript 代码 -

function changeVideo(filename) {
  var vlc = document.getElementById("tv");
  var options = [":http-user-agent=Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25"];
  var URL = filename;
  var AddVid = vlc.playlist.add(URL, "", options);
  vlc.playlist.playItem(AddVid);
}

这是我激活该功能的底部链接

<a href="javascript:void();" onclick="javascript:changeVideo('<?=$row["link"] ?>');"><img src="./70x/<?=$row["image"] ?>" alt="<?=$row["name"] ?>" style="width:70px;height:auto;"></a></a>

如何将名称和时间戳记入数据库？ :-/

Answer 1

首先感谢 Maze Runner 提供的 ajax 处理的主要代码。这就是我为使其正常工作且安全所做的工作。

这是玩家页面中的代码 CREDIT TO Maze Runner

function changeVideo(filename,name) {
// here is the ajax call
xmlhttp=new XMLHttpRequest();
xmlhttp.open("GET","infoSaver.php?name=" + name,true);
xmlhttp.send();

var vlc = document.getElementById("tv");
var options = [":http-user-agent=Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25"]; 
var URL = filename;
var AddVid = vlc.playlist.add(URL, "", options);
vlc.playlist.playItem(AddVid);
}

这是我的 infoSaver.php 代码

if (isset($_GET['id']) && is_numeric($_GET['id']))  {
$id = $_GET['id'];
  //check if id is vallid
$query1 = mysqli_query($db, "select * from channels WHERE active=1 AND `playid` = '$id' LIMIT 1");
while($row = mysqli_fetch_assoc($query1))   
{
$playid = $row["playid"];
}
if ($id == $playid) {
  // get the rest of the info
$ip = $_SERVER['REMOTE_ADDR'];
$time = time();
  // get name from DB
$query1 = mysqli_query($db, "select * from channels WHERE active=1 AND `playid` = '$id' LIMIT 1");
while($row = mysqli_fetch_assoc($query1))   
{
$name = $row["name"];
}
  // insert the entry
$query = mysqli_query($db, "INSERT INTO log (chname, chid, ip, time)
VALUES ('$name', '$id', '$ip', '$time')");
} else {
    echo '<p>The Id is not vallid</p>';
} 
} else {
    echo '<p>This page is protected</p>';
}

非常感谢您的帮助!你们是最棒的! <3