BIOS最佳化調整

搞不懂BIOS一堆選項的意思嗎?不知道該怎麼調整才能壓榨出你電腦效能的極限嗎?在網路上發現一篇不錯的文張貼出來給大家做參考!

ABIT KR7A BIOS Settings

The table below shows the BIOS settings I am using on the ABIT KR7A-133 motherboard. My ABIT KR7A-133 BIOS version is B5, dated 10/3/2002. Italics indicate values that are not updateable, although they might be under different BIOS settings.

This BIOS optimization guide available from Adrian’s Rojak Pot is an excellent general-purpose source for information on BIOS settings.

SoftMenu III Setup

Parameter Setting Comments
CPU Operating Speed 1800+(133)
CPU FSB Clock (MHz) 133
Ratio (FSB:AGP:PCI) 4:2:1
Multiplier Factor x11.5
Speed Error Hold Disabled
CPU Power Supply CPU Default
Core Voltage 1.750v
I/O Voltage 3.50v
DDR Voltage 2.55v
DQ Control Center DQ
CPU Fast Command Decode Fast This setting will give a performance improvement over Normal and is safe with the high-quality components I’m using. The Ultra setting makes little performance difference and isn’t worth the risk of causing instability.

Standard CMOS Features

Parameter Setting Comments
IDE Primary Master IC35L080AVVA07-0 This is the IBM 120GXP 80GB hard drive. The hard drive and CD-ROM should not be on the same IDE since doing so will cause them both to run at the speed of the slower device. The CD-ROM is much slower than the hard drive. Placing them on separate IDEs allows them to both run at their maximum speeds.
IDE Primary Master (sub-menu)
Parameter Setting Comments
IDE Primary Master Auto
– Access Mode Auto

 

IDE Primary Slave None
IDE Secondary Master LTN525D This is the Lite-On 52x CD-ROM.
IDE Secondary Slave None
Drive A 1.44M, 3.5 in This is the floppy drive.
Drive B None
Floppy 3 Mode Support Disabled Floppy 3 is the Japanese standard floppy drive mode. It stores 1.2MB on a 3.5″ diskette instead of 1.44MB.
Video EGA/VGA
Halt On All, But Keyboard Halt on all errors except Keyboard Absent error. This enables the machine to boot without the keyboard plugged in.
Base Memory 640K DOS device drivers, TSRs and any programs to be run, plus their data.
Extended Memory 523264K Memory above 1 MB is known as extended memory, and is not normally usable under DOS.
Total Memory 524288K Base + Upper + Extended = Total Memory.

Advanced BIOS Features

