Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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; 
    ?>

  2. #2
    Deleted User 4eRNoBiL's Avatar
    Join Date: Oct:2005
    Location: Ñòàðà Çàãîðà
    Posts: 739
    À çàùî íå ñè çàïàçèø ñïèñúêà êàòî .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

  3. #3
    Absolut Hacker runtime's Avatar
    Join Date: Dec:2006
    Location: Ñòàðà Çàãîðà
    Posts: 199
    Àêî àéëà å íà ëîêàëíàòà ìàøèíà:

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè