How to fetch data form database using array

Question

I am trying to fetch data from the database, but not retrieve data particular id. this is my one page: example1.php

  <a style="color: #3498DB;" class="btn btn-default" href="http://www.example.com/getafreequote?id=<?php echo $row['product_id'];  ?>">Get Quote</a>

example2.php

 <?php 
   $id = isset($_GET['id'])?$_GET['id']:'';

        $query = "SELECT * FROM oc_product_description WHERE product_id=$id";
        $run1 = mysql_query($query);
         while ($fetch1 = mysql_fetch_object($run1)){


   ?>

    <div class="col-xs-12 col-sm-6">
     <label for="GetListed_product"></label>
                <input class="le-input" name="product" id="GetListed_product" type="text"  value="<?php 
                    $b = $fetch1->product_id;

                            $q2 ="SELECT product_id,name FROM oc_product_description WHERE product_id = $b";
                            $q3 = mysql_fetch_assoc(mysql_query($q2));
                         echo $q3['name'];

                ?>" >
    <span id="productmsg" class="msg"></span>
    </div>
<?php
                  }
                  ?>

</div>

but didnot get data form particular product id. I have got error show like this

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in example.com/example2.php on line 71

check by die(mysql_error());

Mayank K. Swami
– Mayank K. Swami

2015-10-31 12:02:40 +00:00
Commented Oct 31, 2015 at 12:02 — Mayank K. Swami
– Mayank K. Swami, Commented Oct 31, 2015 at 12:02

FilipNikolovski · Accepted Answer · 2015-10-31 12:24:59Z

1

Please don't use mysql functions they are deprecated. Use mysqli or PDO for database operations. Also the way you write the query string makes it easy for an SQL injection, use prepared statements instead. Here is an example:

$db = new PDO("...");
$statement = $db->prepare("select id from some_table where name = :name");
$statement->execute(array(':name' => "Jimbo"));
$row = $statement->fetch();

You can also use prepared statements for inserting or updating data. More examples here

answered Oct 31, 2015 at 12:24

FilipNikolovski

714 bronze badges

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

1 Comment

Rudie Over a year ago

The sql injection is the most important part here.

Suyog · Accepted Answer · 2015-10-31 12:38:32Z

0

As said by FilipNikolovski, don't use mysql functions they are deprecated. Use mysqli or PDO for database operations.

For your problem, the function mysql_query is returning false. The query is not returning any result and thus mysql_query is returning false.

Make a check like this:

$query = "SELECT * FROM oc_product_description WHERE product_id=$id";
$run1 = mysql_query($query);
if($run1)
{
     if(mysql_num_rows($run1) > 0)
     {
          while ($fetch1 = mysql_fetch_object($run1))
          {
                // your stuff here
          }
     }
     else
     {
          echo "No records found.";
     }
}
else
{
      echo "Error in query : ".mysql_error();
}

This will help you to detect the problem and to solve as well.

answered Oct 31, 2015 at 12:38

Suyog

2,4811 gold badge16 silver badges27 bronze badges

6 Comments

balvant parmar Over a year ago

I am try to put this code but result show blank page

balvant parmar Over a year ago

I am also use mysqli $conn = new mysqli($servername, $username, $password, $dbname);

balvant parmar Over a year ago

$id = isset($_GET['id'])?$_GET['id']:''; $query = "SELECT * FROM oc_product_description WHERE product_id=$id"; $run1 = mysql_query($query); if($run1) { if(mysql_num_rows($run1) > 0) { while ($fetch1 = mysql_fetch_object($run1)) { <div class="col-xs-12 col-sm-6"> <label for="GetListed_product"></label> <input class="le-input" name="product" id="GetListed_product"type="text" value="<?php $b = $fetch1->product_id; $q2 ="SELECT product_id,name FROM oc_product_description WHERE product_id = $b"; $q3 = mysql_fetch_assoc(mysql_query($q2)); echo $q3['name']; ?>" >

Suyog Over a year ago

@balvantparmar you have lots of syntax errors in the code pasted above

Suyog Over a year ago

from where do you want to fetch id?

|

Collectives™ on Stack Overflow

How to fetch data form database using array

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related