Error with create CSV in server with PHP

Question

I have code to create a CSV file with SQL query data and then I send it by email.

function create_csv_string($data) {
    mysql_connect("xxxx", "xxxx", "xxxx");
    echo mysql_error();
    mysql_select_db("xxxxx");
    $data = mysql_query("SELECT NOMBRE, TELEFONO, HORARIO, EMAIL FROM _LEADS WHERE ENVIADO = 0");
    echo mysql_error();
    if (!$fp = fopen('php://temp', 'w+')) {
        return FALSE;
    } else {
        echo "entra";
    }
    fputcsv($fp, array('Nombre', 'Telefono', 'Horario', 'Email'));
    while ($line = mysql_fetch_assoc($data)) fputcsv($fp, $line);
    rewind($fp);
    return stream_get_contents($fp);
}

My problem is that I executing this in local and it works, but I upload it to a server and it doesn't work. I think that the problem is in !$fp = fopen('php://temp', 'w+')) but I am not sure.

Please do not use mysql_* functions, as they are deprecated and removed. Try using mysqli_* or PDO. — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented Jun 9, 2016 at 10:15
The problem seems to be in MySQL Server and the file permissions. Can you set the permissions as 777 just for a moment and check? You can use something like chmod -R 777 /var/www or something. — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented Jun 9, 2016 at 10:15
Have you tried by giving filename with path in fopen function? — Sachin I
– Sachin I, Commented Jun 9, 2016 at 10:19
Ok, I change mysql_* to mysqli_* later. How I can change permissions?? Like this? if (!$fp = fopen('php://temp', '777')) { sorry I am rookie in php.. @PraveenKumar — oihi08
– oihi08, Commented Jun 9, 2016 at 10:20

Praveen Kumar Purushothaman · Accepted Answer · 2016-06-09 11:33:04Z

1

You need to do something like this:

<?php
    function create_csv_string() {
        echo "entssssra?";
        $connection = mysqli_connect("**","**","**","**") or die("Cannot Connect to MySQL Server");
        $data = mysqli_query($connection, "SELECT NOMBRE, TELEFONO, HORARIO, EMAIL FROM _LEADS WHERE ENVIADO = 0");
        // Build the CSV:
        $csv = "'Nombre', 'Telefono', 'Horario', 'Email'" . PHP_EOL;
        while (false != ($line = mysqli_fetch_assoc($data)))
            $csv .= array_values($line);
        echo $csv;
        return file_put_contents('temp.csv', $csv);
    }

And you don't need the $data as a parameter.

answered Jun 9, 2016 at 11:33

Praveen Kumar Purushothaman

167k27 gold badges215 silver badges261 bronze badges

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

Collectives™ on Stack Overflow

Error with create CSV in server with PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related