Re: insert array

[Stephen Van Tuyl]

OOPS! Sorry. Wrong code. Couldn't figure out how to delete or edit so here's the code I meant to put up.

<?php
$servername = "localhost";
$username = "evensteven";
$password = "RuffleFrump";
$dbname = "hosts";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$client = array(
"0" => array("name" => "Peter Maxx", "ip" => "193.169.5.16"),
"1" => array("name" => "Ravi Shankar", "ip" => "193.169.5.17")
);

if(is_array($client)) {
$DataArr = array();
foreach($client as $row) {

$DataArr[] = "('". mysqli_real_escape_string($conn, $row["name"]) ."', '". mysqli_real_escape_string($conn, $row["ip"]) ."')";
}
$sql = "INSERT INTO ip_data (name, ip)
VALUES
('Peter Maxx', '193.169.5.16'),

('Ravi Shankar', '193.169.5.17'),";

$sql .= implode(", " , $DataArr);
mysqli_query($conn, $sql);

}
?>