<?php
include "general2.php";
include "connect.php";
date_default_timezone_set('Africa/Lagos');
$phonebook = $_SESSION["phonebook"];
 if ($phonebook == "" ){
 
               header('Location: addressbookupload.php?err=6');
               die();
   }
		   


 
 $bookname =$_POST["bookname"];   
 $phonenumber =$_POST["phonenumber"];
 $mtype =$_POST["mtype"]; 
 $username =$_SESSION['username'];
 if (mtype =="0")
     $cnt = count(explode(",", $phonenumber));
 else
     $cnt = count(explode("##", $phonenumber));
 
 //$phonenumber= str_replace("\n",",",$phonenumber);
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
 // Check connection
 if (mysqli_connect_errno())
   {
   header('Location:addressbookupload.php?err=7');
   exit();
   }
$query ="INSERT INTO addressbooksingle (username,mtype,bookname,phonenumber,status,domain,datesent)  VALUES ('". $username ."','". $mtype ."','". $bookname ."','". $phonenumber ."','0','". $domain ."','". date('Y-m-d H:i:s')."')";
//echo $query;
//exit();

if(!$result= mysqli_query($con,$query))
{
  //echo mysqli_error($con);
  //echo mysqli_error($con);
   header('Location: addressbookupload.php?err=7');
   mysqli_close($con);
   exit();
}

 mysqli_close($con);
 if (mtype =="0")
      header('Location: addressbookupload.php?err=0&cnt='.$cnt);
 else
       header('Location: addressbookuploadperson.php?err=0&cnt='.$cnt);
 exit();

?>