Invalid query php without error message

Asked May 23 '17 at 07:54

Active May 23 '17 at 07:54

Viewed 22 times

This is my query:

$query =  "INSERT INTO studente (Nome, Cognome, Matricola, Username, Codice)  
     SELECT 'Nome', 'Cognome', 'Matricola', 'Username' FROM studenti_in_sessione
     WHERE studenti_in_sessione.Username = '".$_REQUEST['username']. "';" ; 
          $result = $db_handle->insertQuery($query);

This is insertQuery method:

function insertQuery($query) {
        $result = mysqli_query($this->conn,$query);
        if (!$result) {
            die('Invalid query: ' . mysql_error());
        } else {
            return $result;
        }
    }

The method returns Invalid query: without error messages.

Possible that I wrote the query with "" or "" or actually is wrong, but I do not know where ...

asked May 23 '17 at 07:54

jLab19

2

remove single quotes around column names – Jens May 23 '17 at 07:55
learn about prepared Statements to prevent SQL injection – Jens May 23 '17 at 07:56
Think better dupplicate is https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql – Jens May 23 '17 at 07:57
I remove single quotes but the method returns Invalid query: without error messages. – jLab19 May 23 '17 at 08:34

Invalid query php without error message

0 Answers0