<?php
$conn = mysqli_connect('localhost', 'drganbug_medine', '0AC]Q~*TN!8o', 'drganbug_medine');
$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'];
}elseif(isset($_POST['name']) && isset($_POST['video'])){
    $name = $_POST['name'];
    $mobss = $_POST['whatsapp'];
    $vid_name='';
    $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='$mobss'");
        $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', '$name', '$_POST[country]', 1, 0, '$mobss', 'GST', '$mobss');
";
mysqli_query($conn, $insert_user);
        }
        
        
        foreach($_POST['video'] as $video){
$get_c = mysqli_query($conn, "select name, 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;
                    $vid_name.=$get_cost['name'].' ';
                }else{
                    $i=0;
                }
              
        }
        if($i > 0){
          //include message code here
          $message = "Hi ".$name." payment received for ".$vid_name." video. Click below link, enter your mobile number to view it https://drganbuganapathi.com/direct -Energy Foods"; //enter Your Message 		
            $message = urlencode($message);
            $curl = curl_init();
        curl_setopt_array($curl, array(
          CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$mobss.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb',
          CURLOPT_RETURNTRANSFER => true,
          CURLOPT_ENCODING => '',
          CURLOPT_MAXREDIRS => 10,
          CURLOPT_TIMEOUT => 0,
          CURLOPT_FOLLOWLOCATION => true,
          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
          CURLOPT_CUSTOMREQUEST => 'GET',
        ));
        $response = curl_exec($curl);
        curl_close($curl);
            echo '1';
        }else{
            echo '2';
        }
    }else{
        echo '3';
    }
   
}

?>