PHP - Notice Undefined index

Question

Possible Duplicate    PHP     Notice  Undefined variable     and    Notice  Undefined index          I am trying to do a registration form that registers a user in a database  MySQL    The code is supposed to register    Name Surname Username Password Email Security Question Security Answer   The code  before saving to the table  checks whether the username or password already exists  and if they do it echoes an error message  and if not  it saves to the db   However  on page load  I m getting these errors   Notice  Undefined index  Name in C  xampp htdocs Task2 registration php on line 216  Notice  Undefined index  Surname in C  xampp htdocs Task2 registration php on line 217  Notice  Undefined index  Username in C  xampp htdocs Task2 registration php on line 219  Notice  Undefined index  Email in C  xampp htdocs Task2 registration php on line 221  Notice  Undefined index  C Email in C  xampp htdocs Task2 registration php on line 222  Notice  Undefined index  password in C  xampp htdocs Task2 registration php on line 224  Notice  Undefined index  c password in C  xampp htdocs Task2 registration php on line 225  Notice  Undefined index  SecQ in C  xampp htdocs Task2 registration php on line 227  Notice  Undefined index  SecA in C  xampp htdocs Task2 registration php on line 228  Notice  Undefined variable  mysql connect in C  xampp htdocs Task2 registration php on line 231  Fatal error  Function name must be a string in C  xampp htdocs Task2 registration php on line 231   This is the code        lt  xml version  1 0  encoding  iso-8859-1   gt   lt  DOCTYPE html PUBLIC  -  W3C  DTD XHTML 1 0 Transitional  EN         http   www w3 org TR xhtml1 DTD xhtml1-transitional dtd  gt   lt html xmlns  http   www w3 org 1999 xhtml  gt   lt head gt      lt title gt Registration lt  title gt      lt style type  text css  title  Amaya theme  gt   body       font-size  12pt      font-family  Helvetica  Arial  sans-serif      font-weight  normal      font-style  normal      color  black      background-color  white      line-height  1 2em      margin-left  4em      margin-right  2em           paragraphs    p        padding  0      margin-top  1em      margin-bottom  1em      text-align  left           headings    h1       font-size  180       font-weight  bold      font-style  normal      font-variant  small-caps      text-align  left      padding  0      margin-top  1 7em      margin-bottom  1 7em       h2       font-size  150       font-weight  bold      font-style  normal      padding  0      margin-top  1 5em      margin-bottom  1 1em       h3       font-size  130       font-weight  bold      font-style  normal      padding  0      margin-top  1 3em      margin-bottom  1 1em       h4       font-size  110       font-weight  bold      font-style  normal      padding  0      margin-top  1 1em      margin-bottom  1 1em       h5       font-size  100       font-weight  bold      font-style  italic      padding  0      margin-top  1em      margin-bottom  1em       h6       font-size  100       font-weight  normal      font-style  italic      padding  0      margin-top  1em      margin-bottom  1em           divisions    div       padding  0      margin-top  0em      margin-bottom  0em           lists    ul  ol       padding  0 0 0 3em      margin-top  1em      margin-bottom  1em       ul ul  ol ol  ul ol  ol ul       margin-top  1em      margin-bottom  1em       li       padding  0      margin-top  1em      margin-bottom  1em      text-align  left       li p       margin-top  1em      margin-bottom  1em       dl       padding  0      margin-top  1em      margin-bottom  1em      margin-left  1em       dl dl       margin-top  0em      margin-bottom  0em       dt       padding  0      font-weight  bold      margin-top   3em      margin-bottom   3em       dd       padding  0      margin-top   3em      margin-left  3em      margin-bottom   3em       dl p       margin-top   3em      margin-bottom   3em           inline    strong       font-weight  bold       em       font-style  italic       code       font-family  Courier New  Courier  monospace       ins       background-color  yellow      text-decoration  underline       del       text-decoration  line-through         a href        color  blue      text-decoration  underline            lt  style gt   lt  head gt    lt body gt   lt h4 gt  lt span style  font-family  Arial Helvetica sans-serif  gt Name lt  span gt  lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  text   name  Name   gt  lt  p gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Surname lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  text  name  Surname   gt  lt  p gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Username lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  text  name  Username    gt  lt  p gt   lt hr style  font-family  Arial Helvetica sans-serif    gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Email lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  text  name  Email    gt  lt  p gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Confirm Email lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  text  name  C Email    gt  lt  p gt   lt hr style  font-family  Arial Helvetica sans-serif    gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Password lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  password  name  password    gt  lt  p gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Confirm Password lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  password  name  c password   gt  lt  p gt   lt hr style  font-family  Arial Helvetica sans-serif    gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Security Question lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  password  name  SecQ    gt  lt  p gt    lt h4 style  font-family  Arial Helvetica sans-serif  gt Security Answer lt  h4 gt    lt p style  font-family  Arial Helvetica sans-serif  gt   lt input type  password  name  SecA   gt  lt  p gt   lt hr style  font-family  Arial Helvetica sans-serif    gt    lt hr style  font-family  Arial Helvetica sans-serif    gt     lt p gt  lt span style  font-family  Arial Helvetica sans-serif  gt  lt button gt Submit lt  button gt  lt  span gt  lt  p gt    lt  body gt    lt  html gt   lt  php  Name     POST  Name     Surname     POST  Surname      Username     POST  Username      Email     POST  Email     C Email     POST  C Email      Password     POST  password     C Password     POST  c password      SecQ     POST  SecQ     SecA     POST  SecA       mysql connect   localhost    admin    storefile1234    mysql select db   storefile      check username   mysql query  SELECT FROM users WHERE username     Username      check email   mysql query  SELECT FROM users WHERE email     Email       if   Name    null     Surname   null     Username    null     Password    null     C Password    null     Email    null     C Email    null     SecQ    null     SecA    null          echo  Missing details  Please enter all fields        else        if mysql num rows  check username     0  amp  amp  mysql num rows  check email     0                            echo  Username Email already exists                             if    Email     C Email  amp  amp   Password     C Password                      query    INSERT INTO users  Username  Name Surname  Password  Email  SecQ  SecA  VALUES   NULL      Username        Name        Surname        Password        SecQ        SecA        Email                        mysql query  query  or die   Error registering                      echo  Greetings     Name    you have been registered             else            echo  Error registering your account  Please try again                          gt    Any help would be appreciated   Thanks

