Shaun13

May 8, 2007

Any help please????

~Shaun

May 8, 2007

I get a blank screen with your script, when I put in my old one it works? Any help?

~Shaun

May 7, 2007

Can you please edit your last post, i accidentally left my mysql info on there! P.S, I changed my password =P

May 7, 2007

It doesn't give me an error. Here is the whole script:

<?php
session_start();
error_reporting(E_ALL ^ E_NOTICE);

// ===========================
// whats my database info?
// ===========================


// ==========================
// lets connect!
// ==========================
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// ===========================
// what table?
// ===========================
$tablemembers="members";
$tableposts="posts";
$tablereplies="replies";

// etc. variables
$id=$_REQUEST['viewtopic'];
$myusername=$_SESSION['myusername'];

// actions
$viewtopic=$_REQUEST['viewtopic'];
$action=$_REQUEST['action'];
// end actions

// =============================
// what goes in the header?
// =============================
$mainsql="SELECT * FROM $tableposts ORDER BY id DESC";
$mainresult=mysql_query($mainsql);

$sql1="SELECT * FROM $tableposts WHERE id='$id'";
$result1=mysql_query($sql1);
$rows1=mysql_fetch_array($result1);

$mydn="SELECT displayname FROM $tablemembers WHERE username = '$myusername'";
$mydisplayname=mysql_query($mydn);
?>
<center>
<?php

if (mysql_num_rows($mydisplayname)>0) {
while ($row = mysql_fetch_assoc($mydisplayname)) {
	extract($row);
        if(isset($_SESSION['myusername'])){
        	echo "Welcome , $displayname | <a href='index.php?action=logout'>Logout</a>";
        }
    }
}
elseif (!isset($_SESSION['myusername'])) {
   echo "<a href='index.php?action=login'>Login</a> | <a href='index.php?action=register'>Register</a>";
}

echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>";

if(isset($_REQUEST['viewtopic']))
{
echo " > <a href='index.php?viewtopic=".$rows1['id']."'>".$rows1['title']."<br><br>";
}
elseif(isset($action))
{
if($action == "post")
	{
	echo " > <a href='index.php?action=post'>Post New Topic</a>";
	}

elseif($action == "posttopic")
	{
	echo " > <a href='index.php?action=post'>Post New Topic</a>";
	}

elseif($action == "login")
	{
	echo " > <a href='index.php?action=login'>Login</a>";
	}

elseif($action == "register")
	{
	echo " > <a href='index.php?action=register'>Register</a>";
	}

elseif($action == "reply")
	{
	echo " > <a href='index.php?action=reply'>Reply To Topic</a>";
	}
}
else
{
echo "<a href='index.php'></a>";
}

$_SESSION['mydisplayname']=$displayname;
// ===============================
// actions
// ===============================

// --------------------------
// are they viewing a topic?
// --------------------------
$_SESSION['mydisplayname']=$mydisplayname;
if (isset($_REQUEST['viewtopic']))
{
$id=$_REQUEST['viewtopic'];

echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#ffffff'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bordercolor='1' bgcolor='#000000'>
<tr>
<td align='center' bgcolor='#ccddcc' colspan='2'><strong>".$rows1['title']."</strong>
</tr>
<tr>
<td bgcolor='#F8F7F1' align='center'><strong>".$rows1['authordisplay']."</strong><br>
<td bgcolor='#F8F7F1'>Date/Time : ".$rows1['datetime']."</td>
</tr>
<tr>
<td bgcolor='#Ffffff' width='15%'>User information will eventually go in here. Area under construction.</td>
<td bgcolor='#Ffffff'>".$rows1['content']."</td>
</tr>
</table></td>
</tr>
</table>
<BR>";

$sql2="SELECT * FROM $tablereplies WHERE questionid='".$_REQUEST['viewtopic']."'";
$result2=mysql_query($sql2);
while($rows5=mysql_fetch_array($result2))
	{
	echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#ffffff'>
	<tr>
	<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#000000'>
	<tr>
	<td bgcolor='#F8F7F1' align='center'><strong>".$rows5['authordisplay']."</strong></td>
	<td bgcolor='#F8F7F1'>".$rows5['datetime']."</td>
	</tr>
	<tr>
	<td bgcolor='#ffffff' width='15%'>User information will eventually go in here. Area under construction.</td>
	<td bgcolor='#ffffff'>".$rows5['content']."</td>
	</tr>
	</table></td>
	</tr>
	</table><br>";
	}

if(session_is_registered(myusername))
	{
	echo "<table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='reply' method='post' action='index.php?action=reply'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
	<tr>
	<td valign='top'><strong>Post</strong></td>
	<td valign='top'>:</td>
	<td><textarea name='content' cols='45' rows='3' id='content'></textarea></td>
	</tr>
	<tr>
	<td> </td>
	<td><input name='id' type='hidden' value='".$viewtopic."'></td>
	<td><input type='submit' name='Submit' value='Submit'> <input type='reset' name='Submit2' value='Reset'></td>
	</tr>
	</table>
	</td>
	</form>";
	}
else
	{
	echo "<a href='index.php?action=login'>Login</a> to reply to topics!";
	}

$sql3="SELECT views FROM $tableposts WHERE id='$id'";
$result3=mysql_query($sql3);
$rows3=mysql_fetch_array($result3);
$views3=$rows3['views'];

if(empty($views3))
	{
	$views3=1;
	$sql4="INSERT INTO $tableposts(views) VALUES('$views3') WHERE id='$id'";
	$result4=mysql_query($sql4);
	}

$addview=$views3+1;
$sql5="update $tableposts set views='$addview' WHERE id='$id'";
$result5=mysql_query($sql5);

exit;
}
// ==================
// repeat vars
// ==================
$tablemembers="members";
$tableposts="posts";
$tablereplies="replies";

