PHP - Displaying Image From Table

I just can't get anything right today! Now I am trying to have a list of images, and when the user clicks on the image, the next page will display the image along with other fields for that record. I am sending the id through the hyperlink to the next page, and I have echoed it to ensure it's comign through, but I cannot get anythign to display ont he next page. What am I doin wrong? Here is the link to the page. If you click on one of the images, you 'll see that the next page is empty:


http://webdesignsbyliz.com/wdbl_wordpress/test-submit/


Here is my code:


Code: [Select]

this is the gallery


<?php
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';


$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');


$dbname = 'jewelry';
mysql_select_db($dbname);


$all_records = "SELECT * FROM gallery";
$all_records_res = mysql_query($all_records);
$image = mysql_result($all_records_res, 0, 'image');
$id = mysql_result($all_records_res, 0, 'id');


while($nt=mysql_fetch_array($all_records_res)){
echo "<a href=http://webdesignsbyliz.com/wdbl_wordpress/test-display/?id=" .$nt['id']." ><img src=http://www.webdesignsbyliz.com/wdbl_wordpress/wp-content/themes/twentyten_2/upload/".$nt['image']." width=133 height=86></a>";
}


?>




display page:
Code: [Select]

<?php


$id = $_GET['id'];


$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';


$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');


$dbname = 'jewelry';
mysql_select_db($dbname);


$all_records = "SELECT * FROM gallery WHERE id = $_GET[id]";
$all_records_res = mysql_query($all_records);
$image = mysql_result($all_records_res, 0, 'image');
$id = mysql_result($all_records_res, 0, 'id');


while($nt=mysql_fetch_array($all_records_res)){
echo "<img src=http://www.webdesignsbyliz.com/wdbl_wordpress/wp-content/themes/twentyten_2/upload/".$nt['image']." width=133 height=86></a>";
}








?>


