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 '²åÈëÊý¾Ý¿â³É
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
²ËÄñÇó¾È£¡£¡
ÏÖÔÚÎÒÊÖÍ·ÓÐÒ»¸öphp+oracleµÄÍøÕ¾¡£¡£·þÎñÆ÷ÊÇlinuxϵͳ
Çë¸÷λ¸æËßÎÒÈçºÎ·¢²¼¡£¡£¡£ÎÒÊÇÐÂÊÖ¡£Ð»Ð»ÁË£¡£¡
°²×°Ò»¸öapache£¬°ÑphpÎļþ·Åµ½apacheµÄ·¢²¼Ä¿Â¼Ï£¬ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
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)ÖеÄÊý¾ ......