예제 #1
0
function get_entity_group_list($entitygroup)
{
    $list = $entitygroup;
    $query = "select * from entity_groups where parent_id=" . $entitygroup;
    $result = mysql_query($query);
    while ($row = mysql_fetch_assoc($result)) {
        //strList += "," + getEntityGroupList(dbf.rs.getInt("id") + "");
        $list .= "," . get_entity_group_list($row['id']);
    }
    return $list;
}
예제 #2
0
//require_once 'init2.php';
require_once '../../common/functions.php';
require_once "../../site/includes/sitecommon.php";
/*
 * This returns all of the tickers based off of entity group and a 'term'. 
 * 
 * This is the script used for the autocomplete control in linechart (et. al.)
 */
db_utility::db_connect();
$entitygroup = "1002";
if (isset($_GET['group']) && $_GET['group'] != 'all') {
    $entitygroup = $_GET['group'];
}
$return = array();
$sql = "select entities.ticker,entities.id,entities.full_name ";
$sql .= " from entities ";
$sql .= " join entities_entity_groups on entities.id = entities_entity_groups.entity_id ";
$sql .= " join entity_groups on entities_entity_groups.entity_group_id=entity_groups.id ";
/*
 * mysql_real_escape_string to prevent sql injection.
 */
$sql .= " where ticker like '" . mysql_real_escape_string($_REQUEST['term']) . "%' ";
//if (!($entitygroup == 'all'))
//	$sql.=" AND entity_groups.id=".$entitygroup;
$sql .= " and entity_groups.id in (" . get_entity_group_list($entitygroup) . ")";
$sql .= " order by ticker asc ";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
    $return[] = $row;
}
echo json_encode($return);