$hostname_itelecom = "localhost:3306";
$database_itelecom = "itele_center";
$username_itelecom = "central";
$password_itelecom = "dkn49g3lg";
$itelecom = mysql_pconnect($hostname_itelecom, $username_itelecom, $password_itelecom) or die(mysql_error());
mysql_select_db($database_itelecom,$itelecom);
?>
$query = "SELECT * FROM industries ORDER BY industry_name";
$query_result = mysql_query($query) or die ('This query could not be performed');
while ($row = mysql_fetch_array($query_result,MYSQL_ASSOC)){
$industries[] = $row;
}
if(isset($_POST['name'])){
$name=$_POST['name'];
$company=htmlspecialchars($_POST['company']);
$position=$_POST['position'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$state=$_POST['state'];
$industry=$_POST['industry'];
$phoneSystem=$_POST['phoneSystem'];
$businessType=$_POST['businessType'];
$handset=$_POST['handset'];
$lines=$_POST['lines'];
$splrequirements= $_POST['splrequirements'];
$interests[] = $_POST['interest'];
if(count($interests[0]) != 0){
foreach($interests[0] as $int){
$interest .= $int."\n";
}
}
if(isset($_SESSION['gkw'])){
$keyword=$_SESSION['gkw'];
}else{
$keyword="";
}
require_once "mailer/lib/Swift.php";
require_once "mailer/lib/Swift/Connection/SMTP.php";
//Connect to localhost on port 25
$swift = new Swift(new Swift_Connection_SMTP("localhost"));
$HTMLMessage .= "CONTACT DETAILS\n".
"Full Name :".$name."\n".
"Company Name :".$company."\n".
"Industry :".$industry."\n".
"Position :".$position."\n".
"Phone :".$phone."\n".
"Email address :".$email."\n".
"State :".$state."\n".
"REQUIREMENTS: "."\n".
"I require a :".$phoneSystem."\n".
"I need this because :".$businessType."\n".
"Company Size :".$handset."\n".
"No. of lines :".$lines."\n".
"Special Requirement :".$splrequirements."\n".
"OTHER INTERESTS :"."\n".
"I'm interested in :".$interest."\n".
"Keyword : ".$keyword."";
$requirements ="REQUIREMENTS :".
"
I require a :".$phoneSystem.
"
I need this because :".$businessType.
"
Company Sizet :".$handset.
"
No. of lines :".$lines.
"
Requirements :".$splrequirements.
"
I'm interested in :".$interest;
$querystr="Insert into equote(domain,name,company,industry,position,phone,email,state,quote_date,requirements,keyword) values('Avaya','".
$name."','".$company."','".$industry."','".$position."','".$phone."','".$email."','".$state."','".date("Y-m-d H:i")."','".htmlspecialchars(addslashes($requirements))."','".
$keyword."')";
$result = mysql_query($querystr);
/*
if($industry != ""){
$query = "SELECT * FROM industries WHERE industry_name='$industry'";
$query_result = mysql_query($query);
$row = mysql_fetch_array($query_result,MYSQL_ASSOC);
if(count($row) != 0){
$casestudy=$row['attachment'];
$emailcontent=$row['email_content'];
}else{
$casestudy="";
$emailcontent="";
}
}
*/
$message = new Swift_Message("E-quote from Avaya");
//Create the message
$message->attach(new Swift_Message_Part($HTMLMessage));
//Now check if Swift actually sends it
$swift->send($message, "sales@itelecom.com.au", new Swift_Address("info@avaya-phones.com.au", 'Avaya Phones Admin'));
$swift->send($message, "leads@itelecom.com.au", new Swift_Address("info@avaya-phones.com.au", 'Avaya Phones Admin'));
/*
if($handset == "")
$options="phone system division";
if($handset == "Micro" || $handset == "Small")
$options="small business division";
if($handset == "Medium")
$options="medium business division";
if($handset == "Corporate")
$options="corporate division";
$customer_message="