PHP-script driller
Hej, jeg har dette lange script som indsætter data i en tabel, men det giver mig følgende fejl:You have an error in your SQL syntax near '-mail, cpr_number, sex, picture, data_pub, transport, smoking, dep_connect, resp' at line 1
Og scriptet er her:
<?php require_once('../Connections/afx.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 = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO temp (name, rfid_id, street, postnumber, city, country, telephone, mobile, fax, e-mail, cpr_number, sex, picture, data_pub, transport, smoking, dep_connect, resp_contact, active_inactive, geografi_work, work_areas, notes, `union`, a_box) 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)",
GetSQLValueString($HTTP_POST_VARS['name'], "text"),
GetSQLValueString($HTTP_POST_VARS['rfid_id'], "text"),
GetSQLValueString($HTTP_POST_VARS['street'], "text"),
GetSQLValueString($HTTP_POST_VARS['postnumber'], "text"),
GetSQLValueString($HTTP_POST_VARS['city'], "text"),
GetSQLValueString($HTTP_POST_VARS['country'], "text"),
GetSQLValueString($HTTP_POST_VARS['telephone'], "text"),
GetSQLValueString($HTTP_POST_VARS['mobile'], "text"),
GetSQLValueString($HTTP_POST_VARS['fax'], "text"),
GetSQLValueString($HTTP_POST_VARS['email'], "text"),
GetSQLValueString($HTTP_POST_VARS['cpr_number'], "text"),
GetSQLValueString($HTTP_POST_VARS['sex'], "text"),
GetSQLValueString($HTTP_POST_VARS['picture'], "text"),
GetSQLValueString($HTTP_POST_VARS['data_pub'], "date"),
GetSQLValueString($HTTP_POST_VARS['transport'], "text"),
GetSQLValueString($HTTP_POST_VARS['smoking'], "text"),
GetSQLValueString($HTTP_POST_VARS['dep_connect'], "text"),
GetSQLValueString($HTTP_POST_VARS['resp_contact'], "text"),
GetSQLValueString($HTTP_POST_VARS['active_inactive'], "text"),
GetSQLValueString($HTTP_POST_VARS['geografi_work'], "text"),
GetSQLValueString($HTTP_POST_VARS['work_areas'], "text"),
GetSQLValueString($HTTP_POST_VARS['notes'], "text"),
GetSQLValueString($HTTP_POST_VARS['union'], "text"),
GetSQLValueString($HTTP_POST_VARS['a_box'], "text"));
mysql_select_db($database_afx, $afx);
$Result1 = mysql_query($insertSQL, $afx) or die(mysql_error());
$insertGoTo = "temp.php";
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<html>
<head>
<title>newtemp</title>
<link href="/css/greenstyle2.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
<p align="left"><strong><font size="4"><em>Tilføj ny medarbejder:</em></font></strong></p>
<table align="left">
<tr valign="baseline">
<td width="106" height="23" align="right" nowrap>
<div align="left">Navn:</div></td>
<td colspan="2"><input name="name" type="text" value="" size="60" maxlength="50"></td>
</tr>
<tr valign="baseline">
<td align="right" nowrap><div align="left">Adresse:</div></td>
<td colspan="2"><input name="street" type="text" value="" size="60" maxlength="50"></td>
</tr>
<tr valign="baseline">
<td height="25" align="right" nowrap>
<div align="left">Postnr./by:</div></td>
<td width="118"><input name="postnumber" type="text" value="" size="6" maxlength="4"></td>
<td width="279"><input name="city" type="text" value="" size="40" maxlength="40"></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<table width="69%" border="0">
<tr>
<td width="15%">Land:</td>
<td width="27%"><input name="country" type="text" value="" size="20" maxlength="20"></td>
<td width="24%">Cpr-nummer:</td>
<td width="34%"><input name="cpr_number" type="text" value="" size="12" maxlength="12"></td>
</tr>
<tr>
<td>Telefon:</td>
<td><input name="telephone" type="text" value="" size="12" maxlength="12"></td>
<td>Mobiltelefon:</td>
<td><input name="mobile" type="text" value="" size="12" maxlength="12"></td>
</tr>
<tr>
<td>Fax:</td>
<td><input name="fax" type="text" value="" size="12" maxlength="12"></td>
<td>E-mail:</td>
<td><input name="e-mail" type="text" id="e-mail" value="" size="30" maxlength="50"></td>
</tr>
<tr>
<td>Køn:</td>
<td><select name="sex" id="sex">
<option value="mand">Mand</option>
<option value="kvinde">Kvinde</option>
</select></td>
<td>Upload billede:</td>
<td><input type="text" name="picture" value="" size="30"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Transport:</td>
<td><select name="select">
<option value="Bus/tog">Bus/tog</option>
<option value="Cykel">Cykel</option>
<option value="Bil/mortorcykel">Bil/motorcykel</option>
</select></td>
<td>Ryger:</td>
<td><select name="smoking">
<option value="no" >Nej</option>
<option value="yes" >Ja</option>
</select></td>
</tr>
<tr>
<td>Geografiske arbejdsområder:</td>
<td><input name="geografi_work" type="text" value="" size="25" maxlength="30"></td>
<td>Arbejdsområder:</td>
<td><input name="work_areas" type="text" value="" size="25" maxlength="25"></td>
</tr>
<tr>
<td>Tilknyttet afdeling:</td>
<td><input name="dep_connect" type="text" value="Odense" size="25" maxlength="25"></td>
<td>Rfid-id:</td>
<td><input name="rfid_id" type="text" value="" size="25" maxlength="25"></td>
</tr>
<tr>
<td>Afdelingskontakt:</td>
<td><input name="resp_contact" type="text" value="" size="25" maxlength="25"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Fagforening:</td>
<td><input name="union" type="text" value="" size="35" maxlength="40"></td>
<td>A-kasse:</td>
<td><input name="a_box" type="text" value="" size="35" maxlength="40"></td>
</tr>
<tr>
<td>Aktiv/inaktiv:</td>
<td><select name="active_inactive">
<option value="yes" >Ja</option>
<option value="no" >Nej</option>
</select></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Noter:</td>
<td colspan="3"><textarea name="notes" cols="100" rows="3"></textarea></td>
</tr>
<tr>
<td> </td>
<td colspan="3"> </td>
</tr>
<tr>
<td> </td>
<td colspan="3"> <div align="center">
<input name="submit" type="submit" value="Tilføj medarbejder">
</div></td>
</tr>
</table>
<input type="hidden" name="data_pub" value="">
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
</body>
</html>
Er der nogen som lige ved...
