使用PHP将MySQL数据导出到.csv [英] Export MySQL data to .csv using PHP

问题描述

我正在将数据导出到.csv文件，并且工作正常，但是我有一个小问题.我从表中获取name和gender，但是出于性别原因，我将id保存在数据库中(即1 = Male，2 = Female).我下面的代码为我提供了性别ID，该如何解决?男性返回1，女性返回2:

I'm exporting data to a .csv file and it's working perfectly but I have one small issue. I fetch name and gender from a table but for gender I save id in my database (i.e., 1 = Male, 2 = Female). My below code gives me id for gender, how can I fix it? Return 1 for Male and 2 for Female:

$rows = mysql_query("SELECT `name`, `gender` FROM TABLE");

while ($row = mysql_fetch_assoc($rows)) {
    fputcsv($output, $row);
}

推荐答案

尝试一下:

$rows = mysql_query("SELECT `name`, `gender` FROM TABLE");

while ($row = mysql_fetch_assoc($rows)) {

    if($row['gender'] == 1) {
        $row['gender'] = 'Male'; 
    } else {
        $row['gender'] = 'Female'; 
    }

    // Or ternary condition
    // $row['gender'] = ($row['gender'] == 1 ? 'Male' : 'Female');

    fputcsv($output, $row);
}

这篇关于使用PHP将MySQL数据导出到.csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！