php - Angularjs 发布到 SQL 服务器

Question

我的 post php 文件有一个小问题。我将其发布到我的数据库中，但我不知道如何从 angularjs 获取玩家的名字。

$scope.addPlayer = function (playerName){

    alert(playerName);

    $http.post("insert.php",{'Name': playerName})
        .success(function(data, status, headers, config){
            console.log(status);
        });
  };

这是我的 php

<?php
$servername = "localhost";
$username = "username";
$password = "pswrd";
$dbname = "db_name";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO Pelaaja (Name, Games, Penalty, Alc, Wins, Red, Blue, Yellow, Green, Color)
VALUES (Name, '0', '0', '0', '0', '0', '0', '0', '0', 'No color')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

那么我应该如何获得这个名字呢？

Answer 1

在 php 文件中获取您的帖子值，例如

$name = $_POST['Name'];

$sql = "INSERT INTO Pelaaja (Name, Games, Penalty, Alc, Wins, Red, Blue, Yellow, Green, Color)
VALUES ('$name', '0', '0', '0', '0', '0', '0', '0', '0', 'No color')";