คู่มือการพัฒนาซอฟต์แวร์บนเว็บบราวซ์เซอร์ให้รองรับ UA ด้วยภาษา PHP/en - ประวัติรุ่นแก้ไข

Photchanan เมื่อ 08:15, 6 ตุลาคม 2564

2021-10-06T08:15:01Z

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 08:15, 6 ตุลาคม 2564
บรรทัดที่ 32:		บรรทัดที่ 32:
	# Text Editor (Code Editor) e.g. Notepad, Atom		# Text Editor (Code Editor) e.g. Notepad, Atom

	=== Application Architecture ===		=== Source code ===
			* Source code used in this workshop [[https://github.com/THNICF/UA-Workshop-12062021 source code]]

			== Application Architecture ==
	[[File:App-archetiect-3.png\|400px]]		[[File:App-archetiect-3.png\|400px]]
	[[File:App-archetiect-2.png\|400px]]		[[File:App-archetiect-2.png\|400px]]

Photchanan เมื่อ 02:34, 3 สิงหาคม 2564

2021-08-03T02:34:19Z

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:34, 3 สิงหาคม 2564
บรรทัดที่ 27:		บรรทัดที่ 27:
	#* PHPMailer		#* PHPMailer

	=== ~~To be used~~ software ===		=== Required software ===
	# Filezilla [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_win64-setup.exe?h=nRlrhWw7NLjal-h8S-C__A&x=1615717392 Win]] [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_macosx-x86.app.tar.bz2?h=jSIej0fAkYK7rWgFBbsUPA&x=1615717392 Mac]]		# Filezilla [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_win64-setup.exe?h=nRlrhWw7NLjal-h8S-C__A&x=1615717392 Win]] [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_macosx-x86.app.tar.bz2?h=jSIej0fAkYK7rWgFBbsUPA&x=1615717392 Mac]]
	# Web Browser e.g. Firefox, Chrome, Safari		# Web Browser e.g. Firefox, Chrome, Safari

Photchanan เมื่อ 02:33, 3 สิงหาคม 2564

2021-08-03T02:33:01Z

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:33, 3 สิงหาคม 2564
บรรทัดที่ 3:		บรรทัดที่ 3:


	~~User/Pass for accessing server in the workshop [[https://คน.ไทย/วิกิ/list~~-~~user~~-~~ws.jpg User]]~~		<!--
	~~# HOST: https://ws.kon.in.th~~
	~~# DB: https://ws.kon.in.th/phpmyadmin/~~
	~~# user: userX~~
	~~# pass: eaiuserX~~

	User/Pass สำหรับเข้าเซิร์ฟเวอร์ใน workshop [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]		User/Pass สำหรับเข้าเซิร์ฟเวอร์ใน workshop [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]
บรรทัดที่ 22:		บรรทัดที่ 18:
	=== Related systems ===		=== Related systems ===
	# Database system		# Database system
	# * MySQL		#* MySQL
	# * PHPMyAdmin		#* PHPMyAdmin
	# Web application		# Web application
	# * Registration system		#* Registration system
	# * Login system		#* Login system
	# * User profile system		#* User profile system
	# Email system		# Email system
	# * PHPMailer		#* PHPMailer

	=== To be used software ===		=== To be used software ===

Photchanan เมื่อ 02:31, 3 สิงหาคม 2564

2021-08-03T02:31:41Z

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:31, 3 สิงหาคม 2564
บรรทัดที่ 21:		บรรทัดที่ 21:

	=== Related systems ===		=== Related systems ===
	# Database system		# Database system
	# MySQL		# * MySQL
	# PHPMyAdmin		# * PHPMyAdmin
	# Web application		# Web application
	# Registration system		# * Registration system
	# Login system		# * Login system
	# User profile system		# * User profile system
	# Email system		# Email system
	# PHPMailer		# * PHPMailer

	=== To be used software ===		=== To be used software ===

Photchanan: สร้างหน้าด้วย "-->"

2021-08-03T02:27:05Z

สร้างหน้าด้วย "-->"

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:27, 3 สิงหาคม 2564
บรรทัดที่ 22:		บรรทัดที่ 22:
	=== Related systems ===		=== Related systems ===
	# Database system		# Database system
	#* MySQL		# MySQL
	#* PHPMyAdmin		# PHPMyAdmin
	# Web application		# Web application
	#* Registration system		# Registration system
	#* Login system		# Login system
	#* User profile system		# User profile system
	# Email system		# Email system
	#* PHPMailer		# 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 ==

	~~<div class="mw-translate-fuzzy">~~
	=== [[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;'''
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	=== [[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>
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	to		to
	'''# <input type=[["text"]] name="email" placeholder="Email" id="email" required>		'''# <input type=[["text"]] name="email" placeholder="Email" id="email" required>
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	=== [[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!');
	''' }		''' }
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	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!');
	''' }		''' }
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	=== [[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;
	~~</div>~~

	~~<div class="mw-translate-fuzzy">~~
	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);
	~~</div>~~

	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:

Photchanan: สร้างหน้าด้วย "Category: EAI"

2021-08-03T02:25:18Z

สร้างหน้าด้วย "Category: EAI"

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:25, 3 สิงหาคม 2564
บรรทัดที่ 96:		บรรทัดที่ 96:
	</div>		</div>

	~~<div class="mw-translate-fuzzy">~~		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:
	~~[[Category: EAI]]~~
	~~</div>~~		* something@something ^(.+)@(.+)$


	~~<div lang="th" dir="ltr" class="mw-content-ltr">~~
	[[Category: EAI]]		[[Category: EAI]]
	~~</div>~~

FuzzyBot: กำลังอัพเดตเพื่อทำให้ตรงกันกับรุ่นปรับปรุงใหม่ของหน้่าโค้ดหลัก

2021-08-03T02:23:02Z

กำลังอัพเดตเพื่อทำให้ตรงกันกับรุ่นปรับปรุงใหม่ของหน้่าโค้ดหลัก

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 02:23, 3 สิงหาคม 2564
บรรทัดที่ 8:		บรรทัดที่ 8:
	# user: userX		# user: userX
	# pass: eaiuserX		# pass: eaiuserX

			User/Pass สำหรับเข้าเซิร์ฟเวอร์ใน workshop [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]
			# HOST: https://ws.kon.in.th
			# DB: https://ws.kon.in.th/phpmyadmin/
			# user: userX
			# pass: eaiuserX

			-->

	== Preparing to Support UA in PHP ==		== Preparing to Support UA in PHP ==
บรรทัดที่ 35:		บรรทัดที่ 43:
	== Developing Applications to Support UA in PHP ==		== Developing Applications to Support UA in PHP ==

			<div class="mw-translate-fuzzy">
	=== [[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 ( '''
บรรทัดที่ 44:		บรรทัดที่ 53:
	''' PRIMARY KEY (`id`)		''' PRIMARY KEY (`id`)
	''' ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;'''		''' ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;'''
			</div>

			<div class="mw-translate-fuzzy">
	=== [[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>
			</div>

			<div class="mw-translate-fuzzy">
	to		to
	'''# <input type=[["text"]] name="email" placeholder="Email" id="email" required>		'''# <input type=[["text"]] name="email" placeholder="Email" id="email" required>
			</div>

			<div class="mw-translate-fuzzy">
	=== [[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
บรรทัดที่ 57:		บรรทัดที่ 72:
	'''  exit('Email is not valid!');		'''  exit('Email is not valid!');
	''' }		''' }
			</div>

			<div class="mw-translate-fuzzy">
	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!');
	''' }		''' }
			</div>

			<div class="mw-translate-fuzzy">
	=== [[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
บรรทัดที่ 68:		บรรทัดที่ 87:
	''' default:		''' default:
	''' return filter_var($address, FILTER_VALIDATE_EMAIL) !== false;		''' return filter_var($address, FILTER_VALIDATE_EMAIL) !== false;
			</div>

			<div class="mw-translate-fuzzy">
	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);
			</div>

			<div class="mw-translate-fuzzy">
			[[Category: EAI]]
			</div>


			<div lang="th" dir="ltr" class="mw-content-ltr">
	[[Category: EAI]]		[[Category: EAI]]
			</div>

FuzzyBot: กำลังอัพเดตเพื่อทำให้ตรงกันกับรุ่นปรับปรุงใหม่ของหน้่าโค้ดหลัก

2021-07-22T00:45:35Z

กำลังอัพเดตเพื่อทำให้ตรงกันกับรุ่นปรับปรุงใหม่ของหน้่าโค้ดหลัก

←รุ่นแก้ไขก่อนหน้า		รุ่นแก้ไขเมื่อ 00:45, 22 กรกฎาคม 2564
บรรทัดที่ 1:		บรรทัดที่ 1:
	<languages/>		<languages/>
			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 [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]		User/Pass for accessing server in the workshop [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]
บรรทัดที่ 9:		บรรทัดที่ 11:
	== Preparing to Support UA in PHP ==		== Preparing to Support UA in PHP ==

	~~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.~~

	=== Related systems ===		=== Related systems ===

Photchanan: สร้างหน้าด้วย "=== modifythe registration system to be able to validate EAI email address === modify register.php from '''# if (!filter_var($_POST['email&apo..."

2021-07-05T04:07:18Z

สร้างหน้าด้วย "=== modifythe registration system to be able to validate EAI email address === modify register.php from '''# if (!filter_var($_POST['email&apo..."

หน้าใหม่

<languages/>

User/Pass for accessing server in the workshop [[https://คน.ไทย/วิกิ/list-user-ws.jpg User]]
# HOST: https://ws.kon.in.th
# DB: https://ws.kon.in.th/phpmyadmin/
# user: userX
# pass: eaiuserX

== Preparing to Support UA in PHP ==

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.

=== Related systems ===
# Database system
#* MySQL
#* PHPMyAdmin
# Web application
#* Registration system
#* Login system
#* User profile system
# Email system
#* PHPMailer

=== To be used software ===
# Filezilla [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_win64-setup.exe?h=nRlrhWw7NLjal-h8S-C__A&x=1615717392 Win]] [[https://dl4.cdn.filezilla-project.org/client/FileZilla_3.52.2_macosx-x86.app.tar.bz2?h=jSIej0fAkYK7rWgFBbsUPA&x=1615717392 Mac]]
# Web Browser e.g. Firefox, Chrome, Safari
# Text Editor (Code Editor) e.g. Notepad, Atom

=== Application Architecture ===
[[File:App-archetiect-3.png|400px]]
[[File:App-archetiect-2.png|400px]]
[[File:App-archetiect-1.png|400px]]

== 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);

[[Category: EAI]]