Sharif Ahmed's Blog

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))
  }
})()

Tuesday, May 20, 2014

Install Apache 2.4 in windows using zip files

To install Apache in windows OS/ windows server we can do in two way.
1. using msi (installer file)
2. using zip.
Here we are going to use zip.

1. First download files from
http://www.apachelounge.com/download

Select 32/64 bits and download as zip files.

2. Be sure that you have installed Visual C++ Redistributable for Visual Studio 2012 VC11 vcredist_x64/86.exe

3. After downloading, the zip file contains a folder called Apache24. Move (unzip) the Apache24 folder to C:\\ (now the webserver files are located at: C:\\Apache24).

4. The main configuration file for the server is: C:\\Apache24\\conf\\httpd.conf

Using a text editor, you need to edit the entry for the Server Name to give it a name or if no domain name then use IP , remove the comment from the line:

ServerName www.example.com:80

For just use IP like ServerName www.192.198.107.251

5.Find Start > All programs > Accessories > Command Prompt...... BUT, right click, and select 'Run as administrator'.

Enter the following commands

   cd \Apache24\bin
   httpd -k install
   httpd -k start