Prikazi cijelu temu 27.05.2020 18:42
Avko Van mreze
Administrator
Registrovan od:28.05.2014
Lokacija:zagreb


Predmet:Re: csv u bazu
napredovo jesam ali nisam uspio rijesii sljedeci problem.

sada IMPORT izgleda ovako:



html za import:

PreuzmiIzvorni kôd (Text):
  1. <table class="buttons width-25">
  2.   <tr>
  3.     <td>
  4.         <p>1. Tehnicar racunarstva</p>
  5.     </td>
  6.     <td>
  7.         <input id="file-upload" type="file" />
  8.         <label class="buttons custom" for="file-upload">IZABERI FILE</label>
  9.     </td>
  10.     <td>
  11.         <form method="post" enctype="multipart/form-data">
  12.         <button type="submit" class="buttons submit" name="submit" value="submit">UPLOAD</button>
  13.         </form>
  14.     </td>
  15. </tr>
  16. <tr>
  17.   <td>
  18.     <p>2. Tehnicar elektronike</p>
  19.   </td>
  20.   <td>
  21.         <input id="file-upload" type="file" />
  22.         <label class="buttons custom" for="file-upload">IZABERI FILE</label>
  23.   </td>
  24.   <td>
  25.         <form method="post" enctype="multipart/form-data">
  26.        <button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD </button>
  27.         </form>
  28. </td>
  29. </tr>
  30.  <tr>
  31.   <td>
  32.         <p>3. Tehnicarelektro-energetike</p>
  33.   </td>
  34.   <td>
  35.         <input id="file-upload" type="file" />
  36.         <label class="buttons custom" for="file-upload">IZABERI FILE</label>
  37.   </td>
  38.   <td>
  39.         <form method="post" enctype="multipart/form-data">
  40.         <button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD </button>
  41.         </form>
  42.   </td>
  43. </tr>
  44. <tr>
  45.   <td>
  46.         <p>4. Tehnicar mehatronike</p>
  47.   </td>
  48.   <td>
  49.         <input id="file-upload" type="file" />
  50.         <label class="buttons custom" for="file-upload">IZABERI FILE</label>
  51.   </td>
  52.   <td>
  53.         <form method="post" enctype="multipart/form-data">
  54.        <button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD</button>
  55.         </form>
  56.   </td>
  57. </tr>
  58. <tr>
  59.   <td>
  60.         <p>5. Elektricar </p>
  61.   </td>
  62.   <td>
  63.         <input id="file-upload" type="file" />
  64.         <label class="buttons custom" for="file-upload">IZABERI FILE</label>
  65.   </td>
  66.   <td>
  67.         <form method="post" enctype="multipart/form-data">
  68.        <button type="submit" class="buttons submit" name="submit" value="submit"> UPLOAD</button>
  69.         </form>
  70.   </td>
  71. </tr>
  72. </table>


PreuzmiIzvorni kôd (Text):
  1. [color=#33CC66]table {
  2.     width: 100%;
  3.         border-collapse: collapse;
  4. }
  5.  
  6. table td {
  7.         border: 1px solid black;
  8. }
  9.  
  10. .width-25 td {
  11.     width: 15%;
  12.         /* sakriti crte kolona */
  13.         border: 1px solid #dddddd;
  14.         text-align: left;
  15.         padding: 8px;
  16. }
  17.  
  18. .width-25 input[type="file"], input[type="submit"] {
  19.     display: none;
  20. }[/color]

u function.php fajlu imam kod koji provjerava dali je pritisnut button UPLOAD name="submit"

PreuzmiIzvorni kôd (Text):
  1. [color=#FF0066]if(isset($_POST["submit"])){
  2.    
  3.     $filename=$_FILES["file"]["tmp_name"];    
  4.      if($_FILES["file"]["size"] > 0)
  5.      {
  6.         $file = fopen($filename, "r");
  7.           while (($getData = fgetcsv($file, 10000, ",")) !== FALSE)
  8.            {
  9.              $sql = "INSERT into racunarstvo (imePrezime,email)
  10.                    values ('".$getData[0]."','".$getData[1]."')";
  11.                    $result = mysqli_query($con, $sql);
  12.         if(!isset($result))
  13.         {
  14.           echo "<script type=\"text/javascript\">
  15.               alert(\"Invalid File:Please Upload CSV File.\");
  16.               window.location = \"index.php\"
  17.               </script>";    
  18.         }
  19.         else {
  20.             echo "<script type=\"text/javascript\">
  21.             alert(\"CSV File has been successfully Imported.\");
  22.             window.location = \"index.php\"
  23.           </script>";
  24.         }
  25.            }
  26.      
  27.            fclose($file);  
  28.      }
  29.   }   [/color]

problem je u sljedecem:

-kada izaberem csv fajl za upload , nigdje mi ne napise koji sam fajl pripremio za upload.

to za sada pa kad to rijesim onda cemo do import u table

Prilozi:
01_web_oop_icentar.zip
Preuzimanja:198
Velicina datoteke:36.45 KB

zivot je moja domovina.
Ovaj post je ureden 3 puta. Posljednja izmjena 27.05.2020 18:55 od strane Avko.