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

0 vote130 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel
0 vote84 views1 answer
150 charachter display only php
PHP
0 vote130 views1 answer
Get product price by id woocommerce snippet
PHP
5 votes129 views4 answers
Update column type laravel migration
PHP
1 vote127 views1 answer
Increase xampp phpmyadmin import limit
PHP
3 votes135 views1 answer
Codeigniter check affected rows
PHP
0 vote161 views2 answers
Octobercms mail
PHP
5 votes142 views2 answers
Laravel groupby and latest
PHP Laravel
1 vote122 views1 answer
Notice: Trying to access array offset on value of type int in /var/www/pdam/modules/phpexcel/PHPExcel/Cell/DefaultValueBinder.php on line 82
PHP
40 votes123 views6 answers
Php remove last character from string
PHP