Technology

how to upload csv file on database with php  <?php   if(isset($_POST["submit"])) {  if($_FILES['file']['name'])  {   $filename = explode(".", $_FILES['file']['name']);   if($filename[1] == 'csv')   {    $handle = fopen($_FILES['file']['tmp_name'], "r");    while($data = fgetcsv($handle))    {     $item1 = mysqli_real_escape_string($conn, $data[0]);                   $item2 = mysqli_real_escape_string($conn, $data[1]); $item3 = mysqli_real_escape_string($conn, $data[2]);                   $item4 = mysqli_real_escape_string($conn, $data[3]); $item5 = mysqli_real_escape_string($conn, $data[4]);                   $item6 = mysqli_real_escape_string($conn, $data[5]); $item7 = mysqli_real_escape_string($conn, $data[6]);  $item8 = mysqli_real_esc...

  /////create a tabel  CREATE TABLE ` users ` ( `id` int ( 11 ) NOT NULL AUTO_INCREMENT, `name` varchar ( 100 ) COLLATE utf8_unicode_ci NOT NULL , `email` varchar ( 255 ) COLLATE utf8_unicode_ci NOT NULL , `picture` varchar ( 255 ) COLLATE utf8_unicode_ci NOT NULL , `created` datetime NOT NULL , `modified` datetime NOT NULL , `status` tinyint ( 1 ) NOT NULL DEFAULT '1' COMMENT '1=Active, 0=Inactive' , PRIMARY KEY ( `id` ) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci; Controller (Users.php): <?php defined ( 'BASEPATH' ) OR exit( 'No direct script access allowed' ); class  Users  extends  CI_Controller {     function   __construct () {          parent :: __construct ();          $this -> load -> model ( 'user' );     }      ...