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)
{
$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);
if (!empty($row['id'])) {
$sql = "Update 2014Fall_Food_Types\n\t\t\t\t\t\t\tSet Name='{$row2['Name']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t";
} else {
$sql = "INSERT INTO 2014Fall_Food_Types\n\t\t\t\t\t\t(Name, created_at)\n\t\t\t\t\t\tVALUES ('{$row2['Name']}', 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['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['Time'] = date('Y-m-d H:i:s', strtotime($row2['Time']));
if (!empty($row['id'])) {
$sql = "Update 2014Fall_Food_Eaten\n\t\t\t\t\t\t\tSet Name='{$row2['Name']}', Type_id='{$row2['Type_id']}', Calories='{$row2['Calories']}',\n\t\t\t\t\t\t\t\tFat='{$row2['Fat']}', Carbs='{$row2['Carbs']}', Fiber='{$row2['Fiber']}', Time='{$row2['Time']}'\n\t\t\t\t\t\tWHERE id = {$row2['id']}\n\t\t\t\t\t\t";
} else {
$sql = "INSERT INTO 2014Fall_Food_Eaten\n\t\t\t\t\t\t(Name, Type_id, Calories, Fat, Carbs, Fiber, Time, created_at, UserId)\n\t\t\t\t\t\tVALUES ('{$row2['Name']}', '{$row2['Type_id']}', '{$row2['Calories']}', '{$row2['Fat']}', '{$row2['Carbs']}', '{$row2['Fiber']}', '{$row2['Time']}', Now(), 3 ) ";
}
//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;
}
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;
}
