getdata-prepare.php

<?php
 $conn = new mysqli("localhost", "root", "seedubuntu", "dbtest");
 $sql = "SELECT Name, Salary, SSN
 FROM employee
 WHERE pid= ? and password=?";
 if ($stmt = $conn->prepare($sql)) {
 $stmt->bind_param("ss", $pid, $pwd);
 $stmt->execute();
 $stmt->bind_result($name, $salary, $ssn);
 while ($stmt->fetch()) {
 printf("%s %s %s\n", $name, $salary, $ssn);
 }
 }
?>