Levan Levan - 1 month ago 11
PHP Question

Php/Mysql Export data from two tables

I need to export data from two tables Php/Mysql to Excel or CSV file. I try with Union All but I get data in one cell I need next format:

Name: Age (from another table)
Levan 22
Dito 35
Giorgi 46


I receive next:

Name:
Levan
Dito
Giorgi
22
35
46




<?php
header("Content-type: text/csv; charset=UTF-8");
header('Content-Disposition: attachment; filename=Export.csv');

//connection
$con = mysql_connect('localhost', 'user', 'pass');
if(!$con) {
echo "Error connection";
}

//select db
$select_db = mysql_select_db('database', $con);
if(!$select_db) {
echo "Error to select database";
}

mysql_set_charset("utf8", $con);

//Mysql query to get records from datanbase
$user_query = mysql_query('SELECT Amount FROM Credit UNION ALL SELECT username FROM User');

//While loop to fetch the records
$contents = "Amount \t username\n";
while($row = mysql_fetch_array($user_query)) {
$contents.=$row['Amount']."\t";
$contents.=$row['username']."\n";
}

$contents_final = chr(255).chr(254).mb_convert_encoding($contents, "UTF-16LE","UTF-8");
print $contents_final;
?>

Answer

SELECT Credit.Amount, User.username FROM Credit INNER JOIN Users ON Credit.username = Users.username

The problem was the user columns were different in each table

credit->UserID User: username

try this:

SELECT Credit.Amount, User.username FROM Credit INNER JOIN Users ON Credit.UserID = Users.username