| captainmerton |
06-29-2009 08:47 PM |
Class:
PHP Code:
<?php
class Bet {
public $bettype;
public $eventdetail;
public $eventtype;
public $eventdate;
public $eventtime;
public function validate_add_bet($bettype,$eventdetail,$eventtype,$eventdate,$eventtime,$freezedate,$freezetime) {
$this->bettype = $bettype;
$this->eventdetail = $eventdetail;
$this->eventtype = $eventtype;
$this->eventdate = $eventdate;
$this->eventtime = $eventtime;
$this->freezedate = $freezedate;
$this->freezetime = $freezetime;
$this->validate_event_detail($this->eventdetail);
$this->validate_event_date($this->eventdate);
$this->validate_event_time($this->eventtime);
$this->validate_freeze_date($this->freezedate);
$this->validate_freeze_time($this->freezetime);
$this->addbet($this->bettype,$this->eventdetail,$this->eventtype,$this->eventdate,$this->eventtime,$this->freezedate,$this->freezetime);
}
public function validate_event_detail($eventdetail) {
$this->$eventdetail = $eventdetail;
}
public function validate_event_date($eventdate) {
$this->$eventdate = $eventdate;
try {
validateUkFormat($this->$eventdate);
$this->$eventdate = getMysqlDate($this->$eventdate);
} catch ( Exception $e ) {
die ( $e->__toString() );
}
}
public function validate_event_time($eventtime) {
$this->$eventtime = $eventtime;
try {
validateTime($this->$eventtime);
} catch ( Exception $e ) {
die ( $e->__toString() );
}
}
public function validate_freeze_date($freezedate) {
$this->$freezedate = $freezedate;
try {
validateUkFormat($this->$freezedate);
$this->$freezedate = getMysqlDate($this->$freezedate);
} catch ( Exception $e ) {
die ( $e->__toString() );
}
}
public function validate_freeze_time($freezetime) {
$this->$freezetime = $freezetime;
try {
validateTime($this->$freezetime);
} catch ( Exception $e ) {
die ( $e->__toString() );
}
}
/* Add bet */
public function addbet($bettype,$eventdetail,$eventtype,$eventdate,$eventtime) {
$this->bettype = $bettype;
$this->eventdetail = $eventdetail;
$this->eventtype = $eventtype;
$this->eventdate = $eventdate;
$this->eventtime = $eventtime;
$query = ("INSERT INTO bet (betoriginator,colid,betdate,bettime,bettype,eventdetail,eventtype,eventdate,eventtime,freezedate,freezetime,status)
VALUES ('captainmerton',1,'2009-06-10','19:00:00','test','$this->eventdetail','$this->eventtype','2009-06-10','19:00:00','2009-06-10','19:00:00','E')");
$result = mysql_query($query) OR die('Cannot perform add bet query!');
}
}
?>
Function:
PHP Code:
function validateTime($time)
{
$tPieces = explode(":",$time);
$hour = $tPieces[0];
$min = $tPieces[1];
$sec =$tPieces[2];
if (($hour < 0) || ($hour > 24)) {throw new Exception("Hours must be between 00 and 24");
} else {
if (($min < 0) || ($min > 60)) {throw new Exception("Mins must be between 00 and 60");
} else {
if (($sec < 0) || ($sec > 60)) {throw new Exception("Secs must be between 00 and 60");}
}
}
}
|