Ejemplos de cbSQLConnect::SQLUpdate en PHP

Ejemplo n.º 1

Archivo: delete.php Proyecto: Rotron/jQuery-Sortable-and-PHP

<?php

include "connect.php";
$database = new cbSQLConnect($databaseSetup, cbSQLConnectVar::FETCH_ASSOC);
$data = $_POST["choices"];
foreach ($data as $value) {
    $newid = str_replace('cb-', '', $value);
    $database->SQLUpdate("bookmarks", "estado", "0", "id", (int) $newid);
}
echo $var;

Ejemplo n.º 2

Archivo: order.php Proyecto: Rotron/jQuery-Sortable-and-PHP

<?php

include "connect.php";
$database = new cbSQLConnect($databaseSetup, cbSQLConnectVar::FETCH_ASSOC);
$data = $_POST["choices"];
$newarray = explode("&", $data[0]);
$i = count($newarray);
foreach ($newarray as $key => $value) {
    $ides = explode("=", $value);
    $database->SQLUpdate("bookmarks", "orden", $i, "id", (int) $ides[1]);
    $i--;
}
//print_r($data[0]);

Ejemplo n.º 3

Archivo: insert.php Proyecto: Rotron/jQuery-Sortable-and-PHP

<?php

include "connect.php";
$database = new cbSQLConnect($databaseSetup, cbSQLConnectVar::FETCH_ASSOC);
$date = date('Y-m-d H:i:s');
$id = str_replace('img-', '', $_POST["id"]);
$url = $_POST["url"];
if (!empty($id)) {
    $database->SQLUpdate("bookmarks", "url", $url, "id", $id);
} else {
    // Count rows for order
    $count = $database->QuerySingle("SELECT count(*) AS total FROM bookmarks");
    $insert = $database->SQLInsert(array(array('id' => null, 'url' => $url, 'fecha' => $date, 'orden' => (int) $count[0]['total'] + 1, 'estado' => '1')), "bookmarks");
    // return true if sucess or false
    echo $insert;
}