<?php
    require_once 'configmain.php';

    $apptype=@$_REQUEST['apptype'];
    if ($apptype == "1") {

        $ip=@$_POST['ip'];
        $ipusername=@$_POST['ipusername'];
        $password=@$_POST['password'];
        $dbname=@$_POST['dbname'];
        $ftppath=@$_POST['ftppath'];

        $mysqli = new MySQLi($ip,$ipusername,$password,$dbname);  
        if($mysqli->connect_errno)
        {
          die("ERROR : -> ".$mysqli->connect_error);
        } else{
         // die("Connected");
        }
    }else if ($apptype == "2") {
       $ftppath=@$_POST['ftppath'];
    }

    $response = array();
    $response["configarray"] = array();

    $dquery="SELECT id,ordno,prefix,var1,var2,var3,var4,ptype FROM printconfig ";
    $result=$mysqli->query($dquery);

    while($row = $result->fetch_array())
    {
		 $tmp = array(); 
         $tmp["id"] =$row['id'];
         $tmp["ordno"] =$row['ordno'];
         $tmp["prefix"] =$row['prefix'];
         $tmp["var1"] =$row['var1'];
         $tmp["var2"] =$row['var2'];
         $tmp["var3"] =$row['var3'];
         $tmp["var4"] =$row['var4'];
         $tmp["ptype"] =$row['ptype'];

        array_push($response["configarray"], $tmp);
    }

    header('Content-Type: application/json');
    echo json_encode($response);
?>