phpѧϰ±Ê¼Ç£¨12£©:PHP+MYSQLÁôÑ԰壨ÏÂ
1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
if (myform.user.value=="")
{
alert("ÇëÌîдÓû§");
myform.user.focus();
return false;
}
if (myform.title.value.length<5)
{
alert("±êÌâ²»ÄÜÉÙÓÚ5¸ö×Ö·û");
myform.title.focus();
……
}
2¡¢str_replaceÌæ»»º¯Êý
Ìæ»»µÄÖµ£¬±»Ìæ»»µÄÄÚÈÝ)£»
function htmtocode($content) {
$content = str_replace("\n", "<br>", str_replace(" ", " ", $content));
return $content;
}
3¡¢htmlspecialchars ¸ñʽ»¯html
Ö÷Òª¹¦ÄÜÊǽ«HTML¸ñʽ»¯£¬·ÀÖ¹ÔÚÊä³öhtmlʱ±»ä¯ÀÀÆ÷Ö´ÐÐ
htmlspecialchars(ËùÒª¸ñʽ»¯¶ÔÏó,¶¨Ò嵥˫ÒýºÅ,±àÂë)
4¡¢md5¼ÓÃܺ¯Êý
md5( ¼ÓÃܶÔÏó )
hearder.php:
<?php
/*
* Created on 2010-1-5
* Author :CHAUVET
* Function£º±»°üº¬ÔÚÆäËûÒ³ÃæµÄÍ·²¿Ò³Ã棬ÑÝʾinclude()
*/
function ReplaceSomeWords($words){
$words=str_replace("\n","<br/>",str_replace(" "," ",$words));
return $words;
}
?>
<a href="add.php" mce_href="add.php">Ìí¼ÓÒ³Ãæ</a>|<a href="list.php" mce_href="list.php">²é¿´Ò³Ãæ</a>|<a href="add.php" mce_href="add.php">µÇÂ½Ò³Ãæ</a><br/>
<hr/>
add.php:
<html>
<head>
<title>Ìí¼ÓÒ³Ãæ</title>
<style type="text/css">
body{font-size:12px;text-align:center;}
#capation{font-size:24px;font-famliy:"»ªÎÄÐÂκ";}
</style>
<script type="text/javascript">
function ClearInputWords(){
document.myForm[0].value="";
document.myForm[1].value="";
document.myForm[2].value="ÇëÔÚ´ËÊäÈëÄúµÄÁôÑÔ£¡";
}
function CheckInput(){
&nb
Ïà¹ØÎĵµ£º
ÔÎÄÁ´½Ó£ºhttp://www.williamlong.info/archives/1846.html
ÔÚWindows IIS
6.0ÏÂÅäÖÃPHP
£¬Í¨³£ÓÐCGI
¡¢ISAPI
ºÍFastCGI
ÈýÖÖÅäÖ÷½Ê½£¬ÕâÈýÖÖģʽ¶¼¿ÉÒÔÔÚIIS
6.0ϳɹ¦ÔËÐУ¬ÏÂÃæÎҾͽ²Ò»ÏÂÕâÈýÖÖ·½Ê½ÅäÖõÄÇø±ðºÍÐÔÄÜÉϵIJîÒì¡£
¡¡¡¡1¡¢CGI
£¨Í¨ÓÃÍø¹Ø½Ó¿Ú/Common Ga ......
Ò»¸ö¹«Ë¾¼òµ¥µÄÃæÊÔÌ⣺
1. ¼ò´ðÌâ
(1)һЩÏà¹ØLINUX·½ÃæµÄÖ¸Áî²Ù×÷eg: mkdir ´´½¨Ä¿Â¼ touch ´´½¨Îļþ¼ÐÒÔ¼°ÐÞ¸ÄȨÏÞchmodÖ®ÀàµÈµÈ
(2)¼òÊö²»Í¬°æ±¾µÄPHPÓÐÊ²Ã´Çø±ð,ÊÔ¾ÙÀý¼òÊö.
(3),¼òÊö½Ó¿Ú¼¼ÊõµÄºÃ´¦,ÊÔ¾ÙÀý¼òÊö.
(4)ÈçºÎʹÓÃÏÂÃæµÄÀà,²¢½âÊÍÏÂÃæÊ²Ã´Òâ˼?
class test{
function ......
´úÂëÈçÏÂ:
//Á´½ÓʱÉ趨
mysql_real_connect( ..., CLIENT_MULTI_STATEMENTS );
//»òÕß
//ÖÐ;ָ¶¨
mysql_set_server_option( mysql, MYSQL_OPTION_MULTI_STATEMENTS_ON ); //mysqlÊÇÁ¬½ÓµÄÃû³Æ
µ±Ê¹ÓÃÖ´ÐжàÓï¾ä¹¦Äܺó£¬Ò»¶¨Òª¶ÁÍêÕû¸öresault¼¯£¬·ñÔò»á³öÏÖ´íÎó£ºCommands out of sync; you can't run this co ......
½ØÈ¡province×Ö·û´®ÖеÚÒ»¸ö<br>ǰµÄ×Ö·û´®¡«£¡
update lcjd
set `province` = substring_index( `province` , '<br>', '1' );
ÔÚÐèÒªÌí¼Ó‘0’µÄλÖÃÌí¼ÓÒ»¸ö‘0’
update lcjd
set lc_name2 = concat('0', lc_name2)
WHERE length(lc_name2) = 3
http://www.sqlstudy.com/s ......
×¢½â·ûºÅ:
// µ¥ÐÐ×¢½â
/* */ ¶àÐÐ×¢½â
ÒýºÅµÄʹÓÃ
’ ’ µ ......