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;
}
