PHP conexionBD::setClose Examples

Example #1

File: recomienda.php Project: DC-Lorenzo/PACKS

    $email9_registrado = $gt->getNumRows();
}
$gt->setClose();
$query = "SELECT email_amigo FROM elforodeltenis_recomendaciones WHERE id_member = '{$_GET['m']}' AND numero = '10'";
$gt = new conexionBD();
$gt->doQuery("{$query}");
while ($gt->setWhile()) {
    $email10 = $gt->getDataSQL("email_amigo");
}
if ($email10 != "") {
    $query = "SELECT email_address FROM elforodeltenis_members WHERE email_address = '{$email10}'";
    $gt = new conexionBD();
    $gt->doQuery("{$query}");
    $email10_registrado = $gt->getNumRows();
}
$gt->setClose();
?>
<div class="row space-up">
	<div class="col-md-3"><img src="http://www.elforodeltenis.com/Themes/BeCool_2/images/elforodeltenis.gif" alt="el foro del tenis"></div>
	<div class="col-md-6"></div>
	<div class="col-md-3">
		<a href="http://www.elforodeltenis.com">
			<h1>Volver al foro...</h1>
		</a>
	</div>
</div>
<div class="row space-up">
	<div class="col-md-3">
		<div class="row">
			<div class="col-md-12">
				<img src="http://www.elforodeltenis.com/addons/banners/img/recomienda.jpg" alt="Recomienda el foro del tenis" class="img-thumbnail">

Example #2

File: Powerplay_n1.php Project: DC-Lorenzo/PACKS

<?php

$fecha = date("d/m/Y");
include "classes/class_general_db.php";
$query = "SELECT member_name, email_address FROM elforodeltenis_members WHERE id_member = '{$_GET['us']}'";
$po = new conexionBD();
$po->doQuery("{$query}");
while ($po->setWhile()) {
    $member_name = $po->getDataSQL("member_name");
    $email_address = $po->getDataSQL("email_address");
}
$po->setClose();
$query = "INSERT INTO elforodeltenis_descarga_powerplay ( id_usuario, fecha, version) VALUES ('{$_GET['us']}', '{$fecha}', '1')";
$po = new conexionBD();
$po->doQuery("{$query}");
include "classes/class.phpmailer.php";
//Envía email
$mail = new PHPMailer();
$mail->Host = "localhost";
$mail->From = "*****@*****.**";
$mail->FromName = "Descarga Powerplay | Elforodeltenis.com";
$mail->Subject = "Nueva descarga de la revista N.1 de Powerplay";
$mail->AddAddress('dcolja@elforodeltenis.com; pacoalmendros@ono.com');
$body = "<strong>El usuario {$member_name} se acaba de descargar el n&uacute;mero 1 de la revista Powerplay.<br><br>";
$body .= "<i>Mensaje enviado desde la web de elforodeltenis.com</i><br>";
$body .= "<a href=\"http://www.elforodeltenis.com\"><img src=\"http://www.elforodeltenis.com/Themes/BeCool_2/images/elforodeltenis.gif\"></a>";
$mail->Body = $body;
$mail->IsHTML(true);
$mail->Send();
$mail = new PHPMailer();
$mail->Host = "localhost";