PHP - Search An Array With Regex

I have an array I would like to search that is being built from a data base as follows

$result = mysql_query("SELECT id_one, id_two FROM accounts LIMIT 60");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

    printf("ID_ONE: %s   ID_TWO: %s", $row[0], $row[1]);  
echo "<br>";
}



What I would like to do is after the array is created echo out a certain row from that array.
Soi if the array looks like this

key   id_one   id_two
1         458       444
2          468       455
3         467        466

I can search the array for 468 and it would return 455

Thanks  I will be posting back if I find any new information my self.

Hi guys

I have an php array like below


// array
$array_odds = array(
"1.10" => "1/10",
"1.11" => "1/9",
"1.12" => "1/8",
"1.14" => "1/7"
);

// using the array
echo $array_odds ['1.11']; // will echo in 1/9


As we can see in the array there is no 1.13, Is there a way I can pass it 1.13, and it gets me the closest fraction

so if I passed it 1.13 it would return the fraction 1 lower which is 1.12 > 1/8


Thanks guys

i have this code

<?php
$rulepages = array();
$rulepages[] = array("name" => "1111213", "page" => "fasdd21.php", "id" => "1");
$rulepages[] = array("name" => "41231245152", "page" => "fasd.php", "id" => "2");

?>
<table width="100%">
<tr>
<td width="15%">
<?php
sort($rulepages);
foreach($rulepages AS $rulepage){
echo "<a href=\"?id=".$rulepage["id"]."\">".$rulepage["name"]."</a>";
echo "<br />";
}
?>
</td>
<td  width="80%">
<?php
$id = $_GET["id"];
// ??
?>
</td>
</tr>
</table>

what do i do to search the array where the id equals the get ?

thanks

Whats the most efficient way of searching within a multi dimensional array?

My Array =

Array ( => Array ( => Item 1 [title] => Item 1 [1] => 2012-03-21 [eventDate] => 2012-03-21 [2] => 21 [eventDay] => 21 ) [1] => Array ( => Item 2 [title] => Item 2 [1] => 2012-03-21 [eventDate] => 2012-03-21 [2] => 21 [eventDay] => 21 ) )

String to find = '21'

If (MY ARRAY contains STRING TO FIND) {}

Clearly in this case there are several '21' (s) so if I only wanted to search the [eventDay] keys...would there be a fast effective and efficient manner?


Thoughts and help gratefully received.

Will

Hello,

I have an array, and I want to search the array for a particular 'word' and return how many times that 'word' is in the array. I tried using the search_array, but that just seems to find the first 'word' and return it. What I want it this:

Code: [Select]
$array = array(0-blue, 1-yellow, 2-red, 3-blue, 4-blue, 5-blue, 6-yellow);
Lets say I want to see how many times the word 'blue' is in the array: $counter = 4;
How would I achieve this?

Thanks

Hello
I am facing a problem which i can not handle. I appreciate for any help.

My Database is:
Code: [Select]
CREATE TABLE IF NOT EXISTS `shops` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `options` text,
  `user_name` varchar(250) NOT NULL ,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='user data stored' AUTO_INCREMENT=1 ;
And some sample data as below:
Code: [Select]
INSERT INTO `users` (`id`, `options`, `user_name`) VALUES
(1, 'apple-orange-grape-bmw-toyota-fig-', 'user1'),
(4, 'apple-tomato-pc-notebook-yellow-', 'user2'),
(5, 'blue-green-orange-cdrom-', 'user3'),
(6, 'orange-yellow-blue-pink-bread-', 'user4');
How can i display how many apples or green or any item selected by user?
So far i tried in_array, array_count_values but seems no one is working.

Regards

In the following code: echo $text[2] returns the word at that index but echo $key returns a blank.

Can someone explain why is array-search not working in this  indexed array?

It does work when I test it with a key => value type array.

<?php $myfile = fopen("test.txt", "r") or die("Unable to open file!");

while(!feof($myfile)) {

  $text[] = fgets($myfile); }

fclose($myfile);

$word = $_POST['word'];

$key = array_search($word, $text);

echo $key ?>

I'm just wondering if there is a function like array_key_exists that could take an array as the search parameter and check that all keys exist. It would be easy enough to code if I need to but I was hoping it would already exist. All wanted to use it for is a really quick form check to make sure that all the expected values were POSTed before I actually start filtering and validating individual fields.

Thanks in advance for any recommendations

Hi!

I need a little bit coding help here.
I have a table:
Numbers, Active

