个人中心
gpt4 book ai didi

mysql - 我得到这样的东西 ,"Failed to load resource: the server responded with a status of 404 (Not Found)"

转载 作者：行者123 更新时间：2023-11-30 22:18:18 24 4
gpt4 key购买 nike

我正在从数据库中获取产品的详细信息。这是我的示例代码 我无法显示产品图片!谁能帮帮我吗？

将商品详情插入数据库的代码:

<!DOCTYPE>
<?php
include("includes/db.php");
?>
<html>
<head>
<title> Inserting product</title>

<script src="//tinymce.cachefly.net/4.1/tinymce.min.js"></script>
  <script>
  tinymce.init({ selector:'textarea' });
  </script>

</head>
<body bgcolor="skyblue">
<form action="insert_product.php" method="post" enctype="multipart/form-data">
   <table align="center" width="700" border="2" bgcolor="orange">
     <tr align="center">
          <td colspan="7"><h2>Insert New Post Here.</h2></td>
     </tr>
     <tr>
          <td align="right"><b>Product Title:</b></td>
          <td><input type="text" name="product_title" size="50" required /></td>
     </tr>
     <tr>
          <td align="right"><b>Product Category:</b></td>
          <td>
          <select name="product_cat" required>
          <option>Select a categogory</option>
            <?php 
            $get_cats = "select * from categories";
    $run_cats = mysqli_query($con, $get_cats);

    while($row_cats=mysqli_fetch_array($run_cats)){

        $cat_id = $row_cats['cat_id'];
        $cat_title = $row_cats['cat_title'];
        echo "<option value='$cat_id'>$cat_title</option>";
    }
            ?>
          </select>
          </td>
     </tr>
     <tr>
          <td align="right"><b>Product Brand:</b></td>
          <td>
          <select name="product_brand" required>
          <option>Select a Brand</option>
            <?php 
            $get_brands = "select * from brands";
    $run_brands = mysqli_query($con, $get_brands);

    while($row_brands=mysqli_fetch_array($run_brands)){

        $brand_id = $row_brands['brand_id'];
        $brand_title = $row_brands['brand_title'];
        echo "<option value='$brand_id'>$brand_title</option>";
    }
            ?>
          </select>
          </td>
     </tr>
     <tr>
          <td align="right"><b>Product Image:</b></td>
          <td><input type="file" name="product_image" required/></td>
     </tr>
     <tr>
          <td align="right"><b>Product Price:</b></td>
          <td><input type="text" name="product_price" size="50" required/></td>
     </tr>
     <tr>
          <td align="right"><b>Product Description:</b></td>
          <td><textarea name="product_desc" cols="20" rows="10"></textarea></td>
     </tr>
     <tr>
          <td align="right"><b>Product Keywords</b></td>
          <td><input type="text" name="product_keywords" size="50" required/></td>
     </tr>
     <tr align="center">
          <td colspan="7"><b><input type="submit" name="insert_post" value="Insert Product Now"/></b></td>
     </tr>
   </table>
</form>
</body>
</html>
<?php
   if(isset($_POST['insert_post'])){
       //getting the text data from the fields.
     $product_title = $_POST ['product_title']; 
     $product_cat = $_POST ['product_cat']; 
     $product_brand = $_POST ['product_brand']; 
     $product_price = $_POST ['product_price']; 
     $product_desc = $_POST ['product_desc']; 
     $product_keywords = $_POST ['product_keywords']; 
      //getting the image data from the fields.
      $product_image = $_FILES['product_image'][name];
      $product_image_tmp = $_FILES['product_image']['tmp_name'];

      move_uploaded_file($product_image_tmp,"product_images/$product_image");

      $insert_product = "insert into products (product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords) values ('$product_cat','$product_brand','$product_title','$product_price','$product_desc',' $product_image','$product_keywords')";
   $insert_pro = mysqli_query($con,$insert_product);
   if($insert_pro) {
       echo "<script>alert('Product has been inserted!')</script>";
       echo "<script>window.open('insert_product.php','_self')</script>";
   }
   }
?>

函数部分。

    <?php
$con = mysqli_connect("localhost","root","","ecommerce");
//getting the categories
function getcats(){
    global $con;
    $get_cats = "select * from categories";
    $run_cats = mysqli_query($con, $get_cats);

    while($row_cats=mysqli_fetch_array($run_cats)){

        $cat_id = $row_cats['cat_id'];
        $cat_title = $row_cats['cat_title'];
        echo "<li><a href='#'>$cat_title</a></li>";
    }

    }

