<?php 
 ini_set('display_errors', 1);
 ini_set('display_startup_errors', 1);
 //error_reporting(E_ALL);
 $db = mysql_connect("localhost","root","gsTYww7aAM4Uv8XRWsP") or die(mysql_error());
 $cnct = mysql_select_db("iti_21") or die(mysql_error());
 
 
 
 $query = "select * from application";
			$res = mysql_query($query);
			while($row= mysql_fetch_array($res)) { 
			
			$id = $row['id'];
			
			$q = "select * from filled_seat where application_id='".$id."' and is_admitted=1";
			$r = mysql_query($q);
			while($rows= mysql_fetch_array($r)) { 
			 $img = $row['image'];
			 $ref= $row['reference_no'];
			 echo "<br>";
 
  
	 
	 
	 $old_name = $img ;  
  
// New Name For The File 



 $filePath = 'three/'.$img;
  
/* New File name */
$new_name = 'three/'.$ref."_".$img ;  
  
/* Rename File name */
if( !rename($filePath, $new_name) ) {  
    echo "File can't be renamed!";  
}  
else {  
    echo "File has been renamed!";  
} 


	 		}
			
			
			}
			
			
 
 ?>
 
 <? 
 
 


?>

  
   