PHP - Search For A String In A Sql Table With Php

Hi, I am trying to search a string for a string of characters in this order ../ and carry out relevant if statements but it returns the same result every time. On echoing my $pos, $pos2, $pos3 and $pos4 variables the first two come back 0 and they are the strings that do contain ../ but the if statements perform the same? I don't understand, any ideas? Thanks...

Code: [Select]
<?php $logo = $info ['logo'];
$pos = strpos($logo, "../");//check if image contains ../
if ($pos == 0) {}
else {
$logo = substr($logo, 3);}

$image1 = $info ['image1'];
$pos1 = strpos($image1, "../");//check if image contains ../
if ($pos1 == 0) {}
else {
$image1 = substr($image1, 3);}

$image2 = $info ['image2'];
$pos2 = strpos($image2, "../");//check if image contains ../
if ($pos2 == 0) {}
else {
$image2 = substr($image2, 3);}

$image3 = $info ['image3'];
$pos3 = strpos($image3, "../"); //check if image contains ../
if ($pos3 == 0) {}
else {
$image3 = substr($image3, 3);}

?>

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

Hello,

Okay for some reason i cannot do this, when i open a file in php and search for string, it doesn't seem to work, some codes i tried:

Code: [Select]
$filename = 'example.txt';
$searchfor = 'hello';
$fh = fopen($filename, 'r');
$olddata = fread($fh, filesize($filename));
if(strpos($olddata, $searchfor)) {
           //fount it
}
else {
          //can't find it
}
fclose($fh);
(above it just sample text, i was hoping you could give me sample code that will work)

I tried many others like strstr, stristr, preg_replace etc etc, doesn't seem to find it.. this is my text file:

Code: [Select]
sdfsdfsdfsdfsdf[b]hello[/b]sdvsdf
dfadfsdfsdfsddfsdf
sdfsdfsdfs
sdffffffffffffffffffffdv
vsvdsdsf

I don't want to find it by line, i want to simply open the text file and find the string..

thanks..

Does/can php reconize quotations beyond the simple example I have below:



$quote = "\"";

if(strstr($test, $quote)){
 echo "quote found";
}



I'd like to detect any instance of a quote. Should I be including html such as &quot; and/or other html quote symbols? Or does the simple example I have above suffice?

I am new to PHP and I am trying to write code which will perform a string search function based off of user specified directory + log file (ex: /home/log.txt) , and user specified string(s) to search for, the user can enter more than one string separated by '|'.

Is egrep the correct way to go in terms of taking input separated by '|'

Hello,

I am EXTREMELY new to PHP, and coding in general.  I have attempted to search for an answer to this already, but I'm not sure I'm using terminology that will lead me to an solution, as I haven't come up with much.  I'm hoping that someone can provide some assistance, or at least point me in the right direction for some reading. 

What I am trying to do it search a string for a match to any of 12 words.  I'm wondering if there is a smarter way to do this than coding 12 different lines, each one looking for a specific word.

If you can point me in the right direction, then thank you very much =)

Currently I am using a script that displays the entire directory.  However I am trying to use preg_match to try and figure out how to just link to one file from the directory via a search string from a form.   I am probably not even close so please bare with me

<?php

if (isset($_POST['filelook'])) {
$filez = $_POST['filelook'];
}
   /*
   edit $path to the directory you want to use
   edit $file_types to change the file types to show
   */
   function file_type($file)
   {
       $searchString = $filez;	
       $path_chunks = explode("/", $file);
       $thefile = $path_chunks[count($path_chunks) - 1];
       $dotpos = strrpos($thefile, ".");
       return strtolower(substr($thefile, $dotpos + 1));
   }
   $file_count = 0;
   $path = "./WinFiles/files";
   $file_types = array('png', 'jpg');
   $p = opendir($path);
       while (false !== ($filelook = readdir($p))) 
	   {
           $files[] = $filelook;
       }
   sort($files);
   echo "<b> Your file results:</b><br> ";
      
		   
           if (file_exists($filez) && is_readable($filez) && preg_match($filez)) {
		   
		echo '<a href="download.php?f='.$filez.'">'.$filez.'</a> <br/>';
			  
			   
			   //find filename like name searched for...

         
   if($file_count == 0)
   {
       echo "<b>No file match your file types</b>";
   }

     
    	   
           
			  
			   
			   
		   
		   }
 
