六年制學程 - 使用者貢獻 [zh-tw]

網頁程式撰寫/2017/黃柏實

2017-09-14T03:37:51Z

黃柏實：

[[分類:網頁程式撰寫]]
Class resources:
Hand-out: http://jendo.org/wiki1231/index.php?title=%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB/2017

Software:
1. Filezilla
2. EmEditor

Programs:
1. form.php
2. r.php

Copy past code from hand-outs and change personal info to own
r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user
Server: this is the place where all the information gets processed and translated back to us

<> = Tags
Tags must be in pairs

<Meta> = Define
<br/> = Break

form.php:
<meta http-equiv='content-type' content='text/html;charset=UTF-8'>
//the above line defines the attributes of this program
<form action='r.php'>
//action to send information requested by r.php to the server
姓名：<input type='text' name='__' value='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> stands for break which moves everything you type after this to the next line
<input type='submit' value='送出' />
//as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php
</form>
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

r.php:
<?php
$connect=mysql_connect('localhost','assistant','aide');
//connects r.php to the local server MySQL in which the information will be processed
mysql_select_db('助理們');
//requests MySQL to select the variable "db"
mysql_query("insert into web set 姓名='".$_REQUEST['姓名']."',phone='".$_REQUEST['phone']."'");
//inserts the information needed from form.php into the query which will be shown to the server admin
mysql_close($connect);
//closes the connection after receiving the needed data
?>

Day 2:

Project: Contacts

Files: 網頁程式撰寫 & HTMLeBook

1. D ✔
2. A ✔
3. B ✔
4. C ✔
5. B ✔
6. C ✔
7. D ✔
8. A ✔
9. C ✔

1. Hyper Text Markup Language, Must have opening and closing brackets
2. <meta> Defines program content
<i> ''Italic''
<br> Break
<hr> Thematic break or Horizontal Ruler
<ul> Un-ordered list
<li> List item
3. Ol & Ul, numbered and dots, div can contain much more information than span
4. <table> <tr> <td>
5. <option> <select> & <checked>

網頁程式撰寫/2017/黃柏實

2017-09-14T02:28:34Z

黃柏實：

[[分類:網頁程式撰寫]]
Class resources:
Hand-out: http://jendo.org/wiki1231/index.php?title=%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB/2017

Software:
1. Filezilla
2. EmEditor

Programs:
1. form.php
2. r.php

Copy past code from hand-outs and change personal info to own
r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user
Server: this is the place where all the information gets processed and translated back to us

<> = Tags
Tags must be in pairs

<Meta> = Define
<br/> = Break

form.php:
<meta http-equiv='content-type' content='text/html;charset=UTF-8'>
//the above line defines the attributes of this program
<form action='r.php'>
//action to send information requested by r.php to the server
姓名：<input type='text' name='__' value='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> stands for break which moves everything you type after this to the next line
<input type='submit' value='送出' />
//as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php
</form>
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

r.php:
<?php
$connect=mysql_connect('localhost','assistant','aide');
//connects r.php to the local server MySQL in which the information will be processed
mysql_select_db('助理們');
//requests MySQL to select the variable "db"
mysql_query("insert into web set 姓名='".$_REQUEST['姓名']."',phone='".$_REQUEST['phone']."'");
//inserts the information needed from form.php into the query which will be shown to the server admin
mysql_close($connect);
//closes the connection after receiving the needed data
?>

Project: Contacts

1. D ✔
2. A ✔
3. B ✔
4. C ✔
5. B ✔
6. C ✔
7. D ✔
8. A ✔
9. C ✔

1. Hyper Text Markup Language, Must have opening and closing brackets
2. <meta> Defines program content
<i> ''Italic''
<br> Break
<hr> Thematic break
<ul> Un-ordered list
<li> List item
3.
4. <table> <tr> <td>
5. <option>

網頁程式撰寫/2017/黃柏實

2017-09-14T01:27:31Z

黃柏實：

網頁程式撰寫/2017/黃柏實

2017-09-07T04:01:09Z

黃柏實：

