browse files

nesvarbu

Hi,
I need help with browsing file.
I have made a news script and I want to put a picture near every news. So I need an input with wich I could browse files and select a picture that could be added to teh news.
The problem is that I dont want to upload files, yhe pictures are allready on my site.
I tried this code:

   

.....
<td> 
    <input type="file" name="url"> 
</td>
........

//then

<?php


$query = "INSERT INTO news
	      (date, title, news, category, url) VALUES 
	('$_POST[date]',  '$_POST[title]',  '$_POST[news]',  '$_POST[category]',  

'$_POST[url]');";


?>

But the $_POST[url] doesnt work :/ it is empty.

Norman_Graham

Hi Nesvarbu

I'm reasonably sure that $POST[myvariable] will produce nothing at all. You need $POST["myvariable"] (or with just single quotes). Anywayz, collecting the values inside the MySQL query is, IMHO, a poor way of going about things. How about this:

$date = $_POST["date"];
$title= $_POST["title"];
$news= $_POST["news"];
$category= $_POST["category"];
$url= $_POST["url"];

$query = "INSERT INTO news 
          (date, title, news, category, url) VALUES  

    ('$date',  '$title',  '$news',  '$category',   

'$url')";

HTH

Norm

nesvarbu

I'm reasonably sure that $_POST[myvariable] will produce nothing at all...

Well you are quite wrong, it seems that you never tried it this way, it works just fine. If you'll trie to put double or single quotes you'll get an mysql error. The problem is not in that. I just need to find the variable in witch the url of the picture is stored. And it seems that $_POST[url] is not that variable I need. so does anybody know where PHP stores the actual url of the picture that is about to be uploaded?

laserlight

Actually, Norman Graham is right in the sense that you should quote the index of associative arrays (unless the index is a variable).

Read the PHP Manual on arrays for more information:
http://www.php.net/manual/en/language.types.array.php

The reason is that "myvariable" becomes an undefined constant, instead of a string used as an index.
In this case you're already using in a string, so it probably doesnt matter.

Of course, an alternative is to concatenate the variables rather than use variable interpolation, which can be slower.

laserlight

If the images are already stored on your website, it would make more sense to create a drop down menu that the user can select to get the file.

A possibility would be to store the image names, filenames and paths in a table, then the drop down menu would list the images and have the corresponding key as the value.
Conversely, one could traverse the image directory for the list of images.