34 lines
914 B
PHP
34 lines
914 B
PHP
<?php
|
|
|
|
if(count($argv) != 4) {
|
|
die("Usage: php ./add-call 15555555555 '* * * * *' http://domain.com/file.mp3\n");
|
|
}
|
|
|
|
$phone = $argv[1];
|
|
$schedule = $argv[2];
|
|
$mp3 = $argv[3];
|
|
|
|
if(preg_match('/^\d{11}$/', $phone) != 1) {
|
|
die("Phone should be all numbers with no symbols. ex: 15555555555\n");
|
|
}
|
|
|
|
if(count(split(' ', $schedule)) != 5) {
|
|
die("Schedule requires a properly formed cron schedule.\n");
|
|
}
|
|
|
|
if(!filter_var($mp3, FILTER_VALIDATE_URL)) {
|
|
die("MP3 must be a vaild url.\n");
|
|
}
|
|
|
|
try {
|
|
$db = new PDO('sqlite:db/songcaller.db');
|
|
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
} catch(PDOException $e) {
|
|
die("PDOException (connect): " . $e->getMessage() . "\n");
|
|
}
|
|
try {
|
|
$db->exec("INSERT INTO calls (phone, schedule, mp3) VALUES($phone, '$schedule', '$mp3')");
|
|
} catch(PDOException $e) {
|
|
die("PDOException (query): " . $e->getMessage() . "\n");
|
|
}
|
|
echo "Successfully added call.\n"; |