Help With Code

[immu]

hey guys i need some help with php forms
i have created a form in such a way that what ever the input is given it shall be stored in db (SQL)
everything works but when i check the DB Table it shows Array in the column like this


Code is

immu Reviewed by immu on 11th Feb 2012. Help With Code hey guys i need some help with php forms i have created a form in such a way that what ever the input is given it shall be stored in db (SQL) everything works but when i check the DB Table it shows Array in the column like this http://img100.imageshack.us/img100/3360/20120211145901.png Code is http://img641.imageshack.us/img641/6476/20120211150122.png Rating: 5

[t3od0r]

you should post the code in php tags

try this for each $_POST

'".mysql_real_escape_string($_POST['wcddl_url'])."' 

[Apathetic]

try

die(var_dump($_POST['wcddl_url'])); 

and see it's output

[immu]

<?php
$con = mysql_connect ("localhost","immuwcddl","immuwcddl");
if (!$con)
{
die('DB ERROR - Could not Connect : ' . mysql_error());
}
mysql_select_db ("wcddlv3test", $con);
$sql="INSERT INTO wcddl_remember(wcddl_url, wcddl_username, wcddl_password) VALUES ('".mysql_real_escape_string($_POST['wcddl_url'])."','".mysql_real_escape_string($_POST['wcddl_username'])."','".mysql_real_escape_string($_POST['wcddl_password'])."')";
if (!mysql_query($sql,$con))
{
die ('ERROR : ' . mysql_error());
}
echo "Details Saved Sucessfully";
mysql_close($con)
?>

thanks for the help with these tags it gives

[soft2050]

Try to replace line 8 [sql query one] with this

$wcddl_url_sql = mysql_real_escape_string($_POST['wcddl_url']);
$wcddl_username_sql = mysql_real_escape_string($_POST['wcddl_username']);
$wcddl_password_sql = mysql_real_escape_string($_POST['wcddl_password']);
$sql = "INSERT INTO wcddl_remember(wcddl_url, wcddl_username, wcddl_password) VALUES ('$wcddl_url_sql', '$wcddl_username_sql', '$wcddl_password_sql')"; 

Problem was in syntax = $_POST[wcddl_url] should be $_POST['wcddl_url']

And its always a good to escape the string

[t3od0r]

use the code that Apathetic gave, it seems that the post return an array

[immu]

thanks for the help soft
Worked
Cheers