PHP self::cleanForDb Examples

Example #1

File: db.php Project: nikilster/I

 public static function logMotivation($userId, $time, $activityId, $firstName, $lastName, $duration, $goal, $percentage, $activityName, $message)
 {
     //Anonymous db
     $db = new self(0);
     $message = $db->cleanForDb($message);
     $logQuery = 'INSERT INTO motivation ';
     $logQuery .= ' (user_id, time, activity_id, first_name, last_name, duration, goal, percentage, activity_name, message) ';
     $logQuery .= ' VALUES ';
     $logQuery .= " ({$userId}, '{$time}', {$activityId}, '{$firstName}', '{$lastName}', {$duration}, {$goal}, {$percentage}, '{$activityName}', '{$message}');";
     return $db->query($logQuery);
 }