how to read file and insert database

[jr_yeo]

just like this?

<?php
$conn = mysql_connect('XXXX', 'XXXX', 'XXXX') or die ('Error connecting to mysql');
mysql_select_db('XXXX', $conn) or die ('Error connecting to database');
mysql_query('insert into texter (name) values ("' .   mysql_real_escape_string(str_replace("\n", '\n', file_get_contents('text.txt'))) . '");');
?>

still no data is stored.

MySQL database Dump

CREATE TABLE `texter` (
  `id` smallint(5) unsigned zerofill NOT NULL auto_increment,
  `name` varchar(150) collate latin1_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin AUTO_INCREMENT=1 ;

[jr_yeo]

guyz.... any ideas?

[Twey]

You realise you've only allowed for 150 bytes of data there? If the file is more than 150 bytes, there will be problems. If not, it's time for debugging code to go in.

<?php
$conn = mysql_connect('XXXX', 'XXXX', 'XXXX') or die ('Error connecting to mysql');
mysql_select_db('XXXX', $conn) or die ('Error connecting to database');
$query = 'insert into texter (name) values ("' .   mysql_real_escape_string(str_replace("\n", '\n', file_get_contents('text.txt'))) . '");'
mysql_query($query) or die(mysql_error() . '<br><br>' . '<b>Query:</b> ' . $query);
?>

[jr_yeo]

so far, got the impression that u want me to use BLOB here to insert data from file, right?
but what m trying to achieve here is read a file, insert data to the database line by line, and output back the data thru tables and sort the "outputted" data?

[Twey]

Oh, I see. You want each line to be a separate record?

[jr_yeo]

Oh, I see. You want each line to be a separate record?

yeah. i think its something to do with explode() or is it implode()? dunno much about php to read php.net manual efficiently

[Twey]

You could use explode(), but in this case it's easier to simply use file() to read the file. This returns an array of the lines in the file.

<?php
$conn = mysql_connect('XXXX', 'XXXX', 'XXXX') or die ('Error connecting to mysql');
mysql_select_db('XXXX', $conn) or die ('Error connecting to database');
$query = 'insert into texter (name) values ("%s");';
$lines = file('text.txt');
for($i = 0; $i < count($lines); ++$i)
  mysql_query(sprintf($query, mysql_real_escape_string($lines[$i]))) or die(mysql_error() . '<br><br>' . '<b>Query:</b> ' . $query);
?>

[jr_yeo]

will try later