php script to update mysql table on click of link

Question

0.00/5 (No votes)

See more:

I'm new to php and need help.
I'm not able download a file & update the DB's log table at the same time.
For more details please, please, please see the Link.

And, My code as below:

PHP

<?php
$DownDir = "http://localhost/SGA-INTRANET/".$kmsroot. "/". $user. "/". $bu. "/". $client. "/". $project."/Final";
$filenames = "file.xlsx";

$pathDown1 = $DownDir. "/".$filenames;//download path

//using download functionality of HTML 5
echo '<a download="Final_File_'.$filenames.'" name="save" href="'.$pathDown1.'?id='.$name.'&filepath='.$pathDown1.'" target="_blank"><img src="images/Save File.png" title="Download the file"/></a>';
?>

<?php 

$ide = $_GET['id'];//EmployeeID
$file = $_GET['filepath'];// Path

if(isset($ide) && isset($file)) 
{
 if(file_exists($file)) 
  {
    //save log to DB table 'tbl_km_file_download'
    $mysqli = new mysqli("localhost", "USERNAME", "PASSWORD", "DBNAME");
    $mysqli->query("INSERT INTO `tbl_km_file_download` (`name`, `filename`) VALUES ('$ide',  '$file')");
  }
}

?>

Posted 31-Aug-14 20:29pm

GoneBump

Add a Solution

Comments

Kornfeld Eliyahu Peter 1-Sep-14 2:33am

Debug and see that $ide and $file are never set!!!

GoneBump 1-Sep-14 3:14am

Hi Kornfeld Eliyahu Peter, thanks for the reply. I checked it but they are not setting as on the click of the download link the document is downloaded but the 'id' and 'filepath' are not setting. Is there a way to set them in the current scenario?

Kornfeld Eliyahu Peter 1-Sep-14 3:16am

So the question is - why $ide and $file are not set?! That's because you never set them in any way!

GoneBump 1-Sep-14 4:11am

But I set them @

href="'.$pathDown1.'?id='.$name.'&filepath='.$pathDown1.'"

and

$ide = $_GET['id'];//EmployeeID
$file = $_GET['filepath'];// Path

Kornfeld Eliyahu Peter 1-Sep-14 4:14am

And why do you think that, that link comes to your page?

GoneBump 1-Sep-14 5:01am

Actually I'm calling both these statements ('a href' and $_GET[]) in the same page. Isn't it valid?

Kornfeld Eliyahu Peter 1-Sep-14 5:07am

Valid is not the question!
I will try to explain it in a few word, but it is clear to me that you do not understand PHP...:-(
The echo statement creates an output for the client - in your case an anchor element, but has no effect on the server. Writing that query string is not the same than executing it...If you link was pointed back to the same page, after clicking the link the variables would get values, but that not the case...

GoneBump 1-Sep-14 6:21am

Ok... thanks. So what should I do in this case?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manikandan Subbu · Accepted Answer · 2014-09-02T01:21:00

The Best thing you can do here is redirect it to the second php page when the user clicks and in the second php file set the values in the database and then force the file download from php using readfile.

PHP

$file = <file_path>;

if (file_exists($file)) {
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename='.basename($file));
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    header('Content-Length: ' . filesize($file));
    readfile($file);
    exit;
}</file_path>