PHP - How Extract Arrays From Array Depend On Values

Hello everyone,

I have been trying several things,recently, and I can't figure out how to get a series of numbers, grouped together as a string of number, instead of it adding or grabbing the last number that was randomly generated.

I'm wanting to save it in a variable (of course), so I can pass it though a query when it is needed.


foreach($array as $number){
echo $number;
}


$array is the variable where it is an array but all the randomly generated numbers are stored there.

All / any help would be gratefully appreciated.

Hi - I have an array which is created from a session variable I must have constructed my array wrong, as for the life of me I can not extract the individual values.  I have tried innumerable $key=>$value combinations. I must be doing something stupid, maybe it is obvious, but not to me.   I'll be darn grateful if you can help me !  Many  Thanks


MY array looks like this:

Code: [Select]
Array
(
    [quantity] => Array
        (
            [0] => 1
            [1] => 1
            [2] => 1
            [3] => 1
            [4] => 1
        )

    [name] => Array
        (
            [0] =>  Ribs Large pack 20 pieces
            [1] => 25 Piece Bag
            [2] => Sirloin Steak
            [3] => 50 piece bag of Scalops
            [4] => Sirloin Steak
        )

    [prodid] => Array
        (
            [0] => 17
            [1] => 28
            [2] => 27
            [3] => 25
            [4] => 27
        )

)




The CodeIgniter form which generated this array looks like this:

Code: [Select]

 <?php foreach ( $_SESSION['openorders'] as $key=>$value) {  ?>
<tr align="center">
<td width="30"><?php $data=array('name' =>'quantity[]','value'=>$value['quantity']); echo form_input($data); ?></td>
<td><?php echo $value['prodid']; ?></td>
    <td><?php echo $value['name'];?></td>
    <td><?php echo $value['ordervalue']; ?></td>
<td><?php echo $value['pricelb']; ?></td>
<td align="right"><?php echo form_checkbox('delete','delete',FALSE);
echo form_hidden('prodid[]', $value['prodid']);
echo form_hidden('name[]', $value['name']);
echo form_hidden('orderid', $value['orderid']);
   $totalordervalue += $value['ordervalue'];
} ?>

I'm a newbie . I've been stuck on this error message for 2 days:
I get this error message: extract() expects parameter 1 to be array, boolean given in C:\x\xampp\htdocs\user_personal.php on line 30

Code: [Select]
<?php
$query = 'SELECT
        about_me, job, hobbies, contact
    FROM
        site_user u JOIN
        site_user_profile p ON u.user_id = p.user_id
    WHERE
        username = "' . mysql_real_escape_string($_SESSION['username'], $db) . '"';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_array($result);
extract($row);
mysql_free_result($result);
mysql_close($db);
?>
I think joining table is hard, I just want to create a profile that would be linked to a user name. Please be my friend and help me so I can have PHP phun time.

I've been trying to get this to work for a few days now and can't seem to get anywhere with it! Any help is very much appreciated.

I am creating a number generator where the user is required to insert the maximum number and generate rate. Maximum number is the highest number that the script will go to, and generate rate is how many numbers should be created.

When the script runs, the numbers are stored into a MySQL database. The MySQL database creates a unique ID number so it can be recalled at a later date.

The user then needs to go to Sorting.php and selects the record they wish to use. The numbers from this record are then counted and then stored into an array.

If the numbers 2,5,5,0,2,2,1,3,5,1 where generated, the output of this new array will be: [5] => 3 [3] => 1 [2] => 3 [1] => 2 => 1  (These arrays can be of any length)

I now need to extract this data and show it on screen. I don't know how to approach it.

Format example:

Number 5 appears 3 times
Number 3 appears 1 times
Number 2 appears 3 times
Number 0 appears 1 times

