Read CSV Data

Last Updated on Sunday, 08 March 2009 14:36 Written by Zack Sunday, 08 March 2009 14:32

ကြၽန္ေတာ္ CSV File ကေနျပီး data read လုပ္တာကို ေရးမယ္လို႔ စိတ္ကူးထားပါတယ္။

ဒါက client HTML Form ျဖစ္ပါတယ္။

<form name="search" method="post" action="insert.php" enctype="multipart/form-data">
File to import<br>

<input type="file" name="csvimport" value="" size="40" maxlength="250">
<input type="submit" value="Import">
</form>

insert.php ရဲ႔ code ျဖစ္ပါတယ္။

<?php
$csv = file($_FILES["csvimport"]["tmp_name"]);

PHP ရဲ႔ File Object ကိုသုံးျပီး file ကိုဖတ္တာျဖစ္ပါတယ္။

အဲလို read လိုက္တာနဲ႔ array format ရျပီးသားပါ။ explode ကိုသုံးျပီး array အခန္းထဲက data ကိုျပန္ယူတာပါ။

if(count($csv)>1){

foreach($csv as $val){
$data       = explode(",", $val);
$name     = trim($data[0]);
$address  = trim($data[1]);
$contact  = trim($data[2]);
print_r( "Name: " . $name . "-" ." Address:" . $address ."-". " Contact:" . $contact);
}

}
?>

• Add New
• Search

Comments (2)

• 2009-09-20 18:20:29 | |218.186.9.xxx| myoaung  - CSV ဆိုတာဘ)

  ေခါင္းစဥ္) 29;တိုင္းပါပ) 46; အဲဒါဘာလဲ ဘယ္ေနရာကလဲ ဘယ္လိုအသုံ းခ်လို႕ရတာ လဲရွင္းျပေ ပးပါလို ေတာင္းဆိုပ ါရေစဗ်ာ

  • 0
  • 0

  ReplyQuote

• 2009-09-21 12:16:55 |SAdministrator| admin  - Re: myoaung

  ကို myoaung ေရ
  CSV ဆိုတာကေတာ့ File Extension တစ္မ်ိဳးပဲ ျဖစ္ပါတယ္။ ဒီ file format မ်ိဳးကို excel or open office စတာေတြကေန Export လုပ္ယူႏိုင ္ပါတယ္။

  • 0
  • 0

  ReplyQuote

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

Joomla components by Compojoom