Jump to content

display image from mysql with image name

hotliquer

By hotliquer
in PHP Coding Help

 Share

Recommended Posts

hotliquer Newbie

hotliquer

Posted
Posted

Hi I have image names inside of a mysql database ie "c-major.jpg"

 

I am trying to get them to show up instead of just the text for them showing but I am having difficulty.

 

The code that prints the data is as follows

{BEGIN key_image_fieldcolumn}<TD class=borderbody vAlign=middle {$key_image_style}>{$key_image_value} </TD>{END key_image_fieldcolumn}

 

{$key_image_value}

is actually the code that prints the code from the database. but when i try to envelop it with an <img> tag I get errors and it does not display the image.

 

This is what I have already tried:

<img src="http://www.gtdb.org/images/key_signatures/{$key_image_value}">

 

It would be lovely to have the actual time signatures print out in all their glory!!

 

Please help me

 

Ben

 

Link to comment
Share on other sites
hotliquer Newbie

hotliquer

Posted
  • Author
Posted

haven't ever seen php code that looks like this

 

I'm not sure what code it is then. Does anyone know what code it is so i can maybe find out how to code this?

 

It is in a template that is controlled by php

 

here is the template file

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML {$html_attrs}><HEAD><TITLE>Guitar Tunings</TITLE>
<link REL="stylesheet" href="include/style.css" type="text/css"><!--[if IE]><link REL="stylesheet" href="include/styleIE.css" type="text/css"><![endif]-->{BEGIN style_block}
<STYLE>
#height100{$id} {padding:10px;}
#mastertable_block{$id} {margin-left:50px;margin-top:10px}
#toplinks_block{$id} {width:100%; text-align:right;padding:3px}
#toplinks_block{$id} * {padding:0px 10px;}
#left_block{$id} { position:absolute;width:200px;{BEGIN RTL_block} right:10px;{END RTL_block}{BEGIN LTR_block} left:10px;{END LTR_block} overflow:visible;}
#search_records_block{$id} {width:100%;}
#search_records_block{$id} > * {vertical-align:middle;}
#search_records_block{$id} select {margin:0px 0px;}
#login_block{$id},#languages_block{$id} {padding:10px; margin-bottom:3px}
#login_block{$id} div {margin-left:0px; padding:5px 0px;}
#menu_block{$id} {margin-bottom:3px;width:auto;}
.listIcons img.listIcon{margin:0 3px;opacity:0.3;filter:alpha(opacity=30);}
#recordcontrols_block{$id} {padding:10px;}
#record_controls{$id} > *,#newrecord_controls{$id} > * {margin:2px;vertical-align:middle;}
#grid_block{$id} {margin-top:2px;}
.grid_recordheader {padding:0 5px 5px}
.grid_recordheader * {margin:0px 5px; vertical-align:middle}
form#frmAdmin{$id} {display:inline;}
body{margin:0px;padding:0px;}
#searchOptions{$id}{margin-bottom: 3px;}
#searchform{$id}{/*float: left;*/padding-left: 5px;}
#searchPanelContainer{$id}{width: 200px}

/*report styles*/
#export_links{$id} * {padding:0}

