<?php
session_start();
require 'db.connect.php';

$i=0;
if(isset($_POST['vid_id'])){
    $split = implode(',',$_POST['vid_id']);
    $get_video = mysqli_query($conn, "SELECT sum(price) as amount from shop_product where product_id in ($split)");
    $get = mysqli_fetch_array($get_video, MYSQLI_ASSOC);
    echo $get['amount'];
    exit;
}elseif(isset($_POST['name']) && isset($_POST['video'])){
    $sql = "insert into tbl_yoga_video_request(`name`,`country`, `whatsapp`, `payment_type`, `status`) values
    ('$_POST[name]', '$_POST[country]', '$_POST[whatsapp]', '$_POST[pay]', '0')";
    if(mysqli_query($conn, $sql)){
                $last = mysqli_insert_id($conn);
         $get_user = mysqli_query($conn, "SELECT * FROM shop_user where phone='$_POST[whatsapp]'");
        $check_rows = mysqli_num_rows($get_user);
        if($check_rows == 0){
$username='drg-'.time();
        $insert_user="INSERT INTO shop_user 
(username, password, name, country, status, new_status, phone, gst, skypeid)
VALUES 
('$username', 'test@123', '$_POST[name]', '$_POST[country]', 1, 0, '$_POST[whatsapp]', 'GST', '$_POST[whatsapp]');
";
mysqli_query($conn, $insert_user);
        }

        foreach($_POST['video'] as $video){
$get_c = mysqli_query($conn, "select price from shop_product where product_id = '$video'");
$get_cost = mysqli_fetch_array($get_c, MYSQLI_ASSOC);

           $exp = "insert into tbl_yoga_video_request_explained(`ref_id`, `product_id`, `price`) values (
                '$last', '$video', '$get_cost[price]')";
                
                if(mysqli_query($conn, $exp)){
                    $i=$i+1;
                }else{
                    $i=0;
                }
              
        }
        if($i > 0){
            echo '1';
        }else{
            echo '2';
        }
    }else{
        echo '3';
    }
}
?>