/** * 修改联系人信息 * @todo 未完成 * @param Group_Contact $group_contact 联系人信息 */ public function update($group_id, $contact, $mode = 'default') { $id = $contact->get_id(); switch ($mode) { case 'overwrite': $setters = array(); $setters['gid'] = $group_id; foreach ($this->map as $field) { $name = (string) $field->name; $getprop = (string) $field->accessor; if (in_array($name, array('uid', 'fid', 'formatted_name', 'phonetic', 'given_name', 'middle_name', 'family_name', 'prefix', 'suffix', 'organization', 'department', 'note', 'birthday', 'title', 'nickname', 'sort', 'modified'))) { $setters[$name] = call_user_func(array($contact, $getprop)); } } $sqls = $this->_edit_avatar($group_id, $id, $contact->get_avatar()); foreach (array('emails', 'tels', 'addresses', 'ims', 'urls', 'events', 'relations') as $type) { $sqls = array_merge($sqls, $this->_edit_info($group_id, $id, $type, call_user_func(array($contact, 'get_' . $type)))); } //更新数据库 $query = $this->db->update('gcp_contacts', $setters, array('gcid' => $id)); foreach ($sqls as $sql) { $this->db->query($sql); } $contact->set_modified_at($setters['modified']); return SUCCESS; break; } return FAIL; }
/** * 更新快照信息 * @param int $user_id 用户ID * @param int $history_id 快照ID * @param array $setters 更新内容 * @return bool */ public function update_history($user_id, $history_id, $setters) { $this->db->begin(); $query = $this->db->update($this->get_table($user_id, 'contact_history'), $setters, array('id' => $history_id)); if (!$query) { $this->db->rollback(); } return $this->db->commit(); }
} //end of for loop $sql = "SELECT img_loc FROM doc_imgs where doc_imgs.doc_id='" . $get_decument_id . "' "; $data = mysql_query($sql); $con->disconnect(); } //end of if statment if(isset($_POST['pleace'])) if (isset($_POST['change'])) { $sql = "SELECT c_id FROM documentation where c_num='" . $course_id . "' "; echo $sql; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $get_decument_id = $row['c_id']; echo $get_decument_id; } $con->update('documentation', array('course' => $course, 'event' => $event, 'c_name' => $course_name, 'c_num' => $course_id, 'c_location' => $pleace, 'c_collage_index' => $collage, 'c_dept' => $dept, 'c_price' => $price, 'c_gender' => $type, 'c_target_group' => $target, 'c_duration' => $how_long, 'c_req_num' => $at_least, 'c_reg_time' => $start_date, 'c_max_num' => $at_most, 'c_time_from' => $start_time, 'c_time_to' => $end_time, 'c_major' => $course_about, 'c_languate' => $language, 'c_goals' => $goals, 'c_doc_desc' => $description, 'c_notes' => $notes), array('c_id', $get_decument_id)); } if (isset($_POST['delete_course_id'])) { //echo "it is set <br/>"; $course_id = $_POST['delete_course_id']; $sql = "SELECT c_id FROM documentation where c_num='" . $course_id . "' "; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { $get_decument_id = $row['c_id']; } $con->delete('comunity_service', 'documentation', 'c_id="' . $get_decument_id . '"'); } //else{echo "not set";} } if (isset($_POST['delete_course_id'])) { //echo "it is set <br/>";
$aDatos['entreCalles'] = filter_input(INPUT_POST, "entreCalles"); $aDatos['colonia'] = filter_input(INPUT_POST, "colonia"); $aDatos['ciudad'] = filter_input(INPUT_POST, "ciudad"); $aDatos['estado'] = filter_input(INPUT_POST, "estado"); $aDatos['codigoPostal'] = filter_input(INPUT_POST, "codigoPost"); // Pestaña de Localizacion $aDatos['telefono'] = filter_input(INPUT_POST, "telefono"); $aDatos['fax'] = filter_input(INPUT_POST, "fax"); $aDatos['movil'] = filter_input(INPUT_POST, "movil"); $aDatos['email'] = filter_input(INPUT_POST, "email"); // Pestaña de Contacto $aDatos['contactoNombre'] = filter_input(INPUT_POST, "contactoNombre"); $aDatos['contactoTelefono'] = filter_input(INPUT_POST, "contactoTelefono"); $aDatos['contactoMail'] = filter_input(INPUT_POST, "contactoMail"); // Pestaña Extras $aDatos['direccionEntrega'] = filter_input(INPUT_POST, "direccionEntrega"); $aDatos['direccionCobro'] = filter_input(INPUT_POST, "direccionCobro"); $aDatos['comentario'] = filter_input(INPUT_POST, "comentarios"); $cDb = new DataBase(); if ($cIdCliente != "") { $sWhere = "idCliente = {$cIdCliente}"; $actualizado = $cDb->update("cliente", $aDatos, $sWhere); } else { $actualizado = $cDb->insert("cliente", $aDatos); } $Mensaje = "Datos del Cliente Guardados Correctamente"; if (!$actualizado) { $Mensaje = $cDb->LastError; } $return = array("correcto" => $actualizado, "mensaje" => $Mensaje); echo json_encode($return);
ob_end_clean(); echo '{"success":false,"message":"error: no columns given to query"}'; exit; } if ($objParseColumns->success == false) { ob_end_clean(); echo '{"success":false,"message":"error: no columns given to query"}'; exit; } $dataBase->parseJoin($strJoin); $dataBase->parseRestrictions($strRestrictions); $dataBase->parseOrderBy($strOrder); $dataBase->parseGroupBy($strGroupBy); $dataBase->parseLimit($strLimit); $dataBase->parseValues($strValues); ob_end_clean(); switch ($strQuery) { case 'SELECT': echo $dataBase->select(); break; case 'INSERT': echo $dataBase->insert(); break; case 'DELETE': echo $dataBase->delete(); break; case 'UPDATE': echo $dataBase->update(); break; } exit;
<?php session_start(); include '../dataBaseClass/connection.php'; $aDatos = array(); $idAgente = filter_input(INPUT_POST, "idAgente"); $aDatos['nombre'] = filter_input(INPUT_POST, "nombre"); $aDatos['clave'] = filter_input(INPUT_POST, "clave"); $aDatos['direccion'] = filter_input(INPUT_POST, "direccion"); $aDatos['email'] = filter_input(INPUT_POST, "email"); $aDatos['telefono'] = filter_input(INPUT_POST, "telefono"); $aDatos['movil'] = filter_input(INPUT_POST, "movil"); $cDb = new DataBase(); if ($idAgente != '') { $lCorrecto = $cDb->update("agente", $aDatos, "idAgente = '{$idAgente}'"); } else { $lCorrecto = $cDb->insert("agente", $aDatos, false); } $mensaje = "Datos del agente guardados correctamente"; if (!$lCorrecto) { $mensaje = "Error al tratar de guardar la informacion del agente: " . $cDb->LastError; } echo json_encode(array('correcto' => $lCorrecto, 'mensaje' => $mensaje));
$dbConfig = ""; die(json_encode(array('code' => 'error', 'comment' => 'no database type specified'))); } include $dbConnector; if (!hash_equals($authKey, crypt($auth, $authKey))) { header("HTTP/1.1 403 Forbidden"); die(json_encode(array('code' => 'error', 'comment' => 'auth failed with authkey: ' . $auth))); } $db = new DataBase($dbConfig); switch ($function) { case 'listall': echo $db->listall(); break; case 'save': if ($db->exists($itemName)) { echo $db->update($itemName, $itemCount); } else { echo $db->save($itemName, $itemCount); } break; case 'update': echo $db->update($itemName, $itemCount); break; case 'delete': echo $db->delete($itemName); break; case 'clear': echo $db->clear(); break; default: die(json_encode(array('code' => 'error', 'comment' => 'function not specified')));
echo json_encode($newArr); } // Список отзывов if ($_m == 'reviewList') { $limit = $_GET['limit']; $page = $_GET['page']; $from = $page * $limit - $limit; $array['result'] = $Db->select('SELECT * FROM reviews ORDER BY id DESC LIMIT ' . $from . ', ' . $limit); $array['total'] = $Db->count('SELECT count(*) FROM reviews'); $array['unread'] = $Db->count('SELECT count(*) FROM reviews WHERE visible = ' . $Db->quote(0)); echo json_encode($array); } // Список отзывов if ($_m == 'reviewListSetVisible') { $ids = json_decode($_GET['ids']); $Db->update('UPDATE reviews SET visible = ' . $Db->quote($_GET['visible']) . ' WHERE id IN (' . implode(',', array_map('intval', $ids)) . ')'); } if ($_m == 'userList') { $limit = $_GET['limit']; $page = $_GET['page']; $from = $page * $limit - $limit; $search = ''; if (strlen($_GET['search']) > 0) { $search = $_GET['search']; } $array['result'] = $Db->select(' SELECT id, login, f, i, o, date, type, email, (SELECT count(id) FROM reviews WHERE reviews.user = user.id) as reviewsCount FROM user WHERE user.login like "%' . $search . '%" ORDER BY id DESC
static function update($name, $array = array(), $nid) { $master = self::table_master($name); DataBase::update($master, $array, array('id=:id', array(':id' => $nid))); }
$user = $user[0]; sendMail($user['email'], Config::get('SITE_TITLE'), Config::get('SITE_TITLE'), 'Password reset', 'Dear ' . $user['firstname'] . ' ' . $user['lastname'] . ",<br /><br />Next to your request, your password will be reset. Click the link below to reset it.<br />If you didn't request us to reset your password, simply ignore this mail.<br /><br /><a href=\"http://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}?action=reset&token=" . $user['token'] . "\">Reset your password</a><br /><br /><small>Sent from Skyer</small>"); $showForgotSubmitted = true; } else { die('<h3>User not found</h3>'); } } else { $showForgot = true; } break; case 'reset': if (isset($_GET['token'])) { $user = DataBase::get('users', array(), array('token' => $_GET['token'])); if (count($user) && $user !== false) { $pass = md5(uniqid(rand(), true)); DataBase::update('users', array('password' => hash('sha384', $pass)), array('token' => $_GET['token'])); $showReset = true; } else { die('<h3>User not found</h3>'); } } else { die('<h3>Bad request</h3>'); } break; } } if (!User::isGuest() && (!isset($_GET['action']) || $_GET['action'] !== 'logout')) { header('Location: index.php'); } if (isset($_POST['submit']) && isset($_POST['pseudo']) && isset($_POST['password'])) { $displayForm = false;
session_start(); include './dataBaseClass/connection.php'; $aDatos = array(); $idCompania = filter_input(INPUT_POST, "IdCompania"); $aDatos['nombre'] = filter_input(INPUT_POST, "nombre"); $aDatos['direccion'] = filter_input(INPUT_POST, "direccion"); $aDatos['telefono'] = filter_input(INPUT_POST, "telefono"); $aDatos['portal'] = filter_input(INPUT_POST, "portal"); $aTipos = array(); if (isset($_POST['chkTipoPoliza'])) { $aTipos = $_POST['chkTipoPoliza']; } $cDb = new DataBase(); if ($idCompania != "") { $sWhere = "idCompania = {$idCompania}"; $lCorrecto = $cDb->update("Companias", $aDatos, $sWhere); } else { $lCorrecto = $cDb->insert("Companias", $aDatos); $idCompania = strval($cDb->LastInsertedId); } $mensaje = "Datos de la compañia guardados correctamente"; if (!$lCorrecto) { $mensaje = "Error al tratar de guardar la informacion de la compañia: " . mysqli_stmt_error($stmt); } if ($lCorrecto) { // Borramos los datos de los tipos de polizas y agregamos las nuevas seleccionadas $cDb->delete("TipoPolizaCompania", "idCompania = {$idCompania}"); foreach ($aTipos as $value) { $aData = array(); $aData['idCompania'] = $idCompania; $aData['idTipo'] = $value;
<?php session_start(); include '../dataBaseClass/connection.php'; $aDatos = array(); $id = filter_input(INPUT_POST, "idPaquete"); $tipoPoliza = filter_input(INPUT_POST, "tipoPoliza"); $cobertura = filter_input(INPUT_POST, "coberturaOrg"); $aDatos['idPaquete'] = filter_input(INPUT_POST, "idPaquete"); $aDatos['tipoPoliza'] = filter_input(INPUT_POST, "tipoPoliza"); $aDatos['cobertura'] = filter_input(INPUT_POST, "cobertura"); $cDb = new DataBase(); $lCorrecto = $cDb->update("Paquete", $aDatos, "idPaquete = '{$id}' AND tipoPoliza = '{$tipoPoliza}' AND cobertura = '{$cobertura}'"); $mensaje = "Datos del tipo de poliza guardados correctamente"; if (!$lCorrecto) { $mensaje = "Error al tratar de guardar la informacion del tipo de poliza: " . $cDb->LastError; } echo json_encode(array('correcto' => $lCorrecto, 'mensaje' => $mensaje));
$mail['sender_ID'] = $mail['sender']; $mail['sender'] = $sender['fullname']; $recipient = User::getUserFromID($mail['recipient']); $mail['recipient_ID'] = $mail['recipient']; $mail['recipient'] = $recipient['fullname']; die(json_encode($mail)); break; case 'move': $mail = DataBase::get('messages', array('sender', 'recipient'), array('ID' => $_GET['ID'])); if (count($mail) && $mail !== false) { $mail = $mail[0]; if ($mail['sender'] == User::getID()) { $r = DataBase::update('messages', array('sender_dir' => $_GET['dir']), array('ID' => $_GET['ID'], 'sender' => User::getID()))->fetch(); } else { if ($mail['recipient'] == User::getID()) { $r = DataBase::update('messages', array('recipient_dir' => $_GET['dir']), array('ID' => $_GET['ID'], 'recipient' => User::getID()))->fetch(); } else { die('<h3>Mail not found</h3>'); } } } else { die('<h3>That\'s not your mail !</h3>'); } die('true'); break; case 'unread': $unread = DataBase::query('SELECT COUNT(*) FROM messages WHERE opened = 0 AND recipient_dir = ' . DataBase::_secure($_GET['folder']) . ' AND recipient = ' . User::getID())->fetch()[0]; if (strval($unread)) { die($unread); } else { die;
$allowGuest = true; $hideDefaultView = true; require 'framework/inc.php'; Page::setTitle('Register'); Page::css('inspinia/plugins/iCheck/custom'); Page::css('register'); Page::js('inspinia/plugins/iCheck/icheck.min'); Page::js('register'); $registered = $activated = false; $err = ''; if (isset($_GET['activate'])) { $user = DataBase::get('users', array(), array('token' => $_GET['activate'])); if (count($user) && $user !== false) { $pass = md5(uniqid(rand(), true)); DataBase::update('users', array('activated' => 1), array('token' => $_GET['activate'])); $activated = true; } else { die('<h3>User not found</h3>'); } } elseif (isset($_POST['submit'])) { $required = array('pseudo', 'firstname', 'lastname', 'fullname', 'email', 'email-confirm', 'password', 'password-confirm'); foreach ($required as $i => $name) { if (!isset($_POST[$name])) { $err = 'All fields are required'; } else { $_POST[$name] = htmlspecialchars($_POST[$name]); } } if (strlen($_POST['pseudo']) < 5) { $err = 'Pseudo must be at least 5 characters';