Wednesday, August 24, 2011

Enable GD on Linux

1. install
yum install php-gd

2. restart service
/etc/init.d/httpd restart

Tuesday, June 28, 2011

Install Linux on Window 7 using Virtual Box

1. Download and Install Virtual Box
http://www.virtualbox.org/wiki/Downloads

VirtualBox 4.0.10 for Windows hosts x86/amd64

2. Create New Virtual Machine
Linux Fedora
Memory 1024MB
Hard Disk 8G

3. Start Virtual Machine
Auto Capture keyboard: capture the keyboard every time VM window is activated and unavailable to other applications

Host key to uncapture: Right Ctrl

Problem1: FATAL: NO bootable medium found! System halted.
Solution1:
When you first create a Virtual Machine with VirtualBox, there is no OS installed on the HD image. You have to have the VM mount a bootable ISO image to install the OS from.

Download Fedora disk image, create a folder C:/Fedora
CD/DVD device, select the disk image.

Problem2: GNOME 3 Failed to Load (graphics hardware or driver is not capable of delivering the full GNOME 3 experience.

Install Apache and PHP on Win 7

Install Apache on Windows 7 - how to
http://www.webdevelopersnotes.com/how-do-i/install-apache-windows-7.php


1.Go to the Apache download page.
Click on Win32 Binary without crypto (no mod_ssl) (MSI Installer) file
apache_2.2.14-win32-x86-no_ssl.msi

2. Download and Install

3. Test in browser http://localhost/


MySQL on Windows 7 64 bit – Installation with Apache and PHP
http://www.webdevelopersnotes.com/blog/mysql-windows-7-64bit-installation-with-apache-and-php/

Install PHP on Windows 7
http://www.webdevelopersnotes.com/how-do-i/install-PHP-windows-7.php

How to Install PHP 5.3 on Windows
http://www.sitepoint.com/install-php53-windows/

1. Go to PHP Download Page

which one to choose?

http://www.websiteadministrator.com.au/articles/install_guides/installing_php535_pg2.html

A Thread Safe version should be used if you install PHP as an Apache module. The Non Thread Safe version should be used if you install PHP as a CGI binary.

Download the VC6 builds if you are using the standard Apache.org web server. The VC9 builds should be used for the Apache Lounge binaries or IIS.

Wednesday, May 25, 2011

Clean Computer

1. Delete Stored Password in Firefox
1) In Firefox click Tools > Options.
2) Click Security at the top.
3) Click the Show Passwords button.
4) Find the web site you wish to remove in the list. Click/highlight it with your mouse.
5) Click Remove and click Close then OK when you are finished.

Friday, March 25, 2011

Tuesday, March 1, 2011

YUI Calendar

1. YUI: Using Event.addListener. One Calendar, Multiple Fields

http://grasshopperpebbles.com/ajax/yui-using-eventaddlistener-one-calendar-multiple-fields/


created a variable and set it to null:
var clickEl = null;

use an Event Listener (Event.Listener) using the ids of the input fields:

var ids = ["appoint_date", "interp_date", "service_date", "cancel_date"];
Event.addListener(ids, "click", showCal);


When a user clicks on one of the input fields, the showCal function is called. The showCal function sets the clickEl variable to the id of the “clicked” input field and then shows a YUI Dialog component that contains the YUI Calendar.
function showCal(e) {
clickEl = this.id;
dlgCal.show();
}

When a date is selected, the date value is inserted into the appropriate input field:
var selDate = calCal.getSelectedDates()[0];
var dStr = selDate.getDate();
var mStr = calCal.cfg.getProperty("MONTHS_SHORT")[selDate.getMonth()];
var yStr = selDate.getFullYear();
Dom.get(clickEl).value = yStr + "-"+ mStr + "-" + dStr;
...




Tuesday, February 22, 2011

mysql on linux

1. Use command line client - mysql
Genral syntax
mysql -u DBUSER -h DBSERVERNAME -p

So at a shell prompt you type all one single line to connect to database server install on localhost for root user:
mysql -u root -h localhost -p

Supply the password when prompted for password.

2. Use PHP to connect to MySQL

http://www.cyberciti.biz/faq/how-to-connect-to-my-mysql-database-server-using-command-line-and-php/


$link = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");

$query = "SELECT * FROM TABLE";
$result = mysql_query($query);

while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print "$value\n";
}
}

mysql_close($link);


3. Mysql list databases
http://www.cyberciti.biz/faq/mysql-command-to-show-list-of-databases-on-server/

mysql> show databases;
output

+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)


Use database
mysql> use test;

List tables
mysql> show tables;

4. Create a mysql database
http://www.cyberciti.biz/faq/howto-linux-unix-creating-database-and-table/
Create database
mysql>CREATE DATABASE books;

Use database
USE books;

Create Table
mysql>CREATE TABLE authors (id INT, name VARCHAR(20), email VARCHAR(20));

Add data
mysql>INSERT INTO authors (id,name,email) VALUES(1,"Vivek","xuz@abc.com");

Display all rows
mysql>SELECT * FROM authors;

5. Drop database / table
Drop database
mysql>DROP DATABASE atomstore;