PHP - Images Unlinking But Not Replaced.

Hi, I have a "user profile" page and it has a profile image upload form. I have it so that the old profile  image is deleted, and the new image is uploaded and the new image is echoed out using the name of the new file from the database. The problem is, when I click submit to add the new image, the old image still stays there and the new image does not show up. Only when I manually click refresh on my browser does the new image show up.

That is going to be bad for my users. Please if anyone can help, I'd greatly appreciate it.  Below is the code I am using to delete the old image, and code to upload the image as well, when the photo upload form is used.

Code: [Select]
if(isset($_POST['photoUpload']))

{

if(file_exists("images/".$currentUser.".jpg")){
    unlink("images/".$currentUser.".jpg");
    clearstatcache();

}
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
//if it is not empty
if ($image)
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);
//get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and will not upload the file,
//otherwise we will do more tests
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
{
//print error message
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
}
//end if here
//was else here

//get the size of the image in bytes
//$_FILES['image']['tmp_name'] is the temporary filename of the file
//in which the uploaded file was stored on the server
$size=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name= $currentUser .'.'.$extension;
//$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname=$image_name;
//"images/".
// Connects to your Database
mysql_connect("host", "user", "pass") or die(mysql_error());
mysql_select_db("database") or die(mysql_error()) ;



//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES['image']['tmp_name'], "images/".$newname);
// update the photo name in the database
$result = mysql_query("UPDATE users SET profilePhoto='$newname'  WHERE                                                username='$currentUser'")
or die(mysql_error()); 

if (!$copied)
{
echo '<h1>Copy unsuccessful!</h1>';
$errors=1;
}
else{
$dir="images/";

echo "<p>Profile Picture Change Successful!</p>";

echo "<img src='{$dir}{$newname}' alt='{$newname}' height='200' width='200' />";
echo "<p></p>";

}

}

Here is what I'm working with. what is working is the BOLD RED in the code is what is taking my drop down selection and placing it in the search text field.

Here is my code

<center>
<table cellpadding="5" cellspacing="1" class="searchBox">
<tr>
<td align="center">

<form action="search.php" method="get">

<table><tr><td>
<div align="left">
<input type="text" name="query" id="query" size="40" value="<?php print quote_replace($query);?>" action="include/js_suggest/suggest.php" columns="2" autocomplete="off" delay="1500">
<form action="" method ="post">
<p>
<select name="state" onchange="document.getElementById('query').value=this.value;">
<option value="Nation Wide"> Nation Wide </option>
<option value="Nation Wide ex AK/HI"> Nation Wide ex AK & HI </option>
<option value="Alabama"> Alabama </option>
<option value="Alaska"> Alaska </option>
<option value="Arizona"> Arizona </option>
<option value="Arkansas"> Arkansas </option>
<option value="California"> California </option>
<option value="Colorado"> Colorado </option>
<option value="Connecticut"> Connecticut </option>
<option value="Deleware"> Deleware </option>
<option value="Florida"> Florida </option>
<option value="Georgia"> Georgia </option>
<option value="Hawaii"> Hawaii </option>
<option value="Idaho"> Idaho </option>
<option value="Illinois"> Illinois </option>
<option value="Indiana"> Indiana </option>
<option value="Iowa"> Iowa </option>
<option value="Kansas"> Kansas </option>
<option value="Kentucky"> Kentucky </option>
<option value="Louisiana"> Louisiana </option>
<option value="Maine"> Maine </option>
<option value="Maryland"> Maryland </option>
<option value="Massachusetts"> Massachusetts </option>
<option value="Michigan"> Michigan </option>
<option value="Minnesota"> Minnesota </option>
<option value="Mississippi"> Mississippi </option>
<option value="Missouri"> Missouri </option>
<option value="Montana"> Montana </option>
<option value="Nebraska"> Nebraska </option>
<option value="Nevada"> Nevada </option>
<option value="New Hampshire"> New Hampshire </option>
<option value="New Jersey"> New Jersey </option>
<option value="New Mexico"> New Mexico </option>
<option value="New York"> New York </option>
<option value="North Carolina"> North Carolina </option>
<option value="North Dakota"> North Dakota </option>
<option value="Ohio"> Ohio </option>
<option value="Oklahoma"> Oklahoma </option>
<option value="Oregon"> Oregon </option>
<option value="Pennsylvania"> Pennsylvania </option>
<option value="Rhode Island"> Rhode Island </option>
<option value="South Carolina"> South Carolina </option>
<option value="South Dakota"> South Dakota </option>
<option value="Tennessee"> Tennessee </option>
<option value="Texas"> Texas </option>
<option value="Utah"> Utah </option>
<option value="Vermont"> Vermont </option>
<option value="Virginia"> Virginia </option>
<option value="Washington"> Washington </option>
<option value="West Virginia"> West Virginia </option>
<option value="Wisconsin"> Wisconsin </option>
<option value="Wyoming"> Wyoming </option>
</select>

<select name="prop" onchange="document.getElementById('query').value=this.value;">
<option value="Downtown or Streetfront"> Downtown or Streetfront </option>
<option value="Freestanding Pad"> Freestanding Pad </option>
<option value="Lifestyle Center"> Lifestyle Center </option>
<option value="Mall or Food Court"> Mall or Food Court </option>
<option value="Nontraditional Units"> Nontraditional Units </option>
<option value="Power Center"> Power Center </option>
<option value="Shopping Center"> Shopping Center </option>
<option value="Entertainment Center"> Entertainment Center </option>
<option value="Manufacturer Outlet Center"> Manafacturer Outlet Center </option>
<option value="Regional Mall"> Regional Mall </option>
</select>

<input type="submit" name="submit" value="search">
</p>
</form>
</div>
<td>&nbsp;</td></tr></table>


<?php if ($adv==1 || $advanced_search==1) {
?>
<table width = "100%">
<tr>
<td width="40%"><input type="radio" name="type" value="and" <?php print $type=='and'?'checked':''?>><?php print $sph_messages['andSearch']?></td>
<td><input type="radio" name="type" value="or" <?php print $_REQUEST['type']=='or'?'checked':''?>><?php print $sph_messages['orSearch']?></td></tr>
<tr>
<td><input type="radio" name="type" value="phrase" <?php print $_REQUEST['type']=='phrase'?'checked':''?>><?php print $sph_messages['phraseSearch']?></td>
<td><?php print $sph_messages['show']?>
<select name='results'>
<option <?php if ($results_per_page==10) echo "selected";?>>10</option>
<option <?php if ($results_per_page==20) echo "selected";?>>20</option>
<option <?php if ($results_per_page==50) echo "selected";?>>50</option>
<option <?php if ($results_per_page==100) echo "selected";?>>100</option>
</select>

<?php print $sph_messages['resultsPerPage']?>
</td>
</tr>
</table>
<?php }?>



<?php if ($catid<>0){?>
<center><b><?php print $sph_messages['Search']?></b>: <input type="radio" name="category" value="<?php print $catid?>"><?php print $sph_messages['Only in category']?> "<?php print $tpl_['category'][0]['category']?>'" <input type="radio" name="category" value="-1" checked><?php print $sph_messages['All sites']?></center>
<?php }?>
<input type="hidden" name="search" value="1">
</form>
<?php if ($has_categories && $search==1 && $show_categories){?>
<a href="search.php"><?php print $sph_messages['Categories']?></a>
<?php }?>
</td>

</tr>
</table>
</center>



I need help with understanding how to.....
1. Apply both drop downs to the search without erasing first one.
2. Separate by ( ) A SPACE

Any ideas and or help would be great.
Thanks in advance

I have a form where there are various fields one can edit and replace images as well. The problem is when one tries to replace the image they choose. It only replaces the path of the file on column "imageurl1" on the MySQL database and not on the one that was chosen. I'm also getting a "Invalid argument supplied for foreach()"

Here is the script

Code: [Select]
<?php
session_start();
include('SimpleImage.php');
$image = new SimpleImage();    
//error_reporting(E_ALL); 


