PHP - Count Words In Array, Sort And Filter By Variable Occurences

Hi !

I have an 2d array like this:
                     column 1              column 2          column 3
                      $data[0][0]      $data[0][1]    $data[0][2]
$data[0][0]    RDR                   -1.3                0.001
$data[1][0]    RQR                    0.4                0.01
$data[2][0]    DDR                    1                   0.00004
and more...

Now i need to filter this data. I only need the rows with column 3 < 0.01 AND column2 > 1 or column 2 < -1 .
I have this, but it doesn't work:

$teller = 0;
for($i = 0; $aantal>$i; $i++)
{
   if($data[$i][2]<=0.01)
   {
      
      $p[$teller][0] = $data[$i][0];
      $p[$teller][1] = $data[$i][1];
      $p[$teller][2] = $data[$i][2];   
      $teller++;
   }
}
$teller2 = 0;
for($i = 0; $teller>$i; $i++)
{
   
   if($p[$i][1] < -1 || $p[$i][1] > 1 )
   {
      #als de p value kleiner is dan 0.01 dan alles kopieren in een nieuwe array
      $r[$teller2][0] = $p[$i][0];
      $r[$teller2][1] = $p[$i][1];
      $r[$teller2][2] = $p[$i][2];   
      $teller2++;
   }
}

Can you help me?

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 guys,

I'm trying to sort an array. The array has information about listings. ID, name, info etc.

An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order...

This snippet shows that the original listings array can be sorted by link_id:
sort($this->links, $this->link->link_id); //This works. It sorts links by link ID!

In a foeach loop I have created this:
$sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID.

It makes this:
array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), )

I can then sort this array of arrays with this function:

function compare_sleeps($a, $b){
return strnatcmp($a['Sleeps'], $b['Sleeps']);
} # sort alphabetically by name
usort($sleeps_array, 'compare_sleeps');

It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array?

Sounds complicated, I hope you got that!

Cheers, RJP1

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.

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?

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);


}


}




?>

Is there a way to use sort($Array) on numbers but reverse it. So instead of 1 to 3 itll do 3 to 1 ? AKA descending order?

Can't find a function that would do unless theres a second sort function ?

Thanks

Why does krsort return the array as "1"?

Code: [Select]
$m = array('34' => 1122, '6' => 1944, '9' => 1710);
print_r($m); //outputs: Array ( [34] => 1122 [6] => 1944 [9] => 1710 )
print_r(krsort($m)); //outputs: 1

What i need is the output to be

Array ( [6] => 1944 [9] => 1710 [34] => 1122)

I want to check if a string has any of words listed in array;
Code: [Select]
$array=array('word1', 'word2', 'word3');
$string="This is a sentence containing word2";
Now I want to make an 'if else' to check if the string contains any of the words listed in the array. Thanks 

Dead simple, I know it is but I'm still a little newbie. I have this chat box, and I don't want people to be able to swear in it so I need help making a function where you call the string as an argument and it returns true if the string has any words from an array in it, Even if the word is walking and not just walk. If it's true I can replace the entire string with something else.

Can someone tell me what functions I need? I prefer you didn't do it all for me I need to learn 

Thanks in advance!

Hello,

I'm having trouble getting a piece of code to work and as a result right now i have bloated code on a simple task.  Currently my code looks like this:

Code: [Select]
//convert responses into one string to check for spam
$full_string = $name.' | '.$email.' | '.$message;
//look for spam words
if ( (stristr($full_string, 'test')) || (stristr($full_string, 'http')) || (stristr($full_string, 'www')) || (stristr($full_string, 'site')) || (stristr($full_string, 'fake')) || (stristr($full_string, 'viagra')) || (stristr($full_string, 'cialis')) || (stristr($full_string, 'asdf')) || (stristr($full_string, 'txt')) || (stristr($full_string, 'doc')) || (stristr($full_string, 'xls')) || (stristr($full_string, 'htm')) || (stristr($full_string, 'sale')) || (stristr($full_string, 'free')) ){

I would like to instead place all my 'spam' words in an array like this
Code: [Select]
$spam_array = array('test', 'viagra', cialis...etc
If i had all my spam words in an array, how would i write an if statement to check if any of those words appeared in $full_string ?

Thanks for your help!

I am creating a football predictor game and have a table in the database to hod all my users i have written a query to pull all out the users that have made a prediction that day with their predictions made i have put this into an array so my array will hold all the user details 1 being their userId I have set the order by on the query to userId so I get all the same users predictions in 1 block. I now want to extract all the predictions for each user and put these into their own array but I don't know which users the array will hold, how many users their will be, or how many predictions each user would have made so i'm not sure how to create this array i'm quite new to php can anyone help me with this

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