</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));
}
}
