PHP - Help, With Array Filter

Hi All

I have a script which imports values from a csv file created using excel.   However there are several blank values within the file where the person creating it has used blank columns to create whitespace in the file.

I have used array_filter to remove these from the array, however how do I remove the redundant keys and 'squash' everything together so it is nice and neat?

eg
import would be , ,id, , surname, ,firstname, ,DOB, , address, ,

which returns array after array_filter
[1]-> id
[3]->surname
[5]->firstname
[7]->DOB
[9]->address

I want to return as an array which would be
Quote

[0]-> id
[1]->surname
[2]->firstname
[3]->DOB
[4]->address


Is there a function to do this or would I need to create a custom one?

hi,

Im getting data from a database and store in an array.
and there will be a lot of repeating data in the array.
I would like to know if there is any function can filter the array and arrange in a nice position.
or there's no way doing it and need to check it manually?

appreciate for the help. thanks.

Havent posted here in a while, been learning lots but im stuck on trying to unset/replace arrays that contain awkward key values.

 

[0] => 2021-06-02T19:40:00Z
    [1] => 2021-06-03T02:10:00Z
    [2] => 2021-06-03T01:10:00Z
    [3] => 2021-06-02T23:05:00Z
    [4] => 2021-06-02T23:05:00Z
    [5] => 2021-06-02T23:07:00Z
    [6] => 2021-06-02T23:20:00Z
    [7] => 2021-06-02T18:20:00Z
    [8] => 2021-06-03T00:10:00Z
    [9] => 2021-06-03T00:40:00Z

The json Im using is constantly updated, not sure why tmrw's dates June 3rd are at the top for their API design =[ Not good at regex. preg_replace/etc. Im desperate id use array search manually if I knew how to simple parse out tmrw's dates. I have unlimited API calls so I reckon  it don't matter, here's what Ive been playing with

$oddsdata = 'https://pinnacle.datafeeds.net/api/json/odds/pinnacle/v3/60/baseball/mlb/moneyline?api-key=a71b8fe8e9eb957db549aaa5d99797a4'; 

$readodds = file_get_contents($oddsdata);
$odds = json_decode($readodds, true);
$today = date("Y-m-d");
$tmrw = date('Y-m-d', strtotime( $today . " +1 days"));

foreach($odds['games'] as $key => $val):
$gidRE[$key]["gid"] = $val["gameUID"]; 
$startOdds[$key]["start"] = $val["startDate"]; 
$homeTeams[$key]["hteam"] = $val["homeTeam"]; 
$awayTeams[$key]["ateam"] = $val["awayTeam"]; 
$Price[$key]["betPrice"] = $val["betPrice"]; 
$BookOdds[$key]["book"] = $val["sportsbook"]; 
$BetName[$key]["betName"] = $val["betName"]; 
$Live[$key]["Live"] = $val["isLive"]; 
endforeach;


$endgidd = end(array_keys($gidRE)) + '1';
$endz = end(array_keys($odds['games']));
for ($l = 0; $l < $endz; ++$l) {
$OddsAll[] = array_merge($gidRE[$l], $startOdds[$l], $homeTeams[$l], $awayTeams[$l], $Price[$l], $BetName[$l]);
}

 

Hi - I am uploading Post variables off a form relating to products and customer orders. If a product has a quantity attached to it then all the POST variables relating to that product need to INSERTED into the DB. If a product has just an empty string in it's quantity variable, then that product does not get INSERTED.  So I thought of 2 different approaches:


A) I could filter the Quantity Post variable for a positive values then create a new array only containing products with positive quantities.   
B) I could loop through the product Id (ProdID) POST and using a condition pull out the products with a positive quantity for Insertion.


I have been experimenting with B and have failed miserably.


However I have succeeded excellently in building some code which INSERTS all the products regardless of their quantities ( see below ) - not ideal as it enters products with empty quantities.
I would prefer to adapt what I have rather than throw it away.
Can someone kind person give this student a hand with some advice in adapting what I have got ?


MANY MANY THANKS !


Code: [Select]
<?php



function insert_tel_order(){
$lastname = $_POST['lastname'];
$orderid = strtoupper(substr($lastname,0,3)).(substr(time(),-4));  //Creates a unique order number
$customerid = $_POST['customerid'];
$pickupdate = $_POST['pickupdate'];
$deliverylocationid = $_POST['deliverylocationid'];
$orderdate = $_POST['orderdate'];

foreach ($_POST['prodid'] as $arrkey => $prodid){
$quantity = $_POST['quantity'][$arrkey];
$prodid = $_POST['prodid'][$arrkey];
$price = $_POST['price'][$arrkey];
$ordervalue = $quantity * $price;

$sql =" INSERT INTO `order` (id, orderid,orderdate,customerid, deliverylocationid,pickupdate,prodid,price, quantity, ordervalue, status) 
VALUES ('', '$orderid',$orderdate,$customerid,$deliverylocationid,$pickupdate,$prodid,$price,$quantity,$ordervalue,'')";
$this->db->query($sql);


}


}




?>

Hi guys,

I'm trying to build an array to replicate the hierarchy in a menu:

<ul>
<li><a href="file1.html">text1</a></li>

<ul>
<li><a href="file2.html">text2</a></li>
<li><a href="file3.html">text3</a></li>
<li><a href="file4.html">text4</a></li>
<li><a href="file5.html">text5</a></li>
</ul>

</ul>

An i would like the output to be:

"text1"
"text1", "text2"
"text1", "text3"
"text1", "text4"
"text1", "text5"
 

Here is my loop to go through the html hierarchy:

        foreach ($html2->find('ul') as $ul) {
            foreach ($ul->find('li') as $li) {
                foreach($li->find('a') as $a) { 
                    // need to filter out empty and index.html, tried if(!$->href = 'index.html) {do stuff} but didn't work
                    $links2[] = $a->href ;
                    $taxo2[] = $a->plaintext ;                   
                }
            }
        }

This finds all the links but not the hierarchy, any ideas how to approach this? And also how to filter out blanks and references to index.html?