never seen this error before what do i do?

Question

1.00/5 (1 vote)

See more:

im new to html and php and i get this error when i try to test out my sign up page. i feel like im not setting up my html and my php correctly. not to sure like i said

Parse error: syntax error, unexpected '.' in /home/content/25/11427125/html/signup.php on line 35

this is my php file

XML

<?php
include ("dbConfig.php");
if ( $_GET["op"] == "reg" )
 {
 $bInputFlag = false;
 foreach ( $_POST as $field )
  {
  if ($field == "")
   {
   $bInputFlag = false;
   }
  else
   {
   $bInputFlag = true;
   }
  }
 if ($bInputFlag == false)
  {
  die( "Problem with your registration info. "
   ."Please go back and try again.");
  }

 $q = "INSERT INTO `accounts` (`firstname`,`initial`,`lastname`,`email`,`password`,`dob`,`number`,`sex`) "
  ."VALUES ('".$_POST["firstname"]."', "
  ."VALUES ('".$_POST["initial"]."', "
  ."VALUES ('".$_POST["lastname"]."', "
  ."'".$_POST["email"]."')";
  ."PASSWORD('".$_POST["password"]."'), "
  ."VALUES('".$_POST["dob"]."'), "
  ."VALUES('".$_POST["number"]."'), "
  ."VALUES('".$_POST["sex"]."'), "

 $r = mysql_query($q);

 if ( !mysql_insert_id() )
  {
  die("Error: User not added to database.");
  }
 else
  {

  Header("Location: register.php?op=thanks");
  }
 }

elseif ( $_GET["op"] == "thanks" )
 {
 echo "<h2>Thanks for registering!</h2>";
 }


else
 {
 echo "<form action=\"?op=reg\" method=\"POST\">\n";
 echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n";
 echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br />\n";
 echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n";
 echo "<input type=\"submit\">\n";
 echo "</form>\n";
 }

?>

and this is my html file that goes with the php file

XML

<!DOCTYPE HTML>
<html>
<head>
    <title> RootSpread | Sign up</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <link rel="stylesheet" href="css/normalize.css" type="text/css" media="screen">
  <link rel="stylesheet" href="css/grid.css" type="text/css" media="screen">
  <link rel="stylesheet" href="css/signupstyle.css" type="text/css" media="screen">

   <style type="text/css">

            body {font-family:Arial, Sans-Serif;}

            #container {width:300px; margin:0 auto;}

            /* Nicely lines up the labels. */
            form label {display:inline-block; width:140px;}

            /* You could add a class to all the input boxes instead, if you like. That would be safer, and more backwards-compatible */
            form input[type="text"],
            form input[type="password"],
            form input[type="email"] {width:160px;}

            form .line {clear:both;}
            form .line.submit {text-align:right;}

        </style>


