mysql - PHP: how to convert SQL result in csv -


i'm trying convert sql query result in csv file can't find working solution. have suggestion?

tnx in advance!

here code:

 <? mysql_query("set character set 'utf8'");                    $result3 = mysql_query("select * richieste group mail"); while( $row2 = mysql_fetch_array( $result3 ) )              {              $id="{$row2['id']}";             $nominativo="{$row2['nominativo']}";             $mail="{$row2['mail']}";             $telefono="{$row2['telefono']}";             $comune="{$row2['comune']}";             $cap="{$row2['cap']}";             $provincia="{$row2['provincia']}";             $regione="{$row2['regione']}";               echo"             <tr><td width='20%' align='left' class='testo_verde_maiuscolo'><a href='visualizza_richieste.php?mail=$mail&id=$id'>$nominativo</a></td><td width='15%' align='left' class='testo_verde'><a href='mailto:$mail'>$mail</a></td>             <td width='10%' align='left' class='testo_verde'>$telefono</td><td width='15%' align='left' class='testo_verde'>";

looking value in table

            $result_comune = mysql_query("select * comuni cod_istat=$comune"); while( $row_comune = mysql_fetch_array( $result_comune ) )             { $comune_traslata="{$row_comune['comune']}";echo"$comune_traslata";             }             echo"</td><td width='10%' align='left' class='testo_verde'>             $cap</td><td width='10%' align='left' class='testo_verde'>     ";

here i'm looking value in table

        $result_provincia = mysql_query("select * province cod_provincia=$provincia"); while( $row_provincia = mysql_fetch_array( $result_provincia ) )             {              $provincia_traslata="{$row_provincia['provincia']}";             echo"$provincia_traslata";             }             echo"</td>             <td align='left' class='testo_verde'>";

same before, looking value in table

            $result_regione = mysql_query("select * regioni cod_regione=$regione"); while( $row_regione = mysql_fetch_array( $result_regione ) )             {              $regione_traslata="{$row_regione['regione']}";          echo"$regione_traslata";             }             echo"</td>             ";               echo"</tr>";

first edit: tryed code:

$_csv_data="id;nominativo;mail;telefono\n"; @fwrite( $_fp, $_csv_data); while (list( $id, $nominativo, $mail, $telefono) = mysql_fetch_row($result3)) { $_csv_data = $id.';'.$nominativo.';'.$mail.';'.$telefono."\n"; @fwrite( $_fp, $_csv_data); } @fclose( $_fp );

but i'm getting firs line of csv.

} ?>

the repeated mysql_fetch_array calls in html generating while loop consume of rows, leaving internal result pointer @ end when finished. therefore, when try mysql_fetch_array on same result, being @ end of result, not receive (more) rows.

try adding ...

mysql_data_seek($result3, 0);

... before second/csv generating loop, move internal pointer start of query result.

as side note, please see the manual on mysql_* function usage:

this extension deprecated of php 5.5.0, , removed in future. instead, mysqli or pdo_mysql extension should used [...]


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more