How can PHP developers efficiently retrieve, update, delete, and insert data in a MySQL database using PHP functions?

To efficiently retrieve, update, delete, and insert data in a MySQL database using PHP functions, developers can use the PHP Data Objects (PDO) extension. PDO provides a consistent interface for accessing databases in PHP, making it easier to work with different database systems like MySQL. By using prepared statements with PDO, developers can prevent SQL injection attacks and improve the security of their database operations. 

// Connect to MySQL database using PDO
$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'username';
$password = 'password';
try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    die('Connection failed: ' . $e->getMessage());
}

// Retrieve data
$stmt = $pdo->query('SELECT * FROM table');
$rows = $stmt->fetchAll();

// Update data
$stmt = $pdo->prepare('UPDATE table SET column = :value WHERE id = :id');
$stmt->execute(['value' => 'new value', 'id' => 1]);

// Delete data
$stmt = $pdo->prepare('DELETE FROM table WHERE id = :id');
$stmt->execute(['id' => 1]);

// Insert data
$stmt = $pdo->prepare('INSERT INTO table (column1, column2) VALUES (:value1, :value2)');
$stmt->execute(['value1' => 'value1', 'value2' => 'value2']);

Keywords

MySQL database PHP functions data retrieval data update data insertion

Related Questions