Form data to MySql

Hello everyone,

I hope somebody can help me. I have an online form which directs to a confirmation page then to a thank you page after a new member completes the information needed. This is in the format of PHP.

Email is then sent to the new member and to me about the new member's information.

Here is the problem, the data collected in the online form does not save to the MySql database located in the host server.

I must have made a mistake somewhere.

Please advise.

Best regards,

Mike

Would need some code to look at. Stripped of passwords etc of course if any.

__________________
The internet is just a fad.
http://www.mevans76.com

Here is the code from the confirmation page....


<?php require_once('Connections/connPNAUK.php'); ?>
<?php
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 information (SURNAME, FIRSTNAME, EMAIL, MIDDLENAME, DOB, MEMBER_CATEGORY, PNA_UK_EXPIRY, ADDRESS1, TOWN, COUNTY, POSTCODE, MOBILE_NUMBER, LANDLINE, UNIVERSITY, YEAR_GRAD, HIGHEST_EDUC, PRC_NUMBER, PRC_EXPIRY, BENEFICIARY, RELATIONSHIP, BENEFICIARY_ADDRESS, BENEFICIARY_CONTACT, HOSPITAL_OF_WORK, AREA_OF_WORK, `POSITION`, WORK_ADDRESS) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['surname'], "text"),
GetSQLValueString($_POST['firstname'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['middlename'], "text"),
GetSQLValueString($_POST['dob'], "text"),
GetSQLValueString($_POST['membership'], "text"),
GetSQLValueString($_POST['PNA_UK_EXPIRY'], "text"),
GetSQLValueString($_POST['address'], "text"),
GetSQLValueString($_POST['townI'], "text"),
GetSQLValueString($_POST['county'], "text"),
GetSQLValueString($_POST['postcode'], "text"),
GetSQLValueString($_POST['mobile1'], "text"),
GetSQLValueString($_POST['mobile2'], "text"),
GetSQLValueString($_POST['university'], "text"),
GetSQLValueString($_POST['yeargrad'], "text"),
GetSQLValueString($_POST['educationI'], "text"),
GetSQLValueString($_POST['prcid'], "text"),
GetSQLValueString($_POST['prcexpiry'], "text"),
GetSQLValueString($_POST['nok'], "text"),
GetSQLValueString($_POST['relationship'], "text"),
GetSQLValueString($_POST['nokaddress'], "text"),
GetSQLValueString($_POST['nokcontactnumber'], "text"),
GetSQLValueString($_POST['employer'], "text"),
GetSQLValueString($_POST['areaofwork'], "text"),
GetSQLValueString($_POST['position'], "text"),
GetSQLValueString($_POST['employeraddress'], "text"));
mysql_select_db($database_connPNAUK, $connPNAUK);
$Result1 = mysql_query($insertSQL, $connPNAUK) or die(mysql_error());
$insertGoTo = "thankyou.php";


if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
$exp_dt_func = mktime(0, 0, 0, date("m"), date("d"), date("y")+1);
$exp_dt = date("d-M-y", $exp_dt_func);
?>

another code which is supposed to write to the mysql...


<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connPNAUK = "mysql8.streamline.net";
$database_connPNAUK = "databasname";
$table_connPNAUK = "tablename";
$username_connPNAUK = "username";
$password_connPNAUK = "password";
$connPNAUK = mysql_connect ("mysql8.streamline.net","databasename","password" ) or trigger_error(mysql_error(),E_USER_ERROR);
?>