CMS Made Simple Forums

//User Defined Tag: Factbookdata

mysql_close($connectiondata);

$carrierchoice = urldecode($_GET['carrierchoice']);
// This makes a connection to the file containing the logon data//
require ('connection.php');

$connectiondata = mysql_connect($host,$user,$password, true)
or die ("couldn't connect to server");

$db = mysql_select_db($database,$connectiondata)
or die ("Couldn't select database");

// Combine carriers and country names  and select desired carrier//
$query =
"SELECT * FROM tbl_carrier, tbl_country
WHERE carr_country_iso3=coun_iso3
and carr_name ='".$carrierchoice."';";

$result = mysql_query($query)
or die (mysql_error());

// Display results //
	while ($row = mysql_fetch_array($result))
	{
		extract($row);
		echo "			

			<table>		
			.....
			.....
			.....
			</table>		
					
			";		
	}				
					
	mysql_close($connectiondata);				

• Getting back to the User Defined Tag?
• Somehow entering an initial value for carrierchoice
• Some other thing?

Arthur wrote:

Code: Select all

//User Defined Tag: Factbookdata

mysql_close($connectiondata);

$carrierchoice = urldecode($_GET['carrierchoice']);
// This makes a connection to the file containing the logon data//
require ('connection.php');

$connectiondata = mysql_connect($host,$user,$password, true)
or die ("couldn't connect to server");

$db = mysql_select_db($database,$connectiondata)
or die ("Couldn't select database");

// Combine carriers and country names  and select desired carrier//
$query =
"SELECT * FROM tbl_carrier, tbl_country
WHERE carr_country_iso3=coun_iso3
and carr_name ='".$carrierchoice."';";

$result = mysql_query($query)
or die (mysql_error());

// Display results //
	while ($row = mysql_fetch_array($result))
	{
		extract($row);
		echo "			

			<table>		
			.....
			.....
			.....
			</table>		
					
			";		
	}				
					
	mysql_close($connectiondata);				

To show the data I entered the User Defined Tag in the content of the desired page.

The problem is that up till now I didn't manage to lay-out the table shown (discussed in my post http://forum.cmsmadesimple.org/index.php/topic,14935.msg73986.html#msg73986). Somehow the tag editor doesn't allow me to enter anything that is related to style sheets or even HTML lay-out things like BGCOLOR.

Now I thought it would be a good idea to move the content of the User Defined Tag to the page itself.
This seems to have solved the problem of styling the table. However...

A new problem is introduced:
After opening the page, the content area that is supposed to show the table, initially shows


After entering $carrierchoice = urldecode($_GET['carrierchoice']); by clicking on one of the options in the left column of the page (in here the links look like
http://website.com/index.php?page=fact- ... e=CompanyA) the required data is shown.

My analysis is that since there is initially no carrierchoice entered the query doesn't know what data should be shown and makes an error.

How should this be solved?

• Getting back to the User Defined Tag?
• Somehow entering an initial value for carrierchoice
• Some other thing?

//User Defined Tag: Factbookdata

mysql_close($connectiondata);

// This makes a connection to the file containing the logon data//
require ('connection.php');

$connectiondata = mysql_connect($host,$user,$password, true)
or die ("couldn't connect to server");

$db = mysql_select_db($database,$connectiondata)
or die ("Couldn't select database");


if(isset($_GET['carrierchoice']))
{
  $carrierchoice = urldecode($_GET['carrierchoice']);

  // Combine carriers and country names  and select desired carrier//
  $query = "SELECT * FROM tbl_carrier, tbl_country
  WHERE carr_country_iso3=coun_iso3
  and carr_name ='".$carrierchoice."'";

  $result = mysql_query($query) or die (mysql_error());

  // Display results //
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "


.....
.....
.....


";
}
}
else
{
  $query = "SELECT carr_name FROM tbl_carrier, tbl_country
  WHERE carr_country_iso3=coun_iso3";

  $result = mysql_query($query) or die (mysql_error());

  // Display results //
while ($row = mysql_fetch_array($result))
{
echo ''.$row['carr_name'].'';
}
}

mysql_close($connectiondata);

Some other thing?
Use params for UDT for style your output:
{myudt tdbgcolor="#fff" tdcell="#f00"}

In myudt use them with $params['tdbgcolor'] and $params['tdcell']

Look this for other info

Use params for UDT for style your output:
{myudt tdbgcolor="#fff" tdcell="#f00"}

myudt

How to Execute Smarty Tags from A User Defined Tag (UDT)

Arthur wrote: Further the link you gave, leads to code under

How to Execute Smarty Tags from A User Defined Tag (UDT)

that looks like Russian to me.

So, please give me some very basic examples including the places to put the code and I'll expand it with the lay out I want.

Arthur wrote: In your answer

Some other thing?
Use params for UDT for style your output:
{myudt tdbgcolor="#fff" tdcell="#f00"}

In myudt use them with $params['tdbgcolor'] and $params['tdcell']

Look this for other info

I understand that I can apply CCS.
Could you please give me some example on how to use this. I've got some books inhere to expand basic solutions but I need the basic idea.

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "


field 1
field 2


";
}

Arthur wrote: For instance:

Use params for UDT for style your output:
{myudt tdbgcolor="#fff" tdcell="#f00"}

Is this code to be put inside my UDT, the Template of a Stylesheet applied in the Template?

Arthur wrote: What do you mean by

myudt

in relation to UDT, do you mean the UDT as I use in here?

Arthur wrote: Thanks for your reply. I dropped the idea of the query inside the content page. There appeared more things that were wrong in this solution. I'll concentrate on laying out the UDT.

if(isset($_GET['carrierchoice']))
{
VARIABLE PRESENT, DO ...
}
else
{
VARIABLE NOT PRESENT, DO OTHER ...
}

Arthur wrote: Hi Alby,

//User Defined Tag: Factbookdata
global $gCms;
$db =& $gCms->GetDb();
$config =& $gCms->GetConfig();


if(isset($_GET['carrierchoice']))
{

//There is a carrierchoice!
$carrierchoice = urldecode($_GET['carrierchoice']);

$query = "SELECT * FROM tbl_carrier, tbl_country
WHERE carr_country_iso3=coun_iso3
and carr_name = ?";
$dbresult = $db->Execute( $query, array($carrierchoice) );

//Open table and first line with 3 header
//Substitute with your header and add other header (column)
echo "


HEADER 1
HEADER 2
HEADER 3

";

while($dbresult && $row = $dbresult->FetchRow())
{
//Substitute with your sql field (from query) and add other field (column)
echo "

".$row['field1']".
".$row['field2']".
".$row['field3']".

";
}

//Close table
echo "

";
return;

}
else
{

//No carrierchoice!
//Query without carrierchoice (first page)
$query = "SELECT carr_name FROM tbl_carrier, tbl_country
WHERE carr_country_iso3=coun_iso3";
$dbresult = $db->Execute( $query );

$url = $config['root_url'].'/index.php?'.$config["query_var"].'='.$gCms->variables['content_id'].'&carrierchoice=';

//List of carrierchoice
while($dbresult && $row = $dbresult->FetchRow())
{
echo ''.$row['carr_name'].'';
}
return;

}

Arthur wrote: Hi Alby,

One more reply:
The problem is solved!