I am facing an issue with a function that I have written in PHP mySQL to insert records into a database. The function accepts an array of JSON data, a field name, a connection, and a DB name as parameters. It then constructs a SQL statement to insert the records one by one. However, when I execute it, the function fails. I suspect there is an error in my INSERT statement, but I'm unsure how to resolve it. Any assistance on this matter would be highly appreciated.
Here is the function:
function insertRecords($array, $fieldname, $conn, $db_NAME)
{
mysqli_select_db($conn, $db_NAME);
$sql_insert = "INSERT INTO `tbl_articles` (`" . $fieldname . "`) VALUES ('" . $records . "')";
foreach ($array as $records)
{
if(mysqli_query($conn, $sql_insert))
{
echo "Records Inserted.";
}
else
{
die('Error : ' . mysqli_error($conn) . "<br>");
}
}
echo $sql_insert . "<br>";
}