Loading A Textfile Into A Mysql Table

[wesmith4]

The code below produces a syntax error, saying there is unexpected T-String in the line that starts with "Load Data......".

Can anyone tell me wyat I am doing wrong?

=========================================

<?php
require ('./mysqli_connect.php');
LOAD DATA LOCAL INFILE 'c:/Users/CourseOfStudy.txt'
    INTO TABLE CourseOfStudy
    FIELDS TERMINATED BY ','
    IGNORE 1 LINES;
?>

========================================

Thanks for any directions for a new user.

Wes Smith

 

[HartleySan]

"LOAD DATA ..." is not a valid expression in PHP. That's a MySQL expression.

As such, you need to execute that expression directly from a MySQL manager or properly execute the expression using PHP syntax.