PHP SQLObject::exec Exemples

Exemple #1

Fichier : updates_global.uninstall.php Projet : jankuca/smog-cms

<?php

$sql = new SQLObject();
$query = "DELETE FROM " . $sql->table('modules') . "\r\nWHERE (filename = '" . $_GET['module_codename'] . ".mod.php')";
if ($sql->exec($query)) {
    echo '  [<strong>x</strong>] sql> ' . str_replace("\r\n", ' ', $query) . "\n";
} else {
    echo '  [ ] sql> ' . str_replace("\r\n", ' ', $query) . "\n";
}
$query = "DROP TABLE " . $sql->table('updates_global');
if ($sql->exec($query)) {
    echo '  [<strong>x</strong>] sql> ' . str_replace("\r\n", ' ', $query) . "\n";
} else {
    echo '  [ ] sql> ' . str_replace("\r\n", ' ', $query) . "\n";
}

Exemple #2

Fichier : auth.mod.php Projet : jankuca/smog-cms

 public function setLoginTime()
 {
     $sql = new SQLObject();
     if ($sql->exec("UPDATE " . $sql->table('auth_users') . " SET login_last_time = " . time() . " WHERE (user_id = " . $_SESSION['user']['id'] . ")")) {
         return true;
     } else {
         return false;
     }
 }