select_row PHP Code Examples

Example #1

0

Show file

File: dailysales.php Project: BGCX067/fa-dashboard-module-svn-to-git

 function edit_param()
 {
     global $top, $sequences, $asc_desc;
     $graph_types = array('LineChart' => _("Line Chart"), 'ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of weeks:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type:"), "graph_type", null, $graph_types, null);
 }

Example #2

0

Show file

File: index.php Project: Jeffery-Cai/jinlingV1-1

<?php

require "include/init/init.php";
session_start();
// 产品
$data2 = select_all("SELECT * FROM jl_products ORDER BY products_id DESC LIMIT 0,5");
// 新闻
$data3 = select_all("SELECT * FROM jl_news ORDER BY news_id DESC LIMIT 0,5");
// 通知
$data4 = select_all("SELECT * FROM jl_notice ORDER BY notice_id DESC LIMIT 0,5");
// 友链
$data5 = select_all("SELECT * FROM jl_friend ORDER BY friend_id DESC LIMIT 0,20");
// 网站设置
$optiondata = select_row("SELECT * FROM jl_option");
// 公司简介
// $data6=select_row("SELECT * FROM jl_document WHERE document_id=1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title></title>
	<meta name="keywords" content="<?php 
echo $optiondata["keyword"];
?>
" />
	<meta name="description" content="<?php 
echo $optiondata["description"];
?>
" />
	<link rel="stylesheet" type="text/css" href="css/reset.css">

Example #3

0

Show file

File: contact.php Project: Jeffery-Cai/jinlingV1-1

<?php

require "include/init/init.php";
$contactData = select_row("SELECT * FROM jl_document WHERE document_id=2");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title>金陵贸易有限公司-<?php 
echo $contactData["document_name"];
?>
</title>
	<link rel="stylesheet" type="text/css" href="css/reset.css">
	<link rel="stylesheet" type="text/css" href="css/contact.css">
	<script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
</head>
<body>
	<div id="container">
		<?php 
require "include/header.php";
?>
		<div id="main">
			<img src="images/index-main-bigImg.png" style="margin:1px 0 0 46px;" />
			<div class="content">
				<?php 
echo $contactData["document_content"];
?>
				<?php 
require "include/child_silde.php";
?>

Example #4

0

Show file

File: show.php Project: jcfischer/AvatarHotel

---
  title: Avatar Hotel - Show
---
          <?php 
include '../../php/db.php';
include '../../php/form.php';
$id = params('id');
$table = params('table');
$pk = params('pk');
open_db();
$found = select_row($table, $pk, $id);
?>
          <h1>Show Details</h1>
          <?php 
if (!$found == FALSE) {
    ?>
          <table id='show_details'>
            <thead>
              <th>Field</th>
              <th>Value</th>
            </thead>
            <tbody>
              <?php 
    $ncols = odbc_num_fields($dbResult);
    for ($n = 1; $n <= $ncols; $n++) {
        $field_name = odbc_field_name($dbResult, $n);
        $fieldData = trim(odbc_result($dbResult, $n));
        echo '<tr>';
        echo "<th>" . $field_name . "</th>";
        echo "<th>" . $fieldData . "</th>";
        echo '</tr>';

Example #5

0

Show file

File: suppliers.php Project: BGCX067/fa-dashboard-module-svn-to-git

 function edit_param()
 {
     global $top;
     $graph_types = array('ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of Suppliers:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type:"), "graph_type", null, $graph_types, null);
 }

Example #6

0

Show file

File: about_us.php Project: Jeffery-Cai/jinlingV1-1

<?php

require "include/init/init.php";
$aboutData = select_row("SELECT * FROM jl_document WHERE document_id=1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title>金陵贸易有限公司-<?php 
echo $aboutData["document_name"];
?>
</title>
	<link rel="stylesheet" type="text/css" href="css/reset.css">
	<link rel="stylesheet" type="text/css" href="css/about_us.css">
	<script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
</head>
<body>
	<div id="container">
		<?php 
require "include/header.php";
?>
		<div id="main">
			<img src="images/index-main-bigImg.png" style="margin:1px 0 0 46px;" />
			<div class="content">
				<?php 
echo $aboutData["document_content"];
?>
				<?php 
require "include/child_silde.php";
?>

Example #7

0

Show file

File: items.php Project: BGCX067/fa-dashboard-module-svn-to-git

 function edit_param()
 {
     global $top;
     $item_types = array('stock' => _("Stock"), 'manuf' => _("Manufactured"));
     $graph_types = array('PieChart' => _("Pie Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['item_type'] = $this->item_type;
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of items:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type"), "graph_type", null, $graph_types, null);
     select_row(_("Item Type"), "item_type", null, $item_types, null);
 }

Example #8

0

Show file

File: glreturn.php Project: raqib/ac_dev

 function edit_param()
 {
     global $top, $sequences, $asc_desc;
     $graph_types = array('PieChart' => _("Pie Chart"), 'Table' => _("Table"));
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type"), "graph_type", null, $graph_types, null);
 }

Example #9

0

Show file

File: dailybankbalances.php Project: BGCX067/fa-dashboard-module-svn-to-git

 function edit_param()
 {
     $graph_types = array('LineChart' => _("Line Chart"), 'ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['days_past'] = $this->days_past;
     $_POST['days_future'] = $this->days_future;
     $_POST['bank_act'] = $this->bank_act;
     $_POST['graph_type'] = $this->graph_type;
     text_row_ex(_("Days in past:"), 'days_past', 2);
     text_row_ex(_("Days in future:"), 'days_future', 2);
     bank_accounts_list_cells(_("Account:"), 'bank_act', null);
     select_row(_("Graph Type"), "graph_type", null, $graph_types, null);
 }

Example #10

0

Show file

File: weeklysales.php Project: BGCX067/fa-dashboard-module-svn-to-git

 function edit_param()
 {
     global $top, $sequences, $asc_desc;
     $sequences = array('Week End' => _("Week End Date"), 'Gross Sales' => _("Gross Sales"));
     $asc_desc = array('asc' => _("Ascending"), 'desc' => _("Descending"));
     $graph_types = array('LineChart' => _("Line Chart"), 'ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['orderby'] = $this->orderby;
     $_POST['orderby_seq'] = $this->orderby_seq;
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of weeks:"), 'top', 2);
     select_row(_("Sequence"), "orderby", null, $sequences, null);
     select_row(_("Order"), "orderby_seq", null, $asc_desc, null);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type"), "graph_type", null, $graph_types, null);
 }

Example #11

0

Show file

File: dashboard_setup.php Project: BGCX067/fa-dashboard-module-svn-to-git

$_POST['param'] = '';
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        //editing an existing payment widget
        $myrow = get_dashboard_widget($selected_id);
        $_POST['widget_app'] = $myrow["app"];
        $_POST['column_id'] = $myrow["column_id"];
        $_POST['sort_no'] = $myrow["sort_no"];
        $_POST['description'] = $myrow["description"];
        $_POST['widget'] = $myrow["widget"];
        $_POST['sort_no'] = $myrow["sort_no"];
        $_POST['param'] = $myrow["param"];
    }
    hidden('selected_id', $selected_id);
}
$widget = $app->get_widget(isset($_POST['widget']) ? $_POST['widget'] : $app->widgets[0]->name);
widget_list_row($app->get_widget_list(), _("Widget:"), 'widget', null, true);
text_row_ex(_("Title:"), 'description', 40);
select_row(_("Application Tab:"), "widget_app", null, $app->apps, null);
text_row_ex(_("Column:"), 'column_id', 1);
text_row_ex(_("Sequence:"), 'sort_no', 1);
check_row(_("Collapsed:"), 'collapsed');
include_once $path_to_root . $widget->path;
$className = $widget->name;
$widgetObject = new $className($_POST['param']);
$widgetObject->edit_param();
end_table(1);
div_end();
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();

Example #12

0

Show file

File: reminder_setup.php Project: BGCX067/fa-dashboard-module-svn-to-git

        $myrow = get_dashboard_reminder($selected_id);
        $_POST['role_id'] = $myrow["role_id"];
        $_POST['next_date'] = sql2date($myrow["next_date"]);
        $_POST['description'] = $myrow["description"];
        $_POST['frequency'] = $myrow["frequency"];
        $_POST['param'] = $myrow["param"];
        $data = json_decode(html_entity_decode($_POST['param']));
        $_POST['occurrence'] = coalesce($data, 'occurrence');
    }
    hidden('selected_id', $selected_id);
}
label_cell(_("Role:"), "class='label'");
security_roles_list_cells(null, 'role_id');
date_row(_("Next Date"), 'next_date', '', null, 0, 0, 1001);
textarea_row(_("Description:"), 'description', null, 40, 5);
select_row(_("Frequency:"), "frequency", null, $frequencies, array('select_submit' => true));
switch ($_POST['frequency']) {
    case 'daily':
        text_row_ex(_("Recur every:"), 'occurrence', 3, null, null, null, null, _("days"));
        break;
    case 'weekly':
        text_row_ex(_("Recur every:"), 'occurrence', 3, null, null, null, null, _("weeks"));
        break;
    case 'monthly':
        text_row_ex(_("Recur every:"), 'occurrence', 3, null, null, null, null, _("months"));
        break;
    case 'yearly':
        break;
}
end_table(1);
div_end();

PHP select_row Examples