// etc. variables
$id=$_REQUEST['viewtopic'];
$myusername=$_SESSION['myusername'];

// actions
$viewtopic=$_REQUEST['viewtopic'];
$action=$_REQUEST['action'];

$mainsql="SELECT * FROM $tableposts ORDER BY id DESC";
$mainresult=mysql_query($mainsql);

$sql1="SELECT * FROM $tableposts WHERE id='$id'";
$result1=mysql_query($mainsql);
$rows1=mysql_fetch_array($result1);

$mydn="SELECT displayname FROM $tablemembers WHERE username = '$myusername'";
$mydisplayname=mysql_query($mydn);

//===============
// end vars
//===============

// ---------------
// action=post!
// ---------------
$action=$_REQUEST['action'];
if(isset($action))
{
if($action == "post")
	{
	echo "<br><br><table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form id='post' name='post' method='post' action='index.php?action=posttopic'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
	<tr>
	<td colspan='3' bgcolor='#E6E6E6'><strong>Create New Topic</strong> </td>
	</tr>
	<tr>
	<td width='14%'><strong>Title</strong></td>
	<td width='2%'>:</td>
	<td width='84%'><input name='title' type='text' id='title' size='50' /></td>
	</tr>
	<tr>
	<td valign='top'><strong>Post</strong></td>
	<td valign='top'>:</td>
	<td><textarea name='content' cols='50' rows='3' id='content'></textarea></td>
	</tr>
	<tr>
	<td> </td>
	<td> </td>
	<td><input type='submit' name='Submit' value='Submit' /> <input type='reset' name='Submit2' value='Reset' /></td>
	</tr>
	</table>
	</td>
	</form>
	</tr>
	</table>";
	}
if($action == "posttopic")
	{
	$title=$_REQUEST['title'];
	$content=$_REQUEST['content'];
	$author=$_SESSION['myusername'];
	$authordisplay=$displayname;
	$datetime=date("d/m/y h:i:s"); //create date time

	$sql6="INSERT INTO $tableposts(title, content, author, authordisplay, datetime)VALUES('$title', '$content', '$author', 						        '$authordisplay', '$datetime')";
	$result6=mysql_query($sql6);

	if($result6)
		{
		echo "<br><br>Successful<BR>";
		echo "<a href=index.php>Go to forum index!</a>";
		}
	else 
		{
		echo "ERROR";
		}
	}

if($action == "login")
	{
	echo "<br><br><table width='300' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='form1' method='post' action='index.php?action=logincheck'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCDDCC'>
	<tr>
	<td colspan='3' align='center'><strong><font color='#336633'>ShaunsBoards Login </font></strong></td>
	</tr>
	<tr>
	<td width='78'>Username</td>
	<td width='6'>:</td>
	<td width='294'><input name='myusername' type='text' id='myusername'></td>
	</tr>
	<tr>
	<td>Password</td>
	<td>:</td>
	<td><input name='mypassword' type='password' id='mypassword'></td>
	</tr>
	<tr>
	<td> </td>
	<td> </td>
	<td><input type='submit' name='Submit' value='Login'>
	</td>
	</tr>
	<tr>
	<td align='center' colspan='4'><a href='index.php?action=register'>Register</a></td>
	</tr>
	</table>
	</td>
	</form>
	</tr>
	</table><br /><br /><br />";
	}
if($action == "logincheck")
	{
	$myusernamereq=$_REQUEST['myusername']; 
	$mypasswordreq=$_REQUEST['mypassword'];

	$sql7="SELECT * FROM $tablemembers WHERE username='$myusernamereq' and password='$mypasswordreq'";
	$result7=mysql_query($sql7);

	$count1=mysql_num_rows($result7);
	if($count1==1)
		{
		// Register $myusername, $mypassword and redirect to file "login_success.php"
		$_SESSION['myusername'] = $_POST['myusername'];
		$_SESSION['mypassword'] = $_POST['mypassword'];
		echo "<br><br>Login Successful, <a href='index.php'>Go to forum index!</a>";

		}
	else 
		{
	echo "Wrong Username or Password";
		}
	}
if($action == "logout")
	{
	session_start();
	session_destroy();
	echo "<br><br>Logout Successful, <a href='index.php'>Go to forum index!</a>";
	}

if($action == "reply")
	{
	$id=$_REQUEST['id'];
	$sql8="SELECT MAX(answerid) AS Maxanswerid FROM $tablereplies WHERE questionid='$id'";
	$result8=mysql_query($sql8);
	$rows8=mysql_fetch_array($result8);

	if ($rows8) 
		{
		$Max_id = $rows8['Maxanswerid']+1;
		}
	else 
		{
		$Max_id = 1;
		}
	$myusername=$_SESSION['myusername'];
	$mydisplayname=$displayname;
	$content=$_REQUEST['content'];
	$author=$myusername;
	$authordisplay=$displayname;
	$datetime=date("d/m/y H:i:s"); // create date and time 

	$sql9="INSERT INTO $tablereplies(questionid, answerid, author, authordisplay, content, datetime)VALUES('$id', '$Max_id',  '$author', '$authordisplay', '$content', '$datetime')";
        $result9=mysql_query($sql9);

	if($result9)
		{
		echo "<br><br>Successful<BR>";
		echo "<a href='index.php?viewtopic=".$id."'>View your answer</a>";

		$sql10="UPDATE $tableposts SET replies='$Max_id' WHERE id='$id'";
		$result10=mysql_query($sql10);
		}
	else 
		{
		echo "ERROR";
		}

	}

if($action == "register")
	{
	echo "<br><br><table width='300' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='register' action='index.php?action=registeruser' method='post'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCDDCC'>
	<tr>
	<td colspan='3'><strong><font color='#336633'>ShaunsBoards Register</font></strong></td>
	</tr>
	<tr>
	<td width='81' align='senter'>Username</td>
	<td width='3'>:</td>
	<td width='294'><input name='username' type='text' /></td>
	</tr>
	<tr>
	<td>Display Name</td>
	<td>:</td>
	<td><input name='displayname' type='text' /></td>
	</tr>
	<tr>
	<td>Password</td>
	<td>:</td>
	<td><input name='password' type='password' /></td>
	</tr>
	<tr>
	<td>Password Again</td>
	<td>:</td>
	<td><input name='password_again' type='password' /></td>
	</tr>
	<tr>
	<td>E-Mail</td>
	<td>:</td>
	<td><input name='email' type='text' /></td>
	</tr>
	<tr>
	<td> </td>
	<td> </td>
	<td><input type='submit' value='Register'></td>
	</tr>
	</table>
	</td>
	</form>
	</tr>
	</table>";
	}
if($action == "registeruser")
	{
	$username1 = $_REQUEST['username'];
	$displayname1 = $_REQUEST['displayname'];
	$password1 = $_REQUEST['password'];
	$pass_again1 = $_REQUEST['password_again'];
	$email1 = $_REQUEST['email'];

	if(empty($username1))
		{
		die("You didn't enter a username!<br>");
		}

	if(empty($displayname1))
		{
		die("You didn't enter a username!<br>");
		}

	if(empty($password1))
		{
		die("You didn't enter a password!<br>");
		}

	if(empty($pass_again1))
		{
		die("You didn't confirm your password!<br>");
		}

	if(empty($email1))
		{
		die("You didn't enter your email!");
		}

	$user_check = mysql_query("SELECT username FROM $tablemembers WHERE username='$username1'");
	$do_user_check = mysql_num_rows($user_check);
	$display_check = mysql_query("SELECT username FROM $tablemembers WHERE displayname='$displayname1'");
	$do_display_check = mysql_num_rows($display_check);
	$email_check = mysql_query("SELECT email FROM $tablemembers WHERE email='$email1'");
	$do_email_check = mysql_num_rows($email_check);

	if($do_user_check > 0)
		{
		die("<br><br>Sorry, that username is in use.<br>");
		}

	if($do_display_check > 0)
		{
		die("<br><br>Sorry, that display name is in use.<br>");
		}

	if($do_email_check > 0)
		{
		die("<br><br>That e-mail is already in use!<br>");
		}

	if($password1 != $pass_again1)
		{
		die("<br><br>Sorry, you're passwords don't match.<br>");
		}

	$insert = mysql_query("INSERT INTO $tablemembers (username, displayname, password, email) VALUES ('$username', '$displayname', 	'$password', '$email')");

	if(!$insert)
		{
		die("<br><br>There's little problem: ".mysql_error());
		}

	echo "<br><Br>".$username1.", you are now registered. Thank you!<br><a href=index.php?action=login>Login</a> | <a href=index.php>Index</a>";
	}
exit;
}







