diegodcpbr

erro foreach

Sep 18th, 2019
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. <?php
  2. var_dump($_POST['num']);
  3. $message = "";
  4. if(isset($_POST['enviaformulario'])){ //check if form was submitted
  5.   $db_connect = MySql::conectar();
  6.         //<-- user information register start -->
  7.         $user_name = $_POST['user_name'];
  8.         $user_mail = $_POST['user_email'];
  9.         $user_phone = $_POST['user_phone'];
  10.         $cost = $_POST['total_cost'];
  11.         $cost = (float)$cost;
  12.         $user_sql = "INSERT INTO `tb_site.user` (`name`,`email`,`phone`,`total_cost`) VALUES ('". $user_name ."','". $user_mail ."','". $user_phone ."',". $cost .")";
  13.         $db_connect->query($user_sql);
  14.         $user_id = $db_connect->lastInsertId();
  15.         //<-- user information register end-->
  16.         $number_list = $_POST['num'];
  17.         $rifa_id = intval($_POST['rifas_id']);
  18.         $number_type = 1;
  19.         $number_list = "";
  20.         foreach($number_list as $num){
  21.             $num = intval($num);
  22.             $sql = "INSERT INTO `tb_site.test`(`rifas_id`,`number`,`type`,`user_id`,`cost_id`) VALUES (".$rifa_id.",".$num.",".$number_type .",". $user_id.",".$rifa_id.");";  
  23.             $db_connect->query($sql);
  24.         }
  25.   $mensagem = "Sucesso.: ".$input;
  26. }    
  27. ?>
  28.  
  29. <html>
  30. <body>    
  31. <form action="" method="post">
  32. <?php echo $mensagem; ?>
  33.  
  34.   <input type="submit" name="enviaformulario"/>
  35. </form>    
  36. </body>
  37. </html>
Advertisement
Add Comment
Please, Sign In to add comment