Php/MySQL: Unable to insert a single row only

Question

I am trying to make a page that allows the user to enter the steps he will take to do a particular task. However, whenever I submit a step, multiple similar records get stored inside mysql database. So if i type "Do this", in my mysql database, two records will be stored with same data Here is my code...

<?php

$conn = new mysqli("localhost", "root","","KFC");
if(isset($_POST['Submit_btn']))
{
  session_start();
    $var_value = $_SESSION['R_ID'];

    $Name= mysqli_real_escape_string($conn, $_POST['Step']);

    $sql= "INSERT INTO `step`(`Step`, `R_ID`) VALUES ('$Name','$var_value')";

    mysqli_query($conn,$sql);
    if (!mysqli_query($conn,$sql))
  {
  echo("Error description: " . mysqli_error($conn));
  }
}
mysqli_close($conn);
?>
<html>
<body>
<div id="bodyContent">
<h1> Submit Steps </h1>
</div>
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('garden');
$result = mysql_query("SELECT * FROM step WHERE R_ID='$var_value'");
$rows = mysql_num_rows($result);
echo "So far you have submitted " . $rows . " steps for your recipe.";
?>
<form method="post">
<table>
<tr>
<td>STEP: </td>
<td>
<textarea type="text" name="Step" class="textInput"></textarea>
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" name="Submit_btn" value="submit">
</td>
<td>
<input type="submit" name="Continue_btn" value="Continue">
</td>
</tr>

</table>
</form>
</body>
</html>

how am i executing it twice :/ ? the first one is for inserting and second is for viewing — buffyBTVS96
– buffyBTVS96, Commented Apr 9, 2018 at 2:44
mysqli_query($conn,$sql); if (!mysqli_query($conn,$sql)) = twice — user9487972
– user9487972, Commented Apr 9, 2018 at 2:45
your also using mysql and myqli in the same script for no reason. making 2 db connections etc. — user9487972
– user9487972, Commented Apr 9, 2018 at 2:46

prasanna puttaswamy · Accepted Answer · 2018-04-09 04:18:07Z

1

You are running the execution query twice .

mysqli_query($conn,$sql);

This instruction execute the insert query that you have. You are executing it once, and then you are executing again to validate the boolean return value of the function. You need to use only the validation row.

This is what you have:

  mysqli_query($conn,$sql);
  if (!mysqli_query($conn,$sql))
  {
    echo("Error description: " . mysqli_error($conn));
  }

You only need:

  if (!mysqli_query($conn,$sql))
  {
    echo("Error description: " . mysqli_error($conn));
  }

The validation row will execute the function and return the boolean value you need.

edited Apr 9, 2018 at 4:18

prasanna puttaswamy

9872 gold badges8 silver badges9 bronze badges

answered Apr 9, 2018 at 2:45

Héctor José Hernández Reinoza

521 silver badge7 bronze badges

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

1 Comment

Héctor José Hernández Reinoza Over a year ago

glad to help ;)

Collectives™ on Stack Overflow

Php/MySQL: Unable to insert a single row only

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related