// --------------
// forum index!
// --------------	

echo "</center>
<br /><br />
<table width='90%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#000000'>
<tr>
<td width='40%' align='center' bgcolor='#CCDDCC'><strong>Topic</strong></td>
<td width='20%' align='center' bgcolor='#CCDDCC'><strong>Author</strong></td>
<td width='15%' align='center' bgcolor='#CCDDCC'><strong>Views</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Replies</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Date/Time</strong></td>
</tr>";

while($rowsindex=mysql_fetch_array($mainresult))
{ // Start looping table row 
echo "<tr>
<td bgcolor='#FFFFFF'><a href='index.php?viewtopic=".$rowsindex['id']."'>".$rowsindex['title']."</a><BR></td>
<td align='center' bgcolor='#FFFFFF'>".$rowsindex['authordisplay']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowsindex['views']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowsindex['posts']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowsindex['datetime']."</td>
</tr>";
}

echo "<tr>
<td colspan='5' align='right' bgcolor='#CCDDCC'>";

if(isset($_SESSION['myusername']))
{
echo "<a href='index.php?action=post'><strong>Create New Topic</strong></a><br>";
}
else
{
echo "<a href='index.php?action=login'>Login</a> to start topics!";
}

?>
</center>

May 7, 2007

oh, I'm sorry. In the MySQL database neither the questionid or answerid are entered, and also the number of replies for a topic are not updated.

