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
Ïà¹ØÎĵµ£º
¿ªÊ¼Ö®Ç°£¬Ê×ÏÈÒª³ÎÇåÁ½¸öÎÊÌ⣺µÚÒ»£¬Ö§³Ö¿ªÔ´£¬²»µÈÓÚ·´¶Ô´úÂë¼ÓÃÜ£»µÚ¶þ£¬Èç¹û°Ñ²»ÊôÓÚ×Ô¼ºµÄ¶«Î÷£¨±ÈÈ繫˾µÄ£©ÄÃÈ¥¿ªÔ´£¬¾Í¸ü¼Ó²»Ó¦¸ÃÁË¡£
ÒÔǰ֪µÀµÄ£¬PHP´úÂëµÄ¼ÓÃܶ¼ÊÇÓÃZendµÄencoder£¬Õâ¶«Î÷²»µ«ÊÇÉÌÒµÈí¼þ£¬ºÃÏñ»¹±©³ö¹ýÄܹ»±»ÆÆ½âµÄÎÊÌ⣬ËùÒÔ¾ÍÕÒµ½ÁËÌæ´úµÄ·½°¸©¤©¤©¤©¤php_screw£¬Ò»¸öÈÕ±¾ÈË¿ª·¢µÄ¶«¶«¡£
p ......
1£®Ç°ÑÔ
PHP £¨´Ó PHP 3.05
¿ªÊ¼£©Îª±£´æ¶ÔÏóÌṩÁËÒ»×éÐòÁл¯ºÍ·´ÐòÁл¯µÄº¯Êý£ºserialize¡¢unserialize¡£²»¹ýÔÚ PHP
ÊÖ²áÖжÔÕâÁ½¸öº¯ÊýµÄ˵Ã÷½öÏÞÓÚÈçºÎʹÓ㬶ø¶ÔÐòÁл¯½á¹ûµÄ¸ñʽȴû×öÈκÎ˵Ã÷¡£Òò´Ë£¬Õâ¶ÔÔÚÆäËûÓïÑÔÖÐʵÏÖ PHP
·½Ê½µÄÐòÁл¯À´Ëµ£¬¾Í±È½ÏÂé·³ÁË¡£ËäÈ»ÒÔǰҲËѼ¯ÁËһЩÆäËûÓïÑÔʵÏÖµÄ PHP ÐòÁл¯µ ......
require() Óë require_once()
ͨ³£·ÅÔÚ PHP ³ÌÐòµÄ×îÇ°Ãæ£¬PHP ³ÌÐòÔÚÖ´ÐÐǰ£¬¾Í»áÏȶÁÈë require
ËùÖ¸¶¨ÒýÈëµÄÎļþ£¬Èç¹û³öÏÖ´íÎóÊÇÖÂÃüµÄ¡£
nclude() Óë include_once()
&n ......
mysql ´´½¨±í£º
mysql> create table user(
-> userid int(4) primary key not null auto_increment,
-> username varchar(16) not null,
-> userpassword varchar(32) not null
-> );
create table log(
logid int(4) ......
Ò»£ºasp.netÔõôÁ¬½ÓmysqlÊý¾Ý¿â
ÏÂÔØmysql connectionµÄ¶«Î÷
http://dev.mysql.com/downloads/connector/net/6.2.html
ÓÐ3¸ödownloadÑ¡µÚÒ»¸öÏÂÔØ
Windows (x86, 32-bit), ZIP Archive
mysql-connector-net-6.2.2-noinstall.zip ......