-2

here my code called data.php 

<?php 
sql = db->query('SELECT* FROM tb_karyawan order by kar_id desc');
while($data = $sql->fetch(PDO::FETCH_ASSOC)){
} ?>

nilai.php?hal=tambah&kd=

and my nilai.php

<?php
$sql = $db->query('SELECT * FROM tb_karyawan WHERE kar_id=$_GET["kar_id"]) .');
$data = $sql->fetch(PDO::FETCH_ASSOC);
?>

how to get kar_id from previous page to next page by $_GET METHOD using PDO i am new for PDO THANKS

Rushil K. Pachchigar
  • 1,263
  • 2
  • 21
  • 40
reikiy renaldi
  • 1
  • 7
    You're already using PDO, **please please please PLEASE** bind your parameters instead of passing it through as you are. Save yourself from SQL Injection. – Darren Feb 27 '17 at 03:57

1 Answers1

0
<?php
while($data = $sql->fetch(PDO::FETCH_ASSOC)){ ?>
    <a href="nilai.php?kar_id='<?php echo $data['kar_id'] ?>'">Link</a>
<?php }
?>

nilai.php:

$kar_id = $_GET["kar_id"];
$sql = $db->prepare('SELECT * FROM tb_karyawan WHERE kar_id=:kar_id');
$sql->bindValue(':kar_id', $kar_id , PDO::PARAM_INT);
$sql->execute();
Rushil K. Pachchigar
  • 1,263
  • 2
  • 21
  • 40