Databases
StackOverflow2013
Postsdbo
POopening and viewing a file in php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POopening and viewing a file in php
    primarykey
    data
    text
    <p>how do i open/view for editing an uploaded file in php?</p> <p>i have tried this but it doesn't open the file.</p> <pre><code>$my_file = 'file.txt'; $handle = fopen($my_file, 'r'); $data = fread($handle,filesize($my_file)); </code></pre> <p>i've also tried this but it wont work.</p> <pre><code>$my_file = 'file.txt'; $handle = fopen($my_file, 'w') or die('Cannot open file: '.$my_file); $data = 'This is the data'; fwrite($handle, $data); </code></pre> <p>what i have in mind is like when you want to view an uploaded resume,documents or any other ms office files like .docx,.xls,.pptx and be able to edit them, save and close the said file.</p> <p>edit: latest tried code...</p> <pre><code> &lt;?php // Connects to your Database include "configdb.php"; //Retrieves data from MySQL $data = mysql_query("SELECT * FROM employees") or die(mysql_error()); //Puts it into an array while($info = mysql_fetch_array( $data )) { //Outputs the image and other data //Echo "&lt;img src=localhost/uploadfile/images".$info['photo'] ."&gt; &lt;br&gt;"; Echo "&lt;b&gt;Name:&lt;/b&gt; ".$info['name'] . "&lt;br&gt; "; Echo "&lt;b&gt;Email:&lt;/b&gt; ".$info['email'] . " &lt;br&gt;"; Echo "&lt;b&gt;Phone:&lt;/b&gt; ".$info['phone'] . " &lt;hr&gt;"; //$file=fopen("uploadfile/images/".$info['photo'],"r+"); $file=fopen("Applications/XAMPP/xamppfiles/htdocs/uploadfile/images/file.odt","r") or exit("unable to open file");; } ?&gt; </code></pre> <p>i am getting the error:</p> <pre><code>Warning: fopen(Applications/XAMPP/xamppfiles/htdocs/uploadfile/images/file.odt): failed to open stream: No such file or directory in /Applications/XAMPP/xamppfiles/htdocs/uploadfile/view.php on line 17 unable to open file </code></pre> <p>the file is in that folder, i don't know it wont find it.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USChristian Burgos
    1. USChristian Burgos
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POopening and viewing a file in php
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI wouldn't use SQL for file reading. What part of your regular fopen doesn't work? What is the error message?
      singulars
      1. POopening and viewing a file in php
      1. USDan Goodspeed
    2. COAlso make sure that (depending on your php version) you don't have open_basedir set in the php.ini - it'll affect what directories are allowed for reading by php. And make sure the path is accurate - watch for possible case-sensitivity. It's either a problem with not being found, or permissions.
      singulars
      1. POopening and viewing a file in php
      1. UShelion3
    3. COthe path is accurate sir..
      singulars
      1. POopening and viewing a file in php
      1. USChristian Burgos
 

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