Beste mensen.
Ik heb een code waarmee ik een pdf creeer en daarna doormail. Dit werkt prima. In de pdf staan gegevens die ik haal uit een mysql-tabel. Nu wil ik graag dat er een melding verschijnt als de mysql-query leeg is. Ik ben al aan het experimenteren geweest met mysql_num_rows maar dit wilde niet lukken. Wie weet hoe dit moet ? Onderstaand vindt je de code:
Ik heb een code waarmee ik een pdf creeer en daarna doormail. Dit werkt prima. In de pdf staan gegevens die ik haal uit een mysql-tabel. Nu wil ik graag dat er een melding verschijnt als de mysql-query leeg is. Ik ben al aan het experimenteren geweest met mysql_num_rows maar dit wilde niet lukken. Wie weet hoe dit moet ? Onderstaand vindt je de code:
PHP:
<link href="../style.css" rel="stylesheet" type="text/css">
<?php
define(FPDF_FONTPATH,'font/');
require('../fpdf/fpdf.php');
require("phpmailer/class.phpmailer.php");
class PDF extends FPDF {
var $tablewidths;
var $headerset;
var $footerset;
function _beginpage($orientation) {
$this->page++;
if(!$this->pages[$this->page]) // solved the problem of overwriting a page, if it already exists
$this->pages[$this->page]='';
$this->state=2;
$this->x=$this->lMargin;
$this->y=$this->tMargin;
$this->lasth=0;
$this->FontFamily='';
//Page orientation
if(!$orientation)
$orientation=$this->DefOrientation;
else
{
$orientation=strtoupper($orientation{0});
if($orientation!=$this->DefOrientation)
$this->OrientationChanges[$this->page]=true;
}
if($orientation!=$this->CurOrientation)
{
//Change orientation
if($orientation=='P')
{
$this->wPt=$this->fwPt;
$this->hPt=$this->fhPt;
$this->w=$this->fw;
$this->h=$this->fh;
}
else
{
$this->wPt=$this->fhPt;
$this->hPt=$this->fwPt;
$this->w=$this->fh;
$this->h=$this->fw;
}
$this->PageBreakTrigger=$this->h-$this->bMargin;
$this->CurOrientation=$orientation;
}
}
function Header()
{
global $maxY;
// Check if header for this page already exists
if(!$this->headerset[$this->page]) {
foreach($this->tablewidths as $width) {
$fullwidth += $width;
}
$this->SetY(($this->tMargin) - ($this->FontSizePt/$this->k)*2);
$this->cellFontSize = $this->FontSizePt ;
$this->SetFont('Arial','',( ( $this->titleFontSize) ? $this->titleFontSize : $this->FontSizePt ));
$this->Cell(0,$this->FontSizePt,$this->titleText,0,1,'C');
$l = ($this->lMargin);
$this->SetFont('Arial','',$this->cellFontSize);
foreach($this->colTitles as $col => $txt) {
$this->SetXY($l,($this->tMargin));
$this->MultiCell($this->tablewidths[$col], $this->FontSizePt,$txt);
$l += $this->tablewidths[$col] ;
$maxY = ($maxY < $this->getY()) ? $this->getY() : $maxY ;
}
$this->SetXY($this->lMargin,$this->tMargin);
$this->setFillColor(200,200,200);
$l = ($this->lMargin);
foreach($this->colTitles as $col => $txt) {
$this->SetXY($l,$this->tMargin);
$this->cell($this->tablewidths[$col],$maxY-($this->tMargin),'',1,0,'L',1);
$this->SetXY($l,$this->tMargin);
$this->MultiCell($this->tablewidths[$col],$this->FontSizePt,$txt,0,'C');
$l += $this->tablewidths[$col];
}
$this->setFillColor(255,255,255);
// set headerset
$this->headerset[$this->page] = 1;
}
$this->SetY($maxY);
}
function Footer() {
// Check if footer for this page already exists
if(!$this->footerset[$this->page]) {
$this->SetY(-15);
//Page number
$this->Cell(0,10,'Collectenadministratie Hervormde Gemeente Oud-Vossemeer Pagina '.$this->PageNo().'/{nb}',0,0,'C');
// set footerset
$this->footerset[$this->page] = 1;
}
}
function morepagestable($lineheight=8) {
// some things to set and 'remember'
$l = $this->lMargin;
$startheight = $h = $this->GetY();
$startpage = $currpage = $this->page;
// calculate the whole width
foreach($this->tablewidths as $width) {
$fullwidth += $width;
}
// Now let's start to write the table
$row = 0;
while($data=mysql_fetch_row($this->results)) {
$this->page = $currpage;
// write the horizontal borders
$this->Line($l,$h,$fullwidth+$l,$h);
// write the content and remember the height of the highest col
foreach($data as $col => $txt) {
$this->page = $currpage;
$this->SetXY($l,$h);
$this->MultiCell($this->tablewidths[$col],$lineheight,$txt,0,$this->colAlign[$col]);
$l += $this->tablewidths[$col];
if($tmpheight[$row.'-'.$this->page] < $this->GetY()) {
$tmpheight[$row.'-'.$this->page] = $this->GetY();
}
if($this->page > $maxpage)
$maxpage = $this->page;
unset($data[$col]);
}
// get the height we were in the last used page
$h = $tmpheight[$row.'-'.$maxpage];
// set the "pointer" to the left margin
$l = $this->lMargin;
// set the $currpage to the last page
$currpage = $maxpage;
unset($data[$row]);
$row++ ;
}
// draw the borders
// we start adding a horizontal line on the last page
$this->page = $maxpage;
$this->Line($l,$h,$fullwidth+$l,$h);
// now we start at the top of the document and walk down
for($i = $startpage; $i <= $maxpage; $i++) {
$this->page = $i;
$l = $this->lMargin;
$t = ($i == $startpage) ? $startheight : $this->tMargin;
$lh = ($i == $maxpage) ? $h : $this->h-$this->bMargin;
$this->Line($l,$t,$l,$lh);
foreach($this->tablewidths as $width) {
$l += $width;
$this->Line($l,$t,$l,$lh);
}
}
// set it to the last page, if not it'll cause some problems
$this->page = $maxpage;
}
function connect($host='localhost',$username='',$password='',$db=''){
$this->conn = mysql_connect($host,$username,$password) or die( mysql_error() );
mysql_select_db($db,$this->conn) or die( mysql_error() );
return true;
}
function query($query){
$this->results = mysql_query($query,$this->conn);
$this->numFields = mysql_num_fields($this->results);
}
function mysql_report($query,$dump=false,$attr=array()){
foreach($attr as $key=>$val){
$this->$key = $val ;
}
$this->query($query);
// if column widths not set
if(!isset($this->tablewidths)){
// starting col width
$this->sColWidth = (($this->w-$this->lMargin-$this->rMargin))/$this->numFields;
// loop through results header and set initial col widths/ titles/ alignment
// if a col title is less than the starting col width / reduce that column size
for($i=0;$i<$this->numFields;$i++){
$stringWidth = $this->getstringwidth(mysql_field_name($this->results,$i)) + 6 ;
if( ($stringWidth) < $this->sColWidth){
$colFits[$i] = $stringWidth ;
// set any column titles less than the start width to the column title width
}
$this->colTitles[$i] = mysql_field_name($this->results,$i) ;
switch (mysql_field_type($this->results,$i)){
case 'int':
$this->colAlign[$i] = 'R';
break;
default:
$this->colAlign[$i] = 'L';
}
}
// loop through the data, any column whose contents is bigger that the col size is
// resized
while($row=mysql_fetch_row($this->results)){
foreach($colFits as $key=>$val){
$stringWidth = $this->getstringwidth($row[$key]) + 6 ;
if( ($stringWidth) > $this->sColWidth ){
// any col where row is bigger than the start width is now discarded
unset($colFits[$key]);
}else{
// if text is not bigger than the current column width setting enlarge the column
if( ($stringWidth) > $val ){
$colFits[$key] = ($stringWidth) ;
}
}
}
}
foreach($colFits as $key=>$val){
// set fitted columns to smallest size
$this->tablewidths[$key] = $val;
// to work out how much (if any) space has been freed up
$totAlreadyFitted += $val;
}
$surplus = (sizeof($colFits)*$this->sColWidth) - ($totAlreadyFitted);
for($i=0;$i<$this->numFields;$i++){
if(!in_array($i,array_keys($colFits))){
$this->tablewidths[$i] = $this->sColWidth + ($surplus/(($this->numFields)-sizeof($colFits)));
}
}
ksort($this->tablewidths);
if($dump){
Header('Content-type: text/plain');
for($i=0;$i<$this->numFields;$i++){
if(strlen(mysql_field_name($this->results,$i))>$flength){
$flength = strlen(mysql_field_name($this->results,$i));
}
}
switch($this->k){
case 72/25.4:
$unit = 'millimeters';
break;
case 72/2.54:
$unit = 'centimeters';
break;
case 72:
$unit = 'inches';
break;
default:
$unit = 'points';
}
print "All measurements in $unit\n\n";
for($i=0;$i<$this->numFields;$i++){
printf("%-{$flength}s : %-10s : %10f\n",
mysql_field_name($this->results,$i),
mysql_field_type($this->results,$i),
$this->tablewidths[$i] );
}
print "\n\n";
print "\$pdf->tablewidths=\n\tarray(\n\t\t";
for($i=0;$i<$this->numFields;$i++){
($i<($this->numFields-1)) ?
print $this->tablewidths[$i].", /* ".mysql_field_name($this->results,$i)." */\n\t\t":
print $this->tablewidths[$i]." /* ".mysql_field_name($this->results,$i)." */\n\t\t";
}
print "\n\t);\n";
exit;
}
} else { // end of if tablewidths not defined
for($i=0;$i<$this->numFields;$i++){
$this->colTitles[$i] = mysql_field_name($this->results,$i) ;
switch (mysql_field_type($this->results,$i)){
case 'int':
$this->colAlign[$i] = 'R';
break;
default:
$this->colAlign[$i] = 'L';
}
}
}
mysql_data_seek($this->results,0);
$this->Open();
$this->setY($this->tMargin);
$this->AddPage();
$this->morepagestable($this->FontSizePt);
// $this->Output();
}
}
$pdf = new PDF('L','pt','A3');
$pdf->SetFont('Arial','',11.5);
$pdf->AliasNbPages();
$pdf->connect('localhost','xxxx','xxxxx','xxxx_');
$attr=array('titleFontSize'=>18,'titleText'=>'Collectenopbrengsten t.b.v. de Jeugdraad');
$pdf->mysql_report("SELECT tblinvoerlijstperioden.Periode_naam as Periode, date_format(tbldatum.Datum, '%d-%m-%Y')
as Teldatum, tblsqlcollecten.doel, CONCAT('€ ', FORMAT(declaraties_bedrag1 + declaraties_bedrag2 + declaraties_bedrag3 +
declaraties_bedrag4 + declaraties_bedrag5 + (`plastic_1,00` * 1 + `plastic_0,50` * 0.5 + papier_500 * 500 +
papier_200 * 200 + papier_100 * 100 + papier_50 * 50 + papier_20 * 20 + papier_10 * 10 + papier_5 * 5 + `2,00` * 2 +
`1,00` * 1 + `0,50` * 0.5 + `0,20` * 0.2 + `0,10` * 0.1 + `0,05` * 0.05) * verdeelsleutel,2)) AS Totaal
FROM tbldatum INNER JOIN tblsqlcollecten ON (tbldatum.Periode_nr = tblsqlcollecten.Periode)
INNER JOIN tblinvoerlijstcollectedoelen ON (tblsqlcollecten.doel = tblinvoerlijstcollectedoelen.Doel)
INNER JOIN tblinvoerlijstperioden ON (tbldatum.Periode_nr = tblinvoerlijstperioden.Periode_nr)
WHERE (Datum = (SELECT max(Datum) AS FIELD_1 FROM tbldatum WHERE (tbldatum.Datum <= now())))
AND (tblinvoerlijstcollectedoelen.Storten_naar = 'Jeugdraad')ORDER BY
tblsqlcollecten.doel",false,$attr);
$pdf->Output('jeugdraad.pdf','F');
$mail = new PHPMailer();
$mail->Host = "mail.xxxx.nl"; // your SMTP Server
$mail->Mailer = "smtp"; // SMTP Method
$mail->SMTPAuth = true; // Auth Type
$mail->Username = "hervormd";
$mail->Password = "xxxx";
$mail->From = "xxxx@xxxxxxxxl";
$mail->FromName = "xxxx";
$mail->AddAddress("xxxx@xxx.nl", "Jeugdraad");
$mail->Subject = "Collecte-opbrengsten t.b.v. de jeugdraad";
$mail->IsHTML(true); //html opmaak
$mail->Body = "Geachte jeugdraad,<p>Hierbij ontvangt u de laatste collecte-opbrengsten.
<br>Op de <a href='xxxxx</a> kunt
u meer informatie vinden.</p><p>
Met vriendelijke groet,</p>
xxx";
$mail->AddAttachment("jeugdraad.pdf","jeugdraad.pdf"); // ff de BIJLAGE insluiten bij de mail
//STUUR MAIL MET BIJLAGE
//$mail->Send();
if(!$mail->Send())
{
echo "Er is een fout opgetreden, neem a.u.b. contact op.";
echo "Mailer Error: " . $mail->ErrorInfo;
}
echo "De mail is verzonden naar <a href='mailto:xx@xx.nl'>xxx</a></body> .<br>";
echo "<a href='CustomView13list.php'>";
echo "<img src='images/back-enabled.gif' alt='Terug naar de lijst' width='16' height='16' border='0'></a>";
?>
Laatst bewerkt:
