php recover all id

[EnKor 42]

Hi. How can i recover all ID from same email to email?

I have this, but for some reason it dont work.

 

if(isset($_POST['idrecover']) && $_POST['idrecover']=="Recuperar") {
    
    if(checkMail($_POST['idemail'])) {
      
      $email = mysql_real_escape_string($_POST['idemail']);

      
      $getUser = "SELECT login FROM account.account WHERE email='".$email."' LIMIT 100";
      $qryUser = mysql_query($getUser);
      
      if(mysql_num_rows($qryUser)>0) {
      
        $qryPass =  mysql_query($getUser);
        $login = mysql_real_escape_string($getUser);
        
        if($qryPass) {
          echo'<p class="meldung">xxxxxx';
          
          $absender = $serverSettings['titel']." Recuperação";
          $email = $serverSettings['pass_mail'];
          $empfaenger = $_POST['idemail'];
          $mail_body = "
          
          Hellou!! This is realy funny, but dont Work.
          
          
          ID: ".$login." ----------->>>> i wanna see all logins in Here!!!!
          
          
          
         
          
          $titel = "Recuperação de Password ".$serverSettings['titel'];
          
          $header .= "X-Priority: 3\n";
          $header .= "X-Mailer: mtVision Homepage Mailer\n";
          $header .= "MIME-Version: 1.0\n";
          $header .= "From: ".$absender." <".$serverSettings['pass_mail'].">\n";
          $header .= "Reply-To: ".$serverSettings['pass_mail']."\n";
          //$header .= "Content-Transfer-Encoding: 8bit\n"; 
          $header .= "Content-Type: text/plain; charset=iso-8859-1\n";
          
          if(!mail($empfaenger, $titel, $mail_body, $header)) {
            echo'<p class="meldung">xxxxxx';
          }
          
        }
        else {
          echo'<p class="meldung">xxxxxx';
        }
        
      }
      else {
        echo'<p class="meldung">xxxxxx';
      }
      
    }
    else {
      echo'<p class="meldung">xxxxxx';
    }
    
  }

Edited October 7, 2015 by EnKor

[fenixplayscz 16]

Make with while($row = $???) { 

echo row['login'];

}

[EnKor 42]

Can u place that in the right place :\   my php knolege is only 0.01% xD

[fenixplayscz 16]

Try this

 

<?php 
if(isset($_POST['idrecover']) && $_POST['idrecover']=="Recuperar") {
    
    if(checkMail($_POST['idemail'])) {
      
      $email = mysql_real_escape_string($_POST['idemail']);

      
      $query = "SELECT login FROM account.account WHERE email='".$email."' LIMIT 100";
      $result = mysql_query($query);
	  
		echo'<p class="meldung">xxxxxx';
		$absender = $serverSettings['titel']." Recuperação";
		$email = $serverSettings['pass_mail'];
		$empfaenger = $_POST['idemail'];
      if(mysql_num_rows($result)>0) {
      
        //$qryPass =  mysql_query($getUser);
		while($row = mysql_fetch_assoc($result)) {
			$mail_body = "
          
          Hellou!! This is realy funny, but dont Work.
          
          
          ID: ".$row['login']." ----------->>>> i wanna see all logins in Here!!!!";
		}          
          $titel = "Recuperação de Password ".$serverSettings['titel'];
          
          $header .= "X-Priority: 3\n";
          $header .= "X-Mailer: mtVision Homepage Mailer\n";
          $header .= "MIME-Version: 1.0\n";
          $header .= "From: ".$absender." <".$serverSettings['pass_mail'].">\n";
          $header .= "Reply-To: ".$serverSettings['pass_mail']."\n";
          //$header .= "Content-Transfer-Encoding: 8bit\n"; 
          $header .= "Content-Type: text/plain; charset=iso-8859-1\n";
          
          if(!mail($empfaenger, $titel, $mail_body, $header)) {
            echo'<p class="meldung">xxxxxx';
          }
        
      }
      else {
        echo'<p class="meldung">xxxxxx';
      }
      
    }
    else {
      echo'<p class="meldung">xxxxxx';
    }
    
  }

?>

 

[EnKor 42]

It works. But dont make the loop. Cuz only send one ID in that email and i have 23 ( Tests ) xD

 

 

The while loop need to be insine of:

$mail_body = "

 

 

no? :\

Edited October 7, 2015 by EnKor

[Ayaka 291]

i wrote that for you. NOT TESTED!

<?php
if(isset($_POST['idrecover']) && $_POST['idrecover']=="Recuperar") {
    if (checkMail($_POST['idemail'])) {
        $email = mysql_real_escape_string($_POST['idemail']);
        $getUser = "SELECT login FROM account.account WHERE email='" . $email . "'";
        $qryUser = mysql_query($getUser);

        if (mysql_num_rows($qryUser) > 0) {
            // Set empty array
            $foundLogins = array();
            // get all User IDs with the given email
            while ($row = mysql_fetch_array($qryUser)) {
                $foundLogins[] = $row['login'];
            }
            // config email
            $from = "[email protected]"; // email (from)
            $to = "[email protected]"; // email (to)
            $subject = "Subject"; // Subject

            $message = "Found the following IDs with the email " . $email . ":";
            foreach ($foundLogins as $foundLogin) {
                $message .= "ID: " . $foundLogin . " ,";
            }

            // set email header
            $headers = array();
            $headers[] = "MIME-Version: 1.0";
            $headers[] = "Content-type: text/plain; charset=iso-8859-1";
            $headers[] = "From: Sender Name <$from>";
            $headers[] = "Reply-To: Recipient Name <$from>";
            $headers[] = "Subject: {$subject}";
            $headers[] = "X-Mailer: PHP/" . phpversion();

            // send mail
            if (!mail($to, $subject, $message, implode("\r\n", $headers))) {
                echo "Email could not send";
            } else {
                echo "Email send";
            }
        } else {
            echo "No entries found with this email";
        }
    } else {
        echo "email not valid";
    }
} else {
    echo "fill the formular";
}
?>

Edit: Better without foreach:

<?php
if(isset($_POST['idrecover']) && $_POST['idrecover']=="Recuperar") {
    if (checkMail($_POST['idemail'])) {
        $email = mysql_real_escape_string($_POST['idemail']);
        $getUser = "SELECT login FROM account.account WHERE email='" . $email . "'";
        $qryUser = mysql_query($getUser);

        if (mysql_num_rows($qryUser) > 0) {
            // Set empty array
            $foundLogins = array();
            // get all User IDs with the given email
            while ($row = mysql_fetch_array($qryUser)) {
                $foundLogins[] = $row['login'];
            }
            // config email
            $from = "[email protected]"; // email (from)
            $to = "[email protected]"; // email (to)
            $subject = "Subject"; // Subject

            $message = "Found the following IDs with the email " . $email . ": ";
            $comma_separated = implode(",", $foundLogins);
            $finalMessage = $message.$comma_separated;

            // set email header
            $headers = array();
            $headers[] = "MIME-Version: 1.0";
            $headers[] = "Content-type: text/plain; charset=iso-8859-1";
            $headers[] = "From: Sender Name <$from>";
            $headers[] = "Reply-To: Recipient Name <$from>";
            $headers[] = "Subject: {$subject}";
            $headers[] = "X-Mailer: PHP/" . phpversion();

            // send mail
            if (!mail($to, $subject, $finalMessage, implode("\r\n", $headers))) {
                echo "Email could not send";
            } else {
                echo "Email send";
            }
        } else {
            echo "No entries found with this email";
        }
    } else {
        echo "email not valid";
    }
} else {
    echo "fill the formular";
}
?>

 

Edited October 8, 2015 by Ayaka

