Display Text Record or a Custom Page

**aubreymartin** · Oct 24, 2000, 04:00

I have put a business and shop listing (single table) together for a town which displays a simple text record for each entry. However some shops would like their own custom page which will be displayed in place of the plain text record. I have added a new field to the table called ownpage which has the path and filename of the custom page. What I want to happen is if there is a path and filename in the ownpage field then go there otherwise display the normal default text record.
The site is http://www.e-navan.com
Thank you for any direction or if you would like to see the code in question please let me know.

**akazukin** · Oct 24, 2000, 04:11

Dear aubreymartin...

I don't really understand your question, but, if this is what you want...

This code is used to display companyname.custompage.txt if it exist, if not, use plain text record.

<?php
if (file_exists($cname . ".custompage.txt")){
require ($cname . ".custompage.txt");
}
elseif (file_exist($cname . ".defaultpage.txt")){
require ($cname . ".defaultpage.txt");
}
else{
require ("companydoesnotexist.html");
}
?>

Run this script by

filename.php?cname=companyname

You may make changes to the filenames if nessessary.

**aubreymartin** · Oct 24, 2000, 04:45

Thanks for a very very prompt reply and I'm really sorry to have to give you this much code to look at. Its not the most slick code ever written but ir runs well.
I put double lines in the area where I want the custom page to happen (about 12 lines from the top.
Again Many Thanks

<html>
<head>
</head>
<body text="#FF9900" bgcolor="#000000" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<?php
mysql_connect("server.com",jonness,121212);
mysql_select_db(BLACK);
$table="navan";

IF ($id) {

===============================================
In here I think something like:
IF $ownpage!=" " {
GOTO OWNPAGE AND DISPLAY }(don't know the command for here)
ENDIF
===============================================

//Print page title
//printf("E-NAVAN RECORD DETAIL ");
$result=mysql_query("SELECT * FROM $table WHERE id=$id");
$myrow=mysql_fetch_array($result);

//converting the fields to variables
$Names=($myrow["Names"]);
$contact=($myrow["contact"]);
$add1=($myrow["add1"]);
$add2=($myrow["add2"]);
$add3=($myrow["add3"]);
$tel=($myrow["tel"]);
$fax=($myrow["fax"]);
$mobile=($myrow["mobile"]);
$email=($myrow["email"]);
$web=($myrow["web"]);
$ownpage=($myrow["ownpage"]};
IF ($email == "")
{

$email = "None Listed";
}
else
{
$email = "<a href=\"mailto:$email\">$email</a>\n";
}

if ($web == "")
{
$web = "None Listed";
}
else
{
$web = "<a href=\"http://$web\">$web</a>";
}

print "_____________________________________";
printf("%s\n ",$myrow["Names"]);
print "____________________________________________________";

echo "<center><table width=\"400\" border=\"0\" cellpadding=\"2\" cellspacing=\"2\">\n";

//echo "<tr><th ALIGN=CENTER COLSPAN=\"2\">- $Names -</th></tr>\n";

//echo "<tr colspan=\"2\"><td width=\"400\">$Names </td></tr>\n";
//echo "<tr><td width=\"115\">Name

/td><td width=\"250\">$Names</td></tr>\n";
echo "<tr><td width=\"115\">Contact

/td><td width=\"250\">$contact</td></tr>\n";
echo "<tr><td width=\"115\">Address

/td><td width=\"250\">$add1</td></tr>\n";
echo "<tr><td width=\"115\"> </td><td width=\"250\">$add2</td></tr>\n";
echo "<tr><td width=\"115\">Phone

/td><td width=\"250\">$tel</td></tr>\n";
echo "<tr><td width=\"115\">Fax

/td><td width=\"250\">$fax</td></tr>\n";
echo "<tr><td width=\"115\">Mobile

/td><td width=\"250\">$mobile</td></tr>\n";
echo "<tr><td width=\"115\">Email: </td><td width=\"250\">$email</td></tr> \n";
echo "<tr><td width=\"115\">Website: </td><td width=\"250\">$web</td></tr></table></center>\n";

} else {

printf("E-NAVAN LISTING FOR $title ");
$result=mysql_query("SELECT * FROM enavan WHERE cats LIKE '%$cat%' ORDER BY Names");
IF ($myrow=mysql_fetch_array($result)) {
do {

printf("<a href=\"%s?id=%s\">%s</a> \n",$PHP_SELF,$myrow[id],$myrow["Names"]);
} while ($myrow=mysql_fetch_array($result));
} else {

echo "Sorry, No Matching Records Here";
}
}

?>
</body>
</html>

Run this script by

filename.php?cname=companyname

You may make changes to the filenames if nessessary. [/B][/QUOTE]

**akazukin** · Oct 24, 2000, 04:52

Dear aubreymartin...

You can save the custom pages into plain text files, and use require statements to get the file

require ("asdf.txt");
require ("path/to/asdf.txt");
require ("/home/abolute/path/to/asdf.txt");

**aubreymartin** · Oct 24, 2000, 05:08

Thank you once again and sorry to keep coming back to you,
Will the REQUIRE Function work for html files too as these are the format of the custom pages?
path e.g. ownpages\lorenzen.html

Originally posted by akazukin
Dear aubreymartin...

You can save the custom pages into plain text files, and use require statements to get the file

require ("asdf.txt");
require ("path/to/asdf.txt");
require ("/home/abolute/path/to/asdf.txt");

**akazukin** · Oct 24, 2000, 05:12

Dear aubreymartin...

You're always welcome to ask me questions. I'm often here ^^.

Yes, it works for all ASCII text files (including HTML and PHP executable scripts)

The SitePoint Forums have moved.

User Tag List

Thread: Display Text Record or a Custom Page

Thread Tools

Display

Hybrid View

Bookmarks

Bookmarks

Posting Permissions