I have an external application that generates a HTML GET string. This is read by my .php file which extracts the required information.
$ipAddr = htmlspecialchars($_GET['ipAddr']);
$macAddr = htmlspecialchars($_GET['macAddr']);
$vlan = htmlspecialchars($_GET['vlan']);
$hotelCode= htmlspecialchars($_GET['hotelCode']);
$token = htmlspecialchars($_GET['token']);
$expires = htmlspecialchars($_GET['expires']);
The file then inserts the data into the database
$sql = "INSERT INTO $table (ipAddr,macAddr,vlan,hotelCode,token,expires) VALUES('$ipAddr', '$macAddr', '$vlan', '$hotelCode', '$token', (FROM_UNIXTIME($expires)))";
This creates a new record within the database and the .php file then launches phprunner (10.1) application.
All this works fine but, when PHPRunner launches, I want to present the user with the edit screen using the record based on the $token value to get their input into some detail fields but I am struggling to find a way to 'select where the token field contains the value of $token' to present the user with the edit screen.
For testing purposes, I have created a single table for the above data to be inserted and the user input.
Any guidance would be appreciated.