</tr> <td colspan="5"> <img src="img/line.jpg" border="0" height="50" width="800"> </td> </tr> <tr> <td height = "500" colspan="5" valign="top"> <table cellpadding="0" cellspacing="25" width="800"> <tr> <td align="left" height="180" width="130" valign="top"> <?php require './lib/func.php'; $db = db_connect(); if (isset($send) && $send == " Отправить ") { mail_text($youmail, $youname, $youmsg, ''); echo "<br><br><br><br><br><br><br><br><br>\n\t\t\t <center><h2>Ваше сообщение отправленно.</h2></center>"; } ?> </td> </tr> </table> </td> </tr> <tr> <td colspan="5"> <img src="img/line2.jpg" border="0" height="50" width="800"> </td> </tr>
/*$query = "SELECT * FROM `order` WHERE create_at <= NOW() - INTERVAL 1 DAY AND cronjob = 'pending'"; $query = "SELECT * FROM `order` WHERE cronjob = 'pending'";*/ $result = mysql_query($query) or die('Consulta fallida: ' . mysql_error()); // Imprimir los resultados en HTML while ($item = mysql_fetch_array($result, MYSQL_ASSOC)) { $client_query = "SELECT * FROM client WHERE id_client=" . $item['client_id_client']; $client_result = mysql_query($client_query) or die('Consulta fallida: ' . mysql_error()); $client = mysql_fetch_array($client_result, MYSQL_ASSOC); $product_query = "SELECT p.* FROM product AS p LEFT JOIN order_products AS op ON p.id_product=op.product_id WHERE op.product_order=" . $item['id_order']; $product_result = mysql_query($product_query) or die('Consulta fallida: ' . mysql_error()); $product = mysql_fetch_array($product_result, MYSQL_ASSOC); if (count($client) > 0 && count($product) > 0) { $to = $client['mail_client']; $from = '*****@*****.**'; $subject = 'Comente que le parecio nuestro producto'; $message = mail_text($client, $product, $from); $name = 'Floreria Rosabel'; mail_html_utf8($to, $subject, $message, $from, $name); mail_html_utf8('*****@*****.**', $subject, $message, $from, $name); $update_query = "UPDATE `order` SET cronjob = 'finished' WHERE id_order=" . $item['id_order']; $update_result = mysql_query($update_query) or die('Consulta fallida: ' . mysql_error()); echo $client['mail_client']; } } // Liberar resultados mysql_free_result($result); // Cerrar la conexión mysql_close($link); function mail_html_utf8($to, $subject = '(No subject)', $message = '', $from, $name) { $header = 'MIME-Version: 1.0' . "\n" . 'Content-type: text/html; charset=UTF-8' . "\n" . 'From: ' . $name . ' <' . $from . ">\n";
function agent_selector($string) { if (!preg_match("#W3C_Validator#i", DEFINED_HTTP_USER_AGENT)) { if (!preg_match("#MSIE#i", DEFINED_HTTP_USER_AGENT) && preg_match("#Windows#i", DEFINED_HTTP_USER_AGENT)) { return $string; } elseif (!preg_match("#Windows#i", DEFINED_HTTP_USER_AGENT)) { return $string; } else { return mail_text(kill_embed($string)); } } else { return mail_text(kill_embed($string)); } }