当前位置: 首页>>代码示例>>PHP>>正文


PHP dbNumRows函数代码示例

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


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

示例1: user_has_page_permissions

function user_has_page_permissions($page_content_id, $type = "manager")
{
    if (in_array('admin', $_SESSION['access_permissions'])) {
        return true;
    }
    if (in_array('god', $_SESSION['access_permissions'])) {
        return true;
    }
    $results = dbQuery('SELECT * FROM user_access_pages WHERE page_content_id = ' . $page_content_id . ' AND user_id = ' . $_SESSION['user_id'] . ' AND user_access_pages_type = "' . $type . '"');
    return dbNumRows($results);
}
开发者ID:sherdog,项目名称:cvsi,代码行数:11,代码来源:functions.user.php

示例2: getOrderAmount

function getOrderAmount($orderId)
{
    $orderAmount = 0;
    $sql = "SELECT SUM(pd_price * od_qty)\r\n\t        FROM tbl_order_item oi, tbl_product p \r\n\t\t    WHERE oi.pd_id = p.pd_id and oi.od_id = {$orderId}\r\n\t\t\t\r\n\t\t\tUNION\r\n\t\t\t\r\n\t\t\tSELECT od_shipping_cost \r\n\t\t\tFROM tbl_order\r\n\t\t\tWHERE od_id = {$orderId}";
    $result = dbQuery($sql);
    if (dbNumRows($result) == 2) {
        $row = dbFetchRow($result);
        $totalPurchase = $row[0];
        $row = dbFetchRow($result);
        $shippingCost = $row[0];
        $orderAmount = $totalPurchase + $shippingCost;
    }
    return $orderAmount;
}
开发者ID:jaherulalom,项目名称:SHOP-1-,代码行数:14,代码来源:checkout-functions.php

示例3: doLogin

function doLogin()
{
    // if we found an error save the error message in this variable
    $errorMessage = '';
    $userName = $_POST['txtUserName'];
    $password = $_POST['txtPassword'];
    //	  $_SESSION['user_id'] = $username;
    // first, make sure the username & password are not empty
    if ($userName == '') {
        $errorMessage = 'You must enter your username';
    } else {
        if ($password == '') {
            $errorMessage = 'You must enter the password';
        } else {
            // check the database and see if the username and password combo do match
            $sql = "SELECT user_id,user_name\n\t\t        FROM tbl_user \n\t\t\t\tWHERE user_name = '{$userName}' AND user_password = '{$password}'";
            $result = dbQuery($sql);
            if (dbNumRows($result) == 1) {
                $row = dbFetchAssoc($result);
                $_SESSION['user_id'] = $row['user_id'];
                $_SESSION['user_name'] = $row['user_name'];
                // log the time when the user last login
                $sql = "UPDATE tbl_user \n\t\t\t        SET user_last_login = NOW() \n\t\t\t\t\tWHERE user_id = '{$row['user_id']}'";
                dbQuery($sql);
                // now that the user is verified we move on to the next page
                // if the user had been in the admin pages before we move to
                // the last page visited
                $row = dbFetchAssoc($result);
                if ($userName == 'admin') {
                    //                            echo $userName;
                    //                            echo'1';
                    header('Location: index.php');
                    exit;
                } else {
                    if ($row['user_level'] == 0) {
                        //                            echo $userName;
                        //                                     echo'2';
                        header("Location: http://localhost/html/main.php");
                        exit;
                    }
                }
            } else {
                $errorMessage = 'Wrong username or password';
            }
        }
    }
    return $errorMessage;
}
开发者ID:joevanni,项目名称:gallantic-shopping-cart,代码行数:48,代码来源:functions.php

示例4: addUser

