create and configure htaccess for codeigniter

1. Create .htaccess file on index.php.
   

   RewriteEngine On
   RewriteBase /sitename
   RewriteCond %{REQUEST_URI} ^system.*
   RewriteRule ^(.*)$ /index.php/$1 [L]
   RewriteCond %{REQUEST_FILENAME} !-f
   RewriteCond %{REQUEST_FILENAME} !-d
   RewriteRule ^(.*)$ index.php/$1 [L]
   
   
   php_flag display_errors on

2. Enable rewrite_module on apache server.
3. Enable include_module on apache server.
4. Enable cgi_module on apache server.
5. Enable short open tag on php server.
6. Configure config.php become.
   

   $config['index_page'] = "";

Read More

Simple Script Exsport Excel With PHP

First example

<?
header("Content-Type: application/vnd.ms-excel");
echo "<table border=1>
<tr>
<td>Cell 1</td>
<td>Cell 2</td>
</tr>
</table>";
?>

Implementation

$header = "Header1" . "\t";
$header .= "Header2" . "\t";

//Reading the data thro' POST
$data= $_POST['header1']. "\t";
$data .= $_POST['header2'] . "\t";

header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=xyz.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

Read More