MySQL with Ajax/PHP

Question

After many attempts and researches online I could not find any solution to why I have an error in the database insertion query. The error in question is:

data: Error in query: INSERT INTO Signaling (Severity) VALUES ('gravitaAlta').

I ask desperately where the problem is. Whether it can be in the database itself or in PHP or in my Ajax

HTML

            <form method="post" id="formHomepage">
            <div>
                <input type="email" name="email" required="" placeholder="Email" maxlength="30" autocomplete="on">
            </div>
                <div >
                <a  href="#" id="fotocamera-button" >
                    <label for="fileInput">Carica/Scatta Foto</label>
                </a>
                        <input type="file" accept="image/*" name="file" required="" id="fileInput">
                <img class="img-thumbnail d-none" src="#" id="foto-screen">
            </div>
                <div>
                <select name="categoria" required="">
                    <optgroup label="Seleziona il problema">
                        <option value="mantoStradale" selected="" >Manto Stradale</option>
                        <option value="idrico">Idrico</option>
                        <option value="luceGas">Luce e Gas</option>
                        <option value="rfifiuti">Rifiuti</option>
                        <option value="telecomunicazioni">Telecomunicazioni</option>
                    </optgroup>
                </select>
            </div>
                <div class="form-group">
                <select class="form-control" name="gravita">
                    <optgroup label="Seleziona la tua gravità">
                        <option value="gravitaAlta" selected="">Gravità Alta</option>
                        <option value="gravitaMedia">Gravità Media</option>
                        <option value="gravitaBassa" >Gravità Bassa</option>
                    </optgroup>
                </select>
            </div>
                <div class="form-group">
                <textarea class="form-control" rows="5" name="descrizione" placeholder="Descrizione" maxlength="120"></textarea>
            </div>
                <div class="d-flex flex-row">
                <button type="submit" >Invia Segnalazione</button>
                <button type="reset">Reset</button>
            </div>
         </form>

AJAX

                      var gravita = $("#formHomepage select[name='gravita'] :selected").val();

                      var item = '&gravita=' + gravita;

                      $.ajax(
                      {
                          type: 'POST',
                          url: 'https://civicsensethecitizen.altervista.org/php/formCopy.php',
                          data: item,
                          success: function(data)
                          {
                            console.log("data: " + data);
                          },
                          error: function()
                          {
                            alert("Connessione non riuscita");
                          }
                      });

PHP

<?php
mysqli_set_charset('utf8');

if(isset($_POST['gravita']))
{ 
    $gravita = mysqli_real_escape_string($_POST['gravita']);

    $connessione = mysqli_connect('localhost','civicsensethecitizen','') or die (mysqli_errno ($connessione). mysqli_error ($connessione));
    $db = mysqli_select_db($connessione, "my_civicsensethecitizen" ) or die ('Database non trovato!');

    $query = "INSERT INTO Segnalazione(Gravità) VALUES('.$gravita.')";

    $risultato = mysqli_query($connessione,$query) or die ("Error in query: $query. " . mysqli_connect_error());

    mysqli_close($connessione);

    echo $gravita;
}
?>

Looks like your ajax doesn't get triggered in any way. If it would, according to api.jquery.com/jQuery.post data should be { gravita: gravita } — user8034901
– user8034901, Commented Oct 24, 2018 at 11:54
Ajax works correctly. I tried to return the value sent and print it with the console.log () and it comes quietly — CivicSense
– CivicSense, Commented Oct 24, 2018 at 12:04
if table Segnalazione contains other columnsalso other than Gravità, then you should provide value to those columns in insert query if it had not any default values. — Haritsinh Gohil
– Haritsinh Gohil, Commented Oct 24, 2018 at 13:12
why in your question data: Error in query: INSERT INTO Signaling (Severity) VALUES ('gravitaAlta'). and in your code you have query like INSERT INTO Segnalazione(Gravità) VALUES('.$gravita.'), why table and column is different? — Haritsinh Gohil
– Haritsinh Gohil, Commented Oct 25, 2018 at 13:10
Because gravitaAlta is the value I passed to the PHP variable via Ajax to fill the Gravity field. However, the problem has been changed by changing the Gravity to Severity field and changing data from the given type to String. — CivicSense
– CivicSense, Commented Oct 26, 2018 at 6:26

Justin T. · Accepted Answer · 2018-10-24 12:09:57Z

2

Try changing...

$query = "INSERT INTO Segnalazione(Gravità) VALUES('.$gravita.')";

to this...

$query = "INSERT INTO Segnalazione(Gravità) VALUES('" . $gravita . "')";

Also, make sure that there is a 'Segnalazione' table in your database, and in that table, there is a column named 'Gravità' and that it is set up to except the string you are providing.

edited Oct 24, 2018 at 12:09

answered Oct 24, 2018 at 11:49

Justin T.

8441 gold badge5 silver badges14 bronze badges

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

1 Comment

CivicSense Over a year ago

I have tested this solution of yours but I still get the same error

Nitesh Gupta · Accepted Answer · 2018-10-24 11:51:21Z

1

Use this

$query = "INSERT INTO Segnalazione(Gravità) VALUES('$gravita')";

In Place of

$query = "INSERT INTO Segnalazione(Gravità) VALUES('.$gravita.')";

answered Oct 24, 2018 at 11:51

Nitesh Gupta

1086 bronze badges

1 Comment

Nitesh Gupta Over a year ago

String concatenation is not required inside the double code(" ")

pr1nc3 · Accepted Answer · 2018-10-24 11:57:34Z

1

$query = "INSERT INTO Segnalazione(Gravità) VALUES('$gravita')";

This will work for you. You tried to concatenate the string but did not work as it should!!! You should use double quotes nested inside the single quotes or simplier use the above way.

This solution though will have you open to SQL Injection so i would suggest to use prepared statements:

$stmt = $conn->prepare("INSERT INTO Segnalazione(Gravità) VALUES (?)");
$stmt->bind_param("s", $gravita);
$stmt->execute();

edited Oct 24, 2018 at 11:57

answered Oct 24, 2018 at 11:52

pr1nc3

8,3763 gold badges27 silver badges40 bronze badges

Comments

Prabath Perera · Accepted Answer · 2018-10-24 11:59:53Z

-1

Change,

$query = "INSERT INTO Segnalazione(Gravità) VALUES('.$gravita.')";

To this,

$query = "INSERT INTO Segnalazione(`Gravità`) VALUES('{$gravita} ')";

You seemed to trying to do a string concatenation and it has a issue/ typo Also try quoting column name

answered Oct 24, 2018 at 11:59

Prabath Perera

3502 silver badges9 bronze badges

2 Comments

CivicSense Over a year ago

OK. With this solution I get this new error: data: Error in query: INSERT INTO Signaling (Severity) VALUES ('gravitaAlta'). gravitaAlta is the value of the input form

Prabath Perera Over a year ago

Can you echo the $query and post here?

Collectives™ on Stack Overflow

MySQL with Ajax/PHP

4 Answers 4

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related