?>

Hi there

 

I have started using php excell and getting most of it right. 

But i am struggling to search active sheet and return what cell the string is in. below is my code.

 

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
set_time_limit(0);



$directory = "/var/www/html/csvex/xls/";
$formatdirectory = "/var/www/html/csvex/toformat/";
$finishedformatdirectory = "/var/www/html/csvex/formatted/";
$savanadirectory = "/var/www/html/iretire/files/upload/1/";
$main = "/var/www/html/csvex/";


$files = scandir($directory, SCANDIR_SORT_DESCENDING);

$newest_file = $files[0];
echo $newest_file;
echo "<br>";
$oldfile = $directory.$newest_file;
$newfile = $formatdirectory.$newest_file;
$changedfile = $finishedformatdirectory.$newest_file;
$crmfile = $savanadirectory.$newest_file;
echo $oldfile;
echo "<br>";
echo $newfile;

echo "<br>";
if( !rename($oldfile, $newfile) ) {  
    echo "File can't be moved!";  
}  
else {  
    echo "File has been moved!";  
} 
//format the file


date_default_timezone_set('Europe/London');
set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');

include 'PHPExcel/IOFactory.php';

$fileType = 'Excel5';
$fileName = $newfile;

// Read the file
$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);
//change font
$objPHPExcel->getActiveSheet()->getStyle('a1:a6')->applyFromArray(
$styleArray = array(
'font' => array(
'bold' => true
)
)
);
$objPHPExcel->getActiveSheet()->getStyle('a6:aa6')->applyFromArray(
$styleArray = array(
'font' => array(
'bold' => true
)
)
);
$objPHPExcel->getActiveSheet()->getStyle('n16:aa16')->applyFromArray(
$styleArray = array(
'font' => array(
'bold' => true
)
)
);
//get INACTIVE MEMBERS
$foundInCells = array();
$searchValue = 'INACTIVE MEMBERS';
foreach ($objPHPExcel->getActiveSheet() as $worksheet) {
    $ws = $worksheet->getTitle();
    foreach ($worksheet->getRowIterator() as $row) {
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(true);
        foreach ($cellIterator as $cell) {
            if ($cell->getValue() == $searchValue) {
                $foundInCells[] = $ws . '!' . $cell->getCoordinate();
            }
        }
    }
}
echo "<br>";
echo "<br>";
echo "this is where - - ";
var_dump($foundInCells);
echo "<br>";
echo "<br>";
//
$objPHPExcel->getActiveSheet()->getStyle('a20')->applyFromArray(
$styleArray = array(
'font' => array(
'bold' => true
)
)
);

its located at //Get inactive members.

another one i am struggling with is to see if file exists if not then do nothing if it does run the code.

Hi all, first time here as I am a bit stuck. I am by no means a programmer and I was hoping that someone out there may have a simple solution to my problem?... So here goes"

I have a voucher/offers site up-and-running. The site content is generated from an external feed. I want to create other sites and I want to track what sales/clicks have come from where.