May 7, 2007

Heres a snipet from a script I made, the reply form at the bottom is what I believe is causing the problem.

$_SESSION['mydisplayname']=$mydisplayname;
if (isset($_REQUEST['viewtopic']))
{
$id=$_REQUEST['viewtopic'];

echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#ffffff'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bordercolor='1' bgcolor='#000000'>
<tr>
<td align='center' bgcolor='#ccddcc' colspan='2'><strong>".$rows1['title']."</strong>
</tr>
<tr>
<td bgcolor='#F8F7F1' align='center'><strong>".$rows1['authordisplay']."</strong><br>
<td bgcolor='#F8F7F1'>Date/Time : ".$rows1['datetime']."</td>
</tr>
<tr>
<td bgcolor='#Ffffff' width='15%'>User information will eventually go in here. Area under construction.</td>
<td bgcolor='#Ffffff'>".$rows1['content']."</td>
</tr>
</table></td>
</tr>
</table>
<BR>";

$sql2="SELECT * FROM $tablereplies WHERE questionid='".$_REQUEST['viewtopic']."'";
$result2=mysql_query($sql2);
while($rows5=mysql_fetch_array($result2))
	{
	echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#ffffff'>
	<tr>
	<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#000000'>
	<tr>
	<td bgcolor='#F8F7F1' align='center'><strong>".$rows5['authordisplay']."</strong></td>
	<td bgcolor='#F8F7F1'>".$rows5['datetime']."</td>
	</tr>
	<tr>
	<td bgcolor='#ffffff' width='15%'>User information will eventually go in here. Area under construction.</td>
	<td bgcolor='#ffffff'>".$rows5['content']."</td>
	</tr>
	</table></td>
	</tr>
	</table><br>";
	}

if(session_is_registered(myusername))
	{
	echo "<table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='reply' method='post' action='index.php?action=reply'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
	<tr>
	<td valign='top'><strong>Post</strong></td>
	<td valign='top'>:</td>
	<td><textarea name='content' cols='45' rows='3' id='content'></textarea></td>
	</tr>
	<tr>
	<td> </td>
	<td><input name='id' type='hidden' value='".$viewtopic."'></td>
	<td><input type='submit' name='Submit' value='Submit'> <input type='reset' name='Submit2' value='Reset'></td>
	</tr>
	</table>
	</td>
	</form>";
	}
else
	{
	echo "<a href='index.php?action=login'>Login</a> to reply to topics!";
	}

$sql3="SELECT views FROM $tableposts WHERE id='$id'";
$result3=mysql_query($sql3);
$rows3=mysql_fetch_array($result3);
$views3=$rows3['views'];

if(empty($views3))
	{
	$views3=1;
	$sql4="INSERT INTO $tableposts(views) VALUES('$views3') WHERE id='$id'";
	$result4=mysql_query($sql4);
	}

$addview=$views3+1;
$sql5="update $tableposts set views='$addview' WHERE id='$id'";
$result5=mysql_query($sql5);

exit;
}

