使用AJAX和PHP将数据保存到数据库 [英] Saving data to database using AJAX and 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将数据保存到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！