PHP ComboConnector Examples

Example #1

File: 01_basic_srnd_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require_once "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res, "PDO");
//   $combo->enable_log("temp.log");
$combo->dynamic_loading(2);
$combo->render_table("country_data", "country_id", "name");

Example #2

File: 02_sql_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res);
//$combo->enable_log("temp.log");
$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ", "country_id", "name");

Example #3

File: get_district.php Project: bamcod/Disease-Surveillance

<?php

session_start();
$prov = $_POST[''];
$mysql_link = mysql_connect("localhost", "root", "");
mysql_select_db("idsr") or die("Could not select database");
require "combo_connector.php";
$combo = new ComboConnector($mysql_link);
$combo->enable_log("temp.log");
$combo->render_sql("SELECT ID,name  FROM districts ", "ID", "name");

Example #4

File: 02_sql_srnd_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res);
//	$combo->enable_log("temp.log");
$combo->dynamic_loading(2);
$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ", "country_id", "name");

Example #5

File: getprovincedistrict.php Project: bamcod/Disease-Surveillance

<?php

session_start();
$province = $_GET['province'];
// Use this line or below line if register_global is off
//require_once("../config.php");
/*$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
	mysql_select_db($mysql_db);*/
$mysql_link = mysql_connect("localhost", "root", "");
mysql_select_db("idsr") or die("Could not select database");
require "combo_connector.php";
$combo = new ComboConnector($mysql_link);
$combo->enable_log("temp.log");
//$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ","country_id","name");
//$combo->render_sql("SELECT ID,name  FROM facilitys where  districts BETWEEN  53 AND 55 ","ID","name" );
$combo->render_sql("SELECT ID,name  FROM districts WHERE province='{$province}' ", "ID", "name");

Example #6

File: lstSuppliers.php Project: neohusky/NMIS

<?php

require_once "../codebase/dhtmlx/combo_connector.php";
require_once 'config.php';
$data = new ComboConnector($conn);
$data->enable_log("log.txt", true);
$data->render_sql("SELECT DISTINCT `supplier_name` FROM `suppliers` ", "supplier_name", "supplier_name");

Example #7

File: combo_select.php Project: rokkit/temp

<?php

require_once '../../common/connector/combo_connector.php';
require_once "../../common/config.php";
$combo = new ComboConnector($res, $dbtype);
$combo->event->attach("beforeFilter", "by_id");
function by_id($filter)
{
    if (isset($_GET['id'])) {
        $filter->add("item_id", $_GET['id'], '=');
    }
}
$combo->dynamic_loading(3);
$combo->render_table("Countries", "item_id", "item_nm");

Example #8

File: getprovincefacility.php Project: bamcod/Disease-Surveillance

                        $end2 = 151;
                        $start3 = 157;
                        $end3 = 158;
                    } else {
                        if ($province == 8) {
                            $start = 88;
                            $end = 108;
                        } else {
                            if ($province == 9) {
                                $start = 131;
                                $end = 155;
                            }
                        }
                    }
                }
            }
        }
    }
}
$mysql_link = mysql_connect("localhost", "root", "");
mysql_select_db("idsr") or die("Could not select database");
require "combo_connector.php";
$combo = new ComboConnector($mysql_link);
$combo->enable_log("temp.log");
//$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ","country_id","name");
//$combo->render_sql("SELECT ID,name  FROM facilitys where  districts BETWEEN  53 AND 55 ","ID","name" );
if ($province == 7) {
    $combo->render_sql("SELECT ID,name  FROM facilitys WHERE ((district BETWEEN {$start} AND {$end}) OR (district BETWEEN  {$start2} AND {$end2}) OR (district BETWEEN  {$start3} AND {$end3})) ", "ID", "name");
} else {
    $combo->render_sql("SELECT ID,name  FROM facilitys WHERE district BETWEEN {$start} AND {$end} ", "ID", "name");
}

Example #9

File: 01_basic_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res);
//   $combo->enable_log("temp.log");
$combo->render_table("country_data", "country_id", "name");

Example #10

File: 01_basic_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res);
$combo->enable_log("temp.log");
$combo->render_table("country_data", "country_id", "name");

Example #11

File: get_facilities.php Project: bamcod/Disease-Surveillance

<?php

session_start();
$mysql_link = mysql_connect("localhost", "root", "");
mysql_select_db("idsr") or die("Could not select database");
require "combo_connector.php";
$combo = new ComboConnector($mysql_link);
$combo->enable_log("temp.log");
$combo->render_sql("SELECT id,name  FROM facilitys ", "id", "name");

Example #12

File: 02_sql_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/combo_connector.php";
$combo = new ComboConnector($res);
$combo->enable_log("temp.log");
$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ", "country_id", "name");

Example #13

File: get_district_facilitys.php Project: bamcod/Disease-Surveillance

<?php

session_start();
$districtcode = $_SESSION['accounttype'];
//require_once("../config.php");
/*$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
	mysql_select_db($mysql_db);*/
$mysql_link = mysql_connect("localhost", "root", "");
mysql_select_db("idsr") or die("Could not select database");
require "combo_connector.php";
$combo = new ComboConnector($mysql_link);
$combo->enable_log("temp.log");
//$combo->render_sql("SELECT * FROM country_data  WHERE country_id >40 ","country_id","name");
$combo->render_sql("SELECT ID,name  FROM facilitys where  district='{$districtcode}'", "ID", "name");