PHP :: Reading Tab Delimited File Into Database

Comma Delimited File
I am trying to read comma delimited rows of text. The problem is that
some fields may be encapsulated in "" - particularly the text fields but
not numeric fields.

Is there a simple efficient way to parse the fields with comma but also
strip off the "" encapsulating some of the fields with php?

The problem is the "" encapsulation is optional. Some fields will have
it, some won't.

Delimiting A Non-delimited File
I have a text file, with addresses of business' that I would like to convert to a more useable format ie CSV. Currently there is no delimiting of the various address components.

"A 1 AUTO SALES 1224 S BROADWAY ST WICHITA, KS 67211-3124 316-263-8748"
"ABERLE FORD INC 1025 MAIN ST SABETHA, KS 66534-1893 913-284-3122"
"ACTION AUTO RENTAL & SALES 1101 W 4TH AVE HUTCHINSON, KS 67501 316-662-3699"

As you can see from the examples above the only consistent items are the state and the phone number, and the city is always followed by a comma. I am new to regex and the whole range of string handling functions and I am not sure where to start.

Tab Delimited Txt File To Php Html Table
Wouldn't you know that when I finally find a tutorial using Google that does exactly what I want, the code doesn't run when I use it ...

However, when it gets to this line, for ($i=0; $i<td>$line[0]</td>, it chokes on one of the '>'.

Since my php skills are very basic, and in no way include arrays, can someone assist me with this?

If it's easier to do it differently, what I'd like to do is create a table in Excel/Access, export it to the server (to a tab-delimted text file, since I'll be using commas in my table cells), and have it display in an HTML table.

If I can't figure this out, I'm tempted to just export to HTML from one or the other program (not sure quite yet which I would use), so ...

Match Input Value With Values In A Delimited File
I'm very very new to php. I need your help. I have a text file which is ~ delimited. Each line has a name and link. I want to check if the link is similar to my input and if it is then return the name.

Importing To DB From Pipe Delimited Text File
I am trying to make a PHP script that will import data from a pipe delimited text file in to a database. The problem I am having is that the fields have long descriptions in them and there are multiple line breaks for paragraphs. They contain HTML codes as well (<B>).

The multiple line breaks are causing it to import the data strange, putting data in the wrong fields and totally missing some data as well. Here is what the text file Code:

Stripping Quotes Out Of A Comma Delimited File?
I have a flat file that I'm trying to stick into a MySQL database. One
record per line, multiple fields per record, and many of them are null
fields which are just double quotes without a space between. It's probably
nothing really major for people who have done this before, but I'm a bit
stumped. The file is comma delimited. Every field is surrounded by double
quotes. I've done quite a bit of searching, on the php site and elsewhere,
but I can't seem to get it to strip the quotes out so I can explode the file
line by line to grab the fields.

Multiple Table Insert From Tab Delimited File
I have a page I'm coding for batch updates from a tab delimited file. Each row has data that has to be checked against and inserted/updated on different tables in my mySQL database.

How would I go about parsing through the tab delimited file and then storing data between the tabs in order to insert individually into separate tables??

Here's what I have so far...

$contents = file('/myfile.txt');

for ($i=0; $i<sizeof($contents); $i++) {

$line = trim($contents[$i]);
$arr = explode(" ", $line);

$line[$i] = array('ID' => $arr[0], 'Record_Type' => $arr[1], 'First_Name' => $arr[2], 'MI' => $arr[3], 'Last_Name' =>
$arr[4], 'Firm' => $arr[5], 'Address' => $arr[6], 'type' => rtrim($arr[13]));

I need to take the different columns.. ID, Record_Type, etc. and update different tables with each value where the IDs match.

Importing A Flat Pipe Delimited File Into A MySQL Data Table
I have done this in perl but eeew I don't want to use perl anymore. I
want to be able to take a flat file that looks like this:

mbriones@...|Marian|Briones
bobsmith@...|Bob|Smith
janedoe@...|Jane|Doe
(etc)

The table has more than 3 fields, so I'd want to process the flat file
and then do an INSERT into mailinglist SET field=$value for each line.

Does someone have a nice way for me to do this? The flat file will be
uploaded to the server via a form (copy) and then be processed.

Database Reading..
I have a mysql database named userdata setup. like this

Database = userdata
Under userdata are the columns
buddy and username

what i want to do is make a page that has a textbox with a button on it that says view data.
when you type one of the usernames in the textbox then you would hit view data.

when view data is hit. it will search the database for every row in the column username that = textbox
then display all of the rows it found .

Reading Database Problem
I'm having a problem reading the database. But I assume its due to the fact that I have done some very bad coding lol... I'm still fairly new. So forgive me.

A little info... I'm trying to set up a so called counter. When someone opens a page it will check to see if someone has been to the site before and if they have it will add a 1 to visits.

And if the person hasn't been to the site before it will insert their ip along with 1 visit to the database.

As you can see this is being done by reading the persons ip address. But instead of updating an ip address with visits... It keeps inserting and inserting. Never updating.. Code:

Reading And Displaying A Date From A MySql Database
I've just started using php, and although I am very impressed by it,
there are some things with which I am confounded!

What I'm trying to do is read in a Date from a mySql database and then
display it on screen (the Date is in the usual yyyy-mm-dd format).

If I use SQL on phpadmin
SELECT Date
FROM details
WHERE details.Name = "Paul Lee"
LIMIT 0 , 30

The result comes up 2005-01-01, so this seems to work.
But if I use the following:

$db = mysqli_connect("localhost","root","");
@mysqli_select_db($db, "personnel") or die ( "Unable to select
database" );
$query = 'SELECT Date FROM details WHERE details.Name = "Paul Lee"
LIMIT 0, 30'

$result=mysqli_query($db, $query);

echo "<br>";

echo $result;

mysqli_close($db);

I get "Object id #2" displayed on screen.
I have tried to use the explode function to separate the months, year
and day using the "-" as a delimeter, but this doesn't work, and I
can't seem to get the other php date/time functions to work either.

Reading Barcode, Updating Access Database
I am writing a tracking system using barcode readers. I have a simple page with two entry points, one to display the form to receive a scanned serial number and the other to do the upload to an Access database. It works okay with a button on the upload screen to return to the form screen but I want to return to the form screen without an OnClick event handler. Basically, I want the user to see the "Enter serial Number" prompt and be able to do scan after scan without having to click on anything else. I need to display the status of the upload after each scan. I have tried using windows.location.href, header(location:etc) , $PHP_SELF etc but without any success.

Can anyone help with syntax to reload or load the page (including entry point and status variables) after the database is updated without the user having to do any clicking? Or is this best handled in Javascript?

Reading Database BLOB With Showing Progress Information
I'm dealing with a very tricky problem and can't seem to find the
answer with google. the problem is: i want to store huge data
(binaries) inside a mysql databases blob - to later store those data to
a file somewhere else (from where i can connect the database).

problem comes into play, when I try to output a "progress" of the
reading of this data (kind of "xx bytes of XXX bytes already
transmitted").

Does PHP / PDO /PEAR:DB has those Buffered Read capabilities for Table
Columns ?

Reading A File
For some reason I can open a file, but I can't read it (I checked with is_readable() and is_writeable() and both returned true). I'm trying to open a file just copied, so maybe that's the reason why I can't read it, and I would have to reload the page. PHP Code:

Reading Tar.z File
i wanna extract and read data from a tar file i have tried www.phpclasses.org/browse/package/529.html thing. but that is not working for .z file. any idea how to do that ?

Reading A File
I've got the following script:

<?
$inhoud = file("/opt/scripts/sc/sc_trans.log");
$inhoud = implode("", $inhoud);

$inhoud_array = explode("
", $inhoud);

for($i=0; $i < count($inhoud_array); $i++){
$titel1 = explode("[DECODE] Opened ",$inhoud_array[$i]);
$titel2 = explode(".mp3",$titel1[1]);
$titel = $titel2[0];

$part1 = explode("<",$inhoud_array[$i]);
$part2 = explode(">",$part1[1]);
$tijd= $part2[0];
$tijd= ereg_replace("@"," ", $part2[0]);

echo "[$tijd] $titel
";
}
?>

While running this I get:

PHP Notice: Undefined offset: 1 in /opt/scripts/shoutcast/crphp on
line 9

How do I solve this?

Reading A .txt-file With Php
I have the following problem and it would be nice, if someone could help
me out on this problem:

content of file.txt

#1: Michael
#2: Dennis
#3: Karl

the following file writes only the first line of file.txt:

<?php
$fp = fopen("file.txt","r");
if ($fp)
{
$line = fgets($fp, 100);
echo "$line<br><br>";
fclose($fp);
}
?>

Now I would like to have a PHP-file, which can write every line in
different orders (the order should be write in the PHP-file)

for example:

#2: Dennis
#1: Michael
#3: Karl

Reading A File
I have a file which has a bunch of entries (student's data). Its structure
looks like

Number1|ID|name|surname|emailaddress

As can be seen, the entries are seperated by a "|".

Now I would like to create 5 arrays where I store all the entries
seperatly, for instance an array for the ID, one for the name ....

How do I read out the file and save the data to the arrays?

Reading A M3u File
I'm trying to read a .m3u file.. I'm almost done but got one problem.. I'm trying to remove every non related info for the song info.. meaning the #EXTINF: etc... I've managed to strip the #EXTINF but the problem comes to removing the number after that... Code:

Problem Reading From File
I have used this code in other projects, however, I'm geting an error that I don't understand.

Here is the error:

How To Open A File For Reading ?
i want to open a text file for reading. i tried this but nothing comes out ?

$fp = fopen("/u/htdocs/privat3/ttt/test.txt", "r");
fputs($fp, "GET ".$url." HTTP/1.0 r ");

Reading File Properties
I am trying to create a dynamic page that reads a user's browsing history and writes itself according to that. How can I use php to determine the properties of files?
Any ideas would be helpful.

Reading Only One File From Directory
I am trying to make a class that does a bunch of file stuff and one of the functions is suppose to read the files out of the directory. PHP Code:

Reading Img File From ISAPI .dll URI
Advice or references to information appreciated...

I would like to capture an image file that results from a URI ending with a .dll extension. I assume the .dll conforms to ISAPI but I don't know much about that yet. The big picture is that I want to capture a third party dynamically generated image (chart) normally displayed in a webpage and cache it on a PHP based server as a static image file (.gif, jpeg, or other).

Any suggestions or references to discussions of this would be appreciated. I'm new to PHP but with a long history of C/C++ and Java coding.

Reading File Contents
I am parsing a file delimited by |. For some
reason the content is displayed to the browser properly - but the loop
is consistenlty outputting "one more row" of just the titles.
Perhaps I'm going about it completely wrong:

<?php

$filename = 'books.file'
$fp = fopen("$filename", "r");

while (!feof ($fp)) {
$contents[] = explode("|", fgets($fp, 4096));
}
fclose ($fp);
$loop=1;
foreach ($contents as $row) {
echo "<b>$loop</b> -------------------<br>";
echo "<b>Reviewer</b>: $row[0]<br>";
echo "<b>Date</b>: $row[1]<br>";
echo "<b>Title:</b> $row[2]<br>";
echo "<b>Author:</b> $row[3]<br>";
echo "<b>Rating:</b> $row[4]<br>";
echo "<b>Comments:</b> $row[5]<br><br>";
$loop++;
}

echo "<a href="bookreview.html">Insert a new book review</a>";

?>

Reading File Into Array
I have a directory which contains files and I have since found out that I can place the files into an array. However, I am new to all of this and my all attempts at writing correct code have failed.

All I want to do is place the file name into the array so that I can create a while loop on the array in a table. I would even be satisified with counting the number of files in the directory.

Reading Part Of A File
I would like to read say... ONLY the last 200 bytes of a REMOTE, BINARY file. How can i do this?

Reading Zip File Contents
say i have a zip file - test.zip - with a file - somefile.txt - in it,
whose contents are as follows:

this is a test

when i try running the following script on the above zip file, i get
everything i should be getting, save for the contents of somefile.txt
(example output follows the script):

<?
$filename = 'test.zip'
if (($temp = zip_open($filename))) {
while ($entry = zip_read($temp))
if (preg_match('/.txt$/',zip_entry_name($entry))) {
print "file name = '".zip_entry_name($entry)."'
";
print "file size = '".zip_entry_filesize($entry)."'
";
print "contents = '".zip_entry_read($entry)."'
";
}
zip_close($temp);
}

?>

the output is as follows:

file name = 'somefile.txt'
file size = ཊ'
contents = ''

the output i would like and expect is as follows:

file name = 'somefile.txt'
file size = ཊ'
contents = 'this is a test'

Reading Https File
I have a screencraper application that read webpages with fopen() and then
processes them.

Now I found a https page that does not require a password. However, I cannot
read it with fopen().

My question is: are there other ways to read this page? Or is it technically
impossible?

Reading From A Blob Or A File Which Is Better?
I have over 5000 thumbnail pictures of size 5kb each. I would like to
able to load all 5000 pictures and view 50 per page using
mysql_data_seek(). I would like to know what are the advantages and
disadvantages of using a MySQL blob field rather than reading the
images directly from the file? How does one insert an image into a
blob field? Can it be done dynamically?

Reading MSword File
can anyone suggest me how the content of MSword document can be read and put in mysql database.

Why The Need To Flock() When Reading A File?
I'm only going to be opening and reading a text file. I understand there's the syntax:
flock($fp, 1) for reading file. My question is, is this even necessary, provided my script does not write to a file elsewhere?

UTF-8 File Reading And Writing For PHP
I'm creating a page that:
- accepts user input in whatever language
- saves that input to a file
- reads the file and displays the original input

The following code successfully writes the user input to a file (when I
open the file, it's in the correct font), but I can't get PHP to read
the file and display the correct characters.

HTML --------------- Form
<FORM name=saveform method=post action="wiki.php">
File:
<TEXTAREA name=thetext rows=20 cols=30></TEXTAREA>
</TEXTAREA>
<INPUT type=submit>
<INPUT type=hidden name=action value="save">
</FORM>

PHP --------------- Sticks the data in a file
$message = $_REQUEST['thetext'];
echo $message; // This displays the correct stuff
$filename = "tmp/tmp.txt";
$fr = fopen($filename, "wb+");
// adding header
fwrite($fr, pack("CCC",0xef,0xbb,0xbf));
fputs($fr, $message);
fclose($fr);

PHP --------------- Read the data from the file
$thefile = file($filename);
array_shift($thefile); //To get rid of the BOM
$ret = "";
foreach ($thefile as $i => $line) {
$line = rtrim(utf8_decode($line));
$ret .= $line;
}
echo $ret; // This _doesn't_ display the correct stuff

Reading The Summary Of A File.
I know it is possible to read the contents of a file. But what I wanted to do was be able to read the Summary Contents of a file (summary, category, keywords, comments etc) and I was wondering if this is possible.

Tab Delimted File Reading...
I am having a rough time trying to figure out how to open a tab-delimted .txt file into php and having it print the contents correctly.

The file I have is laid out like this:

Stock Item Color Price Quantity
Stock Item Color Price Quantity
Stock Item Color Price Quantity

What I am using is: Code:

Reading A File Into A Varriable?
I have a script that generates a file that has a 0 if it succeded or another number if it did not succede. It is always a single digit in the file and I would like to know how I can open that file and read it from a PHP script and assign it to a varriable. This way I can do something like this to rerun it at a later a point:

if ($attempt == 0){
exit;
}else{
# I will rerun the script that failed
include('update.php');
}

Reading From A Variable Instead Of A File
I want to achieve this:

ob_start();
include($file_path);
$contents = ob_get_contents();
ob_end_clean();

but I want to load it from a variable instead of a file but I cant think of a way of doing it any idea guys?

Reading File Names
Im writing a php file that will upload pictures in a remote directory. Im actualy doing a buletin board,and i have a mysql table that has subjext message date and entries(key) columns. I want the user to be able to aslo upload a image when posting a message.

So I figured the best way to do this is to upload all files in a dirr and add the column 'image filename' to the mysql table for each entry. Im not sure how to read the file names for each entry. My guess was to use $image = basename($path); but how will it know to store differet file names for each entry in the table. Does anyone know ?

Reading File Data
i am trying to read ogg metadata by opening the file and looking for the tag data, i can manage to echo out the vorbis header, but the commend fields wont echo out, i get random characters-buti can see the data in the file (with a hex editor)

whe i try and read the data for album name

using fread($file,x) ;

and echo it out, its not equal to the album name?

Reading XML Without Opening A File
I'm having a small problem with PHP that I'm hoping someone can help me solve:

I have a script that can parse XML when reading from a file and store each part of the XML in a variable, it works great: ....

[PHP] Reading A Text File Into A Dbase
I want to update my mysql database with a single text file (one table). Every row in the file is a new entry into the table but a row has several fields in it and that's where i have a problem. I'm able to load the file into an array and then insert it into the database but i have to split the row into different fields like: field1, field2, field3. I can't get it done. Can somebody help me .

Problems Reading Word File Using COM In Php
Can no one help with this? I have search all over the internet in messageboards and articles. Everyone seems to just give up on this error. Surely there is someone who knows how to fix it.

PHP Warning: Invoke() failed: Exception occurred. Source: Microsoft Word Description: Could not open macro storage. in c:inetpubwwwrootconvert.php on line 18

Here is the code I am using

<?php

// starting word
$word = new COM("word.application") or die("Unable to instanciate Word");

// if you want see the World interface the value must be Ƈ' else Ɔ'
$word->Visible = 1;

//doc file location
$word->Documents->Open("c:wwwroot rial.doc");

//html file location Ǝ' mean HTML format
$word->Documents[1]->SaveAs("c:wwwroot rial.html",8);

//closing word
$word->Quit();

?>

I have checked that the IUSER in security settings is set to interactive. I have checked for case sensitivity.

Reading File Names In A Directory.
I'm quite new to PHP, just getting my feet wet really, and I was wondering if I can scan a directory?

ie. Counting all files in a certain folder with a ".txt" extension or maybe all files in a folder that contain "news" in it's name.

Reading Local File Not On Server
I am trying to parse a file which is located on the users local drive and then take this data and put it into the mySQL DB. However, I get errors when I pass in a file path such as C:Documents and SettingsAdministratorDesktopfooSLInfo.txt.

Puzzling File Reading Problem
This is a script that is supposed to read all the files in a directory, grab the 3rd line of information in each, and write it to results.txt.

The problem being that it seems to be opening all the files at once as one big file, then when I write the chosen line to results.txt, it's always the same data, because line 3 is still the same line 3, if you see what i mean:

file1 line1
file1 line2
file1 line3<-- reads this line for each iteration of the for() loop
file2 line1
file2 line2
file2 line3 etc.

Here's my "code"; PHP Code:

Reading In A Part Of A HTML File
I am working on a script at the moment, and I want to be able to include some HTML snippets that a user can update at any given time.

In most cases the snippets will be only a table, but I want to make allowances for the file if it is a full HTML file.

What I would like some help in working out, is what would be the best way to read in the file and take all the code after the <body> tag upto but not including the </body>. Is there an eay way of doing this? So that if all I want is the table that is inside the page, that is all I will get.

Reading XLS File And Storing Data In DB
anyone idea how to read Excel file in php?

keep in mind that i would use php on linux platform so no COM solution ...

Reading A Line At A Time From A File
Just wondering what the best way to do this is?

What i specifically want to do is check if a user exists on a unix machine.
The best way i was told was to read a line at a time of /etc/passwd and
check if the username is in that line.

Reading Tab Delimited File Into Database

I have a .tab file that I need to write to the database. I've read it in, but for some reason it's not reading correctly. I'm truncating the complete database and then reloading it with whatever is in the tab file. I keep getting an error when trying to run my current code which is: Code: