Web Hosting PHP - PHP4, PHP5 Programming Blog

The above screenshot displays the user’s account details. The user should select the appropriate link to view the details of an order: The above screenshot displays the details of an item ordered by the user. From here, the user can either go back to the previous (view account) screen by selecting the BACK soft link, or can go to the home page of the application by selecting the HOME soft link: The Application Code Let’s walk through the code. The script Common.php contains variable definitions and functions that are used across the whole application. The following variables contain the information for accessing the back-end database. Before running the application, make sure you change these variables to reflect your installation environment: “); printf(”n”); Generate a WML card that displays the error message: printf(”n”); printf(”

n”); printf(”%s”, $mesg); printf(”

n”); printf(”n”); Page 554
Note: If you are looking for cheap and quality provider to host and run your java application check Astra java hosting services

viagra soft en ligne france
propecia prezzo farmacia
viagra super active online
propecia rezeptfrei kaufen
lovegra preisvergleich
clomid farmacia
cialis prezzo farmacia
prix lasix
amoxil ohne rezept kaufen
kamagra online
vente clomid en ligne
antabuse vendita
acheter vigora france
pilule france
kamagra soft online
costo cytotec farmacia
pilule en ligne
vendita kamagra soft
vente kamagra oral jelly
zyloprim kaufen
levitra en ligne
acheter intagra en pharmacie
accutane vendita senza ricetta
silagra rezeptfrei
acheter kamagra oral jelly en france
farmacia online vendita
prix viagra soft france
amoxil rezeptfrei
paxil france
acheter pharmacie
cialis super active prezzo farmacia
viagra super active costo
viagra kaufen
viagra super active vente en ligne
vendita lovegra italia
nolvadex pharmacie
levitra en ligne
cialis prix pharmacie
cytotec costo farmacia
cialis soft italia
vigora acheter
viagra super active vendita italia
farmacia online vendita
paxil prix pharmacie
cialis en france
levitra pharmacie
tadalis sx italia

