Insert array to mysql

insert-php-array-into-mysql.php

<?php

$mysqli = new mysqli( DB_HOST, DB_USER, DB_PASSWORD, DB_NAME ) or die( 'Could not connect' );

// Check connection
if ( mysqli_connect_errno() ) {
	printf( "Connect failed: %s\n", mysqli_connect_error() );
	exit();
}

$values = array(
	'XXX',
  'XXX2',
  'XXX3'
);

foreach( $values as $value ) {
    $mysqli->query( "INSERT INTO `TABLE` (`COLUMN`) VALUES ('$value')" );
}