form redirect

**Jesdisciple** · 08-06-2008, 02:41 PM

What's the exact error message? The parens look wrong to me, but I can't tell you for sure.

**lord22** · 08-06-2008, 03:30 PM

MY FORM:

PHP Code:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>database first try</title>
</head>

<body>
<form method="post" action="add2.php">
<table>
<tr>
<td>link url:</td>
<td><input name="link_url" type="text" /></td> 
</tr>
<tr>
<td>link name:</td>
<td><input name="link_name" type="text" /></td>
</tr>
<tr>
<td>choose:</td>
<td>
      <select name="selectgrade"> 
        <option value="option_a">A</option> 
        <option value="option_b">B</option> 
        <option value="option_c">C</option> 
        <option value="option_d">D</option> 
      </select>  
</td>
</tr>
</table>
<input type="submit" value="sumbit" />
</form>
</body>
</html>

add2.php:

PHP Code:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>database first try</title>
</head>

<body>
<?php

$connection = mysql_connect("localhost",
                            "XXX",
                            "XXX");
if (!$connection)
  die('Could not connect: ' . mysql_error());

mysql_select_db("XXX", $connection);

$sql="INSERT INTO links (link_url, link_name, selectgrade)
VALUES
('$_POST[link_url]','$_POST[link_name]','$_POST['selectgrade']')";

if (!mysql_query($sql,$connection))
  die('Error: ' . mysql_error());


echo "1 record added";

mysql_close($connection);
?>

</body>
</html>

What I've tried to do is to get the selected value and insert it into a database.

**Jesdisciple** · 08-06-2008, 03:42 PM

Thank you for posting the entire source, but what's the error message?

**lord22** · 08-06-2008, 04:04 PM

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

**Jesdisciple** · 08-06-2008, 04:18 PM

The code you originally said was causing the problem was

Code:

$sql="INSERT INTO grades (selectgrade)
VALUES
('$_POST['selectgrade']')";

But if that line became this

Code:

$sql="INSERT INTO links (link_url, link_name, selectgrade)
VALUES
('$_POST[link_url]','$_POST[link_name]','$_POST['selectgrade']')";

then change it to this

Code:

$sql="INSERT INTO links (link_url, link_name, selectgrade)
VALUES
('{$_POST['link_url']}','{$_POST['link_name']}','{$_POST['selectgrade']}')";

See the second code-section at http://www.php.net/manual/en/languag...string.parsing.

**lord22** · 08-06-2008, 04:40 PM

Hi thank you,
now there are no errors, but still it doesn't insert it in the right way. All the values from the select menu turned into 0 in the database.

**Jesdisciple** · 08-06-2008, 04:49 PM

Try this anywhere in that script and report the output:

Code:

var_dump(isset($_POST['selectgrade']));
var_dump($_POST['selectgrade']);

**motormichael12** · 08-06-2008, 06:16 PM

I think it might have something to do with your single quotes. Here is the way it would be saved.

Code:

$sql="INSERT INTO grades (selectgrade) VALUES ('$_POST['selectgrade']')";

Try this:

Code:

$grade = $_POST['selectgrade'];
$sql="INSERT INTO grades (selectgrade) VALUES ('{$grade}')";

Also as to the problem with changing to 0, make sure that the field in the DB is set to text/varchar and not int.

**lord22** · 08-07-2008, 05:07 AM

Thank you very much!!
Now it is working

Thread: form redirect

Thread Tools

Search Thread

The Following User Says Thank You to Jesdisciple For This Useful Post:

The Following User Says Thank You to motormichael12 For This Useful Post:

Bookmarks

Bookmarks

Posting Permissions