Php / Mysql从两个表中导出数据

时间:2022-03-16 15:41:49

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:

我需要将数据从两个表Php / Mysql导出到Excel或CSV文件。我尝试使用Union All,但我在一个单元格中获取数据,我需要下一个格式:

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

1 个解决方案

#1


0  

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

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

The problem was the user columns were different in each table

问题是每个表中的用户列不同

credit->UserID User: username

credit-> UserID用户:用户名

try this:

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

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

#1


0  

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

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

The problem was the user columns were different in each table

问题是每个表中的用户列不同

credit->UserID User: username

credit-> UserID用户:用户名

try this:

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

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