Parameter Setting Comments
Virus warning Disabled Symantec Norton Antivirus protects My Super PC.
CPU L2 Cache ECC Checking Enabled Improves stability and reliability with no real impact to performance.
Quick Power On Self Test Enabled Skip Power On Self-Tests for faster boot.
First Boot Device CDROM Normally this should be set to HDD-0 to boot directly from the hard drive, but set it to the CDROM for now since that’s how we’ll need it when we’re ready for the step after configuring the BIOS parameters. When it’s set to HDD-0 the computer does not look to see if there’s a floppy disk in the floppy drive from which it should boot. Set this to Floppy for disaster recovery procedures.
Second Boot Device CDROM Normally this would be set to HDD-0 since the First Boot Device is the only boot device.
Third Boot Device CDROM Ditto.
Boot Other Device Disabled Gives the “ok” for the BIOS to try the Second Boot Device and Third Boot Device if the First Boot Device is a “no-go”, but My Super PC just boots from the First Boot Device, which is the hard drive so – Disabled.
Swap Floppy Drive Disabled I’ve only got one floppy drive, so it’s going to be A:.
Boot Up Floppy Seek Disabled Skipping this check makes the boot go a bit faster.
Boot Up NumLock Status Off This item is a matter of personal taste.
Typematic Rate Setting Enabled
Typematic Rate (Chars/Sec) 30 6, 8, 10, 12, 15, 20, 24, 30
Typematic Delay (Msec) 250 250, 500, 750, 1000. This is the delay, in milliseconds, before the keyboard automatically repeats the keystroke that you have pressed continuously.
Security Option Setup If you have set a password, select whether the password is required every time the System boots, or only when you enter Setup. I don’t even have a password set, so it’s a moot point.
APIC Mode Disabled Setting to Enabled can cause instabilities. Once the operating system is installed, such as Windows XP in my case, this setting cannot be changed without reinstalling the operating system, regardless of whether the initial setting is Disabled or Enabled. The purpose of setting it to Enabled is to extend the number of IRQ’s, which sounds like a real risky proposition. I’m not surprised to see the conclusion reached at APIC: Benefit or Trouble. The number of IRQ’s should be fine without being extended, anyway.
MPS Version Control For OS 1.1 Not changeable with APIC Mode set to Disabled.
OS Select For DRAM > 64MB Non-OS2 IBM’s relic.
Report No FDD For WIN 95 No When using Windows 95 without a floppy drive, set to Yes. Say – how many ABIT KR7A-133 motherboards do you suppose are out there running under Windows 95 without a floppy drive?
Video BIOS Shadow Disabled Your system will perform better with this setting at Disabled. As you can read in the MS Knowledge base, shadowing is not an advantage. Only enable this if you still use DOS mode a lot, where it can improve performance as it will speed up VGA BIOS (C0000-C7FFF) accesses.
Delay for IDE Initial (Secs) 0 Certain hard disk drives require some extra time to spin up in a cold boot. If the system does not start after the memory tes
t, try adding time in this field.
Small Logo(EPA) Show Disabled

Advanced Chipset Features

Parameter Setting Comments
DRAM Clock/Drive Control (sub-menu)
Parameter Setting Comments
DRAM Clock 133 MHz
DRAM Timing Manual
DRAM CAS Latency 2 Although the memory is spec’d at 2.5, Crucial memory is high quality and will run at the faster 2 setting.
Bank Interleave 4 bank For best performance.
Precharge to Active(Trp) 2T
Active to Precharge(Tras) 6T This value is recommended for PC2100 memory to improve stability with no real loss of performance. A value of 5T is recommended for PC1600 memory and a value of 7T is recommended for PC2700 memory (which the ABIT KR7A-133 doesn’t support anyway).
Active to CMD(Trcd) 2T
DDR DQS Input Delay Auto
Input Delay Value 24
DDR DQS Output Delay Auto
Ouput Delay Value 40
Command Drive Strength Hi Set this to Hi for added stability, especially with multiple DIMM’s in use.
Rx6C OverWrite Disabled Default value. Even ABIT technical support couldn’t tell me what this does, so it’s best to leave it alone.
OverWrite Rx6C 00 Ignored since Rx6C OverWrite, whatever that is, is disabled.
Rx6D OverWrite Disabled Default value. Even ABIT technical support couldn’t tell me what this does, so it’s best to leave it alone.
OverWrite Rx6D 0A Ignored since Rx6D OverWrite, whatever that is, is disabled.
DRAM Queue Depth 4 level For best performance.
DRAM Command Rate 2T Command The 1T Command setting is unstable and problematical.
DCLK Feedback Delay 0 ps The only agreed safe value.

 

AGP & P2P Bridge Control (sub-menu)
Parameter Setting Comments
AGP Aperture Size 64MB The BIOS optimization guide reference from Adrian’s Rojak Pot above provides a great description of how this should be set and why. A value of 64MB is best for most configurations.
AGP Mode 4x
AGP Driving Control Auto Setting to Manual may destabilizes the video card.
AGP Driving Value DA Not changeable with AGP Driving Control set to Auto.
AGP Fast Write Enabled
AGP Read Synchronization Disabled Setting to Enabled may cause instability.
AGP Master 1 WS Write Enabled By default, the AGP busmastering device waits for at least 2 wait states before it starts a write transaction. This option sets the delay to 1 wait state. This setting works fine with the motherboard and video card I have in My Super PC. But if you see anything strange with your graphics then set back to Disable and see if it clears up.
AGP Master 1 WS Read Enabled Default is at least 2 wait states. The Comments under AGP Master 1 WS Write apply.

 

