Ad:

HTML and CSS Discussion Thread
Unsolved
Views: 543

Jul 14th, 2009

problem with $_post

Expand Post »

I have a form which takes a string from a database and posts it to another page problem is that post seems to be shortening the variable.

So if post should be "product name" it is shortened to "product" by post I think.

Any help would be great thanks.

Similar Threads

$PHP_SELF within html form question in PHP
updating multiple columns in single MySQL table in PHP
serch text file in PHP
Problem with $_POST in PHP
PHP sessions/$_POST problem. Too Stressed today! in PHP

bjg5858

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Nov 2007

Permalink

Jul 15th, 2009

Re: problem with $_post

Hi there,
Is "product name" the name of the input box & post variable or is that the value of the variable/text in the input box?

Menster

Reputation Points: 49

Solved Threads: 22

Junior Poster

Offline

175 posts
since Jun 2009

Permalink

Jul 15th, 2009

Re: problem with $_post

Here is the real code "product name" was just an example.
This is the part of the input form;

HTML and CSS Syntax (Toggle Plain Text)
echo "<select name='type'>";
include("mysql_conn.php");
include("db_conn.php");
 
// Get a specific result from the "type" table
$result = mysql_query("SELECT * FROM type") or die(mysql_error());
 
while($row = mysql_fetch_array( $result )) {
$type = $row['type'];
echo  "<option value=$type>$type</option>";
}
echo "</select>";
echo "<select name='type'>";
include("mysql_conn.php");
include("db_conn.php");

// Get a specific result from the "type" table
$result = mysql_query("SELECT * FROM type") or die(mysql_error());

while($row = mysql_fetch_array( $result )) {
$type = $row['type'];
echo  "<option value=$type>$type</option>";
}
echo "</select>";

Here is a some code from the processing form which adds user input to the database;

HTML and CSS Syntax (Toggle Plain Text)

$prod_type = $_POST['type'];
 
$qry = "INSERT INTO products(prod_name, prod_desc, prod_skincond, prod_application, prod_benefits, prod_type, prod_price, prod_img, prod_size, prod_code) VALUES('$prod_name','$prod_desc','$prod_skincond','$prod_application','$prod_benefits','$prod_type','$prod_price','$img','$prod_size','$prod_code')";
$result = @mysql_query($qry);

bjg5858

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Nov 2007

Permalink

Jul 15th, 2009

Re: problem with $_post

Click to Expand / Collapse Quote originally posted by bjg5858 ...

HTML and CSS Syntax (Toggle Plain Text)
echo "<select name='type'>";
include("mysql_conn.php");
include("db_conn.php");
 
// Get a specific result from the "type" table
$result = mysql_query("SELECT * FROM type") or die(mysql_error());
 
while($row = mysql_fetch_array( $result )) {
$type = $row['type'];
echo  "<option value=$type>$type</option>";
}
echo "</select>";
echo "<select name='type'>"; include("mysql_conn.php"); include("db_conn.php"); // Get a specific result from the "type" table $result = mysql_query("SELECT * FROM type") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $type = $row['type']; echo "<option value=$type>$type</option>"; } echo "</select>";

I think the problem might be here, try enclosing the value attribute for the select statement in quotes:

php Syntax (Toggle Plain Text)
while($row = mysql_fetch_array( $result )) {
$type = $row['type'];
echo  "<option value=\"$type\">$type</option>";
}
while($row = mysql_fetch_array( $result )) {
$type = $row['type'];
echo  "<option value=\"$type\">$type</option>";
}

Another thing you can try is, on the page that you post this form to, at the top:

php Syntax (Toggle Plain Text)
echo "<pre>";
print_r($_POST);
echo "</pre>";
die();
echo "<pre>";
print_r($_POST);
echo "</pre>";
die();

Which will tell exactly what is coming through from your form.

Menster

Reputation Points: 49

Solved Threads: 22

Junior Poster

Offline

175 posts
since Jun 2009

Permalink

Jul 15th, 2009

Re: problem with $_post

All variables have a limit on the legth of values it can hold. If you are using Joomla or another CMS then often restrictions are placed and you can only post values using the methods designated in the API.

kronikmedia

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

65 posts
since May 2008

Permalink

Jul 16th, 2009

Re: problem with $_post

Thanks Menster Adding the quotes fixed the problem.

bjg5858

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

10 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in HTML and CSS Forum Timeline: Create fields using <option> tags

Next Thread in HTML and CSS Forum Timeline: how do thay get twitter id to show up in link?

DaniWeb Message

Cancel Changes

User Name
Password