Echo the result of a mysql query on PHP

Question

0.00/5 (No votes)

See more:

Hello Good day.

I have a mysql query which returns the sum of values on a table.

PHP

357  $conn = mysqli_connect($servername, $username, $password, $dbname);
358  
359  SELECT FORMAT(SUM(Total_Amount),0) FROM(
360      (SELECT SUM(assign_inventory.`quantity` * assign_inventory.`price`) AS 'Total_Amount'
361      FROM assign_inventory WHERE assign_inventory.`project` = 'Apongbon Shopping Mall')
362      UNION ALL
363  	(SELECT SUM(contrator_payments.`amount`) AS 'Total_Amount'
364      FROM contrator_payments WHERE contrator_payments.`project_name` = 'Apongbon Shopping Mall')
365  	UNION ALL
366  	(SELECT SUM(petty_cash_expenses.`amount`) AS 'Total_Amount'
367      FROM petty_cash_expenses WHERE petty_cash_expenses.`project` = 'Apongbon Shopping Mall'))as Total_Amount;<pre>";?>
368  											<?php 	$result = mysqli_query($conn,$query); 
369  $data = mysqli_fetch_assoc($result);
370  echo $data;?

What I have tried:

I try to echo the result but I get the error "

( ! ) Notice: Array to string conversion in C:\wamp64\www\bosmak_properties\project_cost_details.php on line 370

Line 370 is the echo $data line.

Posted 24-Nov-20 10:03am

akynyemi

Updated 25-Nov-20 1:02am

Richard Deeming

v3

Add a Solution

Comments

Richard MacCutchan 25-Nov-20 5:22am

You cannot use echo on anything other than simple strings. You need to echo each individual item in the returned data.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

W∴ Balboos, *GHB* · Answer 1 · 2020-11-25T01:02:00

Returns from SQL queries, even if only a single value, are arrays.

The first element in your $data return, then, is $data[0], or, if you have the filed name, as in an associative array, $data['Total_Amount']

printr(), as in the previous answer, is useful in that you can see what the array is sending back and that is useful for at least two points:
1) it let's you see the extent of the data (or none!) without having to know details, even if it's a multi-dimensional array.
2) you have the correct indices for the values, not the least important of which is the name (if associative), the index, if not, or both if you grab it all. Including correct spelling and capitalization.

So the error's telling you precisely this: you want to echo an array (an object) and there's no rules for that.

Member 13178297 · Answer 2 · 2020-11-24T17:05:00

Solution 1

Have you tried print_r($data);

Posted 24-Nov-20 17:05pm

Member 13178297

Comments

akynyemi 25-Nov-20 3:51am

Thanks @13178297. I have tried print_r($data); but it returns the required value but also shows =>FUNCTIONS(SUM(5,813,617) along with it which I do not want displayed.