Sharif Ahmed's Blog

Sunday, July 6, 2014

Apply Dynamic Active Class on Current Menu Item php

Given this example url:

http://www.example.com/yourpage.php?s=item1&n=01

$_SERVER['REQUEST_URI'] will give you:

yourpage.php?q=bogus&n=10

$full_url = $_SERVER['REQUEST_URI'];

list($url) = explode("?",$full_url); // get only file name

now $url will carry only file name.

So in your menu

<ul>

</ul>

Now it'll dynamically show the active menu.

Thanks

Sunday, June 22, 2014

Hosting multiple websites in one windows server with Apache (VirtualHost)

To host multiple websites in one windows server with Apache is known VirtualHost.
Here is the way to do.
In root create different folder according site name.
Example for domain www.mysite.com create folder "mysite"
Example for domain www.yoursite.com create folder "yoursite"
First of all need to go this path "apache/config" folder then open httpd file.

add following code end of the file.

NameVirtualHost *:80

<VirtualHost *:80>
ServerAdmin winsharif@gmail.com
DocumentRoot "C:\xampp\htdocs\mysite"
ServerName mysite.com
ServerAlias www.mysite.com
</VirtualHost>

<VirtualHost *:80>
ServerAdmin winsharif@gmail.com
DocumentRoot "C:\xampp\htdocs\yoursite"
ServerName yoursite.com
ServerAlias www.yoursite.com
</VirtualHost>

Restart your apache and you'r done.
For more visit apache site http://httpd.apache.org/docs/2.2/vhosts/examples.html

Saturday, May 24, 2014

Export html table into MS Excel file

This is the most easy way to export html table into MS Excel file.
for demo check : http://bl.ocks.org/insin/1031969#index.html

index.html#

<!DOCTYPE html>
<html>
<head>
  <title>tableToExcel Demo</title>
  <script src="tableToExcel.js"></script>
</head>
<body>
<h1>tableToExcel Demo</h1>
<p>Exporting the W3C Example Table</p>

<table id="testTable" summary="Code page support in different versions of MS Windows." rules="groups" frame="hsides" border="2">
<caption>CODE-PAGE SUPPORT IN MICROSOFT WINDOWS</caption>
<colgroup align="center"></colgroup><colgroup align="left"></colgroup><colgroup span="2" align="center"></colgroup>
<colgroup span="3" align="center"></colgroup>
<tbody>
<tr>
<th>Title</th>
<th>Name</th>
<th>Phone</th>
</tr>
<tr>
<td>Mr.</td>
<td>John</td>
<td>07868785831</td>
</tr>
</tbody>
</table>
<input type="button" onclick="tableToExcel('testTable', 'W3C Example Table')" value="Export to Excel">
</body>
</html>


tableToExcel.js


var tableToExcel = (function() {
  var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
  return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
  }
})()