<?php
error_reporting(E_ALL);
$mysql_user = 'root2';
$mysql_pass = 'root';
$mysql_host = '172.15.1.6';
$dbname = 'UTM5';

$dsn = sprintf('mysql:host=%s;dbname=%s;charset=utf-8',$mysql_host,$dbname);
try{
$pdo = new PDO($dsn,$mysql_user,$mysql_pass);
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION );
}catch (PDOException $e){
    die('Error while trying to connect to DB');
}


//include '/opt/switch/sw-db1.php';


$ids = range(7,9);
$sql = "SELECT `kpp_number`,`login`,`tax_number`,`id` FROM `users` where `id` IN (".implode(",",$ids ).")";
try{
    $statement = $pdo->query($sql);
    $rows = $statement->fetchAll(PDO::FETCH_OBJ);
}catch (PDOException $e){
    echo '<pre>'.print_r($e,true).'</pre>';
    die("Error in SQL");
}
foreach($rows as $row){

    echo $row->id."\n";
    echo $row->tax_number."\n";
    $file = "/opt/switch/".$row->id;
    $data = "#!/bin/sh\n"
        . "echo open 172.15.$row->tax_number\n"
        . "sleep 4\n"
        . "echo admin\n"
        . "sleep 2\n"
        . "echo negjcdbn4\n"
        . "sleep 2\n"
        . "echo config ports $row->kpp_number description $row->login\n"
        . "sleep 2\n"
        . "echo save\n"
        . "sleep 5\n"
        . "echo logout\n";
    file_put_contents($file,$data);
    exec("chmod 777 $file");
    exec("$file | /usr/bin/telnet");
    unlink($file);
}