Databases
StackOverflow2013
Postsdbo
POphp file runs twice when using header for showing pdf in browser
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp file runs twice when using header for showing pdf in browser
    primarykey
    data
    text
    <p>strange problem. At least for me. When the link to pdf.php gets clicked, the query writes to the mysql db how many times a certain document has been clicked.</p> <p>The Problem: Instead of writing "1" in the db for every click, it writes "2". It seems that the php file runs twice. But why?</p> <pre><code>$file = './'.mysqli_real_escape_string ($con,$_GET[name]).''; $filename = mysqli_real_escape_string ($con,$_GET[name]); /* Note: Always use .pdf at the end. */ $id = intval($_GET[id]); $date = time(); $what = mysqli_real_escape_string ($con,$_GET[name]); header('Content-type: application/pdf'); header('Content-Disposition: inline; filename="' . $filename . '"'); header('Content-Transfer-Encoding: binary'); header('Content-Length: ' . filesize($file)); header('Accept-Ranges: bytes'); @readfile($file); $sql = "SELECT id,what,person_id,count FROM pdftrack WHERE id = '".$id."' AND what='".$what."'"; $ergebnis = mysqli_query($con,$sql); $row = mysqli_fetch_assoc($ergebnis); if ($row[id] == '') { $sql = "INSERT INTO pdftrack (id,what,date,count) VALUES ('".$id."', '".$what."','".$date."','1')"; mysqli_query($con,$sql);//echo $sql; } else { $count = $row[count]+1; $sql="UPDATE pdftrack SET count='".$count."', date2='".$date."' WHERE id='".$row['id']."' "; mysqli_query($con,$sql); } </code></pre> <p>update: thanks for your help, but it still counts wrong. If the header part is gone, it works like it should. So i think it has something to do with the header part. Any ideas?</p> <p>solution: using only</p> <pre><code>header('Content-type: application/pdf'); @readfile($file); </code></pre> <p>can´t see any downside at the moment.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBenjamin79
    1. USBenjamin79
    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
    1. This table or related slice is empty.
    1. COWhat have you actually done in an attempt to solve the problem by yourself? this info can help us to help you better and faster.
      singulars
      1. POphp file runs twice when using header for showing pdf in browser
      1. USSidOfc
    2. COWhat primary index do you have in pdftrack table? Probably you could put it all into single SQL statement, using ON DUPLICATE operator.
      singulars
      1. POphp file runs twice when using header for showing pdf in browser
      1. USAntony Harder
    3. CODepending on the PDF viewer used the PDF may actually be queried twice. Have you checked doing a TCP DUMP or simply inspecting some web-access log file?
      singulars
      1. POphp file runs twice when using header for showing pdf in browser
      1. USmkl
 

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