need help to fix errors in php with xampp server(Apache and mysql)

Question

Teja_1 0 Newbie Poster

8 Years Ago

i am using php with xampp server and i am getting the following error while i am running the program.

Unknown column 'firstname' in 'field list'

(heres the program)

CREATE DATABASE IF NOT EXISTS customerdb DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE customerdb;

-- --------------------------------------------------------

--

-- Table structure for table customer

CREATE TABLE IF NOT EXISTS customer (
id int(11) NOT NULL,
firstname varchar(80) NOT NULL,
lastname varchar(80) NOT NULL,
email varchar(80) NOT NULL,
contact varchar(15) NOT NULL,
password varchar(80) NOT NULL,
address varchar(200) NOT NULL,
ip varchar(15) NOT NULL,
dateadded date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

ALTER TABLE customer
MODIFY id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

apache client-server mysql php

3 Contributors
11 Replies
402 Views
1 Week Discussion Span
Latest Post 8 Years Ago Latest Post by Teja_1

diafol

8 Years Ago

Show the php code you.re using to connect and the query routine

diafol

8 Years Ago

Ok you.re using dead code (mysql functions) consider pdo or mysqli. But that.s not the issue. Show the query with the php code that you.re running. We have no idea what you.re doing.

rch1231 169 Posting Shark

8 Years Ago

Hello,
When are you getting the error about firstname not in field list? Is it when you are running the create table query or at another point in the process?
Is there already a table called customer in the customerdb database? If so is there a firstname field already defined?
If you are testing creating the database and/or table from scratch then here is a sample of the sql code I use that drops the table first then recreates it. I did not include the rest of the select since it is a long query with a couple of JOINs and UNIONs.

DROP TABLE IF EXISTS `TagLinks`;
CREATE TABLE `TagLinks` 
(
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ProductID` int(11) DEFAULT NULL,
  `TagID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `tag` (`TagID`),
  KEY `prod` (`ProductID`)
) 
SELECT * FROM

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Teja_1 0 Newbie Poster · Answer 1 · 2016-02-20T20:37:05+00:00

heres the php code

<?php
    define('DB_HOSTNAME', 'localhost');
    define('DB_USERNAME', 'root');
    define('DB_PASSWORD', '');
    define('DB_DATABASE', 'customerdb');
    define('DB_PORT', '3306');
    //define('DB_PREFIX', 'xyz_');

    mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD) or die(mysql_error());
    mysql_select_db(DB_DATABASE) or die(mysql_error());

Teja_1 0 Newbie Poster · Answer 2 · 2016-02-22T06:09:55+00:00

i am providing the entire code

<?php
    session_start();
    include 'db_connect.php';
    $_SESSION['fname'] = filter_input(INPUT_POST,'fname_fld');
    $_SESSION['lname'] = filter_input(INPUT_POST,'lname_fld');
    $_SESSION['email'] = filter_input(INPUT_POST,'em_fld');
    $_SESSION['contact'] = filter_input(INPUT_POST,'cnt_fld');
    $_SESSION['address'] = filter_input(INPUT_POST,'add_fld');

    $fname = filter_input(INPUT_POST,'fname_fld');
    $lname = filter_input(INPUT_POST,'lname_fld');
    $email = filter_input(INPUT_POST,'em_fld',FILTER_VALIDATE_EMAIL);
    $contact = filter_input(INPUT_POST,'cnt_fld');
    $pass = filter_input(INPUT_POST,'pwd_fld');
    $cpass = filter_input(INPUT_POST,'cpwd_fld');
    $address = filter_input(INPUT_POST,'add_fld');
    $ip = filter_input(INPUT_SERVER, 'SERVER_ADDR');
    $date = date('Y-m-d');

    if(null != filter_input(INPUT_POST, 'subForm')) {
        if($pass !== $cpass) {
            header('Location: signup.php?token=Password%20Mismatch');
        }
        else {
            if($fname && $lname && $email && $contact && $pass && $address) {
                mysql_query("insert into customer(firstname,lastname,email,contact,password,address,ip,dateadded) values('$fname','$lname','$email','$contact','$pass','$address','$ip','$date')") or die(mysql_error());
                unset($_SESSION['fname']);
                unset($_SESSION['lname']);
                unset($_SESSION['email']);
                unset($_SESSION['contact']);
                unset($_SESSION['address']);
                echo 'Successfully Added';

            }
        }
    }

