What are some common methods for passing non-database column values from SQL queries to PHP scripts?

When executing SQL queries in PHP, you may need to pass non-database column values back to your PHP script. One common method to achieve this is by using aliases in your SQL query to assign custom names to these values. These aliases can then be accessed in your PHP script using the same name specified in the query. 

// SQL query with alias for non-database column value
$sql = "SELECT column1, column2, column3, CONCAT(column1, ' ', column2) AS full_name FROM table_name";

// Execute the query
$result = mysqli_query($conn, $sql);

// Fetch the results and access the non-database column value using the alias
while($row = mysqli_fetch_assoc($result)) {
    echo $row['full_name']; // Accessing the non-database column value using the alias
}

Keywords

SQL queries PHP scripts non-database column values data manipulation fetch_assoc

Related Questions