1
0
Fork 0
song-caller/add-call.php

34 lines
914 B
PHP
Raw Permalink Normal View History

<?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";