Re: [PHP-DB] Re: posting information from a textarea
Ha! I figured the damn thing out! Using the full text type created a bunch of overhead and it wasn't storing it into the table. I realized that I was unsetting the post array before I was doing the print_r so that is why the variables weren't showing up. Then, I finally realized that for some reason, I had to convert the textarea to a utf encoding before I entered it into the database! That was annoying. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: I think I might have found the problem, but I'm not sure how to fix it. I'm just going to rebuild the form and it make it seperate (with all the database calls in one page). For some reason, if I add another field before the motto and i change it, it changes motto too...w/e I'll just make a new one. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: > hmm..interesting. Neither the motto or desc is showing up in the array. > I made a simple form and the > > echo 'post vars: ' . print_r($_POST, true) . ''; > > works fine. I'm just perplexed on why the motto is still working and not > the desc. Maybe it's because I'm using a fieldset, but then why wouldn't > just one not work? > > On 7/6/06, Chris < [EMAIL PROTECTED]> wrote: > > > Dave W wrote: > > > I'll show you all the steps it passes through. > > > Here's the form: > > > > > > > > > > > > Motto: > > > > name="motto" > > > value="value("motto") == ""){ > > >echo $session->nationinfo['motto']; > > > }else{ > > >echo $form->value("motto"); > > > } ?>" /> > > > Nation Description: > > > > > if($form->value("desc") == ""){ > > >echo $session->nationinfo['desc']; > > > }else{ > > >echo $form->value("desc"); > > > } > > > ?> > > > > > > > > > > > > > > > It's echoing the nationinfo right, but its not posting it. The motto > > > also works too. When it's submitted, it goes through the function > > > procEditNation(). > > > > > > $session->editNation($_POST['motto'], $_POST['desc']); > > > > > > The editNation function: > > > > > >function editNation($motto, $desc){ > > > global $database, $form; > > > > > > if($motto){ > > > $field = "motto"; > > > $motto = htmlspecialchars($motto); > > > $database->updateNationField($this->username,"motto",$motto); > > > > > > > > } > > > > > > if($desc){ > > > $field = "desc"; > > > $desc = htmlspecialchars($desc); > > > $database->updateNationField($this->username,"desc",$desc); > > > > > > > > > > > } > > > > > > return true; > > >} > > > > > > Then finally the updateNationField function: > > > > > >function updateNationField($username, $field, $value){ > > > $q = "UPDATE nations SET ".$field." = '$value' WHERE username > > = > > > '$username'"; > > > return mysql_query($q, $this->connection); > > >} > > > > > > I just don't know what's wrong since it's posting the motto (which > > is > > > just a text-type input) and not the description (which is a > > textarea). I > > > echo'd out the mysql queries and excuted them myself from what > > echo'd > > > out and it's selecting the desc column just fine. > > > > That definitely all looks fine. > > > > If you do: > > > > echo 'post vars: ' . print_r($_POST, true) . ''; > > > > does it show up in post at all? > > > > -- > > Postgresql & php tutorials > > http://www.designmagick.com/ > > > > > > -- > Dave W > -- Dave W -- Dave W
Re: [PHP-DB] Re: posting information from a textarea
I think I might have found the problem, but I'm not sure how to fix it. I'm just going to rebuild the form and it make it seperate (with all the database calls in one page). For some reason, if I add another field before the motto and i change it, it changes motto too...w/e I'll just make a new one. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: hmm..interesting. Neither the motto or desc is showing up in the array. I made a simple form and the echo 'post vars: ' . print_r($_POST, true) . ''; works fine. I'm just perplexed on why the motto is still working and not the desc. Maybe it's because I'm using a fieldset, but then why wouldn't just one not work? On 7/6/06, Chris <[EMAIL PROTECTED]> wrote: > Dave W wrote: > > I'll show you all the steps it passes through. > > Here's the form: > > > > > > > > Motto: > > > value="value("motto") == ""){ > >echo $session->nationinfo['motto']; > > }else{ > >echo $form->value("motto"); > > } ?>" /> > > Nation Description: > > > if($form->value("desc") == ""){ > >echo $session->nationinfo['desc']; > > }else{ > >echo $form->value("desc"); > > } > > ?> > > > > > > > > > > It's echoing the nationinfo right, but its not posting it. The motto > > also works too. When it's submitted, it goes through the function > > procEditNation(). > > > > $session->editNation($_POST['motto'], $_POST['desc']); > > > > The editNation function: > > > >function editNation($motto, $desc){ > > global $database, $form; > > > > if($motto){ > > $field = "motto"; > > $motto = htmlspecialchars($motto); > > $database->updateNationField($this->username,"motto",$motto); > > > > > } > > > > if($desc){ > > $field = "desc"; > > $desc = htmlspecialchars($desc); > > $database->updateNationField($this->username,"desc",$desc); > > > > > > } > > > > return true; > >} > > > > Then finally the updateNationField function: > > > >function updateNationField($username, $field, $value){ > > $q = "UPDATE nations SET ".$field." = '$value' WHERE username = > > '$username'"; > > return mysql_query($q, $this->connection); > >} > > > > I just don't know what's wrong since it's posting the motto (which is > > just a text-type input) and not the description (which is a textarea). > I > > echo'd out the mysql queries and excuted them myself from what echo'd > > out and it's selecting the desc column just fine. > > That definitely all looks fine. > > If you do: > > echo 'post vars: ' . print_r($_POST, true) . ''; > > does it show up in post at all? > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > -- Dave W -- Dave W
Re: [PHP-DB] Re: posting information from a textarea
hmm..interesting. Neither the motto or desc is showing up in the array. I made a simple form and the echo 'post vars: ' . print_r($_POST, true) . ''; works fine. I'm just perplexed on why the motto is still working and not the desc. Maybe it's because I'm using a fieldset, but then why wouldn't just one not work? On 7/6/06, Chris <[EMAIL PROTECTED]> wrote: Dave W wrote: > I'll show you all the steps it passes through. > Here's the form: > > > > Motto: > value="value("motto") == ""){ >echo $session->nationinfo['motto']; > }else{ >echo $form->value("motto"); > } ?>" /> > Nation Description: > if($form->value("desc") == ""){ >echo $session->nationinfo['desc']; > }else{ >echo $form->value("desc"); > } > ?> > > > > > It's echoing the nationinfo right, but its not posting it. The motto > also works too. When it's submitted, it goes through the function > procEditNation(). > > $session->editNation($_POST['motto'], $_POST['desc']); > > The editNation function: > >function editNation($motto, $desc){ > global $database, $form; > > if($motto){ > $field = "motto"; > $motto = htmlspecialchars($motto); > $database->updateNationField($this->username,"motto",$motto); > > } > > if($desc){ > $field = "desc"; > $desc = htmlspecialchars($desc); > $database->updateNationField($this->username,"desc",$desc); > > > } > > return true; >} > > Then finally the updateNationField function: > >function updateNationField($username, $field, $value){ > $q = "UPDATE nations SET ".$field." = '$value' WHERE username = > '$username'"; > return mysql_query($q, $this->connection); >} > > I just don't know what's wrong since it's posting the motto (which is > just a text-type input) and not the description (which is a textarea). I > echo'd out the mysql queries and excuted them myself from what echo'd > out and it's selecting the desc column just fine. That definitely all looks fine. If you do: echo 'post vars: ' . print_r($_POST, true) . ''; does it show up in post at all? -- Postgresql & php tutorials http://www.designmagick.com/ -- Dave W
Re: [PHP-DB] Re: posting information from a textarea
Dave W wrote: I'll show you all the steps it passes through. Here's the form: Motto: value="value("motto") == ""){ echo $session->nationinfo['motto']; }else{ echo $form->value("motto"); } ?>" /> Nation Description: value("desc") == ""){ echo $session->nationinfo['desc']; }else{ echo $form->value("desc"); } ?> It's echoing the nationinfo right, but its not posting it. The motto also works too. When it's submitted, it goes through the function procEditNation(). $session->editNation($_POST['motto'], $_POST['desc']); The editNation function: function editNation($motto, $desc){ global $database, $form; if($motto){ $field = "motto"; $motto = htmlspecialchars($motto); $database->updateNationField($this->username,"motto",$motto); } if($desc){ $field = "desc"; $desc = htmlspecialchars($desc); $database->updateNationField($this->username,"desc",$desc); } return true; } Then finally the updateNationField function: function updateNationField($username, $field, $value){ $q = "UPDATE nations SET ".$field." = '$value' WHERE username = '$username'"; return mysql_query($q, $this->connection); } I just don't know what's wrong since it's posting the motto (which is just a text-type input) and not the description (which is a textarea). I echo'd out the mysql queries and excuted them myself from what echo'd out and it's selecting the desc column just fine. That definitely all looks fine. If you do: echo 'post vars: ' . print_r($_POST, true) . ''; does it show up in post at all? -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: posting information from a textarea
I'll show you all the steps it passes through. Here's the form: Motto: nationinfo['motto']; }else{ echo $form->value("motto"); } ?>" /> Nation Description: value("desc") == ""){ echo $session->nationinfo['desc']; }else{ echo $form->value("desc"); } ?> It's echoing the nationinfo right, but its not posting it. The motto also works too. When it's submitted, it goes through the function procEditNation(). $session->editNation($_POST['motto'], $_POST['desc']); The editNation function: function editNation($motto, $desc){ global $database, $form; if($motto){ $field = "motto"; $motto = htmlspecialchars($motto); $database->updateNationField($this->username,"motto",$motto); } if($desc){ $field = "desc"; $desc = htmlspecialchars($desc); $database->updateNationField($this->username,"desc",$desc); } return true; } Then finally the updateNationField function: function updateNationField($username, $field, $value){ $q = "UPDATE nations SET ".$field." = '$value' WHERE username = '$username'"; return mysql_query($q, $this->connection); } I just don't know what's wrong since it's posting the motto (which is just a text-type input) and not the description (which is a textarea). I echo'd out the mysql queries and excuted them myself from what echo'd out and it's selecting the desc column just fine. On 7/6/06, Chris <[EMAIL PROTECTED]> wrote: Dave W wrote: > I saw this bug: http://bugs.php.net/bug.php?id=22427. Could this be related > to problem I'm having? > Actually, show us the form you're trying to submit before doing anything else. Since we haven't seen any html or php code, guessing it's a bug is a bit of a stretch. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Dave W
Re: [PHP-DB] Re: posting information from a textarea
Dave W wrote: I saw this bug: http://bugs.php.net/bug.php?id=22427. Could this be related to problem I'm having? Actually, show us the form you're trying to submit before doing anything else. Since we haven't seen any html or php code, guessing it's a bug is a bit of a stretch. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: posting information from a textarea
Dave W wrote: I saw this bug: http://bugs.php.net/bug.php?id=22427. Could this be related to problem I'm having? Simplify your example and test it, only way to know. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: posting information from a textarea
I saw this bug: http://bugs.php.net/bug.php?id=22427. Could this be related to problem I'm having? On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: O, I also tried to change it to a $_FILES array, but that didn't work either. On 7/6/06, Dave W <[EMAIL PROTECTED] > wrote: > > I seem to be having a problem posting text from a text area. I have a > form that posts data into a database and there are input fields which seem > to post the data fine. I know this because the entry is changing in the > database, but the text area text doesn't seem to be posting. I double > checked to make sure i got the names right, but it still doesn't seem to be > working. Before I put it into the database I'm using stripslashes. I thought > that might of been the problem and I changed it to trim, but that didn't > work. In the database, the field that I'm putting it into is a longtext type > with fulltext. > > -- > Dave W > -- Dave W
[PHP-DB] Re: posting information from a textarea
O, I also tried to change it to a $_FILES array, but that didn't work either. On 7/6/06, Dave W <[EMAIL PROTECTED]> wrote: I seem to be having a problem posting text from a text area. I have a form that posts data into a database and there are input fields which seem to post the data fine. I know this because the entry is changing in the database, but the text area text doesn't seem to be posting. I double checked to make sure i got the names right, but it still doesn't seem to be working. Before I put it into the database I'm using stripslashes. I thought that might of been the problem and I changed it to trim, but that didn't work. In the database, the field that I'm putting it into is a longtext type with fulltext. -- Dave W