$img = imagecreatefrompng($filepath);
}
$width = imagesx($img);
$height = imagesy($img);
$new_width = 200;
$new_height = floor($height * ($new_width / $width));
$tmp_img = imagecreatetruecolor($new_width, $new_height);
imagecopyresized($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height);
imagejpeg($tmp_img, __DIR__ . "/../thumbnails/" . basename($image));
}
}
}
try {
// Connect to the database
$conn = new DBCommunication();
$conn->beginTransaction();
// Get user, who is logged in and posting ad, id
$query = "SELECT user_id FROM whwp_User WHERE user_username = :username";
$conn->prepQuery($query);
$conn->bind('username', $username);
$resultset = $conn->single();
$user_id = $resultset->user_id;
// Insert some data to the database.
$query = "INSERT INTO whwp_Advert (advert_owner, advert_price, advert_bookname, advert_date, advert_description, advert_category) " . "VALUES (:user_id, :price, :title, :date, :description, :category)";
$conn->prepQuery($query);
$conn->bindArrayValue(array('user_id' => $user_id, 'price' => $price, 'title' => $title, 'date' => gmdate('Y-m-d'), 'description' => $description, 'category' => $category_id));
$conn->execute();
// Get the auto generated advert_id.
$advert_id = $conn->lastInsertId();
if (isset($_POST['condition'])) {
$query = "UPDATE whwp_Advert SET advert_condition=:condition WHERE advert_id = :advert_id";
