如何使用 angular.js PHP 显示来自 mysql 的数据?
[英] How to display data from mysql using angular.js PHP?
本文介绍了如何使用 angular.js PHP 显示来自 mysql 的数据?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如何使用 angular.js PHP 打印从 mysql 收到的数据.我想知道如何连接mysql和angular.js
我尝试使用 node.js mongodb.但想了解 php,mysql,angular.js
解决方案
您好，可以查看以下示例代码吗您的 HTML 页面:
<头><title>AngularJs 帖子示例:DevZone.co.in </title><script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.0.7/angular.min.js"></script><风格>#dv1{边框:1px 实心 #DBDCE9;左边距:自动；边距右:自动；宽度:220px；边框半径:7px；填充:25px；}.信息{边框:1px 实心；边距:10px 0px；填充:10px；颜色:#00529B；背景颜色:#BDE5F8；列表样式:无；}.呃{边框:1px 实心；边距:10px 0px;填充:10px；颜色:#D8000C；背景色:#FFBABA；列表样式:无；}</风格><身体><div id='dv1'><form ng-controller="FrmController"><ul><li class="err" ng-repeat="error in errors">{{ 错误}} </li><ul><li class="info" ng-repeat="msg in msg">{{ msg}} </li><h2>注册表格</h2><div><label>名称</label><input type="text" ng-model="username" placeholder="用户名" style='margin-left: 22px;'>
<div><label>电子邮件</label><input type="text" ng-model="useremail" placeholder="Email" style='margin-left: 22px;'>
<div><label>密码</label><input type="password" ng-model="userpassword" placeholder="密码">
<button ng-click='SignUp();'style='margin-left: 63px;margin-top:10px'>SignUp</button></表单>
<script type="text/javascript">函数 FrmController($scope, $http) {$scope.errors = [];$scope.msgs = [];$scope.SignUp = function() {$scope.errors.splice(0, $scope.errors.length);//删除所有错误信息$scope.msgs.splice(0, $scope.msgs.length);$http.post('post_es.php', {'uname': $scope.username, 'pswd': $scope.userpassword, 'email': $scope.useremail}). 成功(功能(数据，状态，标题，配置){如果(数据.味精！= ''){$scope.msgs.push(data.msg);}别的{$scope.errors.push(data.error);}}).error(function(data, status) {//发生错误时异步调用//或者服务器返回带有错误状态的响应.$scope.errors.push(status);});}}<a href='http://devzone.co.in'>Devzone.co.in</a></html>///////////////////////////////////////////////////////////////////////你的php代码<?php$data = json_decode(file_get_contents("php://input"));$usrname = mysql_real_escape_string($data->uname);$upswd = mysql_real_escape_string($data->pswd);$uemail = mysql_real_escape_string($data->email);$con = mysql_connect('localhost', 'root', '');mysql_select_db('test', $con);$qry_em = 'select count(*) as cnt from users where email ="' . $uemail . '"';$qry_res = mysql_query($qry_em);$res = mysql_fetch_assoc($qry_res);如果 ($res['cnt'] == 0) {$qry = 'INSERT INTO users (name,pass,email) values ("'.$usrname.'","'.$upswd.'","'.$uemail.'")';$qry_res = mysql_query($qry);如果($qry_res){$arr = array('msg' => "用户创建成功！！！", 'error' => '');$jsn = json_encode($arr);打印_r($jsn);} 别的 {$arr = array('msg' => "", 'error' => '插入记录时出错');$jsn = json_encode($arr);打印_r($jsn);}} 别的 {$arr = array('msg' => "", 'error' => '用户已经存在相同的电子邮件');$jsn = json_encode($arr);打印_r($jsn);}?>
请检查上面的代码，你就会明白它是如何工作的.如果您遇到任何问题，请在评论行中告诉我
How to print data recieved from mysql using angular.js PHP.
I want to know how to connect with mysql and angular.js
I tried with node.js mongodb. but wants to know about php,mysql,angular.js
解决方案
Hi Can you check following sample code
your HTMLpage :
<html ng-app>
<head>
<title>AngularJs Post Example: DevZone.co.in </title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.0.7/angular.min.js"></script>
<style>
#dv1{
border:1px solid #DBDCE9; margin-left:auto;
margin-right:auto;width:220px;
border-radius:7px;padding: 25px;
}
.info{
border: 1px solid;margin: 10px 0px;
padding:10px;color: #00529B;
background-color: #BDE5F8;list-style: none;
}
.err{
border: 1px solid; margin: 10px 0px;
padding:10px; color: #D8000C;
background-color: #FFBABA; list-style: none;
}
</style>
</head>
<body>
<div id='dv1'>
<form ng-controller="FrmController">
<ul>
<li class="err" ng-repeat="error in errors"> {{ error}} </li>
</ul>
<ul>
<li class="info" ng-repeat="msg in msgs"> {{ msg}} </li>
</ul>
<h2>Sigup Form</h2>
<div>
<label>Name</label>
<input type="text" ng-model="username" placeholder="User Name" style='margin-left: 22px;'>
</div>
<div>
<label>Email</label>
<input type="text" ng-model="useremail" placeholder="Email" style='margin-left: 22px;'>
</div>
<div>
<label>Password</label>
<input type="password" ng-model="userpassword" placeholder="Password">
</div>
<button ng-click='SignUp();' style='margin-left: 63px;margin-top:10px'>SignUp</button>
</form>
</div>
<script type="text/javascript">
function FrmController($scope, $http) {
$scope.errors = [];
$scope.msgs = [];
$scope.SignUp = function() {
$scope.errors.splice(0, $scope.errors.length); // remove all error messages
$scope.msgs.splice(0, $scope.msgs.length);
$http.post('post_es.php', {'uname': $scope.username, 'pswd': $scope.userpassword, 'email': $scope.useremail}
).success(function(data, status, headers, config) {
if (data.msg != '')
{
$scope.msgs.push(data.msg);
}
else
{
$scope.errors.push(data.error);
}
}).error(function(data, status) { // called asynchronously if an error occurs
// or server returns response with an error status.
$scope.errors.push(status);
});
}
}
</script>
<a href='http://devzone.co.in'>Devzone.co.in</a>
</body>
</html>
////////////////////////////////////////////////////////////////////////
Your php code
<?php
$data = json_decode(file_get_contents("php://input"));
$usrname = mysql_real_escape_string($data->uname);
$upswd = mysql_real_escape_string($data->pswd);
$uemail = mysql_real_escape_string($data->email);
$con = mysql_connect('localhost', 'root', '');
mysql_select_db('test', $con);
$qry_em = 'select count(*) as cnt from users where email ="' . $uemail . '"';
$qry_res = mysql_query($qry_em);
$res = mysql_fetch_assoc($qry_res);
if ($res['cnt'] == 0) {
$qry = 'INSERT INTO users (name,pass,email) values ("' . $usrname . '","' . $upswd . '","' . $uemail . '")';
$qry_res = mysql_query($qry);
if ($qry_res) {
$arr = array('msg' => "User Created 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);
}
} else {
$arr = array('msg' => "", 'error' => 'User Already exists with same email');
$jsn = json_encode($arr);
print_r($jsn);
}
?>
Please checkthe above code you will be understand how it will work. If any problem you are facing just tell me here in comment line
这篇关于如何使用 angular.js PHP 显示来自 mysql 的数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
