Tutorials by Alva
The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause.
October 1,
2007
Today Views:
1 Total Views:
197
If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join.
September 28,
2007
Today Views:
2 Total Views:
194
Many tables require an ID column to assign a unique ID number for each row in the table.
September 27,
2007
Today Views:
2 Total Views:
227
If you want to insert a row of data into an existing table, you can use the INSERT INTO statement...
September 25,
2007
Today Views:
3 Total Views:
234
If you want to create a table in the database connected through a ODBC DSN, you can run the CREATE TABLE SQL statement using the odbc_exec() function...
September 24,
2007
Today Views:
2 Total Views:
198
A collection of 14 tutorials on Apache and PHP installation and configuration covering: How to download and install Apache 2.x and PHP 5; How to start Apache server; How to publish HTML documents; How to set PATH variable for PHP; How to create php.ini; How to configure Apache to use PHP as CGI; etc
August 27,
2007
Today Views:
3 Total Views:
273
A collection of 18 FAQs on connecting to MS SQL Server with PHP scripts. Clear explanations and tutorial exercises are provided on SQL Server connection; providing port number; selecting database; running SQL statements; checking execution errors; looping through query result; looping through result.
July 31,
2007
Today Views:
1 Total Views:
215
A collection of 14 FAQs on using PHP ODBC functions to connect to SQL Server databases. Clear explanations and tutorial exercises are provided on testing ODBC DSN settings; creating connection to a SQL Server through a DSN; executing SQL statements; looping through result set, etc.
July 2,
2007
Today Views:
3 Total Views:
290
When data needs to be presented in Web pages, HTML special characters must be well protected Otherwise, data well not be presented properly, or the Web will become corrupted. This page allows you to learn and test the htmlspecialchars() function to protect embedded data in Web pages.
June 5,
2007
Today Views:
3 Total Views:
290
A collection of 19 tips on understanding and using sessions in PHP. Clear explanations and tutorial exercises are provided on starting and closing sessions, saving and retrieving values in sessions, deciding how session IDs to be transferred, deciding where to store session files etc.
May 9,
2007
Today Views:
1 Total Views:
340
