<?php
$db_user="root";
$db_pass="";
$db_host="localhost";
$db_name="internetbanking";
$db_host = "analogdepat.mysql.db";
$db_user = "analogdepat";
$db_pass = "Un92pac007";
$db_name = "analogdepat";
$connexion = new mysqli($db_host, $db_user, $db_pass, $db_name);
if ($connexion->connect_error)
{
die("Connection failed: " . $connexion->connect_error);
}
else
{
echo "Match !";
mysqli_query($connexion,'TRUNCATE TABLE aaa_upload_files');
for ($i = 0; $i < count($matches); $i++)
{
$sql = "INSERT INTO aaa_upload_files (filename) VALUES ('$matches[$i]')";
//$conn->query($sql);
}
}
/*
// sql to create table
"CREATE TABLE aaa_upload_files (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
filename VARCHAR(100) NOT NULL
)";
*/
?>