[RESOLVED] MYSQL TEXT Value issue

jfleck25

My text form only allows 255 characters however I am using a blank valued TEXT field. How can I make it more like 1000 characters long. Having problems...

bradgrafelman

What is limiting your form to 255 characters?

dalecosp

I might think about using TEXTAREA if I needed that much text. It could obviously be styled to look as you wish ...

johanafm

jfleck25;11035471 wrote:
My text form only allows 255 characters however I am using a blank valued TEXT field. How can I make it more like 1000 characters long. Having problems...

If by "text form" you mean when you input data in the form text field, then it's handled by the maxsize attribute of the text input element. But I agree with dalecosp that a textarea is far better suited for that much text.

However, you might just as well hit your limit in several other places, and it's completely unclear what part you may be referring to. Considering that you are posting in a database forum and set the thread title to "MYSQL TEXT value issue", perhaps you are actually talking about your db schema and the text datatype. You may very well try to store the string in a text field, while it can't be called "blank valued" if you actually try storing anything in it… If this is what you're referring to, then mysql 5.6 manual - storage requirements will tell you how much can be stored using what data types.

jfleck25

[PHP<textarea name="aboutme" cols="70" rows="10" id="aboutme"><?php echo "$aboutme"; ?></textarea><br><input name="Submit" type="submit" value="Submit About Me" />
<br><br><br>[/code] Is the form, it goes to my database which is set to TEXT type on mysql. What is the issue? It's still limiting to 255.

Weedpacket

Huh. 255 characters is the limit for TINYTEXT; TEXT should be allowing 65535.

Is anything done to the submitted value before it is inserted into the database?

jfleck25

Is it the fact that the form is textarea>?

jfleck25

<textarea name="aboutme" cols="70" rows="10" id="aboutme"><?php echo "$aboutme"; ?></textarea><br><input name="Submit" type="submit" value="Submit About Me" />
<br><br><br>

dalecosp

No, TEXTAREA is simply an HTML form element, and should be included in POST.

To check that it's being passed to the handler, do a "print_r($_POST);exit;" at the top and check the output.

What the others are asking about is the data type in the database. Do you have access to the DB, other than through PHP?

We'd be looking for "describe $tablename", or a description that you get when you look at "structure" in PHPMyAdmin ... or similar.

Weedpacket

For the sake of gathering more information, you can also use the browser's debugger to examine the POST request it's sending to the server.

jfleck25

dalecosp;11035541 wrote:
No, TEXTAREA is simply an HTML form element, and should be included in POST.

To check that it's being passed to the handler, do a "print_r($_POST);exit;" at the top and check the output.

What the others are asking about is the data type in the database. Do you have access to the DB, other than through PHP?

We'd be looking for "describe $tablename", or a description that you get when you look at "structure" in PHPMyAdmin ... or similar.

$aboutme = $_POST['aboutme']; is my post... What do I need to do to it?

jfleck25

FIXED IT! Just changed to medium text and works great!

bradgrafelman

Sounds like you were using a "TINYTEXT" column and not a "TEXT" column to begin with.

Weedpacket

That's what I suspected, and mentioned. But the guy said "TEXT", so....

dalecosp

Weedpacket;11035561 wrote:
That's what I suspected, and mentioned. But the guy said "TEXT", so....

We really need a LIKE button here ;-)

johanafm

dalecosp;11035577 wrote:
We really need a LIKE button here ;-)

Won't ever happen because noone is able to like your suggestion 😉