What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do i exclude the current logged in user from a PHP\MySqlscript
Posted on 2013-01-18
Hi
I have an Andriod application that logs in and querys Mysql PHP script. The script returns a list of books within a date then returns the list into a list view. All this works absolutely fine.
Now i want to bring the same list back but do not include the books for user thats logged in.
At the moment it returns all the books including the user im logging at, could someone suggets away of not to include the current logged in user?
Heres the current PHP script, note i have added the <>1 (this is the userId im logging as) just as a quick work around, abviously this is not a good way though:
$result = mysql_query("SELECT users.uid, users.name, users.book
FROM users
WHERE EXISTS (SELECT 0 FROM available A1, available A2
WHERE A1.uid =1 AND A2.uid = users.uid
AND A1.AvailableDates = A2.AvailableDates
AND users.uid <>1)") or die(mysql_error());
I would imagine i would need to get the current users id and exclude that from the query (somehow)?
I have an Andriod application that logs in and querys Mysql PHP script. The script returns a list of books within a date then returns the list into a list view. All this works absolutely fine.
Now i want to bring the same list back but do not include the books for user thats logged in.
At the moment it returns all the books including the user im logging at, could someone suggets away of not to include the current logged in user?
Heres the current PHP script, note i have added the <>1 (this is the userId im logging as) just as a quick work around, abviously this is not a good way though:
$result = mysql_query("SELECT users.uid, users.name, users.book
FROM users
WHERE EXISTS (SELECT 0 FROM available A1, available A2
WHERE A1.uid =1 AND A2.uid = users.uid
AND A1.AvailableDates = A2.AvailableDates
AND users.uid <>1)") or die(mysql_error());
I would imagine i would need to get the current users id and exclude that from the query (somehow)?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
-
2
- +2
7 Comments
Probably the user id you're trying to get is in session variable, like
$_SESSION['userid']
You would hav eto know how it's set up during logging in.
Can you post the login script ?
$_SESSION['userid']
You would hav eto know how it's set up during logging in.
Can you post the login script ?
All scripts that use PHP client authentication follow the same design pattern. It is described in this article. Look for $_SESSION['uid'] to see the sort of thing you would want to exclude from the query results set.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_2391-PHP-login-logout-and-easy-access-control.html
Cant say what other thinks, but i personally find this very confusing and unclear.
What exactly does this means.
Now i want to bring the same list back but do not include the books for user thats logged in.
At the moment it returns all the books including the user im logging at, could someone suggets away of not to include the current logged in user?
What exactly does this means.
I think a better option could have been
1. user table userid , username
2.books table userid,bookname
3.available table userid,available date
Now to get all the book name which does not belong to a particular userid
use a query like
Select u.userid,u.username ,b.bookname from user
inner join books b on b.userid = u.userid
where u.userid <> 1
I am not sure what purpose available date is serving on your query.
An alternative could be ( based on your table structure - and my assumptions)
select u.userid,u.username,b.book
user u where u.userid <> 1
1. user table userid , username
2.books table userid,bookname
3.available table userid,available date
Now to get all the book name which does not belong to a particular userid
use a query like
Select u.userid,u.username ,b.bookname from user
inner join books b on b.userid = u.userid
where u.userid <> 1
I am not sure what purpose available date is serving on your query.
An alternative could be ( based on your table structure - and my assumptions)
select u.userid,u.username,b.book
user u where u.userid <> 1
Roads_Roads and Ray_Paseur, that sounds like just the job, one thing left then, my login function and the all books funtion are in 2 seperate files i.e. Login.php and Get_All_Book.php.
So if, in the login.php file i declare the $_SESSION and then pass the user id into the $_SESSION, can i then carry this over to the Get_All_Books.php file as $_SESSION [variable'']?
As an example:
//Login.php file
//Set up the variable in login.php file
$loggedinuser=addslashes($
//$loggedinuser will be the person who has logged into the app
$_SESSION['login_user']=$l
//Get_All_Books.php file
//Pull the varibale across from login.php
$user_check=$_SESSION['log
//Run query and exclude logged in user, query simplified for this example
$result = mysql_query("SELECT users.uid, users.name, users.book
FROM users
WHERE users.uid <>$user_check)") or die(mysql_error());
So if, in the login.php file i declare the $_SESSION and then pass the user id into the $_SESSION, can i then carry this over to the Get_All_Books.php file as $_SESSION [variable'']?
As an example:
//Login.php file
//Set up the variable in login.php file
$loggedinuser=addslashes($
//$loggedinuser will be the person who has logged into the app
$_SESSION['login_user']=$l
//Get_All_Books.php file
//Pull the varibale across from login.php
$user_check=$_SESSION['log
//Run query and exclude logged in user, query simplified for this example
$result = mysql_query("SELECT users.uid, users.name, users.book
FROM users
WHERE users.uid <>$user_check)") or die(mysql_error());
Featured Post
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Originally, this post was published on Monitis Blog, you can check it
here
.
In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing.
Set up your basic HTML file. Open your form tag and set the method and action attributes.:
(CODE)
Set up your first few inputs one for the name and …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 3 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.