Code: Select all
<?
/*db variables*/
$db_name = "xxx";
$table_name = "xxx";
$server_name = "localhost";
$user_name = "xxx";
$password = "xxx";
$connection = @mysql_connect($server_name, $user_name, $password) or die("could not connect");
$db = mysql_select_db($db_name, $connection) or die ("could not create connection");
/*text variables*/
$filename = "pba.txt";
$file=file($filename);
while(list(,$value)=each($file))
{
list($First_Name,$Last_Name,$Company,$Address,$City,$State,$Zip_Code,$Active,$Work_Phone,$Fax_Phone,$Email,$Member_Class,$Type)=split( "\,", $value);
$First_Name = ucwords(strtolower($First_Name));
$Last_Name = ucwords(strtolower($Last_Name));
$Company = ucwords(strtolower($Company));
$Address = ucwords(strtolower($Address));
$City = ucwords(strtolower($City));
$State = ucwords(strtolower($State));
$Zip_Code = ucwords(strtolower($Zip_Code));
$Active = ucwords(strtolower($Active));
$Work_Phone = ucwords(strtolower($Work_Phone));
$Home_Phone = ucwords(strtolower($Home_Phone));
$Fax_Phone = ucwords(strtolower($Fax_Phone));
$Email = trim(strtolower($Email));
$Type = ucwords(strtolower($Type));
/*inserting text into database*/
$sql = "INSERT INTO $table_name (First_Name, Last_Name, Company, Address, City, State, Zip_Code, Active, Work_Phone, Fax_Phone, Email, Member_Class, Type)
VALUES ("$First_Name", "$Last_Name", "$Company", "$Address", "$City", "$State", "$Zip_Code", "$Active", "$Work_Phone", "$Fax_Phone", "$Email", "$Member_Class", "$Type")";
mysql_query($sql, $connection) or die("could not execute query");
}
?>at first i posted in Db because of it dealing with Mysql but realized it's technically a php command that may be buggin me...
Any helpis appreciated!