douxunwei8259 2015-07-15 12:32
浏览 56
已采纳

使用php将数据插入mysql数据库[关闭]

<?php

$cxn = mysql_connect("localhost","root","") or die("failed to connect to mysql:" . mysql_error());

$barcode = $_POST['barcode'];
$manufacturer = $_POST['manufacturer'];
$product_name = $_POST['product_name'];
$category = $_POST['category'];
$model_no = $_POST['model_no'];
$price = $_POST['price'];
$color = $_POST['color'];
$image_path = $_POST['image_path'];
$others = $_POST['others'];


mysql_select_db("estinno",$cxn);
$sql="INSERT INTO details (barcode, manufacturer, product_name, category, model_no, price, color, image_path, others) VALUES ('$barcode', '$manufacturer', '$product_name', '$category', '$model_no', '$price', '$color', '$image_path', '$others')";

echo "Barcode details Successfully Added";

?>

I have seen all such related question, but none of them working here.

  • 写回答

2条回答 默认 最新

  • drvkf88226 2015-07-15 12:36
    关注

    You have forgotton to run your SQL. Add:

    $insert = mysql_query($sql);
    
    if($insert){
        echo "Barcode details Successfully Added";
    } else {
        echo mysql_error();
    }
    

    ..and please update your code to use mysqli_* or PDO. mysql_* functions are being deprecated.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?