Using a div value within a SQL query

Question

this is my updated link:

<a href="Portfolio.php?val="'.$row['profile_name'].'" id="link">

and this is my updated SQL query

"SELECT * 
 FROM profile 
 WHERE profile_type = value=".$_REQUEST['val']."";

at the moment this is bringing back nothing does this code look correct or do i need to alter it in anyway ??

any help would be much appreciated.

Why don't you append the id on the href like Portfolio.php?id=1 and then you can use $_GET['id'] to read it back when that page is loaded. And make sure to properly sanitize it before using on the SQL query. — Prix
– Prix, Commented Apr 9, 2014 at 9:13
because at the moment there are about 20 of these links on one page and they are being being brought from a database the href="" that is within the link wont actually be used @Prix — user3387522
– user3387522, Commented Apr 9, 2014 at 9:15

Anand Solanki · Accepted Answer · 2014-04-09 10:03:39Z

1

Try this:

Pass that value in query string

<a href="Portfolio.php?val=".<?php echo $row['field']; ?>." " id="link"> </a>

Use it in query like:

 "SELECT * 
 FROM profile 
 WHERE profile_type = ".$_REQUEST['val']." ";

edited Apr 9, 2014 at 10:03

answered Apr 9, 2014 at 9:15

Anand Solanki

3,4254 gold badges19 silver badges27 bronze badges

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

7 Comments

user3387522 Over a year ago

would this work if i used <a href="portfolio.php?val='.$row["value"].'" @Anandsolanki

Anand Solanki Over a year ago

Yes just change your syntax like <a href="portfolio.php?val='.<?php echo $row["value"]; ?>.'"

user3387522 Over a year ago

would this not be <a href="portfolio.php?val='.<?php echo $row["value"]; ?>.'">; because you only have one closing bracket and two opening

user3387522 Over a year ago

@Arnandsolanki I have altered my code but it will not bring back any results any ideas i will alter my code above to what i have got

Anand Solanki Over a year ago

Try this query my friend, it will surely works: "SELECT * FROM profile WHERE profile_type = ".$_REQUEST['val']." ";

|

Kami · Accepted Answer · 2014-04-09 09:28:17Z

0

As it has been pointed out - value is not a attribute for an anchor tag.

You need to update the anchor tag href attribute to be something like

<a href="Portfolio.php?value=1" id="link">Click Here</a>

This will send the value to the php side when clicked. Which can then be retrieved by the php side using the $_GET array.

<?php
if (isset($_GET['value']))
{  // Check that the value was passed
   $val = $_GET['value'];

   // TODO: Use val in SQL as required.
}
?>

answered Apr 9, 2014 at 9:28

Kami

19.5k4 gold badges53 silver badges65 bronze badges

3 Comments

user3387522 Over a year ago

how would i alter this with the example above ??

Kami Over a year ago

@user3387522 You need a good grasp of what you are trying to achieve in order to understand the question and answers being posted here. Please read up some tutorials/guides on how to update sql data, try starting at - wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers.

Kami Over a year ago

@user3387522 Your code sample is lacking details, and clearly, anything I post here will not work as it lacks those details.

sss999 · Accepted Answer · 2014-04-09 10:07:13Z

0

You don't need to use the value = part. the query should be

"SELECT * FROM profile WHERE profile_type = ".$_REQUEST['val']." ";

answered Apr 9, 2014 at 10:07

sss999

5283 silver badges14 bronze badges

Collectives™ on Stack Overflow

Using a div value within a SQL query

3 Answers 3

7 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related