ThaiCreate PHP

	PHP Introduction
	PHP What? PHP System Requirement?
	PHP Installation
	PHP Installation PHP Install for Windows 98,Me (With PWS) PHP Install for Windows All Version (With Apache) PHP Install for Windows (With IIS 5,6) PHP & MySQL PHP Hello World PHP Extension phpinfo(); PHP register_global = On/Off
	PHP Syntax
	PHP Comment PHP = PHP Concat() PHP Echo() PHP Print() PHP Printf() PHP $$ PHP Flush() PHP Print_r()
	PHP Variable
	PHP Variable PHP Define PHP Defined PHP Global PHP Integer PHP Float PHP Boolean PHP String PHP Null PHP Empty PHP isset PHP Array PHP Object
	PHP Operators
	PHP Arithmetic Operators PHP String Operators PHP Assignment Operators PHP Logical Operators PHP Comparison Operators
	PHP Looping
	PHP while() PHP do..while() PHP for() PHP foreach() PHP break() PHP continue() PHP declare()
	PHP Constant
	PHP Constant Variable PHP Error Handling PHP System Variable
	PHP Include & Require
	PHP require() PHP require_once() PHP include() PHP include_once() PHP include & require
	PHP Condition
	PHP if() PHP if..else() PHP if-elseif() PHP switch() Case Statement PHP or PHP and PHP exit()
	PHP Predefined variables
	PHP Get ($_GET,$HTTP_GET_VARS) PHP Post ($_POST,$HTTP_POST_VARS) PHP Request ($_REQUEST) PHP Env ($_ENV,$HTTP_ENV_VARS) PHP Session ($_SESSION,$HTTP_SESSION_VARS) PHP Cookies ($_COOKIE,$HTTP_COOKIE_VARS) PHP File ($_FILES,$HTTP_POST_FILES) PHP Server ($_SERVER,$HTTP_SERVER_VARS)
	PHP Html & Element
	PHP HTML & Table PHP Form PHP Button Submit PHP Input Text Field / Textbox PHP Hidden Field PHP Input Textarea PHP Checkbox PHP Radio Button PHP Select/Listmenu PHP Jump Menu PHP File Field Upload PHP DropDownList / Listmenu From Database
	PHP Javascript & Event
	JavaScript HTML name,id JavaScript getElementById JavaScript OnClick JavaScript OnDblClick JavaScript OnKeyDown JavaScript OnKeyPress JavaScript OnKeyUp JavaScript OnMouseDown JavaScript OnMouseUp JavaScript OnMouseMove JavaScript OnMouseOut JavaScript OnMouseOver JavaScript OnSubmit JavaScript OnChange JavaScript OnFocus JavaScript OnBlur JavaScript OnError JavaScript OnLoad JavaScript OnUnload JavaScript OnReset JavaScript OnResize
	PHP Javascript & Validation
	JavaScript Submit & Button JavaScript alert & confirm JavaScript HTML Submit Form JavaScript HTML Multiple Action Form JavaScript HTML Check Input TextBox/Text Field JavaScript HTML Check Checkbox JavaScript HTML Check Radio Button JavaScript HTML Back/Next/Close/Print JavaScript HTML Disable & Enable Html Element JavaScript HTML Show/Hide Html Element JavaScript Auto Print Preview JavaScript Reload/Refresh Webpage JavaScript Auto Redirect JavaScript Timers Delay setTimeout HTML Redirect / Refresh Webpage JavaScript Click Check All and Un Check All
	PHP VBScript & Event
	VBScript HTML name,id VBScript getElementById,getElementsByName VBScript OnClick VBScript OnDblClick VBScript OnKeyDown VBScript OnKeyPress VBScript OnKeyUp VBScript OnMouseDown VBScript OnMouseUp VBScript OnMouseMove VBScript OnMouseOut VBScript OnMouseOver VBScript OnSubmit VBScript OnChange VBScript OnFocus VBScript OnBlur VBScript OnError VBScript OnLoad VBScript OnUnload VBScript OnReset VBScript OnResize VBScript Event
	PHP VBScript & Validation
	VBScript Submit & Button VBScript Msgbox VBScript InputBox VBScript Submit Form VBScript HTML Multiple Action Form VBScript HTML Check Input Text Field VBScript HTML Check Checkbox VBScript HTML Check Radio Button VBScript HTML Back/Next/Close/Print VBScript HTML Disable & Enable Html Element
	PHP Math Functions
	PHP round() PHP max() PHP min() PHP is_nan() PHP number_format() PHP octdec() PHP pi() PHP pow() PHP rad2deg() PHP rand() PHP mt_rand() PHP decbin() PHP dechex() PHP decoct() PHP deg2rad() PHP exp() PHP getrandmax() PHP hexdec() PHP log() PHP log10() PHP cos() PHP sin() PHP tan() PHP bindec() PHP atan() PHP asin() PHP acos() PHP abs()
	PHP String Functions
	PHP strlen() PHP strpos() PHP strrchr() PHP str_repeat() PHP strrev() PHP strrpos() PHP strstr() PHP strtolower() PHP strtoupper() PHP str_replace() PHP strtr() PHP substr() PHP substr_replace() PHP trim() PHP ucfirst() PHP ucwords() PHP stristr() PHP strip_tags() PHP strchr() PHP sprintf() PHP similar_text() PHP setlocale() PHP parse_str() PHP ord() PHP ltrim() PHP rtrim() PHP join() PHP implode() PHP htmlspecialchars() PHP flush() PHP eregi_replace() PHP ereg_replace() PHP explode() PHP echo() PHP print() PHP printf() PHP chr() PHP chop() PHP md5() PHP base64_encode() PHP base64_decode() PHP nl2br() PHP urlencode() PHP addslashes() PHP eval()
	PHP Date & Time
	PHP Date/Time PHP Getdate() PHP strptime PHP Compare Date/Time PHP DateDiff / TimeDiff PHP DateAdd PHP Thai Date/Time Function PHP date_parse
	PHP Files
	PHP mkdir() Create Directory PHP rmdir() Delete/Remove Directory PHP file_exists() Checks Exists files PHP scandir() Read file in Folder ,List Directory PHP opendir() List Directory PHP fopen() Create a file PHP fopen(),fgets() read text file PHP fseek() fread() text file PHP fgetc() text file PHP fopen(),fwrite() write text file PHP copy() text file PHP rename() text file PHP unlink() delete file PHP Disk/Dirve Space PHP Search Text file PHP Get File Properties
	PHP EnCode/DeCode
	PHP md5() PHP base64_encode() PHP base64_decode()
	PHP User-defined functions
	PHP Function Introduction PHP Function Non arguments PHP Function arguments PHP Function Non Returning values PHP Function Returning values
	PHP Extension php.ini
	Download php_gd2.dll Download php_mssql.dll Download php_mysql.dll Download php_oci8.dll Download php_zip.dll Download php_sockets.dll Download php_pgsql.dll Download php_fdf.dll Download php_mbstring.dll Download php_dbase.dll Download php_mcrypt.dll Download ntwdblib.dll
	PHP Upload file
	PHP Upload Single file field PHP Upload Mutiple file field
	PHP Sending Mail
	PHP Sending Email / Send Mail PHP Sending Email Name Alias PHP Sending Email Cc and Bcc PHP Sending Email Reply-To Header PHP Sending Email HTML Format PHP Sending Email Attachment Files PHP Sending Email Contact Form PHP Sending Email Set Priority PHP Sending Email Upload Form & Attachment Files PHP Sending Email Multiple Array Upload Form & Attachment File PHP Sending Email Upload,Zip & Attachment Files PHP Sending Email Using Gmail Account Authentication PHP Sending Email Using SMTP Authentication PHP Mail Class (MIMEMAIL V 1.5)
	PHP Database SQL
	SQL Database & Table SQL SELECT SQL WHERE SQL ALIAS SQL OR AND SQL ORDER BY SQL SUB SELECT QUERY SQL SELECT INTO SQL BETWEEN SQL JOIN SQL OUTER JOIN SQL RIGHT JOIN SQL LEFT JOIN SQL UNION SQL DISTINCT SQL TOP SQL LIMIT SQL ROWNUM SQL RAND SQL LIKE SQL NOT LIKE SQL INSERT SQL UPDATE SQL INSERT … SELECT SQL DELETE SQL IN SQL NOT IN SQL GROUP BY SQL HAVING SQL COUNT SQL MAX SQL MIN SQL REPLACE SQL SUM SQL AVG SQL CONCAT SQL LENGTH SQL TRIM SQL SUBSTRING SQL TRUNCATE,DROP SQL INSERT DUPLICATE KEY UPDATE SQL COPY TABLE SQL CREATE TABLE SQL PRIMARY KEYS SQL CREATE INDEX SQL UNIQUE SQL AUTO_INCREMENT For MySQL SQL AUTO_INCREMENT/IDENTITY For SQL SERVER SQL AUTO_INCREMENT For ORACLE SQL INSERT INTO…SET SQL CREATE DATABSE SQL CASE..WHEN SQL NULL / ISNULL SQL CASCADE ONUPDATE/ONDELETE SQL FIRST SQL EXISTS SQL ALTER SQL DROP SQL UNION ALL SQL AS SQL LAST SQL MYSQL IF SQL DATE , DAY , MONTH , YEAR SQL MYSQL DATE_FORMAT SQL MYSQL DATE_ADD() SQL MYSQL DATEDIFF() SQL MID SQL UCASE , UPPER SQL LCASE , LOWER SQL LEN SQL ROUND SQL NOW() SQL GETDATE() SQL SYSDATE() SQL REPAIR TABLE SQL USE SQL RENAME TABLE SQL RENAME DATABASE SQL ORACLE IMP (Import Database) SQL ORACLE EXP (Export Database) SQL OPTIMIZE TABLE SQL CONVERT
	PHP MySQL
	MySQL Introduction MySQL Installation MySQL phpMyAdmin Tools MySQL phpMyAdmin Create Database & Table MySQL phpMyAdmin Import/Export Table MySQL Relation CasCade On Delete/On Update MySQL Data Source Config ODBC (DSN) PHP MySQL Connect to Database PHP MySQL List Table Properties PHP MySQL List Record PHP MySQL Random Record PHP MySQL List Record Paging/Pagination PHP MySQL Search Record PHP MySQL Search Record Paging/Pagination PHP MySQL Multiple Column PHP MySQL Multiple Column and Paging/Pagination PHP MySQL Add/Insert Record PHP MySQL Add/Insert Multiple Record PHP MySQL Check Already Exists Add/Insert Record PHP MySQL Edit/Update Record PHP MySQL Multiple Rows Edit/Update Record PHP MySQL Delete Record/Confirm Delete PHP MySQL Multiple Checkbox Delete Record PHP MySQL Add/Insert/Edit/Delete to MySQL On Same Form PHP MySQL Transaction (Begin,Commit,RollBack) PHP MySQL Used Require/Include PHP MySQL Used Function Database Query PHP MySQL Database Class PHP MySQL (Thai Support) PHP MySQL : Upload file to MySQL PHP MySQL Multiple Upload File to MySQL Database – CreateElement Input File Upload PHP MySQL DropDownList / Listmenu / ListBox PHP MySQL Upload File to MySQL Database – Multiple Dynamic CreateElement Input File Upload
	PHP Microsoft Access
	Microsoft Access Introduction Microsoft Access Installation Microsoft Access Create Database and Table Microsoft Access Relation CasCade On Delete/On Update Microsoft Access Config (DSN) – Data Source (ODBC) Microsoft Access Import/Export Microsoft Access Import Database PHP Microsoft Access Connect to Database (PHP ODBC) PHP Microsoft Access List Table Properties (PHP ODBC) PHP Microsoft Access List Record (PHP ODBC) PHP Microsoft Access Random Record (PHP ODBC) PHP Microsoft Access List Record Paging/Pagination (PHP ODBC) PHP Microsoft Access Search Record (PHP ODBC) PHP Microsoft Access Search Record Paging/Pagination (PHP ODBC) PHP Microsoft Access Multiple Column (PHP ODBC) PHP Microsoft Access Multiple Column and Paging/Pagination (PHP ODBC) PHP Microsoft Access Add/Insert Record (PHP ODBC) PHP Microsoft Access Check Already Exists Add/Insert Record (PHP ODBC) PHP Microsoft Access Edit/Update Record (PHP ODBC) PHP Microsoft Access Delete Record (PHP ODBC) PHP Microsoft Access Multiple Checkbox Delete Record (PHP ODBC) PHP Microsoft Access Transaction (TRANSACTION,COMMIT,ROLLBACK) PHP Microsoft Access Used Require Function (PHP ODBC) PHP Microsoft Access Used Function Database Query (PHP ODBC) PHP Microsoft Access Database Class (PHP ODBC)
	PHP SQL Server
	SQL Server Introduction SQL Server Installation SQL Server Create Database and Table SQL Server Relation CasCade On Delete/On Update SQL Server Data Source Config (DSN) Database SQL Server Export/Backup SQL Server Restore Database PHP SQL Server Connect to Database (mssql) PHP SQL Server Connect to Database (ODBC) PHP SQL Server List Table Properties (mssql) PHP SQL Server List Record (mssql) PHP SQL Server Random Record (mssql) PHP SQL Server List Record Paging/Pagination (mssql) PHP SQL Server Search Record (mssql) PHP SQL Server Search Record Paging/Pagination (mssql) PHP SQL Server Multiple Column (mssql) PHP SQL Server Multiple Column and Paging/Pagination (mssql) PHP SQL Server Add/Insert Record (mssql) PHP SQL Server Check Already Exists Add/Insert Record (mssql) PHP SQL Server Edit/Update Record (mssql) PHP SQL Server Delete Record (mssql) PHP SQL Server Multiple Checkbox Delete Record (mssql) PHP SQL Server Transaction (BEGIN TRAN,COMMIT,ROLLBACK) (mssql) PHP SQL Server Used Require Function (mssql) PHP SQL Server Used Function Database Query (mssql) PHP SQL Server Database Class (mssql)
	PHP PHP SQL Server 2005
	SQL Server 2005 Introduction SQL Server 2005 Installation SQL Server 2005 Authentication Mode SQL Server 2005 Create Database and Table SQL Server 2005 Relation CasCade On Delete/On Update SQL Server 2005 Data Source Config (DSN) SQL Server 2005 Export/Backup Database SQL Server 2005 Restore Database PHP & SQL Server 2005
	PHP PHP SQL Server 2008
	SQL Server 2008 Introduction SQL Server 2008 Installation SQL Server 2008 Authentication Mode SQL Server 2008 Create Database and Table SQL Server 2008 Relation CasCade On Delete/On Update SQL Server 2008 Export & Backup SQL Server 2008 Restore Database SQL Server 2008 ODBC (DSN) On Windows 7 PHP & SQL Server 2008
	PHP Oracle
	Oracle Introduction Oracle Installation & Configuration Oracle Create/Grant User Oracle Create Table Oracle Create TNS Name (Net Service) Oracle Relation CasCade On Delete/On Update (Foreign) Oracle Export/Import Table Oracle Data Source Config (DSN) PHP Oracle Config OCI8 Support PHP Oracle Connect to Database PHP Oracle List Table Properties PHP Oracle List Record PHP Oracle Random Record PHP Oracle List Record Paging/Pagination PHP Oracle Search Record PHP Oracle Search Record Paging/Pagination PHP Oracle Multiple Column PHP Oracle Multiple Column and Paging/Pagination PHP Oracle Add/Insert Record PHP Oracle Check Already Exists Add/Insert Record PHP Oracle Edit/Update Record PHP Oracle Delete Record PHP Oracle Multiple Checkbox Delete Record PHP Oracle Transaction (oci_rollback,oci_commit) PHP Oracle Used Include Function PHP Oracle Used Function Database Query PHP Oracle Database Class
	PHP AdoDB
	PHP COM ADO (AdoDB) PHP ADO Connect to Database PHP ADO Table List Properties PHP ADO List Record PHP ADO List Record Paging/Pagination PHP ADO Search Record PHP ADO Add/Insert Record PHP ADO Edit Record PHP ADO Delete Record PHP ADO Transaction (BeginTrans,CommitTrans,RollbackTrans)
	PHP PDF Function
	PHP PDF PHP PDF – Header, footer, page break and image PHP PDF – Line breaks and colors PHP PDF – Multiple Columns PHP PDF – Insert Tables PHP PDF – Links and flowing text PHP PDF – MySQL Export to PDF PHP PDF – Export to PDF and Send Email Attachment
	PHP Image (GD)
	PHP GD PHP Create Image PHP Create text in image PHP Write text in Image PHP Upload and write text in image PHP Add Logo/CopyRight to Image (Watermark) PHP Upload and Add Logo to image PHP Resize image PHP Upload and Resize Image PHP Resize Thumbnails Image and Insert to MySQL PHP Multiple Upload & Multiple Resize to MySQL
	PHP Graph & Charts
	PHP Create Charts/Graph PHP JPGraph
	PHP Zip
	PHP Zip files PHP Extract Zip files PHP Upload and Zip files PHP Multiple File Upload and Zip file PHP Upload,Zip files and Send Email Attachment
	PHP CSV
	PHP Read CSV files (fgetcsv) PHP Convert/Export to CSV PHP Convert and Import CSV to MySQL Database PHP Upload and Convert/Import CSV To MySQL Database PHP Convert/Export MySQL To CSV PHP Convert/Export To CSV and Send Email Attachment
	PHP Excel (PHP Class)
	PHP Excel header("Content-type: application/vnd.ms-excel"); PHP Excel (PHP Class) PHP Export to Excel (PHP Class)
	PHP Excel (Excel.Application)
	PHP Config Excel (Excel.Application) PHP Connect to Excel.Application PHP Write Excel (Excel.Application) PHP Delete Sheet Excel (Excel.Application) PHP Write Excel Multiple Sheet (Excel.Application) PHP Excel Merge Cells (Excel Application) PHP Excel Cell Borders (Excel Application) PHP Excel Draw Line (Excel Application) PHP Excel Insert Picture (Excel Application) PHP Excel Open Document (Excel Application) PHP Write Excel Style & Format (Excel.Application) PHP Read Excel (Excel.Application) PHP Read Excel Multiple Sheet (Excel.Application) PHP ADO Excel (DRIVER={Microsoft Excel Driver (*.xls)}) PHP ADO Excel List Record Paging/Pagination (Microsoft Excel Driver (*.xls)) PHP Import Excel to MySQL Database (Excel.Application) PHP Export Database to Excel (Excel.Application) PHP Export Database to Excel Report/Print Format (Excel.Application) PHP Export to Excel and Send Email Attachment (Excel.Application)
	PHP Charts/Graph (Excel.Application)
	PHP Charts/Graph (Excel.Application) PHP Charts/Graph – Export to XML (Excel.Application) PHP Charts/Graph – Export to Gif,Jpg (Excel.Application) PHP Charts/Graph – Clustered Column 3D PHP Charts/Graph – Exploded pie 3D PHP Charts/Graph – Column Stacked PHP Charts/Graph – Line Markers Stacked PHP Charts/Graph – Cylinder Column Clustered PHP Charts/Graph – Cylinderical Shape 3D PHP Charts/Graph – Send Email Attachment
	PHP Word (Word.Application)
	PHP Word header("Content-type: application/vnd.ms-word"); PHP Config Word (Word.Application) PHP Connect to Word.Application PHP & Word (Word.Application) – Create Word Document PHP & Word (Word.Application) – Page Setup PHP & Word (Word.Application) – BuiltInDocumentProperties PHP & Word (Word.Application) – Font & Style PHP & Word (Word.Application) – Paragraphs & Range PHP & Word (Word.Application) – Page Breaking PHP & Word (Word.Application) – Create/Insert Table (Tables.Add) PHP & Word (Word.Application) – Add/Insert Picture (AddPicture) PHP & Word (Word.Application) – Open Document (Documents.Open) PHP & Word (Word.Application) – Word Document Sample Report PHP & Word (Word.Application) – Export and Send Email Attachment
	PHP PowerPoint (PowerPoint.Application)
	PHP Config PowerPoint (PowerPoint.Application) PHP Connect to PowerPoint.Application PHP & PowerPoint – Create Slides & Presentations PHP & PowerPoint – AddTextbox PHP & PowerPoint – Font Style PHP & PowerPoint – Add/Insert Picture (AddPicture) PHP & PowerPoint – Create Multiple Slides PHP & PowerPoint – Open Template Modify/Edit Slides PHP & PowerPoint – Save Slides To HTML Format PHP & PowerPoint – Convert PPT To HTML Slides PHP & PowerPoint – Convert PPT To WMF Format PHP & PowerPoint – Convert PPT To GIF Format PHP & PowerPoint – Convert PPT To JPG Format PHP & PowerPoint – Convert PPT To JPG Send Email Attachment
	PHP Ajax
	Ajax Introduction Ajax innerHTML & InnerText Ajax JavaScript & Event Ajax visibility hidden & visible Ajax Display Element Ajax Visibility & Display Ajax Disabled Element Ajax CreateElement Ajax setTimeOut Ajax responseText Ajax readyState Ajax Send Data Method POST (PHP & ASP) Ajax Send Data Method GET (PHP & ASP) Ajax Register Form (PHP+MySQL & ASP+Access) Ajax Login (PHP+MySQL & ASP+Access) Ajax Dropdownlist and Listmenu (PHP+MySQL & ASP+Access) Ajax Upload file (PHP & ASP) Ajax Load Content (PHP+MySQL & ASP+Access) Ajax Load Web Page (PHP & ASP) Ajax Loading Progress Icon Ajax List Record (PHP+MySQL & ASP+Access) Ajax List Record Paging/Pagination (PHP+MySQL & ASP+Access) Ajax Add/Insert Record (PHP+MySQL & ASP+Access) Ajax Edit/Update Record (PHP+MySQL & ASP+Access) Ajax Delete Record (PHP+MySQL & ASP+Access) Ajax Delete Record Part 2 (PHP+MySQL & ASP+Access) Ajax Search Record (PHP+MySQL & ASP+Access) Ajax Search Record Paging/Pagination (PHP+MySQL & ASP+Access) Ajax Chat Room (PHP+Text & ASP+Text) Ajax Shopping Cart (PHP+MySQL & ASP+Access) Ajax Contact Form (PHP & ASP) Ajax Image Gallery (PHP & ASP) Ajax Open Text file (PHP & ASP) Ajax Autocomplete Ajax Check Username (PHP+MySQL & ASP+Access) Ajax Auto Fill Textbox (PHP+MySQL & ASP+Access)
	PHP Authentication
	PHP User Login Authentication PHP User Login Authentication Simple Text files PHP User Login Authentication MySQL Database PHP User Login Authentication Active Directory (AD) PHP MySQL Login Form PHP MySQL Register Form