php - 显示表中的信息，然后显示另一个表中的相关信息

Question

您好，我有 2 张 table 。

其中一个是包含联系信息(帐户、姓名、电子邮件、地址、城市、州、邮政编码、标签)的表 (nameinfo)

表二是事件表(events)(email, event_type, event_name, date, keywords)

这就是我正在尝试做的事情......

我想根据匹配的电子邮件地址显示此人参加的所有事件的列表。我想返回这样的结果...

姓名信息人员 1
事件人员 1 去过

姓名信息人员 2
2号人参加的事件

姓名信息人员 3
3号人参加的事件

     $query =  mysql_query("SELECT * FROM nameinfo WHERE account='$a'");

     while($row = mysql_fetch_array($query))


    { 
     $i++;

        echo "<div>";
        echo "<table><tr style='font-weight:bold;color:green;font-size:9pt;text-align:left;'><td  style='text-align:left;'
        >";
       echo "<button class='toggles' id='".$i."'/>"; echo $row['fullname']."</button>";
        echo "</td>";
        echo "<td  >";
        echo $row['target'];
        echo "</td><td >";
        echo $row['lname'];
        echo "</td>";
        echo "<td >";
        echo $row['fname'];
        echo "</td><td >";
        echo $row['title'];
        echo "</td>";
        echo "<td >";
        echo $row['company'];
        echo "</td><td >";
        echo $row['address'];
        echo "</td>";
        echo "<td >";
        echo $row['address2'];
        echo "</td><td>";
        echo $row['city'];
        echo "</td>";
        echo "<td>";
        echo $row['state'];
        echo "</td><td>";
        echo $row['zip'];
        echo "</td>";
          echo "<td>";
        echo $row['email'];
        echo "</td><td>";
        echo $row['officenum'];
        echo "</td>";
          echo "<td>";
        echo $row['cellnum'];
        echo "</td>";
          echo "<td>";
        echo $row['date'];
        echo "</td><td>";
        echo $row['rep'];
        echo "</td></tr></table></div>";
        echo "<div style='width:100%;background:#000;color:#fff;display:none;' id='show-".$i."'>";
        **echo THIS IS WHERE I WOULD LIKE TO PUT THE EVENT INFORMATION BUT HAVE NO IDEA HOW TO DO IT.;**
        echo "</div>";
    }    

<script>
$("button.toggles").click(function() {
       var value = $(this).attr('id');
       $("#show-" + value).toggle();
}); 
</script>

感谢您的帮助。

Answer 1

在循环内运行另一个查询。这里我调用一个函数来完成这项工作:

$i=0;
$link = ""\\your database connection
$query =  mysql_query("SELECT * FROM nameinfo WHERE account='$a'");
while($row = mysql_fetch_array($query)){ 
    $i++;

    echo "<div>";
    echo "<table><tr style='font-weight:bold;color:green;font-size:9pt;text-align:left;'><td  style='text-align:left;'>";
    echo "<button class='toggles' id='".$i."'/>"; echo $row['fullname']."</button>";
    echo "</td>";
    echo "<td  >";
    echo $row['target'];
    echo "</td><td >";
    echo $row['lname'];
    echo "</td>";
    echo "<td >";
    echo $row['fname'];
    echo "</td><td >";
    echo $row['title'];
    echo "</td>";
    echo "<td >";
    echo $row['company'];
    echo "</td><td >";
    echo $row['address'];
    echo "</td>";
    echo "<td >";
    echo $row['address2'];
    echo "</td><td>";
    echo $row['city'];
    echo "</td>";
    echo "<td>";
    echo $row['state'];
    echo "</td><td>";
    echo $row['zip'];
    echo "</td>";
      echo "<td>";
    echo $row['email'];
    echo "</td><td>";
    echo $row['officenum'];
    echo "</td>";
      echo "<td>";
    echo $row['cellnum'];
    echo "</td>";
      echo "<td>";
    echo $row['date'];
    echo "</td><td>";
    echo $row['rep'];
    echo "</td></tr></table></div>";
    echo "<div style='width:100%;background:#000;color:#fff;display:none;' id='show-".$i."'>";
        getEvent($row['email']);//Pass the email to the function here
    echo "</div>";
}    

function getEvent($email){  
    global $link;       
    $evant = "";
    $query =  mysql_query("SELECT * FROM events WHERE email='$email'", $link);
    while($row = mysql_fetch_array($query)){    
        $event = $event . $row["event_name"] . "<br />";
        //Format this however you wish to format
    }   
    return $event;
}

<script>
$("button.toggles").click(function() {
       var value = $(this).attr('id');
       $("#show-" + value).toggle();
}); 
</script>