</STYLE>
{END style_block}
<META name=GENERATOR content="MSHTML 8.00.7600.16490"></HEAD>
<BODY {$bodyattrs} marginwidth="0" marginheight="0">{BEGIN body}
<DIV id="height100{$id}">{$header} 
{BEGIN toplinks_block}<DIV id="toplinks_block{$id}">{BEGIN asearch_link}<A class=tablelinks3 href="guitar_tunings_search.php" 
{$advsearchlink_attrs}>Advanced search</A> {END asearch_link}</DIV>{END toplinks_block}
{BEGIN search_records_block}<DIV id="search_records_block{$id}" class="linedownbody main_table2 toplist">
<TABLE 
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; BORDER-TOP: medium none; BORDER-RIGHT: medium none" 
width="100%">
  <TBODY>
  <TR>
    <TD width=22 noWrap><img src="include/img/arrow_topmenu.gif" align="absmiddle" alt=" "> 
    </TD>
    <TD noWrap align=left>{BEGIN searchform}<!-- Search panel header for horizontal layouts --><SPAN id="searchform{$id}" align="absmiddle"><SPAN id="searchPanelHeader{$id}">{$simpleSearchTypeCombo} {$simpleSearchFieldCombo} {BEGIN searchform_text}<INPUT size=25 {$searchfor_attrs}>{END searchform_text}   {BEGIN searchform_search}<SPAN class=buttonborder><INPUT style="BACKGROUND-IMAGE: url(images/search/search.gif); WIDTH: 18px" class=button type=button {$searchbutton_attrs}></SPAN>{END searchform_search} </SPAN>{BEGIN searchPanelTopButtons}<SPAN>    <SPAN 
      class=buttonborder><INPUT style="BACKGROUND-IMAGE: url(images/search/showOptions.gif); WIDTH: 18px" id="showOptPanel{$id}" class=button type=button {$showHideSearchPanel_attrs}></SPAN> 
      </SPAN>{END searchPanelTopButtons}</SPAN>{END searchform}         
    </TD>
    <TD noWrap align=right>{BEGIN details_block}<SPAN id="detFound{$id}">Details found: <B>{$records_found}</B>    </SPAN>{END details_block} 
      {BEGIN pages_block}<SPAN id="pageOf{$id}">Page <B>{$page}</B> of <B>{$maxpages}</B></SPAN>{END pages_block} 
           <!--{BEGIN recordspp_block}<SPAN id="recordspp_block{$id}">Records Per Page: <SELECT {$recordspp_attrs}> 
        <option value="10" {$rpp10_selected}>10</OPTION> 
        <option value="20" {$rpp20_selected}>20</OPTION> </SELECT> 
  </SPAN>{END recordspp_block}--></TD></TR></TBODY></TABLE></DIV>{END search_records_block}
{BEGIN left_block}<DIV id="left_block{$id}"><!-- search panel and window -->
<DIV id="searchPanelContainer{$id}" class=searchPanelContainer>{$adv_search_panel} </DIV><!-- MenuBegin --><!-- MenuEnd --></DIV>{END left_block}
<DIV id="records_block{$id}" {$marginStyle} moveForSearch="move{$id}">
{BEGIN recordcontrols_block}<DIV id="recordcontrols_block{$id}" class=main_table2>{BEGIN record_controls}<SPAN id="record_controls{$id}"></SPAN>{END record_controls}</DIV>{END recordcontrols_block}
<DIV id="usermessage{$id}" class=message>{$user_message}</DIV>
{BEGIN grid_block}<DIV id="grid_block{$id}">
<TABLE class=data border=0 cellSpacing=0 cellPadding=5 name="maintable">
  {BEGIN grid_header}<THEAD>
  <TR class=blackshade vAlign=top {$gridHeader_attrs}>{BEGIN record_header}
    {BEGIN listIcons_column}<TH class="headerlist listIcons" noWrap align=middle {$widthListIcons}><?php 
    	$gtdb_artist = ("{BEGIN artist_fieldcolumn}{$artist_value}{END artist_fieldcolumn}"); 
        print ("$gtdb_artist");
    ?>
    
    </TH>{END listIcons_column}
    {BEGIN id_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN id_fieldheader}<A 
      class=tablelinks {$id_orderlinkattrs}>Id</A> {END id_fieldheader}</TH>{END id_fieldheadercolumn}
    {BEGIN artist_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN artist_fieldheader}<A 
      class=tablelinks {$artist_orderlinkattrs}>Artist</A> {END artist_fieldheader}</TH>{END artist_fieldheadercolumn}
    {BEGIN album_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN album_fieldheader}<A 
      class=tablelinks {$album_orderlinkattrs}>Album</A> {END album_fieldheader}</TH>{END album_fieldheadercolumn}
    {BEGIN song_title_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN song_title_fieldheader}<A class=tablelinks 
      {$song_title_orderlinkattrs}>Title</A> {END song_title_fieldheader}</TH>{END song_title_fieldheadercolumn}
    {BEGIN tuning_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN tuning_fieldheader}<A 
      class=tablelinks {$tuning_orderlinkattrs}>Tuning</A> {END tuning_fieldheader}</TH>{END tuning_fieldheadercolumn}
    {BEGIN key_image_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN key_image_fieldheader}<A 
      class=tablelinks {$key_image_orderlinkattrs}>Signature</A> {END key_image_fieldheader}</TH>{END key_image_fieldheadercolumn}
    {BEGIN key_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN key_fieldheader}<A 
      class=tablelinks {$key_orderlinkattrs}>Key</A> {END key_fieldheader}</TH>{END key_fieldheadercolumn}
    {BEGIN relative_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN relative_fieldheader}<A 
      class=tablelinks {$relative_orderlinkattrs}>Relative</A> {END relative_fieldheader}</TH>{END relative_fieldheadercolumn}
    {BEGIN camelot_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN camelot_fieldheader}<A 
      class=tablelinks {$camelot_orderlinkattrs}>Camelot</A> {END camelot_fieldheader}</TH>{END camelot_fieldheadercolumn}
    {BEGIN timing_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN timing_fieldheader}<A 
      class=tablelinks {$timing_orderlinkattrs}>Timing</A> {END timing_fieldheader}</TH>{END timing_fieldheadercolumn}
    {BEGIN tempo_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN tempo_fieldheader}<A 
      class=tablelinks {$tempo_orderlinkattrs}>Tempo</A> {END tempo_fieldheader}</TH>{END tempo_fieldheadercolumn}
    {BEGIN tab_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN tab_fieldheader}<A 
      class=tablelinks {$tab_orderlinkattrs}>Tab</A> {END tab_fieldheader}</TH>{END tab_fieldheadercolumn}
    {BEGIN tab2_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN tab2_fieldheader}<A 
      class=tablelinks {$tab2_orderlinkattrs}>Tab2</A> {END tab2_fieldheader}</TH>{END tab2_fieldheadercolumn}
    {BEGIN capo_fieldheadercolumn}<TH style="VERTICAL-ALIGN: baseline" class=headerlist align=middle>{BEGIN capo_fieldheader}<A 
      class=tablelinks {$capo_orderlinkattrs}>Capo</A> {END capo_fieldheader}</TH>{END capo_fieldheadercolumn}
    {BEGIN endrecordheader_block}<TH class=body2></TH>{END endrecordheader_block}{END record_header}</TR></THEAD>{END grid_header}
  <TBODY>{BEGIN grid_row}
  <TR vAlign=top {$rowattrs} {$rowstyle}>{BEGIN grid_record}
    {BEGIN listIcons_column}<TD class="borderbody listIcons" vAlign=middle noWrap align=middle>{BEGIN view_column}{BEGIN view_link}<A 
      class=tablelinks title=View {$viewlink_attrs}><IMG class=listIcon border=0 
      alt=View align=middle src="images/icon_view_new.gif"></A> {END view_link}{END view_column}</TD>{END listIcons_column}
    {BEGIN id_fieldcolumn}<TD class=borderbody vAlign=middle {$id_style}>{$id_value} </TD>{END id_fieldcolumn}
    {BEGIN artist_fieldcolumn}<TD class=borderbody vAlign=middle {$artist_style}><a href="http://gtdb.org/guitar_tunings_list.php?ctlSearchFor=($artist_value)&simpleSrchTypeComboNot=&a=integrated&id=1&criteria=and">{$artist_value}</a> </TD>{END artist_fieldcolumn}
    {BEGIN album_fieldcolumn}<TD class=borderbody vAlign=middle {$album_style}>{$album_value} 
    </TD>{END album_fieldcolumn}
    {BEGIN song_title_fieldcolumn}<TD class=borderbody vAlign=middle {$song_title_style}>{$song_title_value} </TD>{END song_title_fieldcolumn}
    {BEGIN tuning_fieldcolumn}<TD class=borderbody vAlign=middle {$tuning_style}>{$tuning_value} </TD>{END tuning_fieldcolumn}
    {BEGIN key_image_fieldcolumn}<TD class=borderbody vAlign=middle {$key_image_style}>{$key_image_value} </TD>{END key_image_fieldcolumn}
    {BEGIN key_fieldcolumn}<TD class=borderbody vAlign=middle {$key_style}>{$key_value} </TD>{END key_fieldcolumn}
    {BEGIN relative_fieldcolumn}<TD class=borderbody vAlign=middle {$relative_style}>{$relative_value} </TD>{END relative_fieldcolumn}
    {BEGIN camelot_fieldcolumn}<TD class=borderbody vAlign=middle {$camelot_style}>{$camelot_value} </TD>{END camelot_fieldcolumn}
    {BEGIN timing_fieldcolumn}<TD class=borderbody vAlign=middle {$timing_style}>{$timing_value} </TD>{END timing_fieldcolumn}
    {BEGIN tempo_fieldcolumn}<TD class=borderbody vAlign=middle {$tempo_style}>{$tempo_value} 
    </TD>{END tempo_fieldcolumn}
    {BEGIN tab_fieldcolumn}<TD class=borderbody vAlign=middle {$tab_style}>{$tab_value} </TD>{END tab_fieldcolumn}
    {BEGIN tab2_fieldcolumn}<TD class=borderbody vAlign=middle {$tab2_style}>{$tab2_value} 
    </TD>{END tab2_fieldcolumn}
    {BEGIN capo_fieldcolumn}<TD class=borderbody vAlign=middle {$capo_style}>{$capo_value} 
    </TD>{END capo_fieldcolumn}
    {BEGIN endrecord_block}<TD class=body2 {$endrecordblock_attrs}></TD>{END endrecord_block}{END grid_record}</TR>{END grid_row}</TBODY></TABLE></DIV>{END grid_block}
{BEGIN pagination_block}<DIV id="pagination_block{$id}" class=toplist align=center>{$pagination}</DIV>{END pagination_block}
{BEGIN message_block}<DIV class=toplist align=center valign="middle"><B>{$message}</B></DIV>{END message_block}</DIV>{$footer} 
</DIV>{END body}</BODY></HTML>

 

