PHP - Help With Word Filter

I have a MySql table full of records.

id
owner
car
location

on my page i have these results in a table i want to set a filter up so the table will only show cars from eg location England.
at the minute its just set to show cars that owner has but i want a location filter any help

Hi,   I'm trying to make a program that filters data out of a website. Now I've got a problem. For example, I've this line:

<td class="maintxt" width="200"><a href="profile.php?x=Stranger">Stranger</a></td><td class="maintxt" width="200">Godfather (96.76%)</td><td class="maintxt" width="200"><i><a href="clanprofile.php?x=Ettertjes">Ettertjes</a></i></td>

Form this line I want to set the word "Stranger" in a variable, and do the same for the word "Godfather". What is the best method to do this?   Thanks in advance, iRoot121

Hi.

I was hoping someone could tell me whether this is possible and if so how I could go about doing it preferably with a tutorial as im pretty new to programming.

I have a database that will contain 100's of records. I want users to be able to select filter parameters on this data by both text and checkboxes with it automatically updating the results (hopefully without page reload).

I managed this so far using this Jquery filter script: http://www.picnet.com.au/picnet-table-filter.html. As this will table will have so many rows however I think it would take ages to load so instead I would like to paginate the table but still allow filters applied to affect all records not just the ones displayed on the current page.

Any ideas on how i could do this? Thanks in advance for your help.

Hi, I want to use an external rss in my site but the problem is that i only want to grab feeds that contain certain keywords in the title,   This is what i got so far to display the feed:

<?php

$html = "";
$url = "http://www.feedsite.com/conv-rss.asp";
$xml = simplexml_load_file($url);

for($i = 0; $i < 5; $i++){

	$title = $xml->channel->item[$i]->title;
	$link = $xml->channel->item[$i]->link;
	$description = $xml->channel->item[$i]->description;
	$pubDate = $xml->channel->item[$i]->pubDate;

	$html .= "<a href='$link'><h3>$title</h3></a>";
	$html .= "$description";
	$html .= "<br />$pubDate<hr />";

}
echo $html;
?>

The feed is a classified jobs but i only need the jobs listed for musicians, keywords could be: bassist, singer, drummer, musician, etc..    Thanks

so I'm running a query on a database to get address's

$address = $row['address'];

it returns  "1234 Test St"

I want to be able to sort all the records by  the street name without the numbers

Code: [Select]
SELECT *
FROM table1,table2,table3,table4,table5
WHERE table1_f = table2_id
AND table1_g = table3_id 
AND table4_p = table1_id
AND table5 _m = table4_id
ORDER BY RAND()
LIMIT 1
Right, Now What I want to do, is have a filter form, which posts to the above, and if:

$filter1 = "";

it wont be include in the above code

$filter1 = "word";

then i want to include

AND table3_n = '$filter1';

in the above code

thanks in advance.

Hey guys i am using a global filter on my $_POST

function filter($str){return htmlentities($str, ENT_QUOTES);}
$_POST = array_map('filter', $_POST);

It helps me encode the stuff into the database.
It works great on all my fields exept my arrays ...

Ex: fields like this <input type="text" name="name[]" size="20"> breaks

Any sugestions on gething this global filter working?

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

I have one question about the function rand(),

What if i want to have an number between 0 and 360

Without 90 to 180

so 91,92,93,94.....180 can't be the number

how can i do that?

btw, I know its possible through if,while,for and so on. But is there an other way to do this?

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

Yesterday i read quite alot about htmlentities() htmlspecialchars() mysql_real_escape_string
But today i stumbled upon filter()  (http://www.w3schools.com/php/php_filter.asp). Does anyone know if this is also a good way to sanitize and may even be an alternative for the other functions? OR is it something completly different? I am still a novice with this so please enlighten me : )

TY

I have some text boxes for searching the students in database

also i have a drop down box for selecting student with balance amount to be paid

tell me how to filter or search the list of stuents
Code: [Select]
<select>
            <option value="">All </option>
            <option value="">Unpaid </option>
            <option value="">Paid </option>
        </select>

How do I know if Filter extension is on with my webhost?

Or does it always work with PHP5?

If I cannot use it, can someone recommend a good regex to validate EMAIL addresses??

Thanks,


Debbie

Hello...
I'm working on a webpage (http://66.119.8.164/freedownloads.php) that pulls from an rss feed (http://www.moorelife.org/rss/FreeDownloads.xml).  Please keep in mind that I'm working on content, not design.  It's a very long page, currently.
I want to have links on a sidebar that will allow sorting and filtering, based on <category>.  I got the idea from, get this, Internet Explorer's built-in rss reader.  It's great.

I have a section of the page populating with SimpleXMLElement (that's where the case cover images and titles are).
Above that is an alphabetic listing of all those entries populated by SimpleDOM's sortedXPath.
Between those two are a few category links that use ajax to overwrite the section pulled with SimpleXMLElement.
Now, I don't have any idea if I'm even doing this in an intelligent manner.  As a matter of fact, I'm sure it's very far away from resourceful code.  It's just what I have gotten to work when other options didn't work.

Now, on to the problem.  The code, below, is the php file (http://66.119.8.164/include/getrss.php) that ajax uses to overwrite the original list.
Code: [Select]
<?php
//get the category from URL
$category = $_GET["category"];
$xml = "http://www.moorelife.org/rss/FreeDownloads.xml";
$xmlDoc = new DOMDocument();
$xmlDoc->load($xml);
$item = $xmlDoc->getElementsByTagName('item');
for ($i=0; $i<=5; $i++) {
        $item_title = $item->item($i)->getElementsByTagName('title')->item(0)->childNodes->item(0)->nodeValue;
        $item_category = $item->item($i)->getElementsByTagName('category')->item(0)->childNodes->item(0)->nodeValue;
        echo "<p>".$item_title."</p>";
        echo "<p>".$item_category."</p>";
}
?>
How do I only show the entries where $catagory match <category>?
JJ

Ok, so I want to make a comment spam filter for my site.  I know the basic logic, but have yet to figure out how to write the functions.  I have a database table called comments that has a column called "time", which contains a unix timestamp value of when it was posted.  Basically what I want to do is this:

When a user tries to post a comment, the script determines with a database query if they have posted a comment in the last 120 seconds.

So basically I have to find the current time, and the time it was 120 seconds before the current time.  Then I have to find any comments posted by the user that were made after the 120 second mark.

My database query should then look something like this, right?

Code: [Select]
$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time > '".$120secondsago"'");

Please correct me if my logic is wrong, which it very well may be, but how would I find the unix timestamp code from 120 seconds before the current time?  Note that 120 seconds is just an example and also that I have not worked with dates in mysql very often.

$query = mysql_query("SELECT * FROM comments WHERE author = ".$_SESSION['id']." AND time