¡¾PHP¡¿Ñ¡ÔñÌâÌâ¿âϵͳV1.0
Õâ¸öϵͳÆäʵÊÇÁ·Ï°php»ù±¾Óï·¨ºÍMySQLµÄ»ù±¾²éѯÓï¾ä¡£¸øÒ»ÆðѧϰµÄÅóÓÑ·ÖÏí¡£ ^_^
ÔÚphpÎļþÖУ¬Ë«Ð±¸ÜºóÃæÊÇ×¢ÊÍÓï¾ä£¬ÎÒÓÃÓ¢ÎÄдµÄ×¢ÊÍ¡£
Õû¸öϵͳËù°üº¬µÄ.htmºÍ.phpÎļþÓУº
add_que.htm——Ìí¼ÓÐÂÌâµÄÒ³Ãæ
insert.php——ÏÔʾÌí¼ÓÐÂÌâÐÅÏ¢µÄÒ³Ãæ
questionlist.php——ËùÓÐÎÊÌâÁбíÒ³Ãæ
search.htm——ËÑË÷ÎÊÌâµÄÒ³Ãæ
result.php——ËÑË÷½á¹ûµÄÒ³Ãæ
MysqlÄÚ£¬Ð½¨ÁË“query”µÄÊý¾Ý¿â£¬ÄÚ½¨“list”µÄÊý¾Ý±í¡£±íÄÚº¬ÓÐ7Ïid,question,a,b,c,d,key¡£questionΪÌâ¸É£¬a,b,c,dΪËĸöÑ¡ÏkeyΪ´ð°¸µÄÑ¡Ïî¡£
ÏÂÃæÊǸ÷¸öÎļþµÄ´úÂë.
/*add_que.htm*/----------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="index.css" mce_href="index.css" rel="stylesheet" type="text/css"/>
<title>Add Question</title>
</head>
<body>
<div style="margin: 0px auto;margin-top:100px; width: 500px;">
<form name="input" action="insert.php" method="get">
Please put your own question.<br />
<textarea cols="50" rows="5" name="question">
A.
B.
C.
D.
Choose The Right Answer:
A
B
C
D
Back To Question List
Search Question
/*insert.php*/----------------------------------------------------------------------
<title>Insert Page</title>
<body style="margin:0px auto; margin-top:180px; margin-left:450px; width: 500px;"></body>
<?php
$db=mysql_connect("localhost:3321","root","root","query");
mysql_set_charset('gb2312',$db);
if(!$db)
{
die('Connect Failed:'.mysql_error());
}
mysql_select_db("query",$db);
$sql="INSERT INTO `list` (`question`,`a`,`b`,`c`,`d`,`key`) VALUES ('$_GET[question]','$
Ïà¹ØÎĵµ£º
ÈÎÎñÐèÇó£ºÒ»¸ö»áÒéͶ¸åϵͳ£¬ÔÚ×÷ÕßÌá½»ÂÛÎÄժҪʱ×Ô¶¯Ïò×÷Õß·¢ËÍÒ»·âÈ·ÈÏÓʼþ¡£
(×¢£ºÍ¶¸åϵͳʹÓõÄÊÇmyreview
)
×Ðϸ¿¼ÂÇһϣ¬Õâ¸öÈÎÎñ¿ÉÒÔÓÐÒÔϼ¸ÖÖ·½Ê½Íê³É£º
ÔÚ·þÎñÆ÷ÉÏÅäÖÃsendmail·þÎñ£¬Ê¹ÓÃphpÖеĵÄmailº¯Êý·¢ËÍÓʼþ£»
ÔÚ·þÎñÆ÷Éϰ²×°mutt + msmtp£¬»òÕßÔÚ·þÎñÆ÷Éϰ²×°ÆäËüµÄsmtp¿Í»§¶Ë³ÌÐò£¬Ê¹ÓÃsmtp¿Í» ......
ÎÒµÄgentooϵͳflashÎÞ·¨ÏÔʾÖÐÎÄ×ÖÌ壬¶øÇÒÎÞ·¨Ë¯Ãߺʹý»ú£¬Óй¦·òÔÙÑо¿Ò»ÏÂÈçºÎ½â¾ö°É
ÒòΪҪ¿ª·¢Ò»¸ö¸»Îı¾¹ýÂ˵ÄphpÀ©Õ¹£¬Òò´ËÑо¿ÁËÒ»ÏÂphpÀ©Õ¹µÄ¿ª·¢¼¼Êõ¡£
php.netÉϵÄÎĵµÐ´µÄ²»È«¡£»¹Òªµ½´¦ÕÒ¡£
¹ØÓÚ¸»Îı¾¹ýÂË£¬¾ÍÊÇ˵¸øÒ»¶Î»ìÔÓÁËhtml,js,cssµÄÎı¾£¬¹ýÂ˳ö°²È«µÄ²¿·Ö£¬Òò´ËÒª×öhtml,css½âÎö£¬ºÚ°×Ãûµ¥Éè¼Æ ......
windowsÏÂ:
1.ÏÂÔØÓÃÓÚ Windows µÄ Instant Client Basic ³ÌÐò°ü:http://download.oracle.com/otn/nt/instantclient/111070/instantclient-basic-win32-11.1.0.7.0.zip
2.½âѹËõ
´´½¨Ò»¸ö×ÓĿ¼£¨ÀýÈ磬d:\oci£©£¬È»ºó´ÓѹËõÎļþÖи´ÖÆÒÔÏ¿⣺
oraociei10.dll
orannzsbb10.dll
oci.dll
µ½´ËĿ¼ÏÂ
´ò¿ªPHP.ini ......
Ò»¡¢°²×°
³õ´ÎʹÓÃEclipse¿ª·¢PHPÏîÄ¿£¬°²×°»¹Êǵû¨·ÑÒ»¶¨µÄʱ¼äµÄ£¬×Ðϸ¿´Ò»Ï±¾
ÎÄ£¬¿ÉÒÔ½ÚÔ¼²»ÉÙʱ¼ä¡£Ê×ÏÈ¡£EclipseÏîÄ¿ÊÇÓÃJava¿ª·¢µÄ£¬ËùÒÔÐèÒªÔÚJavaµÄÐéÄâ»úÉÏÔËÐУ¬¶øEclipseȱʡÊÇûÓдøÐéÄâ»úµÄ£¬ËùÒÔÈç
¹ûÄãµÄ»úÆ÷ÉÏûÓа²×°JavaÐéÄâ»ú£¨Ò»°ãµÄWindows»úÆ÷É϶¼Ã»°²×°£©£¬ÄãÏȵð²×°Ò»¸ö£¬ÔÚÕâÀï˳±ã˵һÏ£ ......