function addUser()
{
    $userName = $_POST['txtUserName'];
    $password = $_POST['txtPassword'];
    /*
    // the password must be at least 6 characters long and is 
    // a mix of alphabet & numbers
    if(strlen($password) < 6 || !preg_match('/[a-z]/i', $password) ||
    !preg_match('/[0-9]/', $password)) {
      //bad password
    }
    */
    // check if the username is taken
    $sql = "SELECT user_name\n\t        FROM tbl_user\n\t\t\tWHERE user_name = '{$userName}'";
    $result = dbQuery($sql);
    if (dbNumRows($result) == 1) {
        header('Location: index.php?view=add&error=' . urlencode('Username already taken. Choose another one'));
    } else {
        $sql = "INSERT INTO tbl_user (user_name, user_password, user_regdate)\n\t\t          VALUES ('{$userName}', PASSWORD('{$password}'), NOW())";
        dbQuery($sql);
        header('Location: index.php');
    }
}
开发者ID:joevanni,项目名称:gallantic-shopping-cart,代码行数:23,代码来源:processUser.php

示例5: recurse_pages

function recurse_pages($id = 0, $level = 0)
{
    $level++;
    $sql = "SELECT * FROM page_content WHERE parent = " . $id . " ORDER BY page_content_title ASC";
    $pageResults = dbQuery($sql);
    $count = 0;
    while ($pInfo = dbFetchArray($pageResults)) {
        $padding = 18 * $level;
        if ($level != 1) {
            $style = "style=\"padding-left:" . ($padding + 18) . "px; background-repeat:no-repeat; background-position:" . $padding . "px 0px; background-image:url(images/directory_arrow.gif);\"";
        } else {
            $class = "";
        }
        //SECURITY CHECK
        //ONLY SHOW PAGES THAT THE USER HAS ACCESS TOO
        $row = $count % 2;
        echo "<tr>\n";
        echo "<td  nowrap width=\"1\">\n";
        if ($pInfo['page_content_member']) {
            echo "<a href=\"javascript:void(0);\" title=\"Membership Required\"><img src=\"images/icons/lock_16x16.gif\" border=\"0\"><a>";
        }
        echo "</td>\n";
        echo "<td nowrap width\"1\">" . date('m/d/Y', $pInfo['page_content_publish_date']) . "</td>\n";
        echo "<td " . $style . "><a href=\"" . PAGE_MANAGE . "?action=edit&section=webpage&id=" . $pInfo['page_content_id'] . "\">" . output($pInfo['page_content_title']) . "</a></td>\n";
        echo "<td nowrap width\"1\">";
        if ($pInfo['page_content_status'] == 'pending') {
            echo "<span class=\"textPending\">Pending</span>";
        } else {
            if ($pInfo['page_content_status'] == 'published') {
                echo "<span class=\"textActive\">Published</span>";
            } else {
                echo "<span class=\"textInactive\">Unpublished</span>";
            }
        }
        echo "</td>\n";
        echo "<td nowrap width\"1\">\n";
        echo "<span class=\"smallText\"><abbr title=\"by " . getAuthor($pInfo['page_content_author']) . "\" style=\"margin:2px;\">Created: " . date('m/d/y g:i a', $pInfo['page_content_added']) . " </abbr></span>\n";
        //check to see if this page has been edited
        //display
        $modifiedResults = dbQuery('SELECT * FROM page_content_log WHERE page_content_id = ' . $pInfo['page_content_id'] . ' LIMIT 1');
        if (dbNumRows($modifiedResults)) {
            $m = dbFetchArray($modifiedResults);
            echo "<br>";
            echo "<span class=\"smallText\" style=\"font-style:italic;\"><abbr style=\"margin:2px;\" title=\"by " . getAuthor($m['user_id']) . "\">Last Modified: " . date('m/d/y g:i a', $m['page_content_log_timestamp']) . "</abbr></span>";
        }
        echo "</td>\n";
        echo "<td align=\"right\" >";
        if ($level == 1) {
            echo "<a class=\"table_addsubpage_link\" href=\"" . PAGE_PUBLISH . "?section=webpage&parent=" . $pInfo['page_content_id'] . "\" title=\"Add Sub Page\">Add Subpage</a>";
            echo " ";
        }
        if (user_has_permission('banners')) {
            //echo "<a class=\"table_banner_link\" href=\"".PAGE_MANAGE."?action=banners&section=webpage&id=".$pInfo['page_content_id']."\" title=\"Add Banner\">Advert</a>\n";
            //echo " ";
        }
        if (user_has_permission('content') && user_has_page_permissions($pInfo['page_content_id'])) {
            echo "<a class=\"table_edit_link\" href=\"" . PAGE_MANAGE . "?action=edit&section=webpage&id=" . $pInfo['page_content_id'] . "\" title=\"Edit " . output($pInfo['page_content_title']) . "\">Edit</a>\n";
            echo " ";
        }
        if (user_has_permission('admin')) {
            echo "<a class=\"table_delete_link\" href=\"" . PAGE_MANAGE . "?action=delete&section=webpage&id=" . $pInfo['page_content_id'] . "\" title=\"Delete " . output($pInfo['page_content_title']) . "\" onclick=\"return confirm('Are you sure you want to delete this page? THIS IS NOT UNDOABLE');\">Delete</a>\n";
        }
        echo "</td>\n";
        echo "</tr>\n";
        recurse_pages($pInfo['page_content_id'], $level);
        $count++;
    }
}
开发者ID:sherdog,项目名称:cvsi,代码行数:68,代码来源:functions.general.php

