PHP - Remove Odd Datas From Array

So, I am making a system that shows if there are new posts or not. How I have it done is a singular array called "Read" will have all of the IDs of the read posts.

It is entered in the database like so:
$ID2= $_SESSION['UserID'];
$ID2 = mysql_real_escape_string($ID2);
$Readornot=mysql_query("SELECT * FROM forum_read WHERE Reader_ID='$ID2'");
$Readornot2=mysql_fetch_array($Readornot);
if($ID2==0)
{
}
else
{
if(empty($Readornot2))
{
$Read1= array("Read" => $Get_TopicID);
$Read2 = implode('-',$Read1);
mysql_query("INSERT INTO forum_read (Reader_ID,`Read`) values ('$ID2','$Read2')") or die(mysql_error());
}
else
{
$cr_topicid=$Readornot2['Read'];
if(strpos($cr_topicid,'-'))
{
$cr_topicid=explode('-',$cr_topicid);
if(!in_array($Get_TopicID,$cr_topicid,true))
{
$Read0=implode('-',$cr_topicid);
$Read1= array("Read" => $Read0, $Get_TopicID);
$Read2= implode('-',$Read1);
mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error());
}
}
else
{
if($cr_topicid==$Get_TopicID)
{
}
else
{ 
$Read1= array("Read" => $cr_topicid, $Get_TopicID);
$Read2= implode('-',$Read1);
mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error());
}
}
}
}

It all works fine and dandy to the point where if it's in the database an icon will be black and white, and if its not it wont, signifying read or unread.

What I need to do, however, is make it so when there is a new post, it takes all of the entries in the database with the topic ID out of the database, and strips the one part.

What I thought of at first was to use str_replace to replace
"-" . $TopicID . "-"
with
"-"

But of course, that won't work, because the very first entry could be  the topic ID, so it would just be $TopicID- and not -$TopicID- in the database.

So, how would I go about doing this?

Hello guys,

need some help.


Let us say i have an array =

2011 ipad
2011 ipad review
2011 ipad price
2011 ipad design
2011 ipad reviews
review 2011 ipad
2011 ipad feature


I would like to review all the array elements that contain "review"...So the final array should look like

2011 ipad
2011 ipad price
2011 ipad design
2011 ipad feature

Thanks

I am trying to write a dirty script that removes duplicate rows from a multidimensional array.

I want to be able to edit the function and spit the duplicates out to a CSV file.

Here is my test file:


$fullArray = array(array('Jim', 'Jones'),
array('Pete', 'Pumpkin'),
array('Barak', 'Obama'),
array('Jason', 'Newstead'),
array('Toby', 'Keith'),
array('Jim', 'Jones'),
array('Jim', 'Nelson'));


echo "<h1>Original</h2>";
for($i=0; $i<count($fullArray); $i++) {
echo $fullArray[$i][0] . " " . $fullArray[$i][1] . "<br />";
}

echo "<h2>Checked</h2>";
$cleanArray = array();
$cay = array();
$nn=0;
$dup=0;
// Loop the entire input array
foreach ($fullArray as $index => $item) {
echo "foreach index:$index<br>";

        // Start an internal pointer
for ($f=0; $f<count($fullArray); $f++) {
echo "for $f ";
                // if the index is lower or the same as the pointer, skip it to cut down on time
if ($f > $index) {
                        // if the rows are the same...
if($fullArray[$f][0] == $item[0] && $fullArray[$f][1] == $item[1]) {
echo "$item[0] DUP<br>";
                                // remove it from the array
$cay = array_push($cleanArray, array($item[0], $item[1]));
array_pop($fullArray[5]);

$dup++;
} else {
                                // not a duplicate
echo " not a dup<br>";
}

} else {
echo "ON THIS ONE<br>";
}
}
echo "<br><br>";
}
echo"<br>$dup duplicates found<br><br>";
print_r($fullArray);
echo "<br /><br>";
// print_r($item);
print_r($cleanArray);
?>


When I spit out the new fullArray variable, it still has an element from the duplicate record.

This is what I get for the output of the full array after the duplicate was removed:
Quote

Array ( => Array ( => Jim [1] => Jones ) [1] => Array ( => Pete [1] => Pumpkin ) [2] => Array ( => Barak [1] => Obama ) [3] => Array ( => Jason [1] => Newstead ) [4] => Array ( => Toby [1] => Keith ) [5] => Array ( => Jim )[/b] [6] => Array ( => Jim [1] => Nelson ) )

