Andrew Tomaka
b7fb4c8ced
Implement xml-generator.php that will automatically generate XML files from the database based on an ID passed in a get query. This allows new calls to be added using new MP3s without having to create a new XML file by hand everytime. This is the first step to a full web implementation.
11 lines
246 B
PHP
11 lines
246 B
PHP
<?php
|
|
$db = new PDO('sqlite:db/songcaller.db');
|
|
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
|
|
$db->exec('create table calls (
|
|
id integer PRIMARY KEY,
|
|
phone integer,
|
|
schedule varchar(50),
|
|
mp3 varchar(255)
|
|
);'
|
|
);
|