如何在MySQL中将每个结果添加到我的表中

I have a php file (with simple_HTML_Dom) wich scrape all the urls of a CSV file.

He extract all the info i need, and all OK, but now i wan't to add all these results on my MySQL table.

I wan't each result adds in one row in MySQL table.

That's the code i have so far:

    <?php

    require 'libs/simple_html_dom/simple_html_dom.php';
set_time_limit(0);



    function scrapUrl($url) 
    {

        $html = new simple_html_dom();

        $html->load_file($url);


        $names = $html->find('h1');
        $manufacturers = $html->find('h2');


        foreach ($names as $name) {
           echo $name->innertext;
           echo '<br>';
        }
        foreach ($manufacturers as $manufacturer) {
           echo $manufacturer->innertext;
           echo '<br>';
           echo '<hr><br>';
        }


    }

    $rutaCSV = 'csv/urls1.csv'; // Ruta del csv.

    $csv = array_map('str_getcsv', file($rutaCSV));

    //print_r($csv); // Verás que es un array donde cada elemento es array con una de las url.

    foreach ($csv as $linea) {

        $url = $linea[0];
        scrapUrl($url);

    }


$servername = "localhost";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 


foreach ($csv as $linea) {


 $sql = "INSERT INTO productos (nombre, nombreFabricante) VALUES($name, $manufacturer)";
 print ("<p> $sql </p>");    
 if ($conn->query($sql) === TRUE) {
    echo "Items added to the database!";
 } else {
    echo "Error: " . $sql . "<br>" . $conn->error;
 }
}

$conn->close();

?>

EDIT: I have updated the code. I have added also the price variable. The error shown in the output is this one:

Notice: Undefined variable: name in C:\xampp\htdocs\bootstrap\csv2.php on line 69

Notice: Undefined variable: manufacturer in C:\xampp\htdocs\bootstrap\csv2.php on line 69

Error: INSERT INTO productos (nombre, nombreFabricante) VALUES(,)
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 'https://url.com/es/product1.html', )' at line 1

How can i solve the error for the Notice: Undefined variable: name & price ?

I want to add the $name and $manufacturer variables wich are inside the function, to my MySQL table

EDIT 2: @adamlab, you have deleted the post :(

If someone can help me, i will appreciate so much.

Thank you and best regards

Try this code , Hope you are collecting each value separately but your need is to insert each set of result in the mysql table as a new row , try the below but it's a rough one make it as per your need.

require 'libs/simple_html_dom/simple_html_dom.php';
set_time_limit(0);



function scrapUrl($url) 
{

   $ar_name =array();
   $ar_man = array();

    $html = new simple_html_dom();

    $html->load_file($url);


    $names = $html->find('h1');
    $manufacturers = $html->find('h2');


    foreach ($names as $name) {
       $ar_name[] = $name->innertext;
    }
    foreach ($manufacturers as $manufacturer) {
       $ar_man[] = $manufacturer->innertext;
    }

    for($i=o;$i<sizeof($ar_name);$i++)
     {


$sql = "INSERT INTO table(name, manufacturer)
VALUES ($ar_name[$i],$ar_man[$i])";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
     }

    //echo $url;

}

$rutaCSV = 'csv/urls1.csv'; // Ruta del csv.

$csv = array_map('str_getcsv', file($rutaCSV));

I'm not sure where you define $name so you'll need to check that it's valid.

foreach ($csv as $linea) {


 $sql = "INSERT INTO productos (name, manufacturer) VALUES('$name', '{$linea[0]}')";
 print ("<p> $sql </p>");    
 if ($conn->query($sql) === TRUE) {
    echo "Items added to the database!";
 } else {
    echo "Error: " . $sql . "<br>" . $conn->error;
 }
}

$conn->close();

?>