CPU & PCI Bus Control (sub-menu)
Parameter Setting Comments
PCI Master Read Caching Disabled Setting to Enabled allows CPU L2 cache to be used for PCI master reads, but that leaves less CPU L2 cache for system memory which doesn’t sound like a good trade, so I’ve set it to Disabled.
PCI Master Bus Time-Out Disabled Default value. If a PCI device is troublesome, like crackling noises are coming from the PCI sound card, then changing this parameter may clear it up.
PCI Master Priority Rotation Co Disabled Controls the CPU’s access to the PCI . The default value is Disabled. As long as the PCI devices are performing properly it’s fine to leave it disabled. By the way, it looks like the full name of the parameter was overwritten on the display by it’s displayed value.
PCI1 Master 0 WS Write Enabled Performance is better when set to Enabled.
PCI2 Master 0 WS Write Enabled Ditto.
PCI1 Post Write Enabled Ditto.
PCI2 Post Write Enabled Ditto.
PCI Delay Transaction Enabled This option should be enabled for better performance and to meet PCI 2.1 specifications. Disable it only if your PCI cards cannot work properly.
Master Delay Transaction Disabled Default value. Even ABIT technical support couldn’t tell me what this does, so it’s best to leave it alone.

 

Memory Hole Disabled Some special ISA cards require this area of memory for them to work properly. Enabling this function reserves the memory area for the card’s use. It will also prevent the system from accessing memory above 16MB. This means that if you enable this function, your OS can only use up to 15MB of RAM, irrespective of how much RAM your system actually has. So, always disable this function unless your ISA card absolutely requires this memory area to work properly.
System BIOS Cacheable Disabled This feature is only valid when the system BIOS (F0000-FFFFF) is shadowed. It greatly speeds up accesses to the system BIOS. However, this does not translate into much better system performance because the OS does not need to access the system BIOS much. As such, it would be a waste of L2 cache bandwidth to cache the system BIOS instead of data that are more critical to the system’s performance. In addition, if any program writes into this memory area, it will result in a system crash.
Video RAM Cacheable Disabled Set to Disabled for all nVidia based cards.

Integrated Peripherals

Parameter Setting Comments
VIA OnChip IDE Device (sub-menu)
Parameter Setting Comments
IDE Prefetch Mode Enabled For best performance.
Onboard IDE-1 Controller Enabled These are the ATA/133 IDE controllers.
Onboard IDE-2 Controller Enabled These are the ATA/133 IDE controllers.
– Master Drive PIO Mode Auto Set all of these to Auto and let the BIOS determine if each drive is capable of DMA support, and its respective PIO mode.
– Slave Drive PIO mode Auto Ditto.
– Master Drive Ultra DMA Auto Ditto.
– Slave Drive Ultra DMA d> Auto Ditto.

 

SuperIO Device (sub-menu)
Parameter Setting Comments
Onboard FDD Controller Enabled I do have floppy.
Onboard Serial Port 1 3F8/IRQ4 Standard.
Onboard Serial Port 2 2F8/IRQ3 Standard.
– Onboard IR Function Disabled No Infra-Red devices.
– RxD , TxD Active Hi,Lo Not applicable since IR is disabled.
– IR Transmission Delay Enabled Not applicable since IR is disabled.
– IR Function Duplex Half Not applicable since IR is disabled.
– Use IR Pins IR-Rx2Tx2 Not applicable since IR is disabled.
Onboard Parallel Port 378/IRQ7 Standard.
– Parallel Port Type SPP Set this to SPP unless you have a device or printer that specifically requires use of ECP/EPP modes such as a parallel port scanner, zip drive, etc.”
– EPP Type Select EPP1.9 Not changeable since Parallel Port Type is set to SPP.
– ECP Mode Use DMA 3 Ditto.

 

Init Display First AGP Set to AGP if your primary display is your AGP adapter, or to PCI if the primary display is a PCI video card.
USB Controller All Enabled
– USB Keyboard Support BIOS