And here is the php file

<?php
@ini_set("display_errors","1");
@ini_set("display_startup_errors","1");

include("include/dbcommon.php");

header("Expires: Thu, 01 Jan 1970 00:00:01 GMT");
header("Pragma: no-cache");
header("Cache-Control: no-cache");

include('include/xtempl.php');
include("include/guitar_tunings_variables.php");
include('classes/runnerpage.php');
include('classes/listpage.php');
include("classes/searchpanel.php");
include("classes/searchcontrol.php");
include("classes/searchclause.php");
include("classes/panelsearchcontrol.php");	//	Include necessary files in accordance with mode displaying page
if (postvalue("mode")=="")
{
$mode = LIST_SIMPLE;
include('classes/listpage_simple.php');
include("classes/searchpanelsimple.php");	
}
elseif(postvalue("mode") == "ajax")
{
$mode = LIST_AJAX;
include('classes/listpage_simple.php');
include('classes/listpage_ajax.php');
include("classes/searchpanelsimple.php");	
}
elseif(postvalue("mode") == "lookup")
{	
include('classes/listpage_embed.php');
include('classes/listpage_lookup.php');
include("classes/searchpanellookup.php");	
$mode=LIST_LOOKUP;
//determine which field should be used to select values
		$params["lookupSelectField"] = "id";
												}
