PHP - String Search From User Specified Configurations

Somewhat new with PHP but I think I'm on the right track. I'm trying to search for a serial number on a sql table. I want a response of the serial # and what column its in. There is 4 columns if that helps (id, 30, 32, 31). (serials 002062008002220 002062008002222 002062008002233 are in the table) When I enter in a serial # 002062008002220 (all serials are 16 digits long). I get a blank page to show up...  my form

<form action="search.php" method="get">
<input id="serials" type="text" name="serials" />
<input type="submit" />
</form>

my php

<?php

$con=mysqli_connect("localhost", "xxx", "xxx", "nsmserials");

if (mysqli_connect_errno ()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$search = mysql_real_escape_string($_REQUEST['serials']);
$query = "SELECT 30, 32, 31 FROM nsmtable WHERE 30 LIKE '%$search%' OR 32 LIKE '%$search%' OR 31 LIKE '%$search%'";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)){
    echo "<li><span class='name'><b>{$row['serials']}</b></span></li>";
}

mysqli_close($con);

?>

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);}

?>

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?

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..

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.

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 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?

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 =)

Hi all dear
can anyone help me how to find all permutation of a String by allow user input text or number and generate when user click on button,

user need to input text on number in input box and click generate button to show result of all permutation of a String
below is code i found from https://www.journaldev.com/526/permutation-of-string-in-java
but it's not allow user input text,

please help me in php function
thank with best regard

 

<!DOCTYPE html>
<html>
<body>
<?php
function generatePermutation($string,$start,$end){ if($start == $end-1){ echo "$string - "; } else{ for($i = $start; $i < $end; $i++){ $temp = $string[$start]; $string[$start] = $string[$i]; $string[$i] = $temp; generatePermutation($string,$start+1,$end); $temp = $string[$start]; $string[$start] = $string[$i]; $string[$i] = $temp; } }
}
$str = "ABC";
$n = strlen($str);
echo "All the permutations of the string a  ";
generatePermutation($str,0,$n);
?>
</body>
</html>

 

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>

I have a kind of search and react on my site. The user can search for a number in a column as below

$search = mysqli_real_escape_string($link, $_POST["query"]);

$query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";

 

The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... 

I want to expand the oemnr column as

12345/03124/34713, numbers separated with / or another character.

If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql.

Edited February 14 by jigga

Hello,

I had 8 select boxes(dropdowns) in a form. Its like a search kind of implementation in the website. I don't know what the user selects, he may choose different select boxes, any number of select boxes.

So, based upon the user selection, I need to generate the data. The data fields to be generated would be almost same.

So, How would I know what the user selection is and how many select boxes has been selected and how could I generate different data based upon selected boxes.

I had to make a small note abt this, that the data generation fields may change for some of the user select combinations, but most of the result fields would be same.

so, can you please help me out, how to do, how to make different combination data generations, because, i had 8 fields, i had to make 8! combinations, that would result in a big code.

The situation is that I have a large string with some identifiers to say "replace me" with something else. My goal is to replace the values, but if one replacement includes one of the other keys, I don't want to replace it.   For example:

<?php
$str = 'some blob ~abc~ followed by ~def~';

$arr_orig = array(
	'~abc~',
	'~def~'
);

$arr_new  = array(
	'value~def~',
	'blah'
);

echo str_replace( $arr_orig, $arr_new, $str );
?>

This will echo: some blob valueblah followed by blah   But that's not what I'm trying to accomplish. Basically, I want ~abc~ to be replaced with the literal: value~def~ and for the ~def~ that happens to be part of that string to NOT be replaced. I hope what I'm asking is clear. Basically, preg_replace/str_replace with arrays seems no different than just doing a FOR loop and replacing ~abc~ and then ~def~. But that's not what I need.   I'm hoping that if ~abc~ is replaced with text that happens to be another identifier -- ~def~, ~xyz~, whatever -- that this already replaced text is not again replaced. Is there a built-in function to do something like this? If not, should I just parse the whole string and count characters or something? Seems like a pain (and slow!)

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

 

hi,

i have made a website where people resgister their details of them and products.

they have to enter the following details in form

Name of company

name of the product

company address

email id 

password 

mobile number contact

and 

brief details about their company 

after filling all details user is registered on website.

user can then login with email id and pwd.

now after login ..user will get a page where he can upload the photos of products images and their price, so now my question is that when he finishes uploading (|by clicking on upload button) the product images and price text box ..then on final uploaded webspage it should show all other things which he registerd before (company name , mobile number etc) along with images and price...hence the main question that user does not need to enter mobile and address while uploading images and filling proce ..but on the final page it should show mobile and address along with price and images..as user is not going to enter mobile and address again and again as he will have multiple products to upload.

thanks in advance .