rodrigobravo · September 19, 2017 22:07
diff --git a/insert.ṕhp b/insert.ṕhp

 try{
   $dbdest = new PDO('sqlite:/home/rodrigo/delivery2/files/delivery.db');
   
            foreach ($listaPedidos as $key) {
            //var_dump($key);
            $sqlinsert = $dbdest->prepare($sqlInsertRequests);
           
            $client_id = $key->client_id;
            $funcionario = $key->employee_name;
            $acumulador = $key->accumulator;
            $obs = $key->obs;
            $total = $key->total_price;
            $date_req = $key->date;
            $id = $key->id_orig;
            $doc_number = $key->doc_number;
            $clock_req = substr($key->clock,0,-9);

            $sqlinsert->bindValue(':client_id', $client_id);
            $sqlinsert->bindValue(':employee_name', $funcionario);
            $sqlinsert->bindValue(':accumulator', $acumulador);
            $sqlinsert->bindValue(':obs', $obs);
            $sqlinsert->bindValue(':totalPrice', $total);
            $sqlinsert->bindValue(':date', $date_req);
            $sqlinsert->bindValue(':id_orig', $id);
            $sqlinsert->bindValue(':doc_number', $doc_number);
            $sqlinsert->bindValue(':clock_req', $clock_req);
        

            $sqlinsert->execute();
            
                        }
 }
 catch(PDOException $f){
  print 'Exception : '.$f->getMessage();
                      }
No results found