Php image error in displaying

Question

When i run this query images are displaying from php correctly.

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("dawat");
$submit=$_GET['str'] ;
$sql = mysql_query("SELECT * FROM searchengine WHERE pagecontent LIKE '%$_GET%' ");    
while($row=mysql_fetch_array($sql)) {
echo "<img src=image.php?pagecontent=".$row['pagecontent']." />";
}
?>

And code of image.php:

<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
$conn = mysql_connect("localhost","root","");
if(!$conn)
{
echo mysql_error();
}
$db = mysql_select_db("dawat",$conn);
if(!$db)
{
echo mysql_error();
}
$pagecontent = $_GET['pagecontent'];
$q = "SELECT pageurl FROM searchengine where pagecontent='$pagecontent'";
$sql = mysql_query("$q",$conn);
if($sql)
{
$row = mysql_fetch_array($sql);
echo $row['pageurl'];
}
else
{
echo mysql_error();
}
?>

And when i run same code of above just few changes in search script:

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("dawat");
$submit=$_GET['str'] ;
$sql = mysql_query("SELECT pageurl, BIT_COUNT(pagecontent^'$submit') 
FROM searchengine WHERE pagecontent < 20 ORDER BY pagecontent ASC;
") or die(mysql_error());
while($row=mysql_fetch_array($sql)) {
echo "<img src=image.php?pagecontent=".$row['pagecontent']." />";
}
?>

It is showing errors that undefined index:pagecontent and also not showing images.Please help and thanks in advance.

Are you sure that your changed SQL has return value ?

fanfan1609
– fanfan1609

2014-08-22 04:58:36 +00:00
Commented Aug 22, 2014 at 4:58 — fanfan1609
– fanfan1609, Commented Aug 22, 2014 at 4:58

Jenz · Accepted Answer · 2014-08-22 04:58:30Z

3

In your query

$sql = mysql_query("SELECT pageurl, BIT_COUNT(pagecontent^'$submit') 
FROM searchengine WHERE pagecontent < 20 ORDER BY pagecontent ASC;
") or die(mysql_error());

You are not fetching the column pagecontent and is trying to access it in

echo "<img src=image.php?pagecontent=".$row['pagecontent']." />";
                                                   ^

So change your query to,

$sql = mysql_query("SELECT pageurl,pagecontent, BIT_COUNT(pagecontent^'$submit') 
FROM searchengine WHERE pagecontent < 20 ORDER BY pagecontent ASC;
") or die(mysql_error());

answered Aug 22, 2014 at 4:58

Jenz

8,3718 gold badges50 silver badges83 bronze badges

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

1 Comment

user3958765 Over a year ago

Thank you so much.I worked.You don't know how much i have troubled for this..Thank you.

Syed Ibrahim · Accepted Answer · 2014-08-22 05:08:18Z

1

Try it and get print value from $sql.. you will get idea from how to return it..

$sql = mysql_query("SELECT pageurl,pagecontent, BIT_COUNT(pagecontent^'$submit') 
FROM searchengine WHERE pagecontent < 20 ORDER BY pagecontent ASC;
") or die(mysql_error());

answered Aug 22, 2014 at 5:08

Syed Ibrahim

5831 gold badge6 silver badges19 bronze badges

1 Comment

user3958765 Over a year ago

Thank you so much.I worked.You don't know how much i have troubled for this..Thank you.

Collectives™ on Stack Overflow

Php image error in displaying

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related