How to Add php variable in laravel function

Question

$username='Vasim';

$results = DB::select(
    'Select r.LocationId ,LM.Name+'-'+LM.LocationCode as LocationName
        from User_Master u(nolock), UserRoleLoc_link r(nolock)
        left join Location_Master LM(nolock)
        on r.LocationId = LM.LocationId
        Where r.UserId = u.UserId
        AND u.UserName = '$username' AND LM.Status = 1 AND
        (IsNull(NullIf('',''),'1')='1' Or r.LocationId = '') 
        AND LM.isLocationOnline = 1
        Group by r.UserId, u.UserName, 
            r.LocationId,u.Password,LM.Name,LM.LocationCode
        having COUNT(r.UserId) > 0
        Order By Count(r.UserId) DESC');

Error : syntax error, unexpected '$username' (T_VARIABLE)

how can i use my variable in this query

Always fun when stackoverflow code syntax highlighting makes the problem quite clear! — jszobody
– jszobody, Commented Mar 11, 2016 at 13:54

Ravi Hirani · Accepted Answer · 2016-03-11 14:12:37Z

2

Write your query with Double quote"" instead of single Quote''.

$results = DB::select("SELECT r.LocationId ,LM.Name+'-'+LM.LocationCode as LocationName From User_Master u(nolock), UserRoleLoc_link r(nolock) 
    LEFT JOIN Location_Master LM(nolock) on r.LocationId = LM.LocationId 
    WHERE r.UserId = u.UserId AND u.UserName = '$username' 
    AND LM.Status = 1 AND (IsNull(NullIf('',''),'1')='1' Or r.LocationId = '') 
    AND LM.isLocationOnline = 1 GROUP BY r.UserId, u.UserName, r.LocationId,u.Password,LM.Name,LM.LocationCode HAVING COUNT(r.UserId) > 0 
    ORDER BY Count(r.UserId) DESC");

PHP executes variable in double quotes not in single quote.

$username = 'vasim';
echo '$username';  // $username
echo "$username";  // vasim

Hope it will help you :-)

edited Mar 11, 2016 at 14:12

answered Mar 11, 2016 at 13:58

Ravi Hirani

6,5341 gold badge31 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deep Kakkar · Accepted Answer · 2016-03-11 14:02:59Z

2

Use your db query like the following string:

   $username='Vasim';
   $results = DB::select("Select r.LocationId ,LM.Name+'-'+LM.LocationCode as LocationName from User_Master u(nolock), UserRoleLoc_link r(nolock) left join Location_Master LM(nolock) 
                on r.LocationId = LM.LocationId
                Where r.UserId = u.UserId
                AND u.UserName = '".$username."'  AND LM.Status = 1 AND
                (IsNull(NullIf('',''),'1')='1' Or r.LocationId = '') AND LM.isLocationOnline = 1
                Group by r.UserId, u.UserName, r.LocationId,u.Password,LM.Name,LM.LocationCode
                having COUNT(r.UserId) > 0
                Order By Count(r.UserId) DESC");

Please check the double quoted string and concatenation change in the query there.

edited Mar 11, 2016 at 14:02

answered Mar 11, 2016 at 13:54

Deep Kakkar

6,3054 gold badges43 silver badges80 bronze badges

2 Comments

Sanjog Mittal Over a year ago

SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'Vasim'. (SQL: Select r.LocationId ,LM.Name+'-'+LM.LocationCode as LocationName from User_Master u(nolock), UserRoleLoc_link r(nolock) left join Location_Master LM(nolock) on r.LocationId = LM.LocationId Where r.UserId = u.UserId AND u.UserName = Vasim AND LM.Status = 1 AND (IsNull(NullIf('',''),'1')='1' Or r.LocationId = '') AND LM.isLocationOnline = 1 Group by r.UserId, u.UserName, r.LocationId,u.Password,LM.Name,LM.LocationCode having COUNT(r.UserId) > 0 Order By Count(r.UserId) DESC)

Ravi Hirani Over a year ago

@DeepKakkar: If you write query by concatation way then you should write UserName = '".$username."' instead of current one.

Collectives™ on Stack Overflow

How to Add php variable in laravel function

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related