Shamma Mohammed

حذفت الكلام اللي كنت حاطه هنا داخل textarea وضبط صار يضيف ويحدث بس ان شاء الله يكون هذا السبب مايعلق مره ثانيه

if (isset($_POST['submit'])) { $name=$_POST['name']; $descr=$_POST['descr']; $info=$_POST['info']; $price=$_POST['price']; $qty=$_POST['qty']; $sku=$_POST['SKU']; $si=$_POST['size']; $chkt=implode(",",$si); $descrebtion =$_POST['descrebtion']; $discount =$_POST['discount']; $created_at= date('Y-m-d H:i:s'); $img_name = $_FILES['uploadfile1']['name']; $img_type = $_FILES['uploadfile1']['type']; $tmp_name = $_FILES['uploadfile1']['tmp_name']; $img_name2 = $_FILES['uploadfile2']['name']; $img_type2 = $_FILES['uploadfile2']['type']; $tmp_name2 = $_FILES['uploadfile2']['tmp_name']; $img_name3 = $_FILES['uploadfile3']['name']; $img_type3 = $_FILES['uploadfile3']['type']; $tmp_name3 = $_FILES['uploadfile3']['tmp_name']; $img_name4 = $_FILES['uploadfile4']['name']; $img_type4 = $_FILES['uploadfile4']['type']; $tmp_name4 = $_FILES['uploadfile4']['tmp_name']; $img_explode = explode(".",$img_name); $img_ext = end($img_explode); $img_explode2 = explode(".",$img_name2); $img_ext2 = end($img_explode2); $img_explode3 = explode(".",$img_name3); $img_ext3 = end($img_explode3); $img_explode4 = explode(".",$img_name4); $img_ext4 = end($img_explode4); $extension= ['png','jpeg','jpg','gif']; $Get_image_name = $_FILES['uploadfile1']['name']; $image_Path = "img/".basename($Get_image_name); $Get_image_name2 = $_FILES['uploadfile2']['name']; $image_Path2 = "img/".basename($Get_image_name2); $Get_image_name3 = $_FILES['uploadfile3']['name']; $image_Path3 = "img/".basename($Get_image_name3); $Get_image_name4 = $_FILES['uploadfile4']['name']; $image_Path4 = "img/".basename($Get_image_name4); $sql ="INSERT INTO product(name,descr,info, price ,qty ,img1 ,img2 ,img3 ,img4 ,SKU, size,disc_id ,cate_id,created_at) VALUES ('$name','$descr' ,'$info', '$price','$qty' ,'$Get_image_name','$Get_image_name2' ,'$Get_image_name3' ,'$Get_image_name4' ,'$sku' ,'$chkt' ,'$discount','$descrebtion','$created_at')"; mysqli_query($conn,$sql); //mysqli_query($conn,("ALTER TABLE `product` DROP FOREIGN KEY `cat`; ALTER TABLE `product` ADD CONSTRAINT `cat` FOREIGN KEY (`cate_id`) REFERENCES `productcategory`(`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `product` DROP FOREIGN KEY `disc`; ALTER TABLE `product` ADD CONSTRAINT `disc` FOREIGN KEY (`disc_id`) REFERENCES `discount`(`id`) ON DELETE CASCADE ON UPDATE CASCADE")); if (move_uploaded_file($_FILES['uploadfile1']['tmp_name'], $image_Path)){ echo "<script>alert('Uploaded Successfully');</script> <script>window.location.href = 'addprodect.php'</script>"; }else{ echo "Not Insert Image"; } if (move_uploaded_file($_FILES['uploadfile2']['tmp_name'], $image_Path2)){ echo "<script>alert('Uploaded Successfully');</script> <script>window.location.href = 'addprodect.php'</script>"; }else{ echo "Not Insert Image"; } if (move_uploaded_file($_FILES['uploadfile3']['tmp_name'], $image_Path3)){ echo "<script>alert('Uploaded Successfully');</script> <script>window.location.href = 'addprodect.php'</script>"; }else{ echo "Not Insert Image"; } if(move_uploaded_file($_FILES['uploadfile4']['tmp_name'], $image_Path4)){ echo "<script>alert('Uploaded Successfully');</script> <script>window.location.href = 'addprodect.php'</script>"; }else{ echo "Not Insert Image"; } echo "<script>alert('Uploaded Successfully');</script> <script>window.location.href = 'addprodect.php'</script>"; } كود insert ^^ if (isset($_POST["update"])) { $id= $_GET['id']; $name=$_POST['name']; $descr=$_POST['descr']; $info=$_POST['info']; $price=$_POST['price']; $descrebtion=$_POST['descrebtion']; $sku=$_POST['sku']; $siz=$_POST['size']; $discount =$_POST['discount']; $chkt=implode(",",$siz); $created_at= date('Y-m-d H:i:s'); $img1=$_FILES["uploadfile1"]["name"]; $img2=$_FILES["uploadfile2"]["name"]; $img3=$_FILES["uploadfile3"]["name"]; $img4=$_FILES["uploadfile4"]["name"]; if ($img1 =="" ) { $sql="UPDATE product set name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); }else { $Get_image_name = $_FILES['uploadfile1']['name']; $image_Path = "img/".basename($Get_image_name); $sql="UPDATE product set img1='$Get_image_name' , name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); if (move_uploaded_file($_FILES['uploadfile1']['tmp_name'], $image_Path)){ echo "<script>alert('Updated Successfully');</script> <script>window.location.href = 'editprod.php'</script>"; }else{ echo "Not Insert Image"; } } if ($img2 =="" ) { $sql="UPDATE product set name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' ,size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); }else { $Get_image_name2 = $_FILES['uploadfile2']['name']; $image_Path2 = "img/".basename($Get_image_name2); $sql="UPDATE product set img2='$Get_image_name2' , name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); if (move_uploaded_file($_FILES['uploadfile2']['tmp_name'], $image_Path2)){ echo "<script>alert('Updated Successfully');</script> <script>window.location.href = 'editprod.php'</script>"; }else{ echo "Not Insert Image"; } } if ($img3 =="" ) { $sql="UPDATE product set name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); }else { $Get_image_name3 = $_FILES['uploadfile3']['name']; $image_Path3 = "img/".basename($Get_image_name3); $sql="UPDATE product set img3='$Get_image_name3' , name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); if (move_uploaded_file($_FILES['uploadfile3']['tmp_name'], $image_Path3)){ echo "<script>alert('Updated Successfully');</script> <script>window.location.href = 'editprod.php'</script>"; }else{ echo "Not Insert Image"; } } if ($img4 =="" ) { $sql="UPDATE product set name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); }else { $Get_image_name4 = $_FILES['uploadfile4']['name']; $image_Path4 = "img/".basename($Get_image_name4); $sql="UPDATE product set img4='$Get_image_name4' , name= '$name' ,descr ='$descr', info= '$info', price=$price, cate_id='$descrebtion' ,disc_id='$discount', SKU='$sku' , size='$chkt' , created_at='$created_at' where id=$id "; mysqli_query($conn, $sql); if (move_uploaded_file($_FILES['uploadfile4']['tmp_name'], $image_Path4)){ echo "<script>alert('Updated Successfully');</script> <script>window.location.href = 'editprod.php'</script>"; }else{ echo "Not Insert Image"; } } echo "<script>alert('Updated final Successfully');</script> <script>window.location.href = 'editprod.php'</script>"; } كود update ^^ descrebtion و discount هي FK

عندي صفحتين في php اضافة insert وتحديث update الى قاعدة البيانات كان يعمل الكود لاكن الان اصبح يدخل احيانن فقط مدخل وبعدها لايدخل شي او مايدخل شيء نهائيا مع ان الكود صحيح مايظهر اي ايرور والاتصال بقاعدة البيانات يعمل وكذلك مع التحديث مره يحدث ومره لا !!! ملاحظة عندي صفحات ثانيه بنفس المشروع اضافه وتحديث تعمل عادي

السلام عليكم كيف احذف بواسطة id تبع جدول wishlist بدل id تبع product في هذه الصفحة الاكواد هنا يوضح اكثر كود select <?php $res=mysqli_query($conn,"select * from wishlist inner join product on wishlist.prodect = product.id where user_id = '$user_id' " )or die('query failed'); if(mysqli_num_rows($res) > 0){ while ($row=mysqli_fetch_assoc($res)) { ?> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <a href="prodect.php?id=<?php echo $row['id']; ?>"><img src="admin/img/<?php echo $row["img1"];?>" class="img-responsive" alt="Portfolio"/></a> </div> <div class="detail"> <h2><?php echo $row["name"];?></h2> <span><?php echo $row["descr"];?></span> <h4>$<?php echo $row["price"];?></h4> <a href="user.php?remove=<?php echo $row['id']; ?>" class="delete-btn" onclick="return confirm('remove item from favorit?');">remove</a> </div> </div> <?php } }؟> كود delete <?php if(isset($_GET['remove'])){ $remove_id = $_GET['remove']; mysqli_query($conn, "DELETE FROM wishlist WHERE id = $remove_id ") or die('query failed'); } ?>

اريد اختيار الحجم من جدول المنتج والحجم تمت اضافته الى قاعدة البيانات في صف واحد (مثل الصورة) بستخدام checkbox ، هل ممكن اني اعمل لها select في صفحة المنتج وتكون كل قيمة على شكل input radio او checkbox

السلام عليكم المشكلة : الكود عباره عن تحديث كمية المنتج في الشوبنق كارت السعر يظهر بشكل نص لذلك لايمكنني ادخاله الى قاعدة البيانات بستخدام php و mysql المطلوب : اريد تحويل كود الجافاسكربت الى php كي استطيع ادخال ال grand total الى قاعدة البيانات او اذا كان يوجد طريقة اخرى شكرا كود php بالمختصر <table> <thead> <th><h6>Price</h6></th> <th><h6>quantity</h6></th> <th><h6>total</h6></th> <th><h6>grand total</h6></th> </thead> <tbody> <td>$<?php echo $row['price']; ?><input type="hidden" class="iprice" value="<?php echo $row['price']; ?>"></td> <td><input type="number" min="1" max="10" name="quantity" class="iquantity" onchange="subTotal()" value="1"> </td> <td class="itotal"></td> <td><h6 id="gtotal"></h6></td> </tbody> </table> كود جافاسكربت var gt=0; var iprice=document.getElementsByClassName('iprice'); var iquantity=document.getElementsByClassName('iquantity'); var itotal=document.getElementsByClassName('itotal'); var gtotal=document.getElementById('gtotal'); function subTotal() { gt=0; for ( i = 0; i < iprice.length; i++) { itotal[i].innerText=(iprice[i].value)*(iquantity[i].value); gt=gt+(iprice[i].value)*(iquantity[i].value); } gtotal.innerText=gt; } subTotal();

شكرا لك عرفت حل المشكلة جزاك الله خيرا

لايوجد رسالة خطا بس كود الجافاسكربت مايعمل سجلت هذا الفيديو للتوضيح ‏تسجيل_الشاشة_١٤٤٣-٠٧-٢١_في_٧.٤٥.١٥ ص.mov

السلام عليكم عندي هذا الكود كان بعمل جيدا لاكن بعد ان ربطته بداتابيس وحولته الى php صار فيه مشكلة في كود الجافاسكربت كود php <?php include 'db/config.php'; ?> <section class="portfolio"> <div class="container"> <div class="row"> <div class="col-md-12 col-sm-12"> <div class="iso-section wow fadeInUp" > <ul class="indicator clearfix"> <li data-filter="all" class="active opc-main-bg"><a href="#">All Dress</a></li> <li data-filter="long" class="opc-main-bg"><a href="#">long Dress</a></li> <li data-filter="short" class="opc-main-bg"><a href="#">short Dress</a></li> <li data-filter="medium" class="opc-main-bg"><a href="#">mediam Dress</a></li> </ul> <div class="filter-condition"> <span>View As a</span> <select id="select"> <option value="Default">Default</option> <option value="LowToHigh">Low to high</option> <option value="HighToLow">High to low</option> </select> </div> <div class="iso-box-section wow fadeInUp" > <div class="iso-box-wrapper col4-iso-box"> <?php $res=mysqli_query($conn , "select * from productcategory inner join product on productcategory.id = product.cate_id where productcategory.name = 'Dress'"); while ($row=mysqli_fetch_array($res)) { ?> <ul class="items"> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="admin/img/<?php echo $row["img1"];?>" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2><?php echo $row["name"];?></h2> <strong><?php echo $row["descrebtion"];?></strong> <span><?php echo $row["descr"];?></span> <h4>$<?php echo $row["price"];?></h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> </ul> <?php } ?> </div> </div> </div> </div> </div> </div> </section> كود JavaScript (function() { let field = document.querySelector('.items'); let li = Array.from(field.children); function FilterProduct() { for(let i of li){ const name = i.querySelector('strong'); const x = name.textContent; i.setAttribute("data-category", x); } let indicator = document.querySelector('.indicator').children; this.run = function() { for(let i=0; i<indicator.length; i++) { indicator[i].onclick = function () { for(let x=0; x<indicator.length; x++) { indicator[x].classList.remove('active'); } this.classList.add('active'); const displayItems = this.getAttribute('data-filter'); for(let z=0; z<li.length; z++) { li[z].style.transform = "scale(0)"; setTimeout(()=>{ li[z].style.display = "none"; }, 500); if ((li[z].getAttribute('data-category') == displayItems) || displayItems == "all") { li[z].style.transform = "scale(1)"; setTimeout(()=>{ li[z].style.display = "block"; }, 500); } } }; } } } function SortProduct() { let select = document.getElementById('select'); let ar = []; for(let i of li){ const last = i.lastElementChild.querySelector('h4'); const x = last.textContent.trim(); const y = Number(x.substring(1)); i.setAttribute("data-price", y); console.log(y); ar.push(i); } this.run = ()=>{ addevent(); } function addevent(){ select.onchange = sortingValue; } function sortingValue(){ if (this.value === 'Default') { while (field.firstChild) {field.removeChild(field.firstChild);} field.append(...ar); } if (this.value === 'LowToHigh') { SortElem(field, li, true) } if (this.value === 'HighToLow') { SortElem(field, li, false) } } function SortElem(field,li, asc){ let dm, sortli; dm = asc ? 1 : -1; sortli = li.sort((a, b)=>{ const ax = Number(a.getAttribute('data-price')); const bx = Number(b.getAttribute('data-price')); return ax > bx ? (1*dm) : (-1*dm); }); while (field.firstChild) {field.removeChild(field.firstChild);} field.append(...sortli); } } new FilterProduct().run(); new SortProduct().run(); })();

السلام عليكم عندي مشكلة مع هذا الكود الفونكشن الاولى function FilterProduct() هذه تعمل صح لكن الفونكشن الثانية function SortProduct() لاتعمل متلخبطة ماتترتب بحسب السعر لااعرف مالمشكلة كود HTML <html> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css"/> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" crossorigin="anonymous"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css"> <link rel="stylesheet" href="bootstrap-4.1.3-dist/css/bootstrap.min.css"> <link rel="stylesheet" type="text/css" href="fontawesome-5/fontawesome-css/all.css"> <link rel="stylesheet" href="css/bootstrap.min.css"> <!-- style CSS --> <link rel="stylesheet" href="css/shop.css"> </head> <body> <!-- Navigation section ================================================== --> <?php include"nav.php"; ?> <!-- Header section ================================================== --> <section id="portfolio"> <div class="container"> <div class="row"> <div class="col-md-12 col-sm-12"> <div class="iso-section wow fadeInUp" > <ul class="indicator clearfix"> <li data-filter="all" class="active opc-main-bg"><a href="#">All Dress</a></li> <li data-filter="long" class="opc-main-bg"><a href="#">long Dress</a></li> <li data-filter="short" class="opc-main-bg"><a href="#">short Dress</a></li> <li data-filter="mediam" class="opc-main-bg"><a href="#">mediam Dress</a></li> </ul> <div class="filter-condition"> <span>View As a</span> <select name="" id="select"> <option value="Default">Default</option> <option value="LowToHigh">Low to high</option> <option value="HighToLow">High to low</option> </select> </div> <div class="iso-box-section wow fadeInUp" > <div class="iso-box-wrapper col4-iso-box"> <ul class="items"> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/pexels-maksim-goncharenok-4424269.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>Mango</h2> <strong>long</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$50.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/pexels-maksim-goncharenok-4424216.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>H&M</h2> <strong>short</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$30.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/pexels-cottonbro-10433903.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>ZARA</h2> <strong>mediam</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$100.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/pexels-eko-agalarov-10579860.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>Dior</h2> <strong>mediam</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$160.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/dress.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>max</h2> <strong>long</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$43.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> <li data-category="" data-price=""> <div class="iso-box col-md-4 col-sm-6"> <div class="portfolio-thumb"> <img src="img/pexels-eyup-beyhan-8517815.jpg" class="img-responsive" alt="Portfolio"/> </div> <div class="detail"> <h2>fendy</h2> <strong>short</strong> <span>Lorem, ipsum dolor sit amet consectetur.</span> <h4>$700.78</h4> <a href="#"><i class="fas fa-shopping-cart"></i></a> <a href="#"><i class="fas fa-heart"></i></a> </div> </div> </li> </ul> </div> </div> </div> </div> </div> </div> </section> <!-- Footer section ================================================== --> <?php include"footer.php"; ?> <!-- Javascript ================================================== --> <script src="js/search.js"></script> <script type="text/javascript" src="js/main.js"></script> </body> </html> كود JavaScript (function() { let field = document.querySelector('.items'); let li = Array.from(field.children); function FilterProduct() { for(let i of li){ const name = i.querySelector('strong'); const x = name.textContent; i.setAttribute("data-category", x); } let indicator = document.querySelector('.indicator').children; this.run = function() { for(let i=0; i<indicator.length; i++) { indicator[i].onclick = function () { for(let x=0; x<indicator.length; x++) { indicator[x].classList.remove('active'); } this.classList.add('active'); const displayItems = this.getAttribute('data-filter'); for(let z=0; z<li.length; z++) { li[z].style.transform = "scale(0)"; setTimeout(()=>{ li[z].style.display = "none"; }, 500); if ((li[z].getAttribute('data-category') == displayItems) || displayItems == "all") { li[z].style.transform = "scale(1)"; setTimeout(()=>{ li[z].style.display = "block"; }, 500); } } }; } } } function SortProduct() { let select = document.getElementById('select'); let ar = []; for(let i of li){ const last = i.lastElementChild; const x = last.textContent.trim(); const y = Number(x.substring(1)); i.setAttribute("data-price", y); ar.push(i); } this.run = ()=>{ addevent(); } function addevent(){ select.onchange = sortingValue; } function sortingValue(){ if (this.value === 'Default') { while (field.firstChild) {field.removeChild(field.firstChild);} field.append(...ar); } if (this.value === 'LowToHigh') { SortElem(field, li, true) } if (this.value === 'HighToLow') { SortElem(field, li, false) } } function SortElem(field,li, asc){ let dm, sortli; dm = asc ? 1 : -1; sortli = li.sort((a, b)=>{ const ax = a.getAttribute('data-price'); const bx = b.getAttribute('data-price'); return ax > bx ? (1*dm) : (-1*dm); }); while (field.firstChild) {field.removeChild(field.firstChild);} field.append(...sortli); } } new FilterProduct().run(); new SortProduct().run(); })();

السلام عليكم عندي مشكلة جربت الكثير من اكواد تحميل الصوره الى مجلد في الجهاز لاكن لم يضبط اي كود منهم هل لنظام ماك طريقة خاصة ؟ استخدم XAMPP الكود : <?php error_reporting(0); ?> <?php $host = "localhost:3306"; $dbUsername = "root"; $dbPassword = ""; $dbname = "photos"; $db = mysqli_connect($host, $dbUsername, $dbPassword, $dbname); if (!$db) { die("Connection failed: " .mysqli_connect_error()); } $msg = ""; // If upload button is clicked ... if (isset($_POST['upload']) && isset($_FILES['uploadfile'])){ $category=$_POST['category']; $img_name = $_FILES['uploadfile']['name']; //getting user uploaded name $img_type = $_FILES['uploadfile']['type']; //getting user uploaded img type $tmp_name = $_FILES['uploadfile']['tmp_name']; //this temporary name is used to save/move file in our folder. // let's explode image and get the last name(extension) like jpg, png $img_explode = explode(".",$img_name); $img_ext = end($img_explode); //here we get the extension of an user uploaded img file $extension= ['png','jpeg','jpg','gif']; // Get the name of images $Get_image_name = $_FILES['uploadfile']['name']; // image Path $image_Path = "sora/".basename($Get_image_name); $sql = "INSERT INTO image (filename, category) VALUES ('$Get_image_name', '$category')"; // Run SQL query mysqli_query($db, $sql); if (move_uploaded_file($_FILES['uploadfile']['tmp_name'], $image_Path)) { echo "Your Image uploaded successfully"; }else{ echo "Not Insert Image"; } } ?> <!DOCTYPE html> <html> <head> <title>Image Upload</title> <form method="POST" action="" enctype="multipart/form-data"> <table> <tr> <td>Theme image</td> <td> <input type="file" name="uploadfile" value=""/> </td> </tr> <tr> <td>Theme category</td> <td> <select name="category"> <option value="">...</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> </select> </td> </tr> <tr> <td> <button type="submit" name="upload">UPLOAD</button> </td> </tr> </table> </form> </body> </html>