// image upload folder
    $image_folder = 'images/classified/'; 
// fieldnames in form
$all_file_fields = array('image1', 'image2' ,'image3', 'image4', 'image5', 'image6', 'image7', 'image8', 'image9', 'image10', 'image11', 'image12');
// allowed filetypes
$file_types = array('jpg','gif','png');
// max filesize 5mb
$max_size = 5000000;
//echo'<pre>';print_r($_FILES);exit;

$time = time();
$count = 1;

foreach($all_file_fields as $fieldname){ 
if($_FILES[$fieldname]['name'] != ''){

$type = substr($_FILES[$fieldname]['name'], -3, 3);

// check filetype
if(in_array(strtolower($type), $file_types)){

//check filesize
if($_FILES[$fieldname]['size']>$max_size){
$error = "File too big. Max filesize is ".$max_size." MB";

}else{

// new filename
$filename = str_replace(' ','',$myusername).'_'.$time.'_'.$count.'.'.$type;

// move/upload file
$image->load($_FILES[$fieldname]['tmp_name']);
if($image->getWidth() > 150) { //if the image is larger that 150.
$image->resizeToWidth(500); //resize to 500.
}
$target_path = $image_folder.basename($filename); //image path.

$image->save($target_path); //save image to a directory.

//save array with filenames
$images[$count] = $image_folder.$filename;
$count = $count+1;

}//end if

}else{ $error = "Please use jpg, gif, png files";

}//end if
}//end if
}//end foreach



if($error != ''){ echo $error;
}else{
//error_reporting(E_ALL);
//ini_set('display_errors','On');

$id = $_POST['id'];
$id = substr($id, 0,5);
if($id < 1 || $id > 99999) exit;

  $servername = "localhost";
  $username = "";
  $password = "";

if(!$_POST["title"] || !$_POST["rent"] || !$_POST["fees"]){
header('location: fields.php');

}else if (!(preg_match('#^\d+(\.(\d{2}))?$#',($_POST["rent"])))){
header('location: rent.php');

}else{
$conn =  mysql_connect($servername,$username,$password)or die(mysql_error());
mysql_select_db("apts",$conn);

// validate id belongs to user
$sql_check = "SELECT * FROM apts WHERE id = '".$id."' AND username = '".$myusername."'";
$res = mysql_query($sql_check,$conn) or die(mysql_error());
$count = mysql_num_rows($res);

if ($count > 0){

$sql_images = "";
foreach($images as $number => $imagedetail){
if($imagedetail != ''){
$sql_images .= "imageurl".$number." = '".mysql_real_escape_string($imagedetail)."',";
}
}
$sql = "UPDATE apartments SET title = '".mysql_real_escape_string($_POST['title'])."', description = '".mysql_real_escape_string($_POST['description'])."', cross_streets = 

'".mysql_real_escape_string($_POST['cross_streets'])."', county = '".mysql_real_escape_string($_POST['county'])."', town = '".mysql_real_escape_string($_POST['town'])."', service = 

'".mysql_real_escape_string($_POST['service'])."', phone = '".mysql_real_escape_string($_POST['phone'])."', contact = '".mysql_real_escape_string($_POST['contact'])."', office = 

'".mysql_real_escape_string($_POST['office'])."', pets = '".mysql_real_escape_string($_POST['pets'])."', email = '".mysql_real_escape_string($_POST['email'])."', rooms = 

'".mysql_real_escape_string($_POST['rooms'])."', bath = '".mysql_real_escape_string($_POST['bath'])."', square = '".mysql_real_escape_string($_POST['square'])."', rent = 

'".mysql_real_escape_string($_POST['rent'])."', fees = '".mysql_real_escape_string($_POST['fees'])."', service = '".mysql_real_escape_string($_POST['service'])."', feeornofee = 

'".mysql_real_escape_string($_POST['feeornofee'])."', lease = '".mysql_real_escape_string($_POST['lease'])."', video= '".mysql_real_escape_string($_POST['video'])."', zipcode = 

'".mysql_real_escape_string($_POST['zipcode'])."',".$sql_images." videotitle = '".mysql_real_escape_string($_POST['videotitle'])."' WHERE id = '".$id."'";


//replace info with the table name above
$result = mysql_query($sql,$conn) or die(mysql_error());
header('location: apartments.php');


}else{
header('location: somethingwrong.php');
}
}
}
 
