ÈçºÎÓÃphpÓï¾ä´ÓmysqlÖÐÌáÈ¡Êý¾Ý
ÔÚmysql£¬Ò»¸öÊý¾Ý¿âÖУ¬ÓÐÒ»¸ö´æ´¢Õ˺źÍÃÜÂëµÄ±íµ¥£»
ÔÚphpÖУ¬ÔõôÌá³öÕ˺źÍÃÜÂ룿£¿£¿
ÊÇÓÃÔڵǽ½çÃæ£¬ÑéÖ¤Õ˺ÅÃÜÂëÊÇ·ñ´íÎó¡£
$name='';//¼Ç¼ÄãµÄ»ñµÃµÄµÇ¼Óû§Ãû
$password='';//¼Ç¼Äã»ñµÃµÄµÇ¼ÃÜÂë
$sql="select * from Êý¾Ý¿â±í where Õ˺Å='$name' and ÃÜÂë='$password'";
$rt=mysql_query($sql);
if(mysql_num_rows($rt)!=0){
echo "µÇ½³É¹¦";
......
}else{
echo "µÇ½ʧ°Ü";
......
}
$name='';//¼Ç¼ÄãµÄ»ñµÃµÄµÇ¼Óû§Ãû
$password='';//¼Ç¼Äã»ñµÃµÄµÇ¼ÃÜÂë
$db=mysql_query('127.0.0.1£º3306','Óû§Ãû','ÃÜÂë');
if($db){
mysql_query('use Êý¾Ý¿âÃû');
mysql_query('set names utf8');
$sql="select * from Êý¾Ý¿â±í where Õ˺Å='$name' and ÃÜÂë='$password'";
$rt=mysql_query($sql);
if(mysql_num_rows($rt)!=0){
echo "µÇ½³É¹¦";
......
}else{
echo "µÇ½ʧ°Ü";
......
}
}else{$error=mysql_error();
echo $error;}
лл¹þ
¶¥
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
<!--¹ºÂòÊýÁ¿-->
<div class='buyinfo'>
<table width='auto'>
<tr>
<td><span>¹ºÂòÊýÁ¿£º</sp ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......