PHP - Find And Change Values In An Array

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

Say i have an array (called $myarray) and it has 10 numbers in it like this...

1
2
4
8
9
10
12
14
15
18

Now in my code, I get a number and lets say for this example it is "5".   

I need to see if that number is in the array --easy enough using in_array()--, but if it is NOT in the array, I need to find the next available number in the array that is greater than my starting number of 5  (which would be "8" in this example).

But what is the best way to find this number (i.e. 8 in this example)?

I imagine I need to somehow loop through but i'm not sure which loop is the best to use and i'm generally confusing the hell out of myself (which is frustrating because this is probably rather simple to do ).

Can anyone help guide me in the right direction? 

Hi all, i have this array

$str = array("apple is red", "banana is yellow", "pineaple is tropical fruit", "coconut is also tropical fruit", "grape is violet");

i want to find string "coconut" inside $str and put the whole string "coconut is also tropical fruit" into variable $coconut.

can i do this?

i don't want to use the this code

Code: [Select]
<?
$coconut = $str[3];
echo "$coconut";
?>

can someone help?

Thank you, Best Regards

I'm sure this is possible, but I'm not having any luck.

Code: [Select]
$array = array("11:23", "12:46", "13:34", "14:34", "14:85");
if (in_array('12', $array)) {
echo "yes";
} else { echo "no";
}}

I have mysql select query shown below retrieving data from a database:

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

On inspection of the retrieved array with var_dump(), i have these result below:

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

 How do I get at and print out the highest score from this set of array values within this context.
 I tried this echo max($row['count']) but i understandably got this feedback:
Warning: max(): When only one parameter is given, it must be an array   Thanks.

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

I need help this problem seem too tricky for me right now.

I got an array with decimal numbers and behind it says Yes/No. The min() function works magically and still is able to correctly give me the lowest value.
But how do i make a while loop that loops until it pops a value that is lowest and has Yes behind it?

For example:

Array => ('11,64|No', '209,81|Yes', '533,42|Yes', '27,90|No', '93,01|Yes')

So this function should return '93,01|Yes'

I have a list of products in database and some have the same itemid but a different price depending on size

What i want to do i if the itemid has more than one size, take the smallest price and then add the word "From" at the beginning.

I've tried using the MIN() function but can't get it to do what i want.

If there is only one size it works fine but if there is more than one it just says "From 0.00"

