Build a dynamic WML site 1

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 mapping (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.
If you are using IIS, you must make some changes, similar to when installing PHP: take a look at the mapping of .php and .php3 extensions, and add the same mapping for .wml.
　Normally you will find that PHP is mapped to:
　　C:phpphp4isapi.dll
　or
　C:phpphp.exe
Preparation
　If you are using a Microsoft operating system, you can install the NOKIA development 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), please remember You need the support of Java2 Runtime Environment (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.Professors table includes data related to professors;
　2.subjucts table includes data related to subjects;
　3.exams table includes data related to tests;
　4.teach table includes relationship information between professors and the subjects they teach
　In 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 establish 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,
Id int(11) NOT NULL,
Date date DEFAULT '0000-00-00',
Time time DEFAULT '00:00:00',
Room varchar (64),
Test varchar(16) DEFAULT 'Oral'
);
Cod_subject refers to the name used by the college to represent each subject, which is unique. ID is the professor's unique identification number. Date, Time and Room are used to record The date, time and place when the test is held. Test is used to indicate the type of test (including written, oral, etc.)
CREATE TABLE teach (
Cod_Subject varchar(16) NOT NULL,
Id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (Id, Cod_subject )
);
　 In the teach table, ID is the professor’s identification number, and Cod_Subject has the same meaning as above. The two constitute the primary key of the table.
　The next step is to fill in some data in the database, this step can be completed by yourself.

The above has introduced the creation of a dynamic WML site, including aspects of the content. I hope it will be helpful to friends who are interested in PHP tutorials.