Under numbers can be 10000, 10001, 10002, 10003, 10004, 10005 and active can be 1 or 0, depends on is this row active or not.
Now, i need to check, is there any numbers lost, i mean, (for example) in table i have numbers 10002, 10000 and 10005 Can somebody make script, what finds those lost numbers, in this case those a 10001, 10003 and 10004.

All the best:
Mart

I have successfully used the Yahoo local search API and received results in XML format. I am trying to use PHPs Simple XML to parse the data into an array so I can loop through and print specific elements.

I cannot get to specific elements and I have read several threads online.

Below is some code and below that is the XML. I am trying to get to the elements like title, address, etc.

Code: [Select]
$url = 'http://local.yahooapis.com/LocalSearchService/V3/localSearch?appid=<my yahoo api key>&category=Casinos&query=blackjack&zip=95035&radius=20&results=10';

$xml = file_get_contents($url);

$phpobject = simplexml_load_string($xml);

foreach($phpobject->attributes() as $name=>$attr) {
   $res[$name]=$attr;   
}

Code: [Select]
<ResultSet xsi:schemaLocation="urn:yahoo:lcl http://local.yahooapis.com/LocalSearchService/V3/LocalSearchResponse.xsd" totalResultsAvailable="48" totalResultsReturned="10" firstResultPosition="1">
−
<ResultSetMapUrl>
http://maps.yahoo.com/broadband/?q1=Milpitas%2C+CA+95035&tt=poker&tp=1
</ResultSetMapUrl>
−
<Result id="34179399">
<Title>Bay Area Poker Chip</Title>
<Address>1274 Piper Dr</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.412359</Latitude>
<Longitude>-121.891794</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>1</TotalRatings>
<TotalReviews>1</TotalReviews>
<LastReviewDate>1198993183</LastReviewDate>
−
<LastReviewIntro>
I bought 100% real clay chips from here and obsolutely love it. I had a poker game that night and needed chips and a table. They had everything in stock and saved me time to look around. Great products and great service and I highly recommend this place to anybody
</LastReviewIntro>
</Rating>
<Distance>1.33</Distance>
−
<Url>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-34179399-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1274+Piper+Dr+Milpitas+CA&gid1=34179399
</MapUrl>
<BusinessUrl>http://bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928631">Graphic Design</Category>
</Categories>
</Result>
−
<Result id="44540748">
<Title>Bay Area Poker Chip</Title>
<Address>519 Montague Expy</Address>
<City>Milpitas</City>
<State>CA</State>
<Phone>(408) 263-8611</Phone>
<Latitude>37.409925</Latitude>
<Longitude>-121.89489</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>1.48</Distance>
−
<Url>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-44540748-bay-area-poker-chip-milpitas
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=519+Montague+Expy+Milpitas+CA&gid1=44540748
</MapUrl>
<BusinessUrl>http://www.bayareapokerchip.com/</BusinessUrl>
<BusinessClickUrl>http://www.bayareapokerchip.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925976">Sporting Goods</Category>
<Category id="96935378">Games</Category>
</Categories>
</Result>
−
<Result id="67710717">
<Title>Poker Da Vinci</Title>
<Address>51 E Campbell Ave</Address>
<City>Campbell</City>
<State>CA</State>
<Phone>(408) 866-4446</Phone>
<Latitude>37.287157</Latitude>
<Longitude>-121.94942</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>10.40</Distance>
−
<Url>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-67710717-poker-da-vinci-campbell
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=51+E+Campbell+Ave+Campbell+CA&gid1=67710717
</MapUrl>
<Categories/>
</Result>
−
<Result id="21599986">
<Title>Bay 101 Banquet Facilities</Title>
<Address>1801 Bering Dr</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 451-8888</Phone>
<Latitude>37.373044</Latitude>
<Longitude>-121.912125</Longitude>
−
<Rating>
<AverageRating>4</AverageRating>
<TotalRatings>2</TotalRatings>
<TotalReviews>2</TotalReviews>
<LastReviewDate>1200040214</LastReviewDate>
−
<LastReviewIntro>
If youre looking for high limit action Bay 101 is the place to go in San Jose. You can regularly find limit games up to $80-$160 in their spacious high ceiling room.
</LastReviewIntro>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21599986-bay-101-banquet-facilities-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1801+Bering+Dr+San+Jose+CA&gid1=21599986
</MapUrl>
<BusinessUrl>http://bay101.com/</BusinessUrl>
<BusinessClickUrl>http://bay101.com/</BusinessClickUrl>
−
<Categories>
<Category id="96929273">Casinos</Category>
</Categories>
</Result>
−
<Result id="21401964">
<Title>Thwart Poker Incorporated</Title>
<Address>525 Lincoln Ave</Address>
<City>Palo Alto</City>
<State>CA</State>
<Phone>(650) 329-9627</Phone>
<Latitude>37.444049</Latitude>
<Longitude>-122.151513</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>14.09</Distance>
−
<Url>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21401964-thwart-poker-incorporated-palo-alto
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=525+Lincoln+Ave+Palo+Alto+CA&gid1=21401964
</MapUrl>
−
<Categories>
<Category id="96926908">Internet Access Providers</Category>
<Category id="96932773">Computer Business Solutions</Category>
</Categories>
</Result>
−
<Result id="21574436">
<Title>Blinky's Can't Say Lounge</Title>
<Address>1031 Monroe St</Address>
<City>Santa Clara</City>
<State>CA</State>
<Phone>(408) 985-7201</Phone>
<Latitude>37.348893</Latitude>
<Longitude>-121.94816</Longitude>
−
<Rating>
<AverageRating>5</AverageRating>
<TotalRatings>3</TotalRatings>
<TotalReviews>3</TotalReviews>
<LastReviewDate>1228667811</LastReviewDate>
−
<LastReviewIntro>
Good drinks good prices good people. Who could ask for more.....
</LastReviewIntro>
</Rating>
<Distance>6.39</Distance>
−
<Url>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21574436-blinky-s-can-t-say-lounge-santa-clara
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1031+Monroe+St+Santa+Clara+CA&gid1=21574436
</MapUrl>
−
<Categories>
<Category id="96926057">All Bars, Pubs, & Clubs</Category>
<Category id="96926063">Bars & Pubs</Category>
</Categories>
</Result>
−
<Result id="21619987">
<Title>Barbara of Pauline's Cake Decorating Supplies</Title>
<Address>1093 Malone Rd</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 978-9740</Phone>
<Latitude>37.293702</Latitude>
<Longitude>-121.889876</Longitude>
−
<Rating>
<AverageRating>4.5</AverageRating>
<TotalRatings>8</TotalRatings>
<TotalReviews>8</TotalReviews>
<LastReviewDate>1268173462</LastReviewDate>
−
<LastReviewIntro>
I love this store. No matter what it is i am looking for weather it is some thing i remember from my child hood or some thing i saw in a magazine and i need it i know i can find it there. Yes they are a little rough around the edges but that is only because they are trying to get it across to you what will work and what will not. This is an old school store with people who know their stuff and are only trying to help you get the best end result possible. I am 46 years old and i took my class from Barbara when i first came out of high school and believe me she will not try to up sale you or tell you some thing is going to work if it will not. Go in expecting to be overwhelmed by stock and know you are going to get the best prices in town. Take the time to get to know the employees and the store and you will always go back to Paulines. I travel all the way from Livermore to get stuff i know i can only find there. Thanks for all your many years of being in business
</LastReviewIntro>
</Rating>
<Distance>9.52</Distance>
−
<Url>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21619987-barbara-of-pauline-s-cake-decorating-supplies-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1093+Malone+Rd+San+Jose+CA&gid1=21619987
</MapUrl>
−
<Categories>
<Category id="96928859">Wedding Supplies & Services</Category>
</Categories>
</Result>
−
<Result id="21602089">
<Title>Carey David Incorporated</Title>
<Address>1624 Remuda Ln</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 453-7843</Phone>
<Latitude>37.372385</Latitude>
<Longitude>-121.908305</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.13</Distance>
−
<Url>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-21602089-carey-david-incorporated-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=1624+Remuda+Ln+San+Jose+CA&gid1=21602089
</MapUrl>
<BusinessUrl>http://dc-enterprises.com/</BusinessUrl>
<BusinessClickUrl>http://dc-enterprises.com/</BusinessClickUrl>
−
<Categories>
<Category id="96928508">Clothing Wholesalers</Category>
<Category id="96928509">Clothing Manufacturers</Category>
<Category id="96931030">Apparel Manufacturing</Category>
</Categories>
</Result>
−
<Result id="30246475">
<Title>Royal Casino Parties</Title>
<Address>943 Berryessa Rd, #6</Address>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 213-0904</Phone>
<Latitude>37.363563</Latitude>
<Longitude>-121.886341</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>4.71</Distance>
−
<Url>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-30246475-royal-casino-parties-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=943+Berryessa+Rd%2C+%236+San+Jose+CA&gid1=30246475
</MapUrl>
<BusinessUrl>http://www.royalcasinoparties.com/</BusinessUrl>
<BusinessClickUrl>http://www.royalcasinoparties.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96930362">Gambling</Category>
</Categories>
</Result>
−
<Result id="25247620">
<Title>Bay Casino Gaming, Casino Party Rentals</Title>
<Address/>
<City>San Jose</City>
<State>CA</State>
<Phone>(408) 747-1977</Phone>
<Latitude>37.338475</Latitude>
<Longitude>-121.885794</Longitude>
−
<Rating>
<AverageRating>NaN</AverageRating>
<TotalRatings>0</TotalRatings>
<TotalReviews>0</TotalReviews>
<LastReviewDate/>
<LastReviewIntro/>
</Rating>
<Distance>6.44</Distance>
−
<Url>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</Url>
−
<ClickUrl>
http://local.yahoo.com/info-25247620-bay-casino-gaming-casino-party-rentals-san-jose
</ClickUrl>
−
<MapUrl>
http://maps.yahoo.com/maps_result?q1=+San+Jose+CA&gid1=25247620
</MapUrl>
<BusinessUrl>http://www.baycasinogaming.com/</BusinessUrl>
<BusinessClickUrl>http://www.baycasinogaming.com/</BusinessClickUrl>
−
<Categories>
<Category id="96925812">Entertainment Production</Category>
<Category id="96925814">Party Rentals</Category>
</Categories>
</Result>
</ResultSet>

