How to put php variable in an sql query

Question

So this is my code:

<nav class="navbar navbar-inverse">
    <div class="container-fluid">
        <div class="navbar-header">
          <a class="navbar-brand" href="#">WebSiteName</a>
        </div>

        <ul class="nav navbar-nav">
          <li class="active"><a href="#">Home</a></li>

          <?php
               $dbconn= new PDO('sqlite:negozio.db');


          $sqlcate = "SELECT * FROM categoria";
          foreach($dbconn->query($sqlcate) as $row) { ?>
          <li class="dropdown"> 
            <a class="dropdown-toggle" data-toggle="dropdown" href="#"><?php echo $row['des_categoria']; ?> <span class="caret"></span></a>

            <ul class="dropdown-menu">
              <?php 
                $sqltipocate = "SELECT tipo.des_tipo FROM tipo, categoria, tipo_cate WHERE tipo_cate.id_cate = categoria.id_categoria AND tipo_cate.id_tipo = tipo.id_tipo AND tipo_cate.id_categoria = " . $row['id_categoria'] . " "" "; 

              foreach($dbconn->query($sqltipocate) as $row1) { ?>

              <li><a href="#"><?php echo $row1['des_tipo']; ?></a></li>
            <?php } ?>  
          </ul>
      </li>
      <?php } ?>

        </ul>
  </div>
</nav>

Everything is working fine until $sqltipocate blabla...

This error always appears:

syntax error, unexpected T_CONSTANT_ENCAPSED_STRING

Can someone help me?

@Anant but others may see it and it could help them, so they could upvote and you would get more reputation, or I guess that's not anymore much of a motivation at 10K rep? — benomatis
– benomatis, Commented Apr 24, 2016 at 19:43
@Anant well, apparently it's what I did (not realising it was already there as a comment by you) and indeed I got nothing but downvotes, so I deleted it... well, let me move on... — benomatis
– benomatis, Commented Apr 24, 2016 at 19:47
@Anant no hard feelings, man, it's just a question, there are plenty more to answer... ;) enjoy! — benomatis
– benomatis, Commented Apr 24, 2016 at 19:49
Possible duplicate of Reference - What does this error mean in PHP? — Mike
– Mike, Commented Apr 24, 2016 at 20:17

SaidbakR · Accepted Answer · 2016-04-25 10:45:00Z

1

It is concatenation problem as regarded in previous answers. I can add something may make your life easier. It is sprintf

Your sql query string will be the format parameter of sprintf as follows:

            $sqltipocate = sprintf("SELECT tipo.des_tipo FROM tipo, categoria, tipo_cate WHERE tipo_cate.id_cate = categoria.id_categoria AND tipo_cate.id_tipo = tipo.id_tipo AND tipo_cate.id_categoria = %d", $row['id_categoria']);

answered Apr 25, 2016 at 10:45

SaidbakR

13.6k23 gold badges113 silver badges202 bronze badges

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

Comments

marmeladze · Accepted Answer · 2016-04-25 10:53:07Z

0

Use curly braces.

Example:

$id = 1;
$sql = "SELECT * FROM something WHERE id = {$id}";

echo $sql;
//SELECT * FROM something WHERE id = 1

Link to code: http://codepad.org/V9QasGHH

answered Apr 25, 2016 at 10:53

marmeladze

6,5863 gold badges28 silver badges49 bronze badges

Comments

Devsi Odedra · Accepted Answer · 2016-05-17 09:20:11Z

0

Store your $row['id_categoria'] in variable like

$id = $row['id_categoria'];

Then put $id in query like:

$sqltipocate = "SELECT tipo.des_tipo FROM tipo, categoria, tipo_cate WHERE tipo_cate.id_cate = categoria.id_categoria AND tipo_cate.id_tipo = tipo.id_tipo AND tipo_cate.id_categoria = '".$id."'";

See this tipo_cate.id_categoria = ' " $id " '

answered May 17, 2016 at 9:20

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

Collectives™ on Stack Overflow

How to put php variable in an sql query

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related