PHP create_row_if_not_existing Examples

Example #1

File: icalendar_functions.php Project: op-erator/banwebplus

 public static function calendarLinkToString($s_linktype)
 {
     global $global_user;
     global $maindb;
     $s_id = $global_user->get_id();
     $s_username = $global_user->get_name();
     create_row_if_not_existing(array("database" => $maindb, "table" => "generated_settings", "user_id" => $s_id));
     $a_settings_rows = db_query("SELECT `private_icalendar_key` FROM `[database]`.`generated_settings` WHERE `user_id` = '[user_id]'", array('database' => $maindb, 'user_id' => $s_id));
     if ($s_linktype == "web") {
         return "http://www.banwebplus.com/pages/icalendar/calendars/{$s_username}/" . $a_settings_rows[0]['private_icalendar_key'] . "/ClassSchedule.ics";
     } else {
         if ($s_linktype == "view") {
             return "http://www.banwebplus.com/pages/icalendar/calendars/{$s_username}/" . $a_settings_rows[0]['private_icalendar_key'] . "/pretty/ClassSchedule.ics";
         } else {
             if ($s_linktype == "download") {
                 return "http://www.banwebplus.com/pages/icalendar/calendars/{$s_username}/" . $a_settings_rows[0]['private_icalendar_key'] . "/download/ClassSchedule.ics";
             } else {
                 return self::calendarLinkToString("view");
             }
         }
     }
 }

Example #2

File: user.php Project: op-erator/banwebplus

 private function save_user_data($s_year, $s_semester, $s_tablename, $s_json_saveval, $s_timestamp)
 {
     global $maindb;
     global $mysqli;
     $a_queryvars = array("table" => $s_tablename, "year" => $s_year, "semester" => $s_semester, "user_id" => $this->get_id(), "database" => $maindb);
     $s_querystring = "UPDATE `[database]`.`[table]` SET `json`='[json]',`time_submitted`='[timestamp]' WHERE `year`='[year]' AND `semester`='[semester]' AND `user_id`='[user_id]'";
     create_row_if_not_existing($a_queryvars);
     db_query($s_querystring, array_merge(array('json' => $s_json_saveval, 'timestamp' => $s_timestamp), $a_queryvars));
     return $mysqli->affected_rows;
 }