//getting the Brands
function getBrands(){
    global $con;
    $get_brands = "select * from brands";
    $run_brands = mysqli_query($con, $get_brands);

    while($row_brands=mysqli_fetch_array($run_brands)){

        $brand_id = $row_brands['brand_id'];
        $brand_title = $row_brands['brand_title'];
        echo "<li><a href='#'>$brand_title</a></li>";
    }

    }

    function getpro() {
        global $con;

        $get_pro = "select * from products order by RAND() LIMIT 1,6";
        $run_pro = mysqli_query($con, $get_pro);
        while($row_pro=mysqli_fetch_array($run_pro)){
            $pro_id = $row_pro['product_id'];
            $pro_cat = $row_pro['product_cat'];
            $pro_brand = $row_pro['product_brand'];
            $pro_title = $row_pro['product_title'];
            $pro_price = $row_pro['product_price'];
            $pro_image = $row_pro['product_image'];
            echo "
            <div id='single_product'>
            <h3>$pro_title</h3>
            <img src='\\ecommerce\admin_area\product_images\$pro_image' width='180' height='180' /> 
            <p><b> $pro_price </b></p>
            </div>
            ";
        }
        }                               
?>




**The web page to display all details**
    <!DOCTYPE>
<?php
include("functions/functions.php");
?>
<html>
     <head>
        <title>Gal Baking Services LTD online Shop.</title>
     <link rel="stylesheet" href="admin_area/product_images/style.css" media="all" /> 
     </head>
<body>
    <div class="main_Wrapper">

        <div class="header_wrapper"> 
        <img id="logo" src="images/ad bunner.jpg" />
        <img id="bunner" src="images/ad bunner.jpg" />
        </div>
        <div class="menubar">
            <ul id="menu">
                 <li><a href="#">Home</a></li>
                 <li><a href="#">All products</a></li>
                 <li><a href="#">My account</a></li>
                 <li><a href="#">Sign up</a></li>
                 <li><a href="#">Shopping cart</a></li>
                 <li><a href="#">Contact Us</a></li>
            </ul>
            <div id="form">
                 <form method="get" action="result.php" enctype="multipart/form-data">
                    <input type="text" name="user_query" placeholder="Search a product" />
                    <input type="submit" name="search" value="search" />
                 </form>
            </div>
        </div>
        <div class="content_wrapper">
        <div id="sidebar"> 

           <div id="sidebar_title">Categories</div>
           <ul id="carts">
           <?php getcats();?>
            </ul>
         <div id="sidebar_title">Brands</div>

           <ul id="carts">
           <?php getBrands();?>
           </ul>

        </div>
        </div>
        <div id="content_area">
           <div id="products_box">

           <?php getpro(); ?>

           </div>
        </div>
        </div>
        <div id="footer"> 
           <h2 style="text-align:center; padding-top:30px;">&copy;2016 by www.krumblefresh.com </h2>
        </div>
    </div>
</body>
</html>

最佳答案

感谢大家的参与和支持。在研究了如何显示来自 mysql 数据库的图像的代码之后，我开始意识到我的代码是完美的，只是我在 insert_product.php 文件的以下几行中犯了一些愚蠢的错误，"$product_image = $_FILES['product_image'][name];"。我没有将'name'括在单引号''内。应该是，$product_image = $_FILES['product_image']['name'];.另外，在下一行*

$insert_product = "insert into products (product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords) values ('$product_cat','$product_brand', '$product_title','$product_price','$product_desc', ' $product_image','$product_keywords')";

*, i had included a blank space inside the single quotes near $product_image.Its supposed to be ,

$insert_product = "insert into products (product_cat,product_brand,product_title,product_price,product_desc,product_image,product_keywords) values ('$product_cat','$product_brand','$product_title','$product_price','$product_desc','$product_image','$product_keywords')"; Thank you all.

关于mysql - 我得到这样的东西 ,"Failed to load resource: the server responded with a status of 404 (Not Found)"，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/37498515/

24 4 0
文章推荐： mysql - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException : You have an error in your SQL syntax;
文章推荐： python - 我们如何改变当前的 __main__
文章推荐： python - 如何将列表类型更改为str？
文章推荐： c# - Richtextbox - 撤消？
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com