本文介绍了使用AJAX和PHP将数据保存到数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨! 我目前正在使用PHP,AJAX和BOOTSTRAP Modal做一个小项目。我的代码工作正常,但有时数据保存两次,我不知道为什么。 关于如何解决这个问题的任何想法?提前谢谢。 我的尝试: AJAX
Hi! I'm currently doing a small project using PHP, AJAX and BOOTSTRAP Modal. My code is working fine but sometimes the data save twice and I don't know why. Any ideas on how to solve this problem? Thank you in advance. What I have tried: AJAX
$(document).ready(function(){ fetch(); //ADD $('#AddStocks').click(function(){ $('#AddStocksModal').modal('show'); }); $('#addFormstocks').submit(function(e){ e.preventDefault(); var addform = $(this).serialize(); $.ajax({ method: 'POST', url: 'functions/add_stocks_submit.php', data: addform, dataType: 'json', success: function(response){ $('#AddStocksModal').modal('hide'); $(this).find('form').trigger('reset'); if(response.error){ $('#alert').show(); $('#alert_message').html(response.message); } else{ $('#alert').show(); $('#alert_message').html(response.message); fetch(); } } }); }); //PHP
PHP
<?php include_once('../connection/pdo_db_connection.php'); $assettagad = $_POST['assettagad']; $output = array('error' => false); $database = new Connection(); $db = $database->open(); if(!isset($error)) { $stmt = $db->prepare("SELECT asset_tag FROM sys_stocks WHERE asset_tag = ?"); $stmt->execute(array($assettagad)); $row_count = $stmt->rowCount(); if ($row_count > 0){ $output['message'] = 'Asset Tag is already exist!'; } else { $sql = "INSERT INTO sys_stocks (asset_tag, particulars, status) VALUES ((UPPER('".$_POST["assettagad"]."')), (UPPER('".$_POST["particularad"]."')), (UPPER('".$_POST["hstatstocks"]."')))"; ($db->query($sql)); $output['message'] = 'Stock added successfully!'; } } //close connection $database->close(); echo json_encode($output); ?>推荐答案
( document )。ready( function (){ fetch(); // ADD (document).ready(function(){ fetch(); //ADD
( #AddStocks')。click( function (){ ('#AddStocks').click(function(){
(' #AddStocksModal')。modal(' show'); }); ('#AddStocksModal').modal('show'); });
更多推荐
使用AJAX和PHP将数据保存到数据库
发布评论