$dbhost = 'localhost';
$dbuser = 'tukecn';
$dbpass = 'tukecn';
$dbname = 'discuz';
$connect = mysql_connect($dbhost,$dbuser,$dbpass)or die("无法连接MySQL数据库服务器!");
$sql = "insert into cash_exchange(user_id,cost,director,createtime) values('$_COOKIE[_tk_uid]','$cost','$checkcode','now()')";//生成查询记录数的SQL语句
$res=mysql_query($sql);
$update="update cdb_members set amount=amount+$cost where uid='user_id'";
$rre=mysql_query($update);
if ($connect) {
echo "Success...";
}
else {
echo "Connecting...";
}
请大侠们指点迷津.我上面哪里写错了.是不是连接字符串也错了啊
$dbuser = 'tukecn';
$dbpass = 'tukecn';
$dbname = 'discuz';
$connect = mysql_connect($dbhost,$dbuser,$dbpass)or die("无法连接MySQL数据库服务器!");
$sql = "insert into cash_exchange(user_id,cost,director,createtime) values('$_COOKIE[_tk_uid]','$cost','$checkcode','now()')";//生成查询记录数的SQL语句
$res=mysql_query($sql);
$update="update cdb_members set amount=amount+$cost where uid='user_id'";
$rre=mysql_query($update);
if ($connect) {
echo "Success...";
}
else {
echo "Connecting...";
}
请大侠们指点迷津.我上面哪里写错了.是不是连接字符串也错了啊
$res=mysql_query($sql);
$update="update cdb_members set amount=amount+'$cost' where uid='user_id'";
$rre=mysql_query($update);
给你一个例子,自己比对一下吧<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf ("ID: %s Name: %s", $row["id"], $row["name"]);
} mysql_free_result($result);
?>