how to use Arraylist in sql query?

Question

I want product details from product table. so i get productid from tbl_product_color and now i want product's all detail which are stored in tbl_product table from product_id and in array $data product_id is stored but my below code is not working : one more problem is here that everytime this page refresh color_id =0 is stored in tbl_user_color which i really dont want to store and even there there is no record with color_id =0 in tbl_color.

    $query="select * from tbl_user_color where color_session_id='".$sid."'";
    //echo $query;

    $resultset=mysql_query($query);
    $query="SELECT DISTINCT (product_id) FROM tbl_product_color";

    $cnt=0;

    while($row=mysql_fetch_assoc($resultset))
    {
        extract($row);
        if($cnt==0)
        {
            $query=$query." where color_id=".$color_id."";
        }
        else
        {
            $query=$query." or color_id=".$color_id."";
        }
        $cnt++;
            //  echo $color_id."<br>";
    }

     //echo $query;

    $resultset=mysql_query($query);

    echo "<div id='productdiv'>";
    $data = array();
    while($row=mysql_fetch_assoc($resultset))
    {

        $data[]=$row;
    }
    echo "<pre>";
    print_r($data); /* here i get an array with product_id list */
    echo "</pre>";
    echo "</div>";
    echo "<br>";
    echo "<br>";

    //$idStr = implode(',', $data); 
    /* here i want product details using $data array */
    $sql = "SELECT * FROM tbl_product WHERE product_id =".$data;
    $res=mysql_query($query);
    while($r=mysql_fetch_assoc($res))
    {
            extract($r);
        echo "   ".$product_name;
    }

    ?>

Zoe - Save the data dump · Accepted Answer · 2019-05-25 13:59:23Z

1

Use IN clause,

"SELECT * FROM tbl_product WHERE product_id IN (" . implode(",",$data). ")";

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25, 2019 at 13:59

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Feb 7, 2014 at 7:24

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

Collectives™ on Stack Overflow

how to use Arraylist in sql query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related