song-caller/create-table.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)
		);'
  );
Add Multicall Support Implement multicall support by using an sqlite database to store and retrieve calls. Two interfaces have been added: 1) add-call.php. Used to add calls. example: add-call.php 15555555555 '0 10-16 * * *' 'http://www.domain.com/xml.xml' 2) create-table.php. Creates the database file Created calls are retrieved in the caller.php file. Each call is run through the scheduler to verify if it is time for it to be made. 2013-03-04 19:27:42 -05:00			`<?php`
			`$db = new PDO('sqlite:db/songcaller.db');`
			`$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);`

			`$db->exec('create table calls (`
Automatically Generate XML Files 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. 2013-03-05 11:37:28 -05:00			`id integer PRIMARY KEY,`
Add Multicall Support Implement multicall support by using an sqlite database to store and retrieve calls. Two interfaces have been added: 1) add-call.php. Used to add calls. example: add-call.php 15555555555 '0 10-16 * * *' 'http://www.domain.com/xml.xml' 2) create-table.php. Creates the database file Created calls are retrieved in the caller.php file. Each call is run through the scheduler to verify if it is time for it to be made. 2013-03-04 19:27:42 -05:00			`phone integer,`
			`schedule varchar(50),`
Automatically Generate XML Files 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. 2013-03-05 11:37:28 -05:00			`mp3 varchar(255)`
			`);'`
			`);`