how to export data from mysql using php -

i wanted fetch data database , data downloadable in text format.

for using

<?php $filename="abc.txt"; header("content-disposition: attachment; filename=\"$filename\""); header("content-type: text/csv"); echo "php awesome"; ?> 

the above code providing option download file.

but when trying add database connection in code time not getting download option. need solve above problem.

my error code:

<?php $filename="abc.txt"; header("content-disposition: attachment; filename=\"$filename\""); header("content-type: text/csv"); $name="jone": $db_host =hostname; $db_user =username; $db_pass =password; echo "$name"; mysql_connect( $db_host, $db_user, $db_pass ); $sql_query="select * order"; echo "$sql_query"; $result = mysql_query($sql_query) or die('mysql error' . mysql_error()); while ( $array = mysql_fetch_array($result) ) {    echo "$array[0]\n"; } ?> 

which php version used?

the mysql extension deprecated in php 5 later

php 5 , later can work mysql database using:

mysqli extension (the "i" stands improved)

pdo (php data objects)

earlier versions of php used mysql extension. however, extension deprecated in 2012.

if used php new version , mysql

you can try code

<?php $filename="abc.txt"; header("content-disposition: attachment; filename=\"$filename\""); header("content-type: text/csv"); $name="jone"; $dbserver = 'localhost'; // e.g 'localhost' or '192.168.1.100' $dbuser   = 'root'; $dbpass   = 'root'; $dbname   = 'sms'; echo "$name"; $conn = new mysqli($dbserver, $dbuser, $dbpass, $dbname);  // check connection if ($conn->connect_error) {   trigger_error('database connection failed: '  . $conn->connect_error,   e_user_error); }   $sql_query="select * tmd_news"; $rs=$conn->query($sql_query);  if($rs === false) { trigger_error('wrong sql: ' . $sql_query . ' error: ' . $conn->error,  e_user_error); } else {  $arr = $rs->fetch_all(mysqli_assoc); } foreach($arr $row) { echo $row['news_id']; } ?>