драйвера samsung gt b7722 duos
скачать драйвер genius eye312 формы и методы руководства
скачать драйвер laserjet p2055dn скачать руководство mitsubishi lancer cedia
acer 1410 драйвера
драйвера для видеокарт ati catalyst руководство по ремонту mercury
ga ma770 ds3 драйвера руководство по эксплуатации шевроле авео
mustek 2448 драйвер скачать volvo руководство по ремонту скачать руководство по эксплуатации зил
asus z99h драйвера скачать
dell latitude d505 драйвера
скачать драйвер с media ac97
samsung e840 драйвер
драйвера hp pavilion dv 5 руководство по эксплуатации электровоза
неофициальные драйверы nvidia sheriff руководство пользователя
драйвер mustek 1200 ub руководство по эксплуатации ssangyong actyon dodge caliber руководство по эксплуатации
chicony kb 0401 драйвер руководство по эксплуатации киа рио руководство по эксплуатации мотоблока
драйвер для видеокарты sis 330
драйвер hp deskjet d1500 руководство по ремонту акцент
realtek alc888 скачать драйвер руководство русское радио
lenovo g550 драйвера
драйвера ati 10.7
realtek alc883 via vt8237a драйвер
драйвера для samsung i7500
драйвера roverbook v555 21074 руководство по ремонту спт 941 руководство по эксплуатации
драйвера nvidia g98 руководство по ремонту хонда джаз руководство по ремонту peugeot 605
последние драйвера для radeon 9600 маз руководство скачать нива руководство по ремонту скачать
драйвер для samsung gt e2530 1с версия 7.7 руководство пользователя
hp 1505 драйвер скачать
драйвер nvidia geforce g 105m
creative sb0100 драйвер
драйвер для seagate freeagent go mitsubishi grandis руководство
asus eah4850 драйвер скачать руководство по ремонту муравей скачать
скачать драйвер nvidia 5700
скачать wdm драйвер beholder
скачать драйвер hp f 4180
asus f3t драйвера windows 7 нокиа 5800 руководство по эксплуатации скачать руководство по эксплуатации мерседес
scx 4200 драйвер
скачать драйвера для видеокарты intel excel 2003 руководство
ecs k7vta3 драйвера
драйвер via s3g unichrome pro niva chevrolet руководство по эксплуатации ваз 21110 руководство
ecs 845pe a800 драйвера руководство по ремонту bmw e28 восстание под руководством е пугачева
как правильно обновить драйвера nvidia руководство по эксплуатации форд скорпио
скачать драйвер bearpaw 2448cs
toshiba satellite l300 sata драйвер руководство 2105 руководство по эксплуатации автомобиля opel
драйвер эпсон с91
acer aspire one zg5 драйвера руководство овд hd2 руководство
скачать драйвера acer aspire 4520 ipod touch руководство анализ высшего руководства
nvidia драйвер скачать windows 7 стили руководства в картинках
драйвера на видеокарту geforce 9500 общее руководство таможенным делом осуществляется руководство по эксплуатации калина
драйвер ecs l4igvm6 lanos руководство по эксплуатации
a4tech скачать драйвер
драйвера panasonic lumix fiat ducato руководство по ремонту руководство по ремонту автомобиля opel
ga p31 es3g драйвер руководство по эксплуатации шевроле блейзер
драйвер mustek 12000p руководство по строительству линейных сооружений
agp 9550 драйвер тарифное руководство скачать
canon canoscan 4400f драйвер
radeon hd 4580 драйвер скачать руководство по ремонту фольксваген транспортер руководство пользователя credo
toshiba satellite a200 14d драйвера руководство по эксплуатации 21093 скачать
asus vk193d драйвер
драйвер сетевой карты nvidia nforce cerato руководство по ремонту мультимедийное руководство по автомобилям ваз
самсунг s3600i драйвера руководство пользователя 1с упп
драйвер epson stylus c79 скачать руководство к действию шлахтер
asus eee pc 1015pe драйвера
syncmaster 551s скачать драйвер руководство партнерство
скачать драйвер hp photosmart c4400 нептун 23 руководство по эксплуатации
radeon 9600 256mb драйвер руководство элантра руководство по ремонту рено логан
asus pro5ij драйвера kalina руководство по эксплуатации руководство по ремонту ситроен с2
драйвер creative labs sb0410
ati radeon 1250 драйвер pinnacle 14 руководство
hd3450 agp драйвер cisco packet tracer руководство
драйвера compaq 620
драйвер canon pixma mp130 руководство сюжетно ролевой игрой дошкольников
samsung 3600i скачать драйвера flash cs3 недостающее руководство ubuntu 10 краткое руководство пользователя
драйвер radeon x1600 windows 7 методическое руководство по практической магии руководство по ремонту автомобиля опель
biostar p4m80 m4 драйвера патриот руководство по эксплуатации стили руководства в образовании
драйвера для мфу lexmark тюнинг мотоциклов руководство руководство по ремонту jetta
драйвера для мфу canon
драйвер realtek rtl8100c iveco daily руководство по ремонту
asus ah3450 драйвер e71 руководство
драйвера на самсунг е250 элантра руководство по эксплуатации tomahawk 9030 руководство
s3 trio64v2 драйвер
samsung gt s3650 corby драйвера
acer travelmate 2450 драйвера ist toyota руководство по эксплуатации
xerox pe220 драйвер скачать
benq 5250c драйвер toyota corolla fielder руководство nissan bluebird 1996 2001 руководство
драйвер panasonic kx mb763ru эффективное руководство группой базы руководств ремонта
acer aspire 3682wxc драйвера rav4 руководство
скачать драйвера для asus x61s руководство по ремонту хендай туссан скачать руководство бмв х3
asus f3jp драйвера руководство по монтажу сайдинга руководство по эксплуатации автомобиля ока
драйвера ati 9.12
драйвер для принтера canon i350 pinnacle studio 12 руководство toyota celica руководство по ремонту
драйвер pinnacle 710 usb стили руководства в организации
compaq 500b драйвера
ecs c51gm m драйвер скачать руководство по проектированию аэродромов содержание руководства по эксплуатации
драйвера samsung r25plus
lenovo 14002 драйвера kia руководство по ремонту
драйвера для acer extensa 4220
драйвер для dsl 2640u руководство по ремонту д 243
драйвер scx 4220 руководство по эксплуатации infiniti fx35
скачать драйвер samsung ml 1440 руководство по ремонту опель скачать
gigabyte ru драйвера для мамы руководство по ремонту ниссан навара dir 300 руководство на русском

