HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
File: D:/HostingSpaces/SBogers59/ferrumbv.nl/wwwroot/kes/admin/mass_bounce.php
	<table cellpadding="5" cellspacing="0" border="0">
		<tr>
        	<th>Counter</th>
            <th>Emailadres</th>
		</tr>
	<?php 
	
	$g = "SELECT * FROM bounce";
	
	$rec = mysql_query($g);
	
		$counter = 0;
	
	while( $r = mysql_fetch_array($rec)){
	
		$counter++;
		
		$emailadres = $r[1];
		
		$emailadres = trim($emailadres);
		
		?>
        
        <td><?php echo($counter); ?></td>
        
        <?php

		$query_select = "SELECT email_id FROM kes_emailadressen WHERE kes_emailadressen.emailadres = '$emailadres'";
		$res_select = mysql_query($query_select);
		$r_select = mysql_fetch_array($res_select);
		
		if(!empty($r_select[0])){
		
			$verwijderen1 = "DELETE FROM kes_sendings WHERE kes_sendings.email_id = '$r_select[0]'";
			$res_verwijderen1 = mysql_query($verwijderen1);
			
			$query_verwijderen = "DELETE FROM kes_emailadressen WHERE kes_emailadressen.emailadres = '$emailadres'";
			
			$res_verwijderen = mysql_query($query_verwijderen);
		}
		
		
	?>
        <td><?php
        
        if($res_verwijderen){ 
        
            echo("E-mailadres: ".$emailadres." is SUCCESVOL verwijderd<br />"); 
        
        }else{
            echo("E-mailadres: ".$emailadres." is NIET verwijderd<br />"); 
        }
        
        ?></td>
    </tr>
<?php
}?>
</table>