Archive for March, 2010



Simple PHP CSV upload

<form enctype="multipart/form-data" action="up.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000"/>
Chooseafiletoupload:<input name="uploadedfile" type="file"/><br/>
<input type="submit" value="UploadFile" name="Submit"/>
</form>

<?php

if (isset($_POST[’Submit’])){

$target_path="upload/";
$target_path=$target_path.basename($_FILES[’uploadedfile’][’name’]);
if(move_uploaded_file($_FILES[’uploadedfile’][’tmp_name’],$target_path)){
$myFile = "upload/".$_FILES[’uploadedfile’][’name’];
}
else{echo "could not upload";}
[/cc]

Number of Columns and Rows in CSV using php

How to get the # of columns and rows from a csv using php
[Can be useful when parsing a csv, e.g: creating a table in a database from a csv - need to know # of columns]
2 ways
//using FGETCSV

$myFile = "THEFILE.csv";

$row = 0;
if (($handle = fopen($myFile , "r")) !== FALSE) {
    while (($data = [...]