PHP - Group Timestamps In Array Into Unique Instances And Count Them Via Php

I have been struggling with this for awhile now, and I think it isn't as hard as I making it.  Basically I want to "group" my array by month making a multidimensional array by months.  Basically right now my print_r($my_array) outputs:
Code: [Select]
Array
(
    [0] => stdClass Object
        (
            [id] => 2
            [did] => 2
            [dates] => 2011-06-01
            [enddates] => 2011-06-01
            [shortdescription] =>
            [max_attendance] => 1
            [times] => 06:30:00
            [endtimes] => 07:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Nightclub
            [locid] => 2
            [status] => 4
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 1
            [avaliable] => 0
        )

    [1] => stdClass Object
        (
            [id] => 57
            [did] => 57
            [dates] => 2011-06-05
            [enddates] => 2011-06-05
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 02:00:00
            [endtimes] => 03:00:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Rumba
            [locid] => 1
            [status] => 0
            [shw_attendees] => 0
            [club] => SW
            [url] =>
            [street] => 8936 SW 17th Ave
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [2] => stdClass Object
        (
            [id] => 61
            [did] => 61
            [dates] => 2011-06-05
            [enddates] => 2011-06-05
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 03:00:00
            [endtimes] => 04:00:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Waltz
            [locid] => 1
            [status] => 0
            [shw_attendees] => 0
            [club] => SW
            [url] =>
            [street] => 8936 SW 17th Ave
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [3] => stdClass Object
        (
            [id] => 1
            [did] => 1
            [dates] => 2011-06-06
            [enddates] => 2011-06-06
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Foxtrot
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [4] => stdClass Object
        (
            [id] => 11
            [did] => 11
            [dates] => 2011-06-08
            [enddates] => 2011-06-08
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Nightclub
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [5] => stdClass Object
        (
            [id] => 15
            [did] => 15
            [dates] => 2011-07-04
            [enddates] => 2011-07-04
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Rumba
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

)

I need to take that and make it look like this, grouping by the month of the 'dates' value:

Code: [Select]
Array
(
[0] => Array ( //June
    [0] => stdClass Object
        (
            [id] => 2
            [did] => 2
            [dates] => 2011-06-01
            [enddates] => 2011-06-01
            [shortdescription] =>
            [max_attendance] => 1
            [times] => 06:30:00
            [endtimes] => 07:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Nightclub
            [locid] => 2
            [status] => 4
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 1
            [avaliable] => 0
        )

    [1] => stdClass Object
        (
            [id] => 57
            [did] => 57
            [dates] => 2011-06-05
            [enddates] => 2011-06-05
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 02:00:00
            [endtimes] => 03:00:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Rumba
            [locid] => 1
            [status] => 0
            [shw_attendees] => 0
            [club] => SW
            [url] =>
            [street] => 8936 SW 17th Ave
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [2] => stdClass Object
        (
            [id] => 61
            [did] => 61
            [dates] => 2011-06-05
            [enddates] => 2011-06-05
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 03:00:00
            [endtimes] => 04:00:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Waltz
            [locid] => 1
            [status] => 0
            [shw_attendees] => 0
            [club] => SW
            [url] =>
            [street] => 8936 SW 17th Ave
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [3] => stdClass Object
        (
            [id] => 1
            [did] => 1
            [dates] => 2011-06-06
            [enddates] => 2011-06-06
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Foxtrot
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )

    [4] => stdClass Object
        (
            [id] => 11
            [did] => 11
            [dates] => 2011-06-08
            [enddates] => 2011-06-08
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Nightclub
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )
)
[1] => Array ( //July
    [0] => stdClass Object
        (
            [id] => 15
            [did] => 15
            [dates] => 2011-07-04
            [enddates] => 2011-07-04
            [shortdescription] =>
            [max_attendance] => 15
            [times] => 06:30:00
            [endtimes] => 08:30:00
            [registra] => 1
            [unregistra] => 0
            [titel] => Beginning Rumba
            [locid] => 2
            [status] => 0
            [shw_attendees] => 0
            [club] => SE
            [url] =>
            [street] => 615 SE Alder
            [please] =>
            [city] => Portland, OR
            [country] => US
            [locdescription] =>
            [catname] => Adult Classes
            [catid] => 1
            [price] => Array
                (
                )

            [registered] => 0
            [avaliable] => 15
        )
)

)

hi,

i'm trying to sort an array of associative arrays, based on one of the keys.

if the value of the key is a primitive, normal sorting occurs - this works fine.

if the value of the key is an array, i'd like to have it sorted by "groups"

here's an example:

Code: [Select]
<?php

$data[] = array('name' => 'h', 'list' => array(1,2));
$data[] = array('name' => 'g', 'list' => array(1));
$data[] = array('name' => 'a', 'list' => array(1,3));
$data[] = array('name' => 'f', 'list' => array(2));
$data[] = array('name' => 'e', 'list' => array(2,3));
$data[] = array('name' => 'b', 'list' => array(3));
$data[] = array('name' => 'c', 'list' => array(1,2,3,4));
$data[] = array('name' => 'd', 'list' => array(3,4));

function deep_sort($array, $sorton){

usort($array, function($a, $b) use($sorton) {

$a = $a[$sorton];
$b = $b[$sorton];

if(is_array($a) && is_array($b)){

// this bit is obviously flawed - only included for illustrative purposes
$a = implode('', $a);
$b = implode('', $b);

}

return ($a == $b) ? 0 : ($a > $b) ? 1 : -1;

});

return $array;

}

$sorted_by_name = deep_sort($data, 'name');

print '<pre>';

print_r($sorted_by_name);

print '</pre>';

$sorted_by_list = deep_sort($data, 'list');

print '<pre>';

print_r($sorted_by_list);

print '</pre>';

?>
the sorted_by_name bit is fine - but for sorted_by_list, what i want returned is all the array ordered as follows:

all those with "1" (or the lowest if none have "1") in it's list value first, then all those remaining that have the next highest ("2"), etc.

so right now, the returns for sort_by_list look like this:

Code: [Select]
Array
(
    [0] => Array
        (
            [name] => g
            [list] => Array
                (
                    [0] => 1
                )

        )

    [1] => Array
        (
            [name] => f
            [list] => Array
                (
                    [0] => 2
                )

        )

    [2] => Array
        (
            [name] => b
            [list] => Array
                (
                    [0] => 3
                )

        )

    [3] => Array
        (
            [name] => h
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                )

        )

    [4] => Array
        (
            [name] => a
            [list] => Array
                (
                    [0] => 1
                    [1] => 3
                )

        )

    [5] => Array
        (
            [name] => e
            [list] => Array
                (
                    [0] => 2
                    [1] => 3
                )

        )

    [6] => Array
        (
            [name] => d
            [list] => Array
                (
                    [0] => 3
                    [1] => 4
                )

        )

    [7] => Array
        (
            [name] => c
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                )

        )

)whereas i'd like to get back:
Code: [Select]
Array
(
    [0] => Array
        (
            [name] => g
            [list] => Array
                (
                    [0] => 1
                )

        )

    [1] => Array
        (
            [name] => h
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                )

        )

    [2] => Array
        (
            [name] => c
            [list] => Array
                (
                    [0] => 1
                    [1] => 2
                    [2] => 3
                    [3] => 4
                )

        )

    [3] => Array
        (
            [name] => a
            [list] => Array
                (
                    [0] => 1
                    [1] => 3
                )

        )

    [4] => Array
        (
            [name] => f
            [list] => Array
                (
                    [0] => 2
                )

        )

    [5] => Array
        (
            [name] => e
            [list] => Array
                (
                    [0] => 2
                    [1] => 3
                )

        )

    [6] => Array
        (
            [name] => b
            [list] => Array
                (
                    [0] => 3
                )

        )   

    [7] => Array
        (
            [name] => d
            [list] => Array
                (
                    [0] => 3
                    [1] => 4
                )

        )

)
TYIA for any suggestions

I have it to where it groups two parts of the Array randomly but I need to make it where it won't pair the same together, or if it has already been paired with a team then use another team. Each value of the array can only be used once.

Here is my code
shuffle($teamname);

$loopCount = $games;

for ($i = 0; $i < $loopCount; $i++) {
    $player1 = array_pop($teamname);
    $player2 = array_pop($teamname);
if(is_null($player1))
{
echo 'Not enough different teams to create '.$games.' games';
break;
}
    // output to screen
    echo "Team: " . $player1 . " Vs Team: " . $player2 . "<br />"; 

}
}

Hi all,

I would like to ask you if somebody could have a better idea to build this function.

The current one is working, but I feel this built a bit in an amateur manner.

Feel free to add your ideas so we can learn more about PHP and how to deal with arrays.

I have an array:

$arrayVideoSpecs = Array(
    Array(
        'aspect' => '4:3',
        'density' => '442368',
        'resolution' => '768x576'
    ),
    Array(
        'aspect' => '4:3',
        'density' => '307200',
        'resolution' => '640x480'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '2073600',
        'resolution' => '1920x1080'
    ),
    Array(
        'aspect' => '16:9',
        'density' => '121600',
        'resolution' => '1280x720'
    )
);

and I want an array as output grouped by video aspect ratio where the key is the pixel density and the value is the video resolution, namely like that for aspect ratio 16:9 ...

Array
(
    [2073600] => 1920x1080
    [121600] => 1280x720
)

Then I coded this function which is working but seems amateur ...

    function groupAndExtractByAspect($array, $groupBy, $aspect, $density, $resolution)
    {
        $groupByAspect = Array();
        foreach ($array as $value)
        {
            $groupByAspect[$value[$aspect]][] = Array($value[$density], $value[$resolution]);
        }
	        $arrayClean = Array();
        foreach ($groupByAspect as $key => $value)
        {
            if ($key == $groupBy)
            {
                $arrayClean[$key] = $value;
            }
        }
	        foreach ($arrayClean as $aspectGroup)
        {
            $arrayOutput = Array();
            for ($i = 0; $i <= count($aspectGroup); $i++)
            {
                $densityIsValid = false;
                $resolutionIsValid = false;
                if (!empty($arrayClean[$groupBy][$i][0]))
                {
                    $density = $arrayClean[$groupBy][$i][0];
                    $densityIsValid = true;
                }
                if (!empty($arrayClean[$groupBy][$i][1]))
                {
                    $resolution = $arrayClean[$groupBy][$i][1];
                    $resolutionIsValid = true;
                }
                if (($densityIsValid === true) && ($resolutionIsValid === true))
                {
                    $arrayOutput[$density] = $resolution;
                }
            }
        }
        return $arrayOutput;
    }

The usage is as follow ...

$showArray = groupAndExtractByAspect($arrayVideoSpecs, '16:9', 'aspect', 'density', 'resolution');
echo '<pre>';
print_r($showArray);
echo '</pre>';

Thank you very much for your ideas!

Mapg

Hi All,

I've a loop which creates an array as follows:

$product_table[] = ['SKU' => $sku, 'Label' => $attribute_name, 'Value' => $term_obj->name ];

I'm then grouping the data by SKU code:

                        #group the products by SKU
                        $group_products = array();
                        foreach ($product_table as $element) :
                            $group_products[$element['SKU']][] = $element;
                        endforeach;

Finally, I output the data:

                        #output the data
                        foreach ($group_products as $itemName => $rows) :
                            echo '<tr>';
                            #echo '<td>', $element['SKU'], '</td>';
                            $i=0;
                            foreach ($rows as $row) : $i++;
                                #echo '<td>'. $row["SKU"]. '</td><td>'. $row["Label"]. '</td><td>'. $row["Value"]. '</td>';
                                if ($i == 1):
                                	echo '<td>'. $row["SKU"]. '</td><td>'. $row["Value"]. '</td>';
                                else:
                                	echo '<td>'. $row["Value"]. '</td>';
                                endif;
                                #echo '<td>'. $row["Value"]. '</td>';
                            endforeach;
                            echo '</tr>';
                        endforeach;
                        ?>          

And looks like:

Product code System Pack Quantity XT1CWH System 1 1 x 3m XT2CWH System 2 1 x 3m XT3CWH System 3 1 x 3m

 

This works perfectly fine. However, some products share the same SKU and therefore it causes an issue, like the below:

 

Product code System Pack Quantity XT1CLWH System 1 8 x 3m System 2 8 x 3m System 3 8 x 3m
 
Is there a way I can avoid this, so if perhaps creates the new row but shows the same SKU code?
 
Many thanks

ok so i have an array which has duplicate values in it.

i used array_unique() to remove duplicate values.

the array had values 1,2,2,3.

after the following code:


$unique = array_unique($suggest);
$size = count($unique);
for ($x=0;$x<=$size;$x++)
{

     echo $unique[$x];
echo "<br>";
}



it prints out 1,2 and then gives an error, "Notice: Undefined offset: 2 in E:\wamp\www\Copy of pro2\Classes.php on line 1074" and then finally 3.

any ideas  how i can solve this.

im assuming that array_unique() assigns the index 0,1,3 of the duplicate value array to unique array at the same indexs 0,1,3. since the index 2 of duplicate array is a duplicate value it is ommited but the unique array does not have an array at index 2.

Hi guys,

How would I write a small script in php to count the unique values in the below array :

the below code if part of cubecart 3.20 shopping cart, I need to count the unique number of  Seller_ID fields within this array in the basket
to be able to calculate shipping according to the number of sellers. How would I to this ? please any help is appreciated.


Code: [Select]
if(isset($_GET['act']) && $_GET['act']=="step4"){
// set live vars for order inv and its the last step
$view_cart->assign("QUAN_DISABLED","disabled");
$view_cart->assign("TEXT_BOX_CLASS","textboxDisabled");
$basket = $cart->setVar($productId,"productId","invArray",$i);
$basket = $cart->setVar($product[0]['name'],"name","invArray",$i);
$basket = $cart->setVar($product[0]['productCode'],"productCode","invArray",$i);
$basket = $cart->setVar($plainOpts,"prodOptions","invArray",$i);
$basket = $cart->setVar(sprintf("%.2f",$price*$quantity),"price","invArray",$i);
$basket = $cart->setVar($quantity,"quantity","invArray",$i);
$basket = $cart->setVar($product[0]['digital'],"digital","invArray",$i);
$basket = $cart->setVar($product[0]['Prod_Seller'],"Prod_Seller","invArray",$i);
$basket = $cart->setVar($product[0]['Seller_ID'],"Seller_ID","invArray",$i);

}  else {
$basket = $cart->unsetVar("invArray");
}

Hi,Dear Frnd...........I Hope u r all fine.
I am using php array_unique function.Here is the problem in this function.
This is the code.
Code: [Select]
<?php
$frnd1 = array(
0=> 'arfan',
1=> 'haider',

2=> array(
0=> 'azeem',
1=> 'jeme',
),
3=> array(
0=> 'haider',
1=> 'one'
)
);
// please do not change the above code.
// You can only change below code.
print_r($frnd1);
echo '<hr />';
print_r(array_unique($frnd1)); 
?>
This work fine,But when I am used array_unique then it does not work.
When I am used array_unique.It ignore the [3]=>Array.
As you can see in my array,Here is two time name "haider".
I want to do that in this array all same names are convert into
one unique name.
In this array I want to ignore the "haider" name bcs it is
two time.How can I do that.
Remmber :: This example is very simple.Bcs u can
understand it easily.Suppose if it is dynamically changed array
then what i did do to make it unique.

Right now I have an array of zipcodes with open invitations; I want to loop over the array of zipcodes, query the database and get the name of each zipcode and then remove duplicate names.

So if 90210, 90211 and 90212 are in the array with the first 2 being City A and the last one being City B, I just want City A and City B, not City A, City A, City B.

Right now I'm doing this:
Code: (php) [Select]
foreach($invitation_Zipcodes as $key => $value){
echo 'Key: '.$key.' Value: '.$value.'<br/>';

$csaname_sql = "SELECT CBSA_Name FROM ZIPCodes WHERE ZipCode = '$value'";
$csaname_result = mysql_query($csaname_sql);
$csaname_array[] = mysql_fetch_assoc($csaname_result);

}

//$csaname_array = array_unique($csaname_array);

print_r($csaname_array);
echo '<hr/>';
print_r($invitation_Zipcodes);
exit;
That outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [1] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [2] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [3] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [4] => Array
        (
            [CBSA_Name] => Pensacola-Ferry Pass-Brent, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

If I uncomment the unique call, it outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

What am I doing wrong? Why is it losing "Pensacola-Ferry Pass-Brent, FL" ?

Good morning!

I have a two dimensional array, basically a table (see code below). I want to get a value from the array using two methods:
1) Using the row's key:  $NewValue = $MyArray[$UniqueKey];
2) Using the row's index (row number, so to speak): $NewValue = $MyArray[$RowNumber];

The second print statement in the code below does not work. Both print statements should output the same value. Is there an easy way to do this? The table has hundreds of rows and I will not know the key value of row 879 nor can I generate it. So I cannot use array_keys(). And I DO NOT want to start at the first row and count up to the 879th row.

Any clever ideas to share and enlighten?
Thanks!

<?php
// Initialize the array keys and values
$MyArray = array();
$MyArray['first']['col1'] = 'abc'; $MyArray['first']['col2'] = 'def'; $MyArray['first']['col3'] = 'ghi';
$MyArray['second']['col1'] = 'jkl'; $MyArray['second']['col2'] = 'mno'; $MyArray['second']['col3'] = 'pqr';
$MyArray['third']['col1'] = 'stu'; $MyArray['third']['col2'] = 'vwx'; $MyArray['third']['col3'] = 'yz';
$MyArray['fourth']['col1'] = 'a1a'; $MyArray['fourth']['col2'] = 'b2b'; $MyArray['fourth']['col3'] = 'c3c';
$MyArray['fifth']['col1'] = 'ddd'; $MyArray['fifth']['col2'] = 'eee'; $MyArray['fifth']['col3'] = 'fff';
// Two methods to get a value. Second one does nothing.
print"{$MyArray['third']['col2']}</br>";
print"{$MyArray[2]['col2']}</br>";
?>

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

Hi all,

I have a situation where I need to remember what check boxes where checked over pagination, I have managed to do this via the use of this:

http://jamesfunk.com/wordpress/?p=65

The problem is that as the code stood:

Code: [Select]
<input type="checkbox" name="compare" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
It was treating one ticked checkbox as them all because they all have the same name and are in the a while loop!

I countered this by changing the code to:

Code: [Select]
<input type="checkbox" name="compare<?php echo $list['jobseeker_id']?>" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
Which effectively now makes the checkbox name unique... i.e. compare{id}.

The problem with this is that I can now no longer process it. This is my processing code:

$jobseekers = $_POST['compare'];
$i = 0;
for($i; $i<count($jobseekers); $i++){
$query = "SELECT * FROM jobseekers WHERE jobseeker_id = '$jobseekers[$i]'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
// Spit out the required data
}
}

As you can see I am trying to get the data from $_POST['compare'], which will obviously now be blank as I have had to make the name unique.... the trouble is I'm not sure how to actually process this.

Can anyone help me out here? any help or advice would be greatly appreciated!

many thanks,

Greens85

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp. 
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6 
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again 
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered. 
d) display the code on screen.

What code must I put and where?


**My current php is as follows:**

Code: [Select]
    require "includes/connect.php";
   
    $msg = '';
   
    if($_POST['email']){
   
    // Requested with AJAX:
    $ajax = ($_SERVER['HTTP_X_REQUESTED_WITH']  == 'XMLHttpRequest');
   
    try{
    if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
    throw new Exception('Invalid Email!');
    }
   
    $mysqli->query("INSERT INTO coming_soon_emails
    SET email='".$mysqli->real_escape_string($_POST['email'])."'");
   
    if($mysqli->affected_rows != 1){
    throw new Exception('You are already on the notification list.');
    }
   
    if($ajax){
    die('{"status":1}');
    }
   
    $msg = "Thank you!";
   
    }
    catch (Exception $e){
   
    if($ajax){
    die(json_encode(array('error'=>$e->getMessage())));
    }
   
    $msg = $e->getMessage();
    }
    }

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.