data insert problem in sql

Question

arctushar 0 Junior Poster in Training

13 Years Ago

Hi
I have a database which has a table named main and a field named description
typ of description is longtext
I can insert more than 100 word through phpmyadmin. but can't insert through form submit by post method. but Here i can insert 10 word through same form submit.
Even I can use echo with that form field having 100 words but no data is inserting in database. what is the problem

mysql php

Edited 13 Years Ago by arctushar because: n/a

4 Contributors
9 Replies
112 Views
3 Days Discussion Span
Latest Post 13 Years Ago Latest Post by FlashCreations

All 9 Replies

FlashCreations 20 Posting Whiz

13 Years Ago

Limits are based on characters and not by words. Longtext allows for 4GB of characters, so in theory it depends on how long your words are. It is possible to have ten words that contain more characters than 100 words. But I doubt this is the case. Some possible limitations could be fontend scripts, backend trimming, and/or server limitations.
It would really help to see some code. As a rule, I would always post some relevant code unless your question involves theory.

Pirion1 0 Newbie Poster

13 Years Ago

The problem is that you are not preparing the text for a SQL entry, so that apostrophe is editing the query that you are sending.

You can look up mysql_real_escape_string()[mysql recommended] or addslashes()[for non-specific databases] functions to resolve this issue.

Edited 13 Years Ago by Pirion1 because: n/a

FlashCreations 20 Posting Whiz

13 Years Ago

mysql_real_escape_string() should be applied to any user generated content passed to MySQL to prevent SQL injections, but has no bearing on the limits on the text submitted (other than escaping characters).
The first thought that comes to mind is you aren't viewing the entire field. Try querying the DB, selecting the field, and outputting the description with PHP after inserting your description with your script. PhpMyAdmin never displays all the text if it exceeds a certain length. Usually you have to view the record individually to see the entire value of a long text field. When PhpMyAdmin truncates text, I believe it adds '...' after it to denote the truncation, but don't hold me to that.
Grab the description with PHP after inserting to verify, but I believe all the text will be there.

EDIT
Sample of using mysql_real_escape_string() to protect yourself from SQL injections, a dangerous hack that can expose and compromise data:

mysql_query("SELECT * FROM users WHERE username='".mysql_real_escape_string($_POST['username'])."' AND id='".mysql_real_escape_string($_POST['id')."'");

To grab the description, use the following:

//Conect to MySQL
//Then grab all the descriptions
$result = mysql_query("SELECT description FROM shortitem");
while($data = mysql_fetch_array($result)) {
echo $data['description']."<br>\n";
}

Edited 13 Years Ago by FlashCreations because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

arctushar 0 Junior Poster in Training · Answer 1 · 2010-08-25T08:14:49+00:00

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
  <title>Hello!</title>
</head>

<body>
<form name="insertitem" action="index.php" target="_self" method="post">
 Insert Serial <input type="text" name="serial" /> <p></p>

 Insert Description  <textarea name="description" cols="100" rows="10"></textarea> <p></p>
 Insert unit <input type="text" name="unit" /> <p></p>
 Insert price <input type="text" name="price" /> <p></p>
 <input type="submit" />
</form>
<?php
$description= $_POST['description'];
$con = mysql_connect("localhost","root","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("pwd", $con);

mysql_query("INSERT INTO shortitem (serial, description, unit, price)
VALUES ('$_POST[serial]', '$description','$_POST[unit]','$_POST[price]')");

mysql_close($con);
?>

</body>

</html>

my description input box value is Erect and remove semi-permanent engineer's site office (minimum 15 sqm plinth area) with required facilities including providing furniture, first-aid box, safety helmet, level/theodolite etc.
Erect and remove semi-permanent engineer's site office (minimum 38 sqm plinth area) with requied facilities including security fencing and providing furniture, first-aid box, safety helmet, level/theodolite facilities, 5-Kva stand-bye Generator etc.
Erect and remove semi-permanent Engineer's Site Office (minimum 38 sqm plinth area) with required facilities including providing furniture, first-aid box, safety helmet, level/theodolite facilities, 5-Kva stand-bye Generator etc.security fencing, PC with monitor, Laserjet Printer, UPS etc.
its not inserting but echo is ok

but when I submit Erect and remove semi-permanent engineer's site then it work well.

arctushar 0 Junior Poster in Training · Answer 2 · 2010-08-25T09:02:31+00:00

The problem is that you are not preparing the text for a SQL entry, so that apostrophe is editing the query that you are sending.
You can look up mysql_real_escape_string()[mysql recommended] or addslashes()[for non-specific databases] functions to resolve this issue.

thank u sir. I m new in php. would u plz give me detail. I mean edited version of my above code.

arctushar 0 Junior Poster in Training · Answer 3 · 2010-08-27T22:07:01+00:00

arctushar 0 Junior Poster in Training

13 Years Ago

thank u. My problem is solved.

dsd_inc123 -2 Newbie Poster · Answer 4 · 2010-08-28T00:22:53+00:00

Hi
I have a database which has a table named main and a field named description
typ of description is longtext
I can insert more than 100 word through phpmyadmin. but can't insert through form submit by post method. but Here i can insert 10 word through same form submit.
Even I can use echo with that form field having 100 words but no data is inserting in database. what is the problem

what form field are you using in the form to input data? please check if that field is not limited length or not...

FlashCreations 20 Posting Whiz · Answer 5 · 2010-08-28T00:54:44+00:00

Great! Please make sure to mark this thread as solved so other users know you don't require further assistance. Thanks :)

FlashCreations 20 Posting Whiz · Answer 6 · 2010-08-28T19:19:00+00:00

The limits are based on characters and not with words. LongText allows 4GB of characters, so in theory it depends on how long your words are. It is possible to have ten words that contain characters more than 100 words. But I doubt it is. Some possible restrictions could fontend backend script trimming and / or server limitations.

This sounds awfully familiar, almost like this was a post I wrote. In fact it is (the first post in this thread after the author's post).

"Limits are based on characters and not by words. Longtext allows for 4GB of characters, so in theory it depends on how long your words are. It is possible to have ten words that contain more characters than 100 words. But I doubt this is the case. Some possible limitations could be fontend scripts, backend trimming, and/or server limitations.
It would really help to see some code. As a rule, I would always post some relevant code unless your question involves theory."

Besides the thread is already solved, garryamin. Maybe you can contribute to another thread.

data insert problem in sql

Recommended Answers Collapse Answers

All 9 Replies

Recommended Answers