Pozdrav
Dali je moguce preko GET uhvatit id preko JSON outputa ?
Imam skriptu za prikaz podataka, i kada povucem podatke iz baze trebo bih link koji ce mi otvorit npr tablicu i sve podatke od tog id-a.
Ali neznam kako to da odradim posto ovi podaci ce da se koriste preko jquery-a.
Problem je kako napravit link tipa index.php?id=$id ali preko json-a.
if (isset($_GET['id']) && !empty($_GET['id']) && is_numeric($_GET['id'])) {
$id = (int)$_GET['id'];
echo '<h1>TRADES FROM ID : '.$id.'</h1>';
$c_limit = 100; // limit of displayed results from 'trades' table
$query3 = "SELECT a.id, a.email, a.user_type, a.account_number, b.*
FROM ".$DEFAULT['db_tables']['www_users']." a
INNER JOIN ".$DEFAULT['db_tables']['trades']." b ON a.id = b.uid WHERE b.uid = ".$id." LIMIT ".$c_limit;
$data_single_user = fetch_array($query3);
if ( ! $data_single_user ) {
echo 'There is no single user data';
die();
}
echo json_encode($data_single_user);
} else {
$a_limit = 100; // limit of displayed results from 'trades' table
$query2 = "SELECT a.id, a.email, a.user_type, a.account_number, b.*
FROM ".$DEFAULT['db_tables']['www_users']." a
INNER JOIN ".$DEFAULT['db_tables']['trades']." b ON a.id = b.uid LIMIT ".$a_limit;
$data_user = fetch_array($query2);
if ( ! $data_user ) {
echo 'There is no user data';
die();
}
echo json_encode($data_user);
}