How To trigger a php query using a link

Question

i have a page, in where by i can want to collect and store the amount of page views, i have a php query that stores my page views onclick of a button,

if(isset($_POST['submit'])){
    mysql_select_db($database_epl, $epl);
    $query_lin = sprintf("SELECT * FROM topic WHERE id = %s ORDER BY `Date` DESC", GetSQLValueString($colname_lin, "int"));
    $topicId = $_GET['id']; // you need to change 'id' to the name of your ID-parameter in the URL
    $viewsIncrementQuery = "UPDATE `topic` SET `Views` = `Views` + 1 WHERE `id` = " . $topicId;
    $incremented = mysql_query($viewsIncrementQuery, $epl) or die(mysql_error());
    // run/execute mysql query

but now i want to be able to call that query using links, (on click of a link)

How can i go about this

First of all, format your post, it's hard to read. What have you tried and what did not work? — DoXicK
– DoXicK, Commented Aug 13, 2014 at 11:32
If you are wanting to stay on the same page you will need to look into using ajax — Patrick Evans
– Patrick Evans, Commented Aug 13, 2014 at 11:33
i dont intend to stay on the page, i just want to make sure that onlick of that link, the query be excuted, — wcp
– wcp, Commented Aug 13, 2014 at 11:37

Patrick Evans · Accepted Answer · 2014-08-13 12:02:07Z

2

You can add a onclick event to the link and have it set a form's action attribute and then trigger a submit

html

<form method="post" id="myForm">
   <input type="text" name="id" />
   <input type="button" name="submit" value="submit">
</form>

<a href="/somePhpScript.php" onclick="submitForm(this)">Click to submit</a>

Javascript

function submitForm(element){
    var action = element.href;
    var form = document.getElementById("myForm");
    form.action = action;
    form.submit();
}

Your data would then be in the $_POST global array, if you want it in the $_GET global then just change the method attribute to get

answered Aug 13, 2014 at 12:02

Patrick Evans

42.8k6 gold badges81 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wcp Over a year ago

i think your solution is more of what i was looking for, because my query already carries a post action, thanks, ill try it and get back

elpaulo · Accepted Answer · 2014-08-13 11:33:46Z

0

You need to call this page with an ajax query, like this in JQuery. With this, you'll be able to transmit parameters as GET or POST, and receive them in your page, where you will do your update query.

answered Aug 13, 2014 at 11:33

elpaulo

964 bronze badges

Comments

Raphael Müller · Accepted Answer · 2014-08-13 11:48:55Z

0

Pass a parameter with your link:

http://example.com/yourpage.php?send=123

in yourpage.php

var_dump($_GET['send']);

returns

string(3) => 123

EDIT:

in your html output introduce a parameter for your link:

 <a href="http://example.com/yourpage.php?updateview=1">link</a>

in yourpage.php

 if($_GET['updateview'] == 1)
 {
      //your sql query etc. from the question.
 }

edited Aug 13, 2014 at 11:48

answered Aug 13, 2014 at 11:39

Raphael Müller

2,2002 gold badges16 silver badges20 bronze badges

11 Comments

wcp Over a year ago

can u please apply that to the snippet i gave

Raphael Müller Over a year ago

i don't know your link, and i don't know the variable you want to send. but i can write some suggestions.

Thijs Over a year ago

Don't use GET-parameters for update actions in the database. He should use a POST-action in his case.

Raphael Müller Over a year ago

@Thijs how do you send a POST header with http in a link?

Thijs Over a year ago

@RaphaelMüller He should use AJAX.

|

Collectives™ on Stack Overflow

How To trigger a php query using a link

3 Answers 3

1 Comment

Comments

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related