hi guys.
im trying to write a ticketing system and am having really basic issues.
in the past i have been ableto send data to a mysql database, but this with this new project, the database isnt updated. u enter the data in the form, hit the submit button, the text fields empty as if it has sent the data, but when i check the database, there are no new record.
can any one help???
<?
mysql_connect("localhost","root","Hammish1");
mysql_select_db("kraft");
?>
<html><!-- InstanceBegin template="/Templates/Main.php.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<?
mysql_connect("localhost","root","Hammish1");
mysql_select_db("kraft");
To prevent notice warnings on submit pages
error_reporting(E_USER_ERROR|E_USER_WARNING);
?>
</head>
<body bgcolor="#FFFFFF">
<table width="90%" height="100%" border="0">
<tr bgcolor="#9999CC">
<td height="50" colspan="2"><div align="center"><font face="Arial, Helvetica, sans-serif"><strong><font color="#000000" size="+5">Ticketing
System </font></strong></font></div></td>
</tr>
<tr>
<td width="200" align="center" valign="top" bgcolor="#CCCCCC"><p><font face="Arial, Helvetica, sans-serif">
<a href="AddUser.php">Add User</a><br>
<a href="EditUser.php">Edit A User</a><br>
<a href="ticket.php">Sumbit A Ticket</a><br>
</font>
</p>
</td>
<td valign="top"><font face="Arial, Helvetica, sans-serif"><!-- InstanceBeginEditable name="Main" -->
<?
$strsql="INSERT INTO ticket (UserID,Fname,Sname,Contactnumber,Subject,Desc,Prty,Group) VALUES(\"{$POST['UserName']}\",\"{$POST['ForeName']}\",\"{$POST['SurName']}\",\"{$POST['ContactNumber']}\",\"{$POST['Subject']}\",\"{$POST['Description']}\",\"{$POST['Priority']}\",\"{$POST['Group']}\",);";
print("Thankyou. Ticket Submited");
if form submit = no, then show form
?>
<p> </p>
<p> </p>
<form name="form1" method="post" action="">
<table width="70%" border="0" align="left" bgcolor="#DCE4E7">
<tr>
<td height="24" colspan="2" nowraphaha><font color="#990000" size="4" face="Arial, Helvetica, sans-serif"><strong>Submit
a ticket</strong></font></td>
</tr>
<tr>
<td width="16%" nowrap>User Name</td>
<td width="84%" nowrap> <input name="UserName" type="text" id="UserName">
eg (UKABC1)</td>
</tr>
<tr>
<td>Forename </td>
<td> <input name="ForeName" type="text" id="ForeName "> </td>
</tr>
<tr>
<td>Surname </td>
<td> <input name="SurName" type="text" id="SurName"> </td>
</tr>
<tr>
<td>Contact Number</td>
<td> <input name="ContactNumber" type="text" id="ContactNumber"> </td>
</tr>
<tr>
<td colspan="2"><hr></td>
</tr>
<tr align="right">
<td><div align="left">Subject</div></td>
<td><div align="left">
<input name="Subject" type="text" id="Subject">
</div></td>
</tr>
<tr align="right">
<td height="72"><div align="left">Description</div></td>
<td><div align="left">
<textarea name="Description" id="Description"></textarea>
</div></td>
</tr>
<tr align="right">
<td><div align="left">Priority</div></td>
<td><div align="left">
<select name="Priority" id="Priority">
<option>Low</option>
<option>Medium</option>
<option>High</option>
</select>
</div></td>
</tr>
<tr align="right">
<td><div align="left">Group</div></td>
<td><div align="left">
<select name="Group" id="Group">
<option>User Support</option>
<option>Operations</option>
<option>Development</option>
</select>
</div></td>
</tr>
<tr align="right">
<td colspan="2"> <input type="submit" name="Submit" value="Submit">
</td>
</tr>
</table>
<p> </p>
</form>
<p> </p>
<!-- InstanceEndEditable --></font></td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
