submit values not working

[irishgirl2004]

hi,
when i submit values to a script, i aint getting them, if i use the following html

     <td align="center" valign="top" width="50%"
            bgcolor="#FFFFFF" marginwidth="12" marginheight="5">

        <input type="text" size="20" name="user_name" >
    </td>
[code=php]


and the following submit

[code=php]
<table border="0" width="100%">
    <tr>
        <td align="center" valign="bottom" width="100%">

        <input type="submit" name="mv_submit" value="Submit">
    </td>
</tr>
</table>
[code=php]

the value $user_name in the script is blank!!!!

but when i do the following, i can set it......

[code=php]
while (list($name, $value) = each($HTTP_POST_VARS)) {
 if ($name == "user_name")
{
$user_name = $value;
}

}


[code=php]



do i have to test for each variable like this????


thanks

[olaf]

Hi,

where is your form-tag?

[irishgirl2004]

hi

i am using this

<form action = "portfolio.php3" method= "POST">

[code=php]


portfolio.php3 does not get the variables........???

[olaf]

first of all try to echo all from-fields in your script...

[irishgirl2004]

yes, when i echo them they are blank

i have to use this to assign them

while (list($name, $value) = each($HTTP_POST_VARS)) { 
if ($name == "user_name") 
{ 
$user_name = $value; 
} 

} 
[code=php]

this is odd, cos it all worked on my older server?? is there a setting i am missing?

[olaf]

Maybe register_globals = off?

check you php config...

[irishgirl2004]

yes, its turned off, is there a quick way to use a substitution to assign the variables?????

i need

while (list($name, $value) = each($HTTP_POST_VARS)) {


need code for here, that will assign each item in $name to be 
 the variable, i.e.

$'$name' = $value;

is this possible?



  }


[code=php]

[olaf]

I'm not sure what you are doing?

[irishgirl2004]

basically, the $HTTP_POST_VARS has aprox 20 items in it, i want to insert these to a database, using an sql i have already written, the sql looks something like this

$sql = "INSERT INTO mdetails (name,haddr,occupation,waddr,hgar,phone,dob,marstatus,regno,mandm,esize,estimate,yom,keptaddr,covwind,owner,rwhynot,altered,ifalter,alarm,immob) VALUES ('$user_name','$haddr','$occupation','$waddr','$hgar','$phone','$dob','$marstatus','$regno','$mandm','$esize','$estimate','$yom','$keptaddr','$covwind','$owner','$rwhynot','$altered','$ifalter','$alarm','$immob')";

[code=php]


so, iin the array, i have user_name, and its value, i need to assign this value to $user_name in the php file , so then i can add to my database................ i think this makes sense? many thanks for your help

[olaf]

I use some modified code from Dreamweaver:

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {
	$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
	switch ($theType) {
    	case "text":
      	$theValue = ($theValue != "") ? "'" . $theValue . "'" : "''";
      	break;    

	    case "int":
    	$theValue = ($theValue != "") ? intval($theValue) : "NULL";
      	break;
	    case "date":
	    $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
	   	break;
	}
  	return $theValue;
}


$insertRec = sprintf("INSERT INTO news (newsId, datum, expDate, titel, subtitel, text1, text2, text3, image1, image2, logo, taal, type, hyperlink) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['newsId'], "int"),
GetSQLValueString($HTTP_POST_VARS['datum'], "date"),
GetSQLValueString($HTTP_POST_VARS['expDate'], "date"),
GetSQLValueString($HTTP_POST_VARS['titel'], "text"),
GetSQLValueString($HTTP_POST_VARS['subtitel'], "text"),
GetSQLValueString(str_replace("\n", "<br>", $HTTP_POST_VARS['text1']), "text"),
GetSQLValueString(str_replace("\n", "<br>", $HTTP_POST_VARS['text2']), "text"),
GetSQLValueString(str_replace("\n", "<br>", $HTTP_POST_VARS['text3']), "text"),
GetSQLValueString(txtConvert($_FILES['image1']['name']), "text"),
GetSQLValueString(txtConvert($_FILES['image2']['name']), "text"),
GetSQLValueString(txtConvert($_FILES['logo']['name']), "text"),
GetSQLValueString($HTTP_POST_VARS['taal'], "text"),
GetSQLValueString($HTTP_POST_VARS['type'], "text"),
GetSQLValueString($HTTP_POST_VARS['hyperlink'], "text"));
mysql_query($insertRec, $conn) or die(mysql_error());

[irishgirl2004]

thanks for that, this all seems like a bit much to do to post info from a form to a database???? is there an easier way???

[lazzy]

the easier way would be to turn your globals on