|
PHP Code insert into database problem
Can anyone please tell me why my data from my form is not going into my database?? The code looks fine to me but am getting syntax issues
Here Is my Databse:
CREATE DATABASE IF NOT EXISTS dbprofile;
USE dbprofile;
CREATE TABLE tbl_customer_data (photo VARCHAR(30), name VARCHAR(25), age VARCHAR(4), sex VARCHAR(30), sexual_orientation VARCHAR(40), area VARCHAR(50), postcode VARCHAR(20), sexual_interests VARCHAR(45), who_id_like_to_meet VARCHAR(55), about_me VARCHAR(150), what_i_look_like VARCHAR(150), contact_email_address VARCHAR(40));
Below is a couple of my error reports:
C:\\webserver\\Apache2\\htdocs\\sexyencounters\\Pr ofile Creation. php on line 478, referer: http://localhost/sexyencounters/Profile%20Creation.php
[Sat Oct 13 19:19:10 2007] [error] [client 127.0.0.1] PHP Notice: Use of undefined constant whatilooklikeinsert - assumed 'whatilooklikeinsert' in C:\\webserver\\Apache2\\htdocs\\sexyencounters\\Pr ofile Creation. php on line 480, referer: http://localhost/sexyencounters/Profile%20Creation.php
[Sat Oct 13 19:19:10 2007] [error] [client 127.0.0.1] PHP Notice: Use of undefined constant emailinsert - assumed 'emailinsert' in C:\\webserver\\Apache2\\htdocs\\sexyencounters\\Pr ofile Creation. php on line 482, referer: http://localhost/sexyencounters/Profile%20Creation.php
Below is my Code:
- PHP: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Instant Messiging Chat</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<style type="text/css">
<!--
.style1 {color: #FF33CC}
-->
</style>
</head>
<body>
<div id="header">
<h1 class="right"> </h1>
<h1> </h1>
</div>
<ul id="nav">
<li class="right"><input value="Search..." type="text" /></li>
<li><a href="MainPage.php">Main Page</a></li>
<li><a href="Login.php">LogIn</a></li>
<li><a href="admin/Sign Up.php">SignUp</a></li>
<li><a href="Contact.php">Contact</a></li>
</ul>
<div class="clear" />
<div id="sidebar">
<h2>Latest News or Comments</h2>
<p class="news"><a href="#" class="more">Read More »</a> </p>
<p class="news"><a href="#" class="more">Read More »</a> </p>
<p class="news"><a href="#" class="more">Read More »</a> </p>
<h2>Quick Links</h2>
<ul>
<li><a href="index.php">Introduction</a></li>
<li><a href="AboutUs.php">About Us</a></li>
<li><a href="admin/Sign Up.php">SignUp</a></li>
<li><a href="MainPage.php">Main Page</a></li>
</ul>
<h2>Search</h2>
<input name="" type="text" value="Search..." />
</div>
<div id="content">
<h2><a href="#" id="intro"><u>Please Create Your Profile</u></a></h2>
<p>Here you can create your profile for use with our site. The more effort & quality you insert into your profile, the more you enhance your chances of finding "who" your looking for, for "what" your looking for!</p>
<p>Good luck! And remember this is your part of the site, so keep it up to date and accurate to ensure success in your naughty adventures.</p>
<table width="847" height="714" border="0">
<tr>
<td valign="top"><table width="842" height="709" border="1" bordercolor="#FF00FF">
<tr>
<td height="87"><div align="center">
<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','672','height','79','src','Create Profile animation 1/SWFAnimation1','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','Create Profile animation 1/SWFAnimation1' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="672" height="79">
<param name="movie" value="Create Profile animation 1/SWFAnimation1.swf" />
<param name="quality" value="high" />
<embed src="Create Profile animation 1/SWFAnimation1.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="672" height="79"></embed>
</object>
</noscript></div></td>
</tr>
<tr>
<td valign="top"><table width="833" border="0">
<tr>
<td width="400" height="612" valign="top"><form action="" method="post" enctype="multipart/form-data" id="form1">
<p class="style1">Please Upload A Recent Photo Of Yourself</p>
<p>
<label>
<span class="style1">Photo:</span>
<input type="file" name="photo"><br>
</label>
</p>
<p>
<label><span class="style1">Go</span>
<input type="submit" name="uploadimage" id="uploadimage" value="Submit" />
</label>
</p>
<p class="style1">Please Insert Your Name</p>
<p>
<label>
<input type="text" name="nameinsert" id="nameinsert" />
</label>
</p>
<p class="style1">Please Insert Your Age</p>
<p>
<label>
<select name="ageinsert" id="ageinsert">
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
<option>32</option>
<option>33</option>
<option>34</option>
<option>35</option>
<option>36</option>
<option>37</option>
<option>38</option>
<option>39</option>
<option>40</option>
<option>41</option>
<option>42</option>
<option>43</option>
<option>44</option>
<option>45</option>
<option>46</option>
<option>47</option>
<option>48</option>
<option>49</option>
<option>50</option>
<option>51</option>
<option>52</option>
<option>53</option>
<option>54</option>
<option>55</option>
<option>56</option>
<option>57</option>
<option>58</option>
<option>59</option>
<option>60</option>
<option>61</option>
<option>62</option>
<option>63</option>
<option>64</option>
<option>65</option>
<option>66</option>
<option>67</option>
<option>68</option>
<option>69</option>
<option>70</option>
<option>71</option>
<option>72</option>
<option>73</option>
<option>74</option>
<option>75</option>
<option>76</option>
<option>77</option>
<option>78</option>
<option>79</option>
<option>80</option>
<option>81</option>
<option>82</option>
<option>83</option>
<option>84</option>
<option>85</option>
<option>86</option>
<option>87</option>
</select>
</label>
</p>
<p class="style1">Please Input Your Sex</p>
<p>
<label>
<select name="sexinsert" id="sexinsert">
<option>Male</option>
<option>Female</option>
<option>Trans Male</option>
<option>Trans Female</option>
</select>
</label>
</p>
<p class="style1">Please Insert Your Sexual Orientation</p>
<p>
<label>
<select name="Orientationinsert" id="Orientationinsert">
<option>Straight Male</option>
<option>Straight Female</option>
<option>Bi Male</option>
<option>Bi Female</option>
<option>Gay Male</option>
<option>Gay Female</option>
</select>
</label>
</p>
<p class="style1">Please Insert Your Area</p>
<p>
<label>
<select name="areainsert" id="areainsert">
<option>England-Bath Avon</option>
<option>England-Bedforshire</option>
<option>England-Berkshire</option>
<option>England-Brighton</option>
<option>England-Bristol</option>
<option>England-Buckinghamshire</option>
<option>England-Cambridgeshire</option>
<option>England-Channel Isles</option>
<option>England-Cheshire</option>
<option>England-Cornwall</option>
<option>England-County Durham</option>
<option>England-Cumbria</option>
<option>England-Derbyshire</option>
<option>England-Devon</option>
<option>England-Dorset</option>
<option>England-Essex</option>
<option>England-Gloucestershire</option>
<option>England-Hampshire</option>
<option>England-Herefordshire</option>
<option>England-Huntingdonshire</option>
<option>England-Isle Of White</option>
<option>England-Isle Of Sily</option>
<option>England-Kent</option>
<option>England-Lancashire</option>
<option>England-Leicestershire</option>
<option>England-Lincolnshire</option>
<option>England-London</option>
<option>England-Manchester</option>
<option>England-Merseyside</option>
<option>England-Middlesex</option>
<option>England-Norfolk</option>
<option>England-Northamptonshire</option>
<option>England-Northumberland</option>
<option>England-Nottinghamshire</option>
<option>England-Oxfordshire</option>
<option>England-Rutland</option>
<option>England-Shropshire</option>
<option>England-Somerset</option>
<option>England-Staffordshire</option>
<option>England-Suffolk</option>
<option>England-Surrey</option>
<option>England-Sussex</option>
<option>England-Tyne & Wear</option>
<option>England-Warwickshire</option>
<option>England-West midlands</option>
<option>England-Westmorland</option>
<option>England-Wiltshire</option>
<option>England-Worcestershire</option>
<option>England-Yorkshire</option>
<option>Isle Of Man</option>
<option>N Ireland-Artrim</option>
<option>N Ireland-Amagh</option>
<option>N Ireland-Bellfast</option>
<option>N Ireland-Down</option>
<option>N-Ireland-Femanagh</option>
<option>N-Ireland-Londondery</option>
<option>N-Ireland-Tyrone</option>
<option>Scotland-Aberdeenshire</option>
<option>Scotland-Angus</option>
<option>Scotland-Argylshire</option>
<option>Scotland-Ayrshire</option>
<option>Scotland-Banffshire</option>
<option>Scotland-Berwicshire</option>
<option>Scotland-Buteshire</option>
<option>Scotland-Caithness</option>
<option>Scotland-Clackmannanshire</option>
<option>Scotland-Dumfriesshire</option>
<option>Scotland-Dundee city</option>
<option>Scotland-Edinburgh</option>
<option>Scotland-Falkirk</option>
<option>Scotland-Fife</option>
<option>Scotland-Highland</option>
<option>Scotland-Inverness-shire</option>
<option>Scotland-Isle of Islay</option>
<option>Scotland-Isle of Lewis</option>
<option>Scotland-Isle of Skye</option>
<option>Scotland-Kincarineshire</option>
<option>Scotland-Kinross-shire</option>
<option>Scotland-Kirkcudbrightshire</option>
<option>Scotland-Lanarkshire</option>
<option>Scotland-Midlothian</option>
<option>Scotland-Morayshire</option>
<option>Scotland-Naimshire</option>
<option>Scotland-Orkney</option>
<option>Scotland-Peeblesshire</option>
<option>Scotland-Perthshire</option>
<option>Scotland-Renfrewshire</option>
<option>Scotland-Ross-shire</option>
<option>Scotland-Roxburghshire</option>
<option>Scotland-Selkirkshire</option>
<option>Scotland-Shetland</option>
<option>Scotland-Sterlingshire</option>
<option>Scotland-Sutherland</option>
<option>Scotland-West Lothiann</option>
<option>Scotland-Western Isles</option>
<option>Scotland-Wigtownshire</option>
<option>Wales-Anglesey</option>
<option>Wales-Brecknockshire</option>
<option>Wales-Caemarfonshire</option>
<option>Wales-Cardiff</option>
<option>Wales-Cardiganshire</option>
<option>Wales-Carmarthenshire</option>
<option>Wales-Ceredigion</option>
<option>Wales-Denbighshire</option>
<option>Wales-Flintshire</option>
<option>Wales-Glamorgan</option>
<option>Wales-Gwynedd</option>
<option>Wales-Merioneth</option>
<option>Wales-Monmouthshire</option>
<option>Wales-Montgomeryshire</option>
<option>Wales-Newport</option>
<option>Wales-Pembrokeshire</option>
<option>Wales-Radnorshire</option>
<option>Wales-Swansea</option>
</select>
</label>
</p>
<p class="style1">Please Insert Your Postcode (Capitals Only)</p>
<p>
<label>
<input type="text" name="postcodeinsert" id="postcodeinsert" />
</label>
</p>
<p class="style1">Please Input Your Sexual Interests</p>
<p>
<label>
<select name="interestsinsert" id="interestsinsert">
<option>1 on 1 Sexual Discreet Partner</option>
<option>Group Sex</option>
<option>Gay Male</option>
<option>Gay Female</option>
<option>Bi Male</option>
<option>Bi Female</option>
<option>Couples</option>
<option>Transvestite</option>
<option>BDSM\Fetish</option>
</select>
</label>
</p>
<p class="style1">Please Input Who You Would Like To Meet</p>
<p>
<label>
<textarea name="liketomeetinsert" id="liketomeetinsert" cols="45" rows="5"></textarea>
</label>
</p>
<p class="style1">Please Tell Us About Yourself</p>
<p>
<label>
<textarea name="aboutyourselfinsert" id="aboutyourselfinsert" cols="45" rows="5"></textarea>
</label>
</p>
<p class="style1">Please Describe What You Look LIke</p>
<p>
<label>
<textarea name="whatilooklikeinsert" id="whatilooklikeinsert" cols="45" rows="5"></textarea>
</label>
</p>
<p class="style1">Please Input A Discreet Email Address For Other members To Contact You About Your Naughty Interests</p>
<p>
<label>
<input type="text" name="emailinsert" id="emailinsert" />
</label>
</p>
<p>
<label>
<input type="submit" name="button" id="button" value="Submit" />
</label>
</p>
<p class="style1">Remember Keep Your Emails Private &amp; Dont Get Caught Doing Anythink I Wouldnt Do & He He</p>
<p> </p>
</form>
<p> </p>
<p> </p></td>
<td width="210" valign="top"><table width="215" height="279" border="1" bordercolor="#FF00FF">
<tr>
<td> </td>
</tr>
</table></td>
<td width="201"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
</div>
<div id="footer">
<p>Site Design by <a href="http://www.sixshootermedia.com">AJL Online Services Business Developement Specialists</a>.<br />
<!-- you can delete below here -->
© All copyrights reserved.</p>
</div>
</body>
<?php
$target = "images2/";
$target = $target . basename( $_FILES['photo']['name']);
$pic=($_FILES['photo']['name']);
mysql_connect("localhost", "root", "longstand") or die(mysql_error()) ;
mysql_select_db("dbprofile") or die(mysql_error()) ;
mysql_query("INSERT INTO `tbl_customer_data` VALUES ('$name', '$pic')") ;
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {
echo "Sorry Andy There Was A Problem Uploading The File.";
}
?>
</html>
</body>
<?php
$con = mysql_connect("localhost","root","longstand");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("dbprofile", $con);
echo $_POST[nameinsert];
echo "<br />";
echo $_POST[ageinsert];
echo "<br />";
echo $_POST[sexinsert];
echo "<br />";
echo $_POST[Orientationinsert];
echo "<br />";
echo $_POST[areainsert];
echo "<br />";
echo $_POST[postcodeinsert];
echo "<br />";
echo $_POST[interestsinsert];
echo "<br />";
echo $_POST[liketomeetinsert];
echo "<br />";
echo $_POST[aboutyourselfinsert];
echo "<br />";
echo $_POST[whatilooklikeinsert];
echo "<br />";
echo $_POST[emailinsert];
echo "<br />";
$sql="INSERT INTO tbl_customer_data (name, age, sex, sexual_orientation, area, postcode, sexual_interests, who_id_like_to_meet, about_me, what_i_look_like, contact_email_address)
VALUES
('$_POST[nameinsert]','$_POST[ageinsert]'.'$_POST[sexinsert]','$_POST[Orientationinsert]','$_POST[areainsert]','$_POST[postcodeinsert]','$_POST[interestsinsert]','$_POST[liketomeetinsert]','$_POST[aboutyourselfinsert]','$_POST[whatilooklikeinsert]','$_POST[emailinsert]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
mysql_close($con);
?>
</html>
Cheers thanks & good evening 
|