tag:blogger.com,1999:blog-1839248648198990503Tue, 10 Sep 2024 16:06:07 +0000PHP BasicPHP AdvancedPHP DatabasePHP and AJAXPHP XMLLearn My Own PHPThis is how i learn and everything i learn about PHP. And i hope that it can help other people to learn about PHP.http://learn-my-own-php.blogspot.com/noreply@blogger.com (Unknown)Blogger47125tag:blogger.com,1999:blog-1839248648198990503.post-5737610101283581891Wed, 04 Jun 2008 01:53:00 +00002008-06-03T19:30:08.759-07:00PHP and AJAXPHP and AJAX PollAJAX Suggest In the AJAX example below we will demonstrate a poll where the web page can get the result without reloading. Do you like PHP and AJAX so far? Yes: No: This example consists of four pages:a simple HTML forma JavaScripta PHP pagea text file to store the results The HTML Form This is the HTML page. It contains a simple HTML form and a link to a JavaScript: <html>http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-poll.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-835197141982700535Wed, 04 Jun 2008 01:39:00 +00002008-06-03T18:53:31.303-07:00PHP and AJAXPHP and AJAX RSS ReaderAn RSS Reader is used to read RSS Feeds RSS allows fast browsing for news and updates AJAX RSS Reader In the AJAX example below we will demonstrate an RSS reader where the content from the RSS is loaded into the webpage without refreshing. Select an RSS News Feed in the Box Below Select an RSS-Feed: Google News MSNBC News RSS Feed will be listed here. This example consists of three http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-rss-reader.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-699584492418829208Wed, 04 Jun 2008 01:32:00 +00002008-06-03T18:39:37.919-07:00PHP and AJAXPHP and AJAX Live SearchAJAX can be used for a more user friendly and interactive search. AJAX Live Search In the AJAX example below we will demonstrate a live search, where the server gets search results while the user types. Live search has many benefits compared to traditional searching: Matching results are shown as you typeResults narrow as you continue typingIf results become too narrow, remove characters to http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-live-search.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-8730454669276584079Wed, 04 Jun 2008 01:28:00 +00002008-06-03T18:32:04.220-07:00PHP and AJAXPHP and AJAX responseXML ExampleAJAX can be used to return database information as XML. AJAX Database as XML Example In the AJAX example below we will demonstrate how a web page can fetch information from a MySQL database, convert it to an XML document, and use it to display information in several different places. This example my seem a lot like the "PHP AJAX Database" example in the last chapter, however there is a big http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-responsexml-example.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-4200072801151128262Wed, 04 Jun 2008 01:03:00 +00002008-06-03T18:28:17.521-07:00PHP and AJAXPHP and AJAX MySQL Database ExampleAJAX can be used for interactive communication with a database. AJAX Database Example In the AJAX example below we will demonstrate how a web page can fetch information from a MySQL database using AJAX technology. Select a Name in the Box Below Select a User: Peter Griffin Lois Griffin Joseph Swanson Glenn Quagmire User info will be listed here. This example consists of four elements: a http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-mysql-database-example.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-1154686965388119513Wed, 04 Jun 2008 01:00:00 +00002008-06-03T18:03:41.064-07:00PHP and AJAXPHP and AJAX XML ExampleAJAX can be used for interactive communication with an XML file. AJAX XML Example In the AJAX example below we will demonstrate how a web page can fetch information from an XML file using AJAX technology. Select a CD in the Box Below Select a CD: Bob Dylan Bee Gees Cat Stevens CD info will be listed here. This example consists of four pages: a simple HTML forman XML filea http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-xml-example.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-5384300624936600886Wed, 04 Jun 2008 00:57:00 +00002008-06-03T18:00:27.327-07:00PHP and AJAXPHP and AJAX SuggestAJAX Suggest In the AJAX example below we will demonstrate how a web page can communicate with a web server online as a user enters data into a web form. Type a Name in the Box Below First Name: Suggestions: This example consists of three pages: a simple HTML forma JavaScripta PHP page The HTML Form This is the HTML page. It contains a simple HTML form and a link to a JavaScript: &http://learn-my-own-php.blogspot.com/2008/06/php-and-ajax-suggest.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-6275112446062510025Wed, 04 Jun 2008 00:53:00 +00002008-06-03T17:57:15.736-07:00PHP and AJAXAJAX XMLHttpRequestThe 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 to create an XMLHttpRequest object. http://learn-my-own-php.blogspot.com/2008/06/ajax-xmlhttprequest.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-3351312284526577534Wed, 04 Jun 2008 00:48:00 +00002008-06-03T17:53:13.700-07:00PHP and AJAXAJAX IntroductionAJAX = 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 makes web pages more responsive by exchanging data with http://learn-my-own-php.blogspot.com/2008/06/ajax-introduction.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-4096369980956021888Wed, 04 Jun 2008 00:44:00 +00002008-06-03T17:48:10.688-07:00PHP XMLPHP SimpleXMLSimpleXML 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 lines of code to read text data from an element. SimpleXML converts the XML document into an http://learn-my-own-php.blogspot.com/2008/06/php-simplexml.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-2578280702840782203Wed, 04 Jun 2008 00:37:00 +00002008-06-03T17:44:52.680-07:00PHP XMLPHP XML DOMThe 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 Level 1/2/3):* Core DOM - defines a standard set of objects for any http://learn-my-own-php.blogspot.com/2008/06/php-xml-dom.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-751600932990422812Wed, 04 Jun 2008 00:35:00 +00002008-06-03T17:37:51.466-07:00PHP XMLPHP XML Expat ParserThe 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 and update - create and manipulate - an XML document, you will need an XML parser. There are two basic http://learn-my-own-php.blogspot.com/2008/06/php-xml-expat-parser.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-8577375527167439936Tue, 03 Jun 2008 08:19:00 +00002008-06-03T01:21:38.451-07:00PHP DatabasePHP Database ODBCODBC 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 ODBC connection to a MS Access Database: Open the Administrative Tools icon in http://learn-my-own-php.blogspot.com/2008/06/php-database-odbc.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-7152357806075856962Tue, 03 Jun 2008 08:17:00 +00002008-06-03T01:19:38.834-07:00PHP DatabasePHP MySQL Delete FromThe DELETE FROM statement is used to delete rows from a database table. Delete Data In a Database The DELETE FROM statement is used to delete records from a database table. Syntax DELETE FROM table_nameWHERE column_name = some_value Note: SQL statements are not case sensitive. DELETE FROM is the same as delete from.To get PHP to execute the statement above we must use the http://learn-my-own-php.blogspot.com/2008/06/php-mysql-delete-from.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-5049567031576839549Tue, 03 Jun 2008 08:14:00 +00002008-06-03T01:17:49.866-07:00PHP DatabasePHP MySQL UpdateThe UPDATE statement is used to modify data in a database table. Update Data In a Database The UPDATE statement is used to modify data in a database table. Syntax UPDATE table_nameSET column_name = new_valueWHERE column_name = some_value Note: SQL statements are not case sensitive. UPDATE is the same as update.To get PHP to execute the statement above we must use the mysql_query()http://learn-my-own-php.blogspot.com/2008/06/php-mysql-update.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-2267771782305394962Tue, 03 Jun 2008 08:10:00 +00002008-06-03T01:13:28.604-07:00PHP DatabasePHP MySQL Order By KeywordThe 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. Syntax SELECT column_name(s)FROM table_nameORDER BY column_name Note: SQL statements are not case sensitive. ORDER BY is the same as order by. Example The following example selects all the data stored in the "Person" table, http://learn-my-own-php.blogspot.com/2008/06/php-mysql-order-by-keyword.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-3022888043878487742Tue, 03 Jun 2008 07:34:00 +00002008-06-03T01:10:30.633-07:00PHP DatabasePHP MySQL The Where ClauseTo select only data that matches a specified criteria, add a WHERE clause to the SELECT statement. The WHERE clause To select only data that matches a specific criteria, add a WHERE clause to the SELECT statement. Syntax SELECT column FROM tableWHERE column operator value The following operators can be used with the WHERE clause: Operator Description = Equalhttp://learn-my-own-php.blogspot.com/2008/06/php-mysql-where-clause.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-8220751479421045592Tue, 03 Jun 2008 07:32:00 +00002008-06-03T00:34:32.746-07:00PHP DatabasePHP MySQL SelectThe SELECT statement is used to select data from a database. Select Data From a Database Table The SELECT statement is used to select data from a database. Syntax SELECT column_name(s)FROM table_name Note: SQL statements are not case sensitive. SELECT is the same as select. To get PHP to execute the statement above we must use the mysql_query() function. This http://learn-my-own-php.blogspot.com/2008/06/php-mysql-select.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-3655074257060846589Tue, 03 Jun 2008 07:18:00 +00002008-06-03T00:21:32.285-07:00PHP DatabasePHP MySQL Insert IntoThe INSERT INTO statement is used to insert new records into a database table. Insert Data Into a Database Table The INSERT INTO statement is used to add new records to a database table. Syntax INSERT INTO table_nameVALUES (value1, value2,....) You can also specify the columns where you want to insert the data: INSERT INTO table_name (column1, column2,...)VALUES (value1, http://learn-my-own-php.blogspot.com/2008/06/php-mysql-insert-into.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-97983713112892678Tue, 03 Jun 2008 07:14:00 +00002008-06-03T00:18:14.404-07:00PHP DatabasePHP MySQL Create Database and TablesA database holds one or multiple tables. Create a Database The CREATE DATABASE statement is used to create a database in MySQL. Syntax CREATE DATABASE database_name To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.Example In the following example we create a database called "http://learn-my-own-php.blogspot.com/2008/06/php-mysql-create-database-and-tables.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-476480839131813818Tue, 03 Jun 2008 07:12:00 +00002008-06-03T00:13:55.633-07:00PHP DatabasePHP MySQL Connect to a DatabaseThe free MySQL Database is very often used with PHP. Connecting to a MySQL Database Before you can access and work with data in a database, you must create a connection to the database. In PHP, this is done with the mysql_connect() function. Syntax mysql_connect(servername,username,password); Parameter Description servername Optional. Specifies the server http://learn-my-own-php.blogspot.com/2008/06/php-mysql-connect-to-database.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-1463679944505266319Tue, 03 Jun 2008 07:09:00 +00002008-06-03T00:10:33.464-07:00PHP DatabasePHP MySQL IntroductionMySQL is the most popular open source database server. What is MySQL? MySQL is a database. A database defines a structure for storing information. In a database, there are tables. Just like HTML tables, database tables contain rows, columns, and cells. Databases are useful when storing information categorically. A company may have a database with the following tables: "Employees", "Products"http://learn-my-own-php.blogspot.com/2008/06/php-mysql-introduction.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-418526567409436966Tue, 03 Jun 2008 05:43:00 +00002008-06-02T22:48:48.860-07:00PHP AdvancedPHP FilterPHP filters are used to validate and filter data coming from insecure sources, like user input. What is a PHP Filter? A PHP filter is used to validate and filter data coming from insecure sources. To test, validate and filter user input or custom data is an important part of any web application. The PHP filter extension is designed to make data filtering easier and quicker. Why use a http://learn-my-own-php.blogspot.com/2008/06/php-filter.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-136545076408473089Tue, 03 Jun 2008 05:39:00 +00002008-06-02T22:43:16.809-07:00PHP AdvancedPHP Exception HandlingExceptions are used to change the normal flow of a script if a specified error occurs What is an Exception With PHP 5 came a new object oriented way of dealing with errors. Exception handling is used to change the normal flow of the code execution if a specified error (exceptional) condition occurs. This condition is called an exception.This is what normally happens when an exception is http://learn-my-own-php.blogspot.com/2008/06/php-exception-handling.htmlnoreply@blogger.com (Unknown)0tag:blogger.com,1999:blog-1839248648198990503.post-4462454354094753151Tue, 03 Jun 2008 05:34:00 +00002008-06-02T22:38:59.475-07:00PHP AdvancedPHP Error HandlingThe default error handling in PHP is very simple. An error message with filename, line number and a message describing the error is sent to the browser. PHP Error Handling When creating scripts and web applications, error handling is an important part. If your code lacks error checking code, your program may look very unprofessional and you may be open to security risks. This tutorial http://learn-my-own-php.blogspot.com/2008/06/php-error-handling.htmlnoreply@blogger.com (Unknown)0