balian

Untitled

May 5th, 2012
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. if(isset($_POST['submited'])) {
  2.         $nome = $_POST['nome'];
  3.         $preco = $_POST['preco'];
  4.         $descricao = $_POST['descricao'];
  5.         $marca = $_POST['marca'];
  6.         $sabor = $_POST['sabor'];
  7.        
  8.         $idmarca = "SELECT IDMARCA as idmarca
  9.                 FROM `nutrinow`.`marcas`
  10.                 WHERE `MARCA` = $marca";
  11.  
  12.         $idsabor = "SELECT `IDSABOR` as idsabor
  13.                 FROM `nutrinow`.`sabores`
  14.                 WHERE `SABOR` =".$_POST['sabor'];
  15.        
  16.        
  17.         $txtquery = "INSERT INTO `nutrinow`.`produtos` (`IDPRODUTO`, `IDMARCA`, `IDSABOR`, `NOME`, `PRECO`, `DESCRICAO`, `MARCA`, `SABOR`)" .
  18.                     "values ('', '$idmarca', '$idsabor', '$nome', '$preco', $descricao, '$marca', $sabor)";
  19.        
  20.        
  21.         mysql_query($txtquery);
  22.        
  23. }
Advertisement
Add Comment
Please, Sign In to add comment