I'm very beginner with arrays.... i KNOW, databases exist, it's more easy.. I can't use a database.. I have to use, this.. or similar.. that doesn't requiring a database engine... 

So... that array...

array (
     array(string, int, int, string, string),
     array(string, int, int, string, string),
     array(string, int, int, string, string),
    ....+250
     array(string, int, int, string, string)

);

I search by the element [#][0].. in the +250 some will contain the same infos and I would like to make them point to the element containing the info instead of repeating it and have to update at 3-4 places when it's time. Like what it's in "10" also good for "ten", "dix" and "diez"...

anyway to make that simple?  by reference or...???

I'm crying.. last time I used arrays... Turbo Pascal.. at school... or was it Turbo C++ 3.0?? Maybe it was with cobol... well it was the good ol' time of the 90s!

 

Thanks!

 

-TRP-
 

 

 

Hello everybody, I have found a lot of amazing advises and codes to improve on my existing codes. It seems to be an awesome site. I actually came from a background of Application programming, however I have just recently pick up a project in php. The project is about database integration, where I have to integrate 5 supplier's existing data who have different attributes into one. (each suppliers have about 30k data)  I really need help and advises on how should I do the script.

Here's the details, All the suppliers uses different data file, such as CSV and .xls. I am finding a way to integrate all the 5 files into one database(mysql/phpmyadmin) so it could be listed out in a shopping cart or catalog in future. However, I am unfamiliar with php, so please advice on how can i go about fixing this problem. The first problem is that each individual suppliers uses a different attributes name, for example

Supplier 1 uses : SupplierName, SupplierID, SupplierAddress, Status

Inside the status, the supplier uses data such as, Good, Excellent, Great

while Supplier 2 uses : SName, SID, SAddress, Status
and inside this supplier, the status data that are being uses is G, Ex, Gr.

How can I set a consistancy on the data and converting all the properties into one so I can import this data into a proper database such as mysql/phpmyadmin. Please help, thanks in advance

Hi,

I have an array filled with values like this:

Code: [Select]
string(1) "Acer 1"
string(2) "Acer 2"
string(3) "Dell 1"
string(4) "Dell 2"
string(5) "Dell 3"
string(6) "Dell 4"
string(7) "Acer 3"
string(8) "Acer 4"
Is there a way to successfully remove all array strings that starts with a given value like "Acer"?

I tried with this snippet, does not work:

Code: [Select]
foreach($array as &$value) {

  if(preg_match("/^Acer/", $value)) {
  unset($value);
} }

Any ideas will be appreciated!

Hi guys!

i got this code:
Code: [Select]
<?
$x = "abcde";

str_split($x);
for ($k=0; $k<=119; $k++){
$ax = array($x[0],$x[1],$x[2],$x[3],$x[4]);
shuffle($ax);
    $text = implode("", $ax) . "";
echo $text;
echo "<br />";
}
?>
if you test it you see that it is working but giving me allot of duplicates results!

there is a way to ignore duplicaes while it is runing?

thanx.

I hav a php page which takes data from the db.But the problem i am facing is for a particular fild in database ,i have long data,which i need to b displayed in a wordwrap way

eg my data is "    Description      need a site for school    gave order on 12-10-2010     work started on 12-10-2010   "
this shuld  be displayed as
"Description      need a site for school
                        gave order on 12-10-2010
                        work started on 12-10-2010"

Description is the field in the database and rest of them are the datas in it

guys, please help

i have table with datas like speed of vehicle, position e.t.c from morning 8 a.m. to 8 p.m.

I need to get these details, but after every 15 minutes
i.e. after selecting datas at 8 a.m. it shd select datas @ 8.15 a.m. then 8.30 a.m.

hw can i write a mysql query for this ? or a PHP approach is appreciated

Hi all,

Is there a function or method to delete element from current position in array without knowing the index. For example:




$ar = array( 1, 2, 3, "test", 4, 5, "test2" );

while( $v  = current( $ar ) )
{
    if( key( $ar ) == "test" )
     {
          // remove element from the array where key equals "test"
          // i could count every cycle and splice from that index but i wonder can that be done without it
          // i am looking at the php array functions but i can't find any that will delete from element from current position in array

          echo 'key( $ar ) je test. key( $ar ): ' . key( $ar );
     }

      next( $ar );
}



One thing that i don't understand is that when i run example above the "test" key is found and when i echo it it gives me 0.

Doing an API call and want to remove duplicates so I can display the products by brand. Problem I am having now is when I try to display the brands, I am getting duplicate brands. When I display the brands I am getting Nike, Nike, Reebook. When I just want, Nike, Reebok.

My Code
Code: [Select]
<?php
$results = array(); //array from API call

$results2 = $results['data'];

function multi_unique($array) {
        foreach ($array as $k=>$na)
            $new[$k] = serialize($na);
        $uniq = array_unique($new);
        foreach($uniq as $k=>$ser)
            $new1[$k] = unserialize($ser);
        return ($new1);
    }

$results3 = multi_unique($results2);

foreach ($results3 as $var)
{
echo $var['brand'];
?>
<br />
<?php
}

?>
The array
Code: [Select]
{
   "errors": [
   ],
   "warnings": [
   ],
   "data": [
      {
         "url": "http://[...]",
         "image_url": "[...]",
         "image_thumb_url": "[...]",
         "keyword": "Red Running Shoes",
         "description": "Red Running Shoes - Perfect for long jogs!",
         "category": "Shoes",
         "price": "59.99",
         "price_sale": null,
         "currency": "USD",
         "merchant": "",
         "brand": "Nike",
         "upc": "0944588778",
         "isbn": null,
         "sales": 23
      },
      {
         "url": "http://[...]",
         "image_url": "http://[...]",
         "image_thumb_url": null,
         "keyword": "Blue Running Shoes",
         "description": "Blue Running Shoes - Perfect for long jogs!",
         "category": "Shoes",
         "price": "59.99",
         "price_sale": "49.99",
         "currency": "USD",
         "merchant": "",
         "brand": "Nike",
         "upc": "0944588779",
         "isbn": null,
         "sales": 12
      }
{
         "url": "http://[...]",
         "image_url": "http://[...]",
         "image_thumb_url": null,
         "keyword": "Black Running Shoes",
         "description": "Black Running Shoes - Perfect for long jogs!",
         "category": "Shoes",
         "price": "59.99",
         "price_sale": "49.99",
         "currency": "USD",
         "merchant": "",
         "brand": "Reebok",
         "upc": "0944554779",
         "isbn": null,
         "sales": 12
      }
   ],
   "coupons": [
         
   ],
   "countryCode": "US",
   "page": 1,
   "limit": 10,
   "totalRecords": 3
}

Can anyone let me know what I am doing wrong.  I am sure it will (after the fact) be obvious, but I don't see it right now.  Wish to remove all array elements which do not implement ValidatorCallbackInterface.  Thanks

<?php
interface ValidatorCallbackInterface{}
class ValidatorCallback implements ValidatorCallbackInterface{}

function array_filter_recursive($input) {
    foreach ($input as &$value) {
        if (is_array($value)) {
            $value = array_filter_recursive($value);
        }
    }
    return array_filter($input, function($v) {
        return $v instanceOf ValidatorCallbackInterface;
    });
}

function recursive_unset(&$array) {
    foreach ($array as $key => $value) {
        if (is_array($value)) {
            recursive_unset($value);
            if(empty($value)) {
                unset($array[$key]);
            }
        }
        elseif(!$value instanceOf ValidatorCallbackInterface) {
            unset($array[$key]);
        }
    }
}

$validatorCallback = new ValidatorCallback();
$rules=[
    'callbackId'=>"integer",
    'info'=>[
        'arrayofobjects'=>[$validatorCallback],
        'foo1'=>'bar1'
    ],
    'foo2'=>'bar2',
    'bla'=>[
        'a'=>'aa',
        'b'=>'bb',
    ],
    'singleobject'=>$validatorCallback
];

echo('original rules'.PHP_EOL);
var_dump($rules);

$desiredrules=[
    'info'=>[
        'arrayofobjects'=>[$validatorCallback]
    ],
    'singleobject'=>$validatorCallback
];

echo('desired rules'.PHP_EOL);
var_dump($desiredrules);

echo('array_filter_recursive'.PHP_EOL);
var_dump(array_filter_recursive($rules));

echo('recursive_unset'.PHP_EOL);
recursive_unset($rules);
var_dump($rules);

 

original rules
array(5) {
  ["callbackId"]=>
  string(7) "integer"
  ["info"]=>
  array(2) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
    ["foo1"]=>
    string(4) "bar1"
  }
  ["foo2"]=>
  string(4) "bar2"
  ["bla"]=>
  array(2) {
    ["a"]=>
    string(2) "aa"
    ["b"]=>
    string(2) "bb"
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
desired rules
array(2) {
  ["info"]=>
  array(1) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
array_filter_recursive
array(1) {
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}
recursive_unset
array(2) {
  ["info"]=>
  array(2) {
    ["arrayofobjects"]=>
    array(1) {
      [0]=>
      object(ValidatorCallback)#1 (0) {
      }
    }
    ["foo1"]=>
    string(4) "bar1"
  }
  ["singleobject"]=>
  object(ValidatorCallback)#1 (0) {
  }
}

 

When I remove 1 session item using this it works fine when I select more than 1 item to be removed I get unexpected results, I have checked the outputted html to see what positions get echoed into the remove check box and they are correct, so I guess the problem lies in my remove code

here is the part of the form that sends the remove check box

<?php 
for ($basket_counter=0;$basket_counter<$_SESSION['ses_basket_items'];$basket_counter++) {
   $price=sprintf("%01.2f",$ses_basket_price[$basket_counter]);
    $quantity=$ses_basket_amount[$basket_counter];
$code=$ses_basket_stockcode[$basket_counter];
$itemID=$ses_basket_id[$basket_counter];
    $name=$ses_basket_name[$basket_counter];
$image=$ses_basket_image[$basket_counter];
$size=$ses_basket_size[$basket_counter];
$sizechoice=$ses_basket_sizechoice[$basket_counter];
// create array from sizes and make the option box selections
if ($sizechoice!="" && (!in_array($sizechoice, array('One Size', 'one size', 'free size', 'Free Size', 'Adjustable', 'adjustable')))) { 
// add size trigger
$sizelist="add";
//create the array
$sizepick=explode(",", $sizechoice);
} else { $sizepick=$sizechoice; }
// adjust gst for AU customers
if ($country=='AU') { $price=sprintf("%01.2f",($price*1.1));
$unit=sprintf("%01.2f",($price/$quantity));
 }
else
{ $unit=sprintf("%01.2f",($price/$quantity)); }
?>
<tr>
  <td align='center' class='rescon' style="border-bottom:solid #330000 1px;"><input type="checkbox" name="remove[<?php echo $basket_counter; ?>]" value="<?php echo $basket_counter; ?>" /></td>


and here is the part of the code that processes the removal of the items

$remove = $_POST['remove'];
if (isset($remove) && ($remove!='')) {
        foreach($remove AS $key => $remove_position){
array_splice ($ses_basket_name, $remove_position, 1);
array_splice ($ses_basket_amount, $remove_position, 1);
array_splice ($ses_basket_price, $remove_position, 1);
array_splice ($ses_basket_stockcode, $remove_position, 1);
array_splice ($ses_basket_image, $remove_position, 1);
array_splice ($ses_basket_size, $remove_position, 1);
array_splice ($ses_basket_sizechoice, $remove_position, 1);
array_splice ($ses_basket_id, $remove_position, 1);
$_SESSION['ses_basket_items']--;
}
}


I am using a form with checkboxes named remove[$remove_position] and the positions in the form are correct for each item in the array, but when I select more than 1 item to delete they are not always the correct items only the first 1 selected.
What am I doing wrong here??

Hello I have a while loop which outputs countrys from the database (im making a "filter by" function). For example, the loop outputs:


Denmark
Belgium
Holland
Brazil
Japan
Brazil
Denmark


I want to sort these alphabetically and then remove duplicates... Can somebody explain to me how? I don't know how to get them into an array to do it...

Hello. I am editing a plugin that is grabbing a multidimensional array, then breaking it out into a foreach statement and doing stuff with the resulting data.

What I am trying to do is edit the array before it gets to the foreach statement. I want to look and see if there is a key/value combination that exists, and if it does remove that entire subarray, then reform the array and pass it to a new variable.

The current variable Code: [Select]
$arrSlides returns several subarrays that look like something like this (I remove unimportant variables for the sake of brevity):

Code: [Select]
Array (
[0] => Array (
[slide_active] => 1
)
[1] => Array (
[slide_active] => 0
)
)
What I want to do is look and see if one of these subarrays contains the key slide_active with a value of 0. If it contains a value of zero, I want to dump the whole subarray altogether, then reform the multidimensional array back into the variable Code: [Select]
$arrSlides.

I have tried a few array functions but have not had any luck. Any suggestions?

Thanks in advance,
Jason