Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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(" ", "&nbsp;", $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_screw¼ÓÃÜPHP´úÂë

¿ªÊ¼Ö®Ç°£¬Ê×ÏÈÒª³ÎÇåÁ½¸öÎÊÌ⣺µÚÒ»£¬Ö§³Ö¿ªÔ´£¬²»µÈÓÚ·´¶Ô´úÂë¼ÓÃÜ£»µÚ¶þ£¬Èç¹û°Ñ²»ÊôÓÚ×Ô¼ºµÄ¶«Î÷£¨±ÈÈ繫˾µÄ£©ÄÃÈ¥¿ªÔ´£¬¾Í¸ü¼Ó²»Ó¦¸ÃÁË¡£
ÒÔǰ֪µÀµÄ£¬PHP´úÂëµÄ¼ÓÃܶ¼ÊÇÓÃZendµÄencoder£¬Õâ¶«Î÷²»µ«ÊÇÉÌÒµÈí¼þ£¬ºÃÏñ»¹±©³ö¹ýÄܹ»±»ÆÆ½âµÄÎÊÌ⣬ËùÒÔ¾ÍÕÒµ½ÁËÌæ´úµÄ·½°¸©¤©¤©¤©¤php_screw£¬Ò»¸öÈÕ±¾ÈË¿ª·¢µÄ¶«¶«¡£
p ......

MYSQL ʼþµ÷¶ÈµÄÀý×Ó

1.SET GLOBAL event_scheduler = ON;
2.show processlist;
3.´´½¨Ò»¸ö±í test Ö÷Òª×Ö¶Î no,name,sex,age
4.¶Ô¸Ã±í²åÈ缸ÌõÊý¾Ý
5.´´½¨´æ´¢¹ý³Ìadd_age
drop procedure if exists add_age;
delimiter|
create procedure add_age()
begin
  start transaction;
  update eventtest set age = age +1;
&n ......

mysql ´´½¨±í²¢ÉèÖÃÖ÷¼ü×ÔÔö

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) ......

mysql Ë÷Òý

1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
    
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