PHP - Filter Database From Words In An Array

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

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 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?

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!

<?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.

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

 hello, i seem to be stuck again and this bug is difficult for me to solve.

if(isset($_POST['boards']))
	$boards[] = $_POST['boards'];
$allboards = implode("",$boards[0]);
echo $allboards;

outputs (browser source)...
hello
world

I have a combobox with the "multiple" property.  when two items are selected, the combobox "name" property has an array that passes to the $_POST variable. what i would like is those two words to be displayed on the same line.
I have tried rtrim($var, "\r\n") but that does nothing.

the reason i need them on the same line is because i would change then to "hello, world" and then add them as a mysql query, for example... $query = "SELECT hello, world FROM table...

Hi, i'm new here and hope i've finally found a forum where i can find the perfect solution for my questions.   Well since a year now i started to work with PHP and still now and then there are some things where i seize on. My question is on of those situations.   I have the following code:

if (isset($_POST)){
    
    foreach ($_POST as $key => $value){

    if (!empty($value)){
    $update_rma_detail_stmt = $dbh->prepare("UPDATE rma_detail SET $key = ? WHERE rd_rma_nr = ?");
    $update_rma_detail_stmt->bindParam(1, $value);
    $update_rma_detail_stmt->bindParam(2, $getadmrmaid);
    $update_rma_detail_stmt->execute();

    }
  } 
}

All i want is when there is an empty (not filled in) input field because it is not mandatory the foreach still continuous to the end. When i use

if (!empty($value)){

It still outputs these error:   Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ' '   However, when i dont use i got an other error:    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: ''   It is however so that the datetime is the very first empty field it come across when looping. I think my if (!empty($value)){ is doing the right thing but still gives error's on integers. Can it be? I allready tried to use trim() or array_filter() but because i previously never used it i dont know if i am doing it the right way so any help is welkom!   Thanks!
Edited by Raz3rt, 20 May 2014 - 02:56 AM.

Hi all,

This is a piece of code of my php page and what I need is that $n1 till $n4 is filled. Somehow only $n1 is filled.
Can anyone tell me what I'm doing wrong here.

Thnx Ryflex

$sql = "SELECT name FROM unittype WHERE type = 1";
$result = mysql_fetch_array(mysql_query($sql)) or die("Could not find units");
$n1 = $result[0];
$n2 = $result[1];
$n3 = $result[2];
$n4 = $result[3];
echo "$n1 <BR> $n2 <BR> $n3 <BR> $n4";

Hi Guys

I was just wondering if their is a function to randomize an array pulled from database is it possible i know their is array_rand() but it doesnt seem to work for me can someone show me where i am going wrong or do i have to do it from the actual SELECT statemant i.e ORDER_RAND(); ?

Here is what my array prints out.



 $user_list = get_users_by_specialism($specialism);

print_r($user_list);

outputs.

Array ( [0] => 129 [1] => 46 [2] => 57 [3] => 109 [4] => 92 [5] => 137 [6] => 238 [7] => 101 [8] => 60 [9] => 90 [10] => 112 [11] => 133 [12] => 121 [13] => 220 [14] => 275 [15] => 278 ) 



I basically need to make this array output in a random order everytime not by ID incrementing.

Any help Please

Cheers.

Hi, I'm still new to php and having some problems. Sorry about the code not being formatted properly. The snippet I posted has both the code intend to work but it is commented out and a test version that has an array already set thus getting rid of the need of setting up every thing like I have.

Ok this is basically my problem. I'm building a store like website. Its suppose to be very basic for now Part of the website is an RMA system where the customer enters an order number and then pulls up all items in the order on a different page in a table format with check boxes next to each item found in the database.  Each item that is checked off is then saved to an array rma[] which posts to another page when submitted. What this page(copied down below) does is it pulls values from the cookie already made and creates new variables which is not a problem. After that it does a foreach loop for the array of the items into a mysql query which then is suppose to insert it into a database.

When the code runs it only inserts the first item in the array into the database no matter how many items are in the array. When I echo the $insert statement I get this(using the test code) like I expect I'm suppose to. I would assume that because I'm doing a foreach loop that it is doing an INSERT for the number of items in the array.

Quote

INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Saab','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Volvo','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','BMW','123')
INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('857442', '1','Toyota','123')


Code: [Select]
<?php

//connects to the data base
 mysql_connect("localhost", "root", "") or die(mysql_error()); 
 mysql_select_db("project") or die(mysql_error()); 

/* //retrieving rma array from previous page
$rmarequest = $_POST['rma'];

//retieves using name from cookie
$username = $_COOKIE['ID_my_site'];

//retrieves order number from cookie
$ordernumber = $_COOKIE['order'];


//creates rma number
$rmanumber = rand(1000, 999999);

//retrieves accountid from database using the username
$getid = mysql_query("SELECT AccountID FROM users WHERE username = '$username'");
$id = mysql_fetch_array( $getid );

//takes the value of $id
$final = $id['AccountID'];


//suppose to loop through all values for the array created by $request on the previous page and insert into database

foreach($rmarequest as $key){


// $insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '".$AccountID."','".$key."','".$ordernumber."')";
//mysql_query($insert) OR die(mysql_error());


//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 //mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert;}
*/


//THIS SECTION IS TEST ONLY

//test array
$cars[0]="Saab";
$rmarequest[1]="Volvo";
$rmarequest[2]="BMW";
$rmarequest[3]="Toyota";


//creates rma number
$rmanumber = rand(1000, 999999);


foreach($rmarequest as $key){

//this is test to see what is being passed to mysql server
$insert = "INSERT INTO `project`.`rma` (rmanumber, AccountID, item, ordernumber) VALUES ('".$rmanumber."', '1','".$key."','123')";
 mysql_query($insert) OR die(mysql_error());

//to view what $insert is passing to the data base.
echo $insert."<br />";
}

?>

Included is a copy of the table and the php code above.