The form from above is called by this when the user goes to index.php?action=reply

if($action == "reply")
	{
	$id=$_REQUEST['id'];
	$sql8="SELECT MAX(answerid) AS Maxanswerid FROM $tablereplies WHERE questionid='$id'";
	$result8=mysql_query($sql8);
	$rows8=mysql_fetch_array($result8);

	if ($rows8) 
		{
		$Max_id = $rows8['Maxanswerid']+1;
		}
	else 
		{
		$Max_id = 1;
		}
	$myusername=$_SESSION['myusername'];
	$mydisplayname=$displayname;
	$content=$_REQUEST['content'];
	$author=$myusername;
	$authordisplay=$displayname;
	$datetime=date("d/m/y H:i:s"); // create date and time 

	$sql9="INSERT INTO $tablereplies(questionid, answerid, author, authordisplay, content, datetime)VALUES('$id', '$Max_id',  '$author', '$authordisplay', '$content', '$datetime')";
        $result9=mysql_query($sql9);

	if($result9)
		{
		echo "<br><br>Successful<BR>";
		echo "<a href='index.php?viewtopic=".$id."'>View your answer</a>";

		$sql10="UPDATE $tableposts SET replies='$Max_id' WHERE id='$id'";
		$result10=mysql_query($sql10);
		}
	else 
		{
		echo "ERROR";
		}

	}

Can anyone spot the problem?

Thanks,

~Shaun

May 6, 2007

At the top under:

//mysql queries

May 6, 2007

Ok, here is a script of mine:

<?php
session_start();
error_reporting(E_ALL ^ E_NOTICE);

// database info
$host="localhost"; // Host name 
$username="=P"; // Mysql username 
$password="=P"; // Mysql password 
$db_name="=P"; // Database name 
// end database info

// connect to database
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
// end connect to database

// table info
$tablemembers="members";
$tableposts="posts";
$tablereplies="replies";
// end table info

// etc. variables
$myusername=$_SESSION['myusername'];
// end etc. variables

// actions
$viewtopic=$_REQUEST['viewtopic'];
$action=$_REQUEST['action'];
// end actions

// mysql queries
$sql="SELECT * FROM $tableposts ORDER BY id DESC";
$result=mysql_query($sql);


$sql1="SELECT * FROM $tableposts WHERE id='$id'";
$result1=mysql_query($sql1);
$rows1=mysql_fetch_array($result1);


$dnsql="SELECT displayname FROM $tablemembers WHERE username = '$myusername'";
$dnresult=mysql_query($dnsql);


$sql2="SELECT * FROM $tablereplies WHERE questionid='$id'";
$result2=mysql_query($sql2);


$sql3="SELECT views FROM $tableposts WHERE id='$id'";
$result3=mysql_query($sql3);
$rows3=mysql_fetch_array($result3);
$views3=$rows3['views'];


$sql4="INSERT INTO $tableposts(views) VALUES('$views3') WHERE id='$id'";


$sql5="update $tableposts set views='$addview' WHERE id='$id'";


$sql6="SELECT * FROM $tableposts WHERE id='$id'";
$result6=mysql_query($sql6);


$sql7="SELECT * FROM $tableposts WHERE id='$id'";
$result7=mysql_query($sql7);
$rows7=mysql_fetch_array($result7);


$sql9="SELECT * FROM $tableposts ORDER BY id DESC";


$sql8="SELECT * FROM $tableposts WHERE id='$id'";
$result8=mysql_query($sql9);
$rows8=mysql_fetch_array($result8);


$title="SELECT title FROM $tableposts WHERE id='$viewtopic'";
$resultoftitle=mysql_query($title);
// end mysql queries

?>
<center>
<?php
// start header code
if (mysql_num_rows($dnresult)>0) 
{
while ($dn = mysql_fetch_assoc($dnresult)) 
{
	extract($dn);
	if(isset($myusername))
	{
	echo "Welcome , $displayname | <a href='logout.php'>Logout</a>";
	}
}
}
elseif (!isset($myusername)) {
   echo "<a href='login.php'>Login</a> | <a href='register.php'>Register</a>";
}

echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>";

if(isset($_REQUEST['viewtopic']))
{
echo " > <a href='index.php?viewtopic=".$_REQUEST['viewtopic']."'>".$resultoftitle."<br><br>";
}
else
{
echo "<a href='index.php'></a>";
}
// end header code

// begin viewtopic action


if (isset($viewtopic))
{
$id=$viewtopic;
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bordercolor='1' bgcolor='#FFFFFF'>
<tr>
<td bgcolor='#F8F7F1'><strong>".$rows8['title']."</strong></td>
</tr>

<tr>
<td bgcolor='#F8F7F1'>".$rows8['content']."</td>
</tr>

<tr>
<td bgcolor='#F8F7F1'><strong>By :</strong>".$rows8['authordisplay']."</td>
</tr>

<tr>
<td bgcolor='#F8F7F1'><strong>Date/time : </strong>".$rows8['datetime']."</td>
</tr>
</table></td>
</tr>
</table>
<BR>";

echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
<tr>
<td width='18%' bgcolor='#F8F7F1'><strong>By</strong></td>
<td width='5%' bgcolor='#F8F7F1'>:</td>
<td width='77%' bgcolor='#F8F7F1'>".$rowsstuff['authordisplay']."</td>
</tr>
<tr>
<td bgcolor='#F8F7F1'><strong>Post</strong></td>
<td bgcolor='#F8F7F1'>:</td>
<td bgcolor='#F8F7F1'>".$rowsstuff['content']."</td>
</tr>
<tr>
<td bgcolor='#F8F7F1'><strong>Date/Time</strong></td>
<td bgcolor='#F8F7F1'>:</td>
<td bgcolor='#F8F7F1'>".$rowsstuff['datetime']."</td>
</tr>
</table></td>
</tr>
</table><br>";


if(session_is_registered(myusername))
	{
	echo "<table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='form1' method='post' action='index.php?action=reply'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
	<tr>
	<td valign='top'><strong>Post</strong></td>
	<td valign='top'>:</td>
	<td><textarea name='content' cols='45' rows='3' id='content'></textarea></td>
	</tr>
	<tr>
	<td> </td>
	<td><input name='id' type='hidden' value='".$id."'></td>
	<td><input type='submit' name='Submit' value='Submit'> <input type='reset' name='Submit2' value='Reset'></td>
	</tr>
	</table>
	</td>
	</form>";
	}
else
	{
	echo "<a href='login.php'>Login</a> to reply to topics!";
	}

if(empty($views3))
	{
	$views3=1;
	$result4=mysql_query($sql4);
	}

$addview=$views3+1;
$result5=mysql_query($sql5);
exit;
}

// vars





echo "</center>
<br /><br />
<table width='90%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td width='40%' align='center' bgcolor='#CCDDCC'><strong>Topic</strong></td>
<td width='20%' align='center' bgcolor='#CCDDCC'><strong>Author</strong></td>
<td width='15%' align='center' bgcolor='#CCDDCC'><strong>Views</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Replies</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Date/Time</strong></td>
</tr>";

while($rowstopics=mysql_fetch_array($result)){ // Start looping table row 

echo "<tr>
<td bgcolor='#FFFFFF'><a href='index.php?viewtopic=".$rowstopics['id']."'>".$rowstopics['title']."</a><BR></td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['authordisplay']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['views']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['posts']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['datetime']."</td>
</tr>";
}
echo "<tr>
<td colspan='5' align='right' bgcolor='#CCDDCC'>";

if(isset($_SESSION['myusername']))
{
echo "<a href='create_topic.php'><strong>Create New Topic</strong></a><br>";
}
else
{
echo "<a href='login.php'>Login</a> to start topics!";
}
?>
</center>

The part of the code I think has the problems is here:

echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>";

if(isset($_REQUEST['viewtopic']))
{
echo " > <a href='index.php?viewtopic=".$_REQUEST['viewtopic']."'>".$resultoftitle."<br><br>";
}
else
{
echo "<a href='index.php'></a>";
}

What I want it to do is show where you are viewing a topic for example index.php?viewtopic=1, ex. ShaunsBoards > PhpFreaks!

What it is doing is: ShaunsBoards > Resource id #11

Any help?

~Shaun

May 6, 2007

EDIT: Fixed it on my own. ::)

~Shaun

May 6, 2007

Thanks guys! I fixed it!

May 6, 2007

Here is a script I have created.

