Jump to content

text area submiting


thegod

Recommended Posts

here is the coding when people reply use a textarea it does submit it into the database look  i marked it in red

 

<?

include_once 'includes/functions.php';

include_once 'includes/replace.php';

logincheck();

 

$forum=$_GET['forum'];

$username=$_SESSION['username'];

$viewtopic = $_GET['viewtopic'];

$forum_look=$_GET['forum_look'];

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));

$forumquote = mysql_query("SELECT * FROM user_info WHERE username = '$right->username'");

$fq = mysql_fetch_object($forumquote);

 

if (!$viewtopic){

$viewtopic = "1";

}

 

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));

if ($forum == "Crew" && $fetch->crew != "0"){

$crew="1";

}

$owner=mysql_num_rows(mysql_query("SELECT * FROM crews WHERE owner='$username' OR rhm='$username'"));

 

 

$userlevel=$fetch->userlevel;

 

 

 

 

 

$ggee = mysql_query("SELECT locked, sticky, lastreply FROM topics WHERE id='$viewtopic' AND forum='$forum'");

while($dsdsd = mysql_fetch_row($ggee)){

$lockedornot = $dsdsd[0];

$stikornot = $dsdsd[1];

$lastreplyit = $dsdsd[2];

}

 

if ($lockedornot == '1'){

echo "This topic is locked.";

}elseif ($userlevel != '0' || $lockedornot != '1'){

 

if ($crew == "1"){

$gg = mysql_query("SELECT * FROM topics WHERE id='$viewtopic' AND forum='$forum' AND crew='$fetch->crew'");

}else{

$gg = mysql_query("SELECT * FROM topics WHERE id='$viewtopic' AND forum='$forum'");

}

while($success = mysql_fetch_row($gg)){

$username1 = $success[1];

$topictext = $success[3];

$made = $success[8];

 

}

 

$forumquote2 = mysql_query("SELECT * FROM user_info WHERE username = '$username1'");

$fq2 = mysql_fetch_object($forumquote2);

 

 

?>

<style type="text/css">

<!--

.style2 {font-size: 10px}

-->

</style>

 

<link href="includes/forum.css" rel="stylesheet" type="text/css">

 

 

<table width=100% border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 class=thinline>

<tr>

<td class="header" colspan=2><center>Topic Made By : <? echo "<a href='profile.php?viewuser=$username1' target=mainFrame>$username1</a>"; ?> On :<?php echo "$made"; ?></td>

</tr>

<tr>

<td width='8%' rowspan='3' bgcolor=#777777>

<center>

<img src='<? echo"$fq2->forumpic"; ?>' hight='65' width='65' align='center'>

<span class=style2><? echo"$fq2->posts"; ?> Posts</span>

 

 

 

 

 

 

</td>

</tr>

 

<tr>

<td height="134" bgcolor="#777777">

<? echo replace($topictext);

if ($topictext == ""){ $topictext = "Main Forum";}?></td>

</tr>

<tr>

<td height='21' colspan='1' bgcolor=#777777>

  <div align=center><? echo"$fetch->forumquote"; ?></div></td>

 

</tr>

</table><br>

<p>

 

 

<?php

 

$forum_count = 15;

 

function index_navigation($index, $count, $num) {

$forum = $_GET['forum'];

$viewtopic = $_GET['viewtopic'];

if ($index != 0) {

print "<a class='linktext' href=\"right.php?forum=$forum&viewtopic=$viewtopic&forum_look=" . ($index - $count) . "\">Previous</a> ";

}

if ($num == $count) {

print " <a class='linktext' href=\"right.php?forum=$forum&viewtopic=$viewtopic&forum_look=" . ($index + $count) . "\">Next</a>";

}

 

 

}

if (! isset($forum_look) ) {

$forum_look = 0;

}

if ($crew == "1"){

$query="SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' AND crew='$fetch->crew' ORDER by `id` DESC LIMIT $forum_look, $forum_count";

}else{

$query="SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' ORDER by `id` DESC LIMIT $forum_look, $forum_count";

}

 

 

$query=mysql_query("$query");

$num=mysql_num_rows($query);

while($right=mysql_fetch_object($query)){

 

 

if ($fetch->userlevel == "0"){

$forumquote = mysql_query("SELECT * FROM user_info WHERE username = '$right->username'");

$fq = mysql_fetch_object($forumquote);

 

if($fq->gender == "Dont State") { $gender = "ds.PNG"; }

if($fq->gender == "Male") { $gender = "male.gif"; }

if($fq->gender == "Female") { $gender = "female.gif"; }

if ($fq->posts >= "0" && $fq->posts < "80"){ $forumrank = "Forum Bum"; }

if ($fq->posts >= "81" && $fq->posts < "160"){ $forumrank = "Curb Crawler"; }

if ($fq->posts >= "161" && $fq->posts < "220"){ $forumrank = "Post Star"; }

if ($fq->posts >= "221" && $fq->posts < "290"){ $forumrank = "V.I.Poster"; }

if ($fq->posts >= "291"){ $forumrank = "Post Whore"; }

 

if ($fq->posts >= "0" && $fq->posts < "80"){ $forumpic = "1.jpg"; }

if ($fq->posts >= "81" && $fq->posts < "160"){ $forumpic = "2.jpg"; }

if ($fq->posts >= "161" && $fq->posts < "220"){ $forumpic = "3.jpg"; }

if ($fq->posts >= "221" && $fq->posts < "290"){ $forumpic = "4.jpg"; }

if ($fq->posts >= "291"){ $forumpic = "5.jpg"; }

 

echo "<table width=100% height=178 border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 class=\"background\">

<tr>

<td height=21 colspan=2 class=\"header\"><div align=center><a href='profile.php?viewuser=$right->username' target=mainFrame>$right->username</a> <b>On:</b> $right->made</div></td>

</tr>

<tr>

<td width='8%' rowspan='3' bgcolor=#777777>

<center>

<img src='$fq->forumpic' hight='65' width='65' align='center'>

<span class=style2>$fq->posts Posts</span>

<img src='$forumpic'>

<span class=style2>$forumrank</span>

 

<br><img src='$gender'>

 

</td>

</tr>

 

<tr>

<td width=92% height='134' class='topictext' bgcolor='#ffffff'>";

 

echo replace($right->text);

 

 

echo "</td>

 

</tr>

<tr>

<td height='21' colspan='1' bgcolor=#ffffff>

  <div align=center><font color=000000>$fq->forumquote</div></td>

</tr>

</table><br>

<p>";

}elseif ($fetch->userlevel =! "0"){

 

$forumquote = mysql_query("SELECT * FROM user_info WHERE username = '$right->username'");

$fq = mysql_fetch_object($forumquote);

 

if($fq->gender == "Dont State") { $gender = "ds.PNG"; }

if($fq->gender == "Male") { $gender = "male.gif"; }

if($fq->gender == "Female") { $gender = "female.gif"; }

if ($fq->posts >= "0" && $fq->posts < "80"){ $forumrank = "Forum Bum"; }

if ($fq->posts >= "81" && $fq->posts < "160"){ $forumrank = "Curb Crawler"; }

if ($fq->posts >= "161" && $fq->posts < "220"){ $forumrank = "Post Star"; }

if ($fq->posts >= "221" && $fq->posts < "290"){ $forumrank = "V.I.Poster"; }

if ($fq->posts >= "291"){ $forumrank = "Post Whore"; }

 

if ($fq->posts >= "0" && $fq->posts < "80"){ $forumpic = "1.jpg"; }

if ($fq->posts >= "81" && $fq->posts < "160"){ $forumpic = "2.jpg"; }

if ($fq->posts >= "161" && $fq->posts < "220"){ $forumpic = "3.jpg"; }

if ($fq->posts >= "221" && $fq->posts < "290"){ $forumpic = "4.jpg"; }

if ($fq->posts >= "291"){ $forumpic = "5.jpg"; }

 

echo "<table width=100% height=178 border=1 cellpadding=0 cellspacing=0 bordercolor=#000000 class=\"background\">

<tr>

<td height=21 colspan=2 class=\"header\"><div align=center><a href='right.php?clean=$right->id&forum=$forum&viewtopic=$viewtopic'><font color=red>Delete</font></a>    <a href='profile.php?viewuser=$right->username' target=mainFrame>$right->username</a> <b>On:</b> $right->made</div></td>

</tr>

<tr>

<td width='8%' rowspan='3' bgcolor=#777777>

<center>

<img src='$fq->forumpic' hight='65' width='65' align='center'>

 

<span class=style2>$fq->posts Posts</span>

<img src='$forumpic'>

<span class=style2>$forumrank</span>

 

 

<br><img src='$gender'>

</td>

</tr>

 

<tr>

<td width=92% height='134' class='topictext'  bgcolor='#ffffff'>";

 

echo replace($right->text);

 

 

echo "</td>

 

</tr>

<tr>

<td height='21' colspan='1' bgcolor=#ffffff>

  <div align=center><font color=000000>$fq->forumquote</div></td>

</tr>

</table><br>

<p>";

}

 

 

 

}

 

if($_GET[clean]) {

$clean=$_GET[clean];

if($userlevel == '0'){

echo "Error.";

exit;

}else

mysql_query("DELETE FROM replys WHERE id='$clean' AND forum='$forum'") or die ("Cannot delete reply");

echo "Reply Deleted";

echo "<SCRIPT LANGUAGE='JavaScript'>

window.location='right.php?forum=$forum&viewtopic=$g';

</script>";

 

}

 

 

 

 

 

?>

<?php

index_navigation($forum_look, $forum_count, $num);

?>

 

 

 

 

 

<br>

 

<br>

 

 

<?

 

if (!$viewtopic){

$viewtopic = "1";

}

 

if(strip_tags($_POST['Submit']) && strip_tags($_POST['reply_text']) && $forum && $viewtopic){

 

$reply_text = addslashes(strip_tags($_POST['reply_text']));

 

$topic_info=mysql_fetch_object(mysql_query("SELECT * FROM topics WHERE  id='$viewtopic' AND forum='$forum'"));

 

 

if ($topic_info->sticky == "1"){

$lastreplytime = $topic_info->lastreply;

}elseif ($stikornot == "0"){

$lastreplytime = time();

}

if ($topic_info->locked == "1"){

echo "This topic is locked.";

exit();

}

 

 

$date = gmdate('Y-m-d h:i:s');

 

 

 

 

 

if ($crew == "1" && $fetch->crew != "0"){

mysql_query("INSERT INTO `replys` (`id`, `username`, `text`, `forum`, `idto`,`made`,`crew`) VALUES ('', '$username', '$reply_text', '$forum', '$viewtopic','$date','$fetch->crew');") or die (mysql_error());

 

}else{

mysql_query("INSERT INTO `replys` (`id`, `username`, `text`, `forum`, `idto`,`made`) VALUES ('', '$username', '$reply_text', '$forum', '$viewtopic','$date');") or die (mysql_error()); here is what am wanting to submit in to the table look down the code you'll see the textarea

 

}

mysql_query("UPDATE `user_info` SET `posts` = `posts`+1 WHERE username='$username'");

 

mysql_query("UPDATE topics SET lastreply='$lastreplytime' WHERE id='$viewtopic' AND sticky='0'");

 

mysql_query("UPDATE `user_info` SET `posts` = `posts`+1 WHERE username='$username'");

echo "

 

<SCRIPT LANGUAGE='JavaScript'>

window.location='right.php?forum=$forum&viewtopic=$viewtopic';

</script>";

 

}

?>

 

 

<script language=JavaScript>

function so(dis)

{

for (i=0;i<dis.elements.length;i++){

if (dis.elements.type=='submit')

  dis.elements.style.visibility='hidden';

}

if(fs==false){

fs=true;

return true;

}else

return false;

}

function goaway()

{

for(i=0;i<document.forms.length;i++)

document.forms.onsubmit = function() {return so(this);};

}

</script><body onload=goaway();>

 

 

<form action='' method=post>

<input name="forumto" type="hidden" value="<?php echo "$forum"; ?>">

        <input name="this" type="hidden" id="this" value="<?php echo "$viewtopic"; ?>">

 

<center><a href="bbcode.php"><img src="../images/bbcodes.jpg" border="0"></a>  <a href="color.php"><img src="../images/colours.jpg" border="0"></a></center>

 

 

 

  <table class=titletext border=0 cellspacing=0 cellpadding=2  width=100%  bordercolor="black">

    <tr>

      <td class="header">      Reply:      </td>

    </tr>

<tr>

      <td >

        <textarea name="reply_text" cols="" rows="5" class="topictext" id="reply_text" style="width: 90%;"></textarea>        <br>

      </td>

</tr>

<tr>

<td width=33% class=thinline><input name=Submit type=submit class="submit" value=Submit></td>  here is they submit button submit the textarea named reply text

</tr>

</table>

</form>

<? } ?>

<? mysql_close(); ?>

 

Link to comment
https://forums.phpfreaks.com/topic/53551-text-area-submiting/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.