Problem inserting in mysql table

Question

Problem inserting in mysql table

Navigation

#1 by (1 votes)

0

Good afternoon, I have this code:

<?php 
$servername = "xxxxxxxxxxx";
$username = "xxxxxxx";
$password = "xxxxxxxx";
$dbname = "xxxxxxx";

$conn = new mysqli($servername, $username, $password, $dbname);
$conn->set_charset('utf8');

$name = $_POST['DescricaoProd'];
$unid = $_POST['DescricaoUnid'];  

$sql = "INSERT INTO ProdHigiene (DescricaoProd,DescricaoUnid) 
VALUES ('$name','$unid')";

if ($conn->query($sql) === TRUE);

//Count total number of rows
$rowCount = $query->num_rows;

$conn->close();
?>

My problem is that whenever I open the page on the menu where I have this code it inserts a blank line in the mysql table and should not because I have not even created the form.

Can anyone help?

php mysql wordpress inserir

asked by anonymous 28.12.2017 / 17:15

1 answer

php variable within line javascript (Sweet Alert) PHP disabling Jquery keyup button

score 1 · Accepted Answer

To avoid inserting while there is no form to submit, place your code inside a if

//isset — Informa se a variável foi iniciada
//!empty se a variável não é vazia

if (isset($_POST['submit']) && (!empty($_POST['submit']))) {
    $servername = "xxxxxxxxxxx";
    $username = "xxxxxxx";
    $password = "xxxxxxxx";
    $dbname = "xxxxxxx";

    $conn = new mysqli($servername, $username, $password, $dbname);
    $conn->set_charset('utf8');

    $name = $_POST['DescricaoProd'];
    $unid = $_POST['DescricaoUnid'];  

    $sql = "INSERT INTO ProdHigiene (DescricaoProd,DescricaoUnid) 
    VALUES ('$name','$unid')";

    if ($conn->query($sql) === TRUE);

    //Count total number of rows
    $rowCount = $query->num_rows;

    $conn->close();
}

When there is a form to insert

<form .....>
............
............
<input type="submit" name="submit" value="submit" />
</form>