Thursday, October 28, 2010

What is php?

PHP stands for Hypertext Preprocessor
PHP
Paradigm     imperative, object-oriented, Procedural, reflective
Appeared in     1995 (1995)[1]
Designed by     Rasmus Lerdorf
Developer     The PHP Group
Stable release     5.3.3 (July 22, 2010; 3 months ago (2010-07-22))
Typing discipline     Dynamic, weak
Major implementations     Zend Engine, Roadsend PHP, Phalanger, Quercus, Project Zero, HipHop
Influenced by     C, Perl, Java, C++, Tcl[1]
Influenced     PHP4Delphi
Programming language     C
OS     Cross-platform
License     PHP License
Usual file extensions     .php, .phtml .php5 .phps
Website     www.php.net
Wikibooks logo PHP Programming at Wikibooks

insert csv into mysql using php.

<?
//session_cache_limiter("nocahe");


if(isset($_POST['submit']))
   {
     $filename=$_POST['filename'];
     $handle = fopen("$filename", "r");
     while (($data = fgetcsv($handle, 100000, ",")) !== FALSE)
     {
   
       $import="INSERT into kmmb_member1(no_ahli,no_pin,nama,no_ic_baru,no_ic_lama) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";
       mysql_query($import) or die(mysql_error());
     }
     fclose($handle);
     print "Import done";
   }
   else
   {

      print "<form action='import.php' method='post'>";
      print "Type file name to import:<br>";
      print "<input type='text' name='filename' size='20'><br>";
      print "<input type='submit' name='submit' value='submit'></form>";
   }  
?>