PHP - Count Duplicate Adjacent (array)

I dont even know where to begin doing this. I am supposed to remove duplicate entries in this 2 dimensional array but I just can't find any answers anywhere.

Code: [Select]
<?php
/*
In the following two dimensional array (an array of arrays) you will notice that
there are several duplicate entries (David and Patricia).

1) Write a basic function which will go through $input and remove the duplicate
entries. A "duplicate" is an entry which has the same FirstName and LastName
as another entry. Ignore the other fields. Call your function "dedupe1". It
should return a two-dimensional array without these duplicates

2) Using your dedupe1 function, write one called dedupe2 which will detect empty
DOB's and DOB's of '00/00/0000'. When an empty or zeroed DOB is detected, your
code should use the entry with a complete DOB (if available). Like dedupe1
your code should return a two-dimensional array without duplicates. If you
use the provided $input function, all of the returned entries should have a
complete DOB listed.

*/

$input = array(
array(
'FirstName' => 'Daniel',
'LastName' => 'Anderson',
'Phone' => '614-123-4568',
'Address' => '123 Main St',
'SSN' => '001-01-0001',
'DOB' => '01/11/1922'
),
array(
'FirstName' => 'Aaron',
'LastName' => 'Williams',
'Phone' => '937-321-3993',
'Address' => '933 N Park St',
'SSN' => '992-23-1192',
'DOB' => '04/21/1965'
),
array(
'FirstName' => 'David',
'LastName' => 'Taylor',
'Phone' => '223-293-9921',
'Address' => '123 Main St',
'SSN' => '003-19-2992',
'DOB' => '12/14/1995'
),
array(
'FirstName' => 'Patricia',
'LastName' => 'Anderson',
'Phone' => '614-123-4568',
'Address' => '123 Main St',
'SSN' => '123-32-3123',
'DOB' => '00/00/0000'
),
array(
'FirstName' => 'David',
'LastName' => 'Taylor',
'Phone' => '223-293-9921',
'Address' => '123 Main St',
'SSN' => '003-19-2992',
'DOB' => ''
),
array(
'FirstName' => 'Patricia',
'LastName' => 'Anderson',
'Phone' => '614-123-4568',
'Address' => '123 Main St',
'SSN' => '123-32-3123',
'DOB' => '02/22/1957'
),
);

// Get results from dedupe1 and print them
$result1 = dedupe1($input);
var_dump($result1);

// Get results from dedupe2 and print them
$result2 = dedupe2($input);
var_dump($result2);

print_r($input);//just to see the information in the web page

function dedupe1($in_array) {
// your code here
}

function dedupe2($in_array) {
// your code here
}

?>

[ Newbie Alert ]   
Hi

i have an array of 39 arrays. Only 5 are shown below so that you have an idea before i ask my question.

<?
array(39) 
{
 [0]=> array(3) { [0]=> string(18) "unit name 1" [1]=> string(9) "category name 1" [2]=> string(20) "Course 1" }

 [1]=> array(3) { [0]=> string(54) "unit name 2" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" }
 
[2]=> array(3) { [0]=> string(29) "unit name 3" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" } 

[3]=> array(3) { [0]=> string(64) "unit name 4" [1]=> string(30) "category name 3" [2]=> string(20) "Course 2" }

[4]=> array(3) { [0]=> string(57) "unit name 5" [1]=> string(24) "category name 1" [2]=> string(20) "Course 1" }

[5]=> array(3) { [0]=> string(50) "unit name 6" [1]=> string(24) "category name 4" [2]=> string(20) "Course 2" }
}


i want a php solution to print category names in table headers , unit names in table rows and course name(s) in table caption.I have tried foreach loop but how to remove duplicate entries as you can see category name 1 and 2 will become two separate headers instead of one and same is the case with Course 1 and 2.
i have googled but could'nt find any solution. i don't want to remove duplicate entries , all i want to display them once in a table as described above.

Hi, can anyone help me with this.

I have a column in my table call "machine", I want to count the number of time each appears and return the results into an array

In the example below the number of times each printer appears in the column is returned to the array


____________
machine
____________
fb7500-1
fb7500-2
turbojet
turbojet
xl1500-1
xl1500-2
canon
roland

When I run the following I get the names as well as the values and I just want the values??

Result like this

Canon   1
FB7500-1   1
Roland   1
TurboJet   2
Vutek QS3200   1
XL1500-1   1

Code: [Select]
<?php
mysql_connect("localhost","XX","XX");
@mysql_select_db("schedule") or die( "Unable to select database");

date_default_timezone_set('Europe/London');

$query = "SELECT machine, COUNT(machine) FROM maindata GROUP BY machine"; 

 
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){

$array = array( 'key1' => $row[0], 'key2' => $row[1],'key3' => $row[2],'key4' => $row[3], 'key5' => $row[4],'key6' => $row[5],'key7' => $row[6]);
extract($array);
echo "$key1<br>$key2<br>$key3<br>$key4<br>$key5<br>$key6<br>$key7";

}
?>

Code: [Select]
$LinksText = array();
    for ($i=0; ($i < $cnt && $i < $total); $i++ ) {
                $Text = explode ('#', $Links[$i]);
                $LinksText[]=$Text[1];
        }
$count = count($LinksText);
print_r(LinksText);
        print count($LinksText);

if($count > 0){
echo "I am not zero"
}
else {
echo "I am zero"
}

Code: [Select]
output:

Array ( [0] => [1] => ) 2


Please tell me why the array count is 2.

I have the following array:

Code: [Select]
Array ( [item0] => Array ( [0] => name1
                                         [1] => name2
                                         [2] => name3
                                         [3] => name4
                                         [4] => name5 )etc...

Is it possible to count the number of times a name exists in the compleet array?

Thanx in advance!

HI - I have tried COUNT and array_count _values but they don't do what I want.

I have an array of 'quantities' relating to orders.

I want to count how many key=>value pairs have a positive value that is to say Not 0 or null or "".

So for example array ( shoes=>5, coats=> 3, ties=>0)

The answer I seek in this case would be 2 as ties is zero.

I don't want to know what the aggregate of the values are or other such info.

I have tried looping through with a foreach loop testing for $value > 0  and I failed miserably

Any ideas ?

Many Thanks !

<?php

$title = "This is an example of a sentence in a paragraph";
$title_array = explode(" ", $title);

$count = strlen($title_array[0]);
?>
what i want to do is store the count for every characters of every word in the array using a loop
e.g the count will be stored in a variable $chr_count then when i access the count for "This" it should be like this $chr_count[0]=4, $char_count[1]=2 etc.

Hi all

I am trying to loop through an array and output as JSON.
What I'm looking to do is create something like:

Code: [Select]
  "something": [
{"title":"Test 1"},
{"title":"Test 2"}
],

Notice that the final row has no comma.

My code is as follows:


<?php foreach($something as $thing): ?>
<?php $something_array = array('title'=>$thingt->getId()); ?>
<?php echo json_encode($something_array).','."\n"; ?>
<?php endforeach; ?>


I had to add a comma to the end of the array, or the JSON rows would not be ended with one.

How can I get it so that, no matter how many items are in the array, the last row, wil not have the comma at the end?

With the comma at the end, my JSON doesn't validate

Thanks


[/code]

i HAVE FOLLOWING VALUES IN FEED TABLE   a1a    a1b    a1c    a1d ...... 7         8        7         7 8         9        8         8 9         7        7         8 7        8        10        9 6         4        6         7 7        8         8        5 9        7         7        6   This in an array ( select a1a,a1b,a1c,a1d from feed where .....)   1) I want to know how many times each values has occured in the array ( eg:  7 occured 10 times, 8 occured 8 times)   2) How many 7's, 8's, 9's  are there in a1a,   howmany .....in a1b   Number of times each values occured OVERALL in array   as  well as also under each head   Please help

