Get JSON data from php with $_GET request in android

Question

Here is my PHP code:

  $query = $sdb->prepare("SELECT * FROM `t_comments` WHERE `a_link` = ?");
    $query->bindValue(1, $_GET["link"]);
    $query->execute();

and here is my JSON request in Android:

JSONObject json = jParser.makeHttpRequest("http://serverip/json/getcomments.php?link=" + index, "GET", params);

Actually, this code works if I remove link request in Activity. Also, if I replace $_GET with ID in PHP, but index will change on each request so.

SOLVED: i needed to use Params list to add GET parameter inside simply with params.add(new BasicNameValuePair("STRING NAME", SOMETHING TO STORE));

Are you making network requests on the main user interface?

Bonatti
– Bonatti

2015-10-06 12:00:44 +00:00
Commented Oct 6, 2015 at 12:00 — Bonatti
– Bonatti, Commented Oct 6, 2015 at 12:00

Maha Dev · Accepted Answer · 2015-10-06 09:41:43Z

1

$query = $sdb->prepare("SELECT * FROM `t_comments` WHERE `a_link` = :link");
$query->bindValue(':link', $_GET["link"]);
$query->execute();

answered Oct 6, 2015 at 9:41

Maha Dev

3,9653 gold badges34 silver badges53 bronze badges

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

1 Comment

The Manhatten Over a year ago

it still does not works, plus this method used above proved that works (iv used in different conditions) but in this case idk, its just cant get $_GET value or idk whats happening $query->bindValue(1, 15); <- this code will work but...

Bonatti · Accepted Answer · 2015-10-06 12:30:04Z

0

From the documentation:

<?php
/* Execute a prepared statement by binding PHP variables */
$calories = 150;
$colour = 'red';
$sth = $dbh->prepare('SELECT name, colour, calories FROM fruit
    WHERE calories < :calories AND colour = :colour');
$sth->bindValue(':calories', $calories, PDO::PARAM_INT);
$sth->bindValue(':colour', $colour, PDO::PARAM_STR);
$sth->execute();
?>

In your code:

if(isset($_GET["link"])){
    $aVarName = $_GET["link"];
    $query->bindValue(1, $aVarName, PDO::PARAM_INT);
} else {
    // Some error or default value.
}

answered Oct 6, 2015 at 12:30

Bonatti

2,8015 gold badges27 silver badges43 bronze badges

3 Comments

The Manhatten Over a year ago

Problem is solved, anyway thanks for finding time to help me :)

Bonatti Over a year ago

If the question is answered, chlick the green symbol below the left of the question. This marks the question as answered, and make it so other people can read an answer that helped solve the issue

The Manhatten Over a year ago

well problem wasn`t in PHP, my PHP code worked very well it was inside json parse so... and by the way i already edited and added SOLVED + SOLUTION in main question

Collectives™ on Stack Overflow

Get JSON data from php with $_GET request in android

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related