PHP - Prompt For A Filename

Is there a class out there that validates window filenames?

Thank you.

Hi everyone.

I have a small problem.
I have a database that shows student images, in the format of 1234.jpg but the file name extension is in both upper case and lower case.
My server OS is linux ubuntu. apache2 php5.
Linux see these as 2 different file so will not show the upper case ones. 1234.JPG

What i have already is working but for lower case only, i need something to detect when the extension is in uppercase and change accordingly.

This is what i have now that works for lower case only.

<img src=../images/mbr_images/<?php echo H($mbr->getBarcodeNmbr());?>.jpg height=150 width=100 border=1px </img

This is what i have tried but gives me a filename of "1234jpg" see the "." is missing? and is still lower case.

<img src=../images/mbr_images/<?php echo H($mbr->getBarcodeNmbr());
      
      $image = jpg;
      $image2 = JPG;
      
      if ($image = $image) {
      echo $image;
      } else {
      echo $image2;
      };?> height=150 width=100 border=1px </img>

can anyone offer any help please?

TIA
Peter

Hi all,

I am working on the PHP to fetch the data from the database. I would like to fetch the filename only following by:

email1.png
email2.png
email3.png
my_inbox.png

 

When I try this:           

$mailbox_sql = 'SELECT * FROM ' . $mailfolder . ' WHERE email_id = ? AND message_id = ?';
$mailbox = $link->prepare($mailbox_sql);
$mailbox->execute([$id,$message_id]); 

// set the resulting array to associative
$row = $mailbox->fetch(PDO::FETCH_ASSOC);

if (is_array($row)) {
   $attached = $row['attached_files'];
   $attached_files_name = explode('attid: ', $attached);
}

 

 

I am getting this:

0 filename: email1.png
1 filename: email2.png
2 filename: email3.png
3 filename: my_inbox.png

 

 

Here is what I have stored in the database:

 attid: 0 filename: email1.png
 attid: 1 filename: email2.png
 attid: 2 filename: email3.png
 attid: 3 filename: my_inbox.png

 

 

Here is what I want to achieve:

email1.png
email2.png
email3.png
my_inbox.png

 

 

Can you please show me example how I could get the filename when I am fetching the data from the database?

Thanks in advance.

Edited January 18, 2020 by mark107

How come my$_SERVER['PHP_SELF'] echos the filename.php

I have a rewrite rule and i need it to echo

http://site.com/file/321

instead of filename.php?id=321


Help! Godaddy wont tell me why its doing that

hi to all...

does anybody has an idea of parsing the filename of the textfile and its contents and insert to database..

example..

format of the filename:

[date] [cod] [time]
201089 1-111 93300.txt

contents of the text file:

12345 John Robinson
54321 Robert svenson

the table where the information should be inserted has this
fields.. name of table: logs

[ID] [name] [date] Code: [Select]
[time]

say for example the parsing is done..it should look like this.

[ID] [name] [date] [code] [time]

12345 John Robinson 2010-8-9 1-111 9:33:00
54321 Robert Svenson 2010-8-9 1-111 9:33:000

how can i do that??
can somebody help me?

thanks.

If it would be just CSS I would just put " " around the url, however this is a php script. Here's the line:

<li style="background: url({img server_id=$aSlidePhoto.server_id path='photo.url_photo' file=$aSlidePhoto.destination suffix='_175' title=$aSlidePhoto.title return_url=true}); width: 175px; height: 130px;">

It works for all images except, for example: myimage (1).jpg   What's the fix for such case?

Hi all

I am trying to write a script that takes the filename and username from a form and adds it into a mySQL database. At the moment only the username is added? Here's my code:

<?php
include('includes/connection.php');

$username = $_POST['username'];

date_default_timezone_set('Europe/London'); // Change time zone to GMT
$date = date ('D M j G:i:s'); // Set date format

$path= "/home/cndvizp/public_html/prints2impress.co.uk/images/uploads/".$HTTP_POST_FILES['ufile']['name'];


if($ufile !=none)
{
if(copy($HTTP_POST_FILES['ufile']['tmp_name'], $path))
{

//insert new query

$filename = $_FILES['ufile']['name'];

$pfw_strQuery = "INSERT INTO `uploads`(`username`,`url`,`date_entered`)VALUES (\"$username\",\"$filename\",\"$date\")" ;

$pfw_result = mysql_query($pfw_strQuery);
if (!$pfw_result) {
 die('Invalid query: ' . mysql_error());
}

//include ('payment.php');
echo 'done';
}

else

{
//include ('error.php');
echo 'error!';
exit;
}
}

?>

Can anyone help me get the filename and the date to be added?

Cheers
Pete.

This topic has been moved to mod_rewrite.

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

Hi,

this works:

if(file_exists("myFile.txt")){etc.}

this doesn't:

$myFile = "myFile.txt";
if(file_exists($myFile)){etc.}

Can anybody explain this to me?
I'd really like to pass the filename as a variable...

Kind regards,
R.

Hi   I am winning I think   I have got the records displayed for the current user logged in so basically they can only see their submitted listings and just working on the edit of them so the current user logged in can update their listing and is all working apart from the update of the images   the images are stored by the file name on the database and then gets moved onto the server so the actual images are not stored on the database only the file names are and the images are moved onto the server, hope that makes sense   what I can't do at the mo is work out how to update the file names of the images on the database and update on the server   I get the following error   Notice: Undefined index: photo on line 209 and line 211   the coding for them lines are below

$pic1= basename($_FILES['photo']['name'][0]);

$pic2= basename($_FILES['photo']['name'][1]);

The rest of the coding below that is

if(!empty($_FILES['photo']['tmp_name']))
{
	
	// Number of uploaded files
	 $num_files = count($_FILES['photo']['tmp_name']);

	 /** loop through the array of files ***/
	 for($i=0; $i < $num_files;$i++)
	 {
		 // check if there is a file in the array
		 if(!is_uploaded_file($_FILES['photo']['tmp_name'][$i]))
		 {
			 $messages[] = 'No file uploaded';
		 }
		 else
		 {
			 // move the file to the specified dir
			 if(move_uploaded_file($_FILES['photo']['tmp_name'][$i],$target.'/'.$_FILES['photo']['name'][$i]))
			 {
			
				 $messages[] = $_FILES['photo']['name'][$i].' uploaded';
				
			 }
			 else
			 {
				 // an error message
				 $messages[] = 'Uploading '.$_FILES['photo']['name'][$i].' Failed';
			 }
		 }
	 }

The update query is below

// save the data to the database
 mysql_query("UPDATE privatelistings SET listingtitle='$listingtitle', make='$model', model='$model', exteriorcolour='$exteriorcolour', enginesize='$enginesize', fueltype='$fueltype', yearregistered='$yearregistered', transmission='$transmission', mileage='$mileage', nodoors='$nodoors', bodystyle='$bodystyle', price='$price', photo='$pic1', photo1='$pic2' WHERE id='$id'")
 or die(mysql_error()); 

I am going to be updating to mysqli just want to get it working first   My HTML form coding is below

<form action="" method="post" enctype="multipart/form-data">
 <input type="hidden" name="id" value="<?php echo $id; ?>"/>
 <div>
 <strong>Listing Title: *</strong> <input type="text" name="listingtitle" value="<?php echo $listingtitle; ?>"/>
 <br/>
 <strong>Make: *</strong> <input type="text" name="make" value="<?php echo $make; ?>"/>
 <br/>
 <strong>Model: *</strong> <input type="text" name="model" value="<?php echo $model; ?>"/>
 <br/>
 <strong>Exterior Colour: *</strong> <input type="text" name="exteriorcolour" value="<?php echo $exteriorcolour; ?>"/>
 <br/>
 <strong>Engine Size: *</strong> <input type="text" name="enginesize" value="<?php echo $enginesize; ?>"/>
 <br/>
 <strong>Fuel Type: *</strong> <input type="text" name="fueltype" value="<?php echo $fueltype; ?>"/>
 <br/>
 <strong>Year Registered: *</strong> <input type="text" name="yearregistered" value="<?php echo $yearregistered; ?>"/>
 <br/>
 <strong>Transmission: *</strong> <input type="text" name="transmission" value="<?php echo $transmission; ?>"/>
 <br/>
 <strong>Mileage: *</strong> <input type="text" name="mileage" value="<?php echo $mileage; ?>"/>
 <br/>
 <strong>Number of Doors: *</strong> <input type="text" name="nodoors" value="<?php echo $nodoors; ?>"/>
 <br/>
 <strong>Body Style: *</strong> <input type="text" name="bodystyle" value="<?php echo $bodystyle; ?>"/>
 <br/>
 <strong>Price: *</strong> <input type="text" name="price" value="<?php echo $price; ?>"/>
 <br/>
 <strong>Photo One:</strong> <input type='hidden' name='size' value='350000'><input type='file' name='photo[]'>
 <br>
 <strong>Photo Two:</strong> <input type='hidden' name='size' value='350000'><input type='file' name='photo[]'>
 <br>
 <input type="submit" name="submit" value="Submit">
 </div>
 </form>

sorry was not sure what other I need to show, so you guys get the idea?

Hello, how do you search for a filename containing a date and then match it to a variable? Please note the filename may only contain some of the variable being matched to.

Any help appreciated...

Hi all,

I am working on my PHP script to open my emails by fetching the data from mysql database. When I open my emails I want to fetch the filename data next to `alt` in the img tag, example:  what-is-bootstrap.png so I can then send the filename data to `/project/u/index` to display the images.

Here is what my image will show as for example:

     <img src="/project/u/?id=47394f41507856374130672f6d65534430734f7177513d3d&attid=0.2&msgid=1630808059112201633&view=attachment&display=view" alt="what-is-bootstrap.png" width="452" height="302" class="gmail-a6T" tabindex="0">

Here is the index.php code:

   

<?php
    
    //ini_set('display_errors', 1);
    //ini_set('display_startup_errors', 1);
    //error_reporting(E_ALL);
    
    require_once "Mail.php";
    require_once('Mail/IMAPv2.php');
    
    $key = "**************";
    $email_number = openssl_decrypt(hex2bin($_GET['id']),'AES-128-CBC', $key);
    $attach_id = $_GET['attid'];
    $attachment_display = $_GET['display'];
    
    $attachments = array();
    $body_attachments = array();
    $attachment_number = 0;
    $inline_number = 0;
    $body_number = 0;
    
    
    if ($attachments >= 1) {
        
        if (($attach_id == 0) or ($attach_id > 0.9))  {
    
            if($attachments[$attach_id])
            {
                $filename = $attachments[$attach_id]['name'];
                $filePath = "attachments/" .$filename;
    
                if($attachment_display == 'download') {
                    header("Content-Type: application/octet-stream");
                    header("Content-Transfer-Encoding: Binary");
                    header("Content-disposition: attachment; filename=".basename($filename));
                    echo readfile($filePath);
                }
                else if($attachment_display == 'view') {
                    $type = 'image/jpeg';
                    header('Content-Type:'.$type);
                    header('Content-Length: ' . filesize($filePath));
                    readfile($filePath);
                }
            }
        }
    }
    
    if ($body_attachments >= 1) {
    
        if (($attach_id >= 0.1) && ($attach_id <= 0.9))  {
    
            if ($attach_id == '0.1') {
                $attach_id = 0;            
            }
            else if ($attach_id == '0.2') {
                $attach_id = 1;            
            }
            else if ($attach_id == '0.3') {
                $attach_id = 2;            
            }
            else if ($attach_id == '0.4') {
                $attach_id = 3;            
            }
            else if ($attach_id == '0.5') {
                $attach_id = 4;            
            }
            else if ($attach_id == '0.6') {
                $attach_id = 5;            
            }
            else if ($attach_id == '0.7') {
                $attach_id = 6;            
            }
            else if ($attach_id == '0.8') {
                $attach_id = 7;            
            }
            else if ($attach_id == '0.9') {
                $attach_id = 8;            
            }
            else if ($attach_id == '0.10') {
                $attach_id = 9;            
            }
            else if ($attach_id == '0.11') {
                $attach_id = 10;            
            }
            else if ($attach_id == '0.12') {
                $attach_id = 11;            
            }
            else if ($attach_id == '0.13') {
                $attach_id = 12;            
            }
            else if ($attach_id == '0.14') {
                $attach_id = 13;            
            }
            else if ($attach_id == '0.15') {
                $attach_id = 14;            
            }
            else if ($attach_id == '0.16') {
                $attach_id = 15;            
            }
            else if ($attach_id == '0.17') {
                $attach_id = 16;            
            }
            else if ($attach_id == '0.18') {
                $attach_id = 17;            
            }
            else if ($attach_id == '0.19') {
                $attach_id = 18;            
            }
            else if ($attach_id == '0.20') {
                $attach_id = 19;            
            }
            else if ($attach_id == '0.21') {
                $attach_id = 20;            
            }
            else if ($attach_id == '0.22') {
                $attach_id = 21;            
            }
            else if ($attach_id == '0.23') {
                $attach_id = 22;            
            }
            else if ($attach_id == '0.24') {
                $attach_id = 23;            
            }
            else if ($attach_id == '0.25') {
                $attach_id = 24;            
            }
            else if ($attach_id == '0.26') {
                $attach_id = 25;            
            }
            else if ($attach_id == '0.27') {
                $attach_id = 26;            
            }
            else if ($attach_id == '0.28') {
                $attach_id = 27;            
            }
            else if ($attach_id == '0.29') {
                $attach_id = 28;            
            }
            else if ($attach_id == '0.30') {
                $attach_id = 29;            
            }
            
            
            if(!$body_attachments[$attach_id]) {
                $attach_id++;
            }
    
    
            if($body_attachments[$attach_id])
            {
                $filename = $body_attachments[$attach_id]['name'];
                $filePath = "attachments/" .$filename;
    
                if($attachment_display == 'download') {
                    header("Content-Type: application/octet-stream");
                    header("Content-Transfer-Encoding: Binary");
                    header("Content-disposition: attachment; filename=".basename($filename));
                    echo readfile($filePath);
                }
                else if($attachment_display == 'view') {
                    $type = 'image/jpeg';
                    header('Content-Type:'.$type);
                    header('Content-Length: ' . filesize($filePath));
                    readfile($filePath);
                }
            }
        }
    }
    
    ?>

Here is what I use to open my emails using database:

   

<?php
    
    // Initialize the session
    session_start();
    
    //Connect to the database
    include('config.php');
    
    // Check if the user is logged in, if not then redirect him to login page
    if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true) {
        header("location: login.php");
        exit;
    }
    else
    {
        $id = $_POST['email_number'];
        $mailfolder = $_POST['mailfolder'];
        $readMail = 'read';
        $mailbox = $link->prepare("UPDATE " . $mailfolder . " SET readtype = ? WHERE id = ?");
        $mailbox->execute([$readMail, $id]);
        
        // set the resulting array to associative
        $row = $mailbox->fetch(PDO::FETCH_ASSOC);
        if($mailbox->rowCount() == 1)
        {
            $results = array();
            $mailbox_from = $row['from_email'];
            $mailbox_from_ = explode('<', $mailbox_from);
            $mailbox_from_name = $mailbox_from_[0];
            $mailbox_from_email = '<' . $mailbox_from_[1];
            $mailbox_from_email = htmlspecialchars($mailbox_from_email);
            $mailbox_to = $row['to_email'];
            $mailbox_to_name = $mailbox_to;
            $mailbox_subject = quoted_printable_decode($row['subject']);
            $mailbox_fulldate = $row['received_date'];
            $mailbox_date = convDate($mailbox_fulldate);
            $mailbox_message = $row['message'];
            $mailbox_attachment = $row['attachments'];
            $mailbox_folder = $_POST['folder'];
            $total = $_POST['total'];
            $email_encrypt = $row['encryption'];
            $send_to = $mailbox_from_email;
    
            $results['mailbox_from'] = $mailbox_from;
            $results['mailbox_from_'] = $mailbox_from_;
            $results['mailbox_from_name'] = $mailbox_from_name;
            $results['mailbox_from_email'] = $mailbox_from_email;
            $results['mailbox_to'] = htmlspecialchars($mailbox_to);
            $results['mailbox_subject'] = $mailbox_subject;
            $results['mailbox_fulldate'] = $mailbox_fulldate;
            $results['mailbox_date'] = $mailbox_date;
            $results['mailbox_message'] = $mailbox_message;
            $results['mailbox_attachment'] = $mailbox_attachment;
            $results['mailbox_folder'] = $mailbox_folder;
            $results['total'] = $total;
            $results['email_encrypt'] = $email_encrypt;
            $results['send_to'] = $send_to;
            $results['time_elapsed'] = $time_elapsed;
            $results['mailed_by_date'] = $mailed_by_date;
            $results['mailed_by'] = $mailed_by;
            $results['mailbox_to_name'] = $mailbox_to_name;
            $results['attach_test'] = $attach_test;
            $data = array("start"=>$start_idx,"total"=>$total,"encryption"=>$email_encrypt);
            $response = array("data"=>$data,"html"=>$html, "total_inbox"=>$total_inbox_unread, "total_draft"=>$total_draft_unread, "total_spam"=>$total_spam_unread, "emailBodyMessage"=>$results, "emailHeader"=>$header);
            echo json_encode($response);
        }
    }
    
    //Close connection
    $mailbox = null;
    ?>

 

