PHP Query and div class

Question

I really need some help. I am trying to build a website and pull content from a mysql database. The div I am trying to populate is below. The problem I have is how do I incorporate the php code into the div?

<div class="cardetails">
    <img src="img/carpic.jpg"/>
    <p class="make"><a href="car.html">'model of car'<a></p>
    <p class="price">£Price</p>
    <div class="clear"></div>
</div>


$db = mysql_connect("localhost", "root", "Password1")
    or die ("Couldn't connect to Server!");
$result = mysql_select_db("my_cars", $db)
    or die ("Couldn't select Database!");
$query = "select img, make, price, from tbl_automatic WHERE MakeID = '7'";
$result = mysql_query($query,$db)
    or die ("Couldn't execute query!");

Thanking you all in advance

Let me get it stright, you want to post query information/details in a div? — Yotam
– Yotam, Commented Oct 5, 2013 at 18:54
Please don't use any mysql_ functions as they are deprecated. Use PDO instead. — nietonfir
– nietonfir, Commented Oct 5, 2013 at 18:56
Hi Evceyone, thanks for getting back to me. Sorry for late reply, I had to take a break as it was "doing my head in". — grimm1
– grimm1, Commented Oct 6, 2013 at 9:28

neeagl · Accepted Answer · 2013-10-05 18:54:29Z

2

<?php
$db = mysql_connect("localhost", "root", "Password1")
    or die ("Couldn't connect to Server!");
$result = mysql_select_db("my_cars", $db)
    or die ("Couldn't select Database!");
$query = "select img, make, price, from tbl_automatic WHERE MakeID = '7'";
$result = mysql_query($query,$db)
    or die ("Couldn't execute query!");

while($q = mysql_fetch_array($result)){
?>
<div class="cardetails">
    <img src="<?=$q['img']?>"/>
    <p class="make"><a href="car.html"><?=$q['make']?><a></p>
    <p class="price"><?=$q['price']?></p>
    <div class="clear"></div>
</div>

<?php
}
?>

I hope it solves your problem.

answered Oct 5, 2013 at 18:54

neeagl

3481 silver badge13 bronze badges

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

2 Comments

grimm1 Over a year ago

Hi neeagl, Sorry for late reply. Many thanks for your solution, unfortunately nothing is being pulled into the page. If I run the query in phpMyadmin, it returns the correct information. Any further help is appreciated.

neeagl Over a year ago

Can you please paste content of your page by doing view-source? Thanks

logic-unit · Accepted Answer · 2013-10-05 19:00:14Z

0

neeagl beat me to it but here's mine anyhow. As mentioned in the comments it's best to use mysqli or pdo now.

<?php
$db = mysql_connect("localhost", "root", "Password1")
    or die ("Couldn't connect to Server!");
$result = mysql_select_db("my_cars", $db)
    or die ("Couldn't select Database!");
$query = "select img, make, price, from tbl_automatic WHERE MakeID = '7'";
$result = mysql_query($query,$db)
    or die ("Couldn't execute query!");


$cardetails = '';

while($row = mysql_fetch_array($result)) {
$cardetails .= '
<div class="cardetails">
    <img src="img/'.$row['img'].'"/>
    <p class="make"><a href="car.html">'.$row['make'].'<a></p>
    <p class="price">£'.$row['price'].'Price</p>
    <div class="clear"></div>
</div>';
}

echo $cardetails;

answered Oct 5, 2013 at 19:00

logic-unit

4,31312 gold badges50 silver badges74 bronze badges

1 Comment

grimm1 Over a year ago

Hi logic-unit, Many thanks for your input. You mention mysqli or pdo unfortunately, I am not sure how to do that as I am new to all of this. Any guidance is much appreciated.

Collectives™ on Stack Overflow

PHP Query and div class

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related