mrchinaski

Paldeis par aatro atbildi, tik es esmu galiigs iesaaceejs php... kur man iisti likt sho kveeriju? Meegjinaaju shaadi, bet joprojaam nekas: mysql_query("SET NAMES UTF8" , "$link"); $result = mysql_query("SHOW COLUMNS FROM ".$table.""); Paldies!

Man ir datu baaze ar UTF-8 encodingu, tachu, kad eksporteeju kaa csv un atveru peec tam ekselii - nobruuk visi latvieshu burti, luuk skripts, ko izmantoju: <?php $host = 'localhost'; $user = 'xxxxxxxxx'; $pass = 'xxxxxxxxx'; $db = 'xxxxxxx'; $table = 'xxxxxx'; $file = 'export'; $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error()); mysql_select_db($db) or die("Can not connect."); $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $csv_output .= $row['Field']."; "; $i++; } } $csv_output .= "\n"; $values = mysql_query("SELECT * FROM ".$table.""); while ($rowr = mysql_fetch_row($values)) { for ($j=0;$j<$i;$j++) { $csv_output .= $rowr[$j]."; "; } $csv_output .= "\n"; } $filename = $file."_".date("Y-m-d_H-i",time()); header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header( "Content-disposition: filename=".$filename.".csv"); print $csv_output; exit; ?> Kaads varbuut var ieteikt, kaa to dariit taa, lai pareizi raadiitos lv simboli/burti. Paldies!

hmm urls it kaa pareizs ar http:// priekshgalaa......... ja ja urlencode visu atrisinijaa.muuzhu dziivo muuzhu maacies. Paldies codez un briedim! P.S kuru variantu labaak izmantot - vai ir kaukaadas buutiskas priekshrociibas file_get_contents vai cURL......... droshvvien jau ka ir, bet man kaa noobam file_get_contents izskataas vienkaarshaak un iisaak :)

Paldies! file_get_contents - nedereeja (400 Bad Request meta aaraa vislaik). Tad nu izmantoju cURL. Atradu shaadu funkciju - varbuut kaadam noder: /** * Send a GET requst using cURL * @param string $url to request * @param array $get values to send * @param array $options for cURL * @return string */ function curl_get($url, array $get = NULL, array $options = array()) { $defaults = array( CURLOPT_URL => $url. (strpos($url, '?') === FALSE ? '?' : ''). http_build_query($get), CURLOPT_HEADER => 0, CURLOPT_RETURNTRANSFER => TRUE, CURLOPT_TIMEOUT => 4 ); $ch = curl_init(); curl_setopt_array($ch, ($options + $defaults)); if( ! $result = curl_exec($ch)) { trigger_error(curl_error($ch)); } curl_close($ch); return $result; }

Jaanosuuta mainiigie un jaasanjem atbilde - it kaa vienkaarshi, bet man nesanaak, luuk mans sacereejums: <?php $host = "www.sample.com"; $request = "/?name=value&name1=value1&name2=value2"; $http_response = ''; $fp = fsockopen($host, 80); fputs($fp, "GET $request HTTP/1.1\r\n"); while (!feof($fp)) { $http_response .= fgets($fp, 128); } fclose($fp); echo $http_response; ?> Droshi vien daru kaut ko nepareizi. Plz apgaismojiet kaads.. Paldies.