PHP and mysql query with a dynamic variable

Question

I am trying to get a value from database using the code below. I want to save the value in the variable category so I can give this as parameter to a function. The id is dynamically given. Is the code below correct? because when trying this nothing works...

$thecategory = mysql_query("SELECT TYPE FROM lists WHERE id =" . this.id);

I guess it's not inside a class either because that way you should've syntax problems earlier than this, But it seems you're using javascript, if that's the case you can't use it this way. — revo
– revo, Commented Mar 9, 2014 at 19:04

SuperDJ · Accepted Answer · 2014-03-09 19:41:41Z

1

The use of '$id' provides a little security against sql injection

$thecategory = mysql_query("SELECT `TYPE` FROM `lists` WHERE `id` ='$id'");
$associate = mysql_fetch_assoc($thecategory);
$TYPE = $associate['TYPE'];

answered Mar 9, 2014 at 19:41

SuperDJ

7,69911 gold badges44 silver badges80 bronze badges

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

3 Comments

Chris Stina Over a year ago

I have this php code and I want to embed the above code into a jquery part of code. The id is dynamically passed. I try creating a function that get the id and pass it to the query but I failed. I am not so familiar with mysql.

SuperDJ Over a year ago

I didn't really know how you get the id with jquery but when I do this: <script> var id = '1'; </script> <?php $id = '<script> document.write(id) </script>'; echo $id; ?> that kind of works for me but don't know if this is the answer you are looking for. I hope this points you in the right direction

Chris Stina Over a year ago

It doesn't work. Tested it and got nothing. I think I know the problem. It what the other answer says, I should use ajax...

aksu · Accepted Answer · 2014-03-09 18:55:38Z

0

Use mysql_result:

$thecategory = mysql_query("SELECT TYPE FROM lists WHERE id =" . $id); // changed $id
$type = mysql_result($thecategory, 0);

I suggest that you use PDO instead of mysql_* functions, they are deprecated.

answered Mar 9, 2014 at 18:55

aksu

5,2365 gold badges26 silver badges39 bronze badges

4 Comments

Chris Stina Over a year ago

I have this php code and I want to embed the above code into a jquery part of code. The id is dynamically passed. I try creating a function that get the id and pass it to the query but I failed. I am not so familiar with mysql.

aksu Over a year ago

If you're using AJAX with jquery, you can post the id by it, and get data in php like: $id = $_POST['id'];

Chris Stina Over a year ago

Id is ok. I can retrieve it, the problem actually is the query. For some reason it doesn't work. I notice tha mysql_query needs the connection, but I am already connected to the database and I tried

$(".statrow").click(function() {    var $theID = this.id;   var $query = ("SELECT TYPE FROM lists WHERE id = '$theID'");   var $result = mysql_query($query);   var $TYPE = mysql_fetch_assoc($result);   dopclick(this.id, $TYPE); });

Nothing. When having values instead of queries it works fine. In the other files the queries are done by simply putting sqlQuery or sqlStatement

aksu Over a year ago

Looks like that you are using PHP and jQuery together. jQuery runs at client, PHP at server. So you can't use them together in code. Use AJAX to communicate PHP with jQuery. api.jquery.com/jQuery.ajax

curdev · Accepted Answer · 2014-03-09 19:04:51Z

0

Try:

$thecategory = mysql_query("SELECT TYPE FROM lists WHERE id =" . this->id);

answered Mar 9, 2014 at 19:04

curdev

383 bronze badges

1 Comment

curdev Over a year ago

You could try to isolate the query string as a variable and add the this.id or this->id part to it.

Collectives™ on Stack Overflow

PHP and mysql query with a dynamic variable

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related