Login   Register  
PHP Classes
elePHPant
Icontem

File: csvCRUD_basic.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mark Berube  >  CSV CRUD  >  csvCRUD_basic.php  >  Download  
File: csvCRUD_basic.php
Role: Example script
Content type: text/plain
Description: Basic expample
Class: CSV CRUD
Create, update, delete and list data in CSV files
Author: By
Last change:
Date: 2012-12-26 16:16
Size: 1,923 bytes
 

Contents

Class file image Download
<?php
ini_set
('display_errors','On');
require(
'class.csvCRUD.php');

//////////////////////
// Define Table Headers:
// RowNum is automatically added by the class. It refers to the 0-indexed line number of the CSV and you must include it when specifying custom headers
// You can not manipulate the RowNum, but you can utilitze the column for admin actions such as delete and edit. These actions would be defined the in the template columns array.
// All other columns are referred to alphabetically like a spreadsheet.
//////////////////////
$tbl_headers = array('RowNum'=>'Row:','A'=>'UPC:','B'=>'EAN:','C'=>'Type:','D'=>'Country:','E'=>'Genre:','F'=>'Price:','G'=>'Descrip:','H'=>'MOD:');


$csv = new csvCRUD('example.txt','|');
$csv -> set_custom_tbl_headers($tbl_headers);
$tbl $csv -> get_tbl_html();//after all desired options set, retrieve the reulting query HTML.

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html>

<head>
    <title>DVD Collection</title>
    <script language="Javascript" type="text/javascript" src="js/sorttable.js"></script>
    <style>

body {
 font-family: Arial, Helvetica, sans-serif;
 font-size: 13px;
}
#form_wrapper { 
 margin: 0 auto;
 width: 372px;
}
#form_content { 
 width: 350px;
 color: #333;
 border: 1px solid #ccc;
 background: #F2F2E6;
 margin: 10px 0px 10px 0px;
 padding: 10px;
 /*
 height: 300px;
 */
}

#tbl_wrapper { 
 margin: 0 auto;
 width: 90%;
}
#tbl_content { 
 color: #333;
 border: 1px solid #ccc;
 background: #F2F2E6;
 margin: 10px 0px 10px 0px;
 padding: 10px;
 /*
 height: 300px;
 */
}
        #csvtbl{font-family: arial,helvetica,verdana,sans-serif; font-size:12pt;}
        #tbl_div{margin-right:auto; margin-left:auto;}
        .csvtbl_row_odd{}
        .csvtbl_row_even{background-color:#D4DBE6;}
        .td_4{font-weight:bold;}
    </style>
</head>
<body>
<div id="container">
    <?php
        
echo "
        
$tbl
        "
;

    
?>
</div>
</body>
</html>