PHP - Split Array By First Part Of Key Name Into Other Arrays

Hi all,

I have the following :

Code: [Select]
print_r($fqlResult);
Which gives the following result :

Code: [Select]
Array ( [0] => Array ( [src_big] => http://a5.sphotos.ak.fbcdn.net/hphotos-ak-ash4/299117_2121699756933_1079004376_2442101_3103384_n.jpg ) )
I want to grab just the image url from it and store it in a seperate variable.

Any ideas how I can do this plzzz ?

Thanks in advance,

Scott.

So, I am making a system that shows if there are new posts or not. How I have it done is a singular array called "Read" will have all of the IDs of the read posts.

It is entered in the database like so:
$ID2= $_SESSION['UserID'];
$ID2 = mysql_real_escape_string($ID2);
$Readornot=mysql_query("SELECT * FROM forum_read WHERE Reader_ID='$ID2'");
$Readornot2=mysql_fetch_array($Readornot);
if($ID2==0)
{
}
else
{
if(empty($Readornot2))
{
$Read1= array("Read" => $Get_TopicID);
$Read2 = implode('-',$Read1);
mysql_query("INSERT INTO forum_read (Reader_ID,`Read`) values ('$ID2','$Read2')") or die(mysql_error());
}
else
{
$cr_topicid=$Readornot2['Read'];
if(strpos($cr_topicid,'-'))
{
$cr_topicid=explode('-',$cr_topicid);
if(!in_array($Get_TopicID,$cr_topicid,true))
{
$Read0=implode('-',$cr_topicid);
$Read1= array("Read" => $Read0, $Get_TopicID);
$Read2= implode('-',$Read1);
mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error());
}
}
else
{
if($cr_topicid==$Get_TopicID)
{
}
else
{ 
$Read1= array("Read" => $cr_topicid, $Get_TopicID);
$Read2= implode('-',$Read1);
mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error());
}
}
}
}

It all works fine and dandy to the point where if it's in the database an icon will be black and white, and if its not it wont, signifying read or unread.

What I need to do, however, is make it so when there is a new post, it takes all of the entries in the database with the topic ID out of the database, and strips the one part.

What I thought of at first was to use str_replace to replace
"-" . $TopicID . "-"
with
"-"

But of course, that won't work, because the very first entry could be  the topic ID, so it would just be $TopicID- and not -$TopicID- in the database.

So, how would I go about doing this?

I wish to get only the last part of each array 'g'
And then show non duplicated 'g'
but in the same order that it was in the original array.


Code: [Select]
<?php
$formarray = array(
'name' => array(
      'i1'=>      array('a'=>'a1', 'b'=>'b1', 'c'=>'c1', 'd'=>'d1', 'e'=>'e1', 'f'=>'f1', 'g'=>'g1'),
      'i2'=>      array('a'=>'a2', 'b'=>'b2', 'c'=>'c2', 'd'=>'d2', 'e'=>'e2', 'f'=>'f2', 'g'=>'g2'),
      'i3'=>      array('a'=>'a3', 'b'=>'b3', 'c'=>'c3', 'd'=>'d3', 'e'=>'e3', 'f'=>'f3', 'g'=>'g3'),
      'i4'=>      array('a'=>'a4', 'b'=>'b4', 'c'=>'c4', 'd'=>'d4', 'e'=>'e4', 'f'=>'f4', 'g'=>'g4'),
      )
);

foreach ($formarray as $newarray => $a) {
?><strong><?=$newarray;?></strong><br><?
  foreach ($a as $key => $k) {
?>"<?=$key;?>", <?
foreach ($k as $b) {
//if ($k['DBfield'] != "") {
?>"<?=$b;?>", <?
//}
}
?><br><?
} //end of second foreach
?><br><br><br><?
} //end of first foreach
?>

Hello,

I have several job categories on a recruitment website:

$job_category[0]="accountant";
$job_category[1]="php programming";
$job_category[2]="baseball";

these job categories are contained within the urls imediately after the recruiting company's name and before the word "jobs", so we could have the following urls:

www.url.com/company_name_accountant_jobs
www.url.com/another_company_name_baseball_jobs
www.url.com/yet_another_company_name_php programming_jobs

Using the array $job_categories and the page path after the foward slash (e.g. yet_another_company_name_php programming_jobs) please could you tell me how to strip out the job category and the company name? (I'll extract the page path using a mod_rewrite)

Thanks

Stu

Hello,

I'm trying to store the match I get in $result to a variable so that I can easily compare its other values against other values. Here is my code..

//loop through new orders array
foreach ( $orders as $order ) {
	
	//compare job number and line item against database information for a match
	if ( array_search ( $order[ 'job_number' ], array_column ( $result, 'job_number' ) ) !== false && array_search ( $order[ 'line_item' ], array_column ( $result, 'line_item' ) ) !== false ) {
		
		$db_match = key($result);
		
		echo '<br><br>'.$db_match.'<br><br>';
		
		echo 'Job: ' . $order['job_number'] . '/Line Item: ' . $order['line_item'] . ' was found<br>';
	
	//new order which doesn't exist in database
	} else {
		echo 'Job: ' . $order['job_number'] . '/Line Item: ' . $order['line_item'] . ' was not found<br>';
	}
}

When I do $db_match = key($result); I get 0 each time and when I do: 

$db_match = array_search ( $order[ 'job_number' ], array_column ( $result, 'job_number' ) ) !== false && array_search ( $order[ 'line_item' ], array_column ( $result, 'line_item' ) ) !== false;

I get 1 each time...which I assume is the number of matches which meet that criteria instead of the array key I found a match on.

Edited May 8, 2020 by mongoose00318

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
)

