Insert Words from text file to database

by Mohan 2014-01-17 18:44:34



Hai,

Here is sample code to insert words from a text file into database table


<?php
$lines = file("words.txt", FILE_IGNORE_NEW_LINES);
$username = "root";
$password = "";
$hostname = "localhost";
$dbname = "sample";
$tablename = "englishwords";
$cn=mysql_connect($hostname,$username,$password);
if(!$cn)
{
// echo "database not connected";

}
else{
//echo "database selected";
}

$link=mysql_selectdb($dbname,$cn);
if(!$link)
{
echo "Table not selected";
}
else
{
//echo "table selected";
}
foreach($lines as $val)
{
$query= mysql_query("INSERT INTO `sample`.`englishwords` (`id` ,`words`) VALUES ('', '$val')");
}
?>
529
like
0
dislike
0
mail
flag

You must LOGIN to add comments