¡¾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
µÄÀ©Õ¹¡£ÔÒò¿ÉÄÜÓÐÒÔÏÂÁ½µã£ºÒ»ÊÇÕâ¸öÀ©Õ¹ÐèÒªÔÚ·þÎñÆ÷ÉÏ´ò¿ª£¬Èç¹ûûÓзþÎñÆ÷² ......
Allowed memory size of 33554432 bytes exhausted (tried to allocate 4554 bytes)
ÓÐʱºòÎÒÃÇÔÚÔËÐÐphp³ÌÐòµÄʱºò»á·¢ÏÖ Fatal Error: Out of memory ÕâÑùµÄÌáʾ¡£ ÕâÓпÉÄÜÊdzÌÐòÖÐÓõ½ÁË´óÁ¿Á˱äÁ¿ºÍ¶ÔÏ󣬵¼Ö·ÖÅäµÄÄÚ´æ²»¹»Óá£ÎÒ¾ÍÓöµ½ÕâÑùÒ»¸ö´íÎóÔõô¸ÄÒ²¸Ä²»ÁË£¬ºóÀ´ÉÏÍø²éÁËһР......
ÈÎÎñÐèÇó£ºÒ»¸ö»áÒéͶ¸åϵͳ£¬ÔÚ×÷ÕßÌá½»ÂÛÎÄժҪʱ×Ô¶¯Ïò×÷Õß·¢ËÍÒ»·âÈ·ÈÏÓʼþ¡£
(×¢£ºÍ¶¸åϵͳʹÓõÄÊÇmyreview
)
×Ðϸ¿¼ÂÇһϣ¬Õâ¸öÈÎÎñ¿ÉÒÔÓÐÒÔϼ¸ÖÖ·½Ê½Íê³É£º
ÔÚ·þÎñÆ÷ÉÏÅäÖÃsendmail·þÎñ£¬Ê¹ÓÃphpÖеĵÄmailº¯Êý·¢ËÍÓʼþ£»
ÔÚ·þÎñÆ÷Éϰ²×°mutt + msmtp£¬»òÕßÔÚ·þÎñÆ÷Éϰ²×°ÆäËüµÄsmtp¿Í»§¶Ë³ÌÐò£¬Ê¹ÓÃsmtp¿Í» ......
PHP³ÌÐòÔ±Ó¦¸Ã¶¼ÖªµÀÁ¬½ÓMySQLÊý¾Ý¿â¿ÉÒÔʹÓÃmysql_pconnect£¨ÓÀ¾ÃÁ¬½Ó£©º¯Êý£¬Ê¹ÓÃÊý¾Ý¿âÓÀ¾ÃÁ¬½Ó¿ÉÒÔÌá¸ßЧÂÊ£¬µ«ÊÇʵ¼ÊÓ¦ÓÃÖÐÊý¾Ý¿âÓÀ¾ÃÁ¬½ÓÍùÍù»áµ¼Ö³öÏÖһЩÎÊÌ⣬ͨ³£µÄ±íÏÖ¾ÍÊÇÔÚ´ó·ÃÎÊÁ¿µÄÍøÕ¾ÉÏʱ³£·¢Éú¶Ï¶ÏÐøÐøµÄÎÞ·¨Á¬½ÓÊý¾Ý¿âµÄÇé¿ö£¬³öÏÖÀàËÆ£¢Too many connections in ...£¢µÄ´íÎóÌáʾÐÅÏ¢£¬ÖØÐÂÆô¶¯·þÎñÆ÷Ó ......
<html>
<head>
<title>¼ÆËã±¾ÖÜ¿ªÊ¼½áÊøÈÕÆÚ</title>
</head>
<body>
<form method="post" action="./index.html" enctype="utf-8">
<table>
<tr><td>ÊäÈëÄê·Ý</td><td><input name="year" type="text" maxlength="4" /></td> ......