function GetMainConnection() { global $MainConnection; if (!isset($MainConnection)) { $MainConnection = GetConnection(DB_HOST, DB_PORT, DB_NAME, DB_CHARSET, DB_USER, DB_PASSWORD); } return $MainConnection; }
public function run() { global $connection_string; global $last_migration; $migrations = array(); try { $migrations = MigrationHistory::find('all', array('order' => 'migration_date desc')); } catch (Exception $e) { //error_log($e); $create_migration_history = "CREATE TABLE `migration_history` (\n\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t `migration_timestamp` bigint(20) DEFAULT NULL,\n\t\t\t `migration_file` varchar(100) DEFAULT NULL,\n\t\t\t `migration_date` datetime DEFAULT NULL,\n\t\t\t `datecreated` datetime NOT NULL,\n\t\t\t PRIMARY KEY (`id`)\n\t\t\t) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8"; GetConnection()->query($create_migration_history); } $last_migration_timestamp = strtotime($last_migration); //if(count($migrations) > 0){ // $last_migration_timestamp = $migrations[0]->migration_timestamp; //} $migrations_ran = array_map(function ($m) { return $m->migration_file; }, $migrations); //$last_migration_date = new DateTime("@$last_migration_timestamp"); $migrationFiles = array(); if (is_dir($this->dir)) { if ($dh = opendir($this->dir)) { while (false !== ($file = readdir($dh))) { if ($file != "." && $file != ".." && filetype($this->dir . "/" . $file) == "file") { $migrationFiles[] = $file; } } sort($migrationFiles); closedir($dh); } } foreach ($migrationFiles as $file) { $file_parts = split('_', $file); $datestamp = $file_parts[0]; $timestamp = strtotime($datestamp); if ($timestamp > $last_migration_timestamp && !in_array($file, $migrations_ran)) { error_log("executing " . $file . ": " . $timestamp); try { $sqlpipe = "/usr/bin/mysql " . $connection_string . " < \"" . $this->dir . "/" . $file . "\" 2>&1 1> /dev/null"; $return = shell_exec($sqlpipe); if (!is_null($return)) { throw new Exception("Migration failed: " . $return); } $migrationHistory = new MigrationHistory(); $migrationHistory->migration_timestamp = $timestamp; $migrationHistory->migration_file = $file; $migrationHistory->migration_date = date("Y-m-d H:i:s", $timestamp); $migrationHistory->datecreated = GetNewDate(); $migrationHistory->save(); $last_migration_timestamp = $timestamp; } catch (Exception $e) { error_log($e); break; } } } }
static function Get() { $conn = GetConnection(); $results = $conn->query("SELECT * FROM 2015Fall_Persons"); $row = $results->fetch_assoc(); //var_dump($row);//=> its like "print(r);" //echo '<pre>' //print_r my_print($row); }
static function Update($row) { $conn = GetConnection(); $sql = "UPDATE Admin " . "Set Username='******'Username']}',Password='******'Password']}',Last_log='{$row['Last_log']}' " . "WHERE id={$row['id']} "; //echo $sql; $conn->query($sql); $error = $conn->error; $conn->close(); return $error != '' ? array('Server Error' => $error) : true; }
static function Update($row) { $conn = GetConnection(); $sql = "UPDATE Suppliers " . "Set FirstName='{$row['FirstName']}',LastName='{$row['LastName']}',created_at='{$row['created_at']}',updated_at='{$row['updated_at']}',Keyword_id='{$row['Keyword_id']}' " . "WHERE id={$row['id']} "; //echo $sql; $conn->query($sql); $error = $conn->error; $conn->close(); return $error != '' ? array('Server Error' => $error) : true; }
public static function Delete($id) { $conn = GetConnection(); $sql = "DELETE FROM 2014Fall_Food_Eaten WHERE id = {$id}"; //echo $sql; $results = $conn->query($sql); $error = $conn->error; $conn->close(); return $error ? array('sql error' => $error) : false; }
function TestLogin($pseudo, $password) { $db = GetConnection(); $request = $db->prepare('SELECT idUser, pseudo, pwd FROM `users` WHERE pseudo = "' . $pseudo . '" AND pwd = "' . $password . '"'); $request->execute(); $tabUser = $request->fetchAll(PDO::FETCH_ASSOC); if ($tabUser != null) { return $tabUser[0]["idUser"]; } else { return false; } }
public static function Save($row) { if ($row['id']) { $sql = "UPDATE 2015Fall_Meals Set Name = '{$row['Name']}', Calories = '{$row['Calories']}', Carbohydrates = '{$row['Carbohydrates']}', " . "Cholestrol='{$row['Cholestrol']}', Fiber = '{$row['Fiber']}', Protein = '{$row['Protein']}', Users_id=1, 2015Fall_MealTypes_id={$row['MealType']} WHERE id={$row['id']} "; } else { $sql = "Insert Into 2015Fall_Meals (Name, Calories, Carbohydrates, Cholestrol, Fiber, Protein, Users_id, 2015Fall_MealTypes_id) " . " Values ('{$row['Name']}', '{$row['Calories']}', '{$row['Carbohydrates']}', '{$row['Cholestrol']}', '{$row['Fiber']}', '{$row['Protein']}', 1, {$row['MealType']})"; } $conn = GetConnection(); $results = $conn->query($sql); $error = $conn->error; $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save($row) { if ($row['id']) { $sql = "Update 2015Fall_Users set Name='{$row['Name']}', Age='{$row['Age']}', Height='{$row['Height']}', Weight='{$row['Weight']}', Avatar='{$row['Avatar']}', Status='offline' WHERE id= {$row['id']}"; } else { $sql = "Insert Into 2015Fall_Users (Name, Age, Height, Weight, Avatar, Status) Values ( '{$row['Name']}', '{$row['Age']}', '{$row['Height']}', '{$row['Weight']}', '{$row['Avatar']}', 'offline' )"; } $conn = GetConnection(); $results = $conn->query($sql); $error = $conn->error; $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save($row) { if ($row['id']) { $sql = "UPDATE Exercises " . " Set Name = '{$row['Name']}', Minutes='{$row['Minutes']}', Calories_Burned='{$row['Calories_Burned']}', Users_id='{$row['Users_id']}', 2015Fall_ExerciseTypes_id='{$row['Users_id']}' " . " WHERE id={$row['id']} "; } else { $sql = "Insert Into Exercises (Name, Minutes, Calories_Burned, ) Values ('{$row['Name']}', '{$row['Minutes']}', '{$row['Calories_Burned']}', '{$row['Users_id']}', )"; } $conn = GetConnection(); $results = $conn->query($sql); $error = $conn->error; $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save($row) { if ($row['id']) { $sql = "UPDATE Friend " . " Set Name = '{$row['Name']}', Friend_id='{$row['Friend_id']}', Users_id='{$row['Person_id']}' WHERE Friend_id={$row['id']} "; } else { $sql = "Insert Into Friends (Friend_id, Person_id) Values('{$row['Friend_id']}', '{$row['Person_id']}')"; } $conn = GetConnection(); $results = $conn->query($sql); $error = $conn->error; $conn->close(); return $error ? array('sql error' => $error) : false; }
function FetchAll($sql) { $ret = array(); $conn = GetConnection(); $results = $conn->query($sql); $error = $conn->error; if ($error) { echo $error; } else { while ($rs = $results->fetch_assoc()) { $ret[] = $rs; } } return $ret; }
public static function Save(&$row) { $conn = GetConnection(); if (!empty($row['id'])) { $sql = "Update Persons set Name='{$row['Name']}', Age='{$row['Age']}', Height='{$row['Height']}', Weight='{$row['Weight']}', Avatar='{$row['Avatar']}', Status='offline' WHERE id= {$row['id']}"; } else { $sql = "Insert Into Persons (Name, Age, Height, Weight, Avatar, Status) Values ( '{$row['Name']}', '{$row['Age']}', '{$row['Height']}', '{$row['Weight']}', '{$row['Avatar']}', 'offline' )"; } //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); $row2['date'] = date('Y-m-d H:i:s', strtotime($row2['date'])); if (!empty($row['id'])) { $sql = "Update exercises\n\t\t\t\t\t\tSet exercisename='{$row2['exercisename']}', date='{$row2['date']}' ,calories='{$row2['calories']}',updated=Now(),minutes='{$row2['minutes']}'\n\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t"; } else { $sql = "INSERT INTO exercises\n\t\t\t\t\t(exercisename, date, created,calories,minutes)\n\t\t\t\t\tVALUES ('{$row2['exercisename']}', '{$row2['date']}', Now() , '{$row['calories']}', '{$row['minutes']}')"; } $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); $row2['dob'] = date('Y-m-d H:i:s', strtotime($row2['dob'])); if (!empty($row['id'])) { $sql = "Update FitnessTracker_User\n\t\t\t\t\t\t\tSet name='{$row2['name']}', dob='{$row2['dob']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t"; } else { $sql = "INSERT INTO FitnessTracker_User\n\t\t\t\t\t\t(name, dob, created_at)\n\t\t\t\t\t\tVALUES ('{$row2['name']}', '{$row2['dob']}', Now() ) "; } //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); // $row2['Birthday'] = date( 'Y-m-d H:i:s', strtotime( $row2['Birthday'] ) ); if (!empty($row['meals_id'])) { $sql = "Update Meals Set Name ='{$row2['Name']}',Calories = '{$row['Calories']}, MealType = '{$row['MealType']} WHERE meals_id = {$row2['meal_id']}"; } else { $sql = "INSERT INTO Meals(Name, Calories, MealType) VALUES ('{$row2['Name']}', '{$row2['Calories']}', '{$row['MealType']}',Now() ) "; } //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); $row2['Date'] = date('Y-m-d H:i:s', strtotime($row2['Date'])); if (!empty($row['id'])) { $sql = "Update 2015Fall_WorkoutDate\n\t\t\t\t\t\t\tSet Name='{$row2['Name']}', Date='{$row2['Date']}', Calories='{$row2['Calories']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t"; } else { $sql = "INSERT INTO 2015Fall_WorkoutDate\n\t\t\t\t(Name, Date, created_at, Calories)\n\t\t\t\tVALUES ('{$row2['Name']}', '{$row2['Date']}', Now(), '{$row2['Calories']}') "; } //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
public static function Save(&$row) { $conn = GetConnection(); $row2 = escape_all($row, $conn); $row2['Birthday'] = date('Y-m-d H:i:s', strtotime($row2['Birthday'])); if (!empty($row['foods_id'])) { $sql = "Update Foods Set firstname='{$row2['firstname']}', Birthday='{$row2['Birthday']}' WHERE foods_id = {$row2['foods_id']}"; } else { $sql = "INSERT INTO Foods(firstname, Birthday, created_at) VALUES ('{$row2['firstname']}', '{$row2['Birthday']}', Now() ) "; } //my_print( $sql ); $results = $conn->query($sql); $error = $conn->error; if (!$error && empty($row['id'])) { $row['id'] = $conn->insert_id; } $conn->close(); return $error ? array('sql error' => $error) : false; }
$iid = $options['item']; $item_param = ItemParam($db, $iid); $ddb = GetDomainConnection($item_param["item_module"]); $ns = ""; $ns_num = 0; while (array_key_exists("ns" . $ns_num, $item_param)) { $ns .= $item_param["ns" . $ns_num] . " "; $ns_num++; } $ddb->query("UPDATE domain SET ns = '" . $ddb->real_escape_string($ns) . "' WHERE name = '" . $ddb->real_escape_string($item_param["domain"]) . "' AND status != 'deleted'"); } elseif ($command == "import") { // Get list of domains and contact. Import into BILLmanager $module = $options['module']; $search = array_key_exists("searchstring", $options) ? $options['searchstring'] : ""; $search_array = explode(" ", $search); $db = GetConnection(); $ddb = GetDomainConnection($module); $sub_query = ""; foreach ($search_array as $domain) { if ($domain == "") { continue; } if ($sub_query == "") { $sub_query .= " AND name in ("; } else { $sub_query .= ","; } $sub_query .= "'" . $ddb->real_escape_string($domain) . "'"; } if ($sub_query != "") { $sub_query .= ")";