User · Answer

How are you loading this page  Is it getting anything on POST to load  If it s not  then the  name     POST  Name    assignation doesn t have any  Name  on POST

User · Answer

For starters    mysql connect   should not have a   accompanying it  it is not a variable  it is a predefined function  Remove the   to properly connect to the database   Why do you have an XML tag at the top of this document  This is HTML PHP - a HTML doctype should suffice   From line 215  update   if  isset   POST          Name     POST  Name         Surname     POST  Surname          Username     POST  Username          Email     POST  Email         C Email     POST  C Email          Password     POST  password         C Password     POST  c password          SecQ     POST  SecQ         SecA     POST  SecA        POST variables are coming from your form  and you have to check whether they exist or not  else PHP will give you a NOTICE error  You can disable these notices by placing error reporting 0   at the top of your document  It s best to keep these visible for development purposes   You should only be interacting with the database  inserting  checking  under the condition that the form has been submitted  If you do not  PHP will run all of these operations without any input from the user  Its best to use an IF statement  like so   if  isset   POST  submit         blah blah    check if user exists  check if fields are blank    insert the user if all of this stuff checks out     else      just display the form     Awesome form tutorial  http   php about com od learnphp ss php forms htm

User · Answer

You re getting errors because you re attempting to read post variables that haven t been set  they only get set on form submission  Wrap your php code at the bottom in an   if    SERVER  REQUEST METHOD        POST            Also  your code is ripe for SQL injection  At the very least use mysql real escape string on the post vars before using them in SQL queries  mysql real escape string is not good enough for a production site  but should score you extra points in class

User · Answer

Before you extract values from   POST  you should check if they exist  You could use the isset function for this  http   php net manual en function isset php

[mysql] PHP - Notice: Undefined index:

Examples related to mysql

Examples related to php