You are using prepared SQL statements, but not using parameterised queries in them, so you're still wide open to SQL injections. This is how you should be doing it:
$gid = $_GET['gid'];
$queryr = $pdo->prepare('SELECT test3.name FROM test1, test2, test3 WHERE test1.id = test2.groupid AND test3.id = test2.peopleid AND test1.id = :gid ORDER BY test3.name ASC');
$queryr->bindParam(':gid', $gid, PDO::PARAM_STR);
$queryr->execute();
Assuming that your $gid
is supposed to be numeric, you should probably extract it this way too:
if(is_numeric($_GET['gid'])) {
$gid = (int)$_GET['gid'];
// ...
$queryr->bindParam(':gid', $gid, PDO::PARAM_INT);
The same applies to your later queries that are being generated from $_POST
.