Alidad Posted April 24, 2008 Share Posted April 24, 2008 yes i can wait to read your article that would help me to understand. at the mean time maybe you can help me with one line code that got into error. please code <?php require_once('../Connections/emailtest.php'); ?> <?php $confirm_code=md5(uniqid(rand())); function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; 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"] == "form1")) { $insertSQL = sprintf("INSERT INTO temp_members_db (confirm_code, name, email, password, country) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_POST['confirm_code'], "text"), GetSQLValueString($_POST['name'], "text"), GetSQLValueString($_POST['email'], "text"), GetSQLValueString($_POST['password'], "text"), GetSQLValueString($_POST['country'], "text")); mysql_select_db($database_emailtest, $emailtest); $Result1 = mysql_query($insertSQL, $emailtest) or die(mysql_error()); $insertGoTo = "../IsNotWorking.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } ?> I'm having trouble to insert confirm_code into the databse, as you can see on the top of code where it said $confirm_code=md5(uniqid(rand())) that suppose to be insert the code number but i could not figure out why is not working! Any idea that you can help me! AM Quote Link to comment Share on other sites More sharing options...
jonsjava Posted April 24, 2008 Share Posted April 24, 2008 you never use $confirm_code in your sql. It is never called in your script. Quote Link to comment Share on other sites More sharing options...
Alidad Posted April 24, 2008 Author Share Posted April 24, 2008 thank you for your help i have fixed that by puting GetSQLValueString('$confirm_code', "text"), instead of GetSQLValueString($_POST['confirm_code'], "text"), but when i tested that and i checked in mysql database is showing word "$confirm_code" instead of confirm code number. What did i missed! AM Quote Link to comment Share on other sites More sharing options...
Alidad Posted April 24, 2008 Author Share Posted April 24, 2008 yes i have solved this probme thanks guys. AM Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.