PHP - How To Get Specific Rows From Result Object

I'm trying to write a php page that displays data from a JOIN query for a specific ID

table view

brandinfo

ID, brand, discounttype

1, antioni, no discount

brandproducts

brandID, producttype, price

1, Tshirt, 20.00
1, Pants, 30.00
1, Shoe, 40.00


the returned result is

1 antioni, no discount, Tshirt, 20.00,
2 antioni, no discount, Pants, 30.00
3 antioni, no discount, Shoe 40.00

The way I want the page to be displayed is

------------------


Antioni (at the top)

Table

1. Tshirt 20.00
2. Pants 30.00
3. Shoe 40.00


no discount (at the bottom)
----------------------------

How should I construct the PHP page from the result since they're retrieved as rows?

Hi all !   I have a piece of code he

$result = display_all(fcon, $var1, $var2);

function display_all( // defined in another file
$query = "SELECT one, two, three four, index1, index2 FROM numbers WHERE index1 = $var1 LIMIT 0, 1"; $result = mysqli_query($fcon, $query); return ($result); )

and then I use the returned variable $result to display the value as follows:-

		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
		{
			echo "<tr>";
			echo "<td>".$one."</td>";
			echo "<td>".$two."</td>";
			echo "<td>".$three. "</td>";
			echo "<td>".$four. "</td>";
			echo "<td>".$index1. "</td>"; 
                        echo "</tr>";
               }    

and this displays the n rows of data returned.       Now I have started using prepared statements and the function is now 

function display_all{

      $query = "SELECT one, two, three four, index1 FROM numbers WHERE index1 = ?
                LIMIT 0, 10";
      $stmt = $conn->prepare($query);
      $stmt->bind_param('i',$var)
      if($stmt->execute())
      {
          $stmt->bind_result($one, $two, $three, $four, $index1);
          $stmt->store_result();
      }
return($stmt);
}

However the returned $stmt object is unable to display the n rows of data since it shows null values. I assume that this is not the right way to use the $stmt object to display data. I must be missing something. So I request you guys to help me with this.   Thanks loads.
Edited by ajoo, 23 December 2014 - 11:24 AM.

I use the Wholesale Suite Premium Prices plugin with WooCommerce. I have 6 specific wholesale roles out of 15 that I wish to hide two specific shipping methods from being selected for the 6 exceptions. I'm just trying this on my staging server at this time using a code snippet example that I found and modified for my specific conditions. Would the following work for this purpose?

/* Hide specific shipping methods for specific wholesale roles */
add_filter( 'woocommerce_package_rates', function( $shipping_rates ) {
// User role and shipping method ID to hide for the user role
    $role_shipping_method_arr = array(
    'ws_silvia_silver' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    );

    // Getting the current user role
    $curr_user = wp_get_current_user(); 
    $curr_user_data = get_userdata($current_user->ID); 

    // Wholesale Suite Roles 
    if (isset($current_user) && class_exists('WWP_Wholesale_Roles')) {
        $wwp_wholesale_roles = WWP_Wholesale_Roles::getInstance();
        $wwp_wholesale_role = $wwp_wholesale_roles->getUserWholesaleRole(); 

// Loop through the user role and shipping method pair
    foreach( $role_shipping_method_arr as $role => $shipping_methods_to_hide ) {

// Check if defined role exist in current user role or not
    if( in_array( $role, $current_user->roles) ) {

// Loop through all the shipping rates
    foreach( $shipping_rates as $shipping_method_key => $shipping_method ) {
$shipping_id = $shipping_method->get_id();

// Unset the shipping method if found
    if( in_array( $shipping_id, $shipping_methods_to_hide) ) {
unset($shipping_rates[$shipping_method_key]);
}
}
}
}
}
    return $shipping_rates;
});

Any insights as to how to accomplish this would be greatly appreciated. Lyse

I am really lost here with this date issue of mine. The below code is the last part of a query:
Code: [Select]
$defendercheck_3 = $row_checkifattacked3['atdate'];
$defendercheck1_3 = strtotime("$defendercheck_3");
$defendercheck2_3 = date("D", $defendercheck1_3);
The query does not return any results as expected, but when echoing the various steps I get following:

