• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP table类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中table的典型用法代码示例。如果您正苦于以下问题:PHP table类的具体用法?PHP table怎么用?PHP table使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



在下文中一共展示了table类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: action_comments_remove

 function action_comments_remove()
 {
     $comm = new table("comments");
     $id = intval($_GET["id"]);
     $comm->delete($id);
     show_msg("删除成功", $_SERVER["HTTP_REFERER"]);
 }
开发者ID:xurenlu,项目名称:tik,代码行数:7,代码来源:m.php


示例2: table_nodes

    function table_nodes()
    {
        global $construct, $db, $main;
        $form_search_nodes = $this->form_search_nodes();
        $where = $form_search_nodes->db_data_where(array("nodes__name" => "starts_with"));
        if ($main->userdata->privileges['admin'] !== TRUE) {
            $where = "users.status = 'activated'" . ($where != '' ? ' AND (' . $where . ')' : "");
        }
        $table_nodes = new table(array('TABLE_NAME' => 'table_nodes'));
        $table_nodes->db_data('nodes.id, nodes.name AS nodes__name, areas.name AS areas__name', 'nodes
			LEFT JOIN areas ON nodes.area_id = areas.id
			LEFT JOIN regions ON areas.region_id = regions.id ' . 'INNER JOIN users_nodes ON nodes.id = users_nodes.node_id ' . 'LEFT JOIN users ON users.id = users_nodes.user_id', $where != '' ? $where : "", "nodes.id", "nodes.id ASC");
        $table_nodes->db_data_search($form_search_nodes);
        for ($i = 1; $i < count($table_nodes->data); $i++) {
            if (isset($table_nodes->data[$i])) {
                $table_nodes->data[$i]['nodes__name'] .= " (#" . $table_nodes->data[$i]['id'] . ")";
                $table_nodes->info['PICKUP_VALUE'][$i] = $table_nodes->data[$i]['id'];
                $table_nodes->info['PICKUP_OUTPUT'][$i] = $table_nodes->data[$i]['nodes__name'];
            }
        }
        $table_nodes->info['PICKUP_COLUMN'] = 'nodes__name';
        $table_nodes->info['PICKUP_OBJECT'] = stripslashes(get('object'));
        $table_nodes->db_data_remove('id');
        return $table_nodes;
    }
开发者ID:southern-wind,项目名称:wind,代码行数:25,代码来源:pickup_nodes.php


示例3: __construct

 function __construct()
 {
     parent::__construct();
     $geometryColumnsObj = new table("settings.geometry_columns_view");
     $this->rows = $geometryColumnsObj->getRecords();
     $this->rows = $this->rows['data'];
 }
开发者ID:netconstructor,项目名称:MyGeoCloud,代码行数:7,代码来源:geometry_columns.php


示例4: updateCartoMobileSettings

 function updateCartoMobileSettings($data, $_key_)
 {
     $table = new table("settings.geometry_columns_join");
     $data = $table->makeArray($data);
     $cartomobileArr = (array) json_decode($this->getValueFromKey($_key_, "cartomobile"));
     foreach ($data as $value) {
         $safeColumn = $table->toAscii($value->column, array(), "_");
         if ($value->id != $value->column && $value->column && $value->id) {
             unset($cartomobileArr[$value->id]);
         }
         $cartomobileArr[$safeColumn] = $value;
     }
     $conf['cartomobile'] = json_encode($cartomobileArr);
     $conf['_key_'] = $_key_;
     $table->updateRecord(json_decode(json_encode($conf)), "_key_");
     $this->execQuery($sql, "PDO", "transaction");
     if (!$this->PDOerror || !$sql) {
         $response['success'] = true;
         $response['message'] = "Column renamed";
     } else {
         $response['success'] = false;
         $response['message'] = $this->PDOerror[0];
     }
     return $response;
 }
开发者ID:netcon-source,项目名称:MyGeoCloud,代码行数:25,代码来源:geometry_columns.php


示例5: query

function query($argv = '')
{
    error_reporting(7);
    $table_queryer_file = __DIR__ . DIRECTORY_SEPARATOR . 'ThinkPHP-Queryer';
    $content = file_get_contents($table_queryer_file);
    $sep = '##########################################################################';
    $arr_content = split($sep, $content);
    $sql = trim($arr_content[0]);
    connect_db($argv);
    $result = mysql_query($sql);
    $rows = array();
    if ($result) {
        $i = 0;
        while ($row = mysql_fetch_assoc($result)) {
            if ($i == 0) {
                $header = array_keys($row);
            }
            $i++;
            $rows[] = array_values($row);
        }
    }
    require __DIR__ . '/table.php';
    $in = array('header' => $header ? $header : array(), 'rows' => $rows);
    // file_put_contents('./', data);
    file_put_contents('./debug.php', var_export($in, 1));
    if ($rows) {
        $table = new table($in);
        $output = $table->render(0);
    }
    if (!$output) {
        $output = 'no results!';
    }
    exit($output);
}
开发者ID:262877348,项目名称:Sublime-Text3,代码行数:34,代码来源:command.php


示例6: get_table

 function get_table()
 {
     $obj_test = new table();
     @$obj_test->create_table();
     @$obj_test->create_content();
     //@table::create_table();
 }
开发者ID:nong053,项目名称:web-ready,代码行数:7,代码来源:obj_table.php


示例7: table_dns

    function table_dns()
    {
        global $construct, $db, $vars;
        $form_search_dns = $this->form_search_dns();
        if (substr($form_search_dns->data[1]['value'], -strlen("." . $vars['dns']['root_zone'])) == "." . $vars['dns']['root_zone']) {
            $form_search_dns->data[1]['value'] = substr($form_search_dns->data[1]['value'], 0, -strlen("." . $vars['dns']['root_zone']));
        }
        $where = $form_search_dns->db_data_where(array("dns_zones__name" => "starts_with"));
        $table_dns = new table(array('TABLE_NAME' => 'table_dns', 'FORM_NAME' => 'table_dns'));
        $table_dns->db_data('dns_zones.id AS dns_zones__id, dns_zones.name AS dns_zones__name, dns_zones.type, dns_zones.date_in, dns_zones.status, nodes.name AS nodes__name, nodes.id AS nodes__id', 'dns_zones
			LEFT JOIN nodes ON dns_zones.node_id = nodes.id', $where, "", "dns_zones.status ASC, dns_zones.type ASC, dns_zones.name ASC");
        for ($i = 1; $i < count($table_dns->data); $i++) {
            if (isset($table_dns->data[$i])) {
                $table_dns->data[$i]['nodes__name'] .= " (#" . $table_dns->data[$i]['nodes__id'] . ")";
                if ($table_dns->data[$i]['type'] == 'forward') {
                    $table_dns->data[$i]['dns_zones__name'] .= "." . $vars['dns']['root_zone'];
                }
                $table_dns->info['EDIT'][$i] = makelink(array("page" => "nodes", "node" => $table_dns->data[$i]['nodes__id']));
            }
        }
        $table_dns->info['EDIT_COLUMN'] = 'nodes__name';
        $table_dns->db_data_remove('dns_zones__id', 'type', 'nodes__id');
        $table_dns->db_data_translate('dns_zones__status');
        return $table_dns;
    }
开发者ID:codeministry,项目名称:wind-ng-mc,代码行数:25,代码来源:dnszones.php


示例8: stat_single_area

 /**
 统计单个地区出现的次数;
 */
 static function stat_single_area($area)
 {
     global $DBR;
     $pw = new table("pw_threads");
     $row = $pw->findROW("count(*) as c", "fid=" . BBS_BID . " AND subject like '%" . mysql_escape_string($area) . "%'");
     return intval($row["c"]);
 }
开发者ID:xurenlu,项目名称:tik,代码行数:10,代码来源:cron.php


示例9: parseTable

 private function parseTable(DOMNode $tableNode)
 {
     $table = new table($tableNode->getAttribute('name'));
     $allFieldsList = $tableNode->getElementsByTagName('field');
     for ($i = 0; $i < $allFieldsList->length; $i++) {
         $fieldNode = $allFieldsList->item($i);
         $table->addField($this->parseField($fieldNode));
     }
     $utags = $tableNode->getElementsByTagName('unique');
     $ftag = $utags->item(0);
     $uniqueKeys = $ftag->nodeValue;
     //only one unique key supported
     $table->addUniqueKeys(explode(',', $uniqueKeys));
     $utags = $tableNode->getElementsByTagName('primary');
     $ftag = $utags->item(0);
     $pKey = $ftag->nodeValue;
     $table->setPrimaryAutocountKey($pKey);
     $allRowsList = $tableNode->getElementsByTagName('row');
     for ($i = 0; $i < $allRowsList->length; $i++) {
         $rowNode = $allRowsList->item($i);
         $table->addRow($this->parseRow($rowNode, $table->getFields(), $i));
     }
     $table->setNewID($tableNode->getAttribute('newID'));
     return $table;
 }
开发者ID:BackupTheBerlios,项目名称:morgos-svn,代码行数:25,代码来源:xml5.class.php


示例10: table_ip_ranges

    function table_ip_ranges()
    {
        global $construct, $db;
        $form_search_ranges = $this->form_search_ranges();
        $where = $form_search_ranges->db_data_where(array('ip' => 'exclude'));
        $table_ip_ranges = new table(array('TABLE_NAME' => 'table_ip_ranges', 'FORM_NAME' => 'table_ip_ranges'));
        $s_ip = $form_search_ranges->data[0]['value'];
        $where = $where != '' ? "(" . $where . ") AND " : "";
        if ($s_ip != '') {
            $where .= '(ip_ranges.ip_start >= ' . ip2long(correct_ip_min($s_ip, TRUE, 1)) . ' AND ip_ranges.ip_start <= ' . ip2long(correct_ip_max($s_ip, TRUE, 1)) . ") OR " . '(ip_ranges.ip_start >= ' . ip2long(correct_ip_min($s_ip, TRUE, 2)) . ' AND ip_ranges.ip_start <= ' . ip2long(correct_ip_max($s_ip, TRUE, 2)) . ") OR " . '(ip_ranges.ip_start >= ' . ip2long(correct_ip_min($s_ip, TRUE, 3)) . ' AND ip_ranges.ip_start <= ' . ip2long(correct_ip_max($s_ip, TRUE, 3)) . ") AND ";
        }
        //$where =
        //		($s_ip !=''?"ip_ranges.ip_start <= ".ip2long($s_ip)." AND ip_ranges.ip_end >= ".ip2long($s_ip)." AND ":"");
        if ($where != '') {
            $where = substr($where, 0, -5);
        }
        #@#
        $table_ip_ranges->db_data('"" AS ip_range, ip_ranges.ip_start, ip_ranges.ip_end, ip_ranges.date_in, ip_ranges.status, nodes.name AS nodes__name, nodes.id AS nodes__id, communities.name AS communities__name', 'ip_ranges
			LEFT JOIN nodes ON ip_ranges.node_id = nodes.id
			LEFT JOIN communities ON nodes.community_id = communities.id', $where != '' ? "(" . $where . ")" : "", "", "ip_ranges.status ASC, ip_ranges.ip_start ASC");
        #@#
        foreach ((array) $table_ip_ranges->data as $key => $value) {
            if ($key != 0) {
                $table_ip_ranges->data[$key]['ip_start'] = long2ip($table_ip_ranges->data[$key]['ip_start']);
                $table_ip_ranges->data[$key]['ip_end'] = long2ip($table_ip_ranges->data[$key]['ip_end']);
                $table_ip_ranges->data[$key]['ip_range'] = $table_ip_ranges->data[$key]['ip_start'] . " - " . $table_ip_ranges->data[$key]['ip_end'];
                $table_ip_ranges->data[$key]['nodes__name'] .= " (#" . $table_ip_ranges->data[$key]['nodes__id'] . ")";
                $table_ip_ranges->info['EDIT'][$key] = makelink(array("page" => "nodes", "node" => $table_ip_ranges->data[$key]['nodes__id']));
            }
        }
        $table_ip_ranges->info['EDIT_COLUMN'] = 'nodes__name';
        $table_ip_ranges->db_data_remove('ip_start', 'ip_end', 'nodes__id');
        $table_ip_ranges->db_data_translate('ip_ranges__status');
        return $table_ip_ranges;
    }
开发者ID:codeministry,项目名称:wind-ng-mc,代码行数:35,代码来源:ranges_search.php


示例11: table_ip_ranges

    function table_ip_ranges()
    {
        global $construct, $db, $lang;
        $form_search_ranges = $this->form_search_ranges();
        $where = $form_search_ranges->db_data_where(array('ip' => 'exclude', 'nodes__name' => 'starts_with', "total_active_p2p" => 'exclude', "total_active_aps" => 'exclude'));
        $table_ip_ranges = new table(array('TABLE_NAME' => 'table_ip_ranges', 'FORM_NAME' => 'table_ip_ranges'));
        $where = $where != '' ? "(" . $where . ") AND " : "";
        if ($form_search_ranges->data[0]['value'] != '') {
            $where .= "(";
            $s_ranges = ip_to_ranges($form_search_ranges->data[0]['value']);
            foreach ($s_ranges as $s_range) {
                $where .= "(ip_ranges.ip_start BETWEEN " . ip2long($s_range['min']) . " AND " . ip2long($s_range['max']) . ") OR ";
            }
            $where = substr($where, 0, -4) . ") AND ";
        }
        if ($where != '') {
            $where = substr($where, 0, -5);
        }
        $having = $form_search_ranges->db_data_where(array('ip' => 'exclude', 'ip_ranges__status' => 'exclude', 'ip_ranges__delete_req' => 'exclude', 'nodes__id' => 'exclude', 'nodes__name' => 'exclude'));
        $table_ip_ranges->db_data('ip_ranges.id, 
				"" AS ip_range, 
				ip_ranges.ip_start, 
				ip_ranges.ip_end, 
				ip_ranges.date_in, 
				ip_ranges.status, 
				ip_ranges.delete_req, 
				COUNT(DISTINCT p2p.id) AS total_active_p2p, 
				COUNT(DISTINCT aps.id) AS total_active_aps, 
				"" AS total_active_peers', 'ip_ranges ' . 'LEFT JOIN nodes ON ip_ranges.node_id = nodes.id 
				LEFT JOIN links ON ip_ranges.node_id = links.node_id AND links.status = "active" 
				LEFT JOIN links AS p2p ON links.type = "p2p" 
					AND links.peer_node_id = p2p.node_id 
					AND p2p.type = "p2p" 
					AND p2p.peer_node_id = links.node_id 
					AND p2p.status = "active" 
				LEFT JOIN links as aps ON links.type = "ap" 
					AND links.id = aps.id', $where, "ip_ranges.id" . ($having != '' ? ' HAVING (' . $having . ')' : ""), "ip_ranges.date_in DESC, ip_ranges.status ASC");
        $table_ip_ranges->db_data_search($form_search_ranges);
        foreach ((array) $table_ip_ranges->data as $key => $value) {
            if ($key != 0) {
                $table_ip_ranges->data[$key]['ip_start'] = long2ip($table_ip_ranges->data[$key]['ip_start']);
                $table_ip_ranges->data[$key]['ip_end'] = long2ip($table_ip_ranges->data[$key]['ip_end']);
                $table_ip_ranges->data[$key]['ip_range'] = $table_ip_ranges->data[$key]['ip_start'] . " - " . $table_ip_ranges->data[$key]['ip_end'];
            }
        }
        $table_ip_ranges->db_data_multichoice('ip_ranges', 'id');
        for ($i = 1; $i < count($table_ip_ranges->data); $i++) {
            if (isset($table_ip_ranges->data[$i])) {
                $table_ip_ranges->data[$i]['total_active_peers'] = ($table_ip_ranges->data[$i]['total_active_p2p'] > 0 ? $table_ip_ranges->data[$i]['total_active_p2p'] . " " . $lang['backbones_abbr'] : "") . ($table_ip_ranges->data[$i]['total_active_aps'] > 0 ? " + " . $table_ip_ranges->data[$i]['total_active_aps'] . " " . $lang['aps_abbr'] : "");
                $table_ip_ranges->info['EDIT'][$i] = make_ref('/hostmaster/range', array("iprange" => $table_ip_ranges->data[$i]['id']));
            }
        }
        $table_ip_ranges->info['EDIT_COLUMN'] = 'ip_range';
        $table_ip_ranges->info['MULTICHOICE_LABEL'] = 'delete';
        $table_ip_ranges->db_data_remove('id', 'ip_start', 'ip_end', 'total_active_p2p', 'total_active_aps');
        $table_ip_ranges->db_data_translate('ip_ranges__status', 'ip_ranges__delete_req');
        return $table_ip_ranges;
    }
开发者ID:southern-wind,项目名称:wind,代码行数:58,代码来源:hostmaster_ranges.php


示例12: __construct

 public function __construct(PDO $pdo, table $table, array $parameters = array(), array $data = array())
 {
     $this->pdo = $pdo;
     $this->table = $table;
     $this->fields = '';
     $this->order = $table->getDefaultOrder();
     $this->limit = array();
     $this->data = $data;
     $this->queryType = '';
     $this->queryText = '';
     $this->parameters = $parameters;
     $this->validationRules = $table->getValidationRules();
 }
开发者ID:stanhelen87,项目名称:OOOO,代码行数:13,代码来源:query.php


示例13: table_nodes

    function table_nodes()
    {
        global $construct, $db, $main, $lang;
        $form_search_nodes = $this->form_search_nodes();
        $where = $form_search_nodes->db_data_where(array("nodes__name" => "starts_with", "total_active_peers" => 'exclude', "total_active_clients" => 'exclude', "has_ap" => 'exclude'));
        $having = $form_search_nodes->db_data_where(array("nodes__id" => "exclude", "nodes__name" => "exclude", "areas__id" => "exclude", "regions__id" => "exclude", "has_ap" => 'exclude'));
        if ($form_search_nodes->data[6]['value'] != '') {
            $having .= ($having != '' ? ' AND ' : '') . 'total_active_aps ' . ($form_search_nodes->data[6]['value'] == 'Y' ? '>' : '=') . ' 0';
        }
        $table_nodes = new table(array('TABLE_NAME' => 'table_nodes'));
        $table_nodes->db_data('nodes.id,
        	nodes.name AS nodes__name,
        	areas.name AS areas__name,
			communities.name AS communities__name,
        	COUNT(DISTINCT p2p.id) AS total_active_p2p,
        	COUNT(DISTINCT aps.id) AS total_active_aps,
        	COUNT(DISTINCT p2p.id)+COUNT(DISTINCT client.id) AS total_active_peers,
        	COUNT(DISTINCT cl.id) AS total_active_clients,  nodes.freeifs AS nodes__freeifs', 'nodes
			LEFT JOIN areas ON nodes.area_id = areas.id
			LEFT JOIN regions ON areas.region_id = regions.id
			LEFT JOIN communities ON nodes.community_id = communities.id
			LEFT JOIN links ON nodes.id = links.node_id AND links.status = "active"
			LEFT JOIN links AS client ON links.peer_ap_id = client.id
									  AND links.type = "client"
									  AND client.type = "ap"
									  AND client.status = "active"
			LEFT JOIN links AS p2p ON p2p.peer_node_id = links.node_id
								   AND links.peer_node_id = p2p.node_id
								   AND links.type = "p2p"
								   AND p2p.type = "p2p"
								   AND p2p.status = "active"
			LEFT JOIN links AS aps ON nodes.id = aps.node_id
								   AND aps.type = "ap"
								   AND aps.status = "active"
			LEFT JOIN links AS cl ON cl.peer_ap_id = aps.id
								  AND cl.type = "client"
								  AND cl.status = "active"
			INNER JOIN users_nodes ON nodes.id = users_nodes.node_id 
			LEFT JOIN users ON users.id = users_nodes.user_id', 'users.status = "activated"' . ($where != '' ? ' AND (' . $where . ')' : ""), 'nodes.id' . ($having != '' ? ' HAVING (' . $having . ')' : ""), "total_active_peers DESC, total_active_aps DESC, total_active_clients DESC, nodes.id");
        $table_nodes->db_data_search($form_search_nodes);
        for ($i = 1; $i < count($table_nodes->data); $i++) {
            if (isset($table_nodes->data[$i])) {
                $table_nodes->data[$i]['nodes__name'] .= " (#" . $table_nodes->data[$i]['id'] . ")";
                $table_nodes->data[$i]['total_active_peers'] = $table_nodes->data[$i]['total_active_peers'] . ($table_nodes->data[$i]['total_active_aps'] > 0 ? " (+" . $table_nodes->data[$i]['total_active_aps'] . " " . $lang['aps'] . ")" : "");
                $table_nodes->info['EDIT'][$i] = makelink(array("page" => "nodes", "node" => $table_nodes->data[$i]['id']));
            }
        }
        $table_nodes->info['EDIT_COLUMN'] = 'nodes__name';
        $table_nodes->db_data_remove('id', 'total_active_p2p', 'total_active_aps');
        return $table_nodes;
    }
开发者ID:codeministry,项目名称:wind-ng-mc,代码行数:51,代码来源:nodes_search.php


示例14: generate

 function generate()
 {
     $this->appendSuperHeader();
     $code = "";
     $tables = $this->getTablesArray();
     $code .= $this->getCodeStarter();
     for ($a = 0; $a < count($tables); $a++) {
         $thisTable = new table($tables[$a], $this->getDb());
         $fields = $thisTable->getFieldNameArray();
         $code .= $this->getLineEnder();
         $code .= "// " . $thisTable->getTableName() . " Table" . $this->getLineEnder();
         $code .= "define(\"TABLE_" . strtoupper($tables[$a]) . "\",\"" . $thisTable->getTableName() . "\");" . $this->getLineEnder();
         $code .= "// Primary Key for Table " . $thisTable->getTableName() . $this->getLineEnder();
         $code .= "define(\"FIELD_" . strtoupper($tables[$a]) . "_PK\",\"" . $thisTable->getPrimaryKey() . "\");" . $this->getLineEnder();
         $code .= "// Field Name Mapping for Table " . $thisTable->getTableName() . $this->getLineEnder();
         for ($b = 0; $b < count($fields); $b++) {
             $code .= "define(\"FIELD_" . strtoupper($tables[$a]) . "_" . strtoupper($fields[$b]) . "\",\"" . $fields[$b] . "\");" . $this->getLineEnder();
         }
         $code .= "// Display Labels of Field for Table " . $thisTable->getTableName() . $this->getLineEnder();
         for ($c = 0; $c < count($fields); $c++) {
             $code .= "define(\"LABEL_" . strtoupper($tables[$a]) . "_" . strtoupper($fields[$c]) . "\",\"" . ucfirst(strtolower($fields[$c])) . "\");" . $this->getLineEnder();
         }
         $code .= $this->getLineEnder();
     }
     $code .= $this->getCodeEnder();
     $this->appendToCode($code);
     $beautifulCode = codeBeautifier::beautify($this->getSourceCode());
     return $beautifulCode;
 }
开发者ID:juddy,项目名称:GIP,代码行数:29,代码来源:genieCommonDbConstantsGenerator.plugin.class.php


示例15: table_communities

 function table_communities()
 {
     global $construct, $db, $lang;
     $form_search_communities = $this->form_search_communities();
     $where = "";
     #$form_search_communities->db_data_where();
     $table_communities = new table(array('TABLE_NAME' => 'table_communities', 'FORM_NAME' => 'table_communities'));
     $table_communities->db_data('communities.id, communities.name,communities.fullname, communities.windURL, communities.TOS, communities.dnstld, communities.ns1, communities.ns2, communities.admins', 'communities', $where, '', "communities.id ASC");
     $table_communities->db_data_search($form_search_communities);
     foreach ((array) $table_communities->data as $key => $value) {
         if ($key != 0) {
             if ($table_communities->data[$key]['ns1']) {
                 $table_communities->data[$key]['ns1'] = long2ip($table_communities->data[$key]['ns1']);
                 #if ($table_services->data[$key]['protocol'] && $table_communities->data[$key]['port']) {
                 #	$table_services->data[$key]['ip'] .= ' ('.$lang['db']['nodes_services__protocol-'.$table_communities->data[$key]['protocol']].'/'.$table_communities->data[$key]['port'].')';
                 #}
             }
             if ($table_communities->data[$key]['ns2']) {
                 $table_communities->data[$key]['ns2'] = long2ip($table_communities->data[$key]['ns2']);
             }
             $cadmins = explode(",", $table_communities->data[$key]['admins']);
             #print_r($cadmins);echo "admins<br>";
             foreach ($cadmins as $key_name => $key_value) {
                 $i++;
                 #print_r($key_value);
                 $queryusers = $db->query("SELECT\n\t\t\t\t\t\t\t\t\tusers.username\n\t\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tusers\n\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\tusers.id =  '{$key_value}'\n\t\t\t\t\t\t\t\t\t");
                 $usernames = mysql_fetch_assoc($queryusers);
                 #echo $usernames['username'];
                 $cadmins[$key_name] = $usernames['username'];
                 #echo $cadmins[$key_name];
                 #print_r($usernames);
                 #$cadmins[$key_name]=$usernames[$i];#echo "users:$key_name:$key_value<br>"; print_r($usernames);
                 #$new=implode(",",$usernames);
                 #$basket = array_replace_recursive($base, $replacements);print_r($basket);
                 #$usernames_comma_separated = implode(",", $usernames);
                 #$basket = array_combine($cadmins, $usernames);print_r($basket);
             }
             #$basket = array_combine($cadmins, $usernames);print_r($basket);
             $table_communities->data[$key]['admins'] = implode(", ", $cadmins);
             #		$cadmins->data[$k]['links__ip'] = $cadmins->data[$k]['links__ip'];#@#
             #$table_communities->data[$key]['nodes__name'] .= " (#".$table_communities->data[$key]['nodes__id'].")";
             #$table_communities->info['LINK']['nodes__name'][$key] = makelink(array("page" => "nodes", "node" => $table_communities->data[$key]['nodes__id']));
             #$table_communities->info['LINK']['services__title'][$key] = $table_communities->data[$key]['url'];
         }
     }
     #$table_communities->db_data_translate('communities__TOS');
     $table_communities->db_data_remove('TOS');
     return $table_communities;
 }
开发者ID:codeministry,项目名称:wind-ng-mc,代码行数:49,代码来源:communities.php


示例16: selectKeywordGenerator

 function selectKeywordGenerator($table, $db, $selectedFieldsArray = "", $orderByArray = "", $orderDirection = "", $startLimit = "", $numOfRows = "", $distinct = "", $wherePk = "")
 {
     $thisTable = new table($table, $db);
     $fieldNames = $thisTable->getFieldNameArray();
     $whereString = " WHERE ";
     $fieldCount = count($fieldNames);
     for ($c = 0; $c < $fieldCount; $c++) {
         $whereString .= $fieldNames[$c] . " like '%\$thisKeyword%' ";
         if ($c != $fieldCount - 1) {
             $whereString .= " OR ";
         }
     }
     $this->setWhereString($whereString);
     $this->constructSQL($thisTable);
 }
开发者ID:juddy,项目名称:GIP,代码行数:15,代码来源:selectKeywordGenerator.class.php


示例17: _make_user_table

function _make_user_table($n, &$data)
{
    $dbh = getdbh();
    //pagination
    $stmt = $dbh->query('SELECT count(*) "total" FROM "users"');
    $rs = $stmt->fetch(PDO::FETCH_ASSOC);
    $total = $rs['total'];
    $limit = $GLOBALS['pagination']['per_page'];
    $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>';
    $data['body'][] = pagination::makePagination($n, $total, myUrl('users/manage'), $GLOBALS['pagination']);
    //table
    $stmt = $dbh->query("SELECT * FROM \"users\" LIMIT {$n},{$limit}");
    $tablearr[] = explode(',', 'uid,username,password,fullname,created_dt,Action');
    while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $uid = $rs['uid'];
        $row = null;
        foreach ($rs as $k => $v) {
            $row[$k] = htmlspecialchars($v);
        }
        $row[] = '<a href="' . myUrl("users/edit/{$uid}") . '">Edit</a> | <a href="javascript:jsconfirm(\'Really Delete User?\',\'' . myUrl("users/ops_delete/{$uid}") . '\')">Delete</a>';
        $tablearr[] = $row;
    }
    $data['body'][] = table::makeTable($tablearr);
    $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>';
}
开发者ID:469306621,项目名称:Languages,代码行数:25,代码来源:manage.php


示例18: _make_html_table

function _make_html_table($table, $item, $urlPrefix, $n, &$data)
{
    $dbh = getdbh();
    //pagination
    $stmt = $dbh->query("SELECT count(OID) total FROM {$table}");
    $total = $stmt->fetchColumn();
    $limit = $GLOBALS['pagination']['per_page'];
    $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>';
    $data['body'][] = pagination::makePagination($n, $total, myUrl("{$urlPrefix}/manage"), $GLOBALS['pagination']);
    //table
    $fields = "URL,stationId,lastContact,debug";
    $stmt = $dbh->query("SELECT OID,CID,{$fields} FROM {$table} LIMIT {$n},{$limit}");
    if ($stmt === false) {
        var_dump($dbh->errorInfo());
        return;
    }
    $tablearr[] = explode(',', $fields);
    while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $OID = $rs['OID'];
        $CID = $rs['CID'];
        $row = null;
        foreach ($tablearr[0] as $f) {
            $row[] = htmlspecialchars($rs[$f]);
        }
        $row[] = '<a href="' . myUrl("{$urlPrefix}/ops_reset/{$OID}/{$CID}") . '">Reset</a> | ' . '<a href="' . myUrl("{$urlPrefix}/ops_shutdown/{$OID}/{$CID}") . '">Shutdown</a> | ' . '<a href="' . myUrl("{$urlPrefix}/edit/{$OID}/{$CID}") . '">Edit</a> | ' . '<a href="javascript:jsconfirm(\'Really Delete ' . $item . '?\',\'' . myUrl("{$urlPrefix}/ops_delete/{$OID}/{$CID}") . '\')">Delete</a>';
        $tablearr[] = $row;
    }
    $data['body'][] = table::makeTable($tablearr);
    $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>';
}
开发者ID:brata-hsdc,项目名称:brata.masterserver,代码行数:30,代码来源:manage.php


示例19: table_areas

    function table_areas()
    {
        global $construct, $db;
        $table_areas = new table(array('TABLE_NAME' => 'table_areas', 'FORM_NAME' => 'table_areas'));
        $table_areas->db_data('"" AS ip_range, areas.name AS areas__name, regions.name AS regions__name, areas.ip_start, areas.ip_end', 'areas
			LEFT JOIN regions ON areas.region_id = regions.id', "", "", "areas.ip_start ASC");
        foreach ((array) $table_areas->data as $key => $value) {
            if ($key != 0) {
                $table_areas->data[$key]['ip_start'] = long2ip($table_areas->data[$key]['ip_start']);
                $table_areas->data[$key]['ip_end'] = long2ip($table_areas->data[$key]['ip_end']);
                $table_areas->data[$key]['ip_range'] = $table_areas->data[$key]['ip_start'] . " - " . $table_areas->data[$key]['ip_end'];
            }
        }
        $table_areas->db_data_remove('ip_start', 'ip_end');
        return $table_areas;
    }
开发者ID:codeministry,项目名称:wind-ng-mc,代码行数:16,代码来源:ranges_allocation.php


示例20: __construct

 public function __construct()
 {
     parent::__construct();
     $this->set_table(S_DB_PREFIX . 'message');
     $this->set_where("mes_lang = '" . S_LANG . "'");
     $this->set_order('mes_id');
 }
开发者ID:jechiy,项目名称:xiu-cms,代码行数:7,代码来源:message.class.php



注:本文中的table类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP table_class类代码示例发布时间:2022-05-23
下一篇:
PHP t3lib_iconWorks类代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap