Retrieve database data using PHP and AJAX

Question

I am trying to retrieve data from database using AJAX without any success. These are the codes I am using. I dont see any specific errors in console.

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 content:

<?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 has connections details:

<?php

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

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

?>

Can someone guide me how to resolve the issue

You just need to echo your data from your PHP file.

Vincent Decaux
– Vincent Decaux

2018-10-22 11:30:26 +00:00
Commented Oct 22, 2018 at 11:30 — Vincent Decaux
– Vincent Decaux, Commented Oct 22, 2018 at 11:30
write echo $TotIncome;exit(); and it will work

Bhargav Chudasama
– Bhargav Chudasama

2018-10-22 11:31:28 +00:00
Commented Oct 22, 2018 at 11:31 — Bhargav Chudasama
– Bhargav Chudasama, Commented Oct 22, 2018 at 11:31
echo is not working

acr
– acr

2018-10-22 11:45:33 +00:00
Commented Oct 22, 2018 at 11:45 — acr
– acr, Commented Oct 22, 2018 at 11:45

Vincent Decaux · Accepted Answer · 2018-10-22 11:32:58Z

3

You need to echo your data from your PHP file :

$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;

answered Oct 22, 2018 at 11:32

Vincent Decaux

10.9k7 gold badges67 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

acr Over a year ago

No luck with it. I dont see any errors also in console

Vincent Decaux Over a year ago

Try to call your Income.php directly in your navigator. It must echo the response.

acr Over a year ago

It looks like button click function $('#result_submit').click(function() not triggering. I tried to put a alert box but not getting any output

acr Over a year ago

do I need to add an onclick function along with button and change jquery ?

acr Over a year ago

Found the issue. I mentioned complete path of Income.php and its working as expected. I saw some thread on how to use url on wordpress site. thanks for you r help

Paweł Miłosz · Accepted Answer · 2018-10-22 13:23:13Z

0

First off all add on the beginig of page:

error_reporting(E_ERROR | E_WARNING | E_PARSE); ini_set('error_reporting', E_ALL);

and printf("Errormessage: %s\n", mysqli_error($income_sum));

afther query to db. Do you have any respons from the page called by ajax?

answered Oct 22, 2018 at 13:23

Paweł Miłosz

1091 silver badge7 bronze badges

Comments

Magnesium · Accepted Answer · 2018-10-22 11:32:42Z

-1

The script that you call using AJAX doesn't render anything.

echo $TotIncome;

answered Oct 22, 2018 at 11:32

Magnesium

6079 silver badges25 bronze badges

2 Comments

Bhargav Chudasama Over a year ago

its already given in comment so why you should use as answer.if you have different things than write here

Magnesium Over a year ago

SO is a question/answer website. A comment is not an answer, it is useful if you need aditionnal infos to solve the problem. If you know the solution, just post an answer...

Collectives™ on Stack Overflow

Retrieve database data using PHP and AJAX

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related