help: include file with variable inside div tag

I have a simple message board I created a while back.

Recently they've asked me to add threading support for messages.

so I created a seperate thread page, which gives me each threaded message after querying the database.

Then, on the main page, what I want it to do is display the original message,
then display the threads under it, after you click on the "show threads" link im trying to put somwhere around the original thread. Then display the next message, with threads under it (of course after the thread button is clicked). I don't want the page to refresh if possible and dont mind if i need to pull all the data first, then format it after, then display the page.

I'll paste pertinent code below, if im missing anything, i'm glad to throw any code requested:

main page

Expand|Select|Wrap|Line Numbers

 <head>
 
<style type="text/css">

div {

color: white;

display: none;

}

</style>
 
<script language="JavaScript">

function setVisibility(id, visibility) {

document.getElementById(id).style.display = visibility;

}

</script>
 
</head>

 /* more page data */
 
// database query to show messages withought the thread

$result=mssql_query("SELECT * FROM Message_Board WHERE $searchby LIKE '%$search2%' 

AND thread_number=0

ORDER BY TStamp DESC");
 
// loop to display message without thread

$i=0;

while ($i < $num) {
 
$First_Name=mssql_result($result,$i,"First_Name");

$Category=mssql_result($result,$i,"Category");

$TStamp=mssql_result($result,$i,"TStamp");

$msg=nl2br(mssql_result($result,$i,"msg"));

$id=mssql_result($result,$i,"id");

$thread_number=mssql_result($result,$i,"thread_number");

$thread_id=mssql_result($result,$i,"thread_id");
 
?>
 
<? echo $msg; ?>

<br>

<input type=button name=type value='Show Layer' onclick="setVisibility('sub3', 'inline');";><input type=button name=type value='Hide Layer' onclick="setVisibility('sub3', 'none');";> 
 
<div id="sub3"><? include('threadtest.php?thread_id=$thread_id'); ?></div>

<?
 
$i++;
 
}
 
mssql_close();

?>

here's pertinent code for 'threadtest.php:

Expand|Select|Wrap|Line Numbers

 
<? $thread_id=$_GET['thread_id']; ?>
 
// database query

$result=mssql_query("SELECT * FROM Message_Board 

WHERE $searchby LIKE '%$search2%' 

AND thread_id=$thread_id

AND thread_number != 0

ORDER BY TStamp ASC");
 
// loop to display threaded messages for the message with "thread_id"

<?

$i=0;

while ($i < $num) {
 
$First_Name=mssql_result($result,$i,"First_Name");

$Category=mssql_result($result,$i,"Category");

$TStamp=mssql_result($result,$i,"TStamp");

$msg=nl2br(mssql_result($result,$i,"msg"));

$id=mssql_result($result,$i,"id");

$thread_number=mssql_result($result,$i,"thread_number");

$thread_id=mssql_result($result,$i,"thread_id");
 
?>
 
<tr>

<td>

<hr width=50%>

<? echo $msg; ?><br><font size=1><tt><? echo $First_Name; ?> at <? echo $TStamp; ?></tt></font> 

</td>

</tr>
 
<?
 
$i++;
 
}
 
mssql_close();

I put the code for the loops in so you see what I'm trying to do.
If the message has a thread number of 0, its the original message, any message with higher values would be threads for that particular message. in which I don't want to be displayed unless clicked on. And just an fyi, the thread_id is the same on the original message and any threaded messages off that particular original message.

i also know from reading forums all day that i can't put variables in an include statement

Expand|Select|Wrap|Line Numbers

include('threadtest.php?thread_id=$thread_id');

, but i wanted to show what i am looking to return, and the fact that the threadtest.php page needs the thread_id (which would be different for each original message) and then hits the database again with it (should I be hitting the database twice like that?).

I left out a lot of code i figured would be useless for this question. Plz assume the database connects correctly and im getting the results from the database that i want.

When i browse to www.website.com/threadtest.php?thread_id=2345 ,for example,
it displays exactly what i want to include on the main page. i only want it to display tho when the user clicks.

I believe i would be able to code it with the page refreshing, but i'm sure there must be a way to do what i'm trying to.

My other problem (non php related?) is in the list of original messages, it doesnt matter which "click to view thread" button i hit, it always displays in the first message only ....i.e., i click on the "view thread" button for message number 3, but the drop down appears in message number 1.

any help appreciated =) thx

Oct 2 '08 #1

Subscribe Post Reply

3342

Dormilich

8,658

Expert Mod 8TB

If you don't want to use refresh you can use ajax for that, another advantage of this is, that you can call a script with parameters.

regards ← has to break-fast now

Oct 2 '08 #2

Markus

6,050

Expert 4TB

Put the thread id in a constant, before you include the file. Then you can access the constant in the included file. Simple.

Cheers,
Markus has an inkling he may be of no help because he has just woke up. :D

Oct 2 '08 #3

wizdom

Put the thread id in a constant, before you include the file. Then you can access the constant in the included file. Simple.

Cheers,
Markus has an inkling he may be of no help because he has just woke up. :D

Thanks for the response, I go back on sunday so I will give it a shot.

Here's what I'm thinking I'm going to try then...

from lines 34 - 43 on the main page code, looks like I already set the thread_id, so just removing the variable in the include statement may work =)
likt this:

Expand|Select|Wrap|Line Numbers

 
$thread_id=mssql_result($result,$i,"thread_id"); 
 
?> 
 
<? echo $msg; ?> 

<br> 

<input type=button name=type value='Show Layer' onclick="setVisibility('sub3', 'inline');";><input type=button name=type value='Hide Layer' onclick="setVisibility('sub3', 'none');";>  
 
<div id="sub3"><? include('threadtest.php'); ?></div> 

<?

and then from threadtest.php remove:

Expand|Select|Wrap|Line Numbers

<? $thread_id=$_GET['thread_id']; ?>

=======================================

If you don't want to use refresh you can use ajax for that, another advantage of this is, that you can call a script with parameters.

regards ← has to break-fast now

Thanks Dorm, I will check on ajax for the non refresh

Oct 2 '08 #4

Markus

6,050

Expert 4TB

Yep, I gave it a quick glance and looks fantabbydoosy!

See you 'round

Oct 2 '08 #5

wizdom

thanks guys for all the help,

i needed to make a couple changes to make it work, but all basically based on the above changes.

i had to change the variables in the second loop (in threadtest.php) because i think the loop variables in threadtest were switching the loop variables in the main page.....particularly "$i" , "$result", and "$num".

looks like i also had a "mssql_close();" at the end of threadtest.php which may have been stopping the loop from the main page, removed it along with a "session_start();", and an extra database connect string i had in threadtest.php.

I also fixed the problem where the thread was only displaying on the first message, i used the value of $id to add to the id name in the div tag, worked perfectly for each message, and it doesn't reload the page, and I didn't have to use ajax, altho i want to learn more about ajax for future reference, once the fixes were in, the page actually workd =)

Here's the changed code for anyone interested, once again really appreciate the help and i hope i can help someone else out at some point =)

Main Page:

Expand|Select|Wrap|Line Numbers

 
<head> 
 
<style type="text/css"> 

div { 

color: white; 

display: none; 

} 

</style> 
 
<script language="JavaScript"> 

function setVisibility(id, visibility) { 

document.getElementById(id).style.display = visibility; 

} 

</script> 
 
</head> 

 /* more page data */ 
 
// database query to show messages withought the thread 

