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 vote204 views1 answer
Carbon this month first day
PHP
1 vote207 views1 answer
Include a file in laravel controller
PHP
0 vote225 views1 answer
How convert the string to int in laravel function event
PHP Laravel
0 vote254 views1 answer
<warning>PHP Warning: preg_grep() expects parameter 2 to be array, string given in G:\Office Projects\Luggage Backend\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Concerns \Guards Attributes.php on line 207</warning>
PHP Laravel
3 votes174 views2 answers
How to export database from phpmyadmin
PHP
21 votes226 views2 answers
Php unset by value
PHP
0 vote235 views1 answer
Laravel take value from different array by key
PHP Laravel
0 vote223 views1 answer
Phpunit/phpunit[dev-master, 9.3.3, ..., 9.4.x-dev] require ext-dom * -> it is missing from your system. Install or enable PHP's dom extension.
PHP
1 vote241 views1 answer
Php connect to postgresql
PHP
6 votes207 views2 answers
Get size files in laravel
PHP