1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
<?php
$IP_Address = $_POST["IP_Address"];
$City = $_POST["City"];
$name = $_POST["name"];
$adress = $_POST["adress"];
$lat = $_POST["lat"];
$lng = $_POST["lng"];
// Connexion au serveur distant 192.168.40.117
$serverName = "192.168.40.117";
$connectionInfo = array( "Database"=>"NetPerfMon", "UID"=>"solarwinds", "PWD"=>"solarwinds");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if(isset($_POST) && !empty($_POST['IP_Address'])){
extract($_POST);
$sql = "SELECT * FROM dbo.Nodes WHERE IP_Address = '".$IP_Address."'";
$result = sqlsrv_query($conn,$sql);
$data = sqlsrv_fetch_array($result);
if($data['IP_Address']){
sql1 = "INSERT INTO dbo.Nodes
(City,name,adress,lat,lng)
VALUES('".$City."','".$name."','".$adress."','".$lat."','".$lng."')
WHERE IP_Address = '".$IP_Address."'";
$result = sqlsrv_query($conn,$sql1);
if($_result){
header('Location: Swecom_Solar_Winds.html');
}else{
}
}else{
}
}else{
}
// On verifie si l'adresse IP est bien dans la base de données
$query = "SELECT IP_Address
FROM dbo.Nodes
WHERE IP_Address = '".$IP_Address."'";
// Execution de la requete
$result = sqlsrv_query($conn,$query);
$rows = sqlsrv_num_rows($result); |
Partager