Hi,
To give you all an idea, i have a script named editform01.php that first
displays the data in a table. ThenI have this link called "Edit" in which it
goes to another script called editform02.php which is where the data is
displayed and then you can edit it there. My problem is I cannot proceed to
the other script editform02.php because it gives me the error "Request URI
Too Large", this only appears whenever I have a big amount of data in one of
my textbox.
Below is my script editform01.php for your reference.
----------------------------------------------------------------------------
-----------
<html>
<head><title>My Database</title>
</head>
<body bgcolor=#ffffff>
<?
mysql_connect(localhost, root, mypassword) or die ("Problem connecting to
DataBase");
$query = "select * from czz";
$result = mysql_db_query("e-bulletin", $query);
if ($result) {
echo "<table width=90% align=center border=0><tr>
<td align=center bgcolor=#0099CC><font color=#FFFFFF face=Arial>D a t
e</font></td>
<td align=center bgcolor=#0099CC><font color=#FFFFFF face=Arial>S u b j e c
t</font></td>
<td align=center bgcolor=#0099CC><font color=#FFFFFF face=Arial>P o s t e d
b y</font></td>
<td align=center bgcolor=#FFFFFF></td>
</tr>";
while ($r = mysql_fetch_array($result)) {
$idx = $r["idx"];
$date = $r["date"];
$too = $r["too"];
$subject = $r["subject"];
$carbon = $r["carbon"];
$body = $r["body"];
$postedby = $r["postedby"];
//URL Encode
$idx = urlencode($idx);
$date = urlencode($date);
$too = urlencode($too);
$subject = urlencode($subject);
$carbon = urlencode($carbon);
$body = urlencode($body);
$postedby = urlencode($postedby);
//URL Decode
$date = urldecode($date);
$subject = urldecode($subject);
$carbon = urldecode($carbon);
$postedby = urldecode($postedby);
echo "<tr>
<td bgcolor=lightblue align=center><font face=Arial>$date</font></td>
<td bgcolor=lightblue align=center><font face=Arial>$subject</font></td>
<td bgcolor=lightblue align=center><font face=Arial>$postedby</font></td>
<td bgcolor=lightblue alignt=center><font face=Arial><a
href=\"editform02.php?idx=$idx&date=$date&too=$too&subject=$subject&carbon=$
carbon&body=$body&postedby=$postedby\">Edit</a></font></td>
</tr>";
}
echo "</table>";
} else {
echo "No data.";
}
mysql_free_result($result);
?>
</body>
</html>
Thanks.
Delz
----- Original Message -----
From: "Andreas Frosting" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 09, 2002 10:06 AM
Subject: RE: Request-URI Too Large
> > I'm using php and mysql as my server, when I'm updating a large
> > page on my database using a browser I get
> > "Request-URI Too Large
> > the requested URL's length exceeds the capacity limit for this server.
> > request failed: URI too long"
> > Why is this so? Do I need to adjust something on mysql or my
> > phpscript?
>
> Try putting method="post" in your <form>
>
> I.e:
>
> <form action="foo.php" method="post">
>
> :wq
> //andreas
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
