Php pdo get id selected by href

<?php
include "/includes/db.php";
$id = $_GET['id'];
$options = [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,        // enable PDO errors
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,   // fetch associative arrays by default
    PDO::ATTR_EMULATE_PREPARES => false,                // Use native prepared statements
];
//                      You should always specify charset VVVVV
$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password, $options);

// Prepare and execute SQL passing in the value of $id  // Verificar o pedido "GET" id param
  $id = $_GET['id'];
  
  // Preparar e executar a passagem SQL no valor de $id
  $query = $pdo->prepare('SELECT * FROM nametable WHERE id = ? ORDER BY nameselect DESC');
  $query->execute([$id]);
?>
  <html>
   <?php foreach($query as $row ?>
     $row  ['namerow']
     <?php } ?>
  </html>

Source: stackoverflow.com

Similar codes

15 votes169 views1 answer
Laravel composer install ignore
PHP
1 vote193 views2 answers
How to display data from mysql database into html table using php
PHP
14 votes203 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel
0 vote132 views1 answer
Laravel faker country code
PHP
0 vote176 views1 answer
Eager load relationships on an existing model in route laravel
PHP
1 vote172 views1 answer
If else if php code reflect
PHP
0 vote177 views2 answers
Access paginator object attribute in laravel
PHP
0 vote203 views2 answers
Transient wordpress
PHP Wordpress
5 votes207 views3 answers
Enum table in laravel
PHP Laravel
0 vote176 views2 answers
Laravel same route different group
PHP