advice needed....

[irishgirl2004]

hi,
i have the following php file..

<?

include "subs.inc";
include "DB_subs.inc";
include "passwd.php3";

$host = "localhost";
$db = "acctest";

parse_str will assign the incoming variable POSTed to this scrpt

parse_str($user_name);

Print_header ();

$referrer = getenv(HTTP_REFERER);

idea here is to print the detailed screen for the stock,

username, password, stock id will be posted to this script

verify password

$status = DB_Open($db,$host, $user, $DBpasswd, $conn);

if ($status) {
$error = $error . $status;
}

?>
<a href="index.php">Company Details</a><br>
<a href="index.php">Structure</a><br>
<a href="index.php">Sums Insured</a><br>
<a href="index.php">Cover Required</a><br>
<a href="index.php">Summary Report</a><br>
<a href="index.php">Docs</a><br>
<?
Print_footer ();
?>

this works fine.....

what i now need is, when a user clicks on a link, i want to reload this page, but with text in the middle of the page, this text will be selected from a mysql database, can anybody show me how to do this?

many thanks .....

[dfr574]

This will do it. But I'm sure someone else can give you a better answer.

<? 

include "subs.inc"; 
include "DB_subs.inc"; 
include "passwd.php3"; 

$link = $_GET[link];

$host = "localhost"; 
$db = "acctest"; 

# parse_str will assign the incoming variable POSTed to this scrpt 
parse_str($user_name); 

Print_header (); 

$referrer = getenv(HTTP_REFERER); 
# idea here is to print the detailed screen for the stock, 
# username, password, stock id will be posted to this script 

# verify password 
$status = DB_Open($db,$host, $user, $DBpasswd, $conn); 

if ($status) { 
$error = $error . $status; 
} 

if(!$link){
echo "<a href=\"index.php/?link=Company_Details\">Company Details</a><br>\n";
echo "<a href=\"index.php?link=Structure\">Structure</a><br> \n";
echo "<a href=\"index.php?link=Sums_Insured\">Sums Insured</a><br> \n";
echo "<a href=\"index.php?link=Cover_Required\">Cover Required</a><br> \n";
echo "<a href=\"index.php?link=Summary\">Summary Report</a><br> \n";
echo "<a href=\"index.php?link=Docs\">Docs</a><br> \n";
}

if($link == "Company_Details")}
	$query = "SOME QUERY";
	mysql_query($query);
		blah blah
	echo "the result\n";
}
if($link == "Structure")}
	$query = "SOME QUERY";
	mysql_query($query);
		blah blah
	echo "the result\n";
}
//so on and so on...
Print_footer (); 
?>

[dotbob]

Ok, dfr574 was almost there.

It's hard to accurately answer this question as I don't know the db schema used. However, assuming that you had this similar layout:

field type

id int
scn tinyint
text longtext

then you could do something like:

<? 

include "subs.inc"; 
include "DB_subs.inc"; 
include "passwd.php3"; 

$host = "localhost"; 
$db = "acctest"; 

# parse_str will assign the incoming variable POSTed to this scrpt 
parse_str($user_name); 

Print_header (); 

$referrer = getenv(HTTP_REFERER); 
# idea here is to print the detailed screen for the stock, 
# username, password, stock id will be posted to this script 

# verify password 
$status = DB_Open($db,$host, $user, $DBpasswd, $conn); 

//check that the scn var holds data
if($scn)
{
//if so, query the db
$result = mysql_query("SELECT text FROM tblname WHERE scn = $scn");
//if a valid recordset was returned
if(mysql_num_rows($result) > 0)
{
//echo the text out to the page
echo mysql_result($result,0,0);
}
}
if ($status) { 
$error = $error . $status; 
} 

?> 
<a href="index.php?scn=1">Company Details</a><br> 
<a href="index.php?scn=2">Structure</a><br> 
<a href="index.php?scn=3">Sums Insured</a><br> 
<a href="index.php?scn=4">Cover Required</a><br> 
<a href="index.php?scn=5">Summary Report</a><br> 
<a href="index.php?scn=6">Docs</a><br> 
<? 
Print_footer (); 
?> 

[irishgirl2004]

hi...
thanks for your help.....is there an easy way, to display text in the middle of the page for each link the user clicks on?

many thanks

[dotbob]

do you mean an easier way but still using the database to store the text?

[irishgirl2004]

hi.....
thats for your reply...... i dont mind if i store the text in the dbase or in the file, what ever is easiest and quickest i guess!!!!! can u help?
i've been trying to find good examples on the web, but sadly to of no avail...........

thanks

[The_Chancer]

I would recommend the database way.

One row per page with the id (what you will search the database for) and the text

Click the link as dotbob suggested, and the bit after the ? ie

<a href="".$_SERVER['PHP_SELF']."?scrn=1">Link 1</a>

will make the query like so..

$query=mysql_query("SELECT text FROM `table` WHERE page='".$_GET['scrn']."' LIMIT 1");
list($text)=mysql_fetch_row($query);
echo $text;

which will echo it all out...

But that depends on your database schema as dotbob said...