PHP - Filtering

Hi guys

I was wondering if anyone could point me in the right direction with this.

I am using JSON to return the contents of a directory and then using a foreach loop to print each one to a new row in a table.

Is there anyway to filter the results? Basically I just want to show the files that end in a .jar extension? Currently all sub directories and files are shown, however all the files I need to pull will be in the main directory.

This is what I am using:

Code: [Select]
<?php
  foreach ($installedplugins1['success'] as $v) 
{
echo "<tr><td>".$v."</td>";
echo "<td><a href='index.php?dp=".$v."'>Disable Plugin</a></td>";

}
?>

Any hints or reading material?

Cheers

I'm pretty sure the problem is starring me in the face, but I can't seem to locate it.


function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);

foreach($bad_words as $value)
{
$string = str_replace($value, '****', $input);
}

return $string;
}


UPDATED CODE

function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);
$string = str_replace($bad_words, '****', $input);

return $string;
}


I've already echoed out $value in the foreeach loop, and it does correctly retrieve the bad words and put them into an array. My only problem is, the returned string is still in strtolower() form, and the words aren't censored. :/

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=334433.0

hi,

i am trying to filter my gps history points.

i would like to ignore points if they are too close to the previous position.

i can do this like so.

$old_lat = $old_long = "0";

                 foreach($history['data'] as $record) {

//calculate distance in meters
$distance = distance($record['latitude'], $record['longitude'], $old_lat, $old_long, "V");

if($distance >= 300) {
echo 'add(jQuery(this), number += 1, "' . date("d-m-Y @ h:i:s",$record['timestamp']) . '", "map_post.php?n=' . $name . 'u=' . $history['user'] . '", "' . $history['user'] . '", "' . $record['latitude'] . '", "' . $record['longitude'] . '");';
                
$old_lat = $record['latitude'];
$old_long = $record['longitude'];
}

the problem with the above is that if i arrive home at 6pm on friday and stay outside my house for 24hours, it will show the latest position as at 6pm on fri.

i would like it to show the 6pm friday position but with a date 'from and to' time like (28/10/11 18:00 - 29/10/11 18:00) rarther than just (28/10/11 18:00) which looks inacurate.

Possible?

hey guys i was generally wondering...is it good practice to add_slashes and use mysqli_real_escape_string when entering data into the database?   then to strip slashes when extracting rows?   is this the right way to go around things...thanks    

Hi, I have an issue, I cant filter my data from DB. Whats wrong in my code?
<?php
/* Include Files *********************/
//include("banners/database.php");
mysql_connect("host", "user", "pwd") or die("Connection Failed");
mysql_select_db("DB")or die("Connection Failed");
?>
<?php
$memberIndustries =['memberIndustries'];
if (isset($_POST["memberIndustries"])) {
$memberIndustries = mysql_real_escape_string ($_POST["memberIndustries"]);
$sql="SELECT * FROM Members WHERE Industries_Industry_ID='$memberIndustries'";
$result = mysql_query($sql) or die (mysql_error());
   
while ($myrowe = mysql_fetch_array($result)) {?>
   <? // if new member, label it 
   //$todays_date = date("Y-m-d");
   //$dateCompare = $myrowe[Creation_Date]+30;
   //$dateCompare = strtotime(date("Y-m-d", strtotime($myrowe[Creation_Date])) . " +30 days");
   //if(strtotime($todays_date)<=$dateCompare){
   ?>
   <table width="100%">
   <tr>
   <td align="right">
            <img src="/members/new.gif">
   </td>
   </tr>
   </table>
   <? //}?>
   
   <? if($myrowe[LOGO_lnk]!='') {?>
   <img src="<? echo $myrowe[LOGO_lnk]; ?>">
   <? } ?>
   <br /> <br /> 
   <font style="font-family: Arial; font-size: 10.5pt; font-weight:bold;color:#C1121F">
   <? echo $myrowe[Company_Title];?>
   </font>
   <? if($myrowe[Person_Name_1]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Name_1];?></font>
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Title_1];?></font>
   <? } 
   if($myrowe[Person_Name_2]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Name_2];?></font>
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Title_2];?></font>
   <? } 
   if($myrowe[Person_Name_2]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Name_3];?></font>
   <font style="font-family: Arial; font-size: 8.5pt; font-weight:bold;color:#000000"><? echo $myrowe[Person_Title_3];?></font>
   <? } 
   if($myrowe[Address_row1]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[Address_row1];?></font>
   <? } 
   if($myrowe[Address_row_2]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[Address_row_2];?></font>
   <? } 
   if($myrowe[Address_row_3]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[Address_row_3];?></font>
   <? } 
   if($myrowe[Phone]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000">Tel:<? echo $myrowe[Phone];?></font>
   <? } 
   if($myrowe[Fax]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000">Fax:<? echo $myrowe[Fax];?></font>
   <? } 
   if($myrowe[email]!='') {?>
   <br />
   <a href="mailto:<? echo $myrowe[email];?>">
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[email];?></font>
   </a>
   <? } 
   if($myrowe[web]!='') {?>
   <br />
   <a href="<? echo $myrowe[web];?>"target="_blank">
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[web];?></font>
   </a>
   <? } 
   if($myrowe[Industries_Industry_ID]!=0) {
      $queryInd = "SELECT Industry_Title FROM Industries WHERE Industry_ID=$myrowe[Industries_Industry_ID]";
      $resultInd = mysql_query($queryInd) or die (mysql_error());
      $myroweIND = mysql_fetch_array($resultInd)
   ?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myroweIND[Industry_Title];?></font>
   <? } 
   if($myrowe[Description]!='') {?>
   <br />
   <font style="font-family: Arial; font-size: 8.5pt; color:#000000"><? echo $myrowe[Description];?></font><p></p>
   <? } ?>
   <br /><br />