I need to find out how many times the "mac" key show is in an array.

Code: [Select]
Array
(
[serial] => Robert
[added] => Peter
[mac] => 1232091823
[mac] => 7538572375
[mac] =>943820348239804
[place] =>home
)

I can't get the COUNT of the matching results? Please help.


$SomeVar = myname;
$queryU =  "SELECT * FROM adxone WHERE username = '".$SomeVar."'";
$resultU = mysql_query($queryU);
while($scoreP = mysql_fetch_array($resultU))
{
$scoreP['roundzAa'];
$scoreP['roundzAb'];
$scoreP['roundzAc'];
$scoreP['roundzAd'];
$scoreP['roundzAe'];
$scoreP['roundzAf'];
$scoreP['roundzAg'];
$scoreP['roundzAh'];
}


$WinV = 'resultA';
$query =  "SELECT * FROM acs WHERE resultx = '".$WinV."'";
$result = mysql_query($query);
while($scoreUsr = mysql_fetch_array($result))
{
$scoreUsr = $scoreM1['winxa'];  
$scoreUsr = $scoreM1['winxb']; 
$scoreUsr = $scoreM1['winxc']; 
$scoreUsr = $scoreM1['winxd']; 
$scoreUsr = $scoreM1['winxe']; 
$scoreUsr = $scoreM1['winxf']; 
$scoreUsr = $scoreM1['winxg']; 
$scoreUsr = $scoreM1['winxh']; 
}

$count1 = count( array_intersect($resultU, $result) );
echo($count1);

mysql_query("UPDATE comp SET id=$count1 WHERE username = '".$SomeVar."'");
?>

HI ! I have a table which captures how customers came to be customer ie 'advertisement', 'friend' etc etc.

So I want to be able to show / count that N number came from referral or advertisement.

My query is simple, I select all from the Media column.

This gives me a multi-dimensional array, where each table row, becomes a new sub array. I have 3000 customers ... that's a quite a few sub arrays ! So, a sample print_r of the array looks like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [media] => friend
        )

    [1] => Array
        (
            [media] => friend
        )

    [2] => Array
        (
            [media] => friend
        )

    [3] => Array
        (
            [media] => Coming Over From Old Site


I have tried using a couple of array functions such as count(array,1) and (array_count_values($media)) but they both don't count the individual values out of the sub arrays.

I'm a bit stuck - Can anyone help me ?

Many Many Thanks !!

I have been researching php.net  regain the function parse_ini_file()

I know you can pass it an actual ini file but what if you already saved the ini file as a string and saved the string in a variable can you pass that variable to the function?

I am getting the following error Code: [Select]
[function.parse-ini-file]: failed to open stream: No such file or directory in
this is how I am calling it.

Code: [Select]
$settings = parse_ini_file($data);

echo $settings["mac"];

Hi guys

I'm kinda stuck..so hopefully you guys can lend me a hand

I've got an array containing date elements ("Y-m-d")...

I'm trying to output some data into googlecharts..so i need to count how many elements that are in the array with todays date -1 day, todays date-2 days...todays date -3days etc... Up until a set number of days (for example 7 days, 14 days etc)..

Any advice on how to go about to achieve this?

I'm using the code below to on echo certain words based on their index/key value, this works fine however, im trying to only do this in exploded quotes... the problem is, exploding quotes turns the portion into an array which cant be passed to str_word_count... how can i do the same thing only inside quotes. So that  hello world "this is a test" would become: Code: [Select]
Hello World This [0] => Is [1] => a [2] => Test [3] 

Im trying to always remove say the 4th word in quotations, or maybe the 3rd and 4th, whatever i want to omit i leave out from the echo, so echo $data[0].' '.$data[3].'; would output "This Test" omitting "Is A"

Code: [Select]
$data = 'hello world "this is a test"';
$data = str_word_count($data, 1);
echo $data[1].' '.$data[2].' '.$data[0];