首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何使它更新两个表,而不是只更新“帐户”?

问如何使它更新两个表,而不是只更新“帐户”?
EN

Stack Overflow用户
提问于 2015-06-08 07:17:57
回答 1查看 33关注 0票数 0

我要把它发送到两个表,而不仅仅是accounts,我希望它在accounts和groups中使用

代码语言:javascript
复制
<?php

session_start();

if(isset($_POST["submit"])){


if (!(isset($_SESSION['sess_user']) || $_SESSION['sess_user'] == '')) {
header("location:index.php");
}

$dbcon = mysqli_connect('host.com', 'db', 'pass', 'db') or die(mysqli_error($dbcon));

$newname = mysqli_real_escape_string($dbcon, $_POST['newname']);
$newname2 = mysqli_real_escape_string($dbcon, $_POST['newname2']);
$username = mysqli_real_escape_string($dbcon, $_SESSION['sess_user']);

if ($newname <> $newname2) { echo "Your fraternity names do not match.";}

如何使它更新两个表而不是只更新帐户?

代码语言:javascript
复制
else if ((mysqli_query($dbcon, "UPDATE `accounts` 
                  SET `groupname`='".$newname."', 
                      `founder` ='".$username."' 
                  WHERE `username` = '".$username."'")))

{ 

echo "Your fraternity has been created. You will now be logged out.";

echo "<META http-equiv='refresh' content='3;URL=logout.php'>";

}

else { mysqli_error($dbcon); }

mysqli_close($dbcon);
}
?>
EN

回答 1

Stack Overflow用户

发布于 2015-06-08 08:30:56

尝尝这个,

代码语言:javascript
复制
$group = mysqli_query($dbconn,"select * from group where founder =".$username);
foreach($group as $row)
if(empty($row['founder']))
{
   echo "You arent in any fraternity. Would you like to <a href='begin'>join one</a>?";  
}else{
   echo "You are in.."
}
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/30703195

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档