<div style="padding: 20% 20%;">
<a href="index.php">Index</a>
<a href="insert.php">Insert</a>
<a href="select.php">Select</a>
<a href="update.php">Update</a>
<a href="delete.php">Delete</a>
</div>
<?php
require_once 'db/mysql.php';
$db = new Db_Mysql(array('dbname' => 'shift_planning_test', 'username' => 'root', 'password' => '', 'host' => 'localhost'));
$fullname = "Konstantin Petrovic";
$email = "*****@*****.**";
$country = "Serbia";
$query_update = "UPDATE user SET fullname = '{$fullname}', email = '{$email}', country = '{$country}' WHERE user_id=20";
$db->connect();
$result = $db->query($query_update);
if ($result == false) {
echo $db->error() . " " . $db->errno();
} else {
$update = $db->affectedRows();
echo $update;
}
$db->close();