How to Search in Text File and Feedback result into MySQL (Newbie)

aomar · February 28, 2012

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>

<legend> Enter you log file here and click Save: </br> </legend>

<label for="my_file"> This Is My Capture File </label>

</fieldset>

</form>

</body>

</html>

<html>

<body>

<title>Eagle Data Base Store</title>

<legend> Please Select the DB you would like to retrive </legend>

<input type = "radio" name ="my_log" value = "rtrv-serial-num">Serial-Num</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-assoc">rtrv-assoc</input><br/> <br/>

<input type = "radio" name ="my_log" value = "rtrv-tabl-capacity">rtrv-tabl-capacity</input><br/><br/>

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

litebearer · February 28, 2012

Ok, so its homework; therefore the instructor believes that what she/he/the books have taught you thus far should have enabled you to do this.

1. Did you test it?

2. If so, what errors are you getting?

3. what specific part is confusing you?

aomar · February 28, 2012

Hello litebearer,

First thank you for your time looking at this, normally I read that from php.net and some mysql tutorials, so no book, no teacher

but I just think about the idea to be able to practice what I'm learning.

So Actually the code below does not contain at all the open,search for pattern and update mysql as I can not get my mind how to do so.

Thanks to shed some light how can i find a pattern like ">" then I need to select all data until next "">" then push what is between those to my mysql

Regards,

bspace · February 29, 2012

$filename = "/path-to-file/log.txt";
$handle = fopen($filename, "r");
$logfile_text = fread($handle, filesize($filename));
fclose($handle);

$pos = strpos($logfile_text, '>', 1);

$rtrv-ls = substr($logfile_text, 9, ($pos - 9));

a base to start from

Sign In

How to Search in Text File and Feedback result into MySQL (Newbie)

Recommended Posts

aomar

Link to comment

Share on other sites

litebearer

Link to comment

Share on other sites

aomar

Link to comment

Share on other sites

bspace

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information