Implementation We are now familiar with the requirements and important design issues of the shopping cart application. It is a good time to walk through the code. This section assumes that the readers are familiar with the WML syntax. Let’s first look at the application screenshots. This will help us in understanding the code better. Import To run the application from your PC, you will have to use a phone simulator. I ant used UP Simulator for testing the application, available from http://developer.phone.com/download/index.html. This is the main page of the application. From here, the existing users can go to the login screen, or new users can register themselves. To register, new users enter their name, user id, password, address, and credit card details. The user will be presented with a series of input forms (one per screen) for entering these details. The above screenshot is the first screen where the user enters their first name. In WML all the input forms cannot be displayed in one screen because of the display size limitations of the mobile devices. If the registration is successful then the following page is displayed, else an error message is displayed. The user can go to the login page, by selecting the Login page link: To login to the site the user enters their user id and password. If the authentication succeeds, then the main page of the application is returned: The adjacent screenshot is the main page of the application. When the user chooses Search they are shown a screen describing the search functionality of the application. The user should select the soft link OK to go to the next screen: The adjacent screenshot is the first input screen of the search menu. Here the user enters the search text, and presses the soft link OK to go to the next screen. Next, the user selects the search criteria and selects OK. Now the search request is sent to the server: The adjacent screenshot displays the search results. The user can select the link to view the details of the item: The above screenshot displays the details of the searched item. The user can either add the item to his cart by selecting the soft link ADD, or can go back to the earlier screen (Search Results) by selecting the soft link BACK. The user can then either view the details of the added item by selecting its link, or can view the contents of the cart by selecting the Display Cart link, or can go to the main page of the application by selecting the soft link HOME: The above screenshot displays the contents in the user’s cart. The user can view the details of an item by selecting the appropriate link. From here, the user can either change the quantity of this item by selecting the soft link CHG, or go back to the earlier (display cart) screen by selecting the BACK soft link: The above page is displayed when the user goes to the check out. From here, the user can either view the shipping address details by selecting the Address Details link, or can view their credit card details by selecting Credit Card Detailslink, or can go to the home page of the application: Page 553
Hint: If you are looking for high quality webhost to host and run your jsp application check Vision web hosting jsp services

. Open a database connection . Execute SQL commands . Manipulate/display data . Close the database connection To save the overhead of opening and closing of the database connection for each invocation of the PHP program, persistent database connections will be used. Persistent database connections remain open, even after the PHP script that opened the connection has exited. For more details on persistent database connections, refer to Chapter 17. Import ant Persistent connections will be useful only when PHP is configured as a module in the web server. See Chapter 2 for more details. Page 552
Note: If you are looking for cheap and quality provider to host and run your java application check Astra java hosting services

Design Consideration for the Middle Tier In this section we will make important design decisions and set guidelines that will be followed by all the application’s PHP scripts. Authentication The user, when entering the site, enters their user id and password. The PHP script verifies the user id and password, and, depending on the result, allows the user to use the application. After this, the user need not specify their user id and password again. The HTTP protocol is a stateless protocol, which means that for each browser request a new network connection is opened with the web server. The PHP script (running on the web server) should have a mechanism to identify the user from the request. The shopping cart application will use PHP sessions to implement the authentication mechanism. The application will create a PHP session after the user is authenticated. The user id and the isAuthenticated flag will be stored in the PHP session. All the PHP scripts will use the session variable isAuthenticated, to find out if the session is authenticated. The user of the session can be found from the value of session variable $userId. Session Storage One of the requirements of the application was to support multiple instances of the middle tier. This would require additional load balancing software that would distribute HTTP requests (depending on the load balancing policy) to different middle tier servers. Now the deployment scenario will look something like this: With the above deployment scenario, requests of a session might get forwarded to different middle tier servers. This would require the sessions to be shared across all the middle tier servers. The default session implementation of PHP does not allow session sharing between multiple PHP instances running on different machines. We will implement session handlers to store and retrieve session data from the back-end database. With these session handler functions, middle tier instances running on different machines will be able to share PHP sessions. This scheme of storing sessions in the database provides additional reliability, which means that the user will be able to access the application even if one of the middle tier instances goes down. WML Issues The application implementation will follow the following guidelines to take care of WML device constraints (small display size, navigational difficulty). A WML introduction has been provided along with the code which can be downloaded from the Wrox web site at http://www.wrox.com/: . Only relevant information, with links to get the details, will be displayed in the first card of the WML page. For example, in the first card of the search results page only the titles of the searched items will be displayed as links pointing to another card in the same page. The user can select the link to get the details of the item. . Only three items will be displayed per WML page. A link will be provided to view next items. For example, if there are ten transactions in a user’s account, then the view account details page will display only the first three transactions in the first page and will provide a link View Next Items (pointing back to the server), to view the remaining transactions. . A HOME link, pointing to the main page of the application, will be provided in all the WML cards. The user can select the HOME link anytime for going to the main page of the application. This way the user will have to traverse only two links to access any functionality. The WML page is of mime type text/vnd.wap.wml, so all the PHP scripts will send the Content-Type: text/vnd.wap.wml HTTP header. Performance Most PHP programs that access a back-end database will do the following tasks: Page 551
Note: If you are looking for top 10 and very good webhost to host and run your jsp application check Actions jsp hosting services

