public function insertGallery(Projeto $project) { $result = $this->connect->begin_transaction(MYSQLI_TRANS_START_READ_WRITE); $result = $this->connect->query("INSERT INTO projeto(name,description,local,category,customer,datinha) VALUES ('" . $project->getName() . "','" . $project->getDescription() . "','" . $project->getLocal() . "'," . $project->getCategory() . ",'" . $project->getCustomer() . "','" . $project->getDate() . "')"); $query_imagem_temp = "INSERT INTO imagem(nome,projeto) VALUES"; $imagem = $project->getImage(); if (count($imagem) > 0) { foreach ($imagem as $key => $value) { $query_imagem_temp .= " ('" . $value . "'," . $this->connect->insert_id . "),"; } $query_imagem = substr($query_imagem_temp, 0, -1); $result = $this->connect->query($query_imagem); } $this->connect->commit(); return $query_imagem; }