Guilherme Toneloto

opa já consegui, resolvi no site que o amigo ESerra passou Vlw

oi galera , montei um script para mandar email aos usuários do meu site. nele tem a parte para colocar anexos, eu tentei colocar uma barra de progresso, pois quando o arquivo é muito grande demora um pouco para enviar, gostaria de saber se alguém me ajuda a incorporar um script de barra de status que achei na net com o meu script. Link do sistema de barra de status http://www.ajaxf1.com/download.html?dl=12 <? if($acao == "enviar_email") { ?> <tr> <td height="21" class="myBox2"> &lt;script type="text/javascript" src="Js/tiny_mce/tiny_mce.js"></script> &lt;script type="text/javascript"> tinyMCE.init({ mode : "textareas", language : "pt", theme : "advanced", plugins : "xhtmlxtras,safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template", theme_advanced_buttons1 : "save,newdocument,separator,bold,italic,underline,separator,strikethrough,justifyleft,justifycenter,justifyright,justifyfull,separator,formatselect,fontselect,fontsizeselect,bullist,numlist,undo,redo,link,unlink,image,forecolor,hr,separator,removeformat,charmap,iespell,ltr,rtl,separator,insertlayer,emotions,media", theme_advanced_buttons2 : "styleselect,separator,,pasteword,fullscreen,preview,", theme_advanced_toolbar_location : "top", theme_advanced_toolbar_align : "left", theme_advanced_statusbar_location : "bottom", theme_advanced_resizing : true, content_css : "css/content.css", }); </script> <? include("menu.php"); ?> <form action="conecxao/funcao.php?acao=email" method="post" enctype="multipart/form-data" > <table width="61%" border="0" align="left" class="texto_geral"> <tr> <td><a href="index.php?acao=ver_pasta_email"><img src="../Images/email_ver.png" width="32" height="32" border="0"></a></td> <td> </td> </tr> <tr> <td width="13%">Assunto:</td> <td width="87%"><input name="assunto" type="text" id="assunto" size="60"></td> </tr> <tr> <td>Anexo:</td> <td><font color="#CCCCCC"> <input name = "arquivo" type = "file" id="arquivo"> </font> </td> </tr> <tr> <td height="26">Email</td> <td><select name="email" id="select7" style="width: 388;"> <?php include("conecxao/conecta.php"); $query_email="SELECT * FROM cadastro"; $result=mysql_query($query_email); while($resultado = mysql_fetch_array($result)) { $email = $resultado['email']; $nome = $resultado['nome']; echo("<option value=$email >$nome</option>"); } ?> </select> </td> </tr> <tr> <td height="24"> </td> <td>Mensagem <textarea name="mensagem" cols="30" id="textarea4"></textarea></td> </tr> <tr> <td> </td> <td><input type="submit" name="btn_enviar2" id="btn_enviar" value="Enviar Email"></td> </tr> <tr> <td> </td> <td> </td> </tr> </table> </form></td> </tr> <? } ?>

Warning: Variable passed to each() is not an array or object in E:\Site\teste.php on line 38 Warning: Variable passed to each() is not an array or object in E:\Site\teste.php on line 52 Warning: Variable passed to each() is not an array or object in E:\Site\teste.php on line 75 Desculpe o servidor não conseguiu receber o upload dos arquivos não foi, esta dando esses erros

Oi pessoal, estou com um script para amndar email, ele vai certinho, eu gostaria que ele mandasse anexos junto com ele. o que eu devo adicionar no script. Eu adicionei uma linha com a variável do anexo da pagina do formulário. include("email/class.phpmailer.php"); $mail = new PHPMailer(); $mail->IsSMTP(); $mail->Host = "smtp.mail.yahoo.com.br"; $mail->SMTPAuth = true; $mail->Username = "guilhermetoneloto@yahoo.com"; $mail->Password = "33521125"; $mail->From = "guilhermetoneloto@yahoo.com"; $mail->FromName = "Toneloto's Server"; $mail->AddAddress("$email","usuário");; $mail->WordWrap = 50; $mail->AddAttachment("$anexo"); $mail->IsHTML(true); if(isset($_POST['nome'])){ $nome = $_POST['nome']; $email = $_POST['email']; $mensagem = $_POST['mensagem']; $mail->AddReplyTo("$email","$nome"); } $mail->Subject = "$assunto"; $mail->Body = " <style> a.link_email:link {text-decoration: none; color: #0099FF;} a.link_email:visited {text-decoration: none; color: #0099FF;} a.link_email:hover {text-decoration: none; color: #0099FF; } a.link_email:active {text-decoration: none; color: #0099FF;} </style> <div align=\"center\"> <table width=\"100%\" border=\"0\"> <tr> <td height=\"14\"> <p align=\"center\"><font color=\"#000066\" size=\"5\">Mensagem enviada pelo site Toneloto's Server.</font></p> </td> </tr> <tr> <td height=\"27\">Data de envio: <font color=\"#999999\">$data</font></td> </tr> </table> </div> <hr> $mensagem\n <hr> <p>&nbsp;</p> <p>&nbsp;</p>"; if(!$mail->Send()) { echo "houve um erro ao enviar o email! erro: $mail->ErrorInfo"; exit; } echo "Mensagem enviada ok"; }

eu já tinha conseguido logo depois que coloquei aqui, foi mal awe, mais obrigado mesmo assim.

