php - How to select values where another value is an array? -
i'm trying select values post values array, not know wrong query giving me error. i'm trying know courses added table. have 5 inputs in form.
notice: trying property of non-object in c:\apache\htdocs\xxx\addcourse.php on line 262 here code
  <?php      if(isset($_post['submit'])) {        $code= isset($_post['code']) ? $_post['code'] : '';       $coursecode = isset($_post['coursecode']) ? $_post['coursecode'] : '';       $both=$code[$x] .' '. $coursecode[$x];        $sqlcourses = "select * courses course_code='$both' order course_id desc limit 5 ";       $resultcourses = $mysqli->query($sqlcourses);           if ($resultcourses->num_rows > 0) {               while($row = $resultcourses->fetch_assoc()) {                  ?>                 </p>                 <p> </p>                 <p>   </p>                 <table width="415" border="0">                 <tr>                 <?php                 $courses=$row["course_code"];                 echo $courses;                 ?>                     </div>                 </tr>                   </table>               <?php              }         }     } ?> 
first, build array of course codes want retrieve; i'm leaving off boundary checks simplicity:
$codes = []; foreach ($_post['code'] $k => $code) {     $codes[] = $code . ' ' . $_post['coursecode'][$k]; } then, prepare statement use:
$stmt = $mysqli->prepare("select *    courses    course_code = ?   order course_id desc    limit 5"); followed main loop:
foreach ($codes $code) {     $stmt->bind_param('s', $code);     assert($stmt->execute());      $res = $stmt->get_result();     while ($row = $res->fetch_assoc()) {       // ...     } }