What are the best practices for sorting data in PHP using ORDER BY in SQL queries?

When sorting data in PHP using ORDER BY in SQL queries, it is important to properly sanitize user input to prevent SQL injection attacks. Additionally, it is recommended to use prepared statements to securely pass variables to the query. Finally, make sure to specify the column and direction (ASC or DESC) for sorting in the ORDER BY clause. 

// Example of sorting data in PHP using ORDER BY in SQL queries
$searchTerm = $_GET['searchTerm']; // Assuming searchTerm is obtained from user input

// Sanitize user input to prevent SQL injection
$searchTerm = mysqli_real_escape_string($connection, $searchTerm);

// Prepare and execute SQL query with ORDER BY clause
$query = "SELECT * FROM table_name WHERE column_name = ? ORDER BY column_name ASC";
$stmt = $connection->prepare($query);
$stmt->bind_param("s", $searchTerm);
$stmt->execute();

// Fetch results
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    // Process each row
}
$stmt->close();

Keywords

PHP SQL ORDER BY sorting data best practices

Related Questions