php ±íµ¥ mysql ÖÐÎÄ×Ö·û - PHP / »ù´¡±à³Ì
ÎÒÔÚ±íµ¥ÖÐÊäÈ룺×Öĸ£¬Êý×Ö£¬¿Õ¸ñ£¬¶¼¿ÉÒÔ²åÈëµ½mysqlÖÐ
µ«ÊÇÎÒÊäÈëÖÐÎÄʱ£¬¾ÍËÀ»î²å²»½øÊý¾Ý¿â
ÒòΪÓÃget·½Ê½°ÑÖÐÎͼ±àÒë³ÉÁËÒ»´®×Ö·û´®£¬ÆäËû·½Ê½µÄÊäÈëµÄ¶¼ÊÇûÓбäµÄ
¹À¼ÆÊÇ´«ÖµµÄÎÊÌ⣬µ«ÊDz»ÖªµÀÔõô½â¾ö
´úÂëÈçÏ£º
PHP code:
<!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">
</head>
<body>
<form action="index.php" accept-charset="gb2312" method="GET">
ÐÕÃû£º<input type="text" name="username" />
ÃÜÂ룺<input type="text" name="password" />
<input type="submit" value="Ìá½»" />
</form>
<?php
echo $_GET[username];
echo '<br />' . $_GET[password];
?>
<?php
$con=mysql_connect("localhost","root","admin");
if($con)
echo "Á¬½Ó³É¹¦";
$sql="insert into phpdemo.user(username,password) values('$_GET[username]','$_GET[password]')";
echo $sql;
mysql_select_db("phpdemo",$con);
echo 'test';
if(mysql_query($sql))
echo '²åÈëÊý¾Ý¿â³É
Ïà¹ØÎÊ´ð£º
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ãæ»º´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......