public get_var ( string | null $query = null, integer $x, integer $y ) : string | null | ||
$query | string | null | Optional. SQL query. Defaults to null, use the result from the previous query. |
$x | integer | Optional. Column of value to return. Indexed from 0. |
$y | integer | Optional. Row of value to return. Indexed from 0. |
리턴 | string | null | Database query result (as string), or null on failure |
public function get_var($query = null, $x = 0, $y = 0)
{
$this->func_call = "\$db->get_var(\"{$query}\", {$x}, {$y})";
if ($query) {
$this->query($query);
}
// Extract var out of cached results based x,y vals
if (!empty($this->last_result[$y])) {
$values = array_values(get_object_vars($this->last_result[$y]));
}
// If there is a value return it else return null
return isset($values[$x]) && $values[$x] !== '' ? $values[$x] : null;
}
function musicmate_get_store_products($product_cnt = 1) { //Connect to the OSCommerce database $storedatabase = new wpdb(get_option('oscimp_dbuser'), get_option('oscimp_dbpwd'), get_option('oscimp_dbname'), get_option('oscimp_dbhost')); $prodVal = ''; for ($i = 0; $i < $product_cnt; $i++) { //Get a random product $product_count = 0; while ($product_count == 0) { $product_id = rand(0, 30); $product_count = $storedatabase->get_var("SELECT COUNT(*) FROM products WHERE products_id={$product_id} AND products_status=1"); } //Get product image, name and URL $product_image = $storedatabase->get_var("SELECT products_image FROM products WHERE products_id={$product_id}"); $product_name = $storedatabase->get_var("SELECT products_name FROM products_description WHERE products_id={$product_id}"); $store_url = get_option('oscimp_store_url'); $image_folder = get_option('oscimp_prod_img_folder'); //Build the HTML code $prodVal .= '<div class="store_product">'; $prodVal .= '<a href="' . $store_url . 'product_info.php?products_id=' . $product_id . '"><img src="' . $image_folder . $product_image . '" /></a><br />'; $prodVal .= '<a href="' . $store_url . 'product_info.php?products_id=' . $product_id . '">' . $product_name . '</a>'; $prodVal .= '</div>'; } return $prodVal; }