parsing text file into mySQL database

Question

I want to parse a log file into a table in my database using PHP, but I keep getting an error saying

php parse error, unexpected mysql_select_db command

any ideas??

Here's my code;

<?
$handle = @fopen("NeXposeResults.txt","r");
$conn = mysql_connect("localhost")
mysql_select_db("resultsdb.mwb",$conn);

$values=;

while (!feof($handle))
{
    $buffer = fgets($handle, 4096);
    list ($a,$b,$c)=explode("|",$buffer);
    values.=($a,$b,$c);

    INSERT INTO storage (Description, Severity, Risk Score,)
    VALUES ($a,$b,$c,)
}
?>

- Dont' use mysql_, use mysqli_ or PDO phpmaster.com/avoid-the-original-mysql-extension-1 - .mwb is a mysql workbench file and not a database. — Matt
– Matt, Commented Feb 26, 2013 at 20:56

rdcapasso · Accepted Answer · 2013-02-26 20:56:22Z

2

You're missing a semicolon on line 3.

$conn = mysql_connect("localhost") should be $conn = mysql_connect("localhost");

answered Feb 26, 2013 at 20:56

rdcapasso

1013 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rdcapasso Over a year ago

No worries. You're also missing them inside of your while loop: INSERT INTO storage (Description, Severity, Risk Score,) VALUES ($a,$b,$c,) should read INSERT INTO storage (Description, Severity, Risk Score,); VALUES ($a,$b,$c,);

Collectives™ on Stack Overflow

parsing text file into mySQL database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related