与AngularJS和PHP将数据保存到数据库 [英] Saving data to DB with AngularJS and PHP

问题描述

所以我在新的角度，从来没有取得到一个数据库和PHP通过角连接。我的角度设置好。该数据是未来通过，但我似乎无法将它保存到我的数据库

So i am new at Angular and never have made a connection to a DB with PHP via Angular. My angular setup is good. The data is coming through but i cannot seem to save it to my DB

这是我的code为HTML：

This is my code for the html:

<form ng-controller="AppCtrl" name="add_user">
            <div class="modal-header">
                <h3 class="modal-title">Add a user by sending an invite via e-mail</h3>
            </div>
            <div class="modal-body">
                <input type="text" class="form-control" name="user_email" ng-model="user_name" placeholder="Enter a name">
                    <br />
                <input type="text" class="form-control" name="user_name" ng-model="user_email" placeholder="Enter an e-mail adress">
            </div>
            <div class="modal-footer">
                <!-- <button type="" class="btn btn-success" ng-click="add_user()">Invite</button> -->
                <input type="button" class="btn btn-success" name="add_user" value="Invite" ng-click="save_user()">
                <button class="btn btn-warning">Cancel</button>
            </div>
    </form>

这是我的app.js code：

This is my app.js code:

var app = angular.module('AddUser', []);

app.controller('AppCtrl', function($scope, $http){

$scope.save_user = function() {

    $http.post('db.php?action=add_user', 
        {
            'user_name'  : $scope.user_name, 
            'user_email' : $scope.user_email
        }
    )

    .success(function (data, status, headers, config) {
        console.log("The user has been added successfully to the DB");
        console.log(data);
    })

    .error(function(data, status, headers, config) {
        console.log("Failed to add the user to DB ");
    });
}

});

这是我的PHP code：

And this is my php code:

<?php 
include('config.php');

//echo ('test' . $_GET['action']);
switch($_GET['action'])  {
    case 'add_user' :
        add_user(); 
        break;
}

/**  Function to add user to db **/
function add_user() {

    $data = json_decode(file_get_contents("php://input")); 
    $user_name      = $data->user_name;    
    $user_email     = $data->user_email;

   print_r($data);

    $qry = 'INSERT INTO tblUser(user_name, user_email) VALUES ("' . $user_name  . '","' . $user_email . ')';

    echo ($qry);

    $qry_res = mysql_query($qry);
    if ($qry_res) {
        $arr = array('msg' => "User added successfully!!!", 'error' => '');
        $jsn = json_encode($arr);
        // print_r($jsn);
    } 
    else {
        $arr = array('msg' => "", 'error' => 'Error in inserting record');
        $jsn = json_encode($arr);
        // print_r($jsn);
    }
}

？>

如果任何人可以点我在正确的方向，我真的AP preciate它

If any one can point me in the right direction i would really appreciate it

推荐答案

您错过在插入SQL上的电子邮件结束的双引号。

You're missing a closing double quotes on your email on the insert SQL.

应该是;

$ QRY ='INSERT INTO tblUser（USER_NAME，USER_EMAIL）VALUES（'$ USER_NAME。'，'$ USER_EMAIL。'）';

这篇关于与AngularJS和PHP将数据保存到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！