<? } 
<? }} ?>

Hello, Is it possible to allow '@' and '.' while maintaining the rest of this regex?

$email= 'adsfsa@asdf.edu';
$email= preg_replace("/[^A-Za-z0-9]/", " ", $email);
echo $email;

Hi there

I have the following array .

Code: [Select]
$products = array(   array( Code => "CF1",
                         Items => "Sand Tray",
                         Cat  => 'Tray',
                         ),
                  array( Code => "CF2",
                         Items => "Mobile Computer Table",
                         Cat  => 'Table',
                         ),
                  array( Code => "CF3",
                         Items => "General Service Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF4",
                         Items => "TV Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF5",
                         Items => "Overhead Projector Trolley",
                         Cat  => 'Trolley',
                         ),
                    array( Code => "CF6",
                         Items => "Book Trolley",
                         Cat  => 'Tolley',
                         ),
                         array( Code => "CF7",
                         Items => "Stacking Chairs",
                         Cat  => 'Chairs',
                         ),     
  ); 
What I want to do is select each by 'Cat'. For example I simply want to display all the trolleys. 

I was wondering how I do this? What functions would I use in PHP? 

Thanks a million 

I have a SQL statement which is difficult to use PDO on, it might not even be possible to do. So I'm filtering it like this:

$search = $_GET['search'];
$search = preg_replace("/[^A-Za-z0-9]/", " ", $search);
$search = $mysqli->real_escape_string($search);

Will this result in an acceptable level of security?
Edited by anderson_catchme, 16 September 2014 - 12:28 PM.

Im struggling with how to filter items that have multiple categorises say if i wanted to search for a shoe that is good for walking and hiking in my database?

Shoe_id
Shoe name
color_id type_id

colors color_id color   type type_id type

My problem is what do i do in a situations like this? say a shoe is good for walking and running? aka type 1 and 2 

shoe id 1 shoe name nike color id 1 type id 1 and 2   

I'm trying to firstly generate all possible 'x' number combinations from an array of 'y' numbers. i.e. combinations of 3 numbers from array(1,2,3,4,5). so... 1,2,3 - 1,2,4 - 1,2,5, 1,3,4 etc
I then want to be able to filter out duplicate permutations. i.e. 1,2,3 is the same as 1,3,2.