Sorting.php
<?php
        $db1 = new Number_Information();
        $db1->openDB();

        $sql = "select * from GeneratedNumber";
        $result = $db1->getResult($sql);

        if (!$_POST) { //page loads for the first time
            ?>

            <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">

                Select the ID (If you have just generated a number, it will be the last one):

                <!--This is the drop down menu-->
                <select name="ID"> 
                    <?php
                    while ($row = mysql_fetch_assoc($result)) {
                        echo "<option value='{$row['ID']}'> {$row['ID']} </option>";
                    }
                    ?>
                </select> <br />

                <input type="submit" value="Continue" />
            </form>

            <?php
        } else {
            $ID = $_POST['ID']; //This will contain the value that was selected in the drop down menu above.

            $result = mysql_query("SELECT NUMBERS2 FROM GeneratedNumber WHERE ID='{$ID}'"); //This tells the script to select NUMBERS2 contents which is assosiated with the ID.

            while ($row = mysql_fetch_array($result))
                $NUMBERS2 = $row['NUMBERS2'];

            echo "$NUMBERS2"; //Testing reasons - remove it later.
            echo "<br />"; //same as above
            echo "$ID"; // as above.
            echo "<br />"; //as above
            //Convert NUMBERS2 back into an array when inserted into table from Generator.php
            $NUMBERS = explode(",", $NUMBERS2);


            // Counts how many times a number appears
            //*******************************************************************************************************************
            //IF ALL ELSE FAILS, REVERT BACK TO THIS.
            //print_r(array_count_values($NUMBERS));
            //It will only print the statement, but gives you a good building block when things WILL go wrong.
            //*******************************************************************************************************************

            rsort($NUMBERS);
            print_r(array_count_values($NUMBERS));
            

(The questions when editing posts are hard. I've needed to Google both of them:()

I have a function that is supposed to find the email address of the user that's logged in my application. going by their ID:

function getUserEmail($userID){
    $sqll="SELECT id,email FROM users WHERE id='".$userID."'";
    $result1=mysql_query($sqll);
    $row11=mysql_fetch_assoc($result1);
    $processor=$row11["email"]; 
    return $processor;
}

What I'm trying to do is incorporate that into sending a simple email to the person that's logged in after they submit a file. But the email is not being sent and I'm getting this message: Warning: mail() expects parameter 1 to be string, array given   Here is what I have for sending the email :

$sendto = getUserInfo($_REQUEST[1][email]);
$subject = "File recieved";
$message = "Hello " . getUser($_REQUEST["user"]) . ". you successfully submitted: $title";
mail($sendto, $subject, $message);

How do I extract just the email address to prevent giving the array?  

This is really cool if I can get it to work

My PHP CODE:

Code: [Select]
$ids = implode (",", $ibforums->input['checkbox']);
Grabs from this data in my HTML FORM:

Code: [Select]
<input name="checkbox[]"  type="checkbox" value="{$r['id']},{$r['friendid']}">

Now when I pass my input, I will get 2 different values in both array's how do I separate them out? I know how to seperate them out using implode, but I need to seperate BOTH of the array's that are being passed, and I need to use them separately.

I am very grateful for any input. I have a field in a database that contains references (pattern: authorYYYY), such as the following string:   "authorA1989; authorB1978a; authorB1984; authorC1999; authorC2000a; authorC2000b; authorC2002; authorD2009"   What I want is an output as the following in order to create a proper bibliography (therefore accessing another table and picking out the respective reference details):    authorA    1989 authorB    1978a    1984 authorC    1999    2000a    2000b    2002 authorD    2009   I somewhat fail to group the values (years) per author. I know that keys are unique, but is there a way to work around this?   Many thanks for any help! 

Problem:
"Warning: extract() expects parameter 1 to be array, null given in C:\x\xampp\htdocs\pages\user_personal.php on line 32" - error also found on lines 33 and 38.
and none of the information is displayed.

Goal: I'm trying to retrieve profile information and multiple user inserted pictures and display the pictures through a while loop from one query.



<?php
$query = 'SELECT
        u.name_id, i.bio, i.exhib, p.product_code
        FROM
        user u LEFT JOIN profile i ON u.name_id = i.name_id
LEFT JOIN ecomm_products p ON u.name_id = p.product_code
        WHERE
        u.name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '" and p.name = "' . mysql_real_escape_string($_SESSION['name'], $db) . '"';
    $result = mysql_query($query, $db) or die(mysql_error());
extract($bio);  //line 32
extract($exhib); //line 33
$odd = true;
while ($row = mysql_fetch_array($result)) {
    echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
    $odd = !$odd; 
    extract($rows); line 38
    echo '<td><a href="' . $dir . '/' . $row['product_code'] . '.jpg">';
    echo '<img src="' . $thumbdir . '/' . $row['product_code'] . '.jpg">';
    echo '</a></td>';
    echo '</tr>';
}
echo "</table>";
echo "<p>";
?>

  <ul>
   <li>Biography: <?php echo $bio; ?></li>
   <li>Exhibitions: <?php echo $exhib; ?></li>
  </ul>

Hi guys,   I wonder if you can offer any advice?   I have two user database tables that are about 70% identical. The problem is that with one of them, the phone number for each user has been cut short by two digits (it was an error on my part early on in the database design).    What I need to do is to get the values from both tables and put them into separate arrays then compare the arrays in a loop. If, say, the first five digits of the phone number in each row of the first table match one entry in the second table then update the second table with the phone number (the full length one).   I'm about puzzled about how to approach this, I've still got a lot to learn about array functions, it seems like it should be fairly simple but I'm a bit lost as to where to begin.   Any advice would be massively appreciated!    

This has kept me busy for a couple of hours. I have two arrays that I would like to compare against each other to see matches and otherwise. Simple enough, right?


foreach ($array1 as $value){
if (in_array($value, $array2)) {
 echo $value."-FOUND<br />";
} else {
 echo $value."-NOT!<br />";
}
}


Using print_r I can CLEARLY see matches:

Code: [Select]
array1 = Array ( [0] => CHARLES [1] => TOM [2] => DICK [3] => HARRY)

array2 = Array ( [0] => HARRY [1] => DICK [2] => TOM [3] => CHARLES)



The only difference I can see is the keys - but why should that matter for what I'm trying to do?

Both arrays were converted to uppercase. I have done variations of search_array, array_intersect and array_unique - but absolutely nothing is working. 3 hours later and I'm no further then I started off. WTF?

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
        )

)

I am trying to locate an array in an array of arrays:

    $card_pos = array_search($target, $_SESSION['leitner']['boxes'][($box - 1)]);
    if ($card_pos !== false) {
  // Do my stuff here
}echo '<pre> oh no -- didn\'t find '; print_r($target); echo "in ";print_r ($_SESSION['leitner']['boxes'][($box + 1)]);echo '<br>leitner';print_r ($_SESSION['leitner']); echo '</pre>';

but I don't find the target in the array though it is clearly there as you can see in the output:

oh no -- didn't find Array
(
    [pos] => v5g
    [tense] => agerimasu
)
in Array
(
    [0] => Array
        (
            [pos] => v5g
            [tense] => agerimasu
        )

)

leitnerArray
(
    [boxes] => Array
        (
            [1] => Array
                (
                )

            [2] => Array
                (
                )

            [3] => Array
                (
                    [0] => Array
                        (
                            [pos] => v5g
                            [tense] => agaru
                        )

                    [1] => Array
                        (
                            [pos] => v5g
                            [tense] => agarimasu
                        )

                    [2] => Array
                        (
                            [pos] => v5g
                            [tense] => agarimasen
                        )

                    [3] => Array
                        (
                            [pos] => v5g
                            [tense] => agaranai
                        )

                    [4] => Array
                        (
                            [pos] => v5g
                            [tense] => ageru
                        )

                    [5] => Array
                        (
                            [pos] => v5g
                            [tense] => ageranai
                        )

                    [6] => Array
                        (
                            [pos] => v5g
                            [tense] => agerimasen
                        )

                    [7] => Array
                        (
                            [pos] => v5g
                            [tense] => agerimasend
                        )

                    [8] => Array
                        (
                            [pos] => v5g
                            [tense] => agereba
                        )

                    [9] => Array
                        (
                            [pos] => v5g
                            [tense] => agareba
                        )

                    [10] => Array
                        (
                            [pos] => v5g
                            [tense] => agatte
                        )

                    [11] => Array
                        (
                            [pos] => v5g
                            [tense] => agette
                        )

                )

            [4] => Array
                (
                    [0] => Array
                        (
                            [pos] => v5g
                            [tense] => agerimasu
                        )

                )

            [5] => Array
                (
                )

        )

    [denom_total] => Array
        (
            [1] => 0
            [2] => 0
            [3] => 36
            [4] => 40
            [5] => 40
        )

    [denom_max] => 40
)

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.