23 lines
503 B
PHP
23 lines
503 B
PHP
<?php
|
|
|
|
namespace services;
|
|
include 'config/database-connection.php';
|
|
|
|
class Search
|
|
{
|
|
static function searchByUsername($username)
|
|
{
|
|
global $conn;
|
|
$query = "SELECT persone.*
|
|
FROM users
|
|
RIGHT JOIN persone ON persone.ID = users.ID_PERSONA
|
|
WHERE users.DESCRIZIONE = ?";
|
|
|
|
$stmt = $conn->prepare($query);
|
|
$stmt->bind_param("s", $username);
|
|
$stmt->execute();
|
|
$result = $stmt->get_result();
|
|
return $result;
|
|
}
|
|
|
|
} |