Power Management Setup

Parameter Setting Comments
ACPI Suspend Type S1(POS)
Power Management Option User Define My Super PC does not use the Suspend power saving mode.
HDD Power Down Disable Ditto.
Suspend Mode Disable Ditto.
Video Off Option Suspend -> Off Screen off when system is in SUSPEND mode, which it never is, in my case.
Video Off Method DPMS Support Use this setting if you have a PnP capable monitor.
Modem Use IRQ NA Manually assigning the IRQ is not needed.
Soft-Off By PWRBTN Instant-Off You don’t want slow death.
State After Power Failure Off
IRQ/Event Activity Detect (sub-menu)
Parameter Setting Comments
PS2KB Wakeup from S3/S4/S5 Disabled My Super PC awakens on pushing the power button only. Just so you know, PS2KB is the PS/2 keyboard and S3/S4/S5 are sleep states
PS2MS Wakeup from S3/S4/S5 Disabled. PS2MS is the PS/2 mouse.
VGA OFF
LPT & COM NONE
HDD & FDD OFF
PCI Master OFF
PowerOn by PCI Card Disabled
Modem Ring Resume Disabled
RTC Alarm Resume Disabled
Date (of Month) 0 Not applicable with RTC Alarm Resume Disabled.
Resume Time (hh:mm:ss) 23 :0 : 0 Not applicable with RTC Alarm Resume Disabled.

 

IRQs Activity Monitoring (sub-menu)
Parameter Setting Comments
All interrupt Event Off Disable IRQ’s from having any effect on power management.

 

PnP/PCI Configurations

Parameter Setting Comments
PNP OS Installed Yes If you’re using Windows (and who isn’t?), set this to Yes.
Force Update ESCD Disabled Normally leave this Disabled. But if, for example, you add a new card and the subsequent system reconfiguration causes a serious conflict of resources (maybe the OS won’t boot) then setting this to Enabled is a solution to be considered.
Resources Controlled By Auto (ESCD) Let the BIOS figure out IRQ’s and DMA channels.
PCI/VGA Palette Snoop Disabled The VGA “palette” is the set of colors that are in use by the videocard when it is in 256-color mode. Since there are thousands of colors and only 256 can be used in that mode, a palette containing the current colors is used. Some special VGA cards, high-end hardware MPEG decoders, etc. need to be able to look at the video card’s VGA palette to determine what colors are currently in use. Enabling this feature turns on this palette “snoop”. This option is only very rarely needed. It should be left at “Disabled” unless a video device specifically requires the setting enabled upon installation.
Assign IRQ for VGA Enabled Set to Yes if you are using an AGP video card.
Assign IRQ for USB Enabled Set to Yes if you are using an USB device.
PIRQ_0 Use IRQ No. Auto The more the BIOS automatically figures out the IRQ settings the better I like it.
PIRQ_1 Use IRQ No. Auto Ditto.
PIRQ_2 Use IRQ No. Auto Ditto.
PIRQ_3 Use IRQ No. Auto Ditto.

PC Health Status

Parameter Setting Comments
Temperature Warning Disabled
CPU Shutdown Temperature Disabled
Shutdown when CPUFAN Fail Disabled

© 2001-2003, Rob Williams, all rights reserved.

原文出處:http://www.build-pc.com/bios_settings.shtml

彈出式選單 II

很久很久以前我們有一篇彈出式選單的教學,今天再來一個一樣是彈出式選單,但比上一篇更簡單,因為這是內建的功能,看官們就看圖說故事吧!

基本上這次可以完全不必用到圖層,範例用一個至#的連結

到上面應該大家就都自己會摸了吧?!那我就結束囉!bye!

資料庫-插入資料

上面一篇光只是顯示資料怎麼夠,現在要講怎麼新增資料,凡事要有效率,所以我們把上一篇的東西拿來繼續用!我們把重複顯示的區域放到下面,上面插一條水平線(沒任何作用,弄爽的)再來請照著圖示分別放入 表單 文字方塊 按鈕

好了之後去點選 伺服器行為+插入記錄

form1表單名稱test資料庫名稱tech則是資料表名稱,這應該不用在多做解釋了!

一開始 裡的東西應該都是沒有取得值的,除非你把文字方塊名稱命名跟資料表欄位名稱一樣他就會自動對應,否則還是手動點一點吧!

一切就緒按下F12使用IE預覽!填個資料上去吧按送出

哈哈,成功了!

資料庫-顯示資料

一個多月沒更新了,今天來動一下好了,前面講過做資料庫連結了,接下來講應用,要怎麼在網頁上顯示資料庫裡的資料呢?

本來是想用Access的啦,後來還是用MySQL,在範例中我在test的資料庫裡新增一個tech的資料表,有以下四個欄位

同時加入三筆資料如下

OK後回Dreamweaver去,當然就是先建立繫結囉,名稱隨你定啦,連線對應到我剛剛講的"test"資料庫,表格對應到資料表

好了之後會看到多出了一個資料集,後面的名稱對應到剛剛的名稱

我們在編輯區放了一個1*4的表格,將滑鼠分別放至上面的id.class.name.num上然後拖曳到編輯區的表格內

好了之後應該像上面這樣

之後將整個表格選取注意!要選取喔!下面是錯誤的示範沒有選!

選取起來後點選 伺服器行為 – + – 重複區域

你可以選擇一次顯示幾個記錄或者全部顯示

如果沒有做這個動作則一次只會顯示一個記錄

那要怎麼看到剩下的紀錄??後面再講啦。

好了後按下即時資料檢視,就是這個光!出來了吧!

最後來補充一下

有人如果問,難道我就不能一次只顯示一筆資料,然後在慢慢看其他的嗎?可以,當然可以

那你就不要做重複區域了,做上面的動作,不是有移至XXX

聰明吧,我選了移至下一頁,他就自己跑出來下一頁連結了,再按下即時資料檢視試試看吧!

電腦耗電量測試

這裡做個簡單的測試讓大家衡量自己電腦的耗電量,也可以順便算一下一個月電費要多少~

測試的方法是利用UPS的監控軟體來看它的負載,然後再推瓦數出來。
http://www.deltaww.com/ups/products/hardware/s500_series.htm

接在負載上的裝置共有:
主機配備:
Duron 600=>1.45V 800Mhz + 風扇
Abit KT7-R + 有一個北橋風扇 + 一個系統風扇
PQI 512MB RAM
ASUS V7100
便宜的音效卡
Leadtek TV2000
Realtek 8139
IBM Deskstar 75GXP 30.7GB + 一個12×12風扇
Seagate Barracuda ATA II 20GB + 塑膠’保溫盒’的風扇..
Afreey 50X CDROM
Pleaxtor 8432Ti

GVC 15”螢幕
數據機:ZyXEL 642
印表機:CANNON SP2100

開始測試囉,蚊子將印表機列印測試頁,CDROM和CDRW都放入片子以複製檔案的方式讓它啟動,電視卡也打開,撥放MP3開啟喇叭..只差沒放軟碟去讀而已..結果如下

以滿載為300W來推算,300*0.64=192W
電費如果以每度三塊錢,每天電腦開12HR,則一個月電費192*12*30*3/1000=207塊

記憶體問題測試 memtest86

電腦很不穩定,常遇到莫名其妙的當機嗎?常常出現程式錯誤嗎?是不是該檢查一下你的記憶體有沒有問題了。任何程式在執行時,都是先將其放置記憶體內才去執行,那你會問,我記憶體才64MB,Windows那麼大怎麼放的進去,你騙人不懂喔,別忘了,有一個東西叫做虛擬記憶體的,他就是利用硬碟空間將目前不需要的暫存到硬碟上。

今天這個軟體叫做memtest86,Freeware喔!目前最新版本為2.9,可至官方網站下載http://www.memtest86.com

下載回來後將其解壓所可看見四個檔案,看到install.bat給他點兩下執行就對了!

