<?php

/**

 * @author Bettina Schwarzer

 * @copyright 08/2011

 *

 * INSERT Infodaten in n:m-Tabellen fuer INSERT und UPDATE Infodaten 

 */

            // Produkt

            $retp = true;

            if (is_array($inf["prid"]) && array_sum($inf["prid"])>0)

            { // nur Produkte, keine Gruppen, Bereiche

                // Loeschen altes Produkt, INSERT neues

                $sql = "DELETE FROM Info_Produkt WHERE info_ID = $infid";

                $retpd = $dbc -> execute($sql);

                if ($retpd)

                {

                    foreach ($inf["prid"] as $pid)

                    {

                        //INSERT in Produkt_Vertrag

                        $sql = "INSERT INTO Info_Produkt VALUES($infid,$pid)";

                        $retpi = $dbc -> execute($sql); 

                        if (!$retpi) $retp=false;

                    }

                    if (!$retp) echo "error INSERT Info_Produkt<br />\n";

                }

                else

                { 

                    echo "error INSERT Info_Produkt: " . $dbc -> error . " <br />\n";

                    $retp = false;

                }

            }

            // Adressat

            $reta = true;

            $sql = "DELETE FROM Info_Adressat WHERE info_ID = $infid";

            $retd = $dbc -> execute($sql);

            if ($retd)

            {

                if (is_array($inf['adr']))

                {

                    foreach ($inf['adr'] as $adr)

                    {

                        if ($adr != -1)

                        { 

                            $sql = "INSERT INTO Info_Adressat VALUES($infid, $adr)";

                            $retai = $dbc -> execute($sql);

                            if (!$retai) $reta = false;

                        }

                    }

                    if (!$reta) echo "error INSERT Info_Adressat<br />\n";

                }

            }

            else

            { 

                echo "error INSERT Info_Adressat: " . $dbc -> error . " <br />\n";

                $reta = false;

            }

?>