The code below displays a web page with a background image. When I print it using a printer, it displays a white background. i.e it doesn't print the background image. please any help will be appreciate. <?php include('../lib/config.php'); include('../lib/common-functions.php'); session_start(); ($_SESSION['auth'] !='ok') ? header("location:../index.php") : NULL; $memberId = $_GET['mid']; $sql = "select * from members where member_id='$memberId'"; $result = mysql_query($sql) or die(mysql_error()); $member = mysql_fetch_array($result); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>NEWKINGS GLOBAL NETWORK LIMITED: CERTIFICATE</title> <link rel="stylesheet" href="css/certificate.css" /> <style type="text/css"> <!-- .style1 {font-size: 9px} .style6 { font-size: 12px; font-weight: bold; } .style7 { font-size: xx-large; font-weight: bold; font-family: Arial, Helvetica, sans-serif; color: #990000; } .style10 {font-family: Arial, Helvetica, sans-serif} .style11 { color: #0099CC; font-weight: bold; } .style14 { color: #FFFFFF; font-weight: bold; font-family: Arial, Helvetica, sans-serif; } .style16 {font-family: Arial, Helvetica, sans-serif; font-weight: bold; } .datacells { font-family: Arial, Helvetica, sans-serif; background-color: #FFFFCC; text-align: center; word-spacing: normal; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #333333; border-right-color: #333333; border-bottom-color: #333333; border-left-color: #333333; } .style20 {color: #3366FF; font-weight: bold; font-family: Arial, Helvetica, sans-serif; } .style21 {font-family: Arial, Helvetica, sans-serif; background-color: #FFFFCC; text-align: center; word-spacing: normal; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #333333; border-right-color: #333333; border-bottom-color: #333333; border-left-color: #333333; color: #3366FF; } .style22 {font-weight: bold; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;} .style23 {font-family: Arial, Helvetica, sans-serif; background-color: #FFFFCC; text-align: center; word-spacing: normal; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #333333; border-right-color: #333333; border-bottom-color: #333333; border-left-color: #333333; font-weight: bold; } --> body { background-image: url(images/sapphire.jpg); ?>); background-repeat: repeat; margin-top: 10px; margin-left: 15px; } </style> </head> <body> <div> <table width="100%" style="background-repeat:repeat; border:#000000; border:solid"> <tr> <td> <table width="98%" class="top1"> <tr> <td width="146" class="style10"><span class="style11"><font color="Black"><?php echo getPlanName($member['plan_id']); ?> PLAN</font></span><BR /> <span class="style6">NIGERIAN <s>N</s><?php echo getPlanNairaFee($member['plan_id']); ?><br /> OTHER NATIONS USD <?php echo getPlanDollarFee($member['plan_id']); ?> </span></td> <td width="653"> </td> <td width="158"> </td> </tr> <tr> <td height="77" align="right"><img src="images/crown.jpeg" /></td> <td align="center" valign="top"><span class="style7">NEWKINGS GLOBAL NETWORK LIMITED</span><span class="style10"><br /> </span> <div align="center" class="style10"><strong><em>(NEWKINGS CLUB)</em></strong></div></td> <td><BR /><br /> <span class="style10"><strong><?php echo RC_NO; ?></strong></span></td> </tr> <tr> <td colspan="3" valign="bottom"><BR /> <span class="style16"> MEMBER REG NO: <?php echo getMemberRegno($member['member_id']); ?><BR /> CERTIFICATE NO: NK<?php echo strrev(getMemberRegno($member['member_id'])); ?> </span><span class="style16"> <?php $dateCreated = $member['date_created']; $date = explode("-", $dateCreated);?> ACTIVATE CERTIFICATE BEFORE: <?php $date= mktime (0,0,0,$date[1] ,$date[2]+CERT_LIFESPAN,$date[0]); echo date("F j, Y", $date); ?></span></td> </tr> </table> <table width="95%" class="datatable" style="background-color:#99CCFF" align="center"> <tr> <td width="61" align="center" class="datacells"><span class="style20">LEVEL</span></td> <td width="260" align="center" class="datacells"><span class="style20">NAME</span></td> <td width="184" align="center" class="datacells"><span class="style20">BANK DETAILS</span></td> <td width="169" class="datacells"><span class="style20">NO. OF CERTIFICATE</span></td> <td colspan="2" align="center" class="style21"><p class="style22">AMOUNT PAYABLE</p> <p class="style10"><strong><span class="style1">NIGERIA (<s>N</s>)</span> <span class="style1"> OTHER NATIONS(USD)</span></strong></p></td> <td colspan="2" class="style21"><span class="style22">TOTAL AMOUNT EARNABLE FOR LEVEL</span> <p class="style10"><strong><span class="style1">NIGERIA (<s>N</s>)</span> <span class="style1"> OTHER NATIONS(USD)</span></strong></p></td> </tr> <?php $upline = get7Uplines($memberId); for ($i=6; $i>=0; $i--) { ?> <tr> <td align="center" class="datacells"><strong><?php echo $i+1; ?></strong></td> <td align="center" class="datacells"><strong><?php echo getMemberFullname($upline[$i]); ?></strong></td> <td align="center" class="datacells"><strong><?php echo getMemberBankDetails($upline[$i]); ?></strong></td> <td align="center" class="datacells"><strong><?php echo number_format(getLevelNoOfCerts($i+1),0); ?></strong></td> <td width="66" align="center" class="datacells"><strong><?php echo getPlanNairaPayable(getMemberPlan($memberId)); ?></strong></td> <td width="97" align="center" class="datacells"><strong><?php echo getPlanDollarPayable(getMemberPlan($memberId)); ?></strong></td> <td width="121" class="datacells"><strong><?php echo number_format(getLevelNoOfCerts($i+1) * getPlanNairaPayable(getMemberPlan($memberId)),0); ?></strong></td> <td width="134" class="datacells"><strong><?php echo number_format(getLevelNoOfCerts($i+1) * getPlanDollarPayable(getMemberPlan($memberId)),0); ?></strong></td> </tr> <?php $totalNairaFullCyc += getLevelNoOfCerts($i+1) * getPlanNairaPayable(getMemberPlan($memberId)); $totalDollarFullCyc += getLevelNoOfCerts($i +1) * getPlanDollarPayable(getMemberPlan($memberId)); } ?> <tr> <td colspan="8" class="datacells" align="left"><span class="style10"><strong>NEWKINGS GLOBAL NETWORK LIMITED FIRST BANK PLC. ACCOUNT NO:<?php $compAccount = getCompanyAccount(); echo $compAccount['number']; ?></strong></span></td> </tr> <tr> <td colspan="8" class="datacells" align="left"><span class="style10"><strong>NEWKINGS GLOBAL NETWORK LIMITED FIRST BANK PLC. ACCOUNT NO:<?php $compAccount2 = getCompanyAccount2(); echo $compAccount2['number']; ?></strong></span></td> </tr> </table> <table width="95%" border="0" align="center"> <tr> <td width="47%"><span class="style16"><br />TOTAL AMOUNT EARNABLE ON FULL CYCLE:</span></td> <td width="53%" rowspan="2" align="center" valign="top"><span class="style14"><font color="Black">MOTTO:</font></span><BR /> <span class="style10"><strong>PEOPLE HELPING PEOPLE<BR /> ACHIEVE THEIR DREAMS</strong></span></td> </tr> <tr> <td><span class="style16"><s>N</s> <?php echo number_format($totalNairaFullCyc,0); ?> (NIGERIA) USD <?php echo number_format($totalDollarFullCyc,0); ?> (OTHER NATIONS)</span></td> </tr> </table> </td> </tr> </table> </div> <p> </p> </body> </html>
Bro, there is no error in your code. Do change in your internet explorer, Click on tools - Internet Options - Select Printing Background - OK You are done and see the result.......Best of Luck
Ouch. Not sure about background printing, but you definitely don't want to insert unchecked values into SQL queries to get your website h4xxx0rd via SQL injection.