CODE EXAMPLE FOR PHP

php get data from prepared select

//on sql server
public function get_data_from($id){
  $request = "SELECT * FROM tableName WHERE id = ?";

  //preparing the request
  $stmt = $this->dbh->prepare($request);

  //executing the request
  $stmt->execute( array($id)  );

  //fetching the result of the request
  $result = $stmt->fetchAll();

  return $result;
}