How to use array data into query to get another data in PHP

Question

So here is my PHP code:

$checkProject1Column = "SELECT * FROM tbl_studentchoice WHERE Project1 = '1'";
$resultProject1Column = mysqli_query($conn, $checkProject1Column);       
    while($row = mysqli_fetch_assoc($resultProject1Column)) {
            //Create an array of students
            $array[] = ['studentid' => $row['studentid']];
    }  
    //check marks database
    $checkmarks = "SELECT studentid,marks FROM tbl_marks";
    $checkResult = mysqli_query($conn, $checkmarks);
    if ($checkResult->num_rows >= 0){
        while($row1 = mysqli_fetch_assoc($checkResult)){
            //Create an array of students
            $array1[] = [
                'marks' => $row1['marks'],
                'studentid' => $row1['studentid']
                ];
            }
        print_r($array);
        print_r($array1);

So I have 2 database tables. tbl_studentchoice and tbl_marks. I created an array of students with a value 1 on Project1 column. This is how my tbl_studentchoice looks like:

.

So now that I have an array of studentid's. I want to get the marks of these students from another table (tbl_marks) which looks like this:

and create a new array with only studentid with Project1 value 1 and their marks. So basically I want to create an array like this:

Array ( 
    [0] => Array ( 
        [studentid] => c12558111 
        [marks] => 50
    ) 
    [1] => Array ( 
        [studentid] => c12558112 
        [marks] => 60
    ) 
)

Is there a reason for the duplicate $resultProject1Column = mysqli_query($conn, $checkProject1Column); ? — Amous
– Amous, Commented May 1, 2016 at 16:53

Arjun Bala · Accepted Answer · 2016-05-01 17:37:39Z

4

Why are you using two diffrent query?? you should join tables only write one query like this

select s.*,m.marks
  from tbl_studentchoice s, tbl_marks m
  where s.studentid = m.studentid
   and  Project1 = '1'

Complete Code

$query= "select s.*,m.marks
  from tbl_studentchoice s, tbl_marks m
  where s.studentid = m.studentid
   and  Project1 = '1'";
$result= mysqli_query($conn, $query);       
while($row = mysqli_fetch_assoc($result)) {

  echo("<br/>Student ID = ".$row['studentid']);
  echo("<br/>Student marks = ".$row['marks']);
}

edited May 1, 2016 at 17:37

answered May 1, 2016 at 17:04

Arjun Bala

2871 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anthony Galpo Over a year ago

Thank you very much. I still do not have enough experience on PHP so I didn't know you could do a query like that. Can you explain the query to me I do not fully understand it. I have done and created the array and its good. I just want to understand that query a bit more.

Arjun Bala Over a year ago

It is like a inner join which joins two table with some condition, in your problem there were two table with one common column which is studentid so this query will merge data of two table whose studentid is same

Collectives™ on Stack Overflow

How to use array data into query to get another data in PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related