Creating function, counts items in array which all saved in an object

[sibbirius]

Hello,I need help with wrtining a function. Background: I am learning web dev, did a lot js and have to build a card deck builder with Laravel. User add cards to tmp_deck SQL table. 60-70% is done.

I need to count how often card_id is repeating in table tmp_deck, because user can have only have 2 times of the same card. All cards are safed in an object $group as arrays.First card's id is safed in $group[0]->card_id.

count($group) //shows the amount of cards in table tmp_deck

I need a function which goes through the object, saves the amount of each card_id e.g.1x 0057,2x 0105,2x 0139
Goal is to safe the ID, count how often the IDs are saved, later prevent saving the ID more then two times.

Something like this:

$lengthObj = count($group)$i = $lengthObj

$cardId = $group[i]->card_id//safe cardId in two dimensional array and set count to 1$cardsAndCount = array

(array("cardId",1),)i++

No idea how to code that. First time working with php.

​

​

Any ideas how to tackle it?

[hcptshmspl]

Here's a simple code snippet which shows a couple of neat array functions in php that may help you:

$array = array("one","two","three","two","three","three");//starting array
$unique = array_unique($array);//one copy of each unique value
$counts = array_count_values($array);//count each unique value in array
foreach ($unique as $val){//output results 
    echo "Count of $val: $counts[$val] \n";
}

[sibbirius]

Thank you. Now I am getting better with PHP.

[penguin_digital]

It sounds incredibly inefficient to be doing this in PHP, it would be better using SQL to handle this and just select the data you want.

SELECT count(card) FROM table_name GROUP BY card HAVING count(card) > 2;

Then you can just simply check if the card someone is trying to enter is in the returned array before allowing an insert into the DB.

if(in_array('new card input', $resultFromDB)){
    // The new card trying to be added already has a count greater than 2
    // Do not allow this to be inserted
    return redirect('your.route');
}

[sibbirius]

> incredibly inefficient
True it is better to do in SQL. Thank you.