?>

I' stuck with writing function for searching replaced numbers and would really appreciate if someone can tell me what I'm doing wrong.   My table structure looks like:

CREATE TABLE servis.zamjene_brojeva (
  id INT(11) NOT NULL AUTO_INCREMENT,
  vrijeme TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  pocetni_broj VARCHAR(55) DEFAULT NULL,
  zamjenski_broj VARCHAR(55) DEFAULT NULL,
  glavni_broj VARCHAR(55) DEFAULT NULL,
  postoji_zamjena INT(1) DEFAULT NULL,
  PRIMARY KEY (id)
)

My function looks like this:

//funkcija za traženje zamjene brojeva
function zamjena_broja($kataloski_broj){
    
    //Traženje zamjenskog broja
    $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                     FROM zamjene_brojeva
                     WHERE glavni_broj = '$kataloski_broj'";
    $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
    $row = mysql_fetch_array($rezultat_zamjena);
        $kataloski_broj = $row["zamjenski_broj"];
        
    $broj_zamjena = mysql_num_rows($rezultat_zamjena);
    
        return $kataloski_broj;
    
    //Traženje druge zamjene broja
    if ($broj_zamjena <> 0) {
        
            $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                             FROM zamjene_brojeva
                             WHERE pocetni_broj = '$kataloski_broj'";
            $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
            $broj_zamjena2 = mysql_num_rows($rezultat_zamjena);
            $row2 = mysql_fetch_array($rezultat_zamjena);
                $kataloski_broj = $row2["zamjenski_broj"];
            
                return $kataloski_broj;
            
            //Traženje treće zamjene
            if ($broj_zamjena2 <> 0) {
                
                     $upit_zamjena = "SELECT pocetni_broj, zamjenski_broj, glavni_broj
                                      FROM zamjene_brojeva
                                      WHERE pocetni_broj = '$kataloski_broj'";
                     $rezultat_zamjena = mysql_query($upit_zamjena) or die (mysql_error());
                     $broj_zamjena3 = mysql_num_rows($rezultat_zamjena);
                     $row3 = mysql_fetch_array($rezultat_zamjena);
                        $kataloski_broj = $row3["zamjenski_broj"];
            
                         return $kataloski_broj;
                
            }
        
    }

}

In pocetni_broj is old number and in glavni_broj is new number. But it can happen that number in glavni_broj is old and I need to search in pocetni_broj to see if there is even newer number and it can happen 5 or 6 times like that.   I need to find all the numbers that are connected, but I'm not getting that. What am I doing wrong?

The situation is that I have a large string with some identifiers to say "replace me" with something else. My goal is to replace the values, but if one replacement includes one of the other keys, I don't want to replace it.   For example:

<?php
$str = 'some blob ~abc~ followed by ~def~';

$arr_orig = array(
	'~abc~',
	'~def~'
);

$arr_new  = array(
	'value~def~',
	'blah'
);

echo str_replace( $arr_orig, $arr_new, $str );
?>

This will echo: some blob valueblah followed by blah   But that's not what I'm trying to accomplish. Basically, I want ~abc~ to be replaced with the literal: value~def~ and for the ~def~ that happens to be part of that string to NOT be replaced. I hope what I'm asking is clear. Basically, preg_replace/str_replace with arrays seems no different than just doing a FOR loop and replacing ~abc~ and then ~def~. But that's not what I need.   I'm hoping that if ~abc~ is replaced with text that happens to be another identifier -- ~def~, ~xyz~, whatever -- that this already replaced text is not again replaced. Is there a built-in function to do something like this? If not, should I just parse the whole string and count characters or something? Seems like a pain (and slow!)