Getting error in exported csv file format using php

Question

I have used below code to save data in csv format from my page. After saving i have got some extra line in my csv file . How i will remove it i need refer for this.

$connection=mysql_connect($host, $uname, $pass); 

echo mysql_error();

//or die("Database Connection Failed");
$selectdb=mysql_select_db($database) or 
die("Database could not be selected"); 
$result=mysql_select_db($database)
or die("database cannot be selected <br>");

// Fetch Record from Database

$output = "";
$table = "tbl_record"; // Enter Your Table Name 
$sql = mysql_query("select * from $table");
$columns_total = mysql_num_fields($sql);

// Get The Field Name

for ($i = 0; $i < $columns_total; $i++) {
    $heading = mysql_field_name($sql, $i);
    $output .= '"'.$heading.'",';
}
$output .="\n";

// Get Records from the table

while ($row = mysql_fetch_array($sql)) {
    for ($i = 0; $i < $columns_total; $i++) {
        $output .='"'.$row["$i"].'",';
    }
    $output .="\n";
}

// Download the file

$filename = "myFile.csv";
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);

echo $output;
exit;

?>

here is the below screenshot for output value

output csv file

the red mark are unwanted line.

Don't use mysql_ functions. Use mysqli or PDO an you'll be ok — Brewal
– Brewal, Commented Jan 23, 2015 at 14:31
if i use mysqli then i get this error msg...Call to undefined function mysqli_field_name()....what can i use here replacing anyone...please refer to me...Thanks for your comment — Sazal Ahmed
– Sazal Ahmed, Commented Jan 23, 2015 at 15:26
It is not just about adding a i. It is a completly different library : php.net/manual/en/book.mysqli.php — Brewal
– Brewal, Commented Jan 23, 2015 at 15:29

Saqueib · Accepted Answer · 2015-01-24 04:21:55Z

1

its a warning that mysql_* is deprecated, dont use it. Use PDO, a quick fix will be

//Put on top
error_reporting(E_ERROR | E_PARSE);

this will suppress the warnings, here is a good getting starting read of PDO

Update

To get the Fields Name in CSV using mysqli you will need to change this code

Change this to

// Get The Field Name
for ($i = 0; $i < $columns_total; $i++) {
      $heading = mysql_field_name($sql, $i);
      $output .= '"'.$heading.'",';
}
$output .="\n";

This

while ($finfo = mysqli_fetch_field($result)) {
    $heading = $finfo->name;
    $output .= '"'.$heading.'",';
}

Enabling mysqli_*

Check your php.ini for extension=mysqli.so or similar. it may be commented out using a # just uncomment it.

Enabling PDO

On a windows server you can add the following lines in your php.ini

extension=php_pdo.dll
extension=php_pdo_mysql.dll

On a Linux server you can compile php with the following option --with-pdo-mysql In your php.ini, add the following lines

extension=pdo.so
extension=pdo_mysql.so

edited Jan 24, 2015 at 4:21

answered Jan 23, 2015 at 14:33

Saqueib

3,5184 gold badges36 silver badges58 bronze badges

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

3 Comments

Sazal Ahmed Over a year ago

if i use mysqli then i get this error msg...Call to undefined function mysqli_field_name()....what can i use here replacing anyone...please refer to me...Thanks for your comment

Saqueib Over a year ago

use mysqli_fetch_field( $result ) see the docs

Sazal Ahmed Over a year ago

Thank you Saqueib...i have used it....unwanted extra line has been removed...but no field name in the csv file....only there is a name Array...

Stijn Bernards · Accepted Answer · 2015-01-23 14:32:10Z

0

You're using depricated functions and it's generating warning as you can see.

Use error_reporting(0); to turn of all error reporting.

I also advice not to use _mysql but use PDO

answered Jan 23, 2015 at 14:32

Stijn Bernards

1,09111 silver badges29 bronze badges

Collectives™ on Stack Overflow

Getting error in exported csv file format using php

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related