Results 1 to 3 of 3
Thread: Ïðîáëåì ñ ÷åòåíå íà *.csv ôàéë
Hybrid View
-
10th February 2009 16:11 #1Registered User
Join Date: Feb:2008
Location: Íàâñÿêúäå
Posts: 46
Ïðîáëåì ñ ÷åòåíå íà *.csv ôàéë
Çäðàâåéòå!!!
Îò äîñòà âðåìå ñå ìà÷à äà ïðåîáðàçóâàì .csv ôàéë â html òàáëèöà. Ñòàâà äóìà çà öåíîâàòà ëèñòà îò ìîñò êîìïþòúðñ http://mostbg.com/Pricelist/PricelistBGN.csv . Àêî ÿ îòâîðèòå ñ Exel ùå çàáåëåæèòå ,÷å íà âñÿêà åäíà ïîäãðóïà èìà ",,," çàïåòàé,êîéòî íåçíàì êàê äà ðàçäåëÿ ïî êúñíî â html. Íàìåðèõ òàêúâ êîíâåðòåð â ÷è÷î GOOGLE íà áàçàòà íà PHP . Ðàáîòè íî òðÿáâà äà ñå äîáàâè íåùî çà äà èçëåçíå ïúëíàòà öåíîâà ëèñòà. Ïîìàãàéòå
ùå ÷åðïÿ . Åòî è ñêðèïòà
PHP Code:Simple <b style="color:black;background-color:#ffff66">CSV</b> to <b style="color:black;background-color:#a0ffff">HTML</b> Table
<?<b style="color:black;background-color:#99ff99">php</b>
*/
//
$filename = ""; // File to open. quote out this variable if you are using a form to link to this script.
/*
No cache!!
*/
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// always modified
header("Cache-Control: no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
/*
End of No cache
*/
function viewlog($filename) {
$fp = fopen($filename,"r");
$file = fread($fp,65535);
$replaced = eregi_replace(",", "<td>", $file);
$replaced2 = eregi_replace("\n", "<tr><td>", $replaced);
$replaced3 = eregi_replace("\r", "<tr><td>", $replaced2);
fclose($fp);
return $replaced3;
}
echo "<<b style="color:black;background-color:#a0ffff">html</b>><head><base href=\"./\"><title><b style="color:black;background-color:#ffff66">CSV</b> File Viewer</title></head><body bgcolor=silver>";
// Start the table definition of your choice
echo "<table border=0 bordercolor=black cellspacing=0 cellpadding=5 width=100% style='font-size:10pt'>";
echo viewlog($filename);
echo "</table></body></<b style="color:black;background-color:#a0ffff">html</b>>";
exit;
?>
-
11th February 2009 12:55 #2
À çàùî íå ñè çàïàçèø ñïèñúêà êàòî .html îò http://mostbg1.com/most/PriceList.aspx? Ïîñëå ñàìî ùå îïðàâèø ëèíêîâåòå è ñè ãîòîâ. Ïúê àêî èìàø ìåðàê ìîæå è åêñòðè äà äîáàâèø, è äèçàéíà äà ïðîìåíèø.
Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19
-
11th February 2009 13:00 #3
Àêî àéëà å íà ëîêàëíàòà ìàøèíà:
HTML Code:<?php $filename = "PricelistBGN.csv"; header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); function viewlog($filename) { $fp = fopen($filename,"r"); $file = fread($fp,65535); $replaced = eregi_replace(",", "<td>", $file); $replaced2 = eregi_replace("\n", "<tr><td>", $replaced); $replaced3 = eregi_replace("\r", "<tr><td>", $replaced2); fclose($fp); return $replaced3; } echo "<table border=\"0\" bordercolor=\"black\" cellspacing=\"0\" cellpadding=\"1\" width=\"100%\" style=\"font-size:10pt\">"; echo viewlog($filename); echo "</table></body>"; exit; ?>
Àêî ôàéëà ùå ñå ÷åòå îò ñàéòà íà ÌÎÑÒ, áåç äà å íåîáõîäèìî äà ãî ñâàëÿø:
Äàíî òîâà äà òè å áèëà èäåÿòà, ÷å íåùî íå äîðàçáðàõ, êîå èñêàø äà ñå ïðîìåíÿHTML Code:<?php $filename = "http://91.198.119.1/Pricelist/PricelistBGN.csv"; header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); function viewlog($filename) { $fp = file_get_contents($filename); $replaced = eregi_replace(",", "<td>", $fp); $replaced2 = eregi_replace("\n", "<tr><td>", $replaced); $replaced3 = eregi_replace("\r", "<tr><td>", $replaced2); return $replaced3; } echo "<table border=\"0\" bordercolor=\"black\" cellspacing=\"0\" cellpadding=\"1\" width=\"100%\" style=\"font-size:10pt\">"; echo viewlog($filename); echo "</table></body>"; exit; ?>
À è òè ïðåïîðú÷âàì ôàéëà äà ñòîè íà òâîÿ ñúðâúð
Ìàëêî ïî íåóäîáíî å, ÷å òðÿáâà äà ñå îáíîâÿâà ðú÷íî àìà ùå ñè ñïåñòèø åâåíòóàëíè ãëàâîáîëèÿ çàùîòî 2-ðèÿ âàðèàíò âñåêè ïúò âèêà ôàéëà îò ñúðâúðà íà most, êîåòî åäíî, ÷å òîâàðè òåõíèÿ òðàôèê ñúñ âñåêè òâîé êëèåíò, îòäåëíî òðÿáâà äà ÷àêàò 1-âî äà ñå ïðî÷åòå ôàéëà îò òàì è ñëåä òîâà äà ñå ïîêàæå
2-íà ðàáîòà...
Last edited by runtime; 11th February 2009 at 13:34.




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè