function modify() { if (!isset($_POST['submit_modify'])) { //Mostrar plantilla vacía return 0; } else { //Introducir los datos de post. //Si se modificó la foto if ($_SESSION['ruta_temporal'] != "") { $file = new upload_file($_SESSION['nombre_photo'], $_SESSION['ruta_temporal'], $_SESSION['tamanno_photo'], $this->id_service, $this->path_photo); $result = $file->upload("images/services/"); } $this->get_fields_from_post(); //$this->insert_post(); //Validacion //Modificamos los todos los valores del objeto fields con los nuevos datos del objeto product, exceptuando path_photo que eso se deberia hacer mediante la clase upload. $this->fields_list->modify_value($this->ddbb_id_service, $this->id_service); $this->fields_list->modify_value($this->ddbb_id_corp, $this->id_corp); $this->fields_list->modify_value($this->ddbb_descrip, $this->descrip); $this->fields_list->modify_value($this->ddbb_name, $this->name); $this->fields_list->modify_value($this->ddbb_name_web, $this->name_web); $this->fields_list->modify_value($this->ddbb_pvp, $this->pvp); $this->fields_list->modify_value($this->ddbb_tax, $this->tax); $this->fields_list->modify_value($this->ddbb_pvp_tax, $this->pvp_tax); //validamos $return = $this->fields_list->validate(); //En caso de que la validacion haya sido fallida se muestra la plantilla //con los campos erroneos marcados con un * // $return=true; //Para pruebas dejar esta linea sin comentar if (!$return) { //Mostrar plantilla con datos erroneos } else { $ADODB_FETCH_MODE = ADODB_FETCH_BOTH; //crea una nueva conexin con una bbdd (mysql) $this->db = NewADOConnection($this->db_type); //le dice que no salgan los errores de conexin de la ddbb por pantalla $this->db->debug = false; //realiza una conexin permanente con la bbdd $this->db->Connect($this->db_ip, $this->db_user, $this->db_passwd, $this->db_name); //mete la consulta para coger los campos de la bbdd $this->sql = "SELECT * FROM " . $this->table_prefix . $this->table_name . " WHERE " . $this->ddbb_id_service . " = \"" . $this->id_service . "\""; //la ejecuta y guarda los resultados $this->result = $this->db->Execute($this->sql); //si falla if ($this->result === false) { $this->error = 1; $this->db->close(); return 0; } //rellenamos el array con los datos de los atributos de la clase $record = array(); $record[$this->ddbb_id_service] = $this->id_service; $record[$this->ddbb_id_corp] = $this->id_corp; $record[$this->ddbb_name] = $this->name; $record[$this->ddbb_name_web] = $this->name_web; $record[$this->ddbb_pvp] = $this->pvp; $record[$this->ddbb_tax] = $this->tax; $record[$this->ddbb_pvp_tax] = $this->pvp_tax; $record[$this->ddbb_descrip] = $this->descrip; //calculamos la sql de insercin respecto a los atributos $this->sql = $this->db->GetUpdateSQL($this->result, $record); //insertamos el registro $this->db->Execute($this->sql); //si se ha insertado una fila $Affected_Rows = $this->db->Affected_Rows(); $return_categories = $this->modify_categories(); if ($Affected_Rows == 1 || $this->sql == "" || $return_categories == 1) { //capturammos el id de la linea insertada $this->db->close(); //devolvemos el id de la tabla ya que todo ha ido bien return $this->id_service; } else { //devolvemos 0 ya que no se ha insertado el registro $this->error = -1; $this->db->close(); return 0; } } } }
$_POST[idx] += 0; $_POST['mini_url'] = trim($_POST['mini_url']); if ($_POST['mini_url'] != '' && $_POST['mini_url'] != 'http://') { $src = $_POST['mini_url']; } else { //$dir = "data/"; $dir = "../../data/editor/"; if (!preg_match("/^image/", $_FILES[mini_file][type])) { echo "<script>alert('이미지 파일만 업로드가 가능합니다');</script>"; exit; } if (is_uploaded_file($_FILES[mini_file][tmp_name])) { $div = explode(".", $_FILES[mini_file][name]); $filename = time() . "." . $div[count($div) - 1]; $upload = new upload_file($_FILES['mini_file'], $dir . $filename, 'image'); if (!$upload->upload()) { echo "<script>alert('이미지 파일만 업로드가 가능합니다');</script>"; exit; } setDu('editor'); # 계정용량 계산 } $src = dirname($_SERVER[PHP_SELF]) . "/" . $dir . $filename; } if ($_POST[imgWidth] && $_POST[imgHeight]) { $size = " width='{$_POST['imgWidth']}' height='{$_POST['imgHeight']}'"; } if ($src) { echo "<script>parent.opener.mini_set_html({$_POST['idx']},\"<img src='{$src}' {$size}>\");</script>"; } echo "<script>parent.window.close();</script>";
//沒有找到要上傳的檔案 UPLOAD_ERR_NO_FILE $this->upfile_error = "沒有找到要上傳的檔案"; break; case 5: //伺服器臨時檔案遺失 $this->upfile_error = "伺服器臨時檔案遺失"; break; case 6: //檔案寫入到站存資料夾錯誤 UPLOAD_ERR_NO_TMP_DIR $this->upfile_error = "檔案寫入到暫存資料夾錯誤"; break; case 7: //無法寫入硬碟 UPLOAD_ERR_CANT_WRITE $this->upfile_error = "無法寫入硬碟"; break; case 8: //UPLOAD_ERR_EXTENSION $this->upfile_error = "PHP擴充功能影響上傳"; break; } echo $this->upfile_error; } } } if (@$_POST['submit']) { $upload = new upload_file(); $upload->upload(); } ?> </body> </html>
function modify() { if (!isset($_POST['submit_modify'])) { return 0; } else { //Introducir los datos de post. //Si se modificó la foto if ($_SESSION['ruta_temporal'] != "") { $file = new upload_file($_SESSION['nombre_photo'], $_SESSION['ruta_temporal'], $_SESSION['tamanno_photo'], $this->id_vehicle, $this->path_photo); $result = $file->upload("images/vehicles/"); if ($result == 1) { //modificar ruta de la foto $this->modify_photo($this->id_vehicle); } } $this->get_fields_from_post(); //$this->insert_post(); $this->fields_list->modify_value($this->ddbb_id_vehicle, $this->id_vehicle); $this->fields_list->modify_value($this->ddbb_id_corp, $this->id_corp); $this->fields_list->modify_value($this->ddbb_number_plate, $this->number_plate); $this->fields_list->modify_value($this->ddbb_alias, $this->alias); //validamos $return = $this->fields_list->validate(); //Validacion //$return=validate_fields(); //En caso de que la validacion haya sido fallida se muestra la plantilla //con los campos erroneos marcados con un * if (!$return) { //Mostrar plantilla con datos erroneos return -1; } else { $ADODB_FETCH_MODE = ADODB_FETCH_BOTH; //crea una nueva conexin con una bbdd (mysql) $this->db = NewADOConnection($this->db_type); //le dice que no salgan los errores de conexin de la ddbb por pantalla $this->db->debug = false; //realiza una conexin permanente con la bbdd $this->db->Connect($this->db_ip, $this->db_user, $this->db_passwd, $this->db_name); //mete la consulta para coger los campos de la bbdd $this->sql = "SELECT * FROM " . $this->table_prefix . $this->table_name . " WHERE " . $this->ddbb_id_vehicle . " = \"" . $this->id_vehicle . "\""; //la ejecuta y guarda los resultados $this->result = $this->db->Execute($this->sql); //si falla if ($this->result === false) { $this->error = 1; $this->db->close(); return 0; } //rellenamos el array con los datos de los atributos de la clase $record = array(); $record[$this->ddbb_id_vehicle] = $this->id_vehicle; $record[$this->ddbb_id_corp] = $this->id_corp; $record[$this->ddbb_alias] = $this->alias; $record[$this->ddbb_number_plate] = $this->number_plate; $record[$this->ddbb_path_photo] = $this->path_photo; //calculamos la sql de insercin respecto a los atributos $this->sql = $this->db->GetUpdateSQL($this->result, $record); //insertamos el registro $this->db->Execute($this->sql); //si se ha insertado una fila $Affected_Rows = $this->db->Affected_Rows(); /*Al hacer la modificacion de categorias antes del siguiente "if" se debe de guardar en una variable el contenido de las filas afectadas y hacer la condicion del if con esa variable ya que al hacer las modificaciones ese valor varía. */ /* $return_category=$this->modify_category($this->id_emp); if(($Affected_Rows==1)||($user_changed!=0)||($this->sql=="")||($return_category!=0)) { //capturammos el id de la linea insertada $this->db->close(); //devolvemos el id de la tabla ya que todo ha ido bien return $this->id_vehicle; } else { //devolvemos 0 ya que no se ha insertado el registro $this->error=-1; $this->db->close(); return 0; }*/ $return_categories = $this->modify_categories(); if ($Affected_Rows == 1 || $this->sql == "" || $return_categories == 1) { //capturammos el id de la linea insertada $this->db->close(); //devolvemos el id de la tabla ya que todo ha ido bien return $this->id_vehicle; } else { //devolvemos 0 ya que no se ha insertado el registro $this->error = -1; $this->db->close(); return 0; } } } }