elseif(postvalue("mode")=="listdetails")
{
include('classes/listpage_embed.php');
include('classes/listpage_dpinline.php');
$mode=LIST_DETAILS;
}
$xt = new Xtempl();

// Modify query: remove blob fields from fieldlist.
// Blob fields on a list page are shown using imager.php (for example).
// They don't need to be selected from DB in list.php itself.
$gQuery->ReplaceFieldsWithDummies(GetBinaryFieldsIndices());

$options = array();
//array of params for classes
$options["pageType"] = PAGE_LIST;
$options["id"] = postvalue("id") ? postvalue("id") : 1;
$options["mode"] = $mode;
$options['xt'] = &$xt;
$options['masterPageType'] = postvalue("masterpagetype");
$options["masterTable"] = postvalue("mastertable");
$options["masterId"] = postvalue("masterid");
$options["firstTime"] = postvalue("firsttime");

$i = 1;
while(isset($_REQUEST["masterkey".$i])) 
{	
$options["masterKeysReq"][$i] = $_REQUEST["masterkey".$i];
$i++;
}
$pageObject = ListPage::createListPage($strTableName, $options);


// prepare code for build page
$pageObject->prepareForBuildPage();

$includesArr = array();

//include files if need
for($i=0;$i<count($includesArr);$i++)
include($includesArr[$i]);

// show page depends of mode
$pageObject->showPage();

?>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.