An example of the feed: (http://www.awin1.com/awclick.php?mid=251&id=28971&clickref=[URL_REFERENCE]&p=http://www.247electrical.co.uk)

As you will see, I have [URL_REFERENCE] in each link. I want to automatically change that part of the string in the database. Does anyone have any thoughts?

I have some data in a table and some of it is Artist names stored as "Last, First"
I need to be able to have the script search weather or not someone types "last, first" or "first last".
Any ideas?

Here's my code:

<html>
<head>
<title>search script</title>
</head>
<body>

<form name="form" action="search.php" method="get">
  <input type="text" name="q" />
  <input type="submit" name="Submit" value="Search" />
</form>

<?php

  // Get the search variable from URL

  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=100; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("localhost","username","password"); //(host, username, password)

//specify database
mysql_select_db("mydb") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "select * from songs where Title like \"%$trimmed%\" or Artist like \"%$trimmed%\"  
  order by Title"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
echo "Results";
$count = 1 + $s ;

// now you can display the results returned
echo "<table border=1>";
  while ($row= mysql_fetch_array($result)) {
  $title = $row["Title"];
  $artist = $row["Artist"];
  $number = $row["Number"];

  echo "<tr><td>$count.)</td><td>$title</td><td>$artist</td><td>$number</td></tr>" ;
  $count++ ;
  }

  echo "</table>";
$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 20 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
  
?>

</body>
</html>

Hello

I have three tables

User

diysmps

usergroup


usergroupid is common in the three tables.

diysmps is joined on usergroup, so running this sql



SELECT
diysmps.name,
diysmps.email,
diysmps.sumbit,
diysmps.message,
diysmps.ID,
usergroup.title
FROM diysmps
INNER JOIN usergroup ON diysmps.usergroupid = usergroup.usergroupid
ORDER BY diysmps.ID DESC

see results i get in picture attached. the result (PENDIN REGISTRATION) is what i need to be updated WHEN the user register to the forums.

when the user register to the forums, an account with his EMAIL will be created into the (USER) table.

So, I need to look out for the email FROM (diysmps TABLE) into the user table _search user table for email from diysmps table_ and if found to update the USERGROUPID in (diysmps TABLE) withe the USERGROUPID from (USER) table (related to the email searched)

so, when user registers, status from PENDING REGISTRATION to REGISTERED will be shown

I know it looks complex for me, but thats how i can describe

Thanks all

I have a string (Product1-Product2-Product3#2-4-1) where Product1-Product2-Product3 are products and 2-4-1 are quantities. I am struggling to make a table out of it where products and quantities are shown in rows.

here is what i tried.

Code: [Select]
list($products, $quantities) = explode("#", $specs); //to separate Quantities from products

<?php foreach(preg_split("/-/", $products) as $product_list) { ?>
 
  <tr>
    <td> <?php echo $product_list; ?></td><? } ?> <?php foreach(preg_split("/-/", $quantities) as $qtylist) { ?>   <td></td>
    <td><?php echo $qtylist; ?></td> <?php } ?>
  </tr>

  <?php //} ?>
</table>
 
I know something is wrong with this and its giving me unexpected reasult

Please help me create a table out of the above string.

Many Thanks
-Max

Hi all, a have a small problem with my search script. At the moment I am searching a field in my tabel called searchtags, now if I enter a one word search term of a string of characters it will return the results but if they are not in the same order it won't.

Example:

searchtags contains - Ford Mondeo 1999 2.0L petrol car

If I search "Ford Mondeo" the query returns results, whereas if I search "Mondeo Ford" the query returns no results?

I assume I have to expand the search in some way but I don;t know how, any ideas? Thanks in advance


Code: [Select]
<?php

  // Get the search variable from URL
  $var = @$_GET['q'] ;
  $field = @$_GET['field'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

if ($field == "") { //if search from homepage start here

$query = "select * from fleet where searchtags like \"%$trimmed%\"  
  order by fleetref"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 $limit=10000; 


if ($numrows == 0)
  {
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; motorhomes to hire returned zero results</p>";

  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<h1>You searched for - " . $var . "cars</h1>";

// now you can display the results returned
  while ($row= mysql_fetch_array($result))
  { 
  $fleetref = $row['fleetref'];
  $fleetmake = $row['fleetmake'];
  $fleetmodel = $row['fleetmodel'];
  $fleetyear = $row['fleetyear'];
  $fleetchassis = $row['fleetchassis'];
  $fleetberth = $row['fleetberth'];
  $fleetlayout = $row['fleetlayout'];
  $fleetlength = $row['fleetlength'];
  $fleettype = $row['fleettype'];
  $fleetof = $row['fleetof'];
  $fleetimage1 = $row['fleetimage1'];
  $fleetimage2 = $row['fleetimage2'];
  $fleetimage3 = $row['fleetimage3'];
  $fleetimage4 = $row['fleetimage4'];
  $fleetadded = $row['fleetadded'];
  $fleetengine = $row['fleetengine'];
  $pricelow = $row['pricelow'];
  $pricemid = $row['pricemid'];
  $pricehigh = $row['pricehigh'];
  $fleetviews = $row['fleetviews'];
  
  $query = mysql_query("SELECT * FROM mhhire WHERE `ref` = '$fleetof'");
  
  if(mysql_num_rows($query)==0){

echo "<p>This company does not exsist</p>";

  }else{
  while($details = mysql_fetch_array($query)){
  $company = $details ['company'];
  $location = $details ['location'];
  
echo "<div class=\"fleet_vehicle\">";

if ($fleetimage1 == "fleet/") {
echo "<img src=\"images/no_image.jpg\" alt=\"$fleetmake $fleetmodel\" width=\"100\" height=\"75\" class=\"fleet_thumb\">";
}
else {
echo "<img src=\"$fleetimage1\" alt=\"$fleetmake $fleetmodel\" width=\"100\" height=\"75\" class=\"fleet_thumb\">";
}
echo "<div class=\"fleet_title\">$fleetmake $fleetmodel $fleetyear</div>";
echo "<div class=\"fleet_berth\"><img src=\"images/$fleetberth.gif\" alt=\"$fleetberth berth\"></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetberth berth<br />- $fleetlayout<br /></div></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetchassis<br />- $fleetengine<br /></div></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetlength meters<br />- $fleettype<br /></div></div>";
echo "<div class=\"fleet_options\">From <strong>$company</strong> in <strong>$location</strong> - <a href=\"view_motorhome_for_hire.php?ref=$fleetref\">More info >></a></div>";

echo "</div>";

}}
  }

} ?>

<?php

if(isset($_POST['ActivityId']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Activity like '%,$Search,%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

elseif(isset($_POST['EventId'])){

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from participation where EventId ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result)){

$LoginId= $row['LoginId'];

echo $LoginId;}

$query="select * from registration where LoginId='$LoginId'";

$result=mysqli_query($dbc,$query) or die('Not Connected to Reg');

while($row=mysqli_fetch_array($result)){

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}}



elseif(isset($_POST['Location']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND Address like '%$Search%'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}



elseif(isset($_POST['BloodGroup']))

{

require_once('database.php');

$Search=$_POST['Search'];

$query="select * from registration where Flag='A' AND BloodGroup ='$Search'";

$result=mysqli_query($dbc,$query) or die('Not Connected');

while($row=mysqli_fetch_array($result))

{

echo "<table border='2'><tr><td> Name--".$row['Name']."</td>

<td>Contact Number--".$row['ContactNumber']."</td>

<td>Email--".$row['Email']."</td>

<td>Address--".$row['Address']."</td></tr></table>";

}

}

?>

<html><body><form action='<?php echo $_SERVER['PHP_SELF']?>' method="post">

<input type="text" name="Search"><br>

<input type="submit" name="ActivityId" value="Submit Activity Id"><br>

<input type="submit" name="EventId" value="Submit Event Id"><br>

<input type="submit" name="Location" value="Submit Location"><br>

<input type="submit" name="BloodGroup" value="Submit Blood Group"><br>



</form>

</body></html>




Hi frds.............
I have two tables named "registration" and "participation". Registration table have some columns like "LoginId", "email","contact no.", "Name" etc.and participation table have 2 column named "LoginId" and "EventId".
Now if user enters EventId, I want to display the details like email,contact no. etc.
I have a code but it not works properly.......
If result have more than one row it only displays the email and contact no. of last one instead of all.
Plzzzzzzzzz help anyone...................
????????/