Head First PHP & MySql Note

1. 变量名只能有字母、数字和下划线，开头不能是数字，不能包含其他字符

2. MySql连接：

 mysqli_connect(uric, user, password, database);

     mydqli_query(connect, sql); CRUD

     mysqli_close(uri);

3. mailto

4. char比varchar的效率要高，因为它不用关心长度。但占用空间

5. 获得数据：

$result = mysqli_query($connect)

mysqli_fetch_array($result): 一次只能一行

6. 不要嵌套IF

7. $_SERVER['PHP_SELF']

8. alert：

alert table add column_name type/ primary key

    alert table drop COLUMN column_name

    alert table change COLUMN old_column_name new_column_name type

   alter table modify column clumne_name datetype after coulmn_name

9. $_FILES

10. limit: limit x, y, x: start, y: count

11. PHP授权：

header('http/1.1 401 Unanthorized');

if ($_SERVER["PHP_AUTH_USER"] != 'flynn' || $_SERVER["PHP_AUTH_PW"] != 'flynn') {
header('HTTP/1.1 401 Unauthorized '); 
header("WWW-Authenticate:Basic realm:'welcome!'");
 exit('Please input the username and password.');}

12. 页面刷新：

header("Refresh: 5; url=http://localhost/")

13：防止SQL注入 ：

 trim()

mysqli_real_escape_string();

14. Mysql 加密： SHA()

15. Cookie & Session:

$_COOKIE[], setcookie(key, value, expire)(set expire to past to delete the cookie)
     $_SESSION:  session_start(); session_destoy(); 

16. isset()

17. surstr(str, -index), - from right end of the str.

18, preg_metch(reg, str), reg: /^…$/, \d, \w, \s