PHP - Search For String In A Text File..

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

     
    	   
           
			  
			   
			   
		   
		   }
 
?>

Hello,
I had simple php website in one folder, no database in the website.
I need a method for text search in the web directory...
Any help?

Thanks

I wanted to replace a strings in a large text file .. what would be the fastest way ?!

e.g the text file contains ..

INSERT INTO `subjects` VALUES (1, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (2, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (3, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (4, 'some text here', 'some text here', 'some text here');
INSERT INTO `subjects` VALUES (5, 'some text here', 'some text here', 'some text here');

I wanted to replace the string " VALUES (1, " with  "VALUES (" in each line ..
I'm new in PHP so any response would be much appreciated .. thanks

Hello all brilliant minds,

I'm a new in all this world of DB and coding and always i tried to avoid it because I think it is very hard (I'm trying to change now).

problem: I have a text file (log.txt) have data like below
========================================
> rtrv-ls

Command Accepted - Processing

    OXX 12-02-21 08:44:41 EST  EAGLE5 42.0.1-63.38.31
    rtrv-ls
    Command entered at terminal #7.
;

    OXX 12-02-21 08:44:41 EST  EAGLE5 42.0.1-63.38.31

                                                   L3T  SLT              GWS GWS GWS
    LSN           APCI   (SS7)  SCRN SET SET BEI LST LNKS ACT MES  DIS SLSCI NIS
    gtcen1pls     7-010-4       none 1    2    no   D    2        off   off   off    no    off
    gtgdv1pls     7-010-5       none 1    2    no   D    2        off   off   off    no    off

> rtrv-sid

Command Accepted - Processing

    OXX 12-02-21 08:43:43 EST  EAGLE5 42.0.1-63.38.31
    rtrv-sid
    Command entered at terminal #7.
;

    OXX 12-02-21 08:43:43 EST  EAGLE5 42.0.1-63.38.31
       PCA                       PCI          PCN                CLLI              PCTYPE
       010-010-010     7-055-1      01830              crher1p           OTHER
;
.
.
may output like this starting always with >

===================================================
Then I have SQL DB that have column with "rtrv-ls" and "rtrv-sid"

Requirement :

A) Use Php to open the .txt file, I used HTML form so the user can upload the file on the browser then
B) Search for the column name as pattern
C)Send query to MYSQL to update DB with Data for each column
D) Query the Mysql for several possible outputs (I've done this part using HTML form and simple php code as below.

<?php

// If we got a GET request on the page from HTML part of the code, we will want to store the data in a variable e.g $my_country
// So country will be passed via GET and will be stored in $my_country variable.

$host="localhost";
$con_usr="aomar";
$con_pass="nokia";

if ($_POST)   {
            $user_input = $_POST['my_log'] ;

// We use the request to search in Database and return the result, First step we need to connect to the database //

                $connect = mysql_connect ($host,$con_usr,$con_pass);
   
// Then we need to select database to run the query and return the result the connection stored in the $connect ressource //
   
if ($connect) {
              mysql_select_db("eagle",$connect);

// We store the query in variable $query becuase is it quite long text; we actually attach our varaiable $my_log passed from HTML //
         
              $query = "SELECT `".$user_input."` FROM `ss7`";

         //$update="INSERT INTO ss7 ('".$user_input."') VLAUES (';


// SO if user selected Egypt it will be stored in (name=my_country) variable from HTML and will be send via GET
// Then we store the query results in a variable called $result      
       
          $result = mysql_query ($query) ;
   

 $arr= mysql_fetch_array($result);
 
       
         echo nl2br ($arr["$user_input"]);
 
 
//Finally we return what we want from the array.
// Print the output as we wish. in case of row data like STP output, use the nl2br to preserve the output as it was written to MYSQL DB
// We need to check if the Query return no value (!$arr) , and print corresponding action

     
 
 
   
}
//================SECONED PART WHEN I LOAD THE LOG FILE TO BE STORED IN MYSQL================//


   
//close the db
mysql_close ($connect);
}
?>



<html>
<body>
<form action = "eagle.php?pmode=my_file" method = "POST"   enctype="multipart/form-data>
<fieldset>
<legend> Enter you log file here and click Save: </br> </legend>
<label for="my_file"> This Is My Capture File </label>
<input type = "file" name ="my_file" style=margin:auto > </input><br/><br/>
<input type="submit" value="Upload file">
</fieldset>
</form>
</body>
</html>   




<html>
<body>

<title>Eagle Data Base Store</title>
<form action = "eagle.php?pmode=my_log" method = "POST">
<fieldset>
<legend> Please Select the DB you would like to retrive </legend>
<br/><br/>
   <input type = "radio" name ="my_log" value = "rtrv-serial-num">Serial-Num</input>
    <input type = "radio" name ="my_log" value = "rtrv-stp">rtrv-stp</input>
   <input type = "radio" name ="my_log" value = "rtrv-feat">rtrv-feat</input>
   <input type = "radio" name ="my_log" value = "rtrv-dstn">rtrv-dstn</input>
   <input type = "radio" name ="my_log" value = "rtrv-rte">rtrv-rte</input>
   <input type = "radio" name ="my_log" value = "rtrv-trm">rtrv-trm</input>
   <input type = "radio" name ="my_log" value = "rtrv-slk">rtrv-slk</input><br/> <br/>
   <input type = "radio" name ="my_log" value = "rtrv-ls">rtrv-ls</input>
   <input type = "radio" name ="my_log" value = "rtrv-sccpopts">rtrv-sccpopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-stpopts">rtrv-stpopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-gsmopts">rtrv-gsmopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-cmd">rtrv-cmd</input>
   <input type = "radio" name ="my_log" value = "rtrv-assoc">rtrv-assoc</input><br/> <br/>
   <input type = "radio" name ="my_log" value = "rtrv-gpl">rtrv-gpl</input>
   <input type = "radio" name ="my_log" value = "rtrv-ip-host">rtrv-ip-host</input>
   <input type = "radio" name ="my_log" value = "rtrv-ip-lnk">rtrv-ip-lnk</input>
   <input type = "radio" name ="my_log" value = "rtrv-secu-trm">rtrv-secu-trm</input>
   <input type = "radio" name ="my_log" value = "rtrv-secu-user">rtrc-secu-user</input>
   <input type = "radio" name ="my_log" value = "rept-stat-sys">rept-stat-sys</input><br/><br/>
   <input type = "radio" name ="my_log" value = "rept-stat-clk">rept-stat-clk</input>
   <input type = "radio" name ="my_log" value = "rtrv-ctrl-feat">rtrv-ctrl-feat</input>
   <input type = "radio" name ="my_log" value = "rtrv-tabl-capacity">rtrv-tabl-capacity</input><br/><br/>

   <input type = "submit" value = "Show Selected Table"/>
   
</fieldset>
</form>
</body>
</html>   

==========================================END OF CODE===========================

*** Sorry for the many comments but I want to be sure I remember why I do that .

You help is much appreciated
(Please note that need to understand more than I need the Code itself)

Hey there,

Thanks for taking the time to read my thread. My issue is that I can't think of a way to edit a XML file using PHP's XML functionality and then assign the edited contents to a string instead of saving the file. Because my issue is that I have to edit the XML file based upon a string brought from a remote location then give it back to that remote location using a string again, to be exact I am doing it via Linux command line utilizing SSH2.

This is what I managed to complete on my own.


function CheckIVMPConfig($ServerID)
{
global $Panel;

if(is_numeric($ServerID) && $this->IsValidServer($ServerID))
{
// We select the game server that the FTP account was created for.
$Servers = mysql_query("SELECT * FROM control_servers WHERE server_id = '".mysql_real_escape_string($FTPAccount['ftp_server'])."'");
$Server = mysql_fetch_array($Servers);

// Here we select the Box ID that the game server is on.
$Boxs = mysql_query("SELECT * FROM control_machines WHERE machine_id = '".$Server['server_machine']."'");
$Box = mysql_fetch_array($Boxs);

// Now we select the required package for the box.
$Packages = mysql_query("SELECT * FROM control_packages WHERE package_id = '".$Server['server_package']."'");
$Package = mysql_fetch_array($Packages);

// Retrive the file.
$Config = $CProtocol->exec("cat /home/{$Server['server_id']}/{$Package['package_config']}");

$Parse = SimpleXMLElement($Config);

foreach($Parse as $Entry) // loop through our books
{
if($Entry->port != $Server['server_port'])
{
// edit the value
}
else if($Entry->maxplayers > $Server['server_slots'])
{
// edit the value
}
}
}
}