public static function executeUpdateQuery($properties, $table, $primaryKey, $connection = null) { try { if (is_null($connection)) { $connection = Connect::getDataInstance(); } $count = 0; $sql = "UPDATE " . $table . " SET "; foreach ($properties as $key => $value) { $count++; if ($key == 'id') { continue; } $sql .= "{$key} = ?"; if ($count < count($properties)) { $sql .= ", "; } } $sql .= " WHERE " . $primaryKey . " = ?"; $statement = $connection->prepare($sql); $indexCount = 0; foreach ($properties as $key => $value) { if ($key === 'id') { continue; } ++$indexCount; $statement->bindValue($indexCount, $value); } $statement->bindValue(++$indexCount, $properties['id']); $result = $statement->execute(); } catch (PDOException $e) { return $e->getMessage(); } return $result; }
public static function all($table, $connection = null) { $sql = "SELECT * FROM {$table}"; if (is_null($connection)) { $connection = Connect::getDataInstance(); } $result = $connection->prepare($sql); $result->execute(); return self::toJson($result->fetchAll(PDO::FETCH_ASSOC)); }
public static function where($column, $value, $table, $connections = null) { $sql = "SELECT * FROM {$table} WHERE {$column} = '{$value}'"; if (is_null($connections)) { $connections = Connect::getDataInstance(); } $result = $connections->prepare($sql); $result->execute(); return self::toJson($result->fetchAll(PDO::FETCH_ASSOC)); }