PHP MYSQLi upgrading a WHERE OR to a WHERE IN()

My knowledge with MYSQLi is online training courses stack overflow and Google. I have been weeks trying to figure how to do the upgrade.

Every webpage that tells me this is how to do it. I copy and paste the code into Dreamweaver then I change the table name and change the array data to what is in the "members_pool_1" table and change everything else that needs to be changed. I run the code and I get errors every time.

Down below is everything I think you need to know to help me out. "members_pool_1" table shows you the 7 columns to make this work. PHP 1 code is the working code using "WHERE OR".

PHP 2 code is the code that will be added to combined a "WHERE IN() and WHERE OR". The session is coming from a form just filled out. The "$players_eliminated_now" is the number of players being eliminated. The "$players_eliminated_now" number will change every entry. The "$players_id[$count]" is the players ID number.

I believe my lack of knowledge in MYSQLi be a mistake for me to write down code to make this work. Number of issues I be having I believe that you will be running away.

If you wish to write down the code to make this work, I thank you. I believe with the database table and PHP 1 code and 2 you have everything you need to make everything work.

members_pool_1 table. I shortened the column names so it will fit everything and when row

member	player1	player2	player3	player4	player5	player6
1	20	8	12	15	10	19
2	7	8	11	1	19	10
3	1	13	20	15	19	7

PHP 1 code

<?php    session_start();  $players_eliminated_now=$_SESSION["players_eliminated_now"];  for($count = 1;$count<=$players_eliminated_now;++$count){          $players_id[$count]=$_SESSION["players_id"][$count];          $first_name[$count]=$_SESSION["first_name"][$count];          $last_name[$count]=$_SESSION["last_name"][$count];  }    $con=mysqli_connect(db_host,db_user,db_pass,db_survivor);  mysqli_set_charset($con,"utf8");    $sql="SELECT * FROM members_pool_1 WHERE player1_id = ? OR player2_id = ? OR player3_id = ? OR player4_id = ? OR player5_id = ? OR player6_id = ?";    $stmt=mysqli_stmt_init($con);  mysqli_stmt_prepare($stmt,$sql);    mysqli_stmt_bind_param($stmt,'iiiiii',$players_id[$count],$players_id[$count],$players_id[$count],$players_id[$count],$players_id[$count],$players_id[$count]);    mysqli_stmt_execute($stmt);  $result=mysqli_stmt_get_result($stmt);    $membersCount=0;  while($row=mysqli_fetch_assoc($result)){          $member_id[++$members_count]=$row['member_id'];          $members_player1_id[$members_count]=$row['player1_id'];          $members_player1_percent[$members_count]=$row['player1_percent'];          $members_player2_id[$members_count]=$row['player2_id'];          $members_player2_percent[$members_count]=$row['player2_percent'];          $members_player3_id[$members_count]=$row['player3_id'];          $members_player3_percent[$members_count]=$row['player3_percent'];          $members_player4_id[$members_count]=$row['player4_id'];          $members_player4_percent[$members_count]=$row['player4_percent'];          $members_player5_id[$members_count]=$row['player5_id'];          $members_player5_percent[$members_count]=$row['player5_percent'];          $members_player6_id[$members_count]=$row['player6_id'];          $members_player6_percent[$members_count]=$row['player6_percent'];          $total_percent[$members_count]=$row['total_percent'];  }    mysqli_free_result($result);      mysqli_stmt_close($stmt);  ?>  

PHP 2 code

<?php    session_start();  $players_eliminated_now=$_SESSION["players_eliminated_now"];  for($count = 1;$count<=$players_eliminated_now;++$count){      $players_id[$count]=$_SESSION["players_id"][$count];      $first_name[$count]=$_SESSION["first_name"][$count];      $last_name[$count]=$_SESSION["last_name"][$count];  }  ?>  

https://stackoverflow.com/questions/66450952/php-mysqli-upgrading-a-where-or-to-a-where-in March 03, 2021 at 12:46PM