Oi pessoal eu estou com um scripr que peguei na internet pra enviar email via smtp pelo msu site, mais estou com um problema e espero que alguém posso me ajudar, este scritp já vem col local de email e envia sosinho toda vez que abre ele, eu gostaria de criar um formulario par que eu posso adicionar o email separadamente. index.php <? #inclui a classe PHPMAILER include("class.phpmailer.php"); #instancia o objeto $mail = new PHPMailer(); #enviar via SMTP $mail->IsSMTP(); #seu servidor smtp / dominio no meu caso "mail" mas pode mudar verifique o seu! $mail->Host = "smtp.mail.yahoo.com.br"; #habilita smtp autenticado $mail->SMTPAuth = true; #usuário deste servidor smtp. Aqui esta a solucao $mail->Username = "guilhermetoneloto@yahoo.com"; $mail->Password = "0123456789"; // senha #email utilizado para o envio, pode ser o mesmo de username $mail->From = "guilhermetoneloto@yahoo.com"; $mail->FromName = "NOME DE EXIBICAO"; #Enderecos que devem receber a mensagem $mail->AddAddress("guitoneloto@hotmail.com","Vendas"); $mail->AddAddress("guitoneloto@hotmail.com","Financeiro"); #wrap seta o tamanhdo do texto por linha $mail->WordWrap = 50; #anexando arquivos no email (supondo estar no mesmo diretorio) $mail->AddAttachment("arquivo.zip"); $mail->AddAttachment("foto.jpg"); $mail->IsHTML(true); //enviar em HTML #recebendo os dados do formulario if(isset($_POST['nome'])){ $nome = $_POST['nome']; $email = $_POST['email']; $mensagem = $_POST['mensagem']; #informando a quem devemos responder. o mail inserido no formulario $mail->AddReplyTo("$email","$nome"); #criando o codigo html para enviar no email, voce pode utilizar qualquer tag html $msg = "Contato Site"; $msg .= " Nome: $nome\n"; $msg .= " E-mail: $email\n"; $msg .= " Mensagem: $mensagem\n"; } $mail->Subject = "ASSUNTO DO EMAIL"; #adicionando o html no corpo do email $mail->Body = $msg; #enviando e retornando o status de envio if(!$mail->Send()) { echo "houve um erro ao enviar o email! erro: $mail->ErrorInfo"; #$mail->ErrorInfo informa onde ocorreu o erro, o uso opcional exit; } echo "Mensagem enviada ok"; ?> class.phpmailer.php <?php class PHPMailer { /** * Email priority (1 = High, 3 = Normal, 5 = low). * @var int */ public $Priority = 3; /** * Sets the CharSet of the message. * @var string */ public $CharSet = 'iso-8859-1'; /** * Sets the Content-type of the message. * @var string */ public $ContentType = 'text/plain'; /** * Sets the Encoding of the message. Options for this are "8bit", * "7bit", "binary", "base64", and "quoted-printable". * @var string */ public $Encoding = '8bit'; /** * Holds the most recent mailer error message. * @var string */ public $ErrorInfo = ''; /** * Sets the From email address for the message. * @var string */ public $From = 'root@localhost'; /** * Sets the From name of the message. * @var string */ public $FromName = 'Root User'; /** * Sets the Sender email (Return-Path) of the message. If not empty, * will be sent via -f to sendmail or as 'MAIL FROM' in smtp mode. * @var string */ public $Sender = ''; /** * Sets the Subject of the message. * @var string */ public $Subject = ''; /** * Sets the Body of the message. This can be either an HTML or text body. * If HTML then run IsHTML(true). * @var string */ public $Body = ''; /** * Sets the text-only body of the message. This automatically sets the * email to multipart/alternative. This body can be read by mail * clients that do not have HTML email capability such as mutt. Clients * that can read HTML will view the normal Body. * @var string */ public $AltBody = ''; /** * Sets word wrapping on the body of the message to a given number of * characters. * @var int */ public $WordWrap = 0; /** * Method to send mail: ("mail", "sendmail", or "smtp"). * @var string */ public $Mailer = 'mail'; /** * Sets the path of the sendmail program. * @var string */ public $Sendmail = '/usr/sbin/sendmail'; /** * Path to PHPMailer plugins. This is now only useful if the SMTP class * is in a different directory than the PHP include path. * @var string */ public $PluginDir = ''; /** * Holds PHPMailer version. * @var string */ public $Version = "2.3"; /** * Sets the email address that a reading confirmation will be sent. * @var string */ public $ConfirmReadingTo = ''; /** * Sets the hostname to use in Message-Id and Received headers * and as default HELO string. If empty, the value returned * by SERVER_NAME is used or 'localhost.localdomain'. * @var string */ public $Hostname = ''; /** * Sets the message ID to be used in the Message-Id header. * If empty, a unique id will be generated. * @var string */ public $MessageID = ''; ///////////////////////////////////////////////// // PROPERTIES FOR SMTP ///////////////////////////////////////////////// /** * Sets the SMTP hosts. All hosts must be separated by a * semicolon. You can also specify a different port * for each host by using this format: [hostname:port] * (e.g. "smtp1.example.com:25;smtp2.example.com"). * Hosts will be tried in order. * @var string */ public $Host = 'localhost'; /** * Sets the default SMTP server port. * @var int */ public $Port = 25; /** * Sets the SMTP HELO of the message (Default is $Hostname). * @var string */ public $Helo = ''; /** * Sets connection prefix. * Options are "", "ssl" or "tls" * @var string */ public $SMTPSecure = ""; /** * Sets SMTP authentication. Utilizes the Username and Password variables. * @var bool */ public $SMTPAuth = false; /** * Sets SMTP username. * @var string */ public $Username = ''; /** * Sets SMTP password. * @var string */ public $Password = ''; /** * Sets the SMTP server timeout in seconds. This function will not * work with the win32 version. * @var int */ public $Timeout = 10; /** * Sets SMTP class debugging on or off. * @var bool */ public $SMTPDebug = false; /** * Prevents the SMTP connection from being closed after each mail * sending. If this is set to true then to close the connection * requires an explicit call to SmtpClose(). * @var bool */ public $SMTPKeepAlive = false; /** * Provides the ability to have the TO field process individual * emails, instead of sending to entire TO addresses * @var bool */ public $SingleTo = false; /** * Provides the ability to change the line ending * @var string */ public $LE = "\r\n"; ///////////////////////////////////////////////// // PROPERTIES, PRIVATE ///////////////////////////////////////////////// private $smtp = NULL; private $to = array(); private $cc = array(); private $bcc = array(); private $ReplyTo = array(); private $attachment = array(); private $CustomHeader = array(); private $message_type = ''; private $boundary = array(); private $language = array(); private $error_count = 0; private $sign_cert_file = ""; private $sign_key_file = ""; private $sign_key_pass = ""; ///////////////////////////////////////////////// // METHODS, VARIABLES ///////////////////////////////////////////////// /** * Sets message type to HTML. * @param bool $bool * @return void */ public function IsHTML($bool) { if($bool == true) { $this->ContentType = 'text/html'; } else { $this->ContentType = 'text/plain'; } } /** * Sets Mailer to send message using SMTP. * @return void */ public function IsSMTP() { $this->Mailer = 'smtp'; } /** * Sets Mailer to send message using PHP mail() function. * @return void */ public function IsMail() { $this->Mailer = 'mail'; } /** * Sets Mailer to send message using the $Sendmail program. * @return void */ public function IsSendmail() { $this->Mailer = 'sendmail'; } /** * Sets Mailer to send message using the qmail MTA. * @return void */ public function IsQmail() { $this->Sendmail = '/var/qmail/bin/sendmail'; $this->Mailer = 'sendmail'; } ///////////////////////////////////////////////// // METHODS, RECIPIENTS ///////////////////////////////////////////////// /** * Adds a "To" address. * @param string $address * @param string $name * @return void */ public function AddAddress($address, $name = '') { $cur = count($this->to); $this->to[$cur][0] = trim($address); $this->to[$cur][1] = $name; } /** * Adds a "Cc" address. Note: this function works * with the SMTP mailer on win32, not with the "mail" * mailer. * @param string $address * @param string $name * @return void */ public function AddCC($address, $name = '') { $cur = count($this->cc); $this->cc[$cur][0] = trim($address); $this->cc[$cur][1] = $name; } /** * Adds a "Bcc" address. Note: this function works * with the SMTP mailer on win32, not with the "mail" * mailer. * @param string $address * @param string $name * @return void */ public function AddBCC($address, $name = '') { $cur = count($this->bcc); $this->bcc[$cur][0] = trim($address); $this->bcc[$cur][1] = $name; } /** * Adds a "Reply-to" address. * @param string $address * @param string $name * @return void */ public function AddReplyTo($address, $name = '') { $cur = count($this->ReplyTo); $this->ReplyTo[$cur][0] = trim($address); $this->ReplyTo[$cur][1] = $name; } ///////////////////////////////////////////////// // METHODS, MAIL SENDING ///////////////////////////////////////////////// /** * Creates message and assigns Mailer. If the message is * not sent successfully then it returns false. Use the ErrorInfo * variable to view description of the error. * @return bool */ public function Send() { $header = ''; $body = ''; $result = true; if((count($this->to) + count($this->cc) + count($this->bcc)) < 1) { $this->SetError($this->Lang('provide_address')); return false; } /* Set whether the message is multipart/alternative */ if(!empty($this->AltBody)) { $this->ContentType = 'multipart/alternative'; } $this->error_count = 0; // reset errors $this->SetMessageType(); $header .= $this->CreateHeader(); $body = $this->CreateBody(); if($body == '') { return false; } /* Choose the mailer */ switch($this->Mailer) { case 'sendmail': $result = $this->SendmailSend($header, $body); break; case 'smtp': $result = $this->SmtpSend($header, $body); break; case 'mail': $result = $this->MailSend($header, $body); break; default: $result = $this->MailSend($header, $body); break; //$this->SetError($this->Mailer . $this->Lang('mailer_not_supported')); //$result = false; //break; } return $result; } /** * Sends mail using the $Sendmail program. * @access public * @return bool */ public function SendmailSend($header, $body) { if ($this->Sender != '') { $sendmail = sprintf("%s -oi -f %s -t", escapeshellcmd($this->Sendmail), escapeshellarg($this->Sender)); } else { $sendmail = sprintf("%s -oi -t", escapeshellcmd($this->Sendmail)); } if(!@$mail = popen($sendmail, 'w')) { $this->SetError($this->Lang('execute') . $this->Sendmail); return false; } fputs($mail, $header); fputs($mail, $body); $result = pclose($mail); if (version_compare(phpversion(), '4.2.3') == -1) { $result = $result >> 8 & 0xFF; } if($result != 0) { $this->SetError($this->Lang('execute') . $this->Sendmail); return false; } return true; } /** * Sends mail using the PHP mail() function. * @access public * @return bool */ public function MailSend($header, $body) { $to = ''; for($i = 0; $i < count($this->to); $i++) { if($i != 0) { $to .= ', '; } $to .= $this->AddrFormat($this->to[$i]); } $toArr = split(',', $to); $params = sprintf("-oi -f %s", $this->Sender); if ($this->Sender != '' && strlen(ini_get('safe_mode'))< 1) { $old_from = ini_get('sendmail_from'); ini_set('sendmail_from', $this->Sender); if ($this->SingleTo === true && count($toArr) > 1) { foreach ($toArr as $key => $val) { $rt = @mail($val, $this->EncodeHeader($this->SecureHeader($this->Subject)), $body, $header, $params); } } else { $rt = @mail($to, $this->EncodeHeader($this->SecureHeader($this->Subject)), $body, $header, $params); } } else { if ($this->SingleTo === true && count($toArr) > 1) { foreach ($toArr as $key => $val) { $rt = @mail($val, $this->EncodeHeader($this->SecureHeader($this->Subject)), $body, $header, $params); } } else { $rt = @mail($to, $this->EncodeHeader($this->SecureHeader($this->Subject)), $body, $header); } } if (isset($old_from)) { ini_set('sendmail_from', $old_from); } if(!$rt) { $this->SetError($this->Lang('instantiate')); return false; } return true; } /** * Sends mail via SMTP using PhpSMTP (Author: * Chris Ryan). Returns bool. Returns false if there is a * bad MAIL FROM, RCPT, or DATA input. * @access public * @return bool */ public function SmtpSend($header, $body) { include_once($this->PluginDir . 'class.smtp.php'); $error = ''; $bad_rcpt = array(); if(!$this->SmtpConnect()) { return false; } $smtp_from = ($this->Sender == '') ? $this->From : $this->Sender; if(!$this->smtp->Mail($smtp_from)) { $error = $this->Lang('from_failed') . $smtp_from; $this->SetError($error); $this->smtp->Reset(); return false; } /* Attempt to send attach all recipients */ for($i = 0; $i < count($this->to); $i++) { if(!$this->smtp->Recipient($this->to[$i][0])) { $bad_rcpt[] = $this->to[$i][0]; } } for($i = 0; $i < count($this->cc); $i++) { if(!$this->smtp->Recipient($this->cc[$i][0])) { $bad_rcpt[] = $this->cc[$i][0]; } } for($i = 0; $i < count($this->bcc); $i++) { if(!$this->smtp->Recipient($this->bcc[$i][0])) { $bad_rcpt[] = $this->bcc[$i][0]; } } if(count($bad_rcpt) > 0) { // Create error message for($i = 0; $i < count($bad_rcpt); $i++) { if($i != 0) { $error .= ', '; } $error .= $bad_rcpt[$i]; } $error = $this->Lang('recipients_failed') . $error; $this->SetError($error); $this->smtp->Reset(); return false; } if(!$this->smtp->Data($header . $body)) { $this->SetError($this->Lang('data_not_accepted')); $this->smtp->Reset(); return false; } if($this->SMTPKeepAlive == true) { $this->smtp->Reset(); } else { $this->SmtpClose(); } return true; } /** * Initiates a connection to an SMTP server. Returns false if the * operation failed. * @access public * @return bool */ public function SmtpConnect() { if($this->smtp == NULL) { $this->smtp = new SMTP(); } $this->smtp->do_debug = $this->SMTPDebug; $hosts = explode(';', $this->Host); $index = 0; $connection = ($this->smtp->Connected()); /* Retry while there is no connection */ while($index < count($hosts) && $connection == false) { $hostinfo = array(); if(eregi('^(.+):([0-9]+)$', $hosts[$index], $hostinfo)) { $host = $hostinfo[1]; $port = $hostinfo[2]; } else { $host = $hosts[$index]; $port = $this->Port; } $tls = ($this->SMTPSecure == 'tls'); $ssl = ($this->SMTPSecure == 'ssl'); if($this->smtp->Connect(($ssl ? 'ssl://':'').$host, $port, $this->Timeout)) { $hello = ($this->Helo != '' ? $this->Helo : $this->ServerHostname()); $this->smtp->Hello($hello); if($tls) { if(!$this->smtp->StartTLS()) { $this->SetError($this->Lang("tls")); $this->smtp->Reset(); $connection = false; } //We must resend HELLO after tls negociation $this->smtp->Hello($hello); } $connection = true; if($this->SMTPAuth) { if(!$this->smtp->Authenticate($this->Username, $this->Password)) { $this->SetError($this->Lang('authenticate')); $this->smtp->Reset(); $connection = false; } } } $index++; } if(!$connection) { $this->SetError($this->Lang('connect_host')); } return $connection; } /** * Closes the active SMTP session if one exists. * @return void */ public function SmtpClose() { if($this->smtp != NULL) { if($this->smtp->Connected()) { $this->smtp->Quit(); $this->smtp->Close(); } } } /** * Sets the language for all class error messages. Returns false * if it cannot load the language file. The default language type * is English. * @param string $lang_type Type of language (e.g. Portuguese: "br") * @param string $lang_path Path to the language file directory * @access public * @return bool */ function SetLanguage($lang_type = 'en', $lang_path = 'language/') { if( !(@include $lang_path.'phpmailer.lang-'.$lang_type.'.php') ) { $PHPMAILER_LANG = array(); $PHPMAILER_LANG["provide_address"] = 'You must provide at least one ' . $PHPMAILER_LANG["mailer_not_supported"] = ' mailer is not supported.'; $PHPMAILER_LANG["execute"] = 'Could not execute: '; $PHPMAILER_LANG["instantiate"] = 'Could not instantiate mail function.'; $PHPMAILER_LANG["authenticate"] = 'SMTP Error: Could not authenticate.'; $PHPMAILER_LANG["from_failed"] = 'The following From address failed: '; $PHPMAILER_LANG["recipients_failed"] = 'SMTP Error: The following ' . $PHPMAILER_LANG["data_not_accepted"] = 'SMTP Error: Data not accepted.'; $PHPMAILER_LANG["connect_host"] = 'SMTP Error: Could not connect to SMTP host.'; $PHPMAILER_LANG["file_access"] = 'Could not access file: '; $PHPMAILER_LANG["file_open"] = 'File Error: Could not open file: '; $PHPMAILER_LANG["encoding"] = 'Unknown encoding: '; $PHPMAILER_LANG["signing"] = 'Signing Error: '; } $this->language = $PHPMAILER_LANG; return true; } ///////////////////////////////////////////////// // METHODS, MESSAGE CREATION ///////////////////////////////////////////////// /** * Creates recipient headers. * @access public * @return string */ public function AddrAppend($type, $addr) { $addr_str = $type . ': '; $addr_str .= $this->AddrFormat($addr[0]); if(count($addr) > 1) { for($i = 1; $i < count($addr); $i++) { $addr_str .= ', ' . $this->AddrFormat($addr[$i]); } } $addr_str .= $this->LE; return $addr_str; } /** * Formats an address correctly. * @access public * @return string */ public function AddrFormat($addr) { if(empty($addr[1])) { $formatted = $this->SecureHeader($addr[0]); } else { $formatted = $this->EncodeHeader($this->SecureHeader($addr[1]), 'phrase') . " <" . $this->SecureHeader($addr[0]) . ">"; } return $formatted; } /** * Wraps message for use with mailers that do not * automatically perform wrapping and for quoted-printable. * Original written by philippe. * @access public * @return string */ public function WrapText($message, $length, $qp_mode = false) { $soft_break = ($qp_mode) ? sprintf(" =%s", $this->LE) : $this->LE; // If utf-8 encoding is used, we will need to make sure we don't // split multibyte characters when we wrap $is_utf8 = (strtolower($this->CharSet) == "utf-8"); $message = $this->FixEOL($message); if (substr($message, -1) == $this->LE) { $message = substr($message, 0, -1); } $line = explode($this->LE, $message); $message = ''; for ($i=0;$i < count($line); $i++) { $line_part = explode(' ', $line[$i]); $buf = ''; for ($e = 0; $e<count($line_part); $e++) { $word = $line_part[$e]; if ($qp_mode and (strlen($word) > $length)) { $space_left = $length - strlen($buf) - 1; if ($e != 0) { if ($space_left > 20) { $len = $space_left; if ($is_utf8) { $len = $this->UTF8CharBoundary($word, $len); } elseif (substr($word, $len - 1, 1) == "=") { $len--; } elseif (substr($word, $len - 2, 1) == "=") { $len -= 2; } $part = substr($word, 0, $len); $word = substr($word, $len); $buf .= ' ' . $part; $message .= $buf . sprintf("=%s", $this->LE); } else { $message .= $buf . $soft_break; } $buf = ''; } while (strlen($word) > 0) { $len = $length; if ($is_utf8) { $len = $this->UTF8CharBoundary($word, $len); } elseif (substr($word, $len - 1, 1) == "=") { $len--; } elseif (substr($word, $len - 2, 1) == "=") { $len -= 2; } $part = substr($word, 0, $len); $word = substr($word, $len); if (strlen($word) > 0) { $message .= $part . sprintf("=%s", $this->LE); } else { $buf = $part; } } } else { $buf_o = $buf; $buf .= ($e == 0) ? $word : (' ' . $word); if (strlen($buf) > $length and $buf_o != '') { $message .= $buf_o . $soft_break; $buf = $word; } } } $message .= $buf . $this->LE; } return $message; } /** * Finds last character boundary prior to maxLength in a utf-8 * quoted (printable) encoded string. * Original written by Colin Brown. * @access public * @param string $encodedText utf-8 QP text * @param int $maxLength find last character boundary prior to this length * @return int */ public function UTF8CharBoundary($encodedText, $maxLength) { $foundSplitPos = false; $lookBack = 3; while (!$foundSplitPos) { $lastChunk = substr($encodedText, $maxLength - $lookBack, $lookBack); $encodedCharPos = strpos($lastChunk, "="); if ($encodedCharPos !== false) { // Found start of encoded character byte within $lookBack block. // Check the encoded byte value (the 2 chars after the '=') $hex = substr($encodedText, $maxLength - $lookBack + $encodedCharPos + 1, 2); $dec = hexdec($hex); if ($dec < 128) { // Single byte character. // If the encoded char was found at pos 0, it will fit // otherwise reduce maxLength to start of the encoded char $maxLength = ($encodedCharPos == 0) ? $maxLength : $maxLength - ($lookBack - $encodedCharPos); $foundSplitPos = true; } elseif ($dec >= 192) { // First byte of a multi byte character // Reduce maxLength to split at start of character $maxLength = $maxLength - ($lookBack - $encodedCharPos); $foundSplitPos = true; } elseif ($dec < 192) { // Middle byte of a multi byte character, look further back $lookBack += 3; } } else { // No encoded character found $foundSplitPos = true; } } return $maxLength; } /** * Set the body wrapping. * @access public * @return void */ public function SetWordWrap() { if($this->WordWrap < 1) { return; } switch($this->message_type) { case 'alt': /* fall through */ case 'alt_attachments': $this->AltBody = $this->WrapText($this->AltBody, $this->WordWrap); break; default: $this->Body = $this->WrapText($this->Body, $this->WordWrap); break; } } /** * Assembles message header. * @access public * @return string */ public function CreateHeader() { $result = ''; /* Set the boundaries */ $uniq_id = md5(uniqid(time())); $this->boundary[1] = 'b1_' . $uniq_id; $this->boundary[2] = 'b2_' . $uniq_id; $result .= $this->HeaderLine('Date', $this->RFCDate()); if($this->Sender == '') { $result .= $this->HeaderLine('Return-Path', trim($this->From)); } else { $result .= $this->HeaderLine('Return-Path', trim($this->Sender)); } /* To be created automatically by mail() */ if($this->Mailer != 'mail') { if(count($this->to) > 0) { $result .= $this->AddrAppend('To', $this->to); } elseif (count($this->cc) == 0) { $result .= $this->HeaderLine('To', 'undisclosed-recipients:;'); } } $from = array(); $from[0][0] = trim($this->From); $from[0][1] = $this->FromName; $result .= $this->AddrAppend('From', $from); /* sendmail and mail() extract Cc from the header before sending */ if((($this->Mailer == 'sendmail') || ($this->Mailer == 'mail')) && (count($this->cc) > 0)) { $result .= $this->AddrAppend('Cc', $this->cc); } /* sendmail and mail() extract Bcc from the header before sending */ if((($this->Mailer == 'sendmail') || ($this->Mailer == 'mail')) && (count($this->bcc) > 0)) { $result .= $this->AddrAppend('Bcc', $this->bcc); } if(count($this->ReplyTo) > 0) { $result .= $this->AddrAppend('Reply-to', $this->ReplyTo); } /* mail() sets the subject itself */ if($this->Mailer != 'mail') { $result .= $this->HeaderLine('Subject', $this->EncodeHeader($this->SecureHeader($this->Subject))); } if($this->MessageID != '') { $result .= $this->HeaderLine('Message-ID',$this->MessageID); } else { $result .= sprintf("Message-ID: <%s@%s>%s", $uniq_id, $this->ServerHostname(), $this->LE); } $result .= $this->HeaderLine('X-Priority', $this->Priority); $result .= $this->HeaderLine('X-Mailer', 'PHPMailer (phpmailer.codeworxtech.com) [version ' . $this->Version . ']'); if($this->ConfirmReadingTo != '') { $result .= $this->HeaderLine('Disposition-Notification-To', '<' . trim($this->ConfirmReadingTo) . '>'); } // Add custom headers for($index = 0; $index < count($this->CustomHeader); $index++) { $result .= $this->HeaderLine(trim($this->CustomHeader[$index][0]), $this->EncodeHeader(trim($this->CustomHeader[$index][1]))); } if (!$this->sign_key_file) { $result .= $this->HeaderLine('MIME-Version', '1.0'); $result .= $this->GetMailMIME(); } return $result; } /** * Returns the message MIME. * @access public * @return string */ public function GetMailMIME() { $result = ''; switch($this->message_type) { case 'plain': $result .= $this->HeaderLine('Content-Transfer-Encoding', $this->Encoding); $result .= sprintf("Content-Type: %s; charset=\"%s\"", $this->ContentType, $this->CharSet); break; case 'attachments': /* fall through */ case 'alt_attachments': if($this->InlineImageExists()){ $result .= sprintf("Content-Type: %s;%s\ttype=\"text/html\";%s\tboundary=\"%s\"%s", 'multipart/related', $this->LE, $this->LE, $this->boundary[1], $this->LE); } else { $result .= $this->HeaderLine('Content-Type', 'multipart/mixed;'); $result .= $this->TextLine("\tboundary=\"" . $this->boundary[1] . '"'); } break; case 'alt': $result .= $this->HeaderLine('Content-Type', 'multipart/alternative;'); $result .= $this->TextLine("\tboundary=\"" . $this->boundary[1] . '"'); break; } if($this->Mailer != 'mail') { $result .= $this->LE.$this->LE; } return $result; } /** * Assembles the message body. Returns an empty string on failure. * @access public * @return string */ public function CreateBody() { $result = ''; if ($this->sign_key_file) { $result .= $this->GetMailMIME(); } $this->SetWordWrap(); switch($this->message_type) { case 'alt': $result .= $this->GetBoundary($this->boundary[1], '', 'text/plain', ''); $result .= $this->EncodeString($this->AltBody, $this->Encoding); $result .= $this->LE.$this->LE; $result .= $this->GetBoundary($this->boundary[1], '', 'text/html', ''); $result .= $this->EncodeString($this->Body, $this->Encoding); $result .= $this->LE.$this->LE; $result .= $this->EndBoundary($this->boundary[1]); break; case 'plain': $result .= $this->EncodeString($this->Body, $this->Encoding); break; case 'attachments': $result .= $this->GetBoundary($this->boundary[1], '', '', ''); $result .= $this->EncodeString($this->Body, $this->Encoding); $result .= $this->LE; $result .= $this->AttachAll(); break; case 'alt_attachments': $result .= sprintf("--%s%s", $this->boundary[1], $this->LE); $result .= sprintf("Content-Type: %s;%s" . "\tboundary=\"%s\"%s", 'multipart/alternative', $this->LE, $this->boundary[2], $this->LE.$this->LE); $result .= $this->GetBoundary($this->boundary[2], '', 'text/plain', '') . $this->LE; // Create text body $result .= $this->EncodeString($this->AltBody, $this->Encoding); $result .= $this->LE.$this->LE; $result .= $this->GetBoundary($this->boundary[2], '', 'text/html', '') . $this->LE; // Create the HTML body $result .= $this->EncodeString($this->Body, $this->Encoding); $result .= $this->LE.$this->LE; $result .= $this->EndBoundary($this->boundary[2]); $result .= $this->AttachAll(); break; } if($this->IsError()) { $result = ''; } else if ($this->sign_key_file) { $file = tempnam("", "mail"); $fp = fopen($file, "w"); fwrite($fp, $result); fclose($fp); $signed = tempnam("", "signed"); if (@openssl_pkcs7_sign($file, $signed, "file://".$this->sign_cert_file, array("file://".$this->sign_key_file, $this->sign_key_pass), null)) { $fp = fopen($signed, "r"); $result = ''; while(!feof($fp)){ $result = $result . fread($fp, 1024); } fclose($fp); } else { $this->SetError($this->Lang("signing").openssl_error_string()); $result = ''; } unlink($file); unlink($signed); } return $result; } /** * Returns the start of a message boundary. * @access public */ public function GetBoundary($boundary, $charSet, $contentType, $encoding) { $result = ''; if($charSet == '') { $charSet = $this->CharSet; } if($contentType == '') { $contentType = $this->ContentType; } if($encoding == '') { $encoding = $this->Encoding; } $result .= $this->TextLine('--' . $boundary); $result .= sprintf("Content-Type: %s; charset = \"%s\"", $contentType, $charSet); $result .= $this->LE; $result .= $this->HeaderLine('Content-Transfer-Encoding', $encoding); $result .= $this->LE; return $result; } /** * Returns the end of a message boundary. * @access public */ public function EndBoundary($boundary) { return $this->LE . '--' . $boundary . '--' . $this->LE; } /** * Sets the message type. * @access public * @return void */ public function SetMessageType() { if(count($this->attachment) < 1 && strlen($this->AltBody) < 1) { $this->message_type = 'plain'; } else { if(count($this->attachment) > 0) { $this->message_type = 'attachments'; } if(strlen($this->AltBody) > 0 && count($this->attachment) < 1) { $this->message_type = 'alt'; } if(strlen($this->AltBody) > 0 && count($this->attachment) > 0) { $this->message_type = 'alt_attachments'; } } } /* Returns a formatted header line. * @access public * @return string */ public function HeaderLine($name, $value) { return $name . ': ' . $value . $this->LE; } /** * Returns a formatted mail line. * @access public * @return string */ public function TextLine($value) { return $value . $this->LE; } ///////////////////////////////////////////////// // CLASS METHODS, ATTACHMENTS ///////////////////////////////////////////////// /** * Adds an attachment from a path on the filesystem. * Returns false if the file could not be found * or accessed. * @param string $path Path to the attachment. * @param string $name Overrides the attachment name. * @param string $encoding File encoding (see $Encoding). * @param string $type File extension (MIME) type. * @return bool */ public function AddAttachment($path, $name = '', $encoding = 'base64', $type = 'application/octet-stream') { if(!@is_file($path)) { $this->SetError($this->Lang('file_access') . $path); return false; } $filename = basename($path); if($name == '') { $name = $filename; } $cur = count($this->attachment); $this->attachment[$cur][0] = $path; $this->attachment[$cur][1] = $filename; $this->attachment[$cur][2] = $name; $this->attachment[$cur][3] = $encoding; $this->attachment[$cur][4] = $type; $this->attachment[$cur][5] = false; // isStringAttachment $this->attachment[$cur][6] = 'attachment'; $this->attachment[$cur][7] = 0; return true; } /** * Attaches all fs, string, and binary attachments to the message. * Returns an empty string on failure. * @access public * @return string */ public function AttachAll() { /* Return text of body */ $mime = array(); /* Add all attachments */ for($i = 0; $i < count($this->attachment); $i++) { /* Check for string attachment */ $bString = $this->attachment[$i][5]; if ($bString) { $string = $this->attachment[$i][0]; } else { $path = $this->attachment[$i][0]; } $filename = $this->attachment[$i][1]; $name = $this->attachment[$i][2]; $encoding = $this->attachment[$i][3]; $type = $this->attachment[$i][4]; $disposition = $this->attachment[$i][6]; $cid = $this->attachment[$i][7]; $mime[] = sprintf("--%s%s", $this->boundary[1], $this->LE); //$mime[] = sprintf("Content-Type: %s; name=\"%s\"%s", $type, $name, $this->LE); $mime[] = sprintf("Content-Type: %s; name=\"%s\"%s", $type, $this->EncodeHeader($this->SecureHeader($name)), $this->LE); $mime[] = sprintf("Content-Transfer-Encoding: %s%s", $encoding, $this->LE); if($disposition == 'inline') { $mime[] = sprintf("Content-ID: <%s>%s", $cid, $this->LE); } //$mime[] = sprintf("Content-Disposition: %s; filename=\"%s\"%s", $disposition, $name, $this->LE.$this->LE); $mime[] = sprintf("Content-Disposition: %s; filename=\"%s\"%s", $disposition, $this->EncodeHeader($this->SecureHeader($name)), $this->LE.$this->LE); /* Encode as string attachment */ if($bString) { $mime[] = $this->EncodeString($string, $encoding); if($this->IsError()) { return ''; } $mime[] = $this->LE.$this->LE; } else { $mime[] = $this->EncodeFile($path, $encoding); if($this->IsError()) { return ''; } $mime[] = $this->LE.$this->LE; } } $mime[] = sprintf("--%s--%s", $this->boundary[1], $this->LE); return join('', $mime); } /** * Encodes attachment in requested format. Returns an * empty string on failure. * @access public * @return string */ public function EncodeFile ($path, $encoding = 'base64') { if(!@$fd = fopen($path, 'rb')) { $this->SetError($this->Lang('file_open') . $path); return ''; } if (function_exists('get_magic_quotes')) { function get_magic_quotes() { return false; } } if (PHP_VERSION < 6) { $magic_quotes = get_magic_quotes_runtime(); set_magic_quotes_runtime(0); } $file_buffer = file_get_contents($path); $file_buffer = $this->EncodeString($file_buffer, $encoding); fclose($fd); if (PHP_VERSION < 6) { set_magic_quotes_runtime($magic_quotes); } return $file_buffer; } /** * Encodes string to requested format. Returns an * empty string on failure. * @access public * @return string */ public function EncodeString ($str, $encoding = 'base64') { $encoded = ''; switch(strtolower($encoding)) { case 'base64': $encoded = chunk_split(base64_encode($str), 76, $this->LE); break; case '7bit': case '8bit': $encoded = $this->FixEOL($str); if (substr($encoded, -(strlen($this->LE))) != $this->LE) $encoded .= $this->LE; break; case 'binary': $encoded = $str; break; case 'quoted-printable': $encoded = $this->EncodeQP($str); break; default: $this->SetError($this->Lang('encoding') . $encoding); break; } return $encoded; } /** * Encode a header string to best of Q, B, quoted or none. * @access public * @return string */ public function EncodeHeader ($str, $position = 'text') { $x = 0; switch (strtolower($position)) { case 'phrase': if (!preg_match('/[\200-\377]/', $str)) { /* Can't use addslashes as we don't know what value has magic_quotes_sybase. */ $encoded = addcslashes($str, "..\37\177\\\""); if (($str == $encoded) && !preg_match('/[^A-Za-z0-9!#$%&\'*+\/=?^_`{|}~ -]/', $str)) { return ($encoded); } else { return ("\"$encoded\""); } } $x = preg_match_all('/[^404143-\133\135-\176]/', $str, $matches); break; case 'comment': $x = preg_match_all('/[()"]/', $str, $matches); /* Fall-through */ case 'text': default: $x += preg_match_all('/[00-10131416-37\177-\377]/', $str, $matches); break; } if ($x == 0) { return ($str); } $maxlen = 75 - 7 - strlen($this->CharSet); /* Try to select the encoding which should produce the shortest output */ if (strlen($str)/3 < $x) { $encoding = 'B'; if (function_exists('mb_strlen') && $this->HasMultiBytes($str)) { // Use a custom function which correctly encodes and wraps long // multibyte strings without breaking lines within a character $encoded = $this->Base64EncodeWrapMB($str); } else { $encoded = base64_encode($str); $maxlen -= $maxlen % 4; $encoded = trim(chunk_split($encoded, $maxlen, "\n")); } } else { $encoding = 'Q'; $encoded = $this->EncodeQ($str, $position); $encoded = $this->WrapText($encoded, $maxlen, true); $encoded = str_replace('='.$this->LE, "\n", trim($encoded)); } $encoded = preg_replace('/^(.*)$/m', " =?".$this->CharSet."?$encoding?\\1?=", $encoded); $encoded = trim(str_replace("\n", $this->LE, $encoded)); return $encoded; } /** * Checks if a string contains multibyte characters. * @access public * @param string $str multi-byte text to wrap encode * @return bool */ public function HasMultiBytes($str) { if (function_exists('mb_strlen')) { return (strlen($str) > mb_strlen($str, $this->CharSet)); } else { // Assume no multibytes (we can't handle without mbstring functions anyway) return False; } } /** * Correctly encodes and wraps long multibyte strings for mail headers * without breaking lines within a character. * Adapted from a function by paravoid at http://uk.php.net/manual/en/function.mb-encode-mimeheader.php * @access public * @param string $str multi-byte text to wrap encode * @return string */ public function Base64EncodeWrapMB($str) { $start = "=?".$this->CharSet."?B?"; $end = "?="; $encoded = ""; $mb_length = mb_strlen($str, $this->CharSet); // Each line must have length <= 75, including $start and $end $length = 75 - strlen($start) - strlen($end); // Average multi-byte ratio $ratio = $mb_length / strlen($str); // Base64 has a 4:3 ratio $offset = $avgLength = floor($length * $ratio * .75); for ($i = 0; $i < $mb_length; $i += $offset) { $lookBack = 0; do { $offset = $avgLength - $lookBack; $chunk = mb_substr($str, $i, $offset, $this->CharSet); $chunk = base64_encode($chunk); $lookBack++; } while (strlen($chunk) > $length); $encoded .= $chunk . $this->LE; } // Chomp the last linefeed $encoded = substr($encoded, 0, -strlen($this->LE)); return $encoded; } /** * Encode string to quoted-printable. * @access public * @param string $string the text to encode * @param integer $line_max Number of chars allowed on a line before wrapping * @return string */ public function EncodeQP( $input = '', $line_max = 76, $space_conv = false ) { $hex = array('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F'); $lines = preg_split('/(?:\r\n|\r|\n)/', $input); $eol = "\r\n"; $escape = '='; $output = ''; while( list(, $line) = each($lines) ) { $linlen = strlen($line); $newline = ''; for($i = 0; $i < $linlen; $i++) { $c = substr( $line, $i, 1 ); $dec = ord( $c ); if ( ( $i == 0 ) && ( $dec == 46 ) ) { // convert first point in the line into =2E $c = '=2E'; } if ( $dec == 32 ) { if ( $i == ( $linlen - 1 ) ) { // convert space at eol only $c = '=20'; } else if ( $space_conv ) { $c = '=20'; } } elseif ( ($dec == 61) || ($dec < 32 ) || ($dec > 126) ) { // always encode "\t", which is *not* required $h2 = floor($dec/16); $h1 = floor($dec%16); $c = $escape.$hex[$h2].$hex[$h1]; } if ( (strlen($newline) + strlen($c)) >= $line_max ) { // CRLF is not counted $output .= $newline.$escape.$eol; // soft line break; " =\r\n" is okay $newline = ''; // check if newline first character will be point or not if ( $dec == 46 ) { $c = '=2E'; } } $newline .= $c; } // end of for $output .= $newline.$eol; } // end of while return $output; } /** * Encode string to q encoding. * @access public * @return string */ public function EncodeQ ($str, $position = 'text') { /* There should not be any EOL in the string */ $encoded = preg_replace("[\r\n]", '', $str); switch (strtolower($position)) { case 'phrase': $encoded = preg_replace("/([^A-Za-z0-9!*+\/ -])/e", "'='.sprintf('%02X', ord('\\1'))", $encoded); break; case 'comment': $encoded = preg_replace("/([\(\)\"])/e", "'='.sprintf('%02X', ord('\\1'))", $encoded); case 'text': default: /* Replace every high ascii, control =, ? and _ characters */ $encoded = preg_replace('/([00-11131416-377577\137\177-\377])/e', "'='.sprintf('%02X', ord('\\1'))", $encoded); break; } /* Replace every spaces to _ (more readable than =20) */ $encoded = str_replace(' ', '_', $encoded); return $encoded; } /** * Adds a string or binary attachment (non-filesystem) to the list. * This method can be used to attach ascii or binary data, * such as a BLOB record from a database. * @param string $string String attachment data. * @param string $filename Name of the attachment. * @param string $encoding File encoding (see $Encoding). * @param string $type File extension (MIME) type. * @return void */ public function AddStringAttachment($string, $filename, $encoding = 'base64', $type = 'application/octet-stream') { /* Append to $attachment array */ $cur = count($this->attachment); $this->attachment[$cur][0] = $string; $this->attachment[$cur][1] = $filename; $this->attachment[$cur][2] = $filename; $this->attachment[$cur][3] = $encoding; $this->attachment[$cur][4] = $type; $this->attachment[$cur][5] = true; // isString $this->attachment[$cur][6] = 'attachment'; $this->attachment[$cur][7] = 0; } /** * Adds an embedded attachment. This can include images, sounds, and * just about any other document. Make sure to set the $type to an * image type. For JPEG images use "image/jpeg" and for GIF images * use "image/gif". * @param string $path Path to the attachment. * @param string $cid Content ID of the attachment. Use this to identify * the Id for accessing the image in an HTML form. * @param string $name Overrides the attachment name. * @param string $encoding File encoding (see $Encoding). * @param string $type File extension (MIME) type. * @return bool */ public function AddEmbeddedImage($path, $cid, $name = '', $encoding = 'base64', $type = 'application/octet-stream') { if(!@is_file($path)) { $this->SetError($this->Lang('file_access') . $path); return false; } $filename = basename($path); if($name == '') { $name = $filename; } /* Append to $attachment array */ $cur = count($this->attachment); $this->attachment[$cur][0] = $path; $this->attachment[$cur][1] = $filename; $this->attachment[$cur][2] = $name; $this->attachment[$cur][3] = $encoding; $this->attachment[$cur][4] = $type; $this->attachment[$cur][5] = false; $this->attachment[$cur][6] = 'inline'; $this->attachment[$cur][7] = $cid; return true; } /** * Returns true if an inline attachment is present. * @access public * @return bool */ public function InlineImageExists() { $result = false; for($i = 0; $i < count($this->attachment); $i++) { if($this->attachment[$i][6] == 'inline') { $result = true; break; } } return $result; } ///////////////////////////////////////////////// // CLASS METHODS, MESSAGE RESET ///////////////////////////////////////////////// /** * Clears all recipients assigned in the TO array. Returns void. * @return void */ public function ClearAddresses() { $this->to = array(); } /** * Clears all recipients assigned in the CC array. Returns void. * @return void */ public function ClearCCs() { $this->cc = array(); } /** * Clears all recipients assigned in the BCC array. Returns void. * @return void */ public function ClearBCCs() { $this->bcc = array(); } /** * Clears all recipients assigned in the ReplyTo array. Returns void. * @return void */ public function ClearReplyTos() { $this->ReplyTo = array(); } /** * Clears all recipients assigned in the TO, CC and BCC * array. Returns void. * @return void */ public function ClearAllRecipients() { $this->to = array(); $this->cc = array(); $this->bcc = array(); } /** * Clears all previously set filesystem, string, and binary * attachments. Returns void. * @return void */ public function ClearAttachments() { $this->attachment = array(); } /** * Clears all custom headers. Returns void. * @return void */ public function ClearCustomHeaders() { $this->CustomHeader = array(); } ///////////////////////////////////////////////// // CLASS METHODS, MISCELLANEOUS ///////////////////////////////////////////////// /** * Adds the error message to the error container. * Returns void. * @access private * @return void */ private function SetError($msg) { $this->error_count++; $this->ErrorInfo = $msg; } /** * Returns the proper RFC 822 formatted date. * @access private * @return string */ private static function RFCDate() { $tz = date('Z'); $tzs = ($tz < 0) ? '-' : '+'; $tz = abs($tz); $tz = (int)($tz/3600)*100 + ($tz%3600)/60; $result = sprintf("%s %s%04d", date('D, j M Y H:i:s'), $tzs, $tz); return $result; } /** * Returns the server hostname or 'localhost.localdomain' if unknown. * @access private * @return string */ private function ServerHostname() { if (!empty($this->Hostname)) { $result = $this->Hostname; } elseif (isset($_SERVER['SERVER_NAME'])) { $result = $_SERVER['SERVER_NAME']; } else { $result = "localhost.localdomain"; } return $result; } /** * Returns a message in the appropriate language. * @access private * @return string */ private function Lang($key) { if(count($this->language) < 1) { $this->SetLanguage('en'); // set the default language } if(isset($this->language[$key])) { return $this->language[$key]; } else { return 'Language string failed to load: ' . $key; } } /** * Returns true if an error occurred. * @access public * @return bool */ public function IsError() { return ($this->error_count > 0); } /** * Changes every end of line from CR or LF to CRLF. * @access private * @return string */ private function FixEOL($str) { $str = str_replace("\r\n", "\n", $str); $str = str_replace("\r", "\n", $str); $str = str_replace("\n", $this->LE, $str); return $str; } /** * Adds a custom header. * @access public * @return void */ public function AddCustomHeader($custom_header) { $this->CustomHeader[] = explode(':', $custom_header, 2); } /** * Evaluates the message and returns modifications for inline images and backgrounds * @access public * @return $message */ public function MsgHTML($message,$basedir='') { preg_match_all("/(src|background)=\"(.*)\"/Ui", $message, $images); if(isset($images[2])) { foreach($images[2] as $i => $url) { // do not change urls for absolute images (thanks to corvuscorax) if (!preg_match('/^[A-z][A-z]*:\/\//',$url)) { $filename = basename($url); $directory = dirname($url); ($directory == '.')?$directory='':''; $cid = 'cid:' . md5($filename); $fileParts = split("\.", $filename); $ext = $fileParts[1]; $mimeType = $this->_mime_types($ext); if ( strlen($basedir) > 1 && substr($basedir,-1) != '/') { $basedir .= '/'; } if ( strlen($directory) > 1 && substr($directory,-1) != '/') { $directory .= '/'; } if ( $this->AddEmbeddedImage($basedir.$directory.$filename, md5($filename), $filename, 'base64',$mimeType) ) { $message = preg_replace("/".$images[1][$i]."=\"".preg_quote($url, '/')."\"/Ui", $images[1][$i]."=\"".$cid."\"", $message); } } } } $this->IsHTML(true); $this->Body = $message; $textMsg = trim(strip_tags(preg_replace('/<(head|title|style|script)[^>]*>.*?<\/\\1>/s','',$message))); if ( !empty($textMsg) && empty($this->AltBody) ) { $this->AltBody = html_entity_decode($textMsg); } if ( empty($this->AltBody) ) { $this->AltBody = 'To view this email message, open the email in with HTML compatibility!' . "\n\n"; } } /** * Gets the mime type of the embedded or inline image * @access public * @return mime type of ext */ public function _mime_types($ext = '') { $mimes = array( 'hqx' => 'application/mac-binhex40', 'cpt' => 'application/mac-compactpro', 'doc' => 'application/msword', 'bin' => 'application/macbinary', 'dms' => 'application/octet-stream', 'lha' => 'application/octet-stream', 'lzh' => 'application/octet-stream', 'exe' => 'application/octet-stream', 'class' => 'application/octet-stream', 'psd' => 'application/octet-stream', 'so' => 'application/octet-stream', 'sea' => 'application/octet-stream', 'dll' => 'application/octet-stream', 'oda' => 'application/oda', 'pdf' => 'application/pdf', 'ai' => 'application/postscript', 'eps' => 'application/postscript', 'ps' => 'application/postscript', 'smi' => 'application/smil', 'smil' => 'application/smil', 'mif' => 'application/vnd.mif', 'xls' => 'application/vnd.ms-excel', 'ppt' => 'application/vnd.ms-powerpoint', 'wbxml' => 'application/vnd.wap.wbxml', 'wmlc' => 'application/vnd.wap.wmlc', 'dcr' => 'application/x-director', 'dir' => 'application/x-director', 'dxr' => 'application/x-director', 'dvi' => 'application/x-dvi', 'gtar' => 'application/x-gtar', 'php' => 'application/x-httpd-php', 'php4' => 'application/x-httpd-php', 'php3' => 'application/x-httpd-php', 'phtml' => 'application/x-httpd-php', 'phps' => 'application/x-httpd-php-source', 'js' => 'application/x-javascript', 'swf' => 'application/x-shockwave-flash', 'sit' => 'application/x-stuffit', 'tar' => 'application/x-tar', 'tgz' => 'application/x-tar', 'xhtml' => 'application/xhtml+xml', 'xht' => 'application/xhtml+xml', 'zip' => 'application/zip', 'mid' => 'audio/midi', 'midi' => 'audio/midi', 'mpga' => 'audio/mpeg', 'mp2' => 'audio/mpeg', 'mp3' => 'audio/mpeg', 'aif' => 'audio/x-aiff', 'aiff' => 'audio/x-aiff', 'aifc' => 'audio/x-aiff', 'ram' => 'audio/x-pn-realaudio', 'rm' => 'audio/x-pn-realaudio', 'rpm' => 'audio/x-pn-realaudio-plugin', 'ra' => 'audio/x-realaudio', 'rv' => 'video/vnd.rn-realvideo', 'wav' => 'audio/x-wav', 'bmp' => 'image/bmp', 'gif' => 'image/gif', 'jpeg' => 'image/jpeg', 'jpg' => 'image/jpeg', 'jpe' => 'image/jpeg', 'png' => 'image/png', 'tiff' => 'image/tiff', 'tif' => 'image/tiff', 'css' => 'text/css', 'html' => 'text/html', 'htm' => 'text/html', 'shtml' => 'text/html', 'txt' => 'text/plain', 'text' => 'text/plain', 'log' => 'text/plain', 'rtx' => 'text/richtext', 'rtf' => 'text/rtf', 'xml' => 'text/xml', 'xsl' => 'text/xml', 'mpeg' => 'video/mpeg', 'mpg' => 'video/mpeg', 'mpe' => 'video/mpeg', 'qt' => 'video/quicktime', 'mov' => 'video/quicktime', 'avi' => 'video/x-msvideo', 'movie' => 'video/x-sgi-movie', 'doc' => 'application/msword', 'word' => 'application/msword', 'xl' => 'application/excel', 'eml' => 'message/rfc822' ); return ( ! isset($mimes[strtolower($ext)])) ? 'application/octet-stream' : $mimes[strtolower($ext)]; } /** * Set (or reset) Class Objects (variables) * * Usage Example: * $page->set('X-Priority', '3'); * * @access public * @param string $name Parameter Name * @param mixed $value Parameter Value * NOTE: will not work with arrays, there are no arrays to set/reset */ public function set ( $name, $value = '' ) { if ( isset($this->$name) ) { $this->$name = $value; } else { $this->SetError('Cannot set or reset variable ' . $name); return false; } } /** * Read a file from a supplied filename and return it. * * @access public * @param string $filename Parameter File Name */ public function getFile($filename) { $return = ''; if ($fp = fopen($filename, 'rb')) { while (!feof($fp)) { $return .= fread($fp, 1024); } fclose($fp); return $return; } else { return false; } } /** * Strips newlines to prevent header injection. * @access public * @param string $str String * @return string */ public function SecureHeader($str) { $str = trim($str); $str = str_replace("\r", "", $str); $str = str_replace("\n", "", $str); return $str; } /** * Set the private key file and password to sign the message. * * @access public * @param string $key_filename Parameter File Name * @param string $key_pass Password for private key */ public function Sign($cert_filename, $key_filename, $key_pass) { $this->sign_cert_file = $cert_filename; $this->sign_key_file = $key_filename; $this->sign_key_pass = $key_pass; } } ?>

