Add a mysql record from php

Question

Why does this code not work? I need to insert a new record on mysql called "utenti" but this code doesn't work:

<?php
    $nome = $_REQUEST["nomeUtente"];
    $cognome = $_REQUEST["cognome"];
    $psw = $_REQUEST["psw"];
    $email = $_REQUEST["email"];
    $cell = $_REQUEST["num"];           

    echo $nome . " / " . $cognome . " / " . $psw . " / " . $email . " / " . $cell;
    echo "<br>";

    $conn = mysql_connect("hostName","User","password");

    if(!$conn){
        echo "connessione non satabilita";
    }else{
        if(!mysql_select_db("a4102239_utenti",$conn)){
            echo "database non trovato";
        }else{
            $sql = "INSERT INTO utenti (id,psw,nome,cognome,email,cellulare) VALUES (NULL,'$psw','$nome','$cognome','$email','$cell')"; //costruzione comando di ricerca      
        }
    }
?>

You must run your query, of course! mysql_query($sql, $conn); — Ahmad
– Ahmad, Commented Sep 2, 2015 at 11:06

Harshit · Accepted Answer · 2015-09-02 11:06:11Z

1

Execute the query

mysql_query("INSERT INTO utenti (id,psw,nome,cognome,email,cellulare) VALUES (NULL,'$psw','$nome','$cognome','$email','$cell')"); //costruzione comando di ricerca

answered Sep 2, 2015 at 11:06

Harshit

5,18711 gold badges51 silver badges96 bronze badges

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

Comments

Rahman Qaiser · Accepted Answer · 2015-09-02 11:11:11Z

0

Because you did not Execute the Query,

$sql = "INSERT INTO utenti (id,psw,nome,cognome,email,cellulare) VALUES (NULL,'$psw','$nome','$cognome','$email','$cell')";
$result=mysql_query($sql);
if($result){
// Query is executed
}
else{
//Error
echo mysql_error();
}

answered Sep 2, 2015 at 11:11

Rahman Qaiser

6825 silver badges18 bronze badges

Collectives™ on Stack Overflow

Add a mysql record from php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related