saveschedule.php

<?php
//include the database
include 'functions.php';

if(!$testuser->has('usersmail', [])) {
	$testuser->create("usersmail", [
		"id" => [
			"INT",
			"NOT NULL",
			"AUTO_INCREMENT",
			"PRIMARY KEY"
		],
		"name" => [
			"VARCHAR(50)",
			"NOT NULL"
		],
		"email" => [
			"VARCHAR(50)",
			"NOT NULL"
		],
		"created" => [
			"Date",
			"NOT NULL"
		],
		"timefrom" => [
			"VARCHAR(50)",
			"NOT NULL"
		],
		"timeto" => [
			"VARCHAR(50)",
			"NOT NULL"
		],
		"callfrom" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"callto" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"callduration" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"talkduration" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"status" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"drunk" => [
			"VARCHAR(100)",
			"NOT NULL"
		],
		"communicationtype" => [
			"VARCHAR(50)",
			"NOT NULL"
		],
		"pincode" => [
			"int(100)",
			"NOT NULL"
		],
		"number_fuzzy" => [
			"int(20)",
			"NOT NULL"
		],
		"sented" => [
			"date",
			"NULL"
		]
	]);
}

$datas = [
	"id" => $_POST['id'],
	"name" => $_POST['name'],
	"email" => $_POST['email'],
	"created" => date('y-m-d'),
	"timefrom" => $_POST['timefrom'],
	"timeto" => $_POST['timeto'],
	"callfrom" => $_POST['callfrom'],
	"callto" => $_POST['callto'],
	"callduration" => $_POST['callduration'],
	"talkduration" => $_POST['talkduration'],
	"status" => $_POST['status'],
	"drunk" => $_POST['drunk'],
	"communicationtype" => $_POST['communicationtype'],
	"pincode" => $_POST['pincode'],
	"number_fuzzy" => $_POST['number_fuzzy'],	
];

if($testuser->has('usersmail', ['id'=>$_POST['id']])){

	unset($datas['id']);

	$testuser->update('usersmail', $datas, ['id'=>$_POST['id']]);
}else{
	
	$testuser->insert('usersmail', $datas);
}

echo json_encode("saved infomation Successfully!");