php mysql where clause not reading variable

Question

I am starting to get furious here

mysql_query don't recognize my variable $d1 even I tried to rename it

here is the code..

html:

<form action ="manageVessel.php" method ="POST">
  <select onchange ="this.form.submit();" class ="form-control" name ="ViewPositionCertificates">
      <option>Choose a Position </option>                                                       
      <?php
      $ViewPCertificates = mysql_query("SELECT * FROM table_cmsjob") or die("error" . mysql_error());
      while ($rwViewPCertificates = mysql_fetch_array($ViewPCertificates)) {
          ?>
          <option value =" <?php echo $rwViewPCertificates['jobName']; ?> "> <?php echo $rwViewPCertificates['jobName']; ?></option>  
      <?php } ?>

       </select>   
</form>

php:

   <?php if (isset($_POST['ViewPositionCertificates'])) { ?>
      <table class = "table table-bordered">
          <tr class ="bg-primary">
              <td> List of Certificates </td>
          </tr>
          <?php
          $d1 = $_POST['ViewPositionCertificates'];
          echo $_POST['ViewPositionCertificates'];
          $ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  '$d1' ") or die("error" . mysql_error());

          while ($rwViewCertificatesFP = mysql_fetch_array($ViewCertificatesFP)) {

              echo "<tr>";
              echo "<td>" . $rwViewCertificatesFP['Certificate'] . "</td>";
              echo "</tr>";
          }
          ?>

      </table>




  <?php } ?>

MYSQL WHERE clause is working fine when I used a string for example

    mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  'MASTER' ") or die("error" . mysql_error());

but when I used a variable to assign $_POST['ViewPositionCertificates'] to a variable MYSQL WHERE clause doesn't read it any help?

$ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName = '{$d1}' ") or die("error" . mysql_error()); use this query and a pair of avice, please prefer mysqli over mysql — Amit Sarwara
– Amit Sarwara, Commented Dec 15, 2015 at 7:04
As nobody said it I'll say it. Please don't use mysql_* functions as they are deprecated and in the newly released PHP 7.0 deleted use mysqli or PDO instead. Also when handling user input use prepared statements otherwise your query is open for SQL injections — BRoebie
– BRoebie, Commented Dec 15, 2015 at 9:29

Shailesh Katarmal · Accepted Answer · 2015-12-15 07:12:15Z

3

<option value ="<?php echo $rwViewPCertificates['jobName']; ?>"> <?php echo $rwViewPCertificates['jobName']; ?></option>   // remove xtra spaces from here......

Remove spaces from value attribute

answered Dec 15, 2015 at 7:12

Shailesh Katarmal

2,7931 gold badge15 silver badges16 bronze badges

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

1 Comment

Salvador Mark Anjelo Over a year ago

thanks did not notice whitespace from value attribute

Amit Rajput · Accepted Answer · 2015-12-15 07:10:29Z

1

Try like this..

$ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  '".mysql_real_escape_string(trim($d1))."' ") or die("error" . mysql_error());

or

$ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  '".addslashes(trim($d1))."' ") or die("error" . mysql_error());

answered Dec 15, 2015 at 7:10

Amit Rajput

2,0591 gold badge13 silver badges27 bronze badges

1 Comment

Amit Rajput Over a year ago

I think there is some special character in value of "$d1" variable. Try using with mysql_real_escape_string() or addslashes()

Felix Kamote · Accepted Answer · 2015-12-15 07:03:48Z

0

Try this one:

mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  ".$_POST['ViewPositionCertificates'])

answered Dec 15, 2015 at 7:03

Felix Kamote

3422 silver badges10 bronze badges

Comments

Amit Rajput · Accepted Answer · 2015-12-15 07:06:11Z

0

<?php if (isset($_POST['ViewPositionCertificates'])) { ?>
    <table class = "table table-bordered">
        <tr class ="bg-primary">
            <td> List of Certificates </td>
        </tr>
        <?php
        $d1 = $_POST['ViewPositionCertificates'];
        echo $_POST['ViewPositionCertificates'];
        $ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  '".$d1."' ") or die("error" . mysql_error());

        while ($rwViewCertificatesFP = mysql_fetch_array($ViewCertificatesFP)) {

            echo "<tr>";
            echo "<td>" . $rwViewCertificatesFP['Certificate'] . "</td>";
            echo "</tr>";
        }
        ?>
    </table>
<?php } ?>

Change in select query syntax use single quote.

edited Dec 15, 2015 at 7:06

Amit Rajput

2,0591 gold badge13 silver badges27 bronze badges

answered Dec 15, 2015 at 7:01

Vishal Kamal

1,1242 gold badges10 silver badges35 bronze badges

2 Comments

Salvador Mark Anjelo Over a year ago

thanks for the response :) but I already tried that so far wont work? I also tried to restart my apache and mysql but it still don't work

Felix Kamote Over a year ago

Don't you know how to vote? Or you just need an answer.

Sanjay · Accepted Answer · 2015-12-15 07:08:05Z

0

You can not write variables inside single quotes, if you write it then PHP will consider it as string. so your query will be
$ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName = $d1 ") or die("error" . mysql_error());

for more help , please read variable interpolation in PHP

answered Dec 15, 2015 at 7:08

Sanjay

2,0482 gold badges19 silver badges26 bronze badges

3 Comments

Salvador Mark Anjelo Over a year ago

Thanks for the response I already tried that but I keep getting an error Unknown column 'MASTER' in 'where clause' master is one of the rows in my database for column jobName

Sanjay Over a year ago

ok then please confirm 'MASTER' is column present in your MySQL table

Sanjay Over a year ago

please replace $d1 to ' " .$d1. " ' , I think it will solve your problem

rahul · Accepted Answer · 2015-12-15 07:02:57Z

-1

Try to change your query method it may help...

$ViewCertificatesFP = mysql_query("SELECT * FROM table_cmsjobassigning WHERE jobName =  '".$d1."' ") or die("error" . mysql_error());

answered Dec 15, 2015 at 7:02

rahul

7747 silver badges30 bronze badges

Collectives™ on Stack Overflow

php mysql where clause not reading variable

6 Answers 6

1 Comment

1 Comment

Comments

2 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

1 Comment

Comments

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related