本文整理汇总了PHP中ps_DB::p方法的典型用法代码示例。如果您正苦于以下问题：PHP ps_DB::p方法的具体用法？PHP ps_DB::p怎么用？PHP ps_DB::p使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ps_DB的用法示例。
在下文中一共展示了ps_DB::p方法的11个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: elseif
function pane_content($tab)
{
global $VM_LANG;
if (vmGet($_REQUEST, 'order_edit_page') == '1') {
?>
<script type="text/javascript">
var current = document.getElementById( "order_edit_page" );
current.tabPage.select();
</script>
<?php
}
if (vmGet($_REQUEST, 'delete_product') != '') {
$this->delete_product();
} elseif (vmGet($_REQUEST, 'add_product') != '') {
$this->add_product();
} elseif (vmGet($_REQUEST, 'update_quantity') != '') {
$this->update_quantity();
} elseif (vmGet($_REQUEST, 'update_coupon_discount') != '') {
$this->update_coupon_discount();
} elseif (vmGet($_REQUEST, 'update_discount') != '') {
$this->update_discount();
} elseif (vmGet($_REQUEST, 'update_standard_shipping') != '') {
$this->update_standard_shipping();
} elseif (vmGet($_REQUEST, 'update_shipping') != '') {
$this->update_shipping();
} elseif (vmGet($_REQUEST, 'update_bill_to') != '') {
$this->update_bill_to();
} elseif (vmGet($_REQUEST, 'update_ship_to') != '') {
$this->update_ship_to();
} elseif (vmGet($_REQUEST, 'update_shipping_tax') != '') {
}
?>
<form method="post" name="editForm" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<table class="adminlist">
<tr>
<th><?php
echo $VM_LANG->_('VM_ORDER_EDIT_EDIT_ORDER');
?>
</th>
</tr>
</table>
<table class="adminlist">
<tr>
<th><?php
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_SKU');
?>
</th>
<th><?php
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_NAME');
?>
</th>
<th width="5%" align="left"><?php
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_QUANTITY');
?>
</th>
<th width="5%" align="left" colspan="2"><?php
echo $VM_LANG->_('VM_ORDER_EDIT_ACTIONS');
?>
</th>
</tr>
<?php
$dbt = new ps_DB();
$db = new ps_DB();
$qt = "SELECT order_item_id, product_quantity,order_item_name,order_item_sku FROM `#__{vm}_order_item`" . "WHERE #__{vm}_order_item.order_id='" . $this->order_id . "' ";
$q = "SELECT * FROM #__{vm}_orders WHERE order_id='" . $this->order_id . "'";
$dbt->query($qt);
$db->query($q);
$db->next_record();
$i = 0;
$rate_details = explode("|", $db->f("ship_method_id"));
while ($dbt->next_record()) {
if ($i++ % 2) {
$bgcolor = 'row0';
} else {
$bgcolor = 'row1';
}
?>
<tr class="<?php
echo $bgcolor;
?>
" valign="top">
<td><?php
$dbt->p("order_item_sku");
?>
</td>
<td><?php
$dbt->p("order_item_name");
?>
</td>
<td>
<form method="post" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<input type="text" value="<?php
$dbt->p("product_quantity");
?>
//.........这里部分代码省略.........
示例2: printf
$sectioncolor = "sectiontableentry2";
$i += 1;
}
else {
$sectioncolor = "sectiontableentry1";
$i -= 1;
}
if( !$db->f('category_flypage') ) {
$flypage = ps_product::get_flypage( $db->f('product_id'));
}
else {
$flypage = $db->f('category_flypage');
}
$tt_item++;
$pid = $db->f("product_parent_id") ? $db->f("product_parent_id") : $db->f("product_id");
?>
<tr class="<?php echo $sectioncolor ?>">
<td width="12%"><?php printf( $tt_item); ?>.</td>
<td width="85%">
<a class="bestseller" href="<?php $sess->purl(URL . "index.php?page=shop.product_details&flypage=$flypage&product_id=" . $pid . "&category_id=" . $db->f("category_id")) ?>">
<?php $db->p("product_name"); ?>
</a>
</td>
</tr>
<?php
} ?>
</table>
<!--Top 10 End-->
示例3: vmFormatDate
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_ACCOUNT_NUMBER');
?>
</th>
<th width="17%"><?php
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_EXPIRE_DATE');
?>
</th>
</tr>
<tr>
<td width="13%">
<?php
$ps_order_change_html->html_change_payment($dbpm->f("payment_method_id"));
?>
</td>
<td width="40%"><?php
$dbpm->p("order_payment_name");
?>
</td>
<td width="30%"><?php
echo ps_checkout::asterisk_pad($dbaccount->f("account_number"), 4, true);
if ($dbaccount->f('order_payment_code')) {
echo '<br/>(' . $VM_LANG->_('VM_ORDER_PAYMENT_CCV_CODE') . ': ' . $dbaccount->f('order_payment_code') . ') ';
}
?>
</td>
<td width="17%"><?php
echo $dbpm->f("order_payment_expire") ? vmFormatDate($dbpm->f("order_payment_expire"), '%b-%Y') : '';
?>
</td>
</tr>
<tr class="sectiontableheader"> 示例4:
function html_change_coupon_discount()
{
global $VM_LANG;
$db = new ps_DB();
$q = "SELECT * FROM #__{vm}_orders WHERE order_id='" . $this->order_id . "'";
$db->query($q);
$db->next_record();
?>
<form method="post" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<?php
echo $VM_LANG->_('PHPSHOP_COUPON_DISCOUNT');
?>
:
<input type="text" value="<?php
$db->p("coupon_discount");
?>
" size="5" name="coupon_discount" />
<input type="image" title="<?php
echo $VM_LANG->_('PHPSHOP_UPDATE');
?>
"
src="<?php
echo VM_THEMEURL;
?>
images/edit_f2.gif" border="0" alt="<?php
echo $VM_LANG->_('PHPSHOP_UPDATE');
?>
" />
<input type="hidden" value="1" name="change_coupon_discount" />
<input type="hidden" name="page" value="order.order_print" />
<input type="hidden" name="option" value="com_virtuemart" />
<input type="hidden" name="func" value="" />
<input type="hidden" name="order_id" value="<?php
echo $this->order_id;
?>
" />
</form>
<?php
}示例5:
}
?>
<tr class="<?php
echo $bgcolor;
?>
">
<td><?php
$db->p("order_date");
?>
</td>
<td><?php
$db->p("number_of_orders");
?>
</td>
<td><?php
$dbis->p("items_sold");
?>
</td>
<td><?php
$db->p("revenue");
?>
</td>
</tr>
<?php
$weekNum = 0;
//CT.need this for weekly viewing of products
// BEGIN product listing
if (!empty($show_products)) {
?>
<tr><td> </td><td colspan="2">
<table class="adminlist">示例6: intval
$q .= " `order_id`=" . intval($vars["order_id"]);
$q .= " AND `product_id`=" . intval($dbcart->f("product_id"));
$dbdl->query($q);
}
/* END HACK EUGENE */
$product_id = null;
// ***** Add product_publish to SELECT statement.
$dbi->query("SELECT product_id, product_publish FROM #__{vm}_product WHERE product_sku='" . $dbcart->f("order_item_sku") . "'");
$dbi->next_record();
$product_id = $dbi->f("product_id");
// ***** Set new flag to guard against the output of the product link by checking existance of product and its published status.
$link_to_product = !empty($product_id) && $dbi->f('product_publish') == 'Y';
?>
<tr align="left">
<td valign="top"><?php
$dbcart->p("product_quantity");
?>
</td>
<td valign="top"><?php
if ($dbdl->next_record()) {
// First output a link to the product or just the product name if the product has been removed.
if ($link_to_product) {
echo '<a href="' . $sess->url($mm_action_url . "index.php?page=shop.product_details&product_id={$product_id}") . '" title="' . $dbcart->f("order_item_name") . '">';
}
echo $dbcart->f("order_item_name");
if ($link_to_product) {
echo "</a>";
}
// ***** This is all new code to output multiple links and download expiration details.
// Now loop through each download and output links to each filename.
do {示例7: die
<?php
if (!defined('_VALID_MOS') && !defined('_JEXEC')) {
die('Direct Access to ' . basename(__FILE__) . ' is not allowed.');
}
/**
*
* @version $Id: shop.tos.php 1095 2007-12-19 20:19:16Z soeren_nb $
* @package VirtueMart
* @subpackage html
* @copyright Copyright (C) 2004-2007 soeren - All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* VirtueMart is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See /administrator/components/com_virtuemart/COPYRIGHT.php for copyright notices and details.
*
* http://virtuemart.net
*/
mm_showMyFileName(__FILE__);
$db = new ps_DB();
$ps_vendor_id = $_SESSION['ps_vendor_id'];
$q = "SELECT `vendor_id`, `vendor_terms_of_service` FROM `#__{vm}_vendor` ";
$q .= "WHERE `vendor_id`='" . $ps_vendor_id . "'";
$db->query($q);
$db->next_record();
$db->p("vendor_terms_of_service");示例8:
$dbpm = new ps_DB();
$q = "SELECT * FROM #__{vm}_payment_method, #__{vm}_order_payment, #__{vm}_orders ";
$q .= "WHERE #__{vm}_order_payment.order_id='{$order_id}' ";
$q .= "AND #__{vm}_payment_method.payment_method_id=#__{vm}_order_payment.payment_method_id ";
$q .= "AND #__{vm}_orders.user_id='" . $db->f("user_id") . "' ";
$q .= "AND #__{vm}_orders.order_id='{$order_id}' ";
$dbpm->query($q);
$dbpm->next_record();
?>
<tr>
<td width="20%"><?php
echo $VM_LANG->_('PHPSHOP_ORDER_PRINT_PAYMENT_LBL');
?>
:</td>
<td><?php
$dbpm->p("payment_method_name");
?>
</td>
</tr>
<?php
require_once CLASSPATH . 'ps_payment_method.php';
$ps_payment_method = new ps_payment_method();
$payment = $dbpm->f("payment_method_id");
if ($ps_payment_method->is_creditcard($payment)) {
// DECODE Account Number
$dbaccount = new ps_DB();
$q = 'SELECT ' . VM_DECRYPT_FUNCTION . '(order_payment_number,\'' . ENCODE_KEY . '\') as account_number
FROM #__{vm}_order_payment WHERE order_id=\'' . $order_id . '\'';
$dbaccount->query($q);
$dbaccount->next_record();
if ($dbpm->f("order_payment_name")) {示例9: while
<fieldset>
<legend><strong><?php
echo $VM_LANG->_('PHPSHOP_PRODUCT_FORM_ITEM_ATTRIBUTES_LBL');
?>
</strong></legend>
<?php
while ($db2->next_record()) {
?>
<div class="formLabel"><?php
$db2->sp("attribute_name");
?>
:</div>
<div class="formField" ><?php
$db2->p("attribute_value");
?>
</div>
<?php
}
?>
</fieldset>
</div>
<?php
}
?>
<div style="width:90%;float:left;">
<fieldset>示例10: vmSpoofValue
}
}
?>
<tr class="<?php
echo $bgcolor;
?>
" valign="top">
<?php
$ps_order_change_html->html_change_delete_item($dbt->f("order_item_id"));
?>
<?php
$ps_order_change_html->html_change_item_quantity($dbt->f("order_item_id"), $dbt->f("product_quantity"));
?>
<td width="30%" align="left">
<?php
$dbt->p("order_item_name");
echo "<br /><span style=\"font-size: smaller;\">" . ps_product::getDescriptionWithTax($dbt->f("product_attribute")) . "</span>";
if ($downloadable) {
echo '<br /><br />
<div style="font-weight:bold;">' . $VM_LANG->_('VM_DOWNLOAD_STATS') . '</div>';
if (empty($files)) {
echo '<em>- ' . $VM_LANG->_('VM_DOWNLOAD_NOTHING_LEFT') . ' -</em>';
$enable_download_function = $ps_function->get_function('insertDownloadsForProduct');
if ($perm->check($enable_download_function['perms'])) {
echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post">
<input type="hidden" name="page" value="' . $page . '" />
<input type="hidden" name="order_id" value="' . $order_id . '" />
<input type="hidden" name="product_id" value="' . $dbt->f('product_id') . '" />
<input type="hidden" name="user_id" value="' . $db->f('user_id') . '" />
<input type="hidden" name="func" value="insertDownloadsForProduct" />
<input type="hidden" name="vmtoken" value="' . vmSpoofValue($sess->getSessionId()) . '" />示例11: printf
$flypage = $db->f('category_flypage');
}
$tt_item++;
$pid = $db->f("product_parent_id") ? $db->f("product_parent_id") : $db->f("product_id");
?>
<tr class="<?php
echo $sectioncolor;
?>
">
<td width="15%"><?php
printf("%02d", $tt_item);
?>
</td>
<td width="85%">
<a href="<?php
$sess->purl(URL . "index.php?page=shop.product_details&flypage={$flypage}&product_id=" . $pid . "&category_id=" . $db->f("category_id"));
?>
">
<?php
$db->p("product_name");
?>
</a>
</td>
</tr>
<?php
}
?>
</table>
<!--Top 10 End-->