rowspan in HTML

Wish everything would have been easier to remember in this world! But that’s not true.

“rowspan” is one of such tag in HTML that I always forget to implement. This Sunday I have decided to make it clear and clear forever. Hope this picture helps you in understanding the HTML tag and remembering forever. Similar concept will be applicable for “colspan’ as well.

Advertisements

PHP without WAMP or XAMPP

I am big fan of WAMP. The reason – I tell every newbie that you can learn PHP in very short span. This is all possible because of a ONE click installation of WAMP and providing you the all the necessary packages to run your PHP and the back end code.

Well – here was the latest requirement from our client – Develop a web application using PHP and SQL Server. Naturally I need to play away with WAMP, as I don’t want to make the client box heavier using two database servers – the existing SQL server and the new MySQL because of WAMP.

Okay – so it’s a high time to install & configure the PHP & the Web Server (Apache or IIS). It was bit of headache, but no other option.

Let’s go. Here is the complete guideline on working with PHP 5.6.x with Apache server without WAMP or without XAMPP.

To be noted these versions are well compatible with each other and hence don’t go with any other major versions unless you are confident in conjuring it by yourself. I will assume that your system has SQL server already installed to it.

 

Here are the major steps:

A.      Download the packages:

  1. Apache 2.4.x httpd web server
  2. PHP 5.6.x – The PHP engine
  3. Eclipse Helios Editor (Optional)

B.      Running Apache(localhost) for the test page

C.      Configure PHP

D.      Configure Apache for PHP

E.       Running the first PHP code

A) Download the packages:

1. Apache httpd-2.4.25 http://www.apachelounge.com/download/VC14/binaries/httpd-2.4.25-win32-VC14.zip

2. PHP-5.6.30http://windows.php.net/downloads/releases/php-5.6.30-Win32-VC11-x86.zip

3. Eclipse Helioss R2 http://www.eclipse.org/downloads/packages/eclipse-php-developers/heliossr2 This is a PHP compatible Eclipse IDE; I would insist you to go ahead with your known editor. This is not at all mandatory.

B) Running Apache(localhost) for the test page

You need to extract the downloaded package above #1. Copy to your drive (say C: or D). Rename the big named folder name to a shorted one – say its Apache24.

Go to C:\Apache24\bin

Do a double click on httpd.exe or from command prompt – C:\Apache24\bin>start httpd.exe

This should pop up a small prompt.

Open a browser and launch the URL  – http://localhost or http://localhost:80 – This should bring you a tiny output stating that – “It works!”. Means it is configured correctly.

Possible Issue #1: By somehow if your port 80 has been taken by other application like IIS or Skype, please change this into the file C:\Apache24\conf\httpd.conf from Listen 80 to Listen <YOUR_PORT>

Possible Issue #2: You may get a prompt like VCRUNTIME140.dll is missing while trying to run the httpd service. Just download this file from internet. This may come as a zip file. Extract it and copy the VCRUNTIME140.dll file to C:\Apache24\bin folder.

C) Configure PHP

Extract the #2 download and rename the big named folder to php5 or php56 or just php.

Copy the c:\php\php.ini-development to the same folder with  a rename as php.ini. After copy you should see it as c:\php\php.ini

Make sure that you should be able to locate the dll file – php5apache2_4.dll to C:/php folder. This dll is the one who help the Apache to communicate with PHP interpreter.

D) Configure Apache for PHP

i) Add these file to your httpd.conf file. You can add them anywhere but I would prefer to add where all these #LoadModule types of lines end with.

LoadModule php5_module "C:/php/php5apache2_4.dll"
AddHandler application/x-httpd-php .php
# configure the path to php.ini
PHPIniDir "C:/php"

Caution : php5apache2_4.dll is the same into your PHP directory.

ii) Modify the value of the DocumentRoot to your folder htdocs or similar folder. Whatever you specify here, that should contain your project folders/subfolders and PHP files.

DocumentRoot "c:/Apache24/htdocs"
<Directory "c:/Apache24/htdocs">

iii)Optionally add/modify the DirectoryIndex. Just add the main PHP file or welcome page of your project. Ideally if somebody just types http://localhost – without anything else – the mentioned page will act as a default page view at the browser.

<IfModule dir_module>
    DirectoryIndex index.php index.html
</IfModule>

E) Running the first PHP code

After adding those above lines to http.conf file, you must create index.php file. Let us add these PHP codes to your  c:/Apache24/htdocs/index.php file

<?php
   echo “PHP is one of the sweet language!”;
   echo phpinfo();
?>

Now launch the browser like http://localhost/index.php – The output should make you happy.

I will be writing another article very soon on major parameters those need to be changed in http.conf file.

Aadhar Card implementation in INDIA

We found many obstacles in implementing Aadhar in India. The obligations from some civil liberty groups (INSAF, Civil Liberties) are well known to this project.

I have group of friends and were talking a lot about the IT implementation of the same when the project UIDAI was announced by ex Infy – Mr. Nandan Nilekani Sir in year 2009-10. In terms of hardware (the crores of Indian citizen), we were just suspecting the possible issues at software implementations right from the data collection to load balancing on the servers and most important – the futuristic usage of this data — Are nahi! God Bramha has to get such server. Look at the IRCTC servers; we got just few millions of travelers from India and now on UIDAI – we will have loads from both travelers and those sitting at home… No no! not possible.

Servers will cry – Cur, Cur, Currrrrrrrrrrr on a SQL query fire – “select aadhar_id from serverX where firstName=’alpha’ && lastName=’beta’ && DOB=’gamma’“;
I am sure they will hire architects from Google conferencing to IISc. data scientists. IIM managers will come up with an PARAM Agile concept to ensure these IITians deliver it at the right time. Of course Nandan’s project team will have testers from NIITs to assure a defect free product to Government of India.

Okay so where are they gonna host these servers – one of my friend said – A new state will be announced and area wise it should be equivalent to Nagaland or Meghalaya!

So funny! So crazy talks!

Okay – What about OBAMACARE?
Every American citizen will get a health insurance — do you see – EVERY AMERICAN!!
Another HUGE project!

Hey – this is America, they have technologies, they have brains and they will do everything – no mess up at all! Did you watch – Spielberg’s Minority Report starring Tom Cruise? Means – Obamcare’s IT implementations should NOT be tough for highly skilled America. But is that true? Is that true? Is that true?

Here is the snapshot from one of the recent reports [https://oig.hhs.gov/oei/reports/oei-01-14-00620.pdf] which talks about the inconsistencies occurred in enrollment to Obamacare program and that too just during the first period – 21 lacs inconsistent/problematic data storage.
But still they are hoping to correct and go ahead with it unless Mr. Trump brings a new formula into healthcare industry.

ObamacareDataIssue

What I am highlighting here – an implementation at global level is NOT easy. Think about the foundation members to bring the concept and how much GUTS they will have to announce such prototypes into the industry. It’s not easy. You would have read this – Galileo’s house arrest on his proposal for – “Earth moves around the Sun”. But later on this all became valid.

I am concluding myself – Give a chance to your team, team members – They may have something unique with them. Making fun is a job for comedians, not for a visionary.

Disclaimer : It is just my vision. You may disagree with me.