[EnKor 42]

Now it works. Tks Ayaka!

 

Only one more thing. In this way i get in my email all ids like xxxxxx, xxxxxx, xxxxxx,

Is it possible add one <br> ?

If so we will get:

Xxxxxxx,

Xxxxxxx, etc....

[fenixplayscz 16]

Try this

 

<?php
if(isset($_POST['idrecover']) && $_POST['idrecover']=="Recuperar") {
    if (checkMail($_POST['idemail'])) {
        $email = mysql_real_escape_string($_POST['idemail']);
        $getUser = "SELECT login FROM account.account WHERE email='" . $email . "'";
        $qryUser = mysql_query($getUser);

        if (mysql_num_rows($qryUser) > 0) {
            // Set empty array
            $foundLogins = array();
            // get all User IDs with the given email
            while ($row = mysql_fetch_array($qryUser)) {
                $foundLogins[] = $row['login'];
            }
            // config email
            $from = "[email protected]"; // email (from)
            $to = "[email protected]"; // email (to)
            $subject = "Subject"; // Subject

            $message = "Found the following IDs with the email " . $email . ": ";
            $comma_separated = implode(",", $foundLogins);
            $finalMessage = $message.$comma_separated."</br>";

            // set email header
            $headers = array();
            $headers[] = "MIME-Version: 1.0";
            $headers[] = "Content-type: text/plain; charset=iso-8859-1";
            $headers[] = "From: Sender Name <$from>";
            $headers[] = "Reply-To: Recipient Name <$from>";
            $headers[] = "Subject: {$subject}";
            $headers[] = "X-Mailer: PHP/" . phpversion();

            // send mail
            if (!mail($to, $subject, $finalMessage, implode("\r\n", $headers))) {
                echo "Email could not send";
            } else {
                echo "Email send";
            }
        } else {
            echo "No entries found with this email";
        }
    } else {
        echo "email not valid";
    }
} else {
    echo "fill the formular";
}
?>

 

[EnKor 42]

its the same :\ dont do <br>

Edited October 8, 2015 by EnKor

[Ayaka 291]

nope. you have to set the linebreak right in and after the implode function. <br> isnt working because you have to set "\r\n" for linebreaks in mail function in this case.

replace

$comma_separated = implode(",", $foundLogins);

with

$comma_separated = implode("\r\n",$foundLogins)."\r\n";

 

Edited October 8, 2015 by Ayaka

[EnKor 42]

nope. you have to set the linebreak right after the implode function. <br> isnt working because you have to set "\r\n" for linebreaks in mail function.

replace

$comma_separated = implode(",", $foundLogins);

with

$comma_separated = implode("\r\n",$foundLogins)."\r\n";

 

Now it works 100%

really grateful for your help

[pollux 789]

nope. you have to set the linebreak right in and after the implode function. <br> isnt working because you have to set "\r\n" for linebreaks in mail function in this case.

replace

$comma_separated = implode(",", $foundLogins);

with

$comma_separated = implode("\r\n",$foundLogins)."\r\n";

 

that's not 100% right. if you are able to read html emails, <br/> will work - for example in googlemail.

but \r\n is the better solution

[Ayaka 291]

nope. you have to set the linebreak right in and after the implode function. <br> isnt working because you have to set "\r\n" for linebreaks in mail function in this case.

replace

$comma_separated = implode(",", $foundLogins);

with

$comma_separated = implode("\r\n",$foundLogins)."\r\n";

 

that's not 100% right. if you are able to read html emails, <br/> will work - for example in googlemail.

but \r\n is the better solution

as i wrote "in this case". We have a text mail not a html mail. Maybe some email clients can read br tags in text mails but it is wrong to do it with this content type

Content-type: text/plain

Edited October 10, 2015 by Ayaka

[pollux 789]

well.. yes with this type <br> isn't the best thing. sorry, i did not read the script ^^