Pages

Wednesday, October 26, 2016

Read CSV file in PHP

CODE HERE

<?php
$csv = array();

// LOAD CSV FILE HERE

$lines = file('files/Flyers.csv', FILE_IGNORE_NEW_LINES);
//$lines = array_filter($lines);
//$lines = array_unique($lines);

foreach($lines as $line)
{
$lines = explode(",",$line);
//echo '<pre>';print_r($lines);

// Columns AND ROWS HERE

$title = mysql_real_escape_string($lines[0]);
$isbn = mysql_real_escape_string($lines[1]);
$exp  = $lines[2];
$price = $lines[3];

echo $title."<br>";
echo $isbn."<br>";
echo         $exp."<br>";
echo         $price.'<br>';
}

?>

Check All checkboxes with single Checkbox

<input type="checkbox" id="checkAll">Check All
<hr />
<input type="checkbox" class="checkboxes">Item 1
<input type="checkbox" class="checkboxes">Item 2
<input type="checkbox" class="checkboxes">Item3


<script type="text/javascript">
$('#checkAll').on('click',function(){
$('.checkboxes').not(this).prop('checked', this.checked);
});
</script>