ผลต่างระหว่างรุ่นของ "คู่มือการพัฒนาซอฟต์แวร์บนเว็บบราวซ์เซอร์ให้รองรับ UA ด้วยภาษา PHP/en"
ไปยังการนำทาง
ไปยังการค้นหา
Photchanan (คุย | มีส่วนร่วม) (สร้างหน้าด้วย "Category: EAI") |
Photchanan (คุย | มีส่วนร่วม) (สร้างหน้าด้วย "-->") |
||
| แถว 22: | แถว 22: | ||
=== Related systems === | === Related systems === | ||
# Database system | # Database system | ||
| − | # | + | # MySQL |
| − | # | + | # PHPMyAdmin |
# Web application | # Web application | ||
| − | # | + | # Registration system |
| − | # | + | # Login system |
| − | # | + | # User profile system |
# Email system | # Email system | ||
| − | # | + | # PHPMailer |
=== To be used software === | === To be used software === | ||
| แถว 43: | แถว 43: | ||
== Developing Applications to Support UA in PHP == | == Developing Applications to Support UA in PHP == | ||
| − | |||
=== [[Cereate database that could handle IDN and EAI]] === | === [[Cereate database that could handle IDN and EAI]] === | ||
'''# CREATE TABLE IF NOT EXISTS accounts ( ''' | '''# CREATE TABLE IF NOT EXISTS accounts ( ''' | ||
| แถว 53: | แถว 52: | ||
''' PRIMARY KEY (`id`) | ''' PRIMARY KEY (`id`) | ||
''' ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;''' | ''' ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;''' | ||
| − | |||
| − | |||
=== [[modify the registration system to be able to accept EAI email address]] === | === [[modify the registration system to be able to accept EAI email address]] === | ||
modify register.html fronm | modify register.html fronm | ||
'''# <input type="email" name="email" placeholder="Email" id="email" required> | '''# <input type="email" name="email" placeholder="Email" id="email" required> | ||
| − | |||
| − | |||
to | to | ||
'''# <input type=[["text"]] name="email" placeholder="Email" id="email" required> | '''# <input type=[["text"]] name="email" placeholder="Email" id="email" required> | ||
| − | |||
| − | |||
=== [[modifythe registration system to be able to validate EAI email address]] === | === [[modifythe registration system to be able to validate EAI email address]] === | ||
modify register.php from | modify register.php from | ||
| แถว 72: | แถว 65: | ||
'''
exit('Email is not valid!');
| '''
exit('Email is not valid!');
| ||
''' } | ''' } | ||
| − | |||
| − | |||
to | to | ||
'''# if (preg_match('/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u', $_POST['email']) == 0) { | '''# if (preg_match('/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u', $_POST['email']) == 0) { | ||
''' exit('Email is not valid!');
| ''' exit('Email is not valid!');
| ||
''' } | ''' } | ||
| − | |||
| − | |||
=== [[modify the registration system to be able to send EAI email with PHPMailer]] === | === [[modify the registration system to be able to send EAI email with PHPMailer]] === | ||
modify PHPMailer/src/PHPMailer.php from | modify PHPMailer/src/PHPMailer.php from | ||
| แถว 87: | แถว 76: | ||
''' default: | ''' default: | ||
''' return filter_var($address, FILTER_VALIDATE_EMAIL) !== false; | ''' return filter_var($address, FILTER_VALIDATE_EMAIL) !== false; | ||
| − | |||
| − | |||
to | to | ||
'''# case 'php': | '''# case 'php': | ||
''' default: | ''' default: | ||
''' return (bool) preg_match("/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u", $address); | ''' return (bool) preg_match("/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u", $address); | ||
| − | |||
The regular expression works for Thai email address only. For general email verification for any email addresses in any language, the following expression may be considered: | The regular expression works for Thai email address only. For general email verification for any email addresses in any language, the following expression may be considered: | ||
รุ่นแก้ไขเมื่อ 09:27, 3 สิงหาคม 2564
This manual is a guideline for UA web application development using PHP. The application will be able to accept, validate and process Thai IDN and Thai EAI correctly.
User/Pass for accessing server in the workshop [User]
# HOST: https://ws.kon.in.th # DB: https://ws.kon.in.th/phpmyadmin/ # user: userX # pass: eaiuserX
User/Pass สำหรับเข้าเซิร์ฟเวอร์ใน workshop [User]
# HOST: https://ws.kon.in.th # DB: https://ws.kon.in.th/phpmyadmin/ # user: userX # pass: eaiuserX
-->
Preparing to Support UA in PHP
Related systems
- Database system
- MySQL
- PHPMyAdmin
- Web application
- Registration system
- Login system
- User profile system
- Email system
- PHPMailer
To be used software
- Filezilla [Win] [Mac]
- Web Browser e.g. Firefox, Chrome, Safari
- Text Editor (Code Editor) e.g. Notepad, Atom
Application Architecture
Developing Applications to Support UA in PHP
Cereate database that could handle IDN and EAI
# CREATE TABLE IF NOT EXISTS accounts ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(100) NOT NULL, `activation_code` varchar(50) DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
modify the registration system to be able to accept EAI email address
modify register.html fronm
# <input type="email" name="email" placeholder="Email" id="email" required>
to
# <input type="text" name="email" placeholder="Email" id="email" required>
modifythe registration system to be able to validate EAI email address
modify register.php from
# if (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {
exit('Email is not valid!');
}
to
# if (preg_match('/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u', $_POST['email']) == 0) {
exit('Email is not valid!');
}
modify the registration system to be able to send EAI email with PHPMailer
modify PHPMailer/src/PHPMailer.php from
# case 'php': default: return filter_var($address, FILTER_VALIDATE_EMAIL) !== false;
to
# case 'php':
default:
return (bool) preg_match("/^[ก-๙a-zA-Z0-9_+&*-]+(?:\.[ก-๙a-zA-Z0-9_+&*-]+)*@(?:[ก-๙a-zA-Z0-9-]+\.)+[ก-๙a-zA-Z]{2,16}$/u", $address);
The regular expression works for Thai email address only. For general email verification for any email addresses in any language, the following expression may be considered:
- something@something ^(.+)@(.+)$