I'm somewhat new to OOP PHP, and I'm still learning, but basically I want searchcolumns() to set which MySQL columns that it'll search inside but I don't know where to go from what I've already coded.

Here's the basic input to be sent to my classes file:

$getusers = new database;
$getusers->search($_GET['search']);
$getusers->searchcolumns('username','account','email');

And to put it simple, I need my $where variable to output this:

$where .= "(username LIKE '%$search%' OR account LIKE '%$search%' OR email LIKE '%$search%')";

Except replacing the already set columns with the ones that I assigned in the searchcolumns() array, and then adding an OR string if there's more than 1 column set.

Here's the code as I have it at the moment, for obvious reasons, it doesn't work how I want it to:

// Search columns
function searchcolumns($columns) {

$this->column = explode(", ", $columns);
}

// Search results
function search($search) {

$search = ($_POST['search']);

if (isset($_GET['search']) && strlen($_POST['search']) > 1) {

$searchresult = explode(" ", $search);

$where = "WHERE";

foreach ($searchresult as $key => $search) { 

$where .= "($this->column LIKE '%$search%')";
if ($key != (sizeof($searchresult) - 1))   

$where .= " AND ";
} 

$this->where = $where;
}

}

Sorry if this has been somewhat confusing to explain, but hopefully someone understands what I'm trying to achieve.