What an I doing wrong this time?? :-(

Not really sure how to get the images I have stored in MySQL into a html form. I can call-up the text fields from the database but it cannot seem to find the index for the images.

Here is my code:-

<?php
session_start();
mysql_connect("localhost","root","abc") or die ("Error! Cannot connect to database");
mysql_select_db("theimageworks") or die ("Cannot find database");
$query = "SELECT * FROM jobs";
$result = mysql_query($query) or die (mysql_error());
?>


<?php
//display data in html table
echo "<table>";
echo "<tr><td>Username</td><td align='center'>Message</td><td>Product Image</td></tr>";

while($row = mysql_fetch_array($result)) {
    echo "</td><td>";
    echo $row['username'];
    echo "</td><td>";
    echo $row['message'];
    echo "</td></tr>";   
    echo $row['image'];
     }
echo "</table>";
?>

The error message I get is "Notice: Undefined index: image in....."

Thanks in advance!

hi guys I am having trouble displaying a table in a mySQL database
i get the error message
Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/students/accounts/s7188633/hit3323/www/htdocs/Assiment2V2/main.php on line 47

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /home/students/accounts/s7188633/hit3323/www/htdocs/Assiment2V2/main.php on line 53

these are the two line that it realtes to

row  47:   $Row = mysqli_fetch_row($result);
   
row  53:   $Row = mysqli_fetch_row($result);

below is all the code if you wanted to look at it,

thanks

<?php
$choice = addslashes ($_POST["selection"]);
{
   $DBConnect = @mysqli_connect("neptune.it.swin.edu.au", "*****", "***")
      Or die("<p>Unable to connect to the database server.</p>"
      . "<p>Error code " . mysqli_connect_errno()
      . ": " . mysqli_connect_error()) . "</p>";
   $DBName = "*****_db";
   if (!@mysqli_select_db($DBConnect, $DBName))
      echo "<p>The database is not available.</p>";

   $SQLstring = "SELECT * FROM Books";// WHERE category = 'Programing'";
   $QueryResult = @mysqli_query($DBConnect, $SQLstring)
      Or die("<p>Unable to execute the query.</p>"
      . "<p>Error code " . mysqli_errno($DBConnect)
      . ": " . mysqli_error($DBConnect)) . "</p>";
   $NumRows = mysqli_num_rows($QueryResult);
   if ($NumRows == 0)
       echo "<p>No records returned.</p>";
   else
   {
      mysqli_select_db($DBConnect, $DBName);
 
     $SQLstring = "SELECT * FROM Books";
  $result = @mysql_query($DBConnect, $SQLstring);

   $Row = mysqli_fetch_row($result);
   do {
      echo "<tr><td>{$Row[0]}</td>";
      echo "<td>{$Row[1]}</td>";
      echo "<td align='right'>{$Row[2]}</td>";
      echo "<td align='right'>{$Row[3]}</td></tr>";
      $Row = mysqli_fetch_row($result);
   } while ($Row);
}
   
   }
         
mysqli_close($DBConnect);
   

?>

Hi all!

I've been recently messing with PHP and MySQL to attempt to create a search function for my tables (too advanced, so I toned it down to learning to just display data from my table).  Anyways, I'm watching a YouTube video on how to do it, and I'm copying his code exactly, but I'm still getting an error.   Can anyone help?  Thanks.    Edit: Sorry, my error was snuggled down below the code.  Anyways, my error is just my while echo appearing in and out of my tables on the page.   My code:

<?php

//Make connection
mysql_connect('localhost', 'root', 'test');

// select db
mysql_select_db('testdatabase');

$sql="SELECT * FROM employees";

$records=mysql_query($sql);



?>



<html>
<head>
<title>Employee Data</title>
</head>

<body>
<table width="600" border="1" cellpadding="1" cellspacing="1">
<tr>

<th>ID</th>
<th>First name</th>
<th>Surname</th>
<th>Age</th>
</tr>

<?php

while($employees=mysql_fetch_assoc($records)){
	echo "<tr>";
	echo "<td>".$Employee['ID']."</td>";
	echo "<td>".$Employee['First name']."</td>";
	echo "<td>".$Employee['Surname']."</td>";
	echo "<td>".$Employee['Age']."</td>";
	echo "</tr>";
}
// end while
?>
</table>
</body>
</html>

Edited by thwikehu1990, 19 January 2015 - 01:33 PM.

for some reason it will not render to the row... ive added the php echo to the row in question and it runs with the top row... can someone take a look and let me know what i am doing wrong...

thanks
trey

here is the code... the php echo in bold red should show up on the next row; but, it doesnt...

<?php
/**
* @version $Id: mod_gridiron_game_results.php, v1.5.0 March 2011 01:32:15
* @author Fastball Productions
* @package Gridiron
* @copyright Copyright (C) 2011 Fastball Productions
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();

// get the module parameters
$heading = $params->get( 'heading', '' );
$showpast = $params->get( 'showpast', '1' );
$numberpast = $params->get( 'numberpast', '1' );
$linkboxscore = $params->get( 'linkboxscore', '1' );
$shownextgame = $params->get( 'nextgame', '1' );
$numbernext = $params->get( 'numbernext', '1' );
$linknext = $params->get( 'linknext', '1' );
$seasonid = $params->get( 'seasonid', '1' );
$gametypes = $params->get( 'gametypes', '1' );
$teamids = $params->get( 'teamids', '' );
$leagueids = $params->get( 'leagueids', '' );
$divisionids = $params->get( 'divisionids', '' );

if (is_array($gametypes)) {
   $gametypes = implode(',', $gametypes);
}
if (is_array($teamids)) {
   $teamids = implode(',', $teamids);
}
if (is_array($leagueids)) {
   $leagueids = implode(',', $leagueids);
}
if (is_array($divisionids)) {
   $divisionids = implode(',', $divisionids);
}

// if there is a league configured, get the teams within the league/division;
if ($teamids == '' && ($divisionids || $leagueids)) {
   if ($divisionids) {
      // get a listing of all team ID's that belong in the league and division;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(divisionid, '$divisionids'))";
   }
   else {
      // get a listing of all team ID's that belong in the league;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(leagueid, '$leagueids'))";
   }
   $db->setQuery($sql);
   $rows = $db->loadResultArray();
   $teamids = implode(',', $rows);
}
else if ($teamids == '') {
   // get the default team (single team component only);
   $db->setQuery("SELECT id FROM #__gridiron_team WHERE (defaultteam = 1)");
   $teamids = $db->loadResult();
}

// get the last x number of games played and the results;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   b.finalv, b.finalh
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_boxscore AS b ON a.id = b.gameid
   WHERE (a.scored = 1 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND a.gamedatetime < now())
   GROUP BY a.id
   ORDER BY a.gamedatetime DESC LIMIT 0, {$numberpast}");
$pastgames = $db->loadObjectList();

// get the next x number of games scheduled;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   t.description AS gametype
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_gametype AS t ON a.gametype = t.id
   LEFT JOIN #__gridiron_location AS l ON a.location = l.id
   WHERE (a.scored = 0 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND DATE_ADD(a.gamedatetime, INTERVAL 3 HOUR) > now())
   GROUP BY a.id
   ORDER BY a.gamedatetime ASC LIMIT 0, {$numbernext}");
$nextgames = $db->loadObjectList();
?>
<table width="100%" border="0" align="center">
   <?php if ($showpast && $numberpast > 0) { ?>
   <tr>
      <td colspan="2" style="text-align:center;"><b><?php echo $heading;?></b></td>
   </tr>
   <tr>
      <td width="43%"><b><u>Matchup</u></b></td>
      <td width="57%" style="text-align:center;"><b><u>Result</u></b></td>
   </tr>
   <?php foreach ($pastgames as $past) { ?>
   <tr>
      <td>
         <?php echo $past->visitingteam;?> vs.<br /><?php echo $past->hometeam;?>
      </td>
      <td style="text-align:center;">
      <?php if ($linkboxscore) { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=boxscore&id=$past->id");?>"><?php echo $past->finalv;?><br /><?php echo $past->finalh;?></a>
      <?php } else { ?>
      <?php echo $past->finalv;?><br /><?php echo $past->finalh;?>
        </td>
      <?php } ?>
   </tr>
   <tr>
      <td colspan="2"></td>
   </tr>
   <?php } ?>
   <?php } ?>
   <?php if ($shownextgame && $numbernext > 0 && $nextgames) { ?>
   <tr>
      <td colspan="2"><b><u>Next Game</u></b></td>
       
   </tr>
   <?php foreach ($nextgames as $next) { ?>
   <?php $next->visitingteam == '' ? $next->visitingteam = 'TBA':$next->visitingteam = $next->visitingteam;?>
   <?php $next->hometeam == '' ? $next->hometeam = 'TBA':$next->hometeam = $next->hometeam;?>
   <tr>
      <td colspan="2">
      <?php if ($linknext) { ?>
      <?php if ($next->visitingteam == 'TBA') { ?>
      <?php echo $next->visitingteam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->visitingteamid");?>"><?php echo $next->visitingteam;?></a>
      <?php } ?>
       vs.
      <?php if ($next->hometeam == 'TBA') { ?>
      <?php echo $next->hometeam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->hometeamid");?>"><?php echo $next->hometeam;?></a>
      <?php } ?>
      <?php } else { ?>
      <?php echo $next->visitingteam;?> vs. <?php echo $next->hometeam;?>   
      </td>
   </tr>
   <tr>
     <td colspan="2"><?php } ?><?php echo $next->gamedate . ' ' . $next->gametime;?> </td> 
  </tr>
   <?php } ?>     
   <?php } ?>   
</table>