PHP DBConn::insert Examples

Example #1

File: auth.data.php Project: rachellcarbone/angular-seed

 static function updateAcceptSignupTeamInvite($validInvite)
 {
     DBConn::insert("INSERT INTO " . DBConn::prefix() . "team_members(user_id, team_id, added_by) " . "VALUES (:user_id, :team_id, :added_by);", array(':user_id' => $validInvite[':user_id'], ':team_id' => $validInvite[':team_id'], ':added_by' => $validInvite[':user_id']));
     return DBConn::update("UPDATE " . DBConn::prefix() . "tokens_player_invites SET " . "response='accepted', user_id = :user_id WHERE token = :token " . "AND team_id = :team_id AND response IS NULL AND expires >= NOW() LIMIT 1;", $validInvite);
 }

Example #2

File: groups.data.php Project: rachellcarbone/angular-seed

 static function insertRoleAssignment($data)
 {
     return DBConn::insert("INSERT INTO " . DBConn::prefix() . "auth_lookup_group_role(`auth_group_id`, `auth_role_id`, `created_user_id`) " . "VALUES (:auth_group_id, :auth_role_id, :created_user_id)", $data);
 }

Example #3

File: auth.additionalInfo.data.php Project: rachellcarbone/angular-seed

 public static function insertQuestion($data)
 {
     return DBConn::insert("INSERT INTO " . DBConn::prefix() . "user_additional_info(user_id, question, answer) " . "VALUES (:user_id, :question, :answer);", $data);
 }

Example #4

File: user.data.php Project: rachellcarbone/angular-seed

 static function insertGroupAssignment($data)
 {
     return DBConn::insert("INSERT INTO " . DBConn::prefix() . "auth_lookup_user_group(`auth_group_id`, `user_id`, `created_user_id`) " . "VALUES (:auth_group_id, :user_id, :created_user_id);", $data);
 }

Example #5

File: config.data.php Project: rachellcarbone/angular-seed

 public static function insertVariable($validConfig)
 {
     return DBConn::insert("INSERT INTO " . DBConn::prefix() . "system_config(name, value, disabled, created_user_id, last_updated_by) " . "VALUES (:name, :value, :disabled, :created_user_id, :last_updated_by);", $validConfig);
 }

Example #6

File: actions.data.php Project: rachellcarbone/angular-seed

 static function insertAction($validAction)
 {
     return DBConn::insert("INSERT INTO " . DBConn::prefix() . "logs_action_tracking(`ip_address`, `code`, `action`, `http_referer`, `created_user_id`) " . "VALUES (:ip_address, :code, :action, :http_referer, :created_user_id);", $validAction);
 }

Example #7

File: emails.data.php Project: rachellcarbone/angular-seed

 static function updateAcceptTeamInvite($validInvite)
 {
     DBConn::delete("DELETE FROM " . DBConn::prefix() . "team_members WHERE user_id = :user_id;", array(':user_id' => $validInvite[':user_id']));
     DBConn::insert("INSERT INTO " . DBConn::prefix() . "team_members(user_id, team_id, added_by) " . "VALUES (:user_id, :team_id, :added_by);", array(':user_id' => $validInvite[':user_id'], ':team_id' => $validInvite[':team_id'], ':added_by' => $validInvite[':user_id']));
     return DBConn::update("UPDATE " . DBConn::prefix() . "tokens_player_invites SET " . "response='accepted', last_visited=NOW() WHERE token = :token AND user_id = :user_id " . "AND team_id = :team_id AND expires > NOW() LIMIT 1;", $validInvite);
 }