Teja_1 0 Newbie Poster · Answer 3 · 2016-02-22T06:11:10+00:00

<?php
    session_start();
    $fname = null;
    $lname = null;
    $email = null;
    $contact = null;
    $address = null;
    $token = filter_input(INPUT_GET, 'token');
    if(isset($_SESSION['fname'])) {
        $fname = $_SESSION['fname'];
    }
    if(isset($_SESSION['lname'])) {
        $lname = $_SESSION['lname'];
    }
    if(isset($_SESSION['email'])) {
        $email = $_SESSION['email'];
    }
    if(isset($_SESSION['contact'])) {
        $contact = $_SESSION['contact'];
    }
    if(isset($_SESSION['address'])) {
        $address = $_SESSION['address'];
    }
?>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="charset=utf-8" />
        <link href="assets/style.css" rel="stylesheet" type="text/css"/>
        <title>Customer SignUp</title>
    </head>
    <body>
        <div id="container">
            <form id="form" name="form" method="post" action="addcustomer.php" onsubmit="return validate();">
                <header class="info">
                    <h2>SignUp Form</h2>
                </header>
                <ul>
                    <li>
                        <span style="color: red"><?php echo $token; ?></span>
                    </li>
                    <li id="fname_blk">
                        <label class="desc" for="fname_fld">First Name <span class="req">*</span></label>
                        <div>
                            <input id="fname_fld" name="fname_fld" type="text" class="text" value="<?php echo $fname; ?>" required />
                        </div>
                    </li>

                    <li id="lname_blk">
                        <label class="desc" for="lname_fld">Last Name <span class="req">*</span></label>
                        <div>
                            <input id="lname_fld" name="lname_fld" type="text" class="text" value="<?php echo $lname; ?>" required />
                        </div>
                    </li>

                    <li id="eml_blk">
                        <label class="desc" for="em_fld">Email <span class="req">*</span></label>
                        <div>
                            <input id="em_fld" name="em_fld" type="email" class="text" value="<?php echo $email; ?>" required />
                        </div>
                    </li>

                    <li id="cnt_blk">
                        <label class="desc" for="cnt_fld">Contact <span class="req">*</span></label>
                        <div>
                            <input id="cnt_fld" name="cnt_fld" type="text" title="Must be a valid Number" pattern="[0-9]{10}" value="<?php echo $contact; ?>" class="text" required />
                        </div>
                    </li>

                    <li id="pwd_blk">
                        <label class="desc" for="pwd_fld">Password <span class="req">*</span></label>
                        <div>
                            <input id="pwd_fld" name="pwd_fld" type="password" class="text" required />
                        </div>
                    </li>

                    <li id="cpwd_blk">
                        <label class="desc" for="cpwd_fld">Confirm Password <span class="req">*</span></label>
                        <div>
                            <input id="cpwd_fld" name="cpwd_fld" type="password" class="text" required />
                        </div>
                    </li>

                    <li id="add_blk">
                        <label class="desc" for="add_fld">Address <span class="req">*</span></label>
                        <div>
                            <textarea id="add_fld" name="add_fld" class="text" required /><?php echo $address; ?></textarea>
                        </div>
                    </li>

                    <li class="buttons ">
                        <div>
                            <input class="subform" id="subForm" name="subForm" type="submit" value="Submit" />
                        </div>
                    </li>
                </ul>
            </form>
        </div>
        <script src="assets/jquery.min.js"></script>
        <script src="assets/script.js"></script>
    </body>
</html>

Teja_1 0 Newbie Poster · Answer 4 · 2016-02-22T06:13:32+00:00

thats the entire code i am providing anyone help me with that

Teja_1 0 Newbie Poster · Answer 5 · 2016-02-24T04:02:57+00:00

and now i am getting the following error when i execute the program after entering the details the error show up as following

: Make sure your input for validation

rch1231 169 Posting Shark · Answer 6 · 2016-02-26T10:56:43+00:00

What really helps is if you put the code you are using and the error you are getting like you did initially. We can't debug your code without seeing it.

Teja_1 0 Newbie Poster · Answer 7 · 2016-02-28T23:18:54+00:00

thank you for your support guys its just an class name causing the issue and it was fixed now i am done with it .

Teja_1 0 Newbie Poster · Answer 8 · 2016-02-28T23:20:03+00:00

check all the file names and their extenstions to make sure that the file name matches the extensions thats the cause of the error somehow i figured it out