Search code examples
phpandroidmysqlapp-inventor

App inventor/PHP app stopped working on Note 4's


We have been using an app that clocks our engineers in/out by connecting a mysql database and submitting values to it. From the 13th, the app appears to have stopped working on note 4's, but still works fine on the note 2's.

We were wondering if a firmware update has possibly stopped this app from working as we have been using this app with absolutely no issues until the 13th and it only seems to be affecting those who have note 4's?

App Inventor Code

<?php
$con=mysqli_connect("localhost","***********","**********","appacmef_App");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$employeeid = mysqli_real_escape_string($con, $_GET['employeeid']);
$time = mysqli_real_escape_string($con, $_GET['time']);
$longitude = mysqli_real_escape_string($con, $_GET['longitude']);
$lattitude = mysqli_real_escape_string($con, $_GET['lattitude']);
$vanreg = mysqli_real_escape_string($con, $_GET['vanreg']);


$sql="INSERT INTO clockings (employeeid, time, longitude, lattitude, vanreg)
VALUES ('$employeeid', '$time', '$longitude', '$lattitude', '$vanreg')";

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

mysqli_close($con);
?>

Any Help with this would be greatly appreciated.


Solution

  • I have changed the blocks and it now works again enter image description here