itemType VARCHAR(20) NOT NULL, title VARCHAR(60) NOT NULL, artist VARCHAR(60) NOT NULL, price FLOAT NOT NULL, PRIMARY KEY(itemNo)); CREATE TABLE Transaction ( orderNo INT NOT NULL PRIMARY KEY AUTO_INCREMENT, userId VARCHAR(20) NOT NULL, itemNo VARCHAR(20) NOT NULL, quantity INT NOT NULL DEFAULT 0, date DATE NOT NULL, status VARCHAR(20) NOT NULL); CREATE TABLE Session ( lastAccessed TIMESTAMP, id VARCHAR(255) NOT NULL, data TEXT, PRIMARY KEY(id)); Indices Indices are created on the ItemNo, Title, and Author/Artist columns of the BookShopand MusicShoptables. Creation of indices on these columns will result in faster searches in the database. Import Indices are used to find rows with a specific value for a column quickly. The ant index stores the mapping between the value of the column, and the physical location of the row. Without indices the database will have to do a complete scan of the table (lots of disk I/O), to search for rows with specific values for a column. SQL commands for creating indices (shopindices.sql): USE shop; CREATE INDEX indexOnBookItemNo ON BookShop(itemNo); CREATE INDEX indexOnBookTitle ON BookShop(title); CREATE INDEX indexOnBookAuthor ON BookShop(author); CREATE INDEX indexOnMusicItemNo ON MusicShop(itemNo); CREATE INDEX indexOnMusicTitle ON MusicShop(title); CREATE INDEX indexOnMusicArtist ON MusicShop(artist); Page 550
Note: If you are looking for top 10 and very good webhost to host and run your jsp application check Actions jsp hosting services

