且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

PHP从MySQL数据库中获取数据

更新时间:2023-01-31 09:37:14

您可以通过一个查询获取项目:

You can get your projects with one query:

$user = mysql_real_escape_string($_SESSION['user']);

$query = mysql_query("SELECT pu.projects_ID FROM users u 
           INNER JOIN projects_users pu ON (pu.users_ID = u.users_id)    
           WHERE u.user='$user'") or die(mysql_error());

$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
  echo $row['projects_ID'];
}