how can i show MySQL data on webpage?

EDR78

so I'm just getting started with PHP and MySQL, and I can't seem to get some data from the database onto the webpage. I need to fill about 100 apdiv's, most at random, but i'm trying one item first to see how it works.
Here's the code I am trying for one single element:

<?php
include ("login.inc");
$cxn = mysqli_connect($host,$user,$password,$dbname)
or die ("Couldn't connect to server");
/ Select from table Sponsors the filelocation of Picture1 /
$query = "SELECT Picture1 FROM Sponsors
WHERE SponsorID='102'";
$result = mysqli_query($cxn,$query)
or die ("Couldn't execute select query.");
$row = mysqli_fetch_assoc($result);
extract($row);
/ Show picture on webpage in element apdiv26/
echo "<div id="apDiv26"><img src='../{$row['Picture1']}' width="100" height="100" alt="clickhere" />";
?>
</div>

I get the following: parse error, expecting "," or ";" on the line where the echo statement is.

Can anyone tell me what is wrong, because I have been looking for hours but l can't find it.

thanks

djjjozsi

you did not escape the double quotes:

If you used extract on a $row array, you reach the indexes as normal strings.

I suggest that do not use $row , use $rows 🙂 I have argued about $row today, and he said that $row is a reversed variable 🙂 I think its not, Who knows 🙂

This code is working on one result only, if you have more then one you should use a while cycle to get the results.

$rows = mysqli_fetch_assoc($result);
extract($rows);
/* Show picture on webpage in element apdiv26*/
echo "<div id=\"apDiv26\"><img src='../$Picture1' width=\"100\" height=\"100\" alt=\"clickhere\" />";

EDR78

thanks for your reply. escaping double quotes works, using single quotes also works.
I am one step further, now I get to see my webpage with 'couldn't execute select query'

I will look into it after lunch. If I can't find a solution, or run into other problems, I will post another question.

Thanks again.

EDR78

Well, I keep getting the message "couldn't execute select query" on my webpage. I checked the file login.inc , and tried double quotes as well as single quotes.

When sending the query with mysql_send.php I get the right result from my database, so what's wrong?

here's the code:

<?php
include ("login.inc");
$cxn = mysqli_connect($host,$user,$password,$dbname)
or die ("Couldn't connect to server");
/* Select from table Sponsors the filelocation of Picture1 */
$query = "SELECT Picture1 FROM Sponsors
WHERE SponsorID='102'";
$result = mysqli_query($cxn,$query)
or die ("Couldn't execute select query.");
$rows = mysqli_fetch_assoc($result); 
extract($rows); 
/* Show picture on webpage in element apdiv26*/ 
echo "<div id=\"apDiv26\"><img src='../$Picture1' width=\"100\" height=\"100\" alt=\"clickhere\" />";
?>
</div>

NogDog

To get more information, you might want to echo out the MySQL error:

$result = mysqli_query($cxn,$query)
or die ("Couldn't execute select query: " . mysqli_error($cxn));

EDR78

thanks, got the right message to solve my problem. Looks like I need to learn to check my syntax more carefully.

Now I can finally get to work with the interesting parts,

thanks again