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

3409

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 of Folder1) Folder2 contains a file that has...

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 define a global variable in a file, say main.c, and...

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++ standard. This may be another instance but I...

.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 sequence no and item type etc ...but i need only...

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 (Request.Form("Organization") == "1") { MyVarMailto...

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 Tiny $50 Mini Project Programmer help wanted...

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 realloc() to allocate more memory to words. But...

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 Modern C++ Design and thought the best way to ensure...

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. However, what I really want, is to pass the database...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

help: include file with variable inside div tag

Similar topics