¡¾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]','$
Ïà¹ØÎĵµ£º
ÔÚ PHP Öб¾Éí´øÓÐÒ»¸öÓà C ÓïÑÔʵÏÖµÄ xmlrpc À©Õ¹£¬½Ð
xmlrpc-epi¡£ÒòΪËüÊÇÓà C ÓïÑÔʵÏֵģ¬ËùÒÔ´ÓËÙ¶ÈÉÏÀ´Ëµ±ÈÓà PHP ʵÏÖµÄÄÇЩ xmlrpc
À©Õ¹Òª¿ìµÄ¶à¡£µ«ÊÇÔÚʵ¼ÊÓ¦ÓÃÖÐÈ´·¢ÏÖºÜÉÙÓÐÈËÓÃÕâ¸öÀ©Õ¹£¬´ó¶¼ÊÇÓà PHP ½Å±¾ÊµÏÖµÄ xmlrpc
µÄÀ©Õ¹¡£ÔÒò¿ÉÄÜÓÐÒÔÏÂÁ½µã£ºÒ»ÊÇÕâ¸öÀ©Õ¹ÐèÒªÔÚ·þÎñÆ÷ÉÏ´ò¿ª£¬Èç¹ûûÓзþÎñÆ÷² ......
ÈÎÎñÐèÇó£ºÒ»¸ö»áÒéͶ¸åϵͳ£¬ÔÚ×÷ÕßÌá½»ÂÛÎÄժҪʱ×Ô¶¯Ïò×÷Õß·¢ËÍÒ»·âÈ·ÈÏÓʼþ¡£
(×¢£ºÍ¶¸åϵͳʹÓõÄÊÇmyreview
)
×Ðϸ¿¼ÂÇһϣ¬Õâ¸öÈÎÎñ¿ÉÒÔÓÐÒÔϼ¸ÖÖ·½Ê½Íê³É£º
ÔÚ·þÎñÆ÷ÉÏÅäÖÃsendmail·þÎñ£¬Ê¹ÓÃphpÖеĵÄmailº¯Êý·¢ËÍÓʼþ£»
ÔÚ·þÎñÆ÷Éϰ²×°mutt + msmtp£¬»òÕßÔÚ·þÎñÆ÷Éϰ²×°ÆäËüµÄsmtp¿Í»§¶Ë³ÌÐò£¬Ê¹ÓÃsmtp¿Í» ......
ÔËÐл·¾³£ºwindows xp sp2
IIS v5.1
PHP 5.3.1-Win32-VC9-x86
Mysql 5.0
°²×°²½Ö裺
°²×°IIS5.1
ÔÚ ......
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 ......