HELP: Recupérer l'id de l'image dans une fonction

Baba deCode · August 31, 2015

Bonjour,
je coince sur un problème si quelqu'un passe par la et qu'il a la gentillesse de m'aider:

J'ai une fonction qui a pour mission d’insérer des images dans le systeme de presta.
Pour l'insertion dans la table ps_image ca se passe bien, l'ID de l'image se genere automatiquement
La ou je galere c'est l'insertion dans la table ps_image_shop, il faut que fasse concorder l'id des image, j'ai donc ajouter cette petite astuce $id_image2=$id_image+1; ca marche mais si l'internaute choisi de selectionner un fichier une fois sur deux ca ne marche plus....

la page du formulaire: http://fr-fr.vente-flash.ninja/vendre-sur-vente-flash

Merci bcp

// Dans la table image on insere id produit, position et cover
if ($photo2up2 == 1)
       
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',2,NULL)';
            $result8=Db::getInstance()->ExecuteS($sql);
            }

if ($photo3up2 == 1)
       
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',3,NULL)';
            $result9=Db::getInstance()->ExecuteS($sql);
            }
if ($photo4up2 == 1)

            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',4,NULL)';
            $result10=Db::getInstance()->ExecuteS($sql);
            }
if ($photo5up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',5,NULL)';
            $result11=Db::getInstance()->ExecuteS($sql);
            }
if ($photo6up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',6,NULL)';
            $result12=Db::getInstance()->ExecuteS($sql);
            }
if ($photo7up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',7,NULL)';
            $result13=Db::getInstance()->ExecuteS($sql);
            }
if ($photo8up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',8,NULL)';
            $result14=Db::getInstance()->ExecuteS($sql);
            }
                       
// Dans la table image_shop on insere id produit, id_image, id_shop et cover          

if ($photo2up2 == 1)
            {
            $id_image2=$id_image+1;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image2.',1,NULL)';
            $result16=Db::getInstance()->ExecuteS($sql);
          
            }

           
if ($photo3up2 == 1)
       
            {

            $id_image3=$id_image+2;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image3.',1,NULL)';
            $result17=Db::getInstance()->ExecuteS($sql);
           
            }

if ($photo4up2 == 1)

            {
            $id_image4=$id_image+3;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image4.',1,NULL)';
            $result18=Db::getInstance()->ExecuteS($sql);
            
            }

if ($photo5up2 == 1)
            {
            $id_image5=$id_image+4;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image5.',1,NULL)';
            $result19=Db::getInstance()->ExecuteS($sql);
           
            
            }
if ($photo6up2 == 1)
            {
            $id_image6=$id_image+5;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image6.',1,NULL)';
            $result20=Db::getInstance()->ExecuteS($sql);
            
            }
if ($photo7up2 == 1)
            {
            $id_image7=$id_image+6;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image7.',1,NULL)';
            $result21=Db::getInstance()->ExecuteS($sql);
          

            }
if ($photo8up2 == 1)
            {
            $id_image8=$id_image+7;
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image8.',1,NULL)';
            $result22=Db::getInstance()->ExecuteS($sql);
           
            }

Edited August 31, 2015 by Alexandre-KM (see edit history)

Fernand WAFO · August 31, 2015

Bonjour,

Vous avez 2 possibilités :

1. Récupérer l'id de la dernière insertion pour l'insertion dans image_shop

2. Utilisation du modèle "Image" : $image = new Image();

La 2e solution est mieux

Baba deCode · September 1, 2015

Hello Cleandev,

Merci pour ta réponse j'ai pu résoudre mon problème, j'ai fais un $id_image2=Db::getInstance()->Insert_ID();

J'ai pas compris comment utiliser le modèle image....

Merci bcp je met le post en résolu

  if ($photo2up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',2,NULL)';
            $result8=Db::getInstance()->ExecuteS($sql);
             //On récupère l'id_image
            $id_image2=Db::getInstance()->Insert_ID();
            }

            if ($photo3up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',3,NULL)';
            $result9=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image3=Db::getInstance()->Insert_ID();
            }
            
            if ($photo4up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',4,NULL)';
            $result10=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image4=Db::getInstance()->Insert_ID();
            }
            
            if ($photo5up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',5,NULL)';
            $result11=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image5=Db::getInstance()->Insert_ID();
            }

            if ($photo6up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',6,NULL)';
            $result12=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image6=Db::getInstance()->Insert_ID();
            }

            if ($photo7up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',7,NULL)';
            $result13=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image7=Db::getInstance()->Insert_ID();
            }

            if ($photo8up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image (id_product,position,cover) VALUES ('.$ID.',8,NULL)';
            $result14=Db::getInstance()->ExecuteS($sql);
            //On récupère l'id_image
            $id_image8=Db::getInstance()->Insert_ID();
            }         
           
            if ($photo2up2 == 1)
            {
            $image = new Image($id_image['id_image']);
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image2.',1,NULL)';
            $result16=Db::getInstance()->ExecuteS($sql);
            }
           
            if ($photo3up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image3.',1,NULL)';
            $result17=Db::getInstance()->ExecuteS($sql);
            }
            
            if ($photo4up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image4.',1,NULL)';
            $result18=Db::getInstance()->ExecuteS($sql);
            }

            if ($photo5up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image5.',1,NULL)';
            $result19=Db::getInstance()->ExecuteS($sql);
            }
            
            if ($photo6up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image6.',1,NULL)';
            $result20=Db::getInstance()->ExecuteS($sql);
            }
            
            if ($photo7up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image7.',1,NULL)';
            $result21=Db::getInstance()->ExecuteS($sql);
            }

            if ($photo8up2 == 1)
            {
            $sql='insert into '._DB_PREFIX_.'image_shop (id_product,id_image,id_shop,cover) VALUES ('.$ID.','.$id_image8.',1,NULL)';
            $result22=Db::getInstance()->ExecuteS($sql);
            }

Fernand WAFO · September 1, 2015

OK c'est la première proposition : récupérer l'id du dernier enregistrement. Si ma réponse vous a aider, cliquer sur j'aime juste devant

Sign In

HELP: Recupérer l'id de l'image dans une fonction

Recommended Posts

Baba deCode

Link to comment

Share on other sites

Fernand WAFO

Link to comment

Share on other sites

Baba deCode

Link to comment

Share on other sites

Fernand WAFO

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

Activity

Go back to prestashop.com