PHP,MySQLKaIApache l ... , 1 : MySQL, Apache 1 MySQL 72 Apache 273 51 11: 4 715 936 1157 135 111: 8 / 1539 18110 20311 21312 Server 23713 245 IV: MySQL 14 26115 SQL 27316 MySQL 321 : 17 33518 l 34719 37120 38721 39922 .41323 .42724 S e r e r .44925 467 : m 26 Apache .48127 WebS e r e r 49928 MySQL 51529 533 l l : 30 5.0 54131 MySQL 4.1 547 l l l : MySQL, Apache CD-ROM 557 569 1 ; 1 2 ' .3 : MySQL, Apache 1: MySQL 7 MySQL 7 MySQL 8 MySQL L / 8 MySQ L Windows 9 16 16 MySQL 17 MySQL 18 MySQL 18 : 19 20 21 23 23 & 25 25 25 25 26 2: Apache 27 Apache 27 28 28 Apache 28 Apache Linux/Unix 29 Apache 29 29 Apache .30 Apache 31 Apache Windows 32 Apache .35 35 (Contai ners) 37 38ServerRoot 39 .40 Apache .41 access_log .41 error_log ..41 .42 Apache .42 Apache Server .42 Script Apache .43 Apache .44 .44 Apache .45 46 Web Server .46 .46 46 .47 .47 .48 .48 .48 .49 ..49 3: 51 51 Apache 52 53 Apache 54 crraWi ndows 55 Apache Wi ndows 55 php. ini 56 , MySQL Apache 57 58 Scripts - 59 60 echo 62 63 64 65 & 66 66 66 67 67 11 : 4: 71 71 ; - 73 74 settypeO 76 ?? ; .79 79 80 81 ; 81 82 / 83 ; 84 ; ; 8S 86 87 89 89 & 90 90 90 ; 91 92 5: v x 93 93 if 94 else if. 95 elseif if 96 switch 97 99 100 while 100 do while 101 for 102 break 104 continue 106' 107 Browser 109 11 & 112 112 112 113 113 6: 115 : 115 116 117 120 ( ) 121 global. 122 static 124 126 127 128 ; 130 132 & 133 133 133 134 134 MySQL Apache 7: 135 135 135 137 137 139 140 142 143 Construeto r 145 145 147 148 148 148 148 149 111: 8: 153 154 154 157 161 162 162 162 st rleno 163 strstr o 163 strposo 163 substr O 164 strtokO 165 166 tri mo, Itrimo strip_tagso 166 5Qb51r_replaceO 168 51r_replace 168 169 wordwrapO nl2brO 170 172 172 limeO 172 geldateO 173 daleO 174 mklimeO : 176 chec kdaleO 178 178 179 179 179 180 180 9: 181 181 183 186 189 190 191 mailO 192 193 Script 194 196 197 198 Script 199 201 202 202 202 202 , MySQL Apache i i 10: 203 203 204 205 209 21 211 & 212 :: 212 212 212 212 11: 213 incl udeO 213 215 includeO ; 216include_onceO 217 include_path .217 218 fil e_existsO 218 ; 218 219 filesize() 219 220 220 .222 , 222 223 fgetsO feof () 224 fread() 225 fgetcO 227 228 fwriteO fputsO 229 flockO 230 231 mkdirO 231 rmdirO 231 opendirO 232 readdir O 232 234 & 235 235 235 236 236 12: Server 237 , popenO 237 execO 239 systemO passthruO 241 242 & 243 243 243 243 13: 245 245 245 246 247 247 248 250 251 254 257 & 258 258 258 258 258 . MySQL Apache V IV: MySQL 14: 261 261 262 263 / 264 / 265 . 266 267 268 268 269 270 271 & 272 272 272 272 272 15: SQL 273 MySQl 273 l 274 / 275 276 277 INSERT 278 INSERT 278 SElECT 280 SEl ECT 281 SElECT 282 WHERE 283 WHERE . 283 . lI KE 284 / 285 JOIN 287 UPDATE 289 ; 291 UPDATE 292 REPLACE 292 293 ..294 MySQL .296 296 298 .300 .301 MySQL .303 .303 .306 .307 .308 MySQL .309 MySQL .311 .313 31S .317 .318 318 318 ....................................................................................................319 16: MySQL 321 MySQL .321 mysql_co nnectO .322 323 .324 MySQL .325 325 .329 MySQL .331 .331 332 .332 .332 , MySQL Apache V: 17: 335 / .335 , subscribers ..336 / 336 342 .345 & 346 .346 346 .346 18: Online 347 347 350 351 355 361 .362 .368 369 369 .369 369 19: 371 371 Scripts 372 375 379 382 385 20: 387 387 store_categories .389 store_items 390 / store_item_size .391 store_item_color 391 i i .391 .395 397 .398 398 398 21: 399 399 Onl ine 401 ..404 405 .408 409 409 / .410 .411 .412 .412 412 22: 413 .413 .413 L .414 416 .420 425 & .426 .426 426 .426 .426 23: 427 - .427 C i e n t .428 Apache .429 .430 432 MySQL Apache Apache .." """"" " " " "" """" .433 ..""". " """ " "" " "" ".434 " """""""" "" " " " " """" " """ "".435 Apache """" """""..436 """"""""""""""" "" """" ,,437 Cookies " "" """ "" " " ""." " ...438 Cookie " "" ".." "." "" "." .438 Cookie """"""""""""""""""""" """""" """""""""""".43 9 Cookie ." """ "." ""." " " " "" "." .441 Cookies """" """""""""""""""""""".441 ..441 Script """""",,443 Cookie auth """" " """""""""""""""""""""""""" ".445 " "" " " " "" "" "" ""." "" " " ".446 "" "" " " "" " "" " " """ "" " " "" " "..447 ..""" "" "" " "" " " "." " "." .447 ..447 .., "." " " "" ""." " "" "" "" .448 """ "." ". " " ". "" "" " "" "" " .448 24: 449 Apache """"""""""" " """" " """""""..449 .450 ." """ "". " "" " ",, " " .454 "" """ "" "" " " ".455 Apache "" "" " " "" " ".4 55 ..456 syslog " " " " " " " " "." """ " "" ".456 LogLevel " "" ".." """ "." " " " " "..456 Apache """" " "" "" " """" """ """"""",,457 Host .457 .."" """ "" "" " " .458 """""" """" " .460 " " ." " " """ " " ".".."."" " 460 .460 .461 .464 .465 .465 .465 .465 25: 467 .467 .468 .469 Apache .470 .470 MySQL .471 .471 .476 .477 .477 .477 .477 26: Apache 481 .481 .482 Apache .483 ApacheBench .485 .487 .487 487 Cache .488 .488 .489 .489 .489 , MySQL Apache Sites Host .." " " .490 Host .491 Host .491 Host .493 .495 & .496 497 .497 .497 27: Web Server 499 .499 .499 .499 500 SSL .500 500 502 503 SSL 505OpenSSL 505mod_ssl 506 508 508 509 - 51 SSL 511 5erver 511 .512 & 513 513 513 513 28: MySQL 515 515 benchmarkO 516 MySQL 517 .518 519 520 FLUSH 521 SHOW 522 523 524 527 528 & 530 .530 530 530 531 29: 533 .533 ; 534 MySQL 535 Apache 535 Apache 536 536 537 .538 538 538 l l : 30: 5. 0 541 4; 541 542 .544 SQLite 544 L 544 5; 545 545 545 & 546 MySQL Apache 31: MySQL 4,1 547 547 548 551 .551 MySQL5.0 552 552 553 553 553 553 MySQL, Apache CDROM 557 557 My5QL .557 Apache 559 559 Wi ndows 561 MySQL 562 Apache 564 565 568 569 Web MySQL Apache server. Apache, MySQL. Web - Windows. Linux/Unix) Windows) C PerI, Oracle Microsoft SQLServer, MySQL. Web, Web, 2 MySQL, Apache MySQL Apache. MYSQL Apache, 11: 111: MySQL MySQL. Apache MySQL. host Web 5.0 MySQL4.1. MySQL Apache 3 MySQL, Apache 1 MySQL2 Apache3 1 MySQL MySQL, MySQL MySQL MySQL MySQL MySQL 4.0.15 MySQL, MySQL MySQL, 5" "4.0" - - MySQL 4.0.16 . ,\ lySQL 8 MySaL MySQL MySQL server MySQL, MySQL Website http://W\V\v.mysql.com/. site MySQL RPM Li nux/Unix. - MySQL- online MySQL MySQL MySQL htt p: //W\V\V. mysql. com/downl oads/mysql.4.0.html . CD MySOL CD, MySOL, Apache CD-ROM'. MySQL MySQL LinuxlUnix RPM RPM MySQL-server-VERSlON.i386.rpm- MySQL server MySQL-cli ent -VERSION.i386.rpm- client MySQL RPM rprn -i My SQL- s e r v er- VERSION. i386. rprnMySQL-clie nt-VERSION. i386. r pm VERSION MySOLnou RPM MySOL 4.0 MySOL-server-4.0.15-0.i386.rpm, RPM client . 15-0.i386.rpm. MySQL Apache 9 MySQL gunzip tar MySQL VERSION-OS MySQL 4.0 Li nux/i386 mysql-max-4.0.15-pclinux-i686.tar.gz.#> groupa dd my sql#> u s e radd -gmysql mysql#> cd /usr/local#>gunzip < /path/to!mysql-vERSION-OS.ta r . gz tar xvf - (Iink) #>ln - $ mysql-VERSION-OS my s ql#> cdrnys ql README INSTALL MySQL #> scr i pt s / mysql _i nstal l _dbt> c hown -Rroot /usr/local/mysqlt > chown - Rmysql /usr/local/my s ql/ da t at> chgrp -Rmy sql / u s r/loc a l/mysqlt> c hown -Rr oot / u sr/ local/ mysql/bin MySQL MySQL Windows MySQL Windows - MySQL setup.exe. setup .exe MySQLserver cJient MySQLserver. MySQL Windows, (installer) Website MySQLAB.1 MySQL Windows 98, 2000 MySQL Windows Windows, Cygwin Windows Web site MySQL 1. setup.exe 1.1. Next 1. 1 MySQL Wi ndows. totheM.ySOLand Cients 4.0.1 5 program. Thi: programwiII MySOLServer: and 4.0.15 onyour compU:er. :uonglyrecommendedtha!youexit Windows belOfe runningt.hisSetup Cancel quiI5etup andthenclose anyyouC6ck10conIinue with W'ARNING: i: proteded bycYId Unauthorized 01tIi: program, DI' portion may result in cRnnaI penaIOe:. be10theunder Iaw..Cancel2. 1.2). C:\ mysql. MySQL MySQL Apache 11 MySQL u- Next 1.2 MySQl. This reIeareof MySQL 4.0.1 5 If MySQL in a rolder ather t:hanC:\MYSQL youintendwstart MySQLon ,,: a mutt C:\MY.CNFor leryotJI'have MySQL wiI 4 fiIe;"""",edMn.cnI. mj>Iagr"", _Det,on .RijI!>I oP,;on, ,;ghl' S"" Ih"liIo-pUOLIC ficenc" .. ,,,Th;."'[1";>' 0 . ee PUBLIC(} ..IO'>odI.d "' 11;'_' ''1_..... ..'''1 , '00 MySQL WinMySQLadmin, MySQL server, MySQLmonitor.16 MySQL MySQL, ' Problems and CommonErrors' MySQL, http:/AV\vw.mysql.com/dodP/r/Problems.html. Linux/Unix, (daemon, MySQL. ''Access denied" MySQL, "Can't connect MySQL ... CHAR VARCHAR). MySQL http://lists.mysql.com/ MySQL MySQL Windows Linux/Unix, (nternet, MySQL Internet, server root - internet - MySQL Apache 17 MySQL MySQL server. (administrator) server Internet MySQL LinuxJUnix, (owner) (deamon ) MySQL- rool. MySQL mysql database, server MySQL ps (process status, MySQL root #> p s auxw grep my s q l dmysql 15 3 0.6 12 068 2624 ? S Nov1 6 00 /us r/ loca l/b i n/my s q l/bi n / my s qld- - de f a u l ts - e xt r a-f i l e =/ u s r / l oc a l / b i n / rny s q l/ da t a / my. cnf- - basedir=/ usr / l ocal/bin/mysql --d a t ad i r =/ u s r / l oc a l/ b i n / mys q l / da ta- - u s e r =my s q l - -pid- fi le=/ usr / l ocal/ b in/ my sql/ d a ta/mike.pid--skip- loc king MySQL rool #> p s auxw grep mysql droot 211 0 7 1.1 11 176 1 444 ? S 27 00 --b a sedi r =/us r/loc al/my s q l - - da t a d i r =/ u s r / l oc a l/ my s q l / da t a --s k i p - l o c k i ng MySQL root Inter net server, MySQL MySQL:mysqld MySQL mysql, mysqld--user =mys q l MySQL scripl safe_mysqld bin MySQL:#> / us r/ l o ca l/ b i n / my s q l/ b i n / s a f e-rn ys ql d &1 MySaL MySQL MySQL MySQLmonitor MySQL MySQL server. MySQL MySQLmonitor MySQL. (screen save r) MySQL server Internet, MySQL MySQLserver. Telnet SSH. SSH elnet , We b server, phpMyAdmi n Intern et MySQL, MySQL MySQL MySQL .. MySQL Apache 19 mysql, MySQL. mysql: columns - db- func - ... host - tables - user - MySQl server. MySQl (authentication). 1. MySQl MySQLserver, MySQl 2. SQl MySQl 1, 2. MySQl server joe abcl23, myDB. joe joe (Iocalhost). joe (iocalhost ), myDB.20 MySQL t> / us r/ l oc al/rnys ql/bi n/ mys ql - h localhost -u j oe - pabc 123 testError 104 5: Access deni ed f or user: . joe@loca l host ' IUsing pa sswo r d: YES) joe abc123 localhost myDB, MySQL joe 2 joe myDB, #> / us r/ l oc al/mys ql/bi n/mys ql -h localhost - u j oe - pabc 123 testRe ading t able infonmation fOTconpl et ionof t abl e dnd col umn names can t urn o f f t t ist o get a quickerwi thWelc ome t he MySQL e nd with ; \g.Your MySQL c onnection i d is 61198 s erve r ve r s ion: 4. 15-1ogType ' hel p;' o r '\h ' f or help. Type ' \ c ' t o c::'ea r tt:e buffer.mysql >select * fromt e s t _t able;+----+------------+ id test_fi e ld +---- +-------- - - --++----+----------- - + 1 blah 2 blahblah+---- +------------+2 rows in s e t sec)mysq l> i ns e r t into test_tabl e val ue s ( ", ' my text' ) ;Error 10 44 : Ac c e ss denied f or user : 'joe@localhost' (Using pas s wo rd: YES ) (INSERT MySQL Internet, - MySQL Apache 21 (wizard) MySQL, GRANT. MySQL rool , INSERT mysqI' GRANT. GRANT GRANT pr i vileges dat abas e name.tablename username@host "p a s sword"; GRANT - ALTER - CREA - - DROP- FILE - - INSERT - PROCESS - 22 MySQL REFERENCES - MySQL, REFERENCES user RELOAD - FLUSH' SELECT - SHUTDOWN - MySQLserver' - USAGE - MySQLserver, john 99hjc, SELECT INSERT myDB GRANT SE LECT, I NSER T myDB. '" j ohn @" %"ID ENTIFI ED "9 9h j c" * %. * % - GRANT' jane 4Ssdg11, employees myCompan y. GRANT ALL myCompany. e mp l oy e e s compa ny.comIDE NTI FIED " 45 s d g 1 1" ; janescomputer.company.com 63.124.45.2, GRANT ALL myCompany. employe e s j a n e @'6 3. 12 4. 45. 2 'I DENTI F I ED " 45 s d g ll" MySQL Apache 23 MySQL GRANT PRIVILEGES, GRANT REVOKE. REVOKE REVOKEprivi leges dat abasename.tablenameFROMuse r name@hostname ; INSERT, DELETE mysq1. REVOKE j ohn (INSERTj myCompany, REVOKE:REVOKE INSERT myDB. "FRQMjohn@"%" ; FLUSHPRIVILEGES MySQL MySQL Windows (\vizard). MySQL Windows, WinMySQLadmin. Linux/Unix MySQL. Linux/Uni x RPM -24 MySQL , MySQL. s e r e r , s e r e r ! MySQLs e r e r . , 0 \ MySQL , . , MySQL . , MySQL , . , w . GRANT, user mysqI. REVOKE, , . MySQL Apache 25 REVOKE DElETE (user) mysql. /nternet MySQLserver rooti Internet server root, 1. Telnet MySQl server 2. MySQL 3. SELECT, INSERT UPDATE (Iocalhost), 1. Teln et SSH 2. 26 MySQL3. GRANTSELECT, INSERT, BillDB... bil l@l ocalhost; ! 1. ; , [ . , ; .2. MySQL, GRANT . ' .3. REVOKE 2. 2 Apache Web server Apache (Iog) (configuration). .. Apache .... Apache server Windo\vs Apache Apache Apache 2.0.47 Apache server, ApacheSoftw3reFoundation "47" "2.0" - - ApacheSoftwareFoundation 2.0.48 http: //httpd.apache.org!do,vnIoad.cgi, 28 Apache Apache, Apache Apache Apache Apache Windows. Apache CD, MySQL,Apache CD-ROM". Apache server Apache (security patches). Apache Apache Apache Linux/Unix Apache Web site Apache $oftware Foundation. Apache Apache (application (modu!es), Apache $oftware Foundation Windows - MySQL Apache 29 Apache Linux/Unix Apache 1. 2. script 3. Apache site Apache http ://httpd.apache.org!. site Apache, tar gzip, compress. (.tar.gz) gunzip. FreeBSD gunzip htt pd2.0.version htt pd-2.0.version.tar.gz, version Apache. Apache 2.0.47 / usr/srd /usr/l0cal/src/ . "tarball, gunzip gzip). 'arball" tar tar.gz). # gunzip Cancel34 Apache Apache (service) Apache server Windo\vs, Windows . Apache server. Apache (default Apache 8080. Apache Web server 80. 2.3. (Typical) Apache header EJ TypeChoosethesetuptype best your needs. select atype. fe"tureswi!l beinstaned. ancI LibrariesfOfroodules wilJ be (ustomChoosewhich featuresyouwant inst"Usdwhere theywin beinstalled. for users. (Custom) header c:\ Program FileslApache Group), 2.4. MySQL Apache 35 Scrver 2.0 . InataIlaoon f3I nst allation WizardComplet edThe Installation WIzardhc'ls 5uccessfully Apache Server 2.0,47, dlckFinlsh exit the Apache server. Apache Apache httpd.conf. (directives) (containers), Apache Apache, (authorization) ... ... 36 Apache \ . # Apache htt p:// httpd.apac he.org' docs -2.0/, (module, online Apache 2.5 Apache , ServerName onIine Apache, http ://httpd.apa-che.org'docs-2 [le E5: 6: SomeDirect i ve37: 8: 9: SomeDirect ive410: