[Pothik]

I want to read a text file by php code with compare like

file name is 'price.txt'

Data of the file are:
-----------------------------------------------------
Copmany Name Price

Exim Bank 100.00
Standard Bank 120.00
-------------------------------------------------

i want read it and save to database field which are created for that.is it possible?

[clay@lazarusid.com]

Not only possible but pretty easy. Just read in the line, break it into it's component parts, and insert a record into the database.

Your trick, of course, will be breakup up the component parts, because you have a variable length, undelimited text field followed by a price. It might have been better to reverse the order of the fields, or create some variety of delimiter like a dollar sign. That can be worked out though, just start hunting for the change between whitespace and digits.

[Pothik]

Thnkx for help but if u give some code for this it would be more helpfull to me coz i am new in php.

[ermau]

For this to work, just add a + in front of each line that contains data, like such:
-----------------------------------------------------
Copmany Name Price

+Exim Bank 100.00
+Standard Bank 120.00
-------------------------------------------------

PHP Code:

<?php



$prices = file('price.txt');

for ($i=0; $i<count($prices); $i++)

{

      if (stristr($prices[$i],'+'))

      {

            $data = explode(' ',$prices[$i]);

            mysql_query("INSERT INTO table (name,price) VALUES ('$data[0]','$data[1]')");

      }

}



?>

Of course I don't know how your mysql table structure is but you can modify that query to your needs.

[Pothik]

Special Thnkx for help .hope it will work properly

[clay@lazarusid.com]

Pothik,

It sounds like you might be better served by the PHP forum here or over at devshed.com. This isn't really a "help me learn PHP" forum. People in those other forums will be able to help you get up and running though.