1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Form with text line on top text

Discussion in 'PHP' started by afonseca, Jan 9, 2007.

  1. #1
    Hi all!

    We are experience a real strange error.
    We have a ecommerce site with a function that emails a list of products.
    This form has several fields like name, address, etc. And at the end presents the products divided with a line between then. Example

    Código: 100-254
    Quantidade: 1
    Preço unitário: 2,05
    Sub-total: 2,05
    -------------------------------------------------
    Código: 100-254
    Quantidade: 1
    Preço unitário: 2,05
    Sub-total: 2,05
    -------------------------------------------------


    Sometimes, we can't find a pattern, the last 2 fields of information and all the products appears with a line in the middle of the text (similar strikethrough style).

    <body>
    <p>C&oacute;digo: 100-254<br />
    Quantidade: 1<br />
    Pre&ccedil;o unit&aacute;rio: 2,05<br />
    Sub-total: 2,05<br />
    -------------------------------------------------<br />
    <s>C&oacute;digo: 100-254<br />
    Quantidade: 1<br />
    Pre&ccedil;o unit&aacute;rio: 2,05<br />
    Sub-total: 2,05</s><br />
    -------------------------------------------------</p>
    <p>&nbsp;</p>
    </body>

    We are lost. We can't understand what is happning because this happens in an irregular pattern.

    We sent below the code of the page that cotains the function.
    Any ideias?

    Thanks in advance
    António

    <?php require_once('Connections/medical.php'); ?>
    <? session_start(); ?>
    <html>
    <head>
    <title>Formulário</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <link href="medical.css" rel="stylesheet" type="text/css">
    <script language="Javascript1.2">


    var message = "imprimir esta página";

    function printpage() {
    window.print();
    }

    //document.write("<form><input type=button "
    //+"value=\""+message+"\" onClick=\"printpage()\"></form>");

    //-->
    </script><link href="images/medical.css" rel="stylesheet" type="text/css">
    <style type="text/css">
    <!--
    body {
    margin-left: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
    margin-top: 0px;
    }
    -->
    </style></head>

    <body>
    <table width="500" border="0" cellspacing="8" cellpadding="0">
    <tr>
    <td><img src="images/logobv2.gif" width="163" height="47"></td>
    <td valign="bottom" class="texto"><div align="right"><a href="index.php" class="linkc">&lt;&lt;voltar</a></div></td>
    </tr>
    <tr>
    <td height="2" colspan="2" valign="bottom"><hr size='1' color='#006633' noshade> </td>
    </tr>
    <tr>
    <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
    <td colspan="2"><?php
    include("db.php");

    $data = date("d-m-Y,G:i");
    $to = "geral@bastosviegas.com"; //
    $nr = $_POST['nr'];
    $name = $_POST['nome'];
    $endereco = $_POST['end'];
    $localidade = $_POST['loc'];
    $cod_postal = $_POST['cod'];
    $pais = $_POST['pais'];
    $telefone = $_POST['tel'];
    $fax = $_POST['fax'];
    $profissao = $_POST['prof'];
    $actividade = $_POST['act'];
    $email = $_POST['mail'];
    $nrcont = $_POST['nrcont'];
    $sub = "Encomenda";
    $msg = $_POST['msg'];
    $headers = 'MIME-Version: 1.0' . "\r\n";
    $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $headers .="Dados do Cliente";

    //$EmailBody = "Nome: $name\nO Email: $email\nTelefone: $telefone\nEmpresa: $empresa\nMenssagem: $msg\n";


    if(empty($name) || empty($endereco) || empty($localidade) || empty($cod_postal) || empty($pais) || empty($telefone) || empty($profissao) || empty($actividade) || empty($email)) {
    echo "<div align='center'><font color='#006633' size=9 face='Verdana, Arial, Helvetica, sans-serif'><h5>N&atilde;o preencheu todos os campos obrigatorios - tente novamente.</h5></font></div>";
    echo " <meta http-equiv=\"refresh\" content=\"3;URL=encomendar.php\"> ";
    exit;
    }


    elseif(!ereg("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z&shy;]{2,3})$",
    $email)) {
    echo "<div align='center'><font color='#006633' size=9 face='Verdana, Arial, Helvetica, sans-serif'><h5>O Email que foi inserido n&atilde;o tem um formato valido, por favor insira um email valido</h5></font></div>";
    echo " <meta http-equiv=\"refresh\" content=\"3;URL=encomendar.php\"> ";
    exit;
    } else {

    echo "<div align='center'><font color='#006633' size=9 face='Verdana, Arial, Helvetica, sans-serif'><h5>Obrigado ".$name." os seus dados foram enviados com sucesso</h5></font></div>";
    print"<input alt=imprimir align='right' border=0 name=submit src='images/print.jpg' type=image onClick='printpage()'><br>";

    $mesage=msn($nr,$name,$endereco,$localidade,$cod_postal,$pais,$telefone,$fax,$profissao,$actividade,$email,$nrcont,$msg,$data);

    mailbody($nr,$name,$endereco,$localidade,$cod_postal,$pais,$telefone,$fax,$profissao,$actividade,$email,$nrcont,$msg,$data);

    mail($to, $sub, $mesage, $headers);

    $qrydrop = mysql_query("select * from cart where cookieId = '" . GetCartId() . "' order by cod asc");

    while($campos = mysql_fetch_array($qrydrop))
    {
    @mysql_query("delete from cart where cookieId = '" . GetCartId() . "' ");

    }
    // exit;
    }


    function mailbody($nr,$name,$endereco,$localidade,$cod_postal,$pais,$telefone,$fax,$profissao,$actividade,$email,$nrcont,$msg,$data){

    global $dbServer, $dbUser, $dbPass, $dbName;


    $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
    print"<font class='text1'>$data</font><br>";
    print "<font class='text1'>N&uacute;mero:</font> <font class='texto'>$nr</font><br>";
    print "<font class='text1'>Nome:</font> <font class='texto'>$name</font><br>";
    print "<font class='text1'>Endere&ccedil;o:</font> <font class='texto'>$endereco</font><br>";
    print "<font class='text1'>Localidade:</font> <font class='texto'>$localidade</font><br>";
    print "<font class='text1'>c&oacute;digo postal:</font> <font class='texto'>$cod_postal</font><br>";
    print "<font class='text1'>Pa&iacute;s:</font> <font class='texto'>$pais</font><br>";
    print "<font class='text1'>Telefone:</font> <font class='texto'>$telefone</font><br>";
    print "<font class='text1'>Fax:</font> <font class='texto'>$fax</font><br>";
    print "<font class='text1'>Profiss&atilde;o:</font> <font class='texto'>$profissao</font><br>";
    print "<font class='text1'>Actividade:</font> <font class='texto'>$actividade</font><br>";
    print "<font class='text1'>Email:</font> <font class='texto'>$email</font><br>";
    print "<font class='text1'>Contribuinte nr:</font> <font class='texto'>$nrcont</font><br>";
    print "<font class='text1'>Comentario:</font> <font class='texto'>$msg</font>";

    $result = mysql_query("select * from cart where cookieId = '" . GetCartId() . "' order by cod asc");
    $num=mysql_num_rows($result);
    print "<br><br><font color='#006633' class='text1'>Total de $num produtos no seu carrinho de compras.</font><br><br>";
    print "<table width='100%' cellspacing='0' cellpadding='0' border='0'>";
    print "<tr>";
    print "<td width='28%' height='25' bgcolor='#CCCCCC'><div align='left'><span class='linkum'><font face='verdana' size='1' color='white'><b>C&oacute;digo</b></font></span></div></td>";
    print"<td width='33%' bgcolor='#CCCCCC'><div align='left' class='linkum'>
    <div align='left' class='linkum'><font face='verdana' size='1' color='white'><b>Qtd</b></font></div>";
    print"</div></td>";
    print"<td width='33%' height='25' bgcolor='#CCCCCC'><div align='left'><font face='verdana' size='1' color='white'><b>Pre&ccedil;o uni.</b></font></div></td>";
    print"<td width='25%' height='25' bgcolor='#CCCCCC'><div align='left'><span class='linkum'><font face='verdana' size='1' color='white'><b>Sub Total </b></font></span></div></td>";
    print"</tr>";

    $total=0;
    while($row = mysql_fetch_array($result))
    {
    $preco=$row['preco'];
    $preco = str_replace(",",".",$preco);
    $query1 = mysql_query("select * from sub_produto where id=$row[itemId]");
    $dados = mysql_fetch_array($query1);
    $total+=floatval($preco);

    print"<tr>";
    print"<td width='28%' height='25' class='texto'><div align='left'> $row[cod] </div></td>";
    print "<td width='33%' align='left' class='texto'><div align='left'> $row[qty]</div></td>";
    print "<td width='33%' height='25' class='texto'><div align='left'>&euro; $dados[euro] </div></td>";
    print"<td width='18%' height='25' class='texto'><div align='left'>&euro;$row[preco]</div></td>";

    print"</tr>";
    print "<td colspan='4'><hr size='1' color='#CCCCCC' NOSHADE></td>";

    }

    $total=str_replace(".",",",$total);

    print"<tr>";
    print"<td colspan='3'><div align='right' class='text1'><strong>Total: &euro;$total<br></strong></div></td>";

    print"</tr>";
    }


    function msn($nr,$name,$endereco,$localidade,$cod_postal,$pais,$telefone,$fax,$profissao,$actividade,$email,$nrcont,$msg,$data){

    global $dbServer, $dbUser, $dbPass, $dbName;


    $cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

    $mail.= "<br><font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>N&uacute;mero:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$nr</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Nome:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$name</font><br>";
    $mail.="<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Endere&ccedil;o:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$endereco</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Localidade:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$localidade</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>c&oacute;digo postal:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$cod_postal</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Pa&iacute;s:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$pais</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Telefone:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$telefone</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Fax:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$fax</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Profiss&atilde;o:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$profissao</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Actividade:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$actividade</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Email:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$email</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Nr Contribuinte:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$nrcont</font><br>";
    $mail.= "<font face='Verdana, Arial, Helvetica, sans-serif' size='1'><strong>Mensagem:</strong></font> <font face='Verdana, Arial, Helvetica, sans-serif' size='1'>$msg</font>";

    $result = mysql_query("select * from cart where cookieId = '" . GetCartId() . "' order by cod asc");
    $num=mysql_num_rows($result);
    $mail.= "<br><br><font face='Verdana, Arial, Helvetica, sans-serif' size='1'>Total de $num produtos.</font><br><br>";
    $mail.="<td colspan='0'><hr size='1' NOSHADE></td>";
    $total=0;
    while($row = mysql_fetch_array($result))
    {
    $preco=$row['preco'];
    $preco = str_replace(",",".",$preco);
    $query1 = mysql_query("select * from sub_produto where id=$row[itemId]");
    $dados = mysql_fetch_array($query1);
    $total+=floatval($preco);


    $mail.= "<font face='verdana' size='1'>Código: $row[cod]</font>";
    $mail.="<br>";
    $mail.= "<font face='verdana' size='1'>Quantidade: $row[qty]</font>";
    $mail.="<br>";
    $mail.= "<font face='verdana' size='1'>Preço unitário: $dados[euro]</font>";
    $mail.="<br>";
    $mail.= "<font face='verdana' size='1'>Sub Total: $row[preco]</font>";
    $mail.="<td colspan='0'><hr size='1' NOSHADE></td><br>";


    }

    $total=str_replace(".",",",$total);

    $mail.="<tr>";
    $mail.="<td colspan='3'><div align='right'><font face='verdana' size='1'><strong>Total: &euro;$total</strong></font><br></div></td>";

    $mail.="</tr>";

    return($mail);
    }

    ?>
     
    afonseca, Jan 9, 2007 IP