In our case, the database and the middle tier will be hosted on different machines. So, grant all privileges on all objects in the shop database to user PHP, connecting from any machine: mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON shop.* TO ‘PHP@%’ IDENTIFIED BY “PHP”; Execute the following SQL script (shop.sql) at the command prompt to create the shopdatabase and tables: mysql < shop.sql CREATE DATABASE IF NOT EXISTS shop; USE shop; CREATE TABLE UserProfile ( fname VARCHAR(32) NOT NULL, lname VARCHAR(32) NOT NULL, userId VARCHAR(16) NOT NULL, password VARCHAR(16) NOT NULL, address VARCHAR(128) NOT NULL, city VARCHAR(64) NOT NULL, country VARCHAR(16) NOT NULL, zipCode VARCHAR(8) NOT NULL, gender VARCHAR(8) NOT NULL, age INTEGER NOT NULL, emailId VARCHAR(64) NOT NULL, phoneNumber VARCHAR(16) NOT NULL, cardNo VARCHAR(16) NOT NULL, expiryDate DATE NOT NULL, cardType VARCHAR(16) NOT NULL, accountBalance FLOAT NOT NULL, PRIMARY KEY(userId)); CREATE TABLE BookShop ( itemNo VARCHAR(20) NOT NULL, itemType VARCHAR(20) NOT NULL, title VARCHAR(60) NOT NULL, author VARCHAR(60) NOT NULL, price FLOAT NOT NULL, PRIMARY KEY(itemNo)); CREATE TABLE MusicShop ( itemNo VARCHAR(20) NOT NULL, Page 549
Quick Hint: If you are looking for best quality webspace to host and run your tomcat application check Vision tomcat hosting services

Column Name Description Author Author of the book Price Price of the book The MusicShop table contains the description of available music titles: Column Name Description ItemNo Unique identifier for the music album ItemType CD/Cassette Title Title of the album Artist Artist Price Price of the album The Transaction table contains the records of user’s transactions: Column Name Description OrderNo Unique identifier for the user’s transaction. UserId User id of the user. ItemNo Unique identifier identifying the item. There must be a corresponding row for this item in either MusicShopor BookShop table. Quantity Number of ItemNo items ordered by the user. Date Date when the user did the transaction. Status Status of the item shipped/pending. The Session table, stores the data of PHP sessions: Column Name Description lastAccessed Time when the session was last accessed Id Unique session identifier Data Session data Database User One database user, PHP, is created for the shopping cart application. All the PHP scripts in the middle tier connect to the back-end database as user PHP. This user has all privileges on the tables of the shopping cart application. We need SQL commands for granting privileges on the tables in the shop database to the user PHP. To do so, execute the following SQL statement. The mysqlutility can be used for executing SQL commands. mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON shop.* TO ‘PHP@localhost’ IDENTIFIED BY “PHP”; Page 548
Hint: If you are looking for good and high quality web space to host and run your java application check Vision java web hosting services

Design of the Database Schema In this section we will create the database schema of the application. The application’s data (tables and indices) will be stored in a separate database (shop). Generally all the schema objects related to an application should be stored in a separate database/table space. It helps in easy management of related database objects. For example, to back up the data of the shopping cart application, the database administrator has to back up only one database (shop). Database Tables The following tables will be created in the shop database: . UserProfile . BookShop . MusicShop . Transaction . Session The UserProfile table contains user information: Column Name Description Fname First name of the user Lname Last name of the user UserId Unique user id Password Encrypted password of the user Address Street address City City Country Country ZipCode Zip code Gender Male/Female Age User’s age Emailed User’s e-mail address PhoneNumber Phone number of the user CardNo User’s credit card number ExpiryDate Expiry date of the credit card CardType User’s credit card type Master/Visa AccountBalance Balance in the user’s account The BookShop table contains the description of available book titles: Column Name Description Itemno Unique identifier for the book Itemtype Book type Title Title of the book Page 547

Hint: If you are looking for very good and affordable webspace to host and run your j2ee hosting application check Sandzak.com j2ee web hosting services

a scripting solution is preferred over servlets and CGI programs. . PHP provides APIs for accessing a large set of databases, and supports features like persistent database connections, and sessions. These features will be heavily used in the middle tier. Page 546
Note: If you are looking for cheap and inexpensive provider to host and run your tomcat application check professional tomcat hosting services

Choosing Software The requirements of the application call for the application to be web-based, with a WML front-end. The application will require a back-end database to store user profiles, user transactions, and the list of music/book titles available at the site. The application will also have a middle tier (the web server plus scripts which are executed by the server), to process the application requests sent from the browser. The browser will send WAP (Wireless Access Protocol) requests to the WAP gateway, which in turn will forward the request to the middle tier using HTTP. The middle tier will get the data from the back-end database, do some processing on the data, and send the reply back to the WAP gateway, which in turn will send the data back to the client browser using the WAP protocol: Import ant A WAP gateway is software that acts as a bridge between a network that supports WAP protocol and Internet Protocol (IP) network. Alternatives for the Back-End Database The back-end database stores the following data: . Information about registered users . Book and music titles available at the site . Record of transactions carried out by users We have two alternatives for storing the above listed information: . Flat files . Relational databases like Oracle, MySQL, or Sybase Flat files are ruled out, because that would lead to implementing lots of functionality, like designing the layout so that the data can be manipulated later, and designing a simple interface for accessing the data from files. This functionality is already available in relational databases. We have chosen MySQL as our back-end database. The reasons for this include: . MySQL is an open source relational database, so it has a cost advantage over other commercial databases . MySQL is highly scalable and easy to administer . MySQL supports client APIs for a large set of programming languages (like Perl, C, and PHP), so it gives more choice of programming languages for implementing the middle tier Alternatives for the Middle Tier The middle tier will generate WML pages dynamically, using the data available in the back-end database. For example, to display the book titles available at the site, the middle tier will get the list of books from the back-end database, and will generate a WML page containing the list of books. The following are the alternatives for implementing the middle tier: . Common Gateway Interface (CGI) programs written in Perl/C. These programs can access the back-end database using the database’s language APIs. . Servlets, written in Java. Servlets can access the back-end database using Java’s SQL APIs and the database’s JDBC driver. JDBC drivers are available for almost all databases. . Server-side scripting language like PHP, JavaServer Pages (JSP), and Active Server Pages (ASP). These languages support APIs for accessing almost all relational databases. PHP is chosen for implementing the middle tier for the following reasons: . PHP is available on a large set of platforms (Linux, UNIX, and Windows NT) and a variety of web servers (Apache and IIS). Therefore, we get a choice of platform and web server for hosting the middle tier. . Performance is one of the implicit requirements for any web-based application, so Page 545
Note: If you are looking for reliable and quality webspace company to host and run your servlet application check professional servlet hosting services