echo "$defendercheck3"; = nothing (as expected)

echo "$defendercheck1_3"; = nothing (as expected)

echo "$defendercheck2_3"; =  result! (NOT expected)

why does it return anything on "date("D", $defendercheck1_3)" when "$defendercheck1_3" is blank?

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

I have 2 queries that I want to join together to make one row  

Hey all,

I want to have an object that has a property which is an object containing instances of other objects. I try this:
Code: [Select]
class Blog extends Posts {
public $has_posts;

public function __construct($a,$b,$c){
$has_posts = (object) array_merge((array) $a, (array) $b, (array) $c);
}
}

class Posts {
public $b;

public function __construct($b){
$this->b = $b;
}
}

$post1 = new Posts(1);
$post2 = new Posts(2);
$post3 = new Posts(3);

$blog = new Blog($post1,$post2,$post3);
var_dump($blog->has_posts); //null
foreach($blog->has_posts as $post){ //Invalid argument supplied for foreach()
echo $post->b;
}

But as you see, has_posts is null, not an object containing other objects.

Thanks for response.

I have a Soup object in a Bowl object in a Microwave object.

The Microwave object has the methods:

receiveItem(Bowl $b)
cookItem(???)

I want the Microwave to be able to set the Soup->temperature but I'm not how to do that?

Make sense?



TomTees

I made a small script and it says that my database object isn't an object.

I connect to my pdo database via:

<?php

try {
$db = new PDO("mysql:host=localhost;dbname=database", "root", "root"); 
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
}  
catch(PDOException $e) {  

echo $e->getMessage();
  
}

?>

 

The error I get is

Code: [Select]
Notice: Undefined variable: db in /Users/JPFoster/Sites/jobiji_sandbox/extensions/tasks.php on line 21

Fatal error: Call to a member function query() on a non-object in /Users/JPFoster/Sites/jobiji_sandbox/extensions/tasks.php on line 21


here's where the error is
$grabber = $db->query('SELECT * WHERE user_id =' . $userid);
$grabber->setFetchMode(PDO::FETCH_OBJ);

while ( $row = $grabber->fetch() ){

$display = '<div>Task Name: ' . $row->name .'</div>';
$display .= '<div>Task Details: <p>'. $row->details  .'</p></div>';
//$display .= '<div>'. $this->checkifDone($row->task_status) .'</div>';
$display .= '<div>Task Due: '. $row->task_due . '</div>';
echo $display;
}


could anyone tell me where this issue is originating I followed a fairly simple tutorial that didn't seem to work.


Thanks!

Ok i call a function like so ...
<?php PunchTime($monday,"in","1",$etime_who); ?>

Below is the function, if you look closely i echo the query after it's been ran, and that query works 100% since i copied & pasted the query into the database and it returns a result that's needed. But for some bloody reason it doesn't work via code.

function PunchTime($pdate,$type,$num,$ewho)
{
if($type == "in")
{
if($num == "1")
{
$etime_col = "PUNCH_IN";
}
elseif($num == "2")
{
$etime_col = "PUNCH_IN2";
}
}
elseif($type == "out")
{
if($num == "1")
{
$etime_col = "PUNCH_OUT";
}
elseif($num == "2")
{
$etime_col = "PUNCH_OUT2";
}
}

include_once('oracleCON.php');

$etime_qry = "SELECT $etime_col FROM tablename WHERE who= '$ewho' AND punch_date = '$pdate'";
echo $etime_qry;
$etime_go = oci_parse($conn, $etime_qry);
oci_execute($etime_go);
$etime_res = oci_fetch_assoc($etime_go);

$time = $etime_res[$etime_col];
if($time == "") $time = "--";

echo $time;
}


All i get are "--" even though some should return a time stamp.

i have a game script and it's always bringing back the same result and i cant see why..

all i get when the script it ran is

[/code]echo '<div class=noticeBox><h2>Sorry! No available member found![/code]

the code is below and can provide the functions and db if needed, but cant see what's wrong.

Code: [Select]
<?php

include '../header.php'; 

echo '<div id=AjaxSubDiv>';
echo '<div id="actionDiv">';

include '../statusbar.php';

echo '<div id=contentBox>';

// Show Fight Result
if( !empty($_GET[action]) AND $_GET[action]=='attack' ) {
echo $str;


// Fight Lists
echo '<P class=pageheader>Fight</P>';
echo '<P>Its time for action! Fight with rival thieves and grab their cash. You will require 1 strength for each fight and you will gain some cash and exp if you win the fight. However you will just earn some exp if you loose!! Each fight will decrease your health so keep an eye on health level because if your health goes below zero you will die and loose everything...</P>';

$res = query("SELECT COUNT(*) FROM `usertable` WHERE `userid`!=$user");
list($total) = mysql_fetch_array($res);
if( $total>0 ) {

$res = query("SELECT * FROM `usertable` WHERE `userid`!=$user LIMIT 0,20");




$viewplayer = Player::getById($row[userid]);

echo '<tr>';
echo '<td width=120px>';
echo '<P class=titleP><a href="#" onclick="load_menu_val(\'AjaxSubDiv\', \'profile\', '.$row[userid].');return false;"><fb:profile-pic uid="'.$row[userid].'" size="square" linked="false" width="75px" class="userImg" /></a></P>';
echo '<P class=titleP><a href="#" onclick="load_menu_val(\'AjaxSubDiv\', \'profile\', '.$row[userid].');return false;"><fb:name uid="'.$row[userid].'" linked="false" /></a></P>';
echo '</td>';

echo '<td width=120px>';
echo '<P><B>Level:</B> '.$viewplayer->level.', '.get_level_title($player->level).'</P>';
echo '</td>';

echo '<td width=120px>';
echo '<P><B>Crew:</B> '.$viewplayer->crew.'</P>';
echo '</td>';

echo '<td width=300px>';
if( $viewplayer->health > 20 ) {
echo '<form id="FightForm'.$row[userid].'" method="POST" class="itemForm">';
echo '<input type=hidden name=user value="'.$user.'">';
echo '<input type=hidden name=opid value="'.$row[userid].'">';
echo '<input type=hidden name=action value="dofight">';
echo '<P><input type=button onclick="do_submit(\'FightForm'.$row[userid].'\',\'http://www.bofs.us/thief/thiefmaster/fight/post_fight.php\', \'actionDiv\'); return false;" value="Fight Now" class="submitButton" /></P>';
echo '</form>';
}
else {
echo '<P class=titleP>Too Weak To Fight</P>';
}
echo '</td>';
echo '</tr>';
}
echo '</table>';
echo '</center>';
}
else {
echo '<div class=noticeBox><h2>Sorry! No available member found!</h2></div>';
print"$res";

}

echo '</div>'; // end of contentBox

echo '</div>'; // end of actiondiv
echo '</div>'; // end of AjaxSubDiv


?>

Basically I want this to do do is:

if (there is no result found in the query){
 echo "nothing for this brand";
}else{
echo this link;
}

this is my code...im just confused on what i want the if statement to to ask for.

any help would be greatly appreciated

Code: [Select]
<?php
$mypro = mysql_query("SELECT * FROM Sheet1 WHERE pro_catagory LIKE '%People%' ORDER BY pro_id DESC");
while($row=mysql_fetch_array($mypro)) {
if(Not sure what to put here){
echo "There are no listings for the brand right now";
}else{
 print "-&nbsp;<a href='proList.php?proNumber=".$row['pro_id']."'>".$row['pro_name']."</a><br />";
 }
}
?>

at the moment i have my page:

addevent.php

i have written:
Code: [Select]
   $q = "SELECT username "
       ."FROM ".TBL_USERS." ORDER BY ASC";
   $result = $database->query($q);

on the database.php page here is what query looks like:
Quote

   /**
    * query - Performs the given query on the database and
    * returns the result, which may be false, true or a
    * resource identifier.
    */
   function query($query){
      return mysql_query($query, $this->connection);
   }



then i want to display $result in a drop down menu so i wrote back on addevent.php:

Code: [Select]
<select name="Select1">
<option value="<? echo("$result"); ?>"><? echo("$result"); ?></option>
</select>

I'm writing an admin panel for my site (to manage users, etc)


I selected the user-rights from the DB, but how can I check it the user-rights is equal to 3, and if it is allow access?