在我的项目(deckbuilder(上,我将卡片推送到名为$scope.decks的表中,一切正常,但我想将甲板插入数据库。有没有简单的方法来实现它?
它看起来像这样(它只是我的练习文件(:
$scope.deckCount = 0;
$scope.deck= [];
$scope.saveDeck= function()
{
var newDeck= [];
if($scope.deckCount === 5)
{
newDeck.push({"talia": $scope.deck});
console.log(newDeck)
}
else
{
alert("There is no 5 cards in deck");
}
};
$scope.showDeck= function()
{
document.getElementById("saved deck").innerHTML = "Twoja talia: "+ $scope.deck;
};
来自浏览器的图片
威布兰·卡蒂 = 选择卡
这是一个 Angular/PHP/MySQL 教程,其中包含您需要的一切:
使用AngularJS PHP MySQL的简单任务管理器应用程序
您显然需要根据代码调整他们的示例。
$scope.addTask = function (task) { $http.post("ajax/addTask.php?task="+task).success(function(data){ getTask(); $scope.taskInput = ""; }); };
<?php require_once '../includes/db.php'; // The mysql database connection script if(isset($_GET['task'])){ $task = $_GET['task']; $status = "0"; $created = time(); $query="INSERT INTO tasks(task,status,created_at) VALUES ('$task', '$status', '$created')"; $result = $mysqli->query($query) or die($mysqli->error.__LINE__); $result = $mysqli->affected_rows; echo $json_response = json_encode($result); } ?>
CREATE DATABASE IF NOT EXISTS angularcode_task; USE angularcode_task; -- Table structure for table `tasks` CREATE TABLE IF NOT EXISTS `tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `task` varchar(200) NOT NULL, `status` int(11) NOT NULL, `created_at` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- Insert some data for table `tasks` INSERT INTO `tasks` (`id`, `task`, `status`, `created_at`) VALUES (1, 'My first task', 0, 1390815970), (2, 'Perform unit testing', 2, 1390815993), (3, 'Find bugs', 2, 1390817659), (4, 'Test in small devices', 2, 1390818389);