<?php

require("connecter.php");

function DataTable_Filling($sqlstr,$Messagein)
{
    $con = connect();
    $json=array();
    try{
    $params = array();
    $options =  array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
    $sel=sqlsrv_query($con, $sqlstr, $params, $options);
    //var_dump($sel);

    if(sqlsrv_num_rows($sel) !== false)
    {
        while($row=sqlsrv_fetch_array($sel))
        {
            $json['results'][]=$row;
        }
        $json['status']='success';
        $json['message']=$Messagein;
    }
    else
    {
        $json['status']="empty";
    }
    return json_encode($json);
}catch(Exception $e){
    var_dump($e);
}
}

function scalar( $sqlstr,$Messagein)
{
    $con = connect();
    $json=array();

    $sel=sqlsrv_query($con,$sqlstr);
    if( $sel === false ) {echo "Error (sqlsrv_query): ".print_r(sqlsrv_errors(), true); exit;}
    if( sqlsrv_num_rows($sel))
    {   $row=sqlsrv_fetch_array($sel);

        $json=$row;
        $json['status']='success';
        $json['message']=$Messagein;
    }
    else
    {
        $json['status']="error";
        $json['message']="Invalid Request";
    }

    return json_encode($json);
}


function nonqry($sqlstr,$Messagein)
{

    $con = connect();
    $params=array();
    $sel = sqlsrv_query($con,$sqlstr);
    $ID = sqlsrv_next_result($sel);
    var_dump($ID);
    $json['ID']=$ID;
    $json['status']='success';
    $json['message']=$Messagein;
    return json_encode($json);
}



?>