PHP - Give Unique Values Inside Dynamiclist

I want to create an application for sending mails using PHPMailer by placing it on my website

server (using SMTP),
but I can not get object of class phpmailer to change its properties of:

to_name
to_email
ContentType

from default (i.e. null).
Why are the properties keeping default values from the PHPMailer class, and not accepting my

once, though I check values i get from DB and they are good. ContentType is set in a config file.


Here is part of var_dump ($mailer); object of my extended class:
object(MyMailer)#2 (56) { ["priority"]=> int(3) ["to_name"]=> NULL ["to_email"]=> NULL ...
["ContentType"]=> string(10) "text/plain"...

also I get value of ["Port"]=> int(26) but ["SMTP_PORT"]=> int(25).
I need to use smtp port  26.


And here is the extended class of phpmailer

require_once './PHPMailer/class.phpmailer.php';
require_once 'mailer-config.php';

class MyMailer extends PHPMailer
{
    var $priority = 3;
    var $to_name = null;
    var $to_email = null;
    var $From = null;
    var $FromName = null;
    var $Sender = null;
    var $ContentType = null;
   
    function MyMailer()
       {
       global $eSlanje;
       
       // Comes from mailer-config.php $eSlanje array
       
        if($eSlanje['smtp_mode'] == 'enabled')
           {
            $this->Host = $eSlanje['smtp_host'];
            $this->Port = $eSlanje['smtp_port'];
            if($eSlanje['smtp_username'] != '')
               {
                $this->SMTPAuth = true;
                $this->Username = $eSlanje['smtp_username'];
                $this->Password = $eSlanje['smtp_password'];
               }
            $this->Mailer = "smtp";
           }
        if(!$this->From)
           {
            $this->From = $eSlanje['from_email'];
           }          
        if(!$this->FromName)
           {
            $this->FromName = $eSlanje['from_name'];
           }
        if(!$this->Sender)
           {
            $this->Sender = $eSlanje['from_email'];
           }
        $this->Priority = $this->priority;
        //echo "<br>eSlanje[content_type]";
        //var_dump ($eSlanje['content_type']);
       $this->ContentType = $eSlanje['content_type'];   
       }
}

and here is the cofig file:

mailer-config.php

<?php
$eSlanje['from_email'] = "hi@mysite.com";
$eSlanje['from_name'] = "Joe Blog";
$eSlanje['title'] = "hi there";
$eSlanje['content_type'] ="text/html";

$eSlanje['smtp_username'] = null;
$eSlanje['smtp_mode'] = "enabled";
$eSlanje['smtp_port'] = 26;
$eSlanje['smtp_host'] = "mail.mysite.com";



Here is where I insert values of email and name into the object:
<?php session_start();
   include ("password.php");
   require_once 'class_lib/MyMailer.php';
   require "class_lib/MySQL_Database.php";
   require "get_email_template.php";
   
   $db = new MySQL_Database ();
   
   $id = isset($_GET['id']) ?  $_GET['id'] : false;
   $sql = "select email,ime from ".TABLE." where id = $id";
   $query = mysql_query ($sql);
   $toClient = mysql_fetch_array($query);
   
   $to = isset($toClient['email']) ? $toClient['email'] : false;

   var_dump($to); // here I get a valid email address

   $to_name = isset($toClient['ime']) ? $toClient['ime'] : false;

   //var_dump($to_name); // here I get a valid preson's name
   
   $mailer = new MyMailer();
   $mailer->AddAddress($to, $to_name);
   $mailer->Body = get_htmlBody();
   $mailer->AltBody = get_txtBody();
   if(!$mailer->Send())
      {
      echo "<br> Mailer Error: " . $mailer->ErrorInfo."&nbsp";   
      }
      else {
         echo "<br>message not sent &nbsp";
         }
   $mailer->ClearAddresses();
            
   var_dump($mailer); // this is where the object trace comes from
?>   

I have a Unique Constraint setup on (emailAddress and pin) to allow multiple email addresses be the same and multiple pins but not the same emailAddress and pin value together (unique(emailAddress, pin))

Anyway, I am trying to generate a pin through a random seed, but I can't get my code to work properly to test if the combination already exists.

Here is the chunk that does not work:

Code: [Select]

$tries = 0;
$foundRows=0;
do {
$pin=null;
$tries++;
$pin = str_pad(rand(0,9), 4, "0", STR_PAD_LEFT);


$stmt = $dbh->prepare("SELECT COUNT(*) FROM ajax WHERE emailAddress=:email AND pin=:pin LIMIT 1");
if ($stmt->bindParam(':email', $email, PDO::PARAM_STR) &&
$stmt->bindParam(':pin', $pin, PDO::PARAM_INT)) {
$stmt->execute();
$foundRows = $dbh->query("SELECT FOUND_ROWS()")->fetchColumn();
echo "<br />$foundRows<br />";
} else {
die ("<p>Could not bind to data verification</p>");
}
} while ($foundRows > 0);


This is always returning $foundRows=0 so always exiting the loop, and giving me a constraint error.

Any ideas? Maybe a better way to do this?

I have a simple db with values.

I want to find all duplicate values and rename them 1,2,3 - so if I have these values for a 'colour' field:

pID / color

1 / brown
2 / blue
3 / red
4 / red
5 / brown

...would result in:

1 / brown1
2 / blue
3 / red1
4 / red2
5 / brown2

...is this possible?

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

Hello All,

I have a contact directory database. It has all the employees of my company (name, phone, email, department, building, etc).

Say on one page I have the Marketing Department, and I want to say:
"The Marketing Department Director is ________"

How would I assign that value from the database? Do I want to put in a unique "keyword" field in the database, but then how would I store all the values automatically on the page?

I see pages where I would want to list the Marketing Director, and his secretary, then another page with the Sales Director, and his secretary, etc....  all with being able to change the values in the database, and it changing across all the pages instantly.

Do I need to say on every page "select * from database where keyword = marketingdirector" and then store that result as a variable? It seems unpractical to repeat that a few times for each different person I want to list.

Is there a better way to do this then I'm thinking?

Thanks all!