kodetop

<?php

class user_profile
{
    const version = '1.0';
    var $name = 'Guest';

    function GetName()
    {
        return $this->name;

kodetop

<?php 
// include connection
require 'pdo.php';

kodetop

<ul>
    <?php while (($result = $statement->fetch()) !== false): ?>
    <li><a href="country.php?code=<?php echo $result->code; ?>"><?php echo $result->name; ?></a></li>
    <?php endwhile; ?>
</ul>

kodetop

<?php
// include connection
require 'pdo.php';

// prepare query
$statement = $pdo->prepare("SELECT * FROM country");
$statement->execute();

kodetop

<h1>Country</h1>
<p>
    <strong>Name</strong>: <?php echo $result->name; ?><br>
    <strong>Continent</strong>: <?php echo $result->continent; ?><br>
    <strong>Region</strong>: <?php echo $result->region; ?><br>
    <strong>Population</strong>: <?php echo number_format($result->population); ?><br>
    <strong>Area</strong>: <?php echo number_format($result->area); ?><br>
    <strong>Head of State</strong>: <?php echo $result->headofstate; ?>
</p>
<p>

kodetop

<?php
// include connection
require 'pdo.php';

// get and filter parameter
$code = filter_input(INPUT_GET, 'code', FILTER_SANITIZE_STRING);

// prepare query
$statement = $pdo->prepare("SELECT * FROM country WHERE Code = :code");
$statement->bindValue(':code', $code, PDO::PARAM_STR);

kodetop

<?php 
// include connection
require 'pdo.php';

// send query
$statement = $pdo->prepare("SELECT * FROM country");
$statement->execute();

// loop and print data
while (($result = $statement->fetch()) !== false) {

kodetop

root = true

[*]
charset = utf-8
end_of_line = lf
indent_size = 2
indent_style = space
insert_final_newline = true
trim_trailing_whitespace = true

kodetop

root = true

[*]
charset = utf-8
end_of_line = lf
indent_size = 2
indent_style = space
insert_final_newline = true
trim_trailing_whitespace = true

kodetop

<script src="main.js" type="module"></script>