I have googled vigorously but not been able to determine a suitable approach.

Any suggestions would be appreciated.

Thanks.

Hi.  I made a website to keep track of where I am in various manga.  I noticed that sometimes the title I grab looks OK when rendered on the page but in the database it's weird looking

I did a for ($x=0; $x<strlen($title); $x++) loop and dumped $x, char at $ pos and ord of char:

0 = T = 84
1 = h = 104
2 = e = 101
3 =   = 32
4 = D = 68
5 = e = 101
6 = m = 109
7 = o = 111
8 = n = 110
9 =   = 32
10 = K = 75
11 = i = 105
12 = n = 110
13 = g = 103
14 = � = 226
15 = � = 128
16 = � = 153
17 = s = 115
18 =   = 32
19 = D = 68
20 = a = 97

Is there some nifty built in function for converting that weird stuff to a regular apostrophe (and convert any other weird stuff)?  I mean, I can write a filter to look for 226/128/153 and replace with ' but I'm sure there must be a proper way to handle that stuff.  Thanks!

Hi Everybody,

I think it's fairly simple, but i am a noob in PHP so need help from advanced coders.

I have MySQL table which is being filled up everyday, there are 7 fields in the table (submitter, choosebank, choosetype, ampaid, amret, date, descript).
What I need is to create a search.php which will be looking up data in all fields and printing it on the screen and the search should be filtered. What I mean is when a user wants to search for data let's say using submitter  who's name is Mitchel then it should search for all data and print all rows containing submitter (Mitchel) and the rest six fields. And if user searches let's say using submitter (Mitchel) and a certain date (let's say DEC-25-2011) then it should find all data containing Mitchel and DEC-25-2011 in the same row and print all rows which contain the same search parameter and the rest of the fields.

Any help would be greatly appreciated!

Here is the code I have so far, but it doesn't work.

<code>

<?php

include ("blocks/db.php");

$sql = mysql_query("SELECT * FROM banks WHERE submitter LIKE '$sub' or choosebank LIKE '$bank' or choosetype LIKE '$type' or $money_column LIKE '$money_column' or $money_value LIKE '$money_amount' or inputdate LIKE '$inputdate' or descript LIKE '$descript'") or die(mysql_error());

echo "<table width='1000' border='1' cellspacing='0' cellpadding='1'>";
 echo "<tr>";
 echo "<td width='100'>Submitter</td>";
 echo "<td width='90'>Bank</td>";
 echo "<td width='110'>Type of Payment</td>";
 echo "<td width='110'>Amount Paid</td>";
 echo "<td width='110'>Amount Returned</td>";
 echo "<td width='100'>Date</td>";
 echo "<td width='366'>Description</td>";
 echo "</tr>";
echo "</table>";

while ($row = mysql_fetch_array($sql)){

echo "<table width='1000' border='1' cellspacing='0' cellpadding='1'>";
 echo "<tr>";
 echo "<td width='100'>$row[submitter]</td>";
 echo "<td width='90'>$row[choosebank]</td>";
 echo "<td width='110'>$row[choosetype]</td>";
 echo "<td width='110'>$row[ampaid]</td>";
 echo "<td width='110'>$row[amret]</td>";
 echo "<td width='100'>$row[date]</td>";
 echo "<td width='366'>$row[descript]</td>";
 echo "</tr>";
echo "</table>";

}

?>

</code>

Perhaps a slight trouble, but I can not solve it:   Match only path like: Trainings/1/test.pdf   but dont match one more directory like this: Trainings/1/4/other.pdf   Any suggestions?

Hi all

I am building a page to filter SQL values but I'm not sure how to write the code for the query.

My URL looks like this:

stone.php?category=Wood&type=4&colour=1&Submit=Submit

Firstly, can I remove the submit from the URL?

Then I have my code to create the query:

$fetchData=mysql_query("SELECT * FROM `products` WHERE category = "'.$_GET'category.'"");

Can I combine this for the type and colour?

Many thanks
Pete