$result=mssql_query("SELECT * FROM Message_Board WHERE $searchby LIKE '%$search2%'  

AND thread_number=0 

ORDER BY TStamp DESC"); 
 
// loop to display message without thread 

$i=0; 

while ($i < $num) { 
 
$First_Name=mssql_result($result,$i,"First_Name"); 

$Category=mssql_result($result,$i,"Category"); 

$TStamp=mssql_result($result,$i,"TStamp"); 

$msg=nl2br(mssql_result($result,$i,"msg")); 

$id=mssql_result($result,$i,"id"); 

$thread_number=mssql_result($result,$i,"thread_number"); 

$thread_id=mssql_result($result,$i,"thread_id"); 
 
?> 
 
<? echo $msg; ?> 

<br> 

<input type=button name=type value='Show Layer' onclick="setVisibility('sub<? echo $id; ?>', 'inline');";><input type=button name=type value='Hide Layer' onclick="setVisibility('sub<? echo $id; ?>', 'none');";>  
 
<div id="sub<? echo $id; ?>"><? include('threadtest.php'); ?></div> 

<? 
 
$i++; 
 
} 
 
mssql_close(); 

?>

threadtest.php:

Expand|Select|Wrap|Line Numbers

 
// database query 
 
// renamed loop variables so as not to get confused with index.php
 
$result2=mssql_query("SELECT * FROM Message_Board 

WHERE thread_id=$thread_id

AND thread_number != 0

ORDER BY TStamp ASC");
 
// loop to display threaded messages for the message with "thread_id" 

$num2=mssql_num_rows($result2);
 
$i2=0;

while ($i2 < $num2) {
 
// removed unnecessary variables
 
$First_Name=mssql_result($result2,$i2,"First_Name");

// $Category=mssql_result($result,$i,"Category");

$TStamp=mssql_result($result2,$i2,"TStamp");

$msg=nl2br(mssql_result($result2,$i2,"msg"));

// $id=mssql_result($result,$i,"id");

// $thread_number=mssql_result($result,$i,"thread_number");

// $thread_id=mssql_result($result,$i,"thread_id");
 
?>
 
    <hr width=50%>

        <? echo $msg; ?><br><font size=1><tt><? echo $First_Name; ?> at <? echo $TStamp; ?></tt></font> 
 
<?
 
$i2++;
 
}
 
?>
 
// removed line - shouldn't close database yet

// mssql_close();

Oct 5 '08 #6

by: michaaal | last post by:

I have two folders in my website... Folder1 (this is where my #include file is, this is where the style.css is) --Folder2 (Folder2 is inside...

HTML / CSS

extern char and include practices

by: atv | last post by:

Alright, i have some questions concerning include files en global variables.I hope someone is willing to answer these. 1).Why is it that if i...

C / C++

pointer is std:map - broke in port from VS6 to .NET - A little Help?

by: Dan Trowbridge | last post by:

Hi everyone, In my attempt to port code from VS 6.0 to VS.NET I had some code break along the way, mostly due to not adhereing closely to the C++...

.NET Framework

i need help in structures .....

by: skumar434 | last post by:

i need to store the data from a data base in to structure .............the problem is like this ....suppose there is a data base which stores the...

C / C++

Help with Extern C

by: pauldepstein | last post by:

#include <iostream> using namespace std; int main() { extern "C" int f(int, int);

C / C++

If / Then / Else Help Needed - More then one condition possible?

by: tbird2340 | last post by:

I want to write an if / then statement and have tried using this: var MyVarMailto; if (Request.Form("LoanRequest") == "Under $250,000") { if...

Javascript

VB6 OR VBA & Webbrowser DOM Tiny $50 Mini Project Programmer help

by: gunimpi | last post by:

http://www.vbforums.com/showthread.php?p=2745431#post2745431 ******************************************************** VB6 OR VBA & Webbrowser DOM...

Microsoft Access / VBA

Memory Allocation Problem, please help

by: weidongtom | last post by:

Hi, I've written the code that follows, and I use the function add_word(), it seems to work fine *before* increase_arrays() is called that uses...

C / C++

Require help learning how to decompose class into policies

by: Stephen Torri | last post by:

Below is a class that is suppose to represent a segment of memory or a contents of a binary image (e.g. ELF executable). I have started to read...

C / C++

Need help with multi-dimensional arrays and functions

by: Paul David Buchan | last post by:

Hello, I'm attempting to write a program to read in database files (.dbf). When I do it all as a single procedure in main, everything works....

C / C++

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...

PHP

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

General

help: include file with variable inside div tag

Similar topics