в 10:37, 26 мая 2010

2010-05-26T10:37:25Z

Admin: 1 версия

2010-05-26T07:03:59Z

1 версия

Новая страница

==explode CSV file==



<source lang="html4strict">

<?php
$users = file("./demoCSV.csv");
foreach ($users as $user) {
list($name, $email, $phone) = explode(",", $user);
echo "<p>$name ($email) Tel. $phone</p>";
}
?>


</source>

==fgetcsv: read a csv file==



<source lang="html4strict">

<?php
$fh = fopen("./demoCSV.csv", "r");
while (list($name, $email, $phone) = fgetcsv($fh, 1024, ",")) {
echo "<p>$name ($email) Tel. $phone</p>";
}
?>



</source>

==Loading table data from a CSV file==



<source lang="html4strict">

<?php
$conn = mysql_connect("localhost","someuser","secret");
$db = mysql_select_db("cars");
$fh = fopen("yourCSVFile.csv", "r");
while ($line = fgetcsv($fh, 1000, ",")) {
$year = $line[0];
$make = $line[1];
$color = $line[2];
$query = "INSERT INTO carcollection SET year="$year", make="$make",color="$color"";
$result = mysql_query($query);
}
fclose($fh);
mysql_close();
?>

</source>

==Read csv file==



<source lang="html4strict">

<?php
$file = "./demoCSV.csv";
$fh = fopen($file, "rt");
$userdata = fread($fh, filesize($file));
fclose($fh);
echo $userdata;
?>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/Development/CSV - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия