Blog Archives

how to convert column data in text or csv file into array in php


The data present in a text file or csv file.so we have total of six column. 19738424064    +19096060558    2012-05-01 09:04:17    2012-05-01 09:05:44    120    0.008 19738424064    +19096060558    2012-05-01 12:01:52    2012-05-01 12:19:17    1080    0.072 19738424064    +19096060558    2012-05-01 14:27:30    2012-05-01 14:27:45    60    0.004

Tagged with: , , , , , , , , ,
Posted in google chart, php

Import excel or csv fields into mysql database in php


Import excel or csv fields into mysql database in php. <?php //connect to the database $connect = mysql_connect(“localhost”,”pramodh”,””); mysql_select_db(“pramodh”,$connect); //select the table // if ($_FILES[csv][size] > 0) { //get the csv file $file = $_FILES[csv][tmp_name]; $handle = fopen($file,”r”); //loop through

Tagged with: , , , , , , , , , ,
Posted in Import excel or csv fields into mysql database in php, php
Follow Tutorial on WordPress.com
categories
Calendar
May 2024
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
Follow me on Twitter
Blog Stats
  • 88,190 hits