mysql - How to fetch data from two tables based on session variable php? -


actually im trying display data 2 tables on database based on current session, basically, had read many article , forum on how solve problem still facing them till now. data , code did:

<?php include('db.php');  $sql="select* users inner join details on users.id= details.id limit 1 users.id ='$loggedin_id' " ;  $result=mysqli_query($db,$sql); if (!$result) { printf("error: %s\n", mysqli_error($db)); exit(); } ?>

so here, got error: "error: have error in sql syntax; check manual corresponds mariadb server version right syntax use near 'where users.id = '16'' @ line 3". if use query:

 $sql="select* users inner join details on users.id= details.id"

it display data in database, need data current session.

here session.php file:

<?php  include('db.php'); session_start(); $user_check=$_session['sess_username']; $ses_sql=mysqli_query($db,"select username,id users username='$user_check' "); $row=mysqli_fetch_array($ses_sql,mysqli_assoc); $loggedin_session=$row['username']; $loggedin_id=$row['id']; $role = $_session['sess_userrole']; if(!isset($loggedin_session) && $role!="user"){   header('location: index.php?err=2'); } ?>

this tables detail: table users table details

hope can me, im new sql , php. tq

change query that.

$sql="select* users inner join details on users.id= details.id users.id ='$loggedin_id' limit 1" ;

Comments

Post a Comment

Popular posts from this blog

python - PyInstaller UAC not working in onefile mode -

hello everybody. i have small python project , want make single executable file . using... windows 7 python 3.4 pyinstaller 3.2.1 my pyinstaller command is, pyinstaller -y -w -f -n output_file_name --uac-admin --clean source_file.py this command works properly. single output file not ask admin rights when executed. , there's no shield mark on executable file icon. when remove -f option (equivalent --onefile), output executable file has shield mark on icon , ask me admin rights. not want. want single executable file. i found manifest file (output_file_name.exe.manifest) in dist\output_file_name folder. did... pyinstaller -y -w -f -n output_file_name --manifest output_file_name.exe.manifest --uac-admin --clean source_file.py but command doesn't work. single executable file still not ask admin rights. i have removed pyinstaller , installed recent development version. pip install git+https://github.com/pyinstaller/pyinstaller.git@develop but result...
Read more

php - Need to store a large amount of data in session with CI 3 but on storing large data in session it is itself destorying automatically -

i working on large web application need database retrieved session instead of database. first time retrieving db , saving session onward calls of data going session. it handling data @ stage when got more data stored in session session got destroyed automatically... "this problem seems similar question says title session destroyed after redirect other pages of site." i got answer questions point here how handle thing when know in future have more data stored inside session, i wanted know little bit more involved answer right in development stage on production when have user 100000 or more how session behave, application behave in same manner did before. kindly discuss me, researching, need corporation more technical in php discussion may solution many of people facing same kind of issues.. you need use native php session because php session stores id in cookie. codeigniter stores data in cookie , problem stuck. so either need use native php sessions...
Read more

ios - Pass NSDictionary from Javascript to Objective-c in JavascriptCore -

i'm using javascriptcore in app. now, i'm passing variables jscontext can passed objective-c. however, 1 of variables, nsdictionary, not passing through correctly. run code below: var evaluate = function(variables) { app.setdictionary(variables.dictionary); } this simple example has these following methods set in jscontext . this setdictionary() method: - (void)setdicationary:(nsdictionary *)dictionary { self.mutabledictionary = [dictionary mutablecopy]; } this variables.dictionary : - (nsdictionary *)dictionary { return self.values; } and how call evaluate() : jsvalue *jsfunction = self.context[@"evaluate"]; jsvalue *value = [jsfunction callwitharguments:@[self.variables]]; however, in setdictionary method, don't nsdictionary, instead nsstring containing [object object] . any ideas how can solve this? although javascriptcore automatically converts types between objective-c or swift , javascript, suggest implement ex...
Read more