Menu
Community /Pin to ProfileBookmark
@NogDogMay 05.2016 — #fgetcsv () will be your friend for reading the data in, being sure to use the optional parameter to tell it to use ';' as the field separator (instead of the default comma). So you'll use that in a loop (should be an example in that manual page), and it will give you an array of data for each row that you can output as desired within the loop.@NogDogMay 06.2016 — #Yes, it's not technically a CSV file, but fegetcsv() is smart enough to treat it as one, using ";" as the separator. It does not matter what the file suffix is: just that it's a plain text file and that there is a specific character being used as the field separator. @NogDogMay 07.2016 — #Because I was bored:
Where do I send my invoice?@NogDogMay 08.2016 — #
Well, I was not trying to write the full end product for you, just show you the basic mechanism of using fgetcsv() with a semicolon-separated-values file. Yes, you'll have to supply the actual file path, make sure your HTML is configured to output whatever character encoding it is using (and perhaps look into applyinghtmlentities() to the output).
Need Help reading and display data from a txt file – PHP
Hello folks, I’m building a website for my dad’s company, so far doing good but now I’ve encountered some problems, so they are working with a software that saves certain data into a text file, its a service company that repairs electronics, so the data is : [B]worksheet code, customer code, device name, device serial number, manufacturer, price offer, gross price in total, repair status.
[U][B]Example:
654;13285;SDR-H80;E9IA10966;Panasonic;15000;14975;Complete
as u can see the software saves the data in that exact order as i mentioned, seperating them with a ;
( 654 is the worksheet code, 13285 is the customer code, SDR-H80 is the device name etc…. )
So what i need is a php code that will retrieve the right data and displaying it’s status from a form action.
So here’s my code:
<div id=”login” class=”boxed”>
<h3 class=”title”>Information about devices</h3>
<p class=”content”>You can find the worksheet ID and the customer code on your worksheet.</p>
<div class=”content”>
<form id=”form1″ method=”post” action=”process.php”>
<fieldset>
<label for=”inputtext1″>Worksheetcode:</label>
<input type=”text” name=”ID”>
<label for=”inputtext2″>Customer code:</label>
<input type=”text” name=”code”>
<input type=”submit” name=”Submit” value=”Submit”>
<input type=”reset” name=”reset” value=”Reset”>
</fieldset>
</form>
</div>
So as you can see it’s an HTML form, that refers to a .php, i need a php code that will search and display all the data related to a certain device from the textfile by giving the ” customer code ” and the ” worksheet code ” ?
Thank you guys in advance! ?
Sign in
to post a comment16 Comments(s) ↴
0
@NogDogMay 05.2016 — #0
@NogDogMay 06.2016 — #0
@NogDogMay 07.2016 — #Because I was bored:[code=php]
<?php
// create test file
$testFile = tempnam('/tmp', 'test');
file_put_contents(
$testFile,
"654;13285;SDR-H80;E9IA10966;Panasonic;15000;14975;Complete".PHP_EOL.
"655;13286;SDR-H85;E9IA10964;Panasonic;15003;14978;Incomplete"
);
// make sure there's really something in there:
echo "<pre>Test Filenn".file_get_contents($testFile)."</pre>";
// now the actual reading/processing of the file
$fh = fopen($testFile, 'r');
while($row = fgetcsv($fh, null, ';')) {
if(count($row)) {
echo "<h3>Data row</h3>n<ul>n";
foreach($row as $field) {
echo "<li>$field</li>";
}
echo "</ul>n";
}
}
fclose($fh);
// clean up after ourselves:
unlink($testFile);
[/code]Where do I send my invoice?
0
@NogDogMay 08.2016 — #Thanks NogDog, but it didn't work, ? the filename is WEBDATA.TXT, also I've watched the tutorial and I discovered some things how I should create the output, so I made a table on process.php and I want to display the data in the table.
but still the function doesn't work. I made a test file for that purpose only to test it out, but I cannot make it work xD, I even tried converting to .TXT to UTF-8 encode cuz of the non english content. but still, doesn't work.[/QUOTE]
Well, I was not trying to write the full end product for you, just show you the basic mechanism of using fgetcsv() with a semicolon-separated-values file. Yes, you'll have to supply the actual file path, make sure your HTML is configured to output whatever character encoding it is using (and perhaps look into applying