Add new cloth

link, $file_name); $type = pathinfo($file_name, PATHINFO_EXTENSION); $fileExists = true; while ($fileExists) { if (!file_exists($uploadDirectory.$uploaded_pic)) { $fileExists = false; } } move_uploaded_file($file_tmp,$uploadDirectory.$uploaded_pic); $mediaType = "something"; switch ($type) { case "mp4": case "mkv": case "mov": case "ogg": case "webm": $mediaType = "video"; break; case "jpg": case "jpeg": case "gif": case "png": default: $mediaType = "image"; break; } } }else { $uploaded_pic = "uploads/articles/shop_logo.gif"; $mediaType = "pic"; } $userid=Session::get("id"); $name= mysqli_real_escape_string($db->link, $_POST["name"]); $colorvalue = mysqli_real_escape_string($db->link, $_POST["colorvalue"]); $trade = mysqli_real_escape_string($db->link, $_POST["trade"]); $fabricweight = mysqli_real_escape_string($db->link, $_POST["fabricweight"]); $description = mysqli_real_escape_string($db->link, $_POST["description"]); $careid = mysqli_real_escape_string($db->link, $_POST["strcode"]); $query = "INSERT INTO lab_tblcloth (name, colorvalue, trade, fabricweight, description, pic, type, modified, careid) VALUES('$name', '$colorvalue', '$trade', '$fabricweight', '$description', '$uploaded_pic', '$mediaType', NOW(), '$careid')"; $inserted_rows = $db->insert($query); if ($inserted_rows) { echo ''; }else { echo ''; } }else{ print_r($errors); } ?>
select($query); ?>

Description