How can one update values in PostgreSQL using PHP?

To update values in PostgreSQL using PHP, you can use the PDO library to establish a connection to the database and then execute an SQL UPDATE statement. Make sure to properly sanitize user input to prevent SQL injection attacks. 

<?php
$pdo = new PDO('pgsql:host=localhost;dbname=mydatabase', 'username', 'password');

$id = 1;
$newValue = 'New Value';

$sql = "UPDATE mytable SET column_name = :new_value WHERE id = :id";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':new_value', $newValue);
$stmt->bindParam(':id', $id);
$stmt->execute();

Keywords

PHP PostgreSQL update values SQL

Related Questions