How can PHP be used to move a database entry one row up in MySQL?

To move a database entry one row up in MySQL using PHP, you can achieve this by updating the order of the rows in the database table. This can be done by fetching the current row and the row above it, then updating their order values accordingly. 

<?php
// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Fetch the current row and the row above it
$currentRow = 5; // Assuming the current row is row 5
$previousRow = $currentRow - 1;

// Update the order values in the database
$sql = "UPDATE your_table SET order_column = order_column + 1 WHERE order_column = $previousRow";
$conn->query($sql);

$sql = "UPDATE your_table SET order_column = order_column - 1 WHERE order_column = $currentRow";
$conn->query($sql);

$conn->close();
?>

Keywords

PHP MySQL database entry move row up

Related Questions