If all the data is in your database, why are you passing it in your
query-string ?!?!?!!?
Why don't you simply pass the idx like:
<a href=\"editform02.php?idx=$idx\"....
Then, in editform02.php you only need to do a
$query = "select * from czz where idx=$idx";
to get your data to edit.
Also, one more note: you encode and after you decode... You must decide
your self! ;-) You can get the results from database, show them while
they are decoded, then encode the data and put the url "Edit".
Hope this helps!
On Sat, 2002-03-09 at 02:52, delz wrote:
> 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
>
--
dsoares
(sql)
---------------------------------------------------------------------
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