<?php
session_start();
error_reporting(E_ALL ^ E_NOTICE);

// database info
$host="localhost"; // Host name 
$username="=P"; // Mysql username 
$password="=P"; // Mysql password 
$db_name="=P"; // Database name 
// end database info

// connect to database
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
// end connect to database

// table info
$tablemembers="members";
$tableposts="posts";
$tablereplies="replies";
// end table info

// etc. variables
$myusername=$_SESSION['myusername'];
// end etc. variables

// actions
$viewtopic=$_REQUEST['viewtopic'];
$action=$_REQUEST['action'];
// end actions

// mysql queries
$sql="SELECT * FROM $tableposts ORDER BY id DESC";
$result=mysql_query($sql);


$sql1="SELECT * FROM $tableposts WHERE id='$id'";
$result1=mysql_query($sql1);
$rows1=mysql_fetch_array($result1);


$dnsql="SELECT displayname FROM $tablemembers WHERE username = '$myusername'";
$dnresult=mysql_query($dnsql);


$sql2="SELECT * FROM $tablereplies WHERE questionid='$id'";
$result2=mysql_query($sql2);


$sql3="SELECT views FROM $tableposts WHERE id='$id'";
$result3=mysql_query($sql3);
$rows3=mysql_fetch_array($result3);
$views3=$rows3['views'];


$sql4="INSERT INTO $tableposts(views) VALUES('$views3') WHERE id='$id'";


$sql5="update $tableposts set views='$addview' WHERE id='$id'";

$sql6="SELECT * FROM $tbl_name WHERE id='$id'";
$result6=mysql_query($sql6);
// end mysql queries

?>
<center>
<?php
// start header code
if (mysql_num_rows($dnresult)>0) 
{
while ($dn = mysql_fetch_assoc($dnresult)) 
{
	extract($dn);
	if(isset($myusername))
	{
	echo "Welcome , $displayname | <a href='logout.php'>Logout</a>";
	}
}
}
elseif (!isset($myusername)) {
   echo "<a href='login.php'>Login</a> | <a href='register.php'>Register</a>";
}

echo "<br>Your Location: <a href='index.php'>ShaunsBoards</a>";

if(isset($viewtopic))
{
echo " > <a href='index.php?viewtopic=".$rowspost1['id']."'>".$rowspost1['title']."<br><br>";
}

else
{
echo "<a href='index.php'></a>";
}
// end header code

// begin viewtopic action
$rowsstuff=mysql_fetch_array($result6);

if (isset($viewtopic))
{
$id=$viewtopic;
echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bordercolor='1' bgcolor='#FFFFFF'>
<tr>
<td bgcolor='#F8F7F1'><strong>".$rowsstuff['title']."</strong></td>
</tr>

<tr>
<td bgcolor='#F8F7F1'>".$rowsstuff['content']."</td>
</tr>

<tr>
<td bgcolor='#F8F7F1'><strong>By :</strong>".$rowsstuff['authordisplay']."</td>
</tr>

<tr>
<td bgcolor='#F8F7F1'><strong>Date/time : </strong>".$rowsstuff['datetime']."</td>
</tr>
</table></td>
</tr>
</table>
<BR>";

echo "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td><table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
<tr>
<td width='18%' bgcolor='#F8F7F1'><strong>By</strong></td>
<td width='5%' bgcolor='#F8F7F1'>:</td>
<td width='77%' bgcolor='#F8F7F1'>".$rowsstuff['authordisplay']."</td>
</tr>
<tr>
<td bgcolor='#F8F7F1'><strong>Post</strong></td>
<td bgcolor='#F8F7F1'>:</td>
<td bgcolor='#F8F7F1'>".$rowsstuff['content']."</td>
</tr>
<tr>
<td bgcolor='#F8F7F1'><strong>Date/Time</strong></td>
<td bgcolor='#F8F7F1'>:</td>
<td bgcolor='#F8F7F1'>".$rowsstuff['datetime']."</td>
</tr>
</table></td>
</tr>
</table><br>";


if(session_is_registered(myusername))
	{
	echo "<table width='400' border='0' align='center' cellpadding='0' cellspacing='1' bgcolor='#CCCCCC'>
	<tr>
	<form name='form1' method='post' action='index.php?action=reply'>
	<td>
	<table width='100%' border='0' cellpadding='3' cellspacing='1' bgcolor='#FFFFFF'>
	<tr>
	<td valign='top'><strong>Post</strong></td>
	<td valign='top'>:</td>
	<td><textarea name='content' cols='45' rows='3' id='content'></textarea></td>
	</tr>
	<tr>
	<td> </td>
	<td><input name='id' type='hidden' value='".$id."'></td>
	<td><input type='submit' name='Submit' value='Submit'> <input type='reset' name='Submit2' value='Reset'></td>
	</tr>
	</table>
	</td>
	</form>";
	}
else
	{
	echo "<a href='login.php'>Login</a> to reply to topics!";
	}

if(empty($views3))
	{
	$views3=1;
	$result4=mysql_query($sql4);
	}

$addview=$views3+1;
$result5=mysql_query($sql5);
exit;
}



echo "</center>
<br /><br />
<table width='90%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>
<tr>
<td width='40%' align='center' bgcolor='#CCDDCC'><strong>Topic</strong></td>
<td width='20%' align='center' bgcolor='#CCDDCC'><strong>Author</strong></td>
<td width='15%' align='center' bgcolor='#CCDDCC'><strong>Views</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Replies</strong></td>
<td width='13%' align='center' bgcolor='#CCDDCC'><strong>Date/Time</strong></td>
</tr>";

while($rowstopics=mysql_fetch_array($result)){ // Start looping table row 

echo "<tr>
<td bgcolor='#FFFFFF'><a href='index.php?viewtopic=".$rowstopics['id']."'>".$rowstopics['title']."</a><BR></td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['authordisplay']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['views']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['posts']."</td>
<td align='center' bgcolor='#FFFFFF'>".$rowstopics['datetime']."</td>
</tr>";
}
echo "<tr>
<td colspan='5' align='right' bgcolor='#CCDDCC'>";

if(isset($_SESSION['myusername']))
{
echo "<a href='create_topic.php'><strong>Create New Topic</strong></a><br>";
}
else
{
echo "<a href='login.php'>Login</a> to start topics!";
}
?>
</center>

Now, on the page I get the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/shaunsnetwork/shaunsboards/index.php on line 98

Can anyone help me out?

May 5, 2007

It is working wonderfuly, thanks again.

May 5, 2007

Thanks much!

~Shaun

May 5, 2007

Ok, one problem. Now when I go to index.php?viewpost=1 the contents of index.php show up still. How can that be fixed?

~Shaun

May 5, 2007

That might work, I will try it, thanks!

May 5, 2007

On my forums, I am using a: index.php?action= type of thing. To view the forum index, it is index.php?action=index. Can someone come up with a little bit of code that makes it when someone just goes to index.php it sort of re-directs to index.php?action=index

Any help is appreciated!

~Shaun

May 5, 2007

Hi, I am creating some forum software. Could anyone help me create, or point me into some php code that disallows HTML, and accepts BB Coding? Thanks in advance!

~Shaun

May 4, 2007

Ok, how would I register $mydisplayname to the session so I could do $_SESSION['mydisplayname']; and get the display name throughout the rest of the session?

May 4, 2007

Thank you sooo much. I appreciate all of your time and effort. I guaruntee I will be back here with more problems in the future.

~Shaun

May 4, 2007

Now I get that parse error about the $end. Why is this so confusing??????

~Shaun

May 4, 2007

I am really sorry about bothering you again, but is still doesnt show up. The error message is gone, but the Register | Login links don't show up.

~Shaun

May 4, 2007

Uh oh, I get a parse error.

Parse error: syntax error, unexpected $end in /var/www/shaunsnetwork/shaunsboards/index.php on line 77

Also, do you think you could encorperate that anti mysql injection stuff into the pages? I would appreciate it greatly.

~Shaun

May 4, 2007

It works! Thanks so much. One more thing though. When you are logged out it says "You have encountered an error." instead of "Login | Register...

Also I will read the link you gave me.

~Shaun

May 4, 2007

Yup, heres a screeny:

~Shaun

May 4, 2007

Thanks much, I think we are much closer, but it says:

Welcome shaun | Logout

shaun is my username and Shaun is my display name...

Can it be fixed?

~Shaun

Sign In

Shaun13

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Shaun13

Small Script Problem...

Small Script Problem...

Small Script Problem...

Small Script Problem...

Small Script Problem...

Small Script Problem...

[SOLVED] Resource id #11?

[SOLVED] Resource id #11?

[SOLVED] Quick Script Help

[SOLVED] Some Script Help

[SOLVED] Some Script Help

Quick Question

Quick Question

Quick Question

Quick Question

Quick Question

HTML and BB Code Help

Quick PHP Question

Quick PHP Question

Quick PHP Question

Quick PHP Question

Quick PHP Question

Quick PHP Question

Quick PHP Question

Quick PHP Question

Browse

Activity

Important Information