The XMLHttpRequest object makes AJAX possible. The XMLHttpRequest The XMLHttpRequest object is the key to AJAX. It has been available ever since Internet Explorer 5.5 was released in July 2000, but not fully discovered before people started to talk about AJAX and Web 2.0 in 2005. Creating An XMLHttpRequest Object Different browsers use different methods… Read More »
AJAX = Asynchronous JavaScript And XML AJAX is an acronym for Asynchronous JavaScript And XML. AJAX is not a new programming language, but simply a new technique for creating better, faster, and more interactive web applications. AJAX uses JavaScript to send and receive data between a web browser and a web server. The AJAX technique… Read More »
Simple XML handles the most common XML tasks and leaves the rest for other extensions. What is SimpleXML? SimpleXML is new in PHP 5. It is an easy way of getting an element’s attributes and text, if you know the XML document’s layout. Compared to DOM or the Expat parser, SimpleXML just takes a few… Read More »
The built-in DOM parser makes it possible to process XML documents in PHP. What is DOM? The W3C DOM provides a standard set of objects for HTML and XML documents, and a standard interface for accessing and manipulating them. The W3C DOM is separated into different parts (Core, XML, and HTML) and different levels (DOM… Read More »
The built-in Expat parser makes it possible to process XML documents in PHP. What is XML? XML is used to describe data and to focus on what data is. An XML file describes the structure of the data. In XML, no tags are predefined. You must define your own tags. What is Expat? To read… Read More »
ODBC is an Application Programming Interface (API) that allows you to connect to a data source (e.g. an MS Access database). Create an ODBC Connection With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available. Here is how to create an… Read More »
The DELETE statement is used to delete records in a table. Delete Data In a Database The DELETE FROM statement is used to delete records from a database table. Syntax DELETE FROM table_nameWHERE some_column = some_value Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should… Read More »
The UPDATE statement is used to modify data in a table. Update Data In a Database The UPDATE statement is used to update existing records in a table. Syntax UPDATE table_nameSET column1=value, column2=value2,…WHERE some_column=some_value Note: Notice the WHERE clause in the UPDATE syntax. The WHERE clause specifies which record or records that should be updated.… Read More »
The ORDER BY keyword is used to sort the data in a recordset. The ORDER BY Keyword The ORDER BY keyword is used to sort the data in a recordset. The ORDER BY keyword sort the records in ascending order by default. If you want to sort the records in a descending order, you can… Read More »
The WHERE clause is used to filter records. The WHERE clause The WHERE clause is used to extract only those records that fulfill a specified criterion. Syntax SELECT column_name(s)FROM table_nameWHERE column_name operator value To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query… Read More »