[WAMP]WampServer 修改預設開啟瀏覽器

更改  wampmanager.conf  和  wampmanager.ini


[wampmanager.conf ]
[main]
language = "chinese_trad"
status = offline
wampserverVersion = 2.4
wampserverLastKnown = 2.4
installDir = "g:/wamp2"
navigator = "C:\Program Files\Google\Chrome\Application\chrome.exe"
defaultLanguage = english

[wampmanager.ini]
[Menu.Left]
;WAMPMENULEFTSTART
Type: separator; Caption: "Powered by Alter Way"
Type: item; Caption: "Localhost"; Action: run; FileName: "C:\Program Files\Google\Chrome\Application\chrome.exe"; Parameters: "http://localhost/"; Glyph: 5
Type: item; Caption: "phpMyAdmin"; Action: run; FileName: "C:\Program Files\Google\Chrome\Application\chrome.exe"; Parameters: "http://localhost/phpmyadmin/"; Glyph: 5
Type: item; Caption: "www 目錄"; Action: shellexecute; FileName: "g:/wamp2/www"; Glyph: 2
Type: submenu; Caption: "Apache"; SubMenu: apacheMenu; Glyph: 3
Type: submenu; Caption: "PHP"; SubMenu: phpMenu; Glyph: 3
Type: submenu; Caption: "MySQL"; SubMenu: mysqlMenu; Glyph: 3
Type: separator; Caption: "Debug"
;Type: item; Caption: "Client XDebug"; Glyph: 6; Action: run; FileName: "g:/wamp2/tools/xdc/xdc.exe"
Type: item; Caption: "webGrind"; Action: run; FileName: "C:\Program Files\Google\Chrome\Application\chrome.exe"; Parameters: "http://localhost/webgrind/"; Glyph: 5
Type: separator; Caption: "Quick Admin"
;Type: servicesubmenu; Caption: "Apache"; Service: wampapache; SubMenu: apache

改成: C:\Program Files\Google\Chrome\Application\chrome.exe

[sql test]利用any

利用any從[訂購]資料表中,取出訂購產品是[豆沙包]類的訂單.



SELECT *
FROM 訂單
WHERE 產品編號 = any
(  select 產品編號 
   from 產品
   where 產品名稱 like '*豆沙包'


);

[test]sql

http://www.javaworld.com.tw/jute/post/view?bid=21&id=217814&tpg=9&ppg=1&sty=0&age=0

[mysql] How to create a IDENTITY column in MySQL?

create TABLE Table1
(
        ID int AUTO_INCREMENT  PRIMARY KEY,  
        classid int,
        sex varchar(10),
        age int
     
 )

ID 會自動加1且是PRIMARY KEY

AUTO_INCREMENT 相當於 IDENTITY (1,1)

[HTML]將input標籤設成readonly

<input readonly="readonly" type="text" />

[html]將檔案存成utf-8

將網頁文件存成 utf-8
notepad++
編碼選項中
轉換至 UTF-8  => 正常顯示，此時文件已經是 UTF-8 編碼了

[php]setcookie()

一. print and echo 皆是用來顯示字串在螢幕
<?php
   $variable=3;
   print("使用print 輸出 $variable<br/>");
   echo "使用print 輸出 $variable";
?>


二. 8進位16進位
<?php
  
  $nl ="<br/>";
  $a =1234;
  echo $a.$nl;
  $a =-123;
  echo $a.$nl;
  $a=0123;
  echo $a.$nl;
  $a=0x12;
  echo $a;
?>


三. 指定字串 (單引號,雙引號,heredoc)
heredoc(<<<)
<?php
  $name="test";
  echo<<<EOD
  MY NAME IS $test<br/>
  hello test
EOD;
  
?>

四. 瀏覽器上的暫存器Http Cookies
php中的setcookie()

1)setcookie()函數可以將我們的上網資訊存在Browser(client端)上,
帳號密碼的網頁正是利用這個功能.

2)cookie
  是一個變數由server送給client.
  通常是一個小的文字檔存在client端的電腦.


3)如果我們只要讓瀏覽器記錄的資料暫時記憶,則只要在setcookie()
函數後面加上時間函數.

4)This function returns TRUE on success or FALSE on failure.

ex: cookie.php
<?php
   //將"chaiyen"這個字串存入browser並以login這個變數來指定,而login這個變數存在3600秒(=1hr).
   setcookie("login","chaiyen",time()+3600);
        if(isset($_COOKIE['login']))
          echo $_COOKIE['login'];

?>