HTML and CSS

problem with $_post

Please support our HTML and CSS advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 10

Reputation: bjg5858 is an unknown quantity at this point

Solved Threads: 0

bjg5858

Offline

Newbie Poster

problem with $_post

Jul 14th, 2009

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.

•

Join Date: Jun 2009

Posts: 172

Reputation: Menster is an unknown quantity at this point

Solved Threads: 22

Menster

Offline

Junior Poster

Re: problem with $_post

Jul 15th, 2009

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?

$me = new Person();
if (isset($_COOKIE)){
$me->eat($_COOKIE);
} else { $me->starve(); }

•

Join Date: Nov 2007

Posts: 10

Reputation: bjg5858 is an unknown quantity at this point

Solved Threads: 0

bjg5858

Offline

Newbie Poster

Re: problem with $_post

Jul 15th, 2009

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

 Help with Code Tags 
 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;

Help with Code Tags

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);

•

Join Date: Jun 2009

Posts: 172

Reputation: Menster is an unknown quantity at this point

Solved Threads: 22

Menster

Offline

Junior Poster

Re: problem with $_post

Jul 15th, 2009

•

Originally Posted by bjg5858

Help with Code Tags

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:

 Help with Code Tags 
 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:

 Help with Code Tags 
 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.

$me = new Person();
if (isset($_COOKIE)){
$me->eat($_COOKIE);
} else { $me->starve(); }

•

Join Date: May 2008

Posts: 66

Reputation: kronikmedia is an unknown quantity at this point

Solved Threads: 1

kronikmedia kronikmedia is offline

Offline

Junior Poster in Training

Re: problem with $_post

Jul 15th, 2009

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.

Kronik Media: Web design Company in London, UK.

Our Websites:
Estate Agent Website
Search engine marketing & eCommerce Resources for business