通过Angularjs和PHP使用id向特定帖子添加评论

Question

我是Angular的新手，正在努力为从数据库中显示的特定帖子添加评论。在帖子下面，我有一个隐藏的评论区，当按下按钮时会显示出来。然后我想能够添加评论到帖子的评论区是附加的。它似乎没有得到id，但我找不到如何解决它。它正在显示/隐藏，而我在控制台日志中插入了“数据”，所以我猜问题出在PHP？

角码

app.controller('meetings', function($scope, $http) {
$scope.meetings_insertdata = function() {
$http.post ("meetings_insert.php",{'meetings_commentdate':$scope.meetings_commentdate,'meetings_comment':$scope.meetings_comment})
window.location.reload();
console.log("data inserted");
    };
});



app.controller('show_hide', function ($scope) {
            $scope.Hidden = true;
            $scope.ShowHide = function () {
                $scope.Hidden = $scope.Hidden ? false : true;
            }

   });

meetings_insert.php

<?php

$data = json_decode(file_get_contents("php://input"));
$meetings_comment = $data->meetings_comment;
$meetings_commentdate = date('Y-m-d H:i:s');
$meetings_entry = $_GET['id'];

mysql_connect("localhost","user","password");
mysql_select_db("mdb_rh316");



mysql_query("UPDATE project_meetings SET (meetings_comment, meetings_commentdate) = ('$meetings_comment','$meetings_commentdate') WHERE meetings_entry = '$meetings_entry'");

?>

HTML代码

<div class="entrybox" ng-controller="meetings">
<?php 
mysql_connect("localhost","user","password");
mysql_select_db("mdb_rh316");

$result = mysql_query("SELECT * FROM project_meetings ORDER BY meetings_date DESC");
while ($row = mysql_fetch_array($result))
{
echo "<table>";
        echo "<tr><td>" ?>Added: <? echo $row['meetings_date'] . $row['meetings_entry'] . "<br/>" . $row['meetings_content']."</td></tr>";
        echo "<tr><td>" ?><br/><span class="emp">Comment: <?
        echo $row['meetings_commentdate']."<br/>" . $row['meetings_comment']."</td></tr>";
        echo "<tr><td>"?></span>
        <div ng-controller="show_hide">
        <input type="button" class="previous_add" value="Add comment" ng-click="ShowHide()" />
        <br />
        <br />
        <div ng-hide = "Hidden">
<form method="post" action="meetings_insert.php?id=<? echo $row['$meetings_entry']?>"> 
<textarea class="textarea" placeholder="Add your comment here.." type="text" ng-model="meetings_comment" name="meetings_comment"></textarea><br/>
<input type="button" class="button" value= "Add" ng-click="meetings_insertdata()"/>
</form>
        </div>
    </div>
</td></tr><br/><?;

}

echo "</table>";
?>
</div>

Answer 1

将'id‘传递给meetings_insertdata函数：

​

<form method="post" action="">
  <textarea class="textarea" placeholder="Add your comment here.." type="text" ng-model="meetings_comment" name="meetings_comment"></textarea>
  <br/>
  <input type="button" class="button" value="Add" ng-click="meetings_insertdata(<? echo $row['$meetings_entry']?>)" />
</form>

​

在下面的AngularJS函数中接收它：

app.controller('meetings', function($scope, $http) {
  $scope.meetings_insertdata = function(id) {
    $http.post("meetings_insert.php", {
      'meetings_commentdate': $scope.meetings_commentdate,
      'meetings_comment': $scope.meetings_comment,
      'meetings_event': id
    })
    window.location.reload();
    console.log("data inserted");
  };
});

​

然后，从发布的值中选取'id‘($data->meetings_event)

$data = json_decode(file_get_contents("php://input"))；

$meetings_comment = $data->meetings_comment；

$meetings_commentdate = date('Y-m-d H:i:s')；

$meetings_entry =$data->会议事件；