Ignited Datatables call stored procedure php

Question

I follow tutorial ignited datatables https://github.com/IgnitedDatatables/Ignited-Datatables/wiki/Function-Reference

 function datatables() {
    $this->datatables
            ->select('TerminalID,AtmLocation,MaxNumOfBills1,MaxNumOfBills2')
            ->from('terminalset');
    header('Content-Type: application/json');
    echo $this->datatables->generate(); 
    }

and I have trouble when I use stored procedures like this:

$this->db->query('proc_request "$parameter"');

How to call stored procedure in an ignited datatable?

How do I add a query function in libraries datatables.php? https://github.com/IgnitedDatatables/Ignited-Datatables/blob/master/application/libraries/Datatables.php

Which Driver you can use ? For Connect Database – Jignesh.Raj Oct 01 '13 at 08:57 — Jignesh.Raj, Oct 01 '13 at 08:57
i use sqlsrv driver framework codeigneter. – Ardy Ant Oct 01 '13 at 09:09 — Ardy Ant, Oct 01 '13 at 09:09

Jignesh.Raj · Answer 1 · 2013-10-09T10:14:34.957

You should try this way

Sample Code:

function GetLogoById($Id)
        {

            $serverName = "XXXXX";
            $uid = "XXXXXX";
            $pwd = "XXXXXX";

            $connectionInfo = array( "UID"=>$uid,
                    "PWD"=>$pwd,
                    "Database"=>"XXXXXX");
            $conn = sqlsrv_connect( $serverName, $connectionInfo);
            $tsql = "select * from TableName where Id = '$Id'";
            $stmt = sqlsrv_query( $conn, $tsql);
            if( $stmt === false)
            {
                echo "Error in query preparation/execution.\n";
                die( print_r( sqlsrv_errors(), true));
            }
            /* Retrieve each row as an associative array and display the results.*/
            while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
            {
                return $row['ColumnName'];
            }
            /* Free statement and connection resources. */
            sqlsrv_free_stmt( $stmt);
            sqlsrv_close( $conn);

        }

Ignited Datatables call stored procedure php

1 Answers1