// plain
To get the first row of a result in MySQL using PHP, you can use the mysqli_fetch_assoc()
function. This function takes a result set as an argument and returns an associative array of the first row.
$result = mysqli_query($conn, "SELECT * FROM table");
$row = mysqli_fetch_assoc($result);
Array
(
[column1] => value1
[column2] => value2
[column3] => value3
)
mysqli_query($conn, "SELECT * FROM table")
: This line executes a query on the MySQL database and returns a result set.mysqli_fetch_assoc($result)
: This line takes the result set as an argument and returns an associative array of the first row.
onelinerhub: How to get the first row of a result in MySQL using PHP?