How can PHP be used to track and manage user payments for a website?

To track and manage user payments for a website using PHP, you can create a database table to store payment information such as user ID, payment amount, payment date, and payment status. You can then use PHP to insert new payment records, update payment statuses, and retrieve payment information for reporting purposes. 

// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "payments";

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

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

// Insert new payment record
$user_id = 123;
$payment_amount = 50.00;
$payment_date = date("Y-m-d");
$payment_status = "Pending";

$sql = "INSERT INTO payments (user_id, payment_amount, payment_date, payment_status) VALUES ('$user_id', '$payment_amount', '$payment_date', '$payment_status')";

if ($conn->query($sql) === TRUE) {
    echo "New payment record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Update payment status
$payment_id = 1;
$new_payment_status = "Completed";

$sql = "UPDATE payments SET payment_status='$new_payment_status' WHERE id='$payment_id'";

if ($conn->query($sql) === TRUE) {
    echo "Payment status updated successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Retrieve payment information
$sql = "SELECT * FROM payments WHERE user_id='$user_id'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "User ID: " . $row["user_id"]. " - Payment Amount: " . $row["payment_amount"]. " - Payment Date: " . $row["payment_date"]. " - Payment Status: " . $row["payment_status"]. "<br>";
    }
} else {
    echo "No payment records found";
}

$conn->close();

Keywords

PHP user payments website tracking management

Related Questions