Unable to insert a row in MySQL table

Question

Here is my code:

 $username   = $connection->real_escape_string($username);
 $html       = $connection->real_escape_string($html);
 $query      = $connection->query("SELECT * from savedarticles WHERE username = '$username' AND article = '$html'");
 $matches    = mysqli_num_rows($query);
 if ($matches == 0) {
   $connection->query("INSERT INTO savedarticles ('username', 'article') VALUES ($username, $html)");
 } 
 if ($matches == 1) {
   $row = mysqli_fetch_array($query);
   $connection->query("DELETE FROM savedarticles WHERE username = '$username' AND article='$html'");
 }

My table name is same in the PHP code and PHPMYADMIN section. I have created two columns with name username and article in the table. This code however, does not insert a new row. The table is empty with no rows. Also, is there a way to delete a row directly since I have already singled it out (instead of running the query through whole table again).

score 0 · Answer 1 · answered Oct 28 '15 at 13:34

0

Change this line like this. You dont need to use single quotes for column name

$connection->query("INSERT INTO savedarticles (username, article) VALUES ('$username', '$html')");

answered Oct 28 '15 at 13:34

Arun Krish

2,153
1
10
15

score 0 · Answer 2 · answered Oct 28 '15 at 13:35

0

You are adding single quotes against field names, which is incorrect.

Change:

$connection->query("INSERT INTO savedarticles 
('username', 'article') VALUES ($username, $html)");

To:

$connection->query("INSERT INTO savedarticles 
(username, article) VALUES ('$username', '$html')");

You can use backtick (`) against field names to avoid conflict with MySQL reserved keywords.

Example is as following:

$connection->query("INSERT INTO savedarticles 
(`username`, `article`) VALUES ('$username', '$html')");

But, single quotes means user entered string and it will not refer to any DB name, table name or field name.

Reference:

answered Oct 28 '15 at 13:35

Pupil

23,834
6
44
66

it still does not insert any rows. I also have a third column called 'ID' do I need to insert values in it too. It is auto incrementing. – SanJeet Singh Oct 28 '15 at 13:42
The code is perfect, check your DB connection. Also, if it jumps into the `if`. – Pupil Oct 28 '15 at 13:44
I put an echo statment inside the `if` condition and it echoed. So, I guess error is somewhere else. – SanJeet Singh Oct 28 '15 at 13:57

Unable to insert a row in MySQL table

2 Answers2