PHP - Just Can't Figure Out Why Implode Doesn't Work As Expected.

I have an avatar upload script.

The uploading and moving of the image file to the correct directory works fine, but the displaying of the image causes problems.

This is the code that is supposed to display the avatar.


// _DISPLAY_ avatar - START
$query2 = "SELECT * FROM user WHERE user_id = '$dbuser_id'";

$row2 = mysqli_query ($dbc, $query2) or die (mysqli_error($dbc));

$assoc2 = mysqli_fetch_assoc ($row2);

$target = AVATAR_UPLOADPATH; 

$avatar_name = $target . $assoc2['avatar'];

if (is_file($assoc2['avatar'])) {

echo "<img src='$avatar_name' alt='Avatar' /><br /><br />";

} else { 

echo "is not a regular file"; 

}

// END


The avatar column in the MySQL database says: image.jpg

So there's a regular file.

What I want to accomplish:
I want the script to check if there's an avatar in the database, if NOT, then it should say: "no avatar uploaded yet."

But as it is now it's telling me that there's no regular file even if there is, as I said the avatar column has an entry saying: image.jpg.

Should I use if !empty instead?

The strange thing is it used to work, now for some reason it suddenly doesn't.

EDIT:
With !empty it works, am I using the is_file function incorrectly?

I need someone to look over this and just see if they can see why this won't work anymore?

It worked when the site was in development but when it came down to the day it's not working.

Basically it reads a CSV and inserted the driver into a Quali or Results table in the correct order but it's not working anymore?

If someone could have a read over it and suggest what might be going wrong that would be great.

Edit: It basically just added the same driver 24 times in the table.

Code: [Select]
Public Function ProcessUpload($UR, $RaceID, $RaceName) {
Global $MDB;
// Configuration - Your Options
  $allowed_filetypes = array('.csv'); // These will be the types of file that will pass the validation.
  $max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB).
  $upload_path = './resultsfiles/'; // The place the files will be uploaded to (currently a 'files' directory).

$filename = $_FILES['userfile']['name']; // Get the name of the file (including file extension).
$ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); // Get the extension from the filename.

If (strpos($filename, "Quali") == True) {
$tbl_name = "QualiPositions";
$FN = " - Qualifying";
} Else {
$tbl_name = "RacePositions";
$FN = " - Race";
}

$SQL = "SELECT count(*) FROM $tbl_name WHERE RaceID = $RaceID";
$Count = $MDB->prepare($SQL);
$Count->execute();
$Count = $Count->fetchColumn();

If ($Count == 24) {
$Msg = "<div class='error'>Error: We already have 24 Results for this Session.</div>";
}

// Check if the filetype is allowed, if not DIE and inform the user.
if(!in_array($ext,$allowed_filetypes))
  $Msg = "<div class='error'>Error: The file you attempted to upload is not allowed.</div>";

// Now check the filesize, if it is too large then DIE and inform the user.
if(filesize($_FILES['userfile']['tmp_name']) > $max_filesize)
  $Msg ="<div class='error'>Error: The file you attempted to upload is too large.</div>";

// Check if we can upload to the specified path, if not DIE and inform the user.
if(!is_writable($upload_path))
  $Msg ="<div class='error'>Error: You cannot upload to the specified directory, please CHMOD it to 777.</div>";

