What is the significance of using AS in SQL queries in PHP?

Using AS in SQL queries in PHP allows you to give a custom alias to columns or tables in the query result set. This can make the query results more readable and easier to work with, especially when dealing with complex queries or joining multiple tables. Example: 

$sql = "SELECT users.id AS user_id, users.name AS user_name, orders.total AS order_total
        FROM users
        JOIN orders ON users.id = orders.user_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "User ID: " . $row["user_id"] . " - User Name: " . $row["user_name"] . " - Order Total: " . $row["order_total"] . "<br>";
    }
} else {
    echo "0 results";
}

Keywords

SQL queries AS keyword PHP database alias

Related Questions