使用php和ajax检索数据库数据

but5z9lq  于 2021-06-19  发布在  Mysql
关注(0)|答案(3)|浏览(355)

我尝试使用ajax从数据库检索数据,但没有成功。这些是我正在使用的代码。我没有看到任何具体的错误控制台。
html格式:

<button type="button" name="result_submit" id="result_submit" >Submit</button>
<div class="result" id="result" name="result"> </div>

jquery查询:

$(document).ready(function(e) {
    $('#result_submit').click(function() {

        $.ajax({
            url  :"Income.php",
            type :'POST',
            success: function(data){
                $("#result").html(data);
            }
        });
    }); 
});

income.php内容:

<?php

include_once 'dbConnection.php';

$stmt = mysqli_stmt_init($conn);

$income = "select SUM(amount) as incomeNumber FROM wp_formdata WHERE entry_type='Income'";

    if(!mysqli_stmt_prepare($stmt,$income)) 

        {
            $message =  '<h1 style="color:red;padding-top:5%;">SQL Error !!</h1>';
        } 
        else 
        {
            mysqli_stmt_execute($stmt);
            $result= mysqli_stmt_get_result($stmt);
            $income_sum=mysqli_fetch_assoc($result); 
            $TotIncome= "Total Income is ".$income_sum['incomeNumber'];
        }
?>

dbconnection.php包含连接详细信息:

<?php

$dbServername = "localhost";    
$dbUsername = "root";
$dbPassword = "";
$dbName = "wordpress";

$conn= mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);

?>

有人能指导我如何解决这个问题吗

xbp102n0

xbp102n01#

你需要 echo php文件中的数据:

$income = "select SUM(amount) as incomeNumber FROM wp_formdata WHERE entry_type='Income'";
$response = '';

if (! mysqli_stmt_prepare($stmt,$income)) {
     $response = '<h1 style="color:red;padding-top:5%;">SQL Error !!</h1>';
} else {
     mysqli_stmt_execute($stmt);
     $result = mysqli_stmt_get_result($stmt);
     $income_sum = mysqli_fetch_assoc($result); 
     $response = "Total Income is ".$income_sum['incomeNumber'];
}

echo $response;
6xfqseft

6xfqseft2#

使用ajax调用的脚本不会呈现任何内容。

echo $TotIncome;
ruyhziif

ruyhziif3#

首先在页面开头添加:
错误|报告(e |错误| e |警告| e |解析);ini\u set('错误报告',e\u all);
和printf(“errormessage:%s\n”,mysqli_error($income_sum));
查询到数据库后。你对ajax调用的页面有什么React吗?

相关问题