function edit_html_article($data, $cid, $uid) { $title = trim($data['title_updated']); //$video = trim($data['video_updated']); $body = trim($data['ck_updated']); //$cat_id = $data['edit_category']; $helper_obj = new Helper(); $db_functions_obj = new DbFunctions(); $tag_obj = new Tag(); $cat_obj = new Category(); $image1 = ""; if (isset($_FILES['image1_updated'])) { $image1_type = explode(".", $_FILES['image1_updated']['name']); $image1 = $helper_obj->generate_name() . '.' . $image1_type[1]; move_uploaded_file($_FILES["image1_updated"]["tmp_name"], VIDEOS_IMAGES_PATH_UPLOAD . $image1); $im = $helper_obj->img_resize(VIDEOS_IMAGES_PATH_UPLOAD . $image1, 620); $helper_obj->imageToFile($im, VIDEOS_IMAGES_PATH_UPLOAD . $image1, 100); $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_PATH_UPLOAD . $image1, THUMBNAIL_W, THUMBNAIL_H, THUMBNAIL_R, THUMBNAIL_ENABLE); $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_PATH_FEATURE_UPLOAD . $image1, FEATURE_W, FEATURE_H, THUMBNAIL_R, THUMBNAIL_ENABLE); //woman app if ($cid == 49) { $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_320x272_PATH_UPLOAD . $image1, IMAGE_320x272_W, IMAGE_320x272_H, THUMBNAIL_R, THUMBNAIL_ENABLE); $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_320x352_PATH_UPLOAD . $image1, IMAGE_320x352_W, IMAGE_320x352_H, THUMBNAIL_R, THUMBNAIL_ENABLE); } } $pgrate_id = $data['edit_pgrate']; $vid = $data['edit_article']; $section = $data['section_updated']; $time = time(); /*$query = "UPDATE articles_html set title = '$title', body = '$body', category_id = '$cat_id', pg_rated_id = '$pgrate_id', updated_by = '$uid', updated_date = '$time', video = '$video' ";*/ $query = "UPDATE articles_html set title = '{$title}', body = '{$body}',\n pg_rated_id = '{$pgrate_id}', updated_by = '{$uid}', updated_date = '{$time}' "; if ($image1 != "") { $query .= " ,image = '{$image1}'"; } $query .= " ,section = '{$section}'"; $query .= " WHERE client_id = '{$cid}' AND id = '{$vid}'"; // echo($query); //update tags //1- delete old tags //2- add new tags $db_functions_obj->delete_article_tags($vid); foreach ($data['edit_tag'] as $tag_id) { $tag_obj->add_tags_to_article($vid, $tag_id); } $this->delete_article_categories($vid); foreach ($data['edit_category'] as $cid) { $cat_obj->add_categories_to_article($vid, $cid); } $result = $this->conn->db_query($query); }