realioseb / dashboard_realioseb Goto Github PK

$feed = array(
  "chanel" => "World News",
  "url" => "http://.../world-news",
  "items" => array(
    array(
      "title" => "Barak Obama Sucks",
      "author" => "Ioseb Dzmanashvili",
      "content" => "Barak Obama Really Sucks...",
      "url" => "http://.../barak-obama-sucks"
    ),
    array(
      "title" => "Puting is Bastard",
      "author" => "Ioseb Dzmanashvili",
      "content" => "Puting is Bastard and sucks more than Obama...",
      "url" => "http://.../putin-is-bastard"
    )
  )
);

function db_update($table, $data, $conditions) { }

function db_insert($table, $data) { }

function db_select($table, $conditions) { }

function db_delete($table, $conditions) { }

function db_query($query) { }

// SELECT * FROM users WHERE name='john'
$users = db_select("users", array(
  "name" => "john"
));

// SELECT * FROM users WHERE role='admin' AND sex='female'
$users = db_select("users", array(
  "role" => "admin",
  "sex"  => "female"
));

// INSERT INTO users
//  (first_name, last_name, email, password)
// VALUES
//  ('john', 'doe', '[email protected]', '1234123413241234')
//
$result = db_insert("users", array(
  "first_name" => "John",
  "last_name"  => "Doe",
  "email"      => "[email protected]",
  "password"   => md5("test"),
));

if ($result) {
  // do something meaningfull...
}

// UPDATE users
//  SET last_name='Doe Doe'
// WHERE
//  email='[email protected]
//
$result = db_update("users", array(
  "last_name" => "Doe Doe",
 ), array(
  "email" => "[email protected]"
));

// DELETE FROM users WHERE email='[email protected]'
// 
$result = db_delete("users", array(
  "email" => "[email protected]"
));