PHP conexionBD::doQuery Examples

Example #1

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";

Example #2

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

    $query = "SELECT email_address FROM elforodeltenis_members WHERE email_address = '{$email9}'";
    $gt = new conexionBD();
    $gt->doQuery("{$query}");
    $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">

Example #3

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

<table>

<?php 
include "classes/class_general_db.php";
$query = "SELECT id_usuario FROM elforodeltenis_descarga_powerplay WHERE id_usuario<>'' group by id_usuario";
$po = new conexionBD();
$po->doQuery("{$query}");
while ($po->setWhile()) {
    $id_usuario = $po->getDataSQL("id_usuario");
    $query = "SELECT email_address, member_name FROM elforodeltenis_members WHERE id_member = '{$id_usuario}'";
    $op = new conexionBD();
    $op->doQuery("{$query}");
    while ($op->setWhile()) {
        $email_address = $op->getDataSQL("email_address");
        $member_name = $op->getDataSQL("member_name");
        ?>
				<tr>
					<td><?php 
        echo $email_address;
        ?>
</td>
					<td><?php 
        echo $member_name;
        ?>
</td>
				</tr>
				<?php 
    }
}
?>
</table>