I want to fetch the filename data next to `alt` so I can send the data to /project/u/index.php to display the image.

I dont know how I could do this using PHP.  Can you please show me how I could do this?

Thanks in advance.

I'm trying to create a form that has a drag and drop image with it. I did a tutorial for the drag and drop and now I'm trying to put it together with a form.

The problem I'm having is that I'm not able to get the filename, so that I can insert it into the database.

I've tried doing this

if(isset($_POST['add_product']))
{
    $filename = $_FILES['files']['name'];

    echo print_r($filename);
    die();
}

but I get a blank array

Quote

Array ( [0] => ) 1

and when I do this

if(isset($_FILES['files']))
{

    $filename = $_FILES['files']['name'];

    echo print_r($filename);
    die();

}

I get the name of my image, but if I do this

if(isset($_FILES['files']))
{
    $filename = $_FILES['files']['name'];
}

if(isset($_POST['add_product']))
{
    echo print_r($filename);
    die();
}

I get a blank array as well

Quote

Array ( [0] => ) 1

Here I was hoping that I could grab the $filename and pass it on to the

Quote

if(isset($_POST['add_product]))

Here is my form

<form action="" method="POST" enctype="multipart/form-data">
    <div class="form-group">
        <label for="title">Title</label>
        <input type="text" class="form-control" name="title">
    </div>

    <div class="form-group">
        <label for="content">content</label>
        <textarea name="content" id="content" class="form-control" cols="30" rows="10"></textarea>
    </div>

    <input type="file" name="files[]" id="standard-upload-files" multiple>
    <input type="submit" value="Upload files" id="standard-upload">

    <div class="wrapper">
        <div class="upload-console">
            <h2 class="upload-console-header">
                Upload
            </h2>

            <div class="upload-console-body">
                <div class="upload-console-drop" id="drop-zone">
                    just drag and drop files here
                </div>

                <div class="bar">
                    <div class="bar-fill" id="bar-fill">
                        <div class="bar-fill-text" id="bar-fill-text"></div>
                    </div>
                </div>

                <div class="hidden" id="uploads-finished">
                    <h3>Process files</h3>

                    <div class="upload-console-upload">
                        <a href="#">filename.jpg</a>
                        <span>Success</span>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="form-group">
        <button type="submit" class="btn btn-dark btn-lg btn-block" name="add_product">Save</button>
    </div>
</form>

Here is the js files that I got from the tutorial that I did.

main.js

(function(){
    "use strict";

    var dropZone = document.getElementById('drop-zone');
    var barFill = document.getElementById('bar-fill');
    var barFillText = document.getElementById('bar-fill-text');
    var uploadsFinished = document.getElementById('uploads-finished');

    var startUpload = function(files){
        // console.log(files);
        app.uploader({
            files: files,
            progressBar: barFill,
            progressText: barFillText,
            processor: 'index.php',

            finished: function(data){
                // console.log(data);
                var x;
                var uploadedElement;
                var uploadedAnchor;
                var uploadedStatus;
                var currFile;

                for(x = 0; x < data.length; x = x + 1)
                {
                    currFile = data[x];

                    uploadedElement = document.createElement('div');
                    uploadedElement.className = 'upload-console-upload';

                    uploadedAnchor = document.createElement('a');
                    uploadedAnchor.textContent = currFile.name;

                    if(currFile.uploaded)
                    {
                        uploadedAnchor.href = 'uploads/'+currFile.file;
                    }

                    uploadedStatus = document.createElement('span');
                    uploadedStatus.textContent = currFile.uploaded ? 'Uploaded' : 'Failed';

                    uploadedElement.appendChild(uploadedAnchor);
                    uploadedElement.appendChild(uploadedStatus);

                    uploadsFinished.appendChild(uploadedElement);
                }

                uploadsFinished.className = '';

            },

            error: function(){
                console.log('there was an error');
            }
        });
    };

    //drop functionality

    dropZone.ondrop = function(e){
        e.preventDefault();
        this.className = 'upload-console-drop';

        startUpload(e.dataTransfer.files);
    };

    dropZone.ondragover = function(){
        this.className = 'upload-console-drop drop';
        return false;
    };

    dropZone.ondragleave = function(){
        this.className = 'upload-console-drop';
        return false;
    };
}());

upload.js

var app = app || {};

(function(o){
    "use strict";

    //private methods
    var ajax, getFormData, setProgress;

    ajax = function(data){


        var xmlhttp = new XMLHttpRequest();

        var uploaded;

        xmlhttp.addEventListener('readystatechange', function(){
            if(this.readyState === 4)
            {
                if(this.status === 200)
                {
                    uploaded = JSON.parse(this.response);

                    if(typeof o.options.finished === 'function')
                    {
                        o.options.finished(uploaded);
                    }
                }else{
                    if(typeof o.options.error === 'function')
                    {
                        o.options.error();
                    }
                }
            }
        });

        xmlhttp.upload.addEventListener('progress', function(e){
            var percent;

            if(e.lengthComputable === true)
            {
                percent = Math.round((event.loaded / event.total) * 100);
                setProgress(percent);
            }
        });

        xmlhttp.open('post', o.options.processor);
        xmlhttp.send(data);
    };

    getFormData = function(source){

        var data = new FormData();
        var i;

        for(i = 0; i < source.length; i = i + 1)
        {
            data.append('files[]', source[i]);
        }

        return data;
    };

    setProgress = function(value){
        if(o.options.progressBar !== undefined)
        {
            o.options.progressBar.style.width = value ? value + '%' : 0;
        }

        if(o.options.progressText !== undefined)
        {
            o.options.progressText.textContent = value ? value + '%' : '';
        }
    };

    o.uploader = function(options){

        o.options = options;

        if(options.files !== undefined)
        {
            ajax(getFormData(o.options.files));

            // getFormData(o.options.files);
        }
    }
}(app));

 

I've looked through all the $_SERVER vars and all of them return path information in some way or another. I just want the script name, nothing else. If I call the code from index.php I want it to return "index.php" not something like "/var/www/path/to/something/index.php". I know I could explode on / and grab the last element but that seems kinda iffy to me. If my script is run on a windows box with \ as the directory separator it would malfunction likely.

I want to use the following code to upload images to my server (below code works great)

Code: [Select]
<?php
$rand = rand(1,99999999999999);
$member_id = $_SESSION['SESS_MEMBER_ID'];

if(isset($_FILES['uploaded']['name']))
{
    $target = "gallery/";
$allowed_filetypes = array('.jpg','.gif','.bmp','.png');
$max_filesize = 524288; // Maximum filesize in BYTES (currently 0.5MB) 
    $fileName = basename($_FILES['uploaded']['name']);
    $target = $target . $fileName;
$errors = array();

   // Get the extension from the filename.
   $ext = substr($filename, strpos($filename,'.'), strlen($filename)-1); 
 
   // Check if the filetype is allowed.
   if(in_array($ext,$allowed_filetypes))
    {
         $errors[] = "The file you attempted to upload is not allowed.";
    }
    
// Now check the filesize.
   if(filesize($_FILES['uploaded']['tmp_name']) > $max_filesize)
    {
         $errors[] = "The file you attempted to upload is too large.";
    }
  
    // Check if we can upload to the specified path.
   if(is_writable($target))
    {
         $errors[] = "You cannot upload to the specified directory, please CHMOD it to 777.";
    }
 
    //Here we check that no validation errors have occured.
    if(count($errors)==0)
    {

//Try to upload it.
        if(!move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))
        {
            $errors[] = "Sorry, there was a problem uploading your file.";
        }
    }
    
    //If no errors show confirmation message
    if(count($errors)==0)
    {
         echo "<div class='notification success png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
The file {$fileName} has been uploaded<br>\n
</div>
</div>";

//echo "The file {$fileName} has been uploaded";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }
    else
    {
        //show error message
        echo "<div class='notification attention png_bg'>
<a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a>
<div>
Sorry your file was not uploaded due to the following errors:<br>\n
</div>
</div>";
//echo "Sorry your file was not uploaded due to the following errors:<br>\n";
        echo "<ul>\n";
        foreach($errors as $error)
        {
            echo "<li>{$error}</li>\n";
        }
        echo "</ul>\n";
echo "<br>\n";
echo "<a href='gallery.php'>Go Back</a>\n";
    }
    
}
else
{
    //Show the form
echo "Use the following form below to add a new image to your gallery;<br />\n";
    echo "<form enctype='multipart/form-data' action='' method='POST'>\n";
    echo "Please choose a file: <input name='uploaded' type='file' /><br />\n";
    echo "<input type='submit' value='Upload' />\n";
    echo "</form>\n";

//Echo Tests!
    echo "<br /><br />Random FileName: "; 
echo $rand;
echo "<br />";
echo "member ID: #";
echo $member_id;
}
?>
i then want it to rename the files for example:

"test.png" is uploaded and name changed to "92997863_321.png" (where first number is using my $rand then the "_" then second number is my $member_id)

the script already got these pieces of information and also gets the file extension using the $ext code.

can this be done, and can i also upload the new filename to my sql table?