Search code examples
phpmysqlurlapp-inventor

Using Greater than ( >= ) in URL App Inventor

I'm using this php code as part of App Inventor

$Techid = mysqli_real_escape_string($dbc, $_GET['Techid']);
$diffs = mysqli_real_escape_string($dbc, $_GET['diff']);
$values = mysqli_query($dbc, "SELECT * FROM CPETrack WHERE (Techid= '$Techid') AND (diff = '$diffs')");

The web url i need to parse over is: http://domainhere.com/custserv.php?id=1000&diff>=15

The techid is defined in app inventor itself and so is the diff.

I can do this in the mysql DB SELECT * FROM CPETrack WHERE id=1000 AND diff>=15; and it will return all items from the relevent id column and diff column greater than or equal to 15.

I'm unable to convert this to php thou to do the same job. How would I go about doing this?

Please bear in mind the actual diff value will be set within app inventor and I'm using set url1 to block in app inventor and join text block to create the web url and the php to give the result.

Solution

  • what about using >= in your php script like this

    $values = mysqli_query($dbc, "... AND (diff >= '$diffs')");