<?php
if (isset($_POST['year'])) {$year = $_POST['year'];} else {$year = 2014;} if (isset($_POST['month'])) {$month = $_POST['month'];} else {$month = 9;} if (isset($_POST['day'])) {$day = $_POST['day'];} else {$day = null;} if (isset($_POST['action'])) {$action = $_POST['action'];} else {$action = 'get';}
if (strlen($month) == 1) {$month = '0' . $month;} if (strlen($day) == 1) {$day = '0' . $day;}
$mysqli = new mysqli(
"", //host
"", // user
"", // pass
"" // DB
);
if ($action == 'get')
{
$sql_query = "SELECT SUBSTRING(vihodnoy, 9, 2) as day FROM t_table WHERE
user_id=6 AND
SUBSTRING(vihodnoy, 6, 2) = " . $month . " AND
SUBSTRING(vihodnoy, 1, 4) = " . $year;
{
$array[] = (integer)$sql_row['day'];
}
} else echo $mysqli->error;
echo $json_data;
} elseif($action == 'del')
{
$vihodnoy = $year . '-' . $month . '-' . $day;
$sql_query = "DELETE FROM t_table WHERE user_id=6 AND vihodnoy = '" . $vihodnoy . "'";
echo 'ok';
else
echo $mysqli->error;
} elseif($action == 'add')
{
$vihodnoy = $year . '-' . $month . '-' . $day;
$sql_query = "SELECT id FROM t_table WHERE user_id=6 AND vihodnoy='" . $vihodnoy . "'";
if ($mysqli->affected_rows == 0)
{
$sql_query = "INSERT INTO t_table (user_id, vihodnoy) VALUES ('6','" . $vihodnoy . "')";
echo 'ok';
else
echo $mysqli->error;
}
}
$mysqli->close();
PD9waHAKCmlmIChpc3NldCgkX1BPU1RbJ3llYXInXSkpCQl7JHllYXIgCQk9ICRfUE9TVFsneWVhciddO30gCQllbHNlIHskeWVhciAJPSAyMDE0O30KaWYgKGlzc2V0KCRfUE9TVFsnbW9udGgnXSkpIAl7JG1vbnRoIAk9ICRfUE9TVFsnbW9udGgnXTt9IAllbHNlIHskbW9udGggCT0gOTt9CmlmIChpc3NldCgkX1BPU1RbJ2RheSddKSkJCXskZGF5IAkJPSAkX1BPU1RbJ2RheSddO30gCQllbHNlIHskZGF5IAkJPSBudWxsO30KaWYgKGlzc2V0KCRfUE9TVFsnYWN0aW9uJ10pKQl7JGFjdGlvbiAJPSAkX1BPU1RbJ2FjdGlvbiddO30gCWVsc2UgeyRhY3Rpb24gCT0gJ2dldCc7fQoKaWYgKHN0cmxlbigkbW9udGgpIAk9PSAxKSB7JG1vbnRoIAk9ICcwJyAuICRtb250aDt9CmlmIChzdHJsZW4oJGRheSkgCT09IDEpIHskZGF5IAk9ICcwJyAuICRkYXk7fQoKJG15c3FsaSA9IG5ldyBteXNxbGkoCgkiIiwgLy9ob3N0CgkiIiwgLy8gdXNlcgoJIiIsIC8vIHBhc3MKCSIiICAvLyBEQgopOwoKaWYgKCRhY3Rpb24gPT0gJ2dldCcpCnsKCSRzcWxfcXVlcnkgPSAiU0VMRUNUIFNVQlNUUklORyh2aWhvZG5veSwgOSwgMikgYXMgZGF5IEZST00gdF90YWJsZSBXSEVSRQoJCQkJCXVzZXJfaWQ9NiBBTkQKCQkJCQlTVUJTVFJJTkcodmlob2Rub3ksIDYsIDIpID0gIiAuICRtb250aCAuICIgQU5ECgkJCQkJU1VCU1RSSU5HKHZpaG9kbm95LCAxLCA0KSA9ICIgLiAkeWVhcjsKCglpZiAoJHNxbF9yZXN1bHQgPSBteXNxbGlfcXVlcnkoJG15c3FsaSwgJHNxbF9xdWVyeSkpCgl7CgoJCXdoaWxlKCRzcWxfcm93ID0gbXlzcWxpX2ZldGNoX2Fzc29jKCRzcWxfcmVzdWx0KSl7CgkJCQkkYXJyYXlbXSA9IChpbnRlZ2VyKSRzcWxfcm93WydkYXknXTsKCQl9CgoJfSBlbHNlIGVjaG8gJG15c3FsaS0+ZXJyb3I7CgoJJGpzb25fZGF0YSA9IGpzb25fZW5jb2RlKCRhcnJheSk7CgoJbXlzcWxpX2ZyZWVfcmVzdWx0KCRzcWxfcmVzdWx0KTsKCgllY2hvICRqc29uX2RhdGE7Cn0gZWxzZWlmKCRhY3Rpb24gPT0gJ2RlbCcpCnsKCSR2aWhvZG5veSA9ICR5ZWFyIC4gJy0nIC4gJG1vbnRoIC4gJy0nIC4gJGRheTsKCSRzcWxfcXVlcnkgPSAiREVMRVRFIEZST00gdF90YWJsZSBXSEVSRSB1c2VyX2lkPTYgQU5EIHZpaG9kbm95ID0gJyIgLiAkdmlob2Rub3kgLiAiJyI7CglpZiAobXlzcWxpX3F1ZXJ5KCRteXNxbGksICRzcWxfcXVlcnkpKQoJCWVjaG8gJ29rJzsKCWVsc2UKCQllY2hvICRteXNxbGktPmVycm9yOwp9IGVsc2VpZigkYWN0aW9uID09ICdhZGQnKQp7Cgkkdmlob2Rub3kgPSAkeWVhciAuICctJyAuICRtb250aCAuICctJyAuICRkYXk7Cgkkc3FsX3F1ZXJ5ID0gIlNFTEVDVCBpZCBGUk9NIHRfdGFibGUgV0hFUkUgdXNlcl9pZD02IEFORCB2aWhvZG5veT0nIiAuICR2aWhvZG5veSAuICInIjsKCW15c3FsaV9xdWVyeSgkbXlzcWxpLCAkc3FsX3F1ZXJ5KTsKCWlmICgkbXlzcWxpLT5hZmZlY3RlZF9yb3dzID09IDApCgl7CgkJJHNxbF9xdWVyeSA9ICJJTlNFUlQgSU5UTyB0X3RhYmxlICh1c2VyX2lkLCB2aWhvZG5veSkgVkFMVUVTICgnNicsJyIgLiAkdmlob2Rub3kgLiAiJykiOwoJCWlmIChteXNxbGlfcXVlcnkoJG15c3FsaSwgJHNxbF9xdWVyeSkpCgkJCWVjaG8gJ29rJzsKCQllbHNlCgkJCWVjaG8gJG15c3FsaS0+ZXJyb3I7Cgl9Cn0KJG15c3FsaS0+Y2xvc2UoKTs=