[[分類:網頁程式撰寫]]
Class resources:
Hand-out: http://jendo.org/wiki1231/index.php?title=%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB/2017
Hand-out print version: http://jendo.org/printOut/%E7%B6%B2%E9%A0%81%E7%A8%8B%E5%BC%8F%E6%92%B0%E5%AF%AB2017.html
form.php link: http://6years.jendo.org/~%E9%BB%83%E6%9F%8F%E5%AF%A6/php/form.php
Book chapter one test criteria: http://jendo.org/wiki1231/index.php?title=PHP,MySQL,AJAX,%E7%B6%B2%E9%A0%81%E8%A8%AD%E8%A8%88%E7%AF%84%E4%BE%8B%E6%95%99%E6%9C%AC

Copy past code from hand-outs and change personal info to own
r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user
Server: this is the place where all the information gets processed and translated back to us

<> = Tags
Tags must be in pairs

<Meta> = Define
<br/> = Break

form.php:
<meta http-equiv='content-type' content='text/html;charset=UTF-8'>
//the above line defines the attributes of this program
<form action='r.php'>
//action to send information requested by r.php to the server
姓名：<input type='text' name='__' value='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> stands for break which moves everything you type after this to the next line
<input type='submit' value='送出' />
//as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php
</form>
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

r.php:
<?php
$connect=mysql_connect('localhost','assistant','aide');
//connects r.php to the local server MySQL in which the information will be processed
mysql_select_db('助理們');
//requests MySQL to select the variable "db"
mysql_query("insert into web set 姓名='".$_REQUEST['姓名']."',phone='".$_REQUEST['phone']."'");
//inserts the information needed from form.php into the query which will be shown to the server admin
mysql_close($connect);
//closes the connection after receiving the needed data
?>

網頁程式撰寫/2017/黃柏實

2017-09-07T03:54:03Z

黃柏實：

[[分類:網頁程式撰寫]]
Copy past code from hand-outs and change personal info to own
r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user
Server: this is the place where all the information gets processed and translated back to us

<> = Tags
Tags must be in pairs

<Meta> = Define
<br/> = Break

form.php:
<meta http-equiv='content-type' content='text/html;charset=UTF-8'>
//the above line defines the attributes of this program
<form action='r.php'>
//action to send information requested by r.php to the server
姓名：<input type='text' name='__' value='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> stands for break which moves everything you type after this to the next line
<input type='submit' value='送出' />
//as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php
</form>
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

r.php:
<?php
$connect=mysql_connect('localhost','assistant','aide');
//connects r.php to the local server MySQL in which the information will be processed
mysql_select_db('助理們');
//requests MySQL to select the variable "db"
mysql_query("insert into web set 姓名='".$_REQUEST['姓名']."',phone='".$_REQUEST['phone']."'");
//inserts the information needed from form.php into the query which will be shown to the server admin
mysql_close($connect);
//closes the connection after receiving the needed data
?>

網頁程式撰寫/2017/黃柏實

2017-09-07T03:49:03Z

黃柏實：

[[分類:網頁程式撰寫]]
Copy past code from hand-outs and change personal info to own
r.php calls your name and phone number from form.php and sends it to the server so that its put into a list that the server admin can see

Browser: a program that communicates with the server and sends it back to the user
Server: this is the place where all the information gets processed and translated back to us

<> = Tags
Tags must be in pairs

<Meta> = Define
<br/> = Break

<meta http-equiv='content-type' content='text/html;charset=UTF-8'>
//the above line defines the attributes of this program
<form action='r.php'>
//action to send information requested by r.php to the server
姓名：<input type='text' name='__' value='____' /><br/>
email：<input type='text' name='email' value='alledu2@gmail.com' /><br/>
電話：<input type='text' name='phone' value='0987466665' /><br/>
//defines the input to text setting the name of this variable to what is typed in, and <br/> stands for break which moves everything you type after this to the next line
<input type='submit' value='送出' />
//as we can see the input type is no longer "text" but instead "submit" therefor this will become a button that submits the information to r.php
</form>
//closing bracket of the <from> tab, meaning everything between the two will get sent to r.php for processing

網頁程式撰寫/2017/黃柏實

2017-09-07T01:51:46Z

黃柏實：

[[分類:網頁程式撰寫]]

網頁程式撰寫/2017/黃柏實

2017-09-07T01:50:53Z

黃柏實：新頁面: 分類：網頁程式撰寫

[[分類：網頁程式撰寫]]