E awe kuroi. Valeu, foi mesmo testei e foi certinho, muito obrigado :rolleyes:

Mais essa numeração muda em algum coisa no comportamento do sql ? Achei que era só para organizaçõa.

Oi pessoal montei um sistema de paginação de recados no meu site. Quando não há recados ele aparece uma mensagem dizendo que não há recados, ate ae tudo bem, porem quando esta mensagem aparece aparece o seguinte erro. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\Site\ver_rss.php on line 296 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\Site\ver_rss.php on line 297 aqui esta o php da paginação. <? require_once("conecxao/conecta.php"); require_once("conecxao/funcao.php"); $pagina = $_GET["pagina"]; $busca = "SELECT * FROM recados WHERE id='$id' "; $total_reg = $config_paginacao_recados; if ($pagina=="") { $pagina = "1"; $pc = "1"; } else { $pc = $pagina; } $inicio = $pc - 1; $inicio = $inicio * $total_reg; $limite = mysql_query("$busca LIMIT $inicio,$total_reg"); $todos = mysql_query("$busca"); $tr = mysql_num_rows($todos); if($tr>0){ // verifica o n?ero total de registros $tp = $tr / $total_reg; // verifica o n?ero total de p?inas ?> <font size="2"><? echo "<font face=arial size=2> <b><font color=\"#999999\"><font color=\"#999999\">|</font>Página $pagina</b>|<font color=\"#999999\"> </font></font> "; ?></font> <?php $query[550] = mysql_query("SELECT * FROM recados WHERE id='$id' ORDER BY idx DESC LIMIT 5"); print mysql_error(); print("<table width=\"100%\" border=\"0\">"); while($result = mysql_fetch_array($limite)) { $recado_recado = stripslashes($result['recado']); $recado_data = stripslashes($result['data']); $recado_email = stripslashes($result['email']); $remetente = stripslashes($result['nome']); $temp_id_recado = stripslashes($result['idx']); ?> </font></p> <table width="15%" border="0" class="Recados_fundo"> <tr> <td width="10%"><div align="center"><font color="#666666">Nome:</font></div></td> <td width="69%"><table width="100%" border="0" class="texto_recados"> <tr> <td width="49%"> <? print($remetente); ?></td> <td width="51%"> <div align="right"><font color="#666666">Data:</font></div></td> </tr> </table></td> <td width="6%" class="texto_recados"> <div align="center" class="texto_recados"><? print($recado_data); ?></div></td> </tr> <tr> <td height="29"> <div align="center"><font color="#666666">Email:</font></div></td> <td class="texto_recados"><table width="100%" border="0" class="texto_recados"> <tr> <td width="50%"> <? print($recado_email); ?></td> <td width="50%">&nbsp;</td> </tr> </table></td> <td><table width="97%" border="0"> <? if($login_ativo_pc == 1){ ?> <tr> <td width="36%"><div align="right"><a href="java script:confirmaExclusao('conecxao/funcao.php?idx=<? print($temp_id_recado); ?>&acao=excluir_recado&id=<? print($temp_id); ?>&site=<? print($site); ?>')"><img src="images/close.png" width="16" height="16" border="0" title="Apagar recado"></a></div></td> </tr> <? } ?> </table></td> </tr> <tr> <td height="29">&nbsp;</td> <td class="texto_recados"><div align="center"><span class="texto_recados"><font color="#666666"> <? print($recado_recado); ?> </font></span></div></td> <td>&nbsp;</td> </tr> </table> <?php } $anterior = $pc -1; $proximo = $pc +1; if ($pagina>1) { echo " <tr> <td width=\"100%\" height=\"19\"> <p align=\"center\"><a href=\"?id=$id&pagina=$anterior\"><img src=\"/Images/b_left.gif\"alt=\"Anterior\" width=\"87\" height=\"18\" border=\"0\"class=\"exibir_cadastro_user_id\"></a></div> "; } else{ echo "<tr> <td width=\"100%\" height=\"19\"> <p align=\"center\"><img src=\"Images/b_left_disable.gif\"alt=\"Anterior\" width=\"87\" height=\"18\">"; } if ($pagina<$tp) { echo " <a href=\"?id=$id&pagina=$proximo\"><img src=\"Images/b_right.gif\"alt=\"Próximo\" width=\"87\" height=\"18\" border=\"0\" class=\"exibir_cadastro_user_id\"></a> "; } else { echo " <img src=\"Images/b_right_disable.gif\"alt=\"Próximo\" width=\"87\" height=\"18\"class=\"exibir_cadastro_user_id\"> "; } ?> </td> </tr> <tr> <td height="22"> <p><span class="texto_recados"><font color="#666666"> <? } -------------------------------------------------AS DUAS LINHAS ABAIXOS são A DO ERRO----------------------------------- $returned = mysql_num_rows($query[550]); if(mysql_num_rows($query[550]) < 1) { ---------------------------------------------------------------------------------------------------------------------------------------- print("<tr> <td width=\"88%\"><div align=\"center\">Não há nenhum comentário</div></td> </tr>"); } print("</table>"); ?> </font></span> <span class="texto_recados"><font color="#666666"> <?php if($returned >= 1) { print(""); } else { print("<table width=\"67%\" border=\"0\" class=\"Recados_fundo\"> <tr> <td width=\"10%\" height=\"81\"> <div align=\"center\"> <p><font color=\"#0099FF\" size=\"4\">Desculpe, mais ninguém postou recado pra min..</font></p> <p><font color=\"#0099FF\" size=\"4\">Quer me mandar um recado ?</font></p> <p><a href=\"java script:DivRecadoRss()\" class=\"link_recado\"><font size=\"4\"> Clique aqui e me deixe mais feliz !!!</font></a></p> </div></td> </tr> <tr> <td height=\"29\"><div align=\"center\"></div></td> </tr> </table> "); } ?>

Já resolvi meu problema hehehe

Eu tentei em ajax, ele abre td bem, mais quando eu vou executar um link ele recarrega a pagina e fecha o ajax, eu quero que a pagina fique aberta. pois é um calendario e ele tem a função de mostrar os meses e anos, quando mudo um mes ele recarrega a pagina e fecha o ajax. Tem como deixar o ajax aberto e so caregar o conteudo dentro dele ? ajax.php <?php $conteudo = $_GET["conteudo"]; if($conteudo == "calendario") { $fileToRead = include("../calendario.php"); } else if($conteudo == "site") { $fileToRead = "site.html"; } print(urlencode($conteudoArquivo)); ?> Js.js function getNewHttpRequest() { try { xmlhttp = new XMLHttpRequest(); } catch(ee) { try { xmlhttp = new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) { try { xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } catch(E) { xmlhttp = false; } } } return(xmlhttp); } oAjax = getNewHttpRequest(); //Fila de conexões fila = []; ifila = 0; // funcao para altear o conteudo do miolo function ajaxHTMLmiolo(id, conteudo) { ajaxHTML(id, 'conecxao/ajax.php?conteudo='+conteudo); } //Executa a próxima conexão da fila function ajaxRun() { //Abre a conexão oAjax.open("GET", fila[ifila][1], true); //Função para tratamento do retorno oAjax.onreadystatechange = function() { if (oAjax.readyState == 4) { //Mostra o HTML recebido retorno = unescape(oAjax.responseText.replace(/\+/g, " ")); document.getElementById(fila[ifila][0]).innerHTML = retorno; //Roda o próximo ifila++; if(ifila < fila.length) setTimeout("ajaxRun()", 20); } }; //Executa oAjax.send(null); } function ajaxHTML(id, url) { //Carregando... document.getElementById(id).innerHTML="<span class='carregando'>"+"Carregando...</span>"; //Adiciona à fila fila[fila.length] = [id, url]; //Se não há conexões pendentes, executa if((ifila+1) == fila.length) ajaxRun(); } e no site <a href="java script: void(0);" onclick="ajaxHTMLmiolo('miolo', 'principal');">Principal</a> <div id="miolo"></div>

oPA eu quero que mantenha a barra de rolagem aonde está , pois toda vez que uso o calendario e escolho um dia ela volta pro topo da pagina.

Oi pessoal, estou montando um site onde tem um calendario no perfil do usuario. ate awe td bem, mais quando clico num link nele, ele recarega a pagina e ela vai pro topo, eu gostaria de usar um include onde qualquer link que eu click nele ele fique na mesmo posição da pagina sem ir pro topo. quero que treve onde ele esta. alguém entendeu, caso contrario eu coloco ele online assim fica mais facil

HUHUUHUH sou brasileiro e nunca desisto !!!! Ficou assim <? if(!file_exists($arquivo)){ $arquivo_nome = ''; } elseif (isset($_FILES["arquivo"])){ $upload_hora = date('d-m-Y_H-i'); $arquivo = $_FILES["arquivo"]; $pasta_dir = "../upload_imagens/$upload_hora";//diretorio dos arquivos; $arquivo_nome = $pasta_dir . $arquivo ["name"]; move_uploaded_file($_FILES['arquivo']['tmp_name'] , $arquivo_nome); } ?> Valeu *FIT* e Stoma Me ajudaram muito... (( ¬¬ )) ___=___

Poxa coloquei mais não mudou nada, agora quando deixo sem imagem ele grava a pasta e a data no Bd. if($acao == "cadastrar_user") { //Variaveis do site e conexao com o banco de dados; $cad_dia = date("d/m/Y H:i"); include("conecta.php"); //Rotina para verificar se os campos obrigatorios foram adicionados; if (strlen($nome) < 4) echo '<p align="center">O nome deve ter pelomenos 4 letras <BR> <meta http-equiv="refresh" content="2;URL=../index.php?acao=cadastro_user"></p>'; elseif (strlen($email) <= 5) echo '<p align="center">Email inválido, tente novamente!<BR> <meta http-equiv="refresh" content="2;URL=../index.php?acao=cadastro_user"></p>'; elseif (strlen($comentario) <= 10) echo '<p align="center">Você deve adicionar um comentário com mais de 10 letras!<BR> <meta http-equiv="refresh" content="2;URL=../index.php?acao=cadastro_user"></p>'; else{ //Tudo ok ele faz o upload da imagem; if(isset($_FILES["arquivo"])){ $upload_hora = date('d-m-Y_H-i'); $arquivo = $_FILES["arquivo"]; $pasta_dir = "../upload_imagens/$upload_hora";//diretorio dos arquivos; $arquivo_nome = $pasta_dir . $arquivo ["name"]; move_uploaded_file($_FILES['arquivo']['tmp_name'] , $arquivo_nome); } //Cadastra arquivos no banco de dados; $cad = "INSERT INTO `tonelotospage`.`cadastro` (`id` , `nome` ,`email` ,`sexo`, `idade`, `dia_cadastro`, `nasc`, `comentario`, `foto`, `rg`, `ip`, `senha`, `relacionamento`, `interesse`, `cidade`) VALUES ('$id', '$nome', '$email', '$sexo', '$idade', '$cad_dia $hora', '$nasc', '$comentario', '$arquivo_nome', '$rg', '$ip', '$senha', '$relacionamento', '$interesse', '$cidade')"; mysql_query ($cad, $conecxao); echo "<script>alert('Usuário cadastro com sucesso')</script>"; echo "<script> window.location = '../index.php?acao=exibir_cadastro_user'</script>"; }} eu quero que se não tiver imagem não grave nada no bd na parte da foto, que fique em branco, mais esse if que você passou não ta adiantando. caso pergunte para o que é.... é para na pagina de exibir o cadastro, caso não tenha imagem gravado no usuario ele retorna uma imagem de "sem foto" Espero ajuda, isto parou td meu projeto

Ola pessoal estou montando uma página de cadastro de usuario, onde ele cadastra seu nome email e foto. No upload da foto é adicionado uma pasta com a data e hora do upload , ate ae td certo, mais na hora que não é colocado nenhuma imagem é salava no banco de dados o pasta da imagem. Ex: Sem imagem: foto ../upload_imagens/30-08-2010_06-08-28-/ Com imagem : foto ../upload_imagens/30-08-2010_06-20-18-/imagem.jpg GOstaria que não fosse nenhum dado pro Bd na hora que não a foto cadastrada. Aki ta o php de cadastro e upload if($acao == "cadastrar_user") { $hora = date('d-m-Y_h-m-s-'); include("conecta.php"); if(isset($_FILES["arquivo"])){ $arquivo = $_FILES["arquivo"]; $pasta_dir = "../upload_imagens/$hora/ ";//diretorio dos arquivos if(!file_exists($pasta_dir)){ mkdir($pasta_dir); } $arquivo_nome = $pasta_dir . $arquivo ["name"]; move_uploaded_file($_FILES['arquivo']['tmp_name'], $arquivo_nome); $cad = "INSERT INTO `tonelotospage`.`cadastro` (`id` , `nome` ,`email` ,`sexo`, `idade`, `dia_cadastro`, `nasc`, `comentario`, `foto`, `rg`, `ip`, `senha`, `relacionamento`, `interesse`, `cidade`) VALUES ('$id', '$nome', '$email', '$sexo', '$idade', '$cad_dia $hora', '$nasc', '$comentario', '$arquivo_nome', '$rg', '$ip', '$senha', '$relacionamento', '$interesse', '$cidade')"; mysql_query ($cad, $conecxao); echo "<script>alert('Usuário cadastro com sucesso')</script>"; echo "<script> window.location = '../index.php?acao=exibir_cadastro_user'</script>"; }} Aki o php de cadastro de user <td height="23"> <form name="form_cadastro" id="form_cadastro" method="post" action="/conecxao/funcao.php?acao=cadastrar_user" enctype = "multipart/form-data"> <p></p> <div class="myBox4"> <table width="67%" border="0" align="center"> <tr> <td width="60%"><font color="#CCCCCC">Nome:</font><font color="#FF0000">*</font></td> <td width="40%"><input name="nome" type="text" class="formobjects" id="nome" size="56"></td> </tr> <tr> <td><font color="#CCCCCC">E-mail:</font><font color="#FF0000">*</font></td> <td><input name="email" type="text" class="formobjects" id="email3" size="56"></td> </tr> <tr> <td><font color="#CCCCCC">Sexo:</font><font color="#FF0000">*</font></td> <td> <select name="sexo" id="select2"> <option value="Masculino">Masculino</option> <option value="Feminino">Feminino</option> </select> </td> </tr> <tr> <td><font color="#CCCCCC">Nascimento:</font><font color="#FF0000">*</font></td> <td><input name="nasc" type="text" class="formobjects" id="nasc" size="56"></td> </tr> <tr> <td><font color="#CCCCCC">Idade:</font><font color="#FF0000">*</font></td> <td> <input name="idade" type="text" class="formobjects" id="idade" size="56"></td> </tr> <tr> <td><font color="#CCCCCC">Rg:</font><font color="#FF0000">*</font></td> <td><input name="rg" type="text" class="formobjects" id="rg" size="20"></td> </tr> <tr> <td><font color="#CCCCCC">Foto:</font></td> <td> <input type = "file" name = "arquivo"> </td> </tr> <tr> <td height="21"><font color="#CCCCCC">Relacionamento:</font><font color="#FF0000">*</font></td> <td><font color="#CCCCCC"> <select name="relacionamento" id="relacionamento"> <option value="Solteiro(a)">Solteiro(a)</option> <option value="Namorando">Namorando</option> <option value="Casado(a)">Casado(a)</option> <option value="Aberto">Aberto</option> </select> </font></td> </tr> <tr> <td height="26"><font color="#CCCCCC">Interessado(a) Em:</font><font color="#FF0000">*</font></td> <td><font color="#CCCCCC"> <select name="interesse" id="interesse"> <option value="Homens">Homens</option> <option value="Mulheres">Mulheres</option> <option value="Mulheres e Homens">Mulheres e Homens</option> </select> </font> </td> </tr> <tr> <td height="26"><font color="#CCCCCC">Cidade Natal:</font><font color="#FF0000">*</font></td> <td><input name="cidade" type="text" class="formobjects" id="cidade" size="56"></td> </tr> <tr> <td height="26"><font color="#CCCCCC">Coment&aacute;rio</font>:<font color="#FF0000">*</font></td> <td><textarea name="comentario" cols="50" class="formobjects" id="textarea2"></textarea></td> </tr> <tr> <td height="26"><font color="#CCCCCC">Senha:<font color="#FF0000">*</font></font></td> <td><input name="senha" type="password" class="formobjects" id="senha" size="20"></td> </tr> <tr> <td height="26"><font color="#FF0000" size="3">* Itens obrigat&oacute;rios</font></td> <td><input type="submit" name="submit" value="Cadastrar"></td> </tr> </table> </div> <p> </form></td> alguém tyem alguma ideia ae?

Boa noite povo, Estou tendo um dificuldade no DBLookupListBox e no DBLookupComboBox, Como faço para eles atualizarem as listas de dados apos adicionar um novo dado no Mysql, no DBLookupListBox Uso o zeus para me conectar no DBLookupComboBox uso o dbx Ambos conectam no Banco de dados Mysql

Opa problema resolvido, Parece que é só você que responde as perguntas aqui :angry: Muito obrigado,

Pode dar uma explicação melhor... Como que eu faço para declarar uma unit WinInet ?? Vlw :blush:

Boa noite pessoal; Queria saber se tem como fazer um programa para verificar o status do meu servidor. E sem como, alguém poderia me ajudar a fazer, pois não achei nada na internet. Vlw

Obrigado, mais já consegui com SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into lista_placa (nome, versao) VALUES ('+''''+plc.Text+''''+', '+''''+vrs.Text+''''+')'); SQLQuery1.ExecSQL; Vlw

Obrigado, consegui colocando esse comando, já fazia muito tempo que não mexia em sql. SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into lista_placa (nome, versao) VALUES ('+''''+plc.Text+''''+', '+''''+vrs.Text+''''+')'); SQLQuery1.ExecSQL;

Oi Gostaria de saber como enviar varios comandos SQLQuery1.SQL.Add para ser adicionado a tabela sql. Eu tentei isto, SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (Placa) values ('+''''+edit2.Text+''''+') '); SQLQuery1.ExecSQL; Mais ele só adiciona o valor de um edit.txt, como faço para adicionar varios edit.txt de uma vez em tabelas diferentes sql. è urgente.

Oi Pessoal, sou nome em delphi, tenho que montar um progeto para meu curso e estou com o seguinte problema. Tenho um 'Edit' que eu uso para adicionar os dados no mysql, o problema é que quando clico em adicionar, cada dado vai para uma coluna diferente no mysql, como se eu tivesse adicionado cada comando separadamente. Tem como eu adicionar varios SQLQuery1.SQL.Add para adicionar varias colunos juntas. procedure TForm1.Button1Click(Sender: TObject); begin //COMANDOS SQL PARA ADICIONAR DADOS AO BANCO DE DADOS. //Adiciona o nome do driver SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (nome) values ('+''''+edit1.Text+''''+ ') '); SQLQuery1.ExecSQL; o que eu quero fazer é adicionar varias tabelas ex SQLQuery1.SQL.Add('insert into driver (nome) values ('+''''+edit1.Text+''''+ ') '); SQLQuery1.SQL.Add('insert into driver (placa) values ('+''''+edit2.Text+''''+ ') '); SQLQuery1.SQL.Add('insert into driver (versao) values ('+''''+edit3.Text+''''+ ') '); tem como fazer tudo isso junto ?, tentei colocar desse geito mais da erro. A maneira que foi errado foi essa procedure TForm1.Button1Click(Sender: TObject); begin //COMANDOS SQL PARA ADICIONAR DADOS AO BANCO DE DADOS. //Adiciona o nome do driver SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (nome) values ('+''''+edit1.Text+''''+') '); SQLQuery1.ExecSQL; //Adiciona o nome da placa mãe SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (Placa) values ('+''''+edit2.Text+''''+') '); SQLQuery1.ExecSQL; //Adiciona o link do download SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (Link) values ('+''''+edit3.Text+''''+') '); SQLQuery1.ExecSQL; //Adiciona o link a versão do driver SQLQuery1.Active := False; SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('insert into driver (Versao) values ('+''''+edit4.Text+''''+') '); SQLQuery1.ExecSQL; end; end. Todos adicionam, sendo que cada um adiciona em uma nova linha