Hi, I have a multidimensional array where each array has a parent id node to create a hierarchical tree.


$hierarchy[] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1');
$hierarchy[] = array('id' => 2, 'parent_id' => 0, 'name' = 'root2');
$hierarchy[] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');
$hierarchy[] = array('id' => 4, 'parent_id' => 1, 'name' = 'root1-2');
$hierarchy[] = array('id' => 5, 'parent_id' => 3, 'name' = 'root1-1-1');
$hierarchy[] = array('id' => 6, 'parent_id' => 2, 'name' = 'root2-1');


I'm trying to come up with a recursive key/value search routine that will return all ancestor arrays of the found item without knowing the depth of the tree.  All nodes with 0 for the parent_id are root level nodes.

Basically I want to search for something like "where key = name and value = xxx" and have it return all ancestors of that node.

So if I wanted to search for "key = name and value = root1-1", it should return and array like:

array[0] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1'); //parent node first
array[1] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');  //first child after parent

if I was to search for "key = name and value = root1-1-1", it should return:

array[0] = array('id' => 1, 'parent_id' => 0, 'name' = 'root1'); //parent node first
array[1] = array('id' => 3, 'parent_id' => 1, 'name' = 'root1-1');  //first child after parent
array[2] = array('id' => 5, 'parent_id' => 3, 'name' = 'root1-1-1'); //first grandchild

So the main problem comes in the iteration and keeping track of parents.  If I just want the array with the answer I can get that node, but I can't get it with all of the ancestors attached.  How would you go about this?  Any good ideas out there?

Thanks!

 The result pages is supposed to have  pagination like google  help me please