Databases
StackOverflow2013
Postsdbo
POshow path of image on update form php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POshow path of image on update form php
    primarykey
    data
    text
    <p>When populating the fields of an update form how can I show the path to the current image like this <img src="https://i.stack.imgur.com/T77u8.png" alt="enter image description here"></p> <p>so that if the user doesn't want to change the image the same image is used. This is what the browser displays: <code>&lt;input type="file" value="uploads/chaps_B.jpg" name="image_edit"&gt;&lt;/input&gt;</code></p> <p>I have a feeling my <code>photopath</code> in not in scope but unsure how to go about fixing it. All variables populate the form and it saves to the db fine just can't figure out the image path.</p> <pre><code> if(isset($_POST['update_submit'])) { $get_products = $db-&gt;prepare("select `photopath` from `item` where `item_id` = '$get_item' LIMIT 1"); $get_products-&gt;execute(); $path= $get_products-&gt;fetchColumn(6); if($_FILES['image_edit']['tmp_name'] != "") { $edit_name = $_POST['item_name']; $edit_description =$_POST['item_description']; $form_id = $_POST['edit_form_id']; $file_dir = "uploads/"; $image = $file_dir. $_FILES['image_edit']['name']; move_uploaded_file($_FILES['image_edit']['tmp_name'], $image); $edit_sql =$db-&gt;prepare("UPDATE item SET item_name = '$edit_name', item_description = '$edit_description', photopath ='$image' WHERE item_id = '$form_id'"); $edit_sql-&gt;execute(); header("Location: manage_items.php"); exit(); } else { $edit_name = $_POST['item_name']; $edit_description =$_POST['item_description']; $form_id = $_POST['edit_form_id']; $edit_sql =$db-&gt;prepare("UPDATE item SET item_name = '$edit_name', item_description = '$edit_description' WHERE item_id = '$form_id'"); $edit_sql-&gt;execute(); header("Location: manage_items.php"); exit(); } </code></pre> <p>UPDATE FORM</p> <pre><code> &lt;form action="item_edit.php" method="post" enctype="multipart/form-data"&gt; &lt;input type = "text" name="item_name" value="&lt;?php echo $item_name ?&gt; "/&gt; &lt;textarea name="item_description"&gt;&lt;?php echo $item_description ?&gt;&lt;/textarea&gt; &lt;p&gt; &lt;img src="&lt;?php echo $image; ?&gt;" width="75" height="75" /&gt;&lt;/p&gt; &lt;input type="file" name="image_edit" /&gt; &lt;input name="edit_form_id" type="hidden" value="&lt;?php echo $get_item ?&gt;"&gt; &lt;p&gt;&lt;input type="submit" name="update_submit" value="Update"/&gt;&lt;/p&gt; &lt;p&gt;&lt;input type="submit" name="cancel_edit" value="Cancel"/&gt;&lt;/p&gt; &lt;/form&gt; </code></pre> <p>DB STRUCTURE</p> <p><img src="https://i.stack.imgur.com/M2Mit.png" alt="enter image description here"></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrogerthat
    1. USrogerthat
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POshow path of image on update form php
      1. This table or related slice is empty.
      1. VTUpMod
    1. CORelative path issue most probably. Can you share the path of the page and the path of the uploads dir with respect to web root?
      singulars
      1. POshow path of image on update form php
      1. USAkshay
    2. CO@Akshay they're in the same directory. uploads is in htdocs folder
      singulars
      1. POshow path of image on update form php
      1. USrogerthat
    3. CO@rogerthat, please let me know if i am off the track, your query is, if user on edit or update page, user can see a already uploaded image name along with chose file button, plus if user dont chose a new image, this image name remain the same in database?
      singulars
      1. POshow path of image on update form php
      1. USm-t
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload