gridphp

function update_data($data) {
    global $g;
//update history table with record before updated in contracts by using OLD as value for ACTION field in HISTORY TABLE
    $str3 = "INSERT INTO history
             SELECT NULL, NOW(), 'old', '" . $_SESSION['username'] . "',
                                               d.* FROM contracts AS d
             WHERE d.contract_Id ={$data["contract_Id"]}";
    // mysql_query($str3);
    $g->execute_query($str3);

gridphp

<?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

include_once("../../config.php");

gridphp

<?php 
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

// include db config

gridphp

<?php

namespace App\Controllers;

class Home extends BaseController
{
	public function index()
	{
		$db_conf = array();
		$db_conf["type"] = "mysqli"; // mysql,oci8(for oracle),mssql,postgres,sybase

gridphp

<?php 
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

// include db config

gridphp

<?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

include_once("../../config.php");

gridphp

<?php 
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

// include db config

gridphp

<?php 
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */
 
// include db config

gridphp

<?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

// include db config

gridphp

<?php 
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - http://www.phpgrid.org
 * @version 2.0.0
 * @license: see license.txt included in package
 */

// include db config