</head>
<body>
    <div id="form">
    <form action="signup.php" method="post" />
        <form>
            <h1>Sign up</h1>
                <div id="first" class="line"><label for="firstname">First Name * </label><input type="text" id="firstname" /></div>
                <div id="middle" class="line"><label for="initial">Middle Initial </label><input type="text" id="pwd" /></div>
                <!-- You may want to consider adding a "confirm" password box also -->
                <div id="last" class="line"><label for="lastname">Last Name * </label><input type="text" id="surname" /></div>
                <div id="email" class="line"><label for="email">Email * </label><input type="text" id="names" /></div>
                <div id="cemail" class="line"><label for="cemail">Comfirm Email * </label><input type="text" id="dob" /></div>
                <div id="password" class="line"><label for="password">Password * </label><input type="password" id="tel" /></div>
                <div id="cpassword" class="line"><label for="cpassword">Comfirm Pswd *</label><input type="password" id="tel" /></div>

                <div id="dob">
                Month* <select><option value="month">January</option>
                <option value="month">Febuary</option>
                <option value="month">March</option>
                <option value="month">April</option>
                <option value="month">May</option>
                <option value="month">June</option>
                <option value="month">July</option>
                <option value="month">Augast</option>
                <option value="month">September</option>
                <option value="month">October</option>
                <option value="month">November</option>
                <option value="month">December</option>
                </select>

                Day* <select>
                <option value="day">1</option>
                <option value="day">2</option><option value="day">3</option>
                <option value="day">4</option>
                <option value="day">5</option><option value="day">6</option>
                <option value="day">7</option>
                <option value="day">8</option><option value="day">9</option><option value="day">10</option><option value="day">11</option><option value="day">12</option><option value="day">13</option><option value="day">14</option><option value="day">15</option><option value="day">16</option><option value="day">17</option><option value="day">18</option><option value="day">19</option><option value="day">20</option><option value="day">21</option><option value="day">22</option><option value="day">23</option><option value="day">24</option><option value="day">25</option><option value="day">26</option><option value="day">27</option><option value="day">28</option><option value="day">29</option><option value="day">30</option><option value="day">31</option></select>

                year* <select><option value="year">1930</option><option value="year">1931</option><option value="year">1932</option><option value="year">1933</option><option value="year">1934</option><option value="year">1935</option><option value="year">1936</option><option value="year">1937</option><option value="year">1938</option><option value="year">1939</option><option "">1940</option><option value="year">1941</option><option value="year">1942</option><option value="year">1943</option><option ="">1944</option><option value="year">1945</option><option value="year">1946</option><option value="year">1947</option><option ="">1948</option><option value="year">1949</option><option value="year">1950</option><option value="year">1951</option><option value="year">1952</option><option value="year">1953</option><option value="year">1954</option><option value="year">1955</option><option ="">1956</option><option value="year">1957</option><option value="year">1958</option><option value="year">1959</option><option value="year">1960</option><option value="year">1961</option><option value="year">1962</option><option value="year">1963</option><option value="year">1964</option><option value="year">1965</option><option value="year">1966</option><option value="year">1967</option><option value="year">1968</option><option value="year">1969</option><option value="year">1970</option><option value="year">1971</option><option value="year">1972</option><option value="year">1973</option><option value="year">1974</option><option value="year">1975</option><option value="year">1976</option><option value="year">1977</option><option value="year">1978</option><option value="year">1979</option><option value="year">1980</option><option value="year">1981</option><option value="year">1982</option><option value="year">1983</option><option value="year">1984</option><option value="year">1985</option><option value="year">1986</option><option value="year">1987</option><option value="year">1988</option><option value="year">1989</option><option value="year">1990</option><option value="year">1991</option><option value="year">1992</option><option value="year">1993</option><option value="year">1994</option><option value="year">1995</option><option value="year">1996</option><option value="year">1997</option><option value="year">1998</option><option value="year">1999</option><option value="year">2000</option><option value="year">2001</option><option value="year">2002</option><option value="year">2003</option><option value="year">2004</option><option value="year">2005</option><option value="year">2006</option><option value="year">2007</option><option value="year">2008</option><option value="year">2009</option><option value="year">2010</option><option value="year">2011</option><option value="year">2012</option><option value="year">2013</option></select>
            </div>

                <!-- Valid input types: http://www.w3schools.com/html5/html5_form_input_types.asp -->
                <div id="number" class="line"><label for="tel">Phone Number </label><input type="text" id="tel" /></div>
                <div id="sex1">
                <form>
                    <input type="radio" name="sex" value="male">Male
                    <div id="sex2"><input type="radio" name="sex" value="female">Female</div>
                </form>
            </div>
                <div class="line submit"><a href="signup.php" class="btn">submit</a></div>
        </form>
    </form>
</div>

    <div id="copyright" class="grid_12">
    <div style="position: absolute; bottom: 0px;">Root Spread &copy 2013 All Rights Reserved.</div>
    </div>

    </body>
</html>

Posted 15-Jul-13 12:44pm

Kevin Miqui

Add a Solution

Comments

DinoRondelly 15-Jul-13 18:48pm

whats line 35?

Kevin Miqui 15-Jul-13 19:35pm

."PASSWORD('".$_POST["password"]."'), "

on the php file

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter_in_2780 · Answer 1 · 2013-07-15T13:50:00

Solution 1

You have a semicolon at the end of the previous line, which terminates the $q = ... statement.
So PHP is expecting the start of a new statement, and the first "." doesn't make sense to it.

Peter

Posted 15-Jul-13 13:50pm

Peter_in_2780

thanh_bkhn · Answer 2 · 2013-07-15T15:33:00

There are two errors here.
First, your INSERT SQL command has an invalid syntax.
Second, the semi-colon after the declaration of $q is at the wrong place.
Try this:

PHP

$q = "INSERT INTO `accounts` (`firstname`,`initial`,`lastname`,`email`,`password`,`dob`,`number`,`sex`) "
  ."VALUES ('".$_POST["firstname"]."', '".$_POST["initial"]."', '".$_POST["lastname"]."', '".$_POST["email"]."', '"
  ."PASSWORD('".$_POST["password"]."'), '".$_POST["dob"]."', '".$_POST["number"]."', '".$_POST["sex"]."') ";