这是基本代码，我还没有测试过。使产品id或名称唯一，以避免在数据库表中重复。是 啊。但是代码请求没有完成！！在这里！！！

$handle =  fopen('data/yourcsvfilename.csv', 'r');
$conn = mysqli_connect('localhost', 'root','','databasename');
    while($data = fgetcsv($handle)){
$id = $data[0];
$category = $data[1];
$product = $data[2];

$qgetcatid = "select id from product_category_master where category = '{$category}'";
$rgetcatid = mysqli_query($conn, $qgetcatid) or die (mysqli_error($conn));  

$rgetcatid = mysqli_fetch_assoc($rgetcatid);

$catid = $rgetcatid[0];

$qi = "insert ignore into product_master set product_name = '{$product}', id = '{$id}', product_cat_id = '{$catid}'"; 
$rgetcatid = mysqli_query($conn, $qi) or die (mysqli_error($conn)); 
}