getMessage(); } } function addList($type, $list){ $class = $type .'DA'; $arr = new ArrayCollection(); foreach ( $list as $object ){ $arr[] = $class::add($object); } return $arr; } function checkConnection(){ return "SUCCESS"; } function login($login, $paswoord){ $login = Core::encrypt($login); $paswoord = Core::encrypt($paswoord); $sql = sprintf("SELECT * FROM personeelslid INNER JOIN gebruiker ON personeelslid.gebruikerID = gebruiker.ID WHERE login = '%s' AND paswoord = '%s'", $login, $paswoord); $query = Core::executeQuery($sql); $arr = new ArrayCollection(); while ($row = mysql_fetch_object($query)) { $user = PersoneelslidDA::makeNew($row); $session = SessionDA::add($user->ID); $user->sessionID = $session->ID; return $user; } return "FAILED"; } function loginClient($login, $paswoord){ $login = Core::encrypt($login); $paswoord = Core::encrypt($paswoord); $sql = sprintf("SELECT * FROM gebruiker WHERE login = '%s' AND paswoord = '%s'", $login, $paswoord); $query = Core::executeQuery($sql); $arr = new ArrayCollection(); while ($row = mysql_fetch_object($query)) { $user = GebruikerDA::makeNew($row); $session = SessionDA::add($user->ID); $user->sessionID = $session->ID; return $user; } return "FAILED"; } public function checkGebruikerExists($naam, $voornaam){ $sql2 = sprintf("SELECT naam, voornaam FROM gebruiker WHERE naam = '%s' AND voornaam = '%s'",$naam,$voornaam); //return $sql2; $query2 = mysql_query($sql2); $num_rows = mysql_num_rows($query2); if ( $num_rows > 0 ){ return false; }else{ return true; } } private function strtocamel($str, $capitalizeFirst = true, $allowed = 'A-Za-z0-9') { return preg_replace( array( '/([A-Z][a-z])/e', // all occurances of caps followed by lowers '/([a-zA-Z])([a-zA-Z]*)/e', // all occurances of words w/ first char captured separately '/[^'.$allowed.']+/e', // all non allowed chars (non alpha numerics, by default) '/^([a-zA-Z])/e' // first alpha char ), array( '" ".$1', // add spaces 'strtoupper("$1").strtolower("$2")', // capitalize first, lower the rest '', // delete undesired chars 'strto'.($capitalizeFirst ? 'upper' : 'lower').'("$1")' // force first char to upper or lower ), $str ); } } ?>