SQLlIite is embedded in the php5.2 and up, therefore you just need to unmark two extensions.

The

 

Apache Environment

Variable	Value
HTTP_ACCEPT	image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_LANGUAGE	en-us
HTTP_UA_CPU	x86
HTTP_ACCEPT_ENCODING	gzip, deflate
HTTP_USER_AGENT	Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Embedded Web Browser from: http://bsalsa.com/; Media Center PC 3.0; .NET CLR 1.0.3705; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
HTTP_HOST	manas10
HTTP_CONNECTION	Keep-Alive
PATH	C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Common Files\Roxio Shared\DLLShared\;
SystemRoot	C:\WINDOWS
COMSPEC	C:\WINDOWS\system32\cmd.exe
PATHEXT	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
WINDIR	C:\WINDOWS
SERVER_SIGNATURE	no value
SERVER_SOFTWARE	Apache/2.2.9 (Win32) PHP/5.2.6
SERVER_NAME	manas10
SERVER_ADDR	192.168.1.71
SERVER_PORT	80
REMOTE_ADDR	192.168.1.71
DOCUMENT_ROOT	C:/Apache2.2/htdocs
SERVER_ADMIN	admin@manas10.net
SCRIPT_FILENAME	C:/Apache2.2/htdocs/myphp/phptest.php
REMOTE_PORT	1668
GATEWAY_INTERFACE	CGI/1.1
SERVER_PROTOCOL	HTTP/1.1
REQUEST_METHOD	GET
QUERY_STRING	no value
REQUEST_URI	/myphp/phptest.php
SCRIPT_NAME	/myphp/phptest.php

This is needed for SOAP web services, xml module is loaded by default.

 

Additional Modules

Module Name

 

Environment

Variable	Value
ALLUSERSPROFILE	C:\Documents and Settings\All Users
CommonProgramFiles	C:\Program Files\Common Files
COMPUTERNAME	MANAS10
ComSpec	C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK	NO
NUMBER_OF_PROCESSORS	2
OS	Windows_NT
Path	C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Common Files\Roxio Shared\DLLShared\;
PATHEXT	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE	x86
PROCESSOR_IDENTIFIER	x86 Family 15 Model 4 Stepping 9, GenuineIntel
PROCESSOR_LEVEL	15
PROCESSOR_REVISION	0409
ProgramFiles	C:\Program Files
SystemDrive	C:
SystemRoot	C:\WINDOWS
TEMP	C:\WINDOWS\TEMP
TMP	C:\WINDOWS\TEMP
USERPROFILE	C:\Documents and Settings\LocalService
windir	C:\WINDOWS
AP_PARENT_PID	1712

 

<?php

//create table
if(file_exists("test.db")) {
$weNeedToCreateTheDatabase = false;
echo(" Modifying Existing DB: <br/>");
} else {
$weNeedToCreateTheDatabase = true;
echo(" New Database Created: <br/>");

}

//create or open database
$db = sqlite_open("test.db") or die("failed to open/create the database");

//create table
if($weNeedToCreateTheDatabase) {
sqlite_query($db, "CREATE TABLE Members(ID, FirstName,LastName)");
}

//add info
sqlite_query($db,"INSERT INTO Members VALUES (1,'Manas', 'Mukherjee')");
sqlite_query($db,"INSERT INTO Members VALUES (2,'Arindam', 'Mukherjee')");
echo(" Rows Created: <br/>");
//get info
$dt = sqlite_query($db, "SELECT * FROM Members");
while ($row = sqlite_fetch_array($dt)) {
echo "row: $row[ID] $row[FirstName] $row[LastName]<br/>";
}
echo("Deleting rows <br/>");
sqlite_query($db, "Delete from Members where ID=1");
sqlite_query($db, "Delete from Members where ID=2");
//get info
$dt = sqlite_query($db, "SELECT * FROM Members");
while ($row = sqlite_fetch_array($dt)) {
echo "row: $row[ID] $row[FirstName] $row[LastName]<br/>";
}

//close database
sqlite_close($db);

?>