PHP bd::doUpdate方法代码示例

             error_log("Error al subir foto");
             $img = "";
         }
     } else {
         $img = $_POST['img'];
     }
 } else {
     $img = "";
 }
 $message = cleanMessage($_POST['message'], $max_chars, $userid);
 if (!is_numeric($message) || $message > 5) {
     $fields = array('userid' => $userid, 'message' => $message, 'img' => $img, 'time_start' => $_POST['time_start'], 'time_end' => $_POST['time_end'], 'days' => $_POST['days'], 'hour' => $_POST['hour'], 'publish_fb' => $_POST['publish_fb'], 'publish_tw' => $_POST['publish_tw'], 'publish_fbp' => $_POST['publish_fbp'], 'publish_fbgp' => $_POST['publish_group']);
     if (is_array($fields = makeTimes($fields))) {
         if ($_POST['edit'] == true) {
             unset($fields['userid']);
             if ($hdb->doUpdate($table, $fields, " id=" . $hdb->quote($_POST['mes_id']) . " AND userid=" . $hdb->quote($userid))) {
                 $return = array("e" => 0, "c" => array("i" => $_POST['mes_id'], "m" => $fields['message'], "p" => $fields['img'], "ts_es" => formatTimeStamp($fields['time_start']), "ts_en" => date('Y-m-d', $fields['time_start']), "te_es" => formatTimeStamp($fields['time_end']), "te_en" => date('Y-m-d', $fields['time_end']), "t_p" => $fields['img'], "d" => $fields['days'], "h" => formatHour($fields['hour']), "tw" => $fields['publish_tw'], "fb" => $fields['publish_fb'], "fbp" => $fields['publish_fbp'], "gp" => $fields['publish_fbgp']));
             } else {
                 error_log($hdb->errorInfo());
                 $return = array("e" => 2);
             }
         } else {
             if ($hdb->doInsert($table, $fields)) {
                 $return = array("e" => 0, "c" => array("i" => $hdb->lastInsertId(), "m" => $fields['message'], "p" => $fields['img'], "ts_es" => formatTimeStamp($fields['time_start']), "ts_en" => date('Y-m-d', $fields['time_start']), "te_es" => formatTimeStamp($fields['time_end']), "te_en" => date('Y-m-d', $fields['time_end']), "t_p" => $fields['img'], "d" => $fields['days'], "h" => formatHour($fields['hour']), "tw" => $fields['publish_tw'], "fb" => $fields['publish_fb'], "fbp" => $fields['publish_fbp'], "gp" => $fields['publish_fbgp']));
             } else {
                 error_log($hdb->errorInfo());
                 $return = array("e" => 2);
             }
         }
     } else {
         $return = array("e" => $fields);

 $fbh = new Handler_Facebook();
 $hsc = new Handler_NewSocialConnection();
 $db = new bd();
 $permissions = ['user_posts', 'publish_actions', 'user_photos', 'manage_pages', 'publish_pages'];
 if ($info = $fbh->javascriptCallbackManager($permissions)) {
     $uid = $info['user_id'];
     $at = $info['access_token'];
     $table = "manager_fb_acc";
     $condition = " user_id=" . $uid;
     if ($result = $db->doSingleSelect($table, $condition)) {
         //account already belongs to a user
         if ($info["e"]) {
             //some error, could mean a lot of things, but whichever the case we need to expire all the accounts.
             $fbh->revokePermissions($at, array());
             $fields = array('expires_at' => 1, 'expired' => 1);
             $db->doUpdate($table, $fields, $condition);
             $return = array("e" => 2);
         } else {
             $ea = $info['expires_at'];
             $fields = array('access_token' => $at, 'expires_at' => $ea, 'expired' => 0);
             $db->doUpdate($table, $fields, $condition);
             switch ($login) {
                 case 0:
                     $return = array("e" => 1);
                     break;
                 case 1:
                     $userid = $result['userid'];
                     require_once "../../clases/usuarios.php";
                     $us = new usuario($userid);
                     $us->ingresoUsuarioPorID();
                     $hsc->clearFlow();

 public function actualizarPublicacion($parametros, $monto, $fotos)
 {
     $bd = new bd();
     $foto = new fotos();
     $condicion = "id={$this->id}";
     $params["titulo"] = ucwords(strtolower($params["titulo"]));
     $result = $bd->doUpdate("publicaciones", $parametros, $condicion);
     $params["monto"] = $monto;
     $this->setMonto($monto);
     $foto->path = "../../" . $foto->path;
     $listaFotos = $bd->doFullSelect("fotosxpublicaciones", "publicaciones_id={$this->id}");
     $result = $bd->query("delete from fotosxpublicaciones where publicaciones_id={$this->id}");
     $ultimafoto = $bd->query("select MAX(id) as ultimo from fotos");
     foreach ($ultimafoto as $key) {
         $ultima = $key["ultimo"];
     }
     $i = 0;
     $fila = 0;
     foreach ($fotos as $data) {
         if (substr($data, 0, 10) == "data:image") {
             $i++;
             $nueva = $ultima + $i;
             $data_url = $data;
             $data_url = str_replace(" ", "+", $data_url);
             $filteredData = substr($data_url, strpos($data_url, ",") + 1);
             //Decodificar la dataurl
             $unencodedData = base64_decode($filteredData);
             $bd->doInsert("fotos", array("id" => $nueva, "ruta" => "galeria/fotos/2015/12/"));
             $bd->doInsert("fotosxpublicaciones", array("fotos_id" => $nueva, "publicaciones_id" => $this->id));
             //subir la imagen
             $ruta = "../../../galeria/fotos/2015/12/{$nueva}.png";
             file_put_contents($ruta, $unencodedData);
         } else {
             $bd->doInsert("fotosxpublicaciones", array("fotos_id" => $listaFotos[$fila]["fotos_id"], "publicaciones_id" => $listaFotos[$fila]["publicaciones_id"]));
             $fila++;
         }
     }
     return true;
 }

function actualiza()
{
    $bd = new bd();
    $publi = new publicaciones($_POST["id"]);
    $monto = $_POST["monto"];
    $publi->setMonto($monto);
    $bd->doUpdate("publicaciones", array("titulo" => $_POST["titulo"], "stock" => $_POST["stock"], "monto" => $monto), "id={$_POST["id"]}");
}

function loadSession()
{
    $bd = new bd();
    $foto = new fotos();
    if (!isset($_SESSION)) {
        session_start();
    }
    $result = $bd->doSingleSelect("usuarios_accesos", "usuarios_id={$_POST["id"]}");
    $_SESSION["id"] = $result["usuarios_id"];
    $_SESSION["seudonimo"] = $result["seudonimo"];
    $_SESSION["nivel"] = $result["nivel"];
    $_SESSION["fotoperfil"] = $foto->buscarFotoUsuario($result["usuarios_id"]);
    $_SESSION["id_rol"] = $result["id_rol"];
    $bd->doUpdate("usuarios_accesos", array("bandera" => 0), "usuarios_id={$_POST["id"]}");
    echo "OK";
}

 public function setNewPassword($user, $clave)
 {
     $bd = new bd();
     $clave = hash("sha256", $clave);
     $actualizar = array('password' => $clave);
     //$parametro=$actualizar["password"]=$clave;
     $condicion = "usuarios_id={$user}";
     $result = $bd->doUpdate($this->a_table, $actualizar, $condicion);
     return $result;
 }

 public function updateUserGeneral($usuarios_id, $seudonimo = NULL, $email = NULL, $password = NULL, $id_rol = NULL)
 {
     $bd = new bd();
     $actualizar = array('seudonimo' => $seudonimo, 'email' => $email, 'id_rol' => $id_rol);
     //si cambiaron la contrase�a
     if (!empty($password)) {
         $password = hash("sha256", $password);
         $actualizar['password'] = $password;
     }
     $condicion = "usuarios_id={$usuarios_id}";
     $result = $bd->doUpdate($this->a_table, $actualizar, $condicion);
     return $result;
 }

 public function __set($property, $value)
 {
     if (property_exists($this, $property)) {
         $bd = new bd();
         $bd->doUpdate($this->table, array($property => $value));
         $this->{$property} = $value;
     }
 }

<?php

require_once "../../clases/bd.php";
$db = new bd();
session_start();
$uid = $_SESSION['id'];
$pid = $db->quote($_POST['id']);
$tw = $_POST['tw'] == 1 ? 1 : 0;
$fb = $_POST['fb'] == 1 ? 1 : 0;
$fbp = $_POST['fbp'] == 1 ? 1 : 0;
$gp = $_POST['gp'] == 1 ? 1 : 0;
$des = $_POST['des'];
$tabla = "publicaciones";
$fields = array("publicar_twitter" => $tw, "publicar_facebook" => $fb, "publicar_fanpage" => $fbp, "publicar_grupo" => $gp, "manager_des" => $des);
if ($db->doUpdate($tabla, $fields, " id={$pid} AND usuarios_id={$uid} ")) {
    $return = array("e" => 0);
} else {
    $return = array("e" => 1);
}
echo json_encode($return);