Home > Article > Backend Development > Create a dynamic WML site with PHP_PHP tutorial
Create a dynamic WML site with PHP_PHP tutorial
- WBOYOriginal
- 2016-07-20 11:05:42700browse
There are more and more mobile phones supporting WAP function. Therefore, you should also consider building your own WML website. This article will introduce how to build a PHP/WML page site. Using a MySQL database, the content of the site can be dynamically updated. Specific examples are the teaching hours and teaching hours of professors in a certain college. Quiz Timetable. It’s not complicated at all :-)
Before you start, you should prepare the following things:
1. You have correctly installed PHP and MySQL, and have experience in programming with both.
2. You have relevant knowledge of SQL
3. You are running Apache and can write .haccess files; or you are running IIS and you can add mappings (or you can ask the system administrator to help you) ;
4. You have relevant knowledge of WML;
Okay, the first step is to let your server know to use PHP to process WML files. Here is how to do this.
Set up the server
If you are using Apache, you must find a .htaccess file in your directory. Then, add the following lines:
AddType application/x-httpd-php3 .wml
If you can’t find the file, you can add one and add the above lines and put it in your directory middle.
If you are using IIS, you have to make some changes, similar to what you did when installing PHP: take a look at the mapping of .php and .php3 extensions, and add the same mapping for .wml.
Typically you will find PHP mapped to:
C:phpphp4isapi.dll
or
C:phpphp.exe
Preparatory work
If you are using Microsoft’s operating system, you can install NOKIA’s development tool kit. It checks your syntax and lets you preview WML pages through a phone-like interface. The toolkit also comes with reference documentation on WML and WML scripting. This can be a big help if your phone doesn't have WAP support, or if you can't use a WAP gateway.
To download this tool, you must first register on this website as a WAP developer (http://www.forum.nokia.com/main/0,6668,1_1_4,00.html) , what you need to remember is that you need Java2 Runtime Enviroment support (Java2 runtime environment support). You can use any text editor to write the page.
Before writing any PHP/WML code, you need to create a MySQL table.
The database consists of 4 tables.
1. The professors table includes data related to professors;
2. The subjects table includes data related to topics;
3. The exams table includes data related to tests;
4. The teach table includes The relationship information between professors and the subjects they teach
When connecting to MySQL, you can create a table through the following code
CREATE TABLE professors (
Id int(11) DEFAULT '0' NOT NULL auto_increment,
Surname varchar(24) NOT NULL,
Name varchar(24) NOT NULL,
Email varchar(48) DEFAULT 'Not avaliable',
Cod_course varchar(16) DEFAULT 'Not avaliable',
Consulting_hour varchar(128) DEFAULT 'Not avaliable',
Consulting_place varchar(128) DEFAULT 'Not avaliable',
PRIMARY KEY (Id)
);
These statements create The table structure of professors. ID assigns a unique identification number to each professor and is the primary key of the table. Other fields, Surname, Name, and Email are used to represent the last name, first name, and e-mail address of each professor. Cod_course is a value that uniquely identifies each subject. Finally, Consulting_hour and Consulting_place represent the teaching time and location.
CREATE TABLE subjects (
Subject varchar(96) NOT NULL,
Cod_Subject varchar(24) NOT NULL,
Cod_number varchar(12) NOT NULL,
PRIMARY KEY (Cod_subject )
);
Subject is the name of the subject. Cod_subject is the name used by the college to represent each subject. Its value is unique and is the primary key of this table. Cod_number is a numeric field. Different courses of the same subject belong to a group. This number is the identification number of the group.
CREATE TABLE exams (
Cod_Subject varchar(24) NOT NULL,