If (strpos($Msg, "Error:") == False) {

// Upload the file to your specified path.
$filename = str_replace(" ", "", $RaceName)."$FN.csv";
if (move_uploaded_file($_FILES['userfile']['tmp_name'],$upload_path . $filename)) {
    $FilePath = $upload_path . $filename;
if (($handle = fopen($FilePath, "r")) !== FALSE) {
$Pos = 0;
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
       
        for ($c=0; $c < $num; $c++) {
        $Pos++;
        If ($Pos <= 24) {
            $Driver = explode(" ", $data[$c]);
            $FName = $Driver[0];
            $LName = $Driver[1]." ".$Driver[2]." ".$Driver[3];
            $STH = $MDB->query("SELECT * FROM Drivers WHERE FirstName = '$FName' AND LastName = '$LName'");
$STH->setFetchMode(PDO::FETCH_OBJ);
while($row = $STH->fetch()) {
$DriverID = $row->DriverID;
$ChassisID = $row->ChassisID;
$EngineID = $row->EngineID;
}
$STH = $MDB->prepare("INSERT INTO $tbl_name(RaceID, DriverID, ChassisID, EngineID, Position, DSQ) VALUES (:RID, :DID, :ChaID, :EngID, :Pos, :DSQ)");
$STH->execute(array('RID' => $RaceID, 'DID' => $DriverID, 'ChaID' => $ChassisID, 'EngID'=>$EngineID, 'Pos'=>$Pos, 'DSQ' => 0));
$Msg = "<div class='team_confirm'>The Results have been uploaded for the $RaceName</div>";
} Else {
If ($tbl_name == "RacePositions") {
$Driver = explode(" ", $data[$c]);
            $FName = $Driver[0];
            $LName = $Driver[1]." ".$Driver[2]." ".$Driver[3];
            $STH = $MDB->query("SELECT * FROM Drivers WHERE FirstName = '$FName' AND LastName = '$LName'");
$STH->setFetchMode(PDO::FETCH_OBJ);
while($row = $STH->fetch()) {
$DriverID = $row->DriverID;
}

$sql = "UPDATE RacePositions SET FastLap = 'Yes' WHERE RaceID=? AND DriverID = ?";
$q = $MDB->prepare($sql);
$q->execute(array($RaceID, $DriverID));
}
}
        }
    }
    fclose($handle);
}
} else {
     $Msg = 'There was an error during the file upload.  Please try again.'; // It failed :(.
}
}

Return $Msg;
}


That is the code, the CSV is basically like this:
Code: [Select]
Lewis Hamilton,
Jenson Button,
Romain Grosjean,
Michael Schumacher,
Mark Webber,
Sebastian Vettel,
Nico Rosberg,
Pastor Maldonado,
Nico Hulkenberg,
Daniel Ricciardo,
Jean-Eric Vergne,
Fernando Alonso,
Kamui Kobayashi,
Bruno Senna,
Paul di Resta,
Felipe Massa,
Kimi Raikkonen,
Heikki Kovalainen,
Vitaly Petrov,
Timo Glock,
Charles Pic,
Sergio Perez,
Pedro de la Rosa,
Narain Karthikeyan
Thanks for any help!

I created a function called converter.  My code doesn't look like it processes anything after the first if . This is what is displayed in browser.

Convert a String

original string: roses Are red, violets are blue....
converted string: roses are red, violets are blue....
converted string: roses are red, violets are blue....
converted string: roses are red, violets are blue....



<html>
<head>
<title>Create a PHP Function to Convert a String</title>
</head>
<body bgcolor="pink">
<h2>Convert a String</h2>



<?php
   $phrase = "roses Are red, violets are blue....";
   function converter($arg1, $arg2){
   
   if($arg1="lower"){
   return strtolower($arg2);
}
   elseif ($arg1="upper"){
   return strtoupper($arg2);
}
   else
   /* if($arg1="title")*/{
   return ucwords($arg2);
}
}

print "original string: ".$phrase."<br />";

print "converted string: ".converter("upper",$phrase)."<br />";

print "converted string: ".converter("lower",$phrase)."<br />";

print "converted string: ".converter("title",$phrase)."<br />";

?>
</body>
</html>

Hey all,

It's easy to look at documentation and see what each of these functions and that super global do individually. But I'm not sure how the three are working together he

Code: [Select]
define('APPLICATION_PATH', realpath('../'));

$paths = array(
APPLICATION_PATH,
get_include_path()
);
set_include_path(implode(PATH_SEPARATOR, $paths));

Thanks for response.

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=319071.0