Parsing multi-line records

[jawa]

I have a file that looks like this:

Name: Name1
Title: Title1

Name: Name2
Title: Title2

.
.

Name: Name300
Title: Title300

I want to load the values into a mysql table.

Can this be done w/ PHP?

Thx!
-J

[zhabala]

Of course it can be done with PHP.

Zdenek

$source = file('filename.txt');
$first_record = 0;
foreach ( $source AS $line ) {
    if ( substr($line,0,4) == 'Name' ) {
        if ( $first_record == 0 ) {
            $first_record = 1;
        } else {
            // save previous record
            $sql = "INSERT INTO table ( name, title ) values ( '$name', '$title' )";
            // some insert into MySQL
        }
        $name = substr($line,5,strlen($line)-5);
    }
    if ( substr($line,0,5) == 'Title' ) {
        $title = substr($line,5,strlen($line)-5);
    }
}

// here you have to insert last record
$sql = "INSERT INTO table ( name, title ) values ( '$name', '$title' )";
// some insert into MySQL

[jawa]

Cool...

Didn't expect code, but I'm happy to see it!

Was just wondering if there were specialized functions, or if I needed to loop, etc...

Thanks for the help!

-J