PHP - How To Get The Result Into Array

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=353485.0

Hi,

I have attached sql script for table structure and sample data.

When I run following sql query ,I get result set.

Code: [Select]
select * from tablename order by col10 desc
I want to create array using result set.

Following is the require structure of array.

Code: [Select]
<?php

$resultSet[]=array
    (
        ('0') =>array (
              ('col10value1') => array
                    (
                        ('0') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                        ('1') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                    ),
            ),
 

        ('1') => array (
          ('col10value2') => array
                (
                    ('0') => array
                        (
                            ('col1') => 'col1',
                            ('col2') => 'col2',
                            ('col3') => 'col3',
                            ('col4') => 'col4',
                            ('col5') => 'col5',
                            ('col6') => 'col6',
                            ('col7') => 'col7',
                            ('col8') => 'col8',
                        ),
                ),
        ),
    );   
?>

Hi All,

I have a select statement

	$stmt = $conn -> prepare('
	                         SELECT u.user_firstname, u.user_lastname, so.staff_id, r.role_name
	                         FROM ssm_staff_order so
	                         INNER JOIN ssm_user u on so.staff_id = u.user_id
	                         INNER JOIN ssm_role r on u.user_role_id = r.role_id
	                         WHERE job_id = ?
	                         ');
	$stmt -> bind_param('i', $jid);
	$stmt -> execute();
	$stmt -> bind_result($fn, $ln, $id, $role);

The result looks like this

+----------------+---------------+----------+-----------+
| user_firstname | user_lastname | staff_id | role_name |
+----------------+---------------+----------+-----------+
| FName          | LName         |        8 | Chef      |
| jon            | smith         |       15 | Manager   |
| Chelsea        | Hockley       |        2 | Manager   |
+----------------+---------------+----------+-----------+

I am wanting to build an array so that i can foreach the result with the people under the header of their role.

I know this is not difficult but i am going around and around with it and clearly missing the key part.

As always your help is appreciated.

Quote from: Hollows on August 20, 2010, 11:29:25 AM

I have an array that is pulling 10 results from a db like this -


<?php
$result = mysql_query("SELECT * FROM inbox ORDER BY id DESC LIMIT 0,10");
while ($row = mysql_fetch_array($result)) {

<div class="<?php echo $row['class'];  ?>">
<?php
echo $row['name'];
echo $row['message'];
?>
</div>


basically 'class' is defined in an earlyier part of the script and is used to tell the css what class to display - as I'm sure you can see.

What I'd like todo then be able to update the class of a message once I have read it, so update the class table with something like 'read' so the css will then be based on .read not what ever was set by the form, either using a link or form button inside each of the 10 results from the array.

I've managed to update one by using -
Code: [Select]
mysql_query("UPDATE shoutbox SET class = 'read' WHERE id = ''XX"); // XX should be row id

But I had to set that myself and point the id to the row id I wanted to change - How can I have that already populated with the row for the id that triggered it?


To be clear so it looks like -

Name
Message
read button
_____________
Name
Message
read button
_____________
Name
Message
read button
_____________

and so on...


Would I be better going by check boxes and one submit button? If so how could I implement that?


I can provide the full code I've written if it helps

Thank you in advance

I am having a bit of trouble with the following (just for theoretical purposes of course!).

Just wondered how you do the following code:

$products = array(); // makes a empty array called $products

$i = 1;
$icol = 1;
while($row = mysql_fetch_array($result)) {
$products[$i]['product1'] = $row[$icol][0];
$i = $i++;
}

All its meant to do is:

Quote

SELECT * FROM products


Which the table contains just 3 columns:
productid | product   | price
1 |  product1  |  25.55

That is it, very simple, but wanted to make a multi dimension array that will be 3 columns wide, then however many rows (hence the while loop and array fetch etc).

Any help is appreciated, just coming from a VBA background when it comes to the arrays in VB lol.

Thanks for any help in advance,
Jeremy.

Hello,   I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator.   How can I separate the numbers in this array with the given code?  Ive attached a photo of the code.

 

 

 

 

Hi, I have come up with the following code, I need it to get the details of several scattered products and echo the results, the trick is I don't want it to echo the results one after the other... I want to have the products scattered between unique text on the page but don't want to run the query several times for performance reasons.

E.g.- PAGE to look like this:

$Product_1

unique text/images

$Product_2
$Product_3

unique text/images

$Product_4


Current Code:

Code: [Select]
<?
$result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");
while($row = mysql_fetch_array($result))
  {
    $x = "1";
      while ($x<=3)
{
          echo $x;
          $Product = "Product_";
          $Product = $Product.$x;
          echo $Product;
          $Product = $row['Product_ID'];
          echo $Product;
          $x++;
          echo $x;
        }
  }

At the moment it returns the following results:

Quote

1
Product_1
465
2

2
Product_2
465
3

3
Product_3
465
4

1
Product_1
475
2

2
Product_2
475
3

3
Product_3
475
4


A few problems...

In Blue... it duplicates for product 465
In Red... It repeats again for 475
Also.... it starts with 465, but I want it to go in order as how it appears - $result = mysql_query("SELECT * FROM products where Product_ID IN (475, 465, 234, 567, 845)");  so should start with 475


I want to get the following result:

Quote

1
Product_1
475
2

2
Product_2
465
3

3
Product_3
234
4

4
Product_4
567
4

(and so on.....)



If anyone could provide me assistance with my troubled 'while loop' statement that would be much appreciated! 

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?

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


?>

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?

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 />";
 }
}
?>

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.