示例6: dbQuery

     $q = "UPDATE articulo SET active = 0 WHERE id={$id_art}";
     $result = dbQuery($q);
     if ($result) {
         echo "exito";
     } else {
         echo "fracaso";
     }
     break;
 case "buscar_articulo":
     $b = $_GET['b'];
     $campo = $_GET['campo'];
     $fila = '';
     $q = "SELECT * FROM articulo WHERE  {$b} LIKE '%" . $campo . "%' AND active = '1'";
     //echo $q;
     $q1 = dbQuery($q);
     $q_tot = dbNumRows($q1);
     if ($q_tot > 0) {
         while ($row = dbFetchAssoc($q1)) {
             if ($row['imagen'] == '' or $row['imagen'] == NULL) {
                 $img_ssc = "noimage.png";
             } else {
                 $img_ssc = $row['imagen'];
             }
             $retorno = "'" . $row['id'] . '|' . $row['codigo'] . '|' . $row['codant'] . '|' . $row['nombre'] . '|' . $row['marca_id'] . '|';
             $retorno .= $row['categoria_id'] . '|' . $row['scategoria_id'] . '|' . $row['sscategoria_id'] . '|' . $row['uni_med'] . '|';
             $retorno .= $row['detalle'] . '|' . $row['peso'] . '|' . $row['caja'] . '|' . $row['mayoreo'] . '|' . $row['codigo_barra'] . '|' . $img_ssc;
             $retorno .= "'";
             //$retorno = $row['id'].';'.$row['codigo'].';'.$row['nombre'].';'.$row['marca_id'].';'.$row['categoria_id'].';'.$row['scategoria_id'].';'.$row['detalle'];
             //$retorno = $row['id'].'#'.$row['codigo'].'#'.$row['nombre'].'#'.$row['marca_id'].'#'.$row['categoria_id'].'#'.$row['scategoria_id'].'#'.$row['detalle'];
             $fila .= '<tr  style="cursor:pointer"  onClick="obtener_articulo(' . ps($retorno) . ')">';
             $nombre = $row['nombre'];
开发者ID:axeljosue12,项目名称:disgene,代码行数:31,代码来源:ajax.php

示例7: dbQuery

        </div>
      </div>
    </div>

  <div class="container-fluid">
    <div class="row">
         <div class="col-md-3 col-md-2 sidebar">
            <ul class="nav nav-sidebar">
               <?php 
    $link = "#";
    $m = "SELECT * FROM modulo WHERE active = '1' AND tipo = 1 and padre=" . $_GET['m'];
    $m1 = dbQuery($m);
    while ($mrow = dbFetchAssoc($m1)) {
        $p = "SELECT * from permiso WHERE usuario_id =" . $_SESSION['id_user'] . " AND modulo_id = " . $mrow['id'];
        $p1 = dbQuery($p);
        $pfila = dbNumRows($p1);
        if ($mrow['link'] === NULL) {
            $link = "#";
        } else {
            $link = $mrow['link'] . '?m=' . $mrow['padre'];
        }
        if ($pfila > 0) {
            ?>
              <li class="<?php 
            if ($mrow['nombre'] == 'SSCategoria') {
                echo 'active';
            }
            ?>
"><a href="<?php 
            echo $link;
            ?>
开发者ID:axeljosue12,项目名称:disgene,代码行数:31,代码来源:index.bu.php

示例8: _deleteImage

function _deleteImage($catId)
{
    // we will return the status
    // whether the image deleted successfully
    $deleted = false;
    // get the image(s)
    $sql = "SELECT cat_image \n            FROM tbl_category\n            WHERE cat_id ";
    if (is_array($catId)) {
        $sql .= " IN (" . implode(',', $catId) . ")";
    } else {
        $sql .= " = {$catId}";
    }
    $result = dbQuery($sql);
    if (dbNumRows($result)) {
        while ($row = dbFetchAssoc($result)) {
            // delete the image file
            $deleted = @unlink(SRV_ROOT . CATEGORY_IMAGE_DIR . $row['cat_image']);
        }
    }
    return $deleted;
}
开发者ID:joevanni,项目名称:gallantic-shopping-cart,代码行数:21,代码来源:processCategory.php

示例9: dbNumRows

 $season_signups = dbNumRows($season_users_ref);
 // Matches
 $matches_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}matches` " . "WHERE `confirmed` <> '0000-00-00 00:00:00' AND `id_season` = {$seasons_row['id']}");
 $season_matches = dbNumRows($matches_ref);
 // Played matches
 $matches_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}matches` " . "WHERE `wo` = 0 AND `bye` = 0 AND `out` = 0 AND `confirmed` <> '0000-00-00 00:00:00' " . "AND `id_season` = {$seasons_row['id']}");
 $season_played = dbNumRows($matches_ref);
 // Walkovers
 $matches_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}matches` " . "WHERE `wo` <> 0 AND `confirmed` <> '0000-00-00 00:00:00' AND `id_season` = {$seasons_row['id']}");
 $season_wos = dbNumRows($matches_ref);
 // Byes
 $matches_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}matches` " . "WHERE `bye` = 1 AND `confirmed` <> '0000-00-00 00:00:00' AND `id_season` = {$seasons_row['id']}");
 $season_byes = dbNumRows($matches_ref);
 // Outs
 $matches_ref = dbQuery("SELECT * FROM `{$cfg['db_table_prefix']}matches` " . "WHERE `out` = 1 AND `confirmed` <> '0000-00-00 00:00:00' AND `id_season` = {$seasons_row['id']}");
 $season_outs = dbNumRows($matches_ref);
 $content_tpl->set_var("I_SEASON_NAME", htmlspecialchars($seasons_row['name']));
 if ($seasons_row['status'] == "") {
     $content_tpl->parse("I_LED", "B_LED_RED");
 } elseif ($seasons_row['status'] == "signups") {
     $content_tpl->parse("I_LED", "B_LED_ORANGE");
 } elseif ($seasons_row['status'] == "running") {
     $content_tpl->parse("I_LED", "B_LED_GREEN");
 } elseif ($seasons_row['status'] == "finished") {
     $content_tpl->parse("I_LED", "B_LED_DONE");
 }
 $content_tpl->set_var("I_SIGNUPS", $season_signups);
 $content_tpl->set_var("I_MATCHES", $season_matches);
 $content_tpl->set_var("I_PLAYED", $season_played);
 $content_tpl->set_var("I_WOS", $season_wos);
 $content_tpl->set_var("I_BYES", $season_byes);
开发者ID:eb,项目名称:phptourney,代码行数:31,代码来源:view_matches.php

示例10: IFNULL

                                              <td> 
                                                <input id="search_loco_nombre"  onkeyup="DelayedCallMe(2)" class="typeahead col-sm-12 col-md-12 col-lg-12" type="text" placeholder="Nombre" data-provide="typeahead" autocomplete="off">
                                              </td>

                                              <td> 
                                                <input id="marca_addlinea" type="text"  class="form-control input-xs" disabled>
                                              </td>
                                            
                                              <td align="right">
                                                <button onClick="agregar_linea_nueva()" class="btn btn-primary btn-xs" ><span class="glyphicon glyphicon-plus"></span></button>
                                              </td>
                                          </tr>
                                          <?php 
    $pd = "SELECT a.codigo as codigo, pd.cantidad as cantidad, \n                                                      (SELECT nombre FROM variados WHERE tipo=2 AND id=a.uni_med) as uni_med, \n                                                      a.nombre as nombre,(SELECT nombre FROM marca where id = a.marca_id) as marca, \n                                                      pd.id as ingreso_d_id,\n                                                      IFNULL((SELECT stock FROM inventario where active = 1 AND articulo_id=pd.articulo_id),0) as stock\n                                                FROM ingreso_d as pd, articulo as a\n                                                WHERE pd.active = 1 AND pd.ingreso_id={$id_ingreso} AND pd.articulo_id = a.id";
    $pd1 = dbQuery($pd);
    $pd_num = dbNumRows($pd1);
    if ($pd_num > 0) {
        while ($pd2 = dbFetchAssoc($pd1)) {
            ?>

                                          <tr id= "linea_<?php 
            echo $pd2['ingreso_d_id'];
            ?>
"  >
                                             <td><?php 
            echo '<small>' . $pd2['codigo'] . '</small>';
            ?>
</td>

                                            <td>
                                              <input onMouseover="ver_saldo(<?php 
开发者ID:axeljosue12,项目名称:disgene,代码行数:31,代码来源:index.php

示例11: dashboard

function dashboard()
{
    global $TLD, $domain_expires, $tld_db;
    show_header();
    $username = $_SESSION['username'];
    $userid = $_SESSION['userid'];
    // echo "<p align=\"right\"><a href=\"user.php?action=logout\">Logout</a></p>\n";
    echo "<center><H2>Welcome to " . $username . "'s Dashboard for ." . $TLD . "</H2>\n";
    echo "<b>My ." . $TLD . " domains</b><BR><BR>";
    $base = database_open_now($tld_db, 0666);
    $query = "SELECT domain, registered, expires FROM domains WHERE userid=" . $userid . "";
    $results = database_query_now($base, $query);
    if (dbNumRows($results)) {
        echo "<table width=\"400\" align=\"center\" border=0 cellspacing=1 cellpadding=0>\n";
        echo "<tr><td>Domain Name</td><td>Created</td>";
        if ($domain_expires == 1) {
            echo "<td>Expires</td>";
        }
        echo "</tr>\n";
        while ($arr = database_fetch_array_now($results)) {
            echo "<tr><td><a href=\"domain.php?action=modify&domain=" . $arr['domain'] . "\">" . $arr['domain'] . '.' . $TLD . "</a></td><td>" . $arr['registered'] . "</td>";
            if ($domain_expires == 1) {
                echo "<td>" . $arr['expires'] . "</td>";
            }
            echo "</tr>\n";
        }
        echo "</table>\n";
    } else {
        echo "You do not have any domains registered.\n";
    }
    echo "You can register a new " . $TLD . " <a href=\"domain.php?action=frm_check_domain\">here</a>.";
    $get_user_details = "SELECT name, email, country FROM users WHERE userid='" . $userid . "' AND username='" . $username . "' LIMIT 1";
    $base = database_open_now($tld_db, 0666);
    $get_user_details_results = database_query_now($base, $get_user_details);
    $get_user_details_arr = database_fetch_array_now($get_user_details_results);
    $name = $get_user_details_arr['name'];
    $email = $get_user_details_arr['email'];
    $country = $get_user_details_arr['country'];
    ?>
<BR><BR>
<form action="user.php" method="post">
<table width="450" align="center">
<tr><td colspan="2" align="center"><b>.<?php 
    echo $TLD;
    ?>
 User Details</b></td></tr>
<tr><td>Name</td><td><?php 
    echo $name;
    ?>
</td></tr>
<tr><td>Email</td><td><?php 
    echo $email;
    ?>
<sup>*</sup></td></tr>
<tr><td>Country</td><td>
<select name="country">
<?php 
    if (strlen($country) > 0) {
        echo "<option value=\"" . $country . "\" selected>Current (" . $country . ")</option>\n";
    } else {
        echo "<option>Select</option>\n";
    }
    ?>
<option>------</option>
<option value="AU">Australia</option>
<option value="CA">Canada</option>
<option value="DE">Germany</option>
<option value="MX">Mexico</option>
<option value="UK">United Kingdom</option>
<option value="US">United States</option>
</select><sup>**</sup></td></tr>
<tr><td>Current Password</td><td><input type="password" name="password"></td></tr>
<tr><td valign="top">Password</td><td><input type="password" name="password1"><BR><font size="-1">(Must be at least 5 characters long)</font></td></tr>
<tr><td>Password Confirm</td><td><input type="password" name="password2"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="submit" value="Update"></td></tr>
<input type="hidden" name="action" value="update_account">
<tr><td colspan="2">
<font size="-1">
<sup>*</sup>Please contact support to change this.<BR>
<sup>**</sup>This is optional and for our statistics only.
</font></td></tr>
</table>
</form>
<?php 
    echo "</center>";
}
开发者ID:smiba,项目名称:opennic-mud4tld,代码行数:86,代码来源:user.php

示例12: dbFetchArray

											$fInfo = dbFetchArray($filterResults);
											$title .= " to " . strtolower($fInfo['subscriber_lists_name']) . ' list';
											$contactLists[] = $fInfo['subscriber_lists_id'];	
										}
									} 
									if($_GET['action'] == 'edit') {
										$buttonText = "Save contact";
										$subscriberResults = dbQuery('SELECT * FROM subscribers WHERE subscriber_id = ' . $_GET['id']);
										$sInfo = dbFetchArray($subscriberResults);
										$title = "Edit contact";
										$newsletter_agree = $sInfo['subscriber_newsletter_agree'];
										$sms_agree = $sInfo['subscriber_sms_agree'];
										$action = 'save';
										//get contact lists this user is attached to.
										$contactListResults = dbQuery('SELECT * FROM subscriber_to_lists WHERE subscriber_id = ' . $_GET['id']);
										if(dbNumRows($contactListResults)) {
											while($cl = dbFetchArray($contactListResults)) {
												$contactLists[] = $cl['subscriber_lists_id'];	
											}
										} else {
											$contactLists = array(0);	
										}
									}
									?>
                                    <form action="<?=PAGE_COMMUNICATION?>" method="post" id="<?=$action?>subscriber">
                                    <input type="hidden" name="action" value="<?=$action?>subscriber" />
                                    <input type="hidden" name="id" value="<?=$_GET['id']?>" />
                                 <table width="100%" border="0" cellspacing="0" cellpadding="0" >
                                  <tr>
                                    <td valign="top" class="formBody">
                                    <div class="mb20"></div>
开发者ID:sherdog,项目名称:cvsi,代码行数:31,代码来源:communication.php

示例13: DATE

         $paginationQuery .= " DATE(StartTime) >= SUBDATE(CURDATE(), INTERVAL 1 MONTH)";
         break;
     case "custom":
         $query = "SELECT * FROM Events WHERE";
         if (isset($chosencameras)) {
             $query .= " MonitorId IN ('" . implode("','", $chosencameras) . "') AND ";
         }
         $query .= " StartTime >= '{$_REQUEST['startdatetime']}' AND StartTime <= '{$_REQUEST['enddatetime']}' {$orderString} LIMIT {$limit}";
         $paginationQuery = "SELECT COUNT(Id) AS NUMROWS FROM Events WHERE";
         if (isset($chosencameras)) {
             $paginationQuery .= " MonitorId IN ('" . implode("','", $chosencameras) . "') AND";
         }
         $paginationQuery .= " StartTime >= '{$_REQUEST['startdatetime']}' AND StartTime <= '{$_REQUEST['enddatetime']}'";
         break;
 }
 if (dbNumRows($query) < 1) {
     die("<div class=\"alert alert-info\"><p>No events in selected range...</p></div>");
 } else {
     $response = dbFetchAll($query);
     if (!$response) {
         die("ERROR: Failed to fetch events!<br>" . $query);
     } else {
         $skipColumns = array(0 => "Archived", 1 => "Videoed", 2 => "Uploaded", 3 => "Emailed", 4 => "Messaged", 5 => "Executed", 6 => "Width", 7 => "Height", 8 => "Notes", 9 => "Frames", 10 => "AlarmFrames", 11 => "TotScore", 12 => "AvgScore", 13 => "MaxScore", 14 => "Cause");
         echo "<table class=\"table table-striped\">";
         echo "<thead><tr><td>Event Id</td><td>Camera</td><td>Name</td><td>Start Time</td><td>End Time</td><td>Length</td><td></td><td></td><td></td><td><input id=\"check-all\" type=\"checkbox\"></td></tr></thead>";
         foreach ($response as $event) {
             echo "<tr>";
             foreach ($event as $key => $value) {
                 if (in_array($key, $skipColumns)) {
                     continue;
                 }
开发者ID:OverByThere,项目名称:modern,代码行数:31,代码来源:fetchevents.php

示例14: date

</td>
			</tr>	
	<?php 
            }
            //fin del while de abonos/recibos
            ?>
			</tbody>
		</table>
	<?php 
        }
        //fin del if que verifica si existen recibos/abonos a la factura
        ?>
		<?php 
        $nc = "SELECT * , date(fecha_alta) as fa, (SELECT sum(total) FROM nota_credito_d WHERE nota_credito_id=nota_credito.id) as total,\n\t\t\tIF( (SELECT tipo FROM nota_credito_d WHERE nota_credito_id=nota_credito.id group by tipo)='OM','Otro Motivo','Devolucion')\tas tipo\n\t\t\tFROM nota_credito WHERE active = 1 AND factura_id={$id_factura}";
        $nc2 = dbQuery($nc);
        $nc_count = dbNumRows($nc2);
        if ($nc_count > 0) {
            ?>
		Notas De Credito
		<table class="table table-condensed " >
			<thead >
				<th bgcolor="#DAA520">No.</th>
				<th bgcolor="#DAA520">Fecha</th>
				<th bgcolor="#DAA520">Tipo</th>
				<th bgcolor="#DAA520">Total</th>
				
			</thead>
			<tbody>
	<?php 
            while ($row = dbFetchAssoc($nc2)) {
                ?>
开发者ID:axeljosue12,项目名称:disgene,代码行数:31,代码来源:ajax.php

示例15: dbQuery

            ?>
 ></div>
                  <span ><i class="icon-folder-open"></i> <?php 
            echo $row['nombre'];
            ?>
</span> 
                  
                  <ul>
                    
                      <?php 
            $sc = "SELECT * FROM modulo WHERE active = 1 AND padre = " . $row['id'];
            $sc1 = dbQuery($sc);
            while ($sc2 = dbFetchAssoc($sc1)) {
                $pom = "SELECT * FROM permiso WHERE active = 1 AND usuario_id = {$id_usuario} AND modulo_id=" . $sc2['id'];
                $pom1 = dbQuery($pom);
                $pexiste_permiso = dbNumRows($pom1);
                ?>
                      <li> 
                           <div class="badge badge-nocolor"> <input type="checkbox" id="chijo_<?php 
                echo $sc2['id'];
                ?>
" name="modulos" value="<?php 
                echo $sc2['id'];
                ?>
" class="hijo_<?php 
                echo $row['id'];
                ?>
" <?php 
                if ($pexiste_permiso > 0) {
                    echo 'checked';
                }
开发者ID:axeljosue12,项目名称:disgene,代码行数:31,代码来源:index.php


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