PHP - Trying To Get Sql Result Array Into Variables

Hello guys

I have here my array result
Array ( => Array ( => 1 [1] => [2] => 123456789 [3] => [4] => 2012-02-02 [5] => 09:12:21 [6] => Test Array ) )

I would like to view this result into a string so that it will remove the unnecessary array elements like brackets etc. Can some tell me how to handle this properly?

The result would be : 1 123456789 2012-02-02 09:12:21

thanks

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

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.

 

 

 

 

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.

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! 

is it possible to have variables in an array?

I have been trying to plot some data using phplot, a graph package but it plots different values to the ones I expect.

it should be able to cope with

array($variable1, $variable2)

shouldn't it?

This code outputs the table fields. how do I set them into an array and assign then to a variable to be inserted into a mysql database.

// Load html string
$dom->loadHTML($html2);

// Get tables from html
$tables = $dom->getElementsByTagName('table');


// Get rows from tables
$rows = $tables->item(0)->getElementsByTagName('tr');

// Loop over each row
foreach ($rows as $row)
{
   // Get each column by tag name
   $cols = $row->getElementsByTagName('td');
   
   
   // Echo values (here you can assign them in array for example)
   echo $cols->item(0)->nodeValue.'<br />';
   
   echo '<hr />';

Hi folks,   Amateur coder here in need of some help.   Background:  I have a dozen sensors that get recorded in a database.  The sensors are not very reliable,  so to smooth out the data to graph,  I compare the reading to the previous reading and if they differ by a given delta I replace the reading by the previous reading (smooth out spikes).  The data for each sensor is loaded into arrays that are names according to sensor numbers (ie sensor one - $sensor1,  sensor 6 - $sensor6).   I have go through and do the comparison on each array and just repeat the code a dozen times,  but I'd like to simplify the amount of code if possible.   I'm not sure how to refer to an array by using a variable. Here is a simplified example of what I would like to do. The issue comes with - $array($i)[$x]   Hope this makes sense of what I'm tring to do.  Any guidence would be greatly appreciated.  Trying to become a better programmer than just repeating the same piece of code a dozen times..

<?php

//define arrays of data
    $array1 = array (7,8,9,10,11,12);
    $array4 = array (13,14,15,16,17,18);
    $array6 = array (1,2,3,4,5,6);

//define array of sensors  
    $sensors = array(1, 4, 6);

//loop through each data point of each array
    foreach ($sensors as $i) {
        for ($x = 0; $x <= 6; $x++) {
        echo $array($i)[$x];
        } 
    }

?>

I have a form that is producing the following :

Array ( [formID] => 3154008308 [q1_applicationDate] => Array ( [month] => 11 [day] => 15 [year] => 2010 ) [q4_fullName4] => Array ( [first] => TOM [last] => STONE ) [q5_email] => TSTONE@YAHOO.COM [q6_address6] => Array ( [addr_line1] => 325 E LINCOLN [addr_line2] => [city] => GENESEE [state] => NY [postal] => 33256 [country] => United States ) [q38_selectProvider38] => Sprint [q39_selectPlan] => Individual [website] => [simple_spc] => 3154008308-3154008308 )

HOW do I automatically get each item above into it's own PHP variable?  The page that receives this Array is the second page of a 3 or 4 page form.  I need to send the above information on through the remainder of the form??

Would appreciate any help!  Thanks!

Hello everyone and thanks in advance for the help. I am working on a permission system for a site I am creating that will be used to restrict access to various areas of the site. I have a table with all the permission that is linked to a group that the user is a member of. I then use a query to get a list of the permission ids the user is part of and put those into the session array. I used a basic login script I found online I planned on modifying to add my own features and to make more secure.

Originally it had just a member id and member name variable in the session array saved in the login script which are both working fine after login. I am using a dynamic variable to set one session variable for each permission with the id being the changing part in the variable name. The problem I found is that the new variables are not being set. When i removed the redirect from my login script so I could check the problem I found that the temp variable, which is also set before it saves to the session array, is blank as well. If I hit refresh on my browser the new variables become set and all is well.

I was talking to nvee in irc chat who said I need to make a function on the page I am redirected to that checks if the variable exists. I looked through the original code of the login script I am using and found that this seems to be how they did it as well so I added an if statement to my index page to check if the variable has a value with and without using if isset. In both cases the new variable is still not getting set. He also gave me some pointers to help make my login checks more secure but the main thing IM concerned with right now is to make my new permission variables accessible to the session. My login script is available in my pastebin.