1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| <?php
include ('config.php');
If ($DBPort == "") $DBconnect = "mysql:dbname=".$DBName.";host=".$DBhost;
Else
{
$DBconnect = "mysql:dbname=".$DBName.";host=".$DBhost.";port=".$DBPort;
}
try
{
$pdo = new PDO($DBconnect, $DBowner, $DBpw);
$sql_query = "LOAD XML LOCAL INFILE 'http:\\....\testusers.xml' INTO TABLE users ROWS IDENTIFIED BY '<users>' IGNORE 1 LINES ";
$result_query = $pdo->query($sql_query);
}
catch (PDOException $e)
{
echo "Connexion DB échouée : <font color=red><b>" . $e->getMessage()."</b></font> <br> \n";
echo "<br>";
}
?> |