Advertisement
Guest User

weh

a guest
Feb 27th, 2015
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. <html>
  2. <head><title></title></head>
  3. <body>
  4. <form enctype="multipart/form-data" action="load.php" method="post">
  5. <input type="file" name="upload" />
  6. <input type="submit" name="submit" value="Enter" />
  7.  
  8. <?php
  9. mysql_connect("localhost", "root", "") or die("Unable to Connect". mysql_error());
  10. mysql_select_db("DBCSE");
  11.  
  12. $file = $_FILES["upload"]["name"];
  13. echo "<br />", $file, "\n";
  14.  
  15. $sql = "LOAD DATA LOCAL INFILE '$file' INTO TABLE tblStudent FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY
  16.  
  17. '\r\n' IGNORE 1 LINES
  18. (id, name, gender)";
  19. mysql_query($sql);
  20.  
  21.  
  22. ?>
  23. </form>
  24. </body>
  25. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement