I can't store in database from my form

**Atli** · Sep 9 '08, 06:18 PM

Hi. Welcome to Bytes!

Exactly how is the code not working?
What isn't it doing that it should be doing?
What is it doing that it shouldn't be doing.

Are you getting any error messages?
How you tried to turn on the debug messages?

Also, use [code] tags when posting code examples.
Please read the Posting Guidelines before posting.

Thank you

**chelvan** · Sep 10 '08, 11:14 AM

why you not trying this syntax for the insert
[code=php]
$sql_ins=mysql_ query("INSERT INTO [table_name] [inserting field names] VALUES ([inserting value])");
[/code]

table_name=your table name;
inserting field names=table colums;
inserting value=your variable;

this above kind syntax worked.
but i'm not sure about your syntax.

regards
chel-1

**nine72** · Sep 10 '08, 06:07 PM

This works for me each time so have stuck with it....

ADD TO YOUR FORM

Code:

<?PHP
	// before your session_start()
	require_once('Connections/connect_to_your_db.php');
	require_once('db_insert/insert_form_data.php');
?>

<form method="POST" name="name_of_form" action="<?php echo $editFormAction; ?>">
<input type="hidden" name="MM_insert" value="name_of_form">
</form>

Create the include_once file insert_form_dat a.php...
[PHP]
<?PHP

session_start() ;

require_once('. ./../Connections/your_db_connect ion_page.php');

if (!function_exis ts("GetSQLValue String")) {
function GetSQLValueStri ng($theValue, $theType, $theDefinedValu e = "", $theNotDefinedV alue = "")
{
$theValue = get_magic_quote s_gpc() ? stripslashes($t heValue) : $theValue;

$theValue = function_exists ("mysql_real_es cape_string") ? mysql_real_esca pe_string($theV alue) : mysql_escape_st ring($theValue) ;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValu e) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theV alue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValu e : $theNotDefinedV alue;
break;
}
return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_ SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "name_of_form") ) {
$insertSQL = sprintf("INSERT INTO fe (eponumsyzygval , eponumpatrval, onomval, onomsyzygval, onompatrval, epaggelval, epaggelsyzygval , imergenval, toposkatagval, asfalistorgval, ap_ast_tayt, dieythval, til1val, til2val) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueStri ng($_POST['eponumsyzygval '], "text"),
GetSQLValueStri ng($_POST['eponumpatrval'], "text"),
GetSQLValueStri ng($_POST['onomval'], "text"),
GetSQLValueStri ng($_POST['onomsyzygval'], "text"),
GetSQLValueStri ng($_POST['onompatrval'], "text"),
GetSQLValueStri ng($_POST['epaggelval'], "text"),
GetSQLValueStri ng($_POST['epaggelsyzygva l'], "text"),
GetSQLValueStri ng($_POST['imergenval'], "text"),
GetSQLValueStri ng($_POST['toposkatagval'], "text"),
GetSQLValueStri ng($_POST['asfalistorgval '], "text"),
GetSQLValueStri ng($_POST['ap_ast_tayt'], "text"),
GetSQLValueStri ng($_POST['dieythval'], "text"),
GetSQLValueStri ng($_POST['til1val'], "text"),
GetSQLValueStri ng($_POST['til2val'], "text")
);

mysql_select_db ($database_your db, $yourdb);
$Result1 = mysql_query($in sertSQL, $yourdb) or die(mysql_error ());

$insertGoTo = "page_to_go_to_ after_insert.ph p"; //redirect page name
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insert GoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf( "Location: %s", $insertGoTo));
}

?>
[/PHP]

I know it is long, but has never faild to do just what I am asking it to do....

nine72

**elen** · Sep 14 '08, 03:20 PM

thank you nine 72 for your help :-)

I can't store in database from my form

I can't store in database from my form

Comment

Comment

Comment

Comment