mysql insert to database no value

Question

im trying to insert values on form submit but no result nothing is entering in the databse not even empty values,

if(isset($_POST['signup'])) {  

    mysql_query("INSERT INTO user (fname, lname)
    VALUES ('Peter', 'Griffin')");
}

i checked if theres connection to database and it's connected. ANYONE ?

Do you get any errors? Also please stop using mysql_* functions. They are deprecated. — Jan Hančič
– Jan Hančič, Commented Feb 1, 2013 at 10:02
does mysql_error() return anything? Link: mysql_error(). Although, note the red box, these functions are deprecated. — Stu
– Stu, Commented Feb 1, 2013 at 10:03
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Mayank K. Swami
– Mayank K. Swami, Commented Feb 1, 2013 at 10:03

Edwin Alex · Accepted Answer · 2013-02-01 10:09:03Z

2

Execute the query directly in query browser or any of mysql editors and check whether it is inserted. If it is inserted successfully, just check like this.

if(isset($_POST['signup'])) {  
    echo "Inside";
    exit;
    mysql_query("INSERT INTO user (fname, lname)
    VALUES ('Peter', 'Griffin')");
}

If it doesn't display Inside, then the problem is in if(isset($_POST['signup'])). Check it.

answered Feb 1, 2013 at 10:09

Edwin Alex

5,0964 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mayank K. Swami Over a year ago

how query will execute when you exist before query ?

Edwin Alex Over a year ago

In this case, the query won't execute. But he has to know whether the control comes inside the if condition. If it wont come, the condition fails. So he can come an conclusion that the problem is in $_POST['signup'].

Collectives™ on Stack Overflow

mysql insert to database no value

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related