Improve translation Get query for multiple results

Title

The description of the question

I am creating with php and mysql a query to a table with the same user id there are multiple product id. I have already achieved that does not show me the product id is repeated, but not how to get the results if it is not using an array. I've done this:

$sql2=$db->prepare('SELECT id_user,id_product FROM contracts WHERE id_user=:id_user GROUP BY id_product');
    $sql2->execute(array(
            ':id_user'=>$id_user
    ));
    $id_product=$sql2->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP);
    foreach($id_product[2] as $value){
            $valueInt=(int)$value;
            $array=array_map('intval',str_split($valueInt));//=>array=[1,3]
    }

Below, I call the id_product specific as well:

if($array[0]==1){
        $id_product==1;
        echo "<p>Cuenta corriente Básica:</p>";
        echo "<a href='products/cuentas/cuenta_corriente.php?id_product=".$array[0]."'>Ir a mi cuenta básica</a>";
    }

And as well two other times, either the id_product 2 or 3:

if($array[0]==2){

if($array[0]==3){

This way only I got that I show in the case of 3, that is to say, the last.

Question tags

Improve translation - Get query for multiple results

Top Tags

HolaDevs.com

Powered by: