PHP query insert '0' value to mysql table

Question

enter image description here My php file inserts into table row 0 values, I cannot find solution for that.

<?php
$selected_button = $_POST['a'];

$conn = mysql_connect('localhost','root','');
if(!$conn )
{
  die('Could not connect: ' . mysql_error());
}
  $sql = "INSERT INTO answers (member_id, question_id, answer) VALUES (1, 2,'$selected_button')";

mysql_select_db('ipad',$conn);
$result = mysql_query($sql, $conn);
if(!$result)
{
    return false;
}
return true;


mysql_close($conn);
?>

after insert i receive, member_id = 0 ; question_id = 0 ; answer = NULL

mysql_query is deprecated, consider replacing with the supported php.net/manual/de/ref.pdo-mysql.php — AdrianBR
– AdrianBR, Commented Jan 7, 2014 at 10:32
change $result = mysql_query($sql, $conn); to $result = mysql_query($sql, $conn) or die('ERROR: ' . mysql_error()); and check if it breaks the code.. — zzlalani
– zzlalani, Commented Jan 7, 2014 at 10:45
btw your database name is not ipad .. referring to the screenshot.. — zzlalani
– zzlalani, Commented Jan 7, 2014 at 10:51

Ana Claudia · Accepted Answer · 2014-01-07 10:34:29Z

4

If you are using mysql, it should be:

$result = mysql_query($sql, $conn);

But try to use mysqli as mysql is deprecated.

answered Jan 7, 2014 at 10:34

Ana Claudia

5076 silver badges17 bronze badges

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

2 Comments

Peon Over a year ago

Was waiting till someone finally spots this :) Gz, you are the winner!

Kordian Wikliński Over a year ago

i have this right now, and problem is the same, earlier i tried with mysqli also, and the same problem occure

Junaid Atique · Accepted Answer · 2014-01-07 10:38:04Z

0

There is no query running right now. query is first paramter in mysql_query. $result = mysql_query($sql,$conn);

answered Jan 7, 2014 at 10:38

Junaid Atique

4951 gold badge5 silver badges19 bronze badges

Collectives™ on Stack Overflow

PHP query insert '0' value to mysql table

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related