Share
Embed
Transcript
92 slides
-
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP <?php $keyword = ''; if (isset($_POST['keyword'])) { $keyword
= $_POST['keyword']; } mysql_connect('localhost','user','password'); mysql_select_db('cakephp_sample'); mysql_query('set names utf8'); $sql = sprintf( "SELECT id,name,description FROM friends WHERE name LIKE '%s'", mysql_real_escape_string('%'.$keyword.'%') ); $result = mysql_query($sql); $data = array(); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } ?> <html> <head><title>ςετϖʔδ</title></head> <body> <form action="list1.php" method="POST"> <input name="keyword"><input type="submit"> </form> <ul> <?php foreach ($data as $row) { echo '<li>'; echo $row['name']; echo $row['description']; echo '</li>'; } ?></ul> </body></html> -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP <?php $keyword = ''; if (isset($_POST['keyword'])) { $keyword
= $_POST['keyword']; } mysql_connect('localhost','user','password'); mysql_select_db('cakephp_sample'); mysql_query('set names utf8'); $sql = sprintf( "SELECT id,name,description FROM friends WHERE name LIKE '%s'", mysql_real_escape_string('%'.$keyword.'%') ); $result = mysql_query($sql); $data = array(); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } ?> <html> <head><title>ςετϖʔδ</title></head> <body> <form action="list1.php" method="POST"> <input name="keyword"><input type="submit"> </form> <ul> <?php foreach ($data as $row) { echo '<li>'; echo $row['name']; echo $row['description']; echo '</li>'; } ?></ul> </body></html> 7JFX .PEFM -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP <?php //index.php $keyword = ''; if (isset($_POST['keyword'])) {
$keyword = $_POST['keyword']; } include ‘model.php’; include ‘view.php’; <?php //model.php mysql_connect('localhost','user','password'); mysql_select_db('cakephp_sample'); mysql_query('set names utf8'); $sql = sprintf( "SELECT id,name,description FROM friends WHERE name LIKE '%s'", mysql_real_escape_string('%'.$keyword.'%') ); $result = mysql_query($sql); $data = array(); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } <!-- view.php --> <html> <head><title>ςετϖʔδ</title></head> <body> <form action="list1.php" method="POST"> <input name="keyword"><input type="submit"> </form> <ul> <?php foreach ($data as $row) { echo '<li>'; echo $row['name']; echo $row['description']; echo '</li>'; } ?></ul> </body></html> .PEFM 7JFX $POUSPMMFS -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP SFXSJUFແ͠ͷ߹ /** * To configure CakePHP *not* to
use mod_rewrite and to * use CakePHP pretty URLs, remove these .htaccess * files: * * /.htaccess * /app/.htaccess * /app/webroot/.htaccess * * And uncomment the App.baseUrl below: */ //Configure::write('App.baseUrl', env('SCRIPT_NAME')); ίϝϯτΛ֎͢ SFXSJUF͕ແཧͳ͚࣌ͩ VSMͷඌʹJOEFYQIQΛ͚Δ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP యܕతͳίϯτϩʔϥʔ QIQ BQQ$POUSPMMFS5BTLT$POUSPMMFSQIQ "QQVTFT "QQ$POUSPMMFS $POUSPMMFS
DMBTT5BTLT$POUSPMMFSFYUFOET"QQ$POUSPMMFS\ QVCMJDGVODUJPOJOEFY \ UBTL@EBUBUIJT5BTLpOE bBMM` UIJTTFU bUBTL@EBUB` UBTL@EBUB ^ ^ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP యܕతͳϞσϧ QIQ BQQ.PEFM5BTLQIQ "QQVTFT "QQ.PEFM .PEFM
DMBTT5BTLFYUFOET"QQ.PEFM\ QVCMJDVTF5BCMFUBTLT ^ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP UIJTpOE bBMM` PQUJPOT UIJTpOE bpSTU` PQUJPOT
UIJTpOE bDPVOU` PQUJPOT UIJTpOE bMJTU` PQUJPOT UIJTpOE bUISFBEFE` PQUJPOT UIJTpOE bOFJHICPST` PQUJPOT pOE Φϓγϣϯ࣍ୈͰࣗࡏʹ42-จΛ࣮ߦ Φϓγϣϯ͕ଟ͍ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP BSSBZ DPOEJUJPOTBSSBZ .PEFMpFMEUIJT7BMVF SFDVSTJWF JOU pFMETBSSBZ .PEFMpFME %*45*/$5.PEFMpFME
PSEFSBSSBZ .PEFMDSFBUFE .PEFMpFME%&4$ HSPVQBSSBZ .PEFMpFME MJNJUO QBHFO P⒎TFUO DBMMCBDLTUSVF pOE ͷΦϓγϣϯ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP BSSBZ DPOEJUJPOTBSSBZ .PEFMpFMEUIJT7BMVF SFDVSTJWF JOU pFMETBSSBZ .PEFMpFME %*45*/$5.PEFMpFME
PSEFSBSSBZ .PEFMDSFBUFE .PEFMpFME%&4$ HSPVQBSSBZ .PEFMpFME MJNJUO QBHFO P⒎TFUO DBMMCBDLTUSVF pOE ͷΦϓγϣϯ ඞཁͳ͍෦దٓলུՄೳ ༷ʑͳpOE ʹ͜ͷΦϓγϣϯΛ͏ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP pFMEbB`ͷΑ͏ͳൺֱ BSSBZ DPOEJUJPOTBSSBZ .PEFMpFMEUIJT7BMVF Ҏ֎ͷൺֱ Ωʔ໊ʹεϖʔεΛۭ͚ͯԋࢉࢠ pFMEMJLFbB`ͷΑ͏ͳൺֱ BSSBZ
DPOEJUJPOTBSSBZ .PEFMpFMEMJLFb`UIJT7BMVF`` -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP "/% BSSBZ DPOEJUJPOTBSSBZ .PEFMpFME .PEFMpFME "/%݅03݅ 03
BSSBZ DPOEJUJPOTBSSBZ b03`BSSBZ .PEFMpFME .PEFMUZQFb"` -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP EFMFUF EFMFUF"MM %&-&5&Λ࣮ߦͰ͖Δɻ ͔࣮͠͠ࡍͷγεςϜͰ%&-&5&Θ ͣআϑϥάͳͲͰૢ࡞͢Δࣄ͕ଟ͍ɻ .PEFMEFMFUF JE DBTDBEF
.PEFMEFMFUF"MM DPOEJUJPO DBTDBEF -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP EFGBVMUDUQͷཁॴ CPEZ EJWJEDPOUBJOFS EJWJEIFBEFS
I QIQFDIPUIJT)UNMMJOL DBLF%FTDSJQUJPO IUUQDBLFQIQPSH I EJW EJWJEDPOUFOU QIQFDIPUIJT4FTTJPOqBTI QIQFDIPDPOUFOU@GPS@MBZPVU EJW EJWJEGPPUFS QIQFDIPUIJT)UNMMJOL UIJT)UNMJNBHF DBLFQPXFSHJG IUUQXXXDBLFQIQPSH EJW EJW QIQFDIPUIJTFMFNFOU TRM@EVNQ CPEZ -
࣌ؒٱ$BLF1)1!Ԭ:VTVLF"OEP !ZBOEP $44ͳͲ IFBE QIQFDIPUIJT)UNMDIBSTFU
UJUMF QIQFDIPDBLF%FTDSJQUJPO QIQFDIPUJUMF@GPS@MBZPVU UJUMF QIQ FDIPUIJT)UNMNFUB JDPO FDIPUIJT)UNMDTT DBLFHFOFSJD FDIPTDSJQUT@GPS@MBZPVU IFBE