hi,

also i have an array with this values:

$a=array('111-aa-zz-4','222-aa-zz-6','333-aa-zz-5');

and i want to sort(); this array, but it must ignore the numbers behind -aa-zz-

also 4,6,5

how should i do this?

best regards, tastro

Hey guys,   I have an array of names sorted alphabetically. I'm trying to loop through them and create new arrays keyed by the letters of the alphabet containing the names which start with that letter.     so in the end i'm trying to create something like this:   $newarray = array( 'a' => array('anna','alan','andrew'),                                'b' => array('bert','ben','bob'),
                               'c' => array('cait','carry'),                                  etc,etc );   thanks        

Code: [Select]
<?
$out = preg_replace('/^(.{701}[^.]*).*/i','$1.',$detrsltnewsrow[news_desc]);
echo $out;
?>

</td></tr><tr><td colspan="2" class="para" style="padding-left:10px;">

<?=
substr(stripslashes(trim($detrsltnewsrow[news_desc])),701)
?>
                                             
</td></tr>

I have the above snippet.. The first php statement, basically grasp the first 701 characters with the closet next stop "." character and out puts it. then out puts the HTML tags

I have a problem with the second statement. I want to output anything after what has been outputted by:
Code: [Select]
<?
$out = preg_replace('/^(.{701}[^.]*).*/i','$1.',$detrsltnewsrow[news_desc]);
echo $out;
?>

So need the correct syntax for
Code: [Select]
<?=
substr(stripslashes(trim($detrsltnewsrow[news_desc])),701)
?>
Currently it breaks at exactly the 701 character, want it to continue from the sentence the first code ended in.

I have a MySQL query that pulls multiple columns with many rows.  I want to break each column into its own array.
Here is what I have to this point but doesn't seem to be working.  Is this the right direction or is there something easier?
Thanks!

Code: [Select]

$query = "SELECT name, address, city, state FROM customers WHERE sku = '12345'";
$result = mysqli_query($dbc, $query) or die();

$name = array();
$address = array();
$city = array();
state = array();

while ($data = mysqli_fetch_assoc($result)) {
  $name = $data['name'];
  $address = $data['address'];
  $city = $data['city'];
  $state = $data['state'];
}

Hello,

I have three arrays of integers $arrayA, $arrayB, and $arrayC.  $ArrayA is a "master array" meaning the array I need to match the other two to.  $arrayB and $arrayC are generated by my functions in the application and meet specific criteria.  As such, arrays B and C will never have any intersecting values, but both should have matches in $arrayA, and I need to generate an array which contains only the values of arrayA which match either B or C.

  After finding some documentation here (http://www.metrocomp.mocsi.eu/w3/php/func_array_intersect.html)

I tried using array_intersect :

array_intersect ($arrayA, $arrayB, $arrayC)

However this does not work as described and returns no results as there are no values which are contained in all three arrays.

I wrote the below as a work around, and it works just fine but I would think there is a better way?

$temp1 = array_intersect($arrA, $arrB);
$temp2 = array_intersect($arrA, $arrC);
$temp3 = array_merge($temp1, $temp2);
$final_array = array_unique($temp3);


Thanks for looking!
Carmen

Here are the two arrays to compare.

Peopleskills            
PeopleID   SkillID
2          2   
2          7   
2          9
2              11
3          2
3                  12
3          14   
4          5
            
Equipskills            
EquipID   SkillID   
1                2          
1                9   
1               11   
2               5      
2               7      
2               9      
2               12   
2               13   
2               14   
3               2   
4               11      

The common link is SkillID.
Each EquipID has some required SkillIDs that people must have to operate that machine.
As long as a PeopleID has the required SkillIDs from the EquipSkills, that person has permission to that machine.
This will be used create a third array.
It will look something like the following.

                          EquipIDs
                      1     2     3     4     5     6     7     8      9      10       11     12
PeopleIDs   
2                    x     x
3                           x
4
5

What might be the best way to code this?

Hey Guys. I came across this code example below assigns array values to a private property. However the private property is not defined as an array. It was a bit confusing to me because I always thought you need to define  the property as an array first. If someone can please help me understand this concept I would really appreciate it.   Below is the code.

<?php 


class Product {

	public $name; 
	public $price; 

	function __construct($name, $price){
		$this->name = $name; 
		$this->price = $price;

	}


}


class ProcessSale {
	private $callbacks; // This holds an array but is not defined as an array?


	function registerCallback($callback) {
		if(!is_callable($callback)) {
			throw new Exception("Callback Is Not Callable");
			
		}
		$this->callbacks[] = $callback;
	}


	function sale($product) {
		print "{$product->name}: processing \n";
		foreach ($this->callbacks as $callback) {
			call_user_func($callback, $product);
		}
	}
}


$logger = function($product) {
	print "logging ({$product->name})\n";
};


$processor = new ProcessSale();
$processor->registerCallback($logger);

$processor->sale(new Product("shoes", 6));
echo  "\n";
$processor->sale(new Product("coffee", 6));

Hi,

I need some help getting my head around arrays.

I have a basket of fruit:

$basket=("Apple","$Orange","$Banana","$Banana","$Peach","$Apple","$Banana","$Orange","$Apple");

I want to distribute and share this basket of fruit into bowls, such that each bowl contains the following:

$bowl=("$Apple",$Orange,"$Banana","$Banana")

ie. One Apple, One Orange & Two Bananas.

I can't seem to figure out how to do it.

Thanks in advance.