Code: [Select]
while ($row = $result->fetch()) {
if(!isset($items[$row['itemid']]))
{
$items[$row['itemid']] = $row;
}
$items[$row['itemid']]['sizes'][$row['size']] = $row['price'];  ### CHANGED ###
}
foreach($items AS $subitem) {
list($prodid, $itemid, $item, $size, $description, $shortdesc, $image, $price) = $subitem;

//Create field for item name based upon record count
if(count($subitem['sizes']) > 1)
{
/*$item_name_field = "<ul>\n";
foreach($subitem['sizes'] as $size => $price) ### CHANGED ###
{*/

//}
//$item_name_field .= "<ul>\n";
$myprice = explode(".",number_format(min($subitem['price']),2));
$item_name_field .= "<li>From ".$myprice[0].".".$myprice[1]." {$size}</li>\n";
}
else
{
$myprice = explode(".",number_format($subitem['price'],2));
$item_name_field .= "<li><span class=\"ucprice\">&#163;".$myprice[0]."<?span><span class=\"lcprice\">.".$myprice[1]."</span></li>\n";
}

I need to find the earliest and latest times, but there must be at least 3 to count it.

$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 15:00"
$array[] = "09:00 - 17:00"
$array[] = "09:00 - 15:30"
$array[] = "07:30 - 15:00"
$array[] = "07:00 - 12:00"

So the above would return 09:00 - 15:00

I thin would need to ensure that a maximum 4 hours inbetween, so I then get something like 10:00 - 14:00 returned

I have the following  array structu
Code: [Select]

[0] => Array
        (
            [id] => Array
                (
                    [$t] => http://www.google.com/mate/
                )

            [updated] => Array
                (
                    [$t] => 2011-08-31T11:43:05.942Z
                )

            [category] => Array
                (
                    [0] => Array
                        (
                            [scheme] => http://schemas.google.com/g/
                            [term] => http://schemas.google.com/contact/
                        )

                )

            [title] => Array
                (
                    [type] => text
                    [$t] => Name
                )

            [link] => Array
                (
                    [0] => Array
                        (
                            [rel] => http://schemas.google.com/contacts/2008/rel#edit-photo
                            [type] => image/*
                            [href] => https://www.google.com/mate/feeds/photos/media/
                        )

                    [1] => Array
                        (
                            [rel] => self
                            [type] => application/atom+xml
                            [href] => https://www.google.com/mate/feeds/contacts
                        )

                    [2] => Array
                        (
                            [rel] => edit
                            [type] => application/atom+xml
                            [href] => https://www.google.com/mate/feeds/
                        )

                )

            [gd$email] => Array
                (
                    [0] => Array
                        (
                            [rel] => http://schemas.google.com/g/2005#other
                            [address] => email_address@gmail.com
                            [primary] => true
                        )

                )

        )



I am tried to display name and email address.
I am using following method, can anyone tell me is there any better way? Thank u 4u help.
NAME
$name=( $emp_det[0]['title'][t]);
EMAIL
$email =( $emp_det[0]['gdemail'][0][address]);

I have an array created to control the down states of the my buttons in my navigation. Which is working well. This array will have quite a few strings in it before I'm done.

I then want to conditionally load a CSS file for all the files in that array with the exception of two, is this possible?

In plain in english I want to say If in array apart from these values then load my css file.

My array (will have more values when complete)

Code: [Select]
$otherTitles = array('Product Selector', 'Avon Range', 'Knightsbridge Range', 'Kingston Range' );

My code to load a css file

Code: [Select]
<?php if (in_array($title, $otherTitles)) { ?>
<link rel="stylesheet" type="text/css" href="homepage.css"/>
<?php } ?>

I want all titles in the otherTitles array to get this CSS file apart from two Product Selector and Avon Range.

Thanks

Richard

I need to some how pull comma separated images $data[23] from this $data array and then put them into there own array so I can insert them into separate rows in a database.


    
This is the provided array:

$data[0] => VIN
$data[1] => StockNumber
    
...(all the other number here)
    
$data[23] => Image_URLs (comma seperated)
$data[24] => Equipment


// I need something like this (obviously doesn't work?!@#)

$delimiter = ",";
$img = explode($delimiter, $data[23]);

foreach($img as $pic){
$sqlPic = "insert into class_prodimages (pid image rank) values('".$LastId['id']."', '$pic', '".rand(1,20)."')"; 

}



Any help here?

okay I am using a jquery plugin to re-arrange images which are in mysql and they have their own "order_number" ... when i re-arrange stuff the new order is put into a hidden field in a form and i have it along with another hidden field with their current order... when submitted I combine these two fields in an array so the key is the original order and the value is the new order ....i have 12 images...
Array ( [1] => 1 [2] => 2 [3] => 3 [4] => 4 [5] => 5 [6] => 6 [7] => 7 [8] => 8 [9] => 9 [10] => 10 [11] => 11 [12] => 12 ) 

this is what is what the array looks like... i have a foreach loop with a mysql query but things get kind of weird when you try to do it this way

$num = $_POST['old_num'];
$num = unserialize($num);
$sort = $_POST['sortOrder'];
$sort = explode(',', $sort);

if ($_POST){


$combine = array_combine($num, $sort);

foreach($combine as $key => $value){


mysql_query("UPDATE shirts SET order_number='$value' WHERE order_number='$key' ")
or die(mysql_error());


}


when you do this lets say for example we have the image with order number "1" get switched with the image order number "2"..... the database first updates with number 1 which becomes 2... then when it goes to number "2"... at this point... the first image gets switched back to number 1.... so  1 becomes 2 then the new 2 becomes 1 again and the other 2 becomes 1 also.

I can not think of another way I could update mysql with the correct order numbers... If anyone has any ideas or other solutions I am open to all suggestions... thank you!

Hi,

I have this form currently setup and is showing the value from the table.

<form action="updaterates.php" method="post">
<table width="350">
<tr>
<td width="100">7 Nights</td>
<td width="100"><input type="text" name="rates1" value="<?php echo ($row['rates1']); ?>" maxlength="3" size="3"></td>
</tr>
</table>
</form>

What do I need to do in order for it to update the value in the table... Thanks in advance...