<?php session_start(); $conn=mysql_connect("localhost","root",""); mysql_select_db("lanjing",$conn); mysql_query("select * from member where t_member=$_SESSION['username']");if($_SESSION['username']==1) { $filename=$_POST['yinchang']; $sql="update member set * 't_member'='".$_POST['username']."' and 'name'='"$filename"'"; mysql_quarry($sql); } else { $filename=$_POST['yinchang']; $sql="insert into member * values('".$_POST['username']."','{$filename}')"; mysql_quarry($sql); } ?> 这个代码哪里有错误??谢谢
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in D:\wamp\www\lanjing\shangchuanchenggong.php on line 15
$sql="update member set * 't_member'='".$_POST['username']."' and 'name'='"$filename"'"; //↓ $sql = "UPDATE member SET `t_member` = '".$_POST['username']."' NAD `name` = '{$filename}'";
还是有同样的错误提示,,,,5555mysql_query("select * from member where t_member=$_SESSION['username']"); 我的15行是这一行,,,,
mysql_query("select * from member where t_member='$_SESSION['username']'");
mysql_query("select * from member where t_member=".$_SESSION['username']);
mysql_query("select * from `member` where t_member='".$_SESSION['username']。"'");
$result=mysql_query("select * from member where t_member=".$_SESSION['username']); if(mysql_num_rows($result)>0) echo '有这个ID'; else echo '没有这个ID';
<?php session_start(); $conn=mysql_connect("localhost","root",""); mysql_select_db("lanjing",$conn); mysql_query("select * from member where t_member=".$_SESSION['username']);$result=mysql_query("select * from member where t_member=".$_SESSION['username']); if(mysql_num_rows($result)>0) { $filename=$_POST['yinchang']; $sql = "UPDATE member SET 't_member' = '".$_SESSION['username']."' AND 'name' = '{$filename}'"; mysql_query($sql); } else { $filename=$_POST['yinchang']; $sql2="insert into member values('".$_SESSION['username']."','','{$filename}','')";echo $sql2;echo $sql2; mysql_query($sql2); } ?>可以这样写吗??就是说有这个用户ID 的话更新,没有的话插入
可以这么写,但是SQL语句肯定有问题,‘’里再加个‘’要用的转义字符\
在问一个问题,, php从数据库中查找用户名之后显示那个用户的信息,应该要怎么做??谢谢。
$result=mysql_query("select * from member where t_member=".$_SESSION['username']); $row=mysql_fetch_assoc($result); foreach($row as $v){ echo $v.'<br>'; }
foreach($row as $v){ echo $v.'<br>'; }这是什么意思??有没有简单的??谢谢
$result=mysql_query("select * from member where t_member=".$_SESSION['username']);$result=mysql_fetch_assoc($result);echo $result['username'];//用户名 echo $result['age'];//岁数 echo $result['ip'];//..........自己根据自己数据库的内容去排吧.freach 循环列出取得的数据集内容
$result=mysql_query("select * from member where t_member=".$_SESSION['username']); while($row=mysql_fetch_assoc($result)){ echo $row.'<br>'; }
就
session_start();
$userId = $_SESSION['xx'];
isset($_SESSION['xx']);
session_start();
$conn=mysql_connect("localhost","root","");
mysql_select_db("lanjing",$conn);
mysql_query("select * from member where t_member=$_SESSION['username']");if($_SESSION['username']==1)
{
$filename=$_POST['yinchang'];
$sql="update member set * 't_member'='".$_POST['username']."' and 'name'='"$filename"'";
mysql_quarry($sql);
}
else
{
$filename=$_POST['yinchang'];
$sql="insert into member * values('".$_POST['username']."','{$filename}')";
mysql_quarry($sql);
}
?>
这个代码哪里有错误??谢谢
//↓
$sql = "UPDATE member SET `t_member` = '".$_POST['username']."' NAD `name` = '{$filename}'";
我的15行是这一行,,,,
if(mysql_num_rows($result)>0)
echo '有这个ID';
else
echo '没有这个ID';
session_start();
$conn=mysql_connect("localhost","root","");
mysql_select_db("lanjing",$conn);
mysql_query("select * from member where t_member=".$_SESSION['username']);$result=mysql_query("select * from member where t_member=".$_SESSION['username']);
if(mysql_num_rows($result)>0)
{
$filename=$_POST['yinchang'];
$sql = "UPDATE member SET 't_member' = '".$_SESSION['username']."' AND 'name' = '{$filename}'";
mysql_query($sql);
}
else
{
$filename=$_POST['yinchang'];
$sql2="insert into member values('".$_SESSION['username']."','','{$filename}','')";echo $sql2;echo $sql2;
mysql_query($sql2);
}
?>可以这样写吗??就是说有这个用户ID 的话更新,没有的话插入
php从数据库中查找用户名之后显示那个用户的信息,应该要怎么做??谢谢。
$result=mysql_query("select * from member where t_member=".$_SESSION['username']);
$row=mysql_fetch_assoc($result);
foreach($row as $v){
echo $v.'<br>';
}
echo $v.'<br>';
}这是什么意思??有没有简单的??谢谢
$result=mysql_query("select * from member where t_member=".$_SESSION['username']);$result=mysql_fetch_assoc($result);echo $result['username'];//用户名
echo $result['age'];//岁数
echo $result['ip'];//..........自己根据自己数据库的内容去排吧.freach 循环列出取得的数据集内容
while($row=mysql_fetch_assoc($result)){
echo $row.'<br>';
}