read | delimited fields from record in variables

[hockeyman10]

I am loading from a .data file and each line has all of the variables divided by "|". The code I use is in Perl and I need to have access to these variables just the same as with my perl code but with PHP. Please let me know if you have any idea what I can do. Thanks in advance. Here is the code.

$data_file="ads.data";

open(DAT, $data_file) || die("Could not open file!");
@raw_data=<DAT>;
close(DAT);



foreach $ads (@raw_data)
{
chop($ads);
($ad_number,$user_name,$user_type,$date,$var_1,$va r_2,$var_3,$var_4,$var_5,$var_6,$var_7,$name,$var_ 8,$city,$province,$postal_code,$country,$phone_num ber,$var_9,$email,$var_10,$category,$subcategory,$ caption_header,$caption,$ad_text,$price,$var_11,$v ar_12,$var_13,$var_14,$var_15,$var_16,$private,$va r_17)=split(/\|/,$ads);



if ($city eq "Toronto") {
print "<table width=100%><tr><td>
$city

</td></tr></table>";
}
}

[ronverdonk]

Welcome to TSDN. Next time enclose your code within php or code tags, as stated in the Posting Guidelines at the top of this forum.

Use the explode function of PHP. See http://nl3.php.net/manual/en/function.explode.php

Sample usage for your script it would be something like:

[php]
// read your record in $data
list($ad_number,$user_name,$user_type,$date,$var_1 ,$var_2,
$var_3,$var_4,$var_5,$var_6,$var_7,$name,$var_8,$c ity,
$province,$postal_code,$country,$phone_num ber,$var_9,
$email,$var_10,$category,$subcategory,$caption_hea der,
$caption,$ad_text,$price,$var_11,$var_12,$var_13,$ var_14,
$var_15,$var_16,$private,$va r_17)= explode("|", $data);[/php]

Ronald :cool:

[hockeyman10]

Thank you for the reply!

So my code should look like this?

<?php

$data_file="data.txt";



list($ad_number,$user_name,$user_type,$date,$var_1 ,$var_2,
$var_3,$var_4,$var_5,$var_6,$var_7,$name,$var_8,$c ity,
$province,$postal_code,$country,$phone_num ber,$var_9,
$email,$var_10,$category,$subcategory,$caption_hea der,
$caption,$ad_text,$price,$var_11,$var_12,$var_13,$ var_14,
$var_15,$var_16,$private,$va r_17)= explode("|", $data);








if ($city == "Toronto") {
print "<table width=100%><tr><td>$city</td></tr></table>";
}


?>


This makes the page not work. Is there something I'm doing wrong? Thanks alot for the help!

[ronverdonk]

Where is your read (of the file) statement? As I pointed out in the sample:

[php]// read your record in $data
[/php]

Ronald :cool:

[hockeyman10]

Would it be something like this?
[php]
<?php
$data_file="data.txt";
$myFile = "data.txt";
$fh = fopen($myFile, 'r');
$data = fread($fh, 5);

list($ad_number,$user_name,$user_type,$date,$var_1 ,$var_2,
$var_3,$var_4,$var_5,$var_6,$var_7,$name,$var_8,$c ity,
$province,$postal_code,$country,$phone_num ber,$var_9,
$email,$var_10,$category,$subcategory,$caption_hea der,
$caption,$ad_text,$price,$var_11,$var_12,$var_13,$ var_14,
$var_15,$var_16,$private,$va r_17)= explode("|", $data);

if ($city == "Toronto") {
print "<table width=100%><tr><td>$city</td></tr></table>";
}
fclose($fh);
?> [/php]
Not to sure what you mean. New to this. Thanks for your help!

[ronverdonk]

You were requested in a previous post to enclose your code within php or code tags! Read the Posting Guidelines. before you continue.

moderator

[hockeyman10]

You were requested in a previous post to enclose your code within php or code tags! Read the Posting Guidelines. before you continue.

moderator

I'm sorry. I am so new! I thought you meant within the <?php ?> tags. Then after my last post I realized what you meant but I could not find an edit feature! I'm sorry.

[ronverdonk]

php command fgets will read one text line at a time. So the process is:

open file
while (not EOF)
   read text line
   assign content to variables
   .. what else to process ...
end while
close file
 

Ronald :cool:

[hockeyman10]

So it should look something like this?? This deffiantely isn't it though.

[PHP]
<?php

$data_file="data.txt";



open file
while (not EOF)





list($ad_number,$user_name,$user_type,$date,$var_1 ,$var_2,
$var_3,$var_4,$var_5,$var_6,$var_7,$name,$var_8,$c ity,
$province,$postal_code,$country,$phone_num ber,$var_9,
$email,$var_10,$category,$subcategory,$caption_hea der,
$caption,$ad_text,$price,$var_11,$var_12,$var_13,$ var_14,
$var_15,$var_16,$private,$va r_17)= explode("|", $data);








if ($city == "Toronto") {
print "<table width=100%><tr><td>$city</td></tr></table>";
}


end while
close file




?>
[/PHP]

[hockeyman10]

I am very confused. Is there something I am supposed to be adding to that?