function database($dbh)
{
$dbh=mysql_connect ("localhost", "glade_test", "milltarn22") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("glade_ems");
return $dbh;
}
function get_variables(&$code,&$staff_ID)
{
$code = $_REQUEST['code'];
$staff_ID = $_REQUEST['staff_ID'];
}
function main($code,$staff_ID)
{
echo'
EMCS
';
include 'control.php';
main_promotion($tel_number,$email_address);
echo'
';
}
function header_top_print()
{
echo'
Estate Maintenance Cleaning Services Ltd
';
}
function header_top()
{
echo'
Estate Maintenance Cleaning
Services Ltd
';
}
function main_left_print()
{
echo'
';
$label = "Window Cleaning"; $pic = "windows/windows0.png"; clean_divs_L($label,$pic);
echo'
';
$label = "Drain Cleaning"; $pic = "drain.png"; clean_divs_L($label,$pic);
echo'
';
$label = "Graffiti Removal"; $pic = "graffiti.png"; clean_divs_L($label,$pic);
echo'
';
$label = "Waste Removal"; $pic = "waste.png"; clean_divs_L($label,$pic);
echo'
';
echo'
';
}
function main_left()
{
echo'
';
$label = "Window Cleaning"; $pic = "windows1.png"; $link_page = "http://www.emcsclean.co.uk/promotion/windows.php"; clean_divs_shadowL($label,$pic,$link_page);
echo'
';
$label = "Drain Cleaning"; $pic = "drain.png"; $link_page = "http://www.emcsclean.co.uk/promotion/drain.php"; clean_divs_shadowL($label,$pic,$link_page);
echo'
';
$label = "Graffiti Removal"; $pic = "graffitix.png"; $link_page = "http://www.emcsclean.co.uk/promotion/graffiti.php"; clean_divs_shadowL($label,$pic,$link_page);
echo'
';
$label = "Waste Removal"; $pic = "waste.png"; $link_page = "http://www.emcsclean.co.uk/promotion/waste.php"; clean_divs_shadowL($label,$pic,$link_page);
echo'
';
echo'
';
}
function clean_divs_L($label,$pic)
{
echo'
';
}
function clean_divs_shadowL($label,$pic,$link_page)
{
echo'
';
}
function main_right()
{
echo'
';
/*$label = "Carpet & Upholstery"; $pic = "carpet.png"; $link_page = "http://www.emcsclean.co.uk/promotion/carpet.php"; clean_divs_shadowR($label,$pic,$link_page);
echo'
';*/
$label = "Carpet & Upholstery"; $pic = "carpet.png"; $link_page = "http://www.emcsclean.co.uk/promotion/carpet.php"; clean_divs_shadowR($label,$pic,$link_page);
echo'
';
$label = "Pressure Washing"; $pic = "pressure.png"; $link_page = "http://www.emcsclean.co.uk/promotion/pressure.php"; clean_divs_shadowR($label,$pic,$link_page);
echo'
';
$label = "Professional Clean"; $pic = "tenancy.png"; $link_page = "http://www.emcsclean.co.uk/promotion/tenancy.php"; clean_divs_shadowR($label,$pic,$link_page);
echo'
';
$label = "Oven Cleaning"; $pic = "oven.png"; $link_page = "http://www.emcsclean.co.uk/promotion/oven.php"; clean_divs_shadowR($label,$pic,$link_page);
echo'
';
echo'
';
}
function main_right_print()
{
echo'
';
$label = "Carpet Upholstery"; $pic = "carpet.png"; clean_divs_R($label,$pic);
echo'
';
$label = "Pressure Washing"; $pic = "pressure.png"; clean_divs_R($label,$pic);
echo'
';
$label = "Professional Clean"; $pic = "tenancy.png"; clean_divs_R($label,$pic);
echo'
';
$label = "Oven Cleaning"; $pic = "oven.png"; clean_divs_R($label,$pic);
echo'
';
echo'
';
}
function clean_divs_R($label,$pic)
{
echo'
';
}
function clean_divs_shadowR($label,$pic,$link_page)
{
echo'
';
}
function offer_message(&$main_head,&$line1,&$line2,&$line3,&$line4,&$line5,&$line6,&$line7,
&$main_head_col,&$line1_col,&$line2_col,&$line3_col,&$line4_col,&$line5_col,&$line6_col,&$line7_col)
{
$dbh = database($dbh);
$query_line = "SELECT * FROM `promotion_clean`
WHERE `ID` = 1;";
$result_line = mysql_query ($query_line, $dbh);
//$main_head = mysql_result($result_line, 0, 'main_head');
$main_head = date("F Y");
$line1 = mysql_result($result_line, 0, 'line1');
$line2 = mysql_result($result_line, 0, 'line2');
$line3 = mysql_result($result_line, 0, 'line3');
$line4 = mysql_result($result_line, 0, 'line4');
$line5 = mysql_result($result_line, 0, 'line5');
$line6 = mysql_result($result_line, 0, 'line6');
$line7 = mysql_result($result_line, 0, 'line7');
$main_head_col = mysql_result($result_line, 0, 'main_head_col');
$line1_col = mysql_result($result_line, 0, 'line1_col');
$line2_col = mysql_result($result_line, 0, 'line2_col');
$line3_col = mysql_result($result_line, 0, 'line3_col');
$line4_col = mysql_result($result_line, 0, 'line4_col');
$line5_col = mysql_result($result_line, 0, 'line5_col');
$line6_col = mysql_result($result_line, 0, 'line6_col');
$line7_col = mysql_result($result_line, 0, 'line7_col');
}
function main_center()
{
offer_message($main_head,$line1,$line2,$line3,$line4,$line5,$line6,$line7,
$main_head_col,$line1_col,$line2_col,$line3_col,$line4_col,$line5_col,$line6_col,$line7_col);
echo'
';
echo'
';
echo'
';
echo'
';
}
function main_center_print()
{
echo'
';
echo'
';
echo'
';
echo'
';
}
function main_bottom($tel_number,$email_address)
{
echo'
'.$tel_number.'
'.$email_address.'
';
}
function main_bottom_print($tel_number,$email_address)
{
echo'
'.$tel_number.'
'.$email_address.'
';
}
function main_promotion($tel_number,$email_address)
{
echo'
';
header_top_print();
header_top();
main_left();
main_left_print();
echo'
';
main_center();
main_center_print();
echo'
';
main_right();
main_right_print();
main_bottom($tel_number,$email_address);
main_bottom_print($tel_number,$email_address);
echo'
';
}
function space_div()
{
echo'
';
}
function enter_date_time_site_isp()
{
$date = date("d M y");
$time = date("G:i:s");
$site = "Main";
$ISP = gethostbyaddr($_SERVER['REMOTE_ADDR']);
//echo"Date = ",$date,"
Time = ",$time,"
Site = ",$site,"
ISP = ",$isp;
$dbh = database($dbh);
$query_counter = mysql_query ("
INSERT INTO `promotion_history`
(`ID`, `date`, `time`, `site`, `ISP`)
VALUES
('', '$date', '$time', '$site', '$ISP')");
mysql_query ($query_counter,$dbh);
}
//enter_date_time_site_isp();
get_variables($code,$staff_ID);
main($code,$staff_ID);
?>