執行後會跳出這個畫面,請鍵入你的磁碟機代號,如a

再來插入一張已經格式化過的磁碟片按enter,這樣就完成了。

再來用剛剛製作的磁片來開機就會進到這個畫面,預設的標準模式一般跑一兩個小時就會完成了,若要完整測試則要花兩三倍的時間,如果你堅持可以在主畫面按下C→2→3→0就會進行完整的測試。圈起來的Pass下面數字代表通過測試的次數,也就是說跑完一次後他並不會停止,而是繼續跑,旁邊的Errors就會顯示共有幾個錯誤,而下面圈選空白處你如果有出現文字的話不要高興,那是記憶體那邊錯誤的詳細資料,準備送修吧。

反鈴聲付費下載

廢話篇:

話說手機鈴聲下載網站如雨後春筍般冒不停,但仔細看看,在這『號稱』不景氣的時代,他的收費還真是好賺,好個Yahoo的每首十點、更多是020、09xx開頭的每分鐘二十?!還有下面這種的,寫的好像很好聽喔!『線上可試聽、喜歡在下載!』你可是每三十秒計費的耶!當然最好大家都在上面慢慢試聽今天來到這邊讓你不花一毛錢!

總要找個網站來開刀,就Yahoo了,誰叫你登錄讓我等那麼久!,這樣也就罷了,要刪除舊登入的時候卻又效率那麼快!

來到了Yahoo鈴聲的區域,慢慢挑,隨便挑!有試聽這最好!看到喜歡的就點下去。

喔,跳出了一個popup視窗

按下右鍵另存新檔,哈哈哈,得來全不費功夫,手機王就比較龜毛!誰叫你效率那麼差,不然就拿手機王開刀。

這張好像沒什麼必要

好了之後打開Nok2Phone,去把剛剛存檔的MIDI檔打開吧!跳出這個視窗他有寫『If you do not know what Channel is,click "OK"』

基本上這種普通鈴聲也是只有一個Channel,而現在流行的X合旋就不是了,一個Channel有一個音色,所以要是有Midi聽起來有如黃鶯出谷、餘音繞樑三日不絕、波濤洶湧、這種的拿來轉你會發現,轉出來的鈴聲怎麼怪怪的,如果管弦樂團只剩下一種樂器在『配樂』會怎樣??

又到這個可愛的畫面,按下右邊各廠牌型號,譜就出來了,((哈哈哈)),得來全不費功夫!

反Nokia鈴聲

廢話連篇:

還記得曾經有過這種『好野人』手上拿著8250,一般人人手一機3250的『盛況』嗎?(開玩笑..我才不會去搭這種國民機熱潮,在那個年代小弟我奮勇加入易立信的行列,傳說中的肥皂T20便是我個人擁有的第一隻手機)手機好像就是標準配備一樣,我還是到高二工作需要才去辦的勒..,如果說拿來用確實算功能強大的,而且又便宜,2001年代單機三千出頭,含WAP,八首自編鈴聲、五組遊戲、支援EMS、兩百組電話簿、冷光螢幕、支援FM外接裝置、MP3外接裝置、聊天版、少話量電池可達五天,手機上可直接對SIM卡及手機記憶體做複製動作,講這些幹嘛….當然NOKIA佔有率高不是沒道理的,外型他就贏了,現代人第一眼都只看外表的佔有率高,周邊也就普及(皮套、傳輸線、副廠電池)一多自然就便宜,傳輸線一條兩百多就有了,然後有圖案可以玩、可以下載、動態的短訊息等..我家的SAGEM(嘿嘿..『預計』未來的重點,my X-5)一條要六七百,而且小通訊行還找不到勒..連機子通訊行都看不到了..

進入重點:

開始準備進入重點、,網路上開始在流行鈴聲編輯,當然各家方式不同,但佔有率高的是老大,大部分看到的譜都是NOKIA的格式,其他品牌的就比較少了,常常看到在一些熱門Nokia鈴聲譜下面看到回應-請問有沒有易立信的、有沒有Panasonic格式的、有沒有三星格式的,看久了都會煩,我們先來談怎麼反對Nokia這股『惡勢力』吧,這就要藉助Nok2Phone這套軟體了,他可以將Nokia的鈴聲譜轉成其他手機的譜,也可以轉換MIDI檔,在這篇文章佔極大的重要份量。

上面的就是這個軟體,香港來的~為共享軟體,印象中有鈴聲長度轉換的限制,但軟體是人寫的,然後就有人會破解,這個嘛~自個去找找解決的辦法我想你會感覺更甜美的,回歸正題,舉個例子:

熱帶雨林-S.H.E

Tempo:180

4c2 4d2 4g2 4.e2 4.f2 2g2 4c2 4d2
4g2 4f2 4e2 4d2 2c2 4c2 4d2 4g2
4.e2 4.f2 4g2 4f2 4e2 4d2 2c2 2.e2
4e2 4e2 4e2 4.e2 4.d2 2f2 4e2 4d2
4c2 4d2 2e2 2.c2 4a1 4c2 4a1 4c2
4a1 4c2 4a1 4b1 2.c2

只要Nok2Phone右邊選單有的你都可以轉換過去,選一個好了..那就易立信吧!點選上圖的Reverse conversion

接下來會出現這個視窗,我們將原本的Nokia譜貼上去注意!斷行必須接起來每個音符中間空一個半形空白,選擇Nokia(Text)-點選Convert to Nokring

將上圖圈選的地方改成原譜提供的Tempo!接著Save Nokring as…你就存檔吧!格式為文字檔,接者請回到主視窗,點選File-Open…,將視窗下的檔案類型改成Nokring Text (*.txt)找到剛剛存檔的文字檔,將他開啟然後按下右邊欲轉換的格式即可!

看到了吧,就是這麼簡單而已!

建立資料庫連線、資料集查詢-MySQL

開始要講到資料庫的東西了,我想表格、框架等那些東西並不需要介紹了,基本上ASP的Access資料庫要資料庫連線跟這是大同小異的,不囉說先開始這篇。

首先當然先確認你的網站定義-進階-測試伺服器-伺服器模式是否為PHP MySQL,當然如果你本來就要以其他語言為腳本就沒話講了。

createdatabase.png

選擇Dreamweaver MX右邊工作列之應用程式-資料庫 點選 + – MySQL連線

在這邊輸入

連線名稱:自訂
MySQL伺服器:一般為localhost,即為本機
使用者名稱:用來存取資料庫的使用者名稱
密碼: 用來存取資料庫的使用者名稱
資料庫:要建立連線的資料庫 ,按下選取可以選擇可以選的資料庫

按下測試以確認連線成功

完成之後就可以看到我們剛剛成功建立之資料庫連線名稱在下方

再來我們要建立資料集(查詢),選擇應用程式-繫結-資料集(查詢)

在這裡我們可以定義:

名稱:請自行定義
連線:選擇之前你所定義的MySQL資料庫連線名稱
表格:選擇要建立資料集查詢之表格
攔:選擇要建立資料集查詢之表格
篩選器:可以用來過濾你不想要的資料,例如本來裡面有Class這個欄位,用來分類寫入的資料,嗯..看下面的可能會比較清楚。

Student:資料庫名稱,用於儲存學生班級姓名座號,下有資料表
–ID:學號
–Class:班級
–Number:座號
–Name:姓名

如果今天你要建立一個資料級查詢內只含某個班級的話,你就可以在篩選器選擇 Class = 參數 or 變數 or 輸入值某某班

就像

這樣子設定的話所建立的資料集查詢裡只會有在 "user_notify"這個資料表是等於 "訊三孝班"的資料,其他的則不會有。

排序: 應該沒什麼好講的

接下來要怎麼將動態資料放到網頁上

只要把需要的欄位資料拖曳到網頁需要的地方就可以了

按下 即時資料檢視,看吧,就會出現目前這個欄位內的第一筆資料了。

後面的就已經超出單純資料庫連線範圍了,寫到這為止。