INSERT ROW doesn't work

Question

Config.php

  $host = 'REMOVED';
  $dbname = 'REMOVED';
  $username = 'REMOVED';
  $password = 'REMOVED';

  try {
  $db = new PDO("mysql:host=".$host.";dbname=".$dbname, $username, $password, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
  } catch(PDOException $e) {
    exit($e->getMessage());
  }

The config connects to the server just fine, then I try to insert a row in index.php to the table, and then...

Index.php

require 'config.php';

$text1 = 'teeext';

$text2 = 'teeeext';

$text3 = 'teeeeext';

$db->exec('INSERT INTO users (`row1`, `row3`, `row2`) VALUES ('.$text1.', '.$text2.', '.$text3);

When I run this page, I just get blank, database does not show any rows inserted, even if I run the page 100 times.

Because running the page 100 times might cause it to work, when it didn't the first time? — random_user_name, Oct 11 '17 at 13:52
[PHP's white screen of death](https://stackoverflow.com/questions/1475297/phps-white-screen-of-death). — FirstOne, Oct 11 '17 at 13:53
Try using `$db->exec("INSERT INTO users (\`row1\`, \`row3\`, \`row2\`) VALUES ('$text1', '$text2', '$text3')");` — mega6382, Oct 11 '17 at 13:53
See if you can view the error log (for apache it's usually in /var/log/httpd or /var/log/apache2 depending on your distribution). This should tell you the exact problem. If you don't have access you may be able to use a .htaccess file to point it to a file you can view. — Cfreak, Oct 11 '17 at 13:55
As @mega6382 says, you have a sintax error. It won't work even if you run it 1000000000 times — nacho, Oct 11 '17 at 13:55
I have updated my comment try that. And also, if any of the values for those variables will be coming from external input, then your code is at risk of sql injection. — mega6382, Oct 11 '17 at 13:59

score -1 · Answer 1 · edited Oct 11 '17 at 14:01

-1

There is an syntax error, at the end of the query you didnt close for '.$text3.'

$db->exec('INSERT INTO users (`row1`, `row3`, `row2`) VALUES ('.$text1.', '.$text2.', '.$text3.')');

edited Oct 11 '17 at 14:01

Funk Forty Niner

74,450
15
68
141

answered Oct 11 '17 at 13:56

Santhosh

142
6

Shouldn't the string values be in quotes, also? Also, while it's good to try to help how can you be sure this is the right data structure? Are you sure? How do you know. – random_user_name Oct 11 '17 at 13:57
As the query assigned as string " ' " at the begining of the $text3 and didnt close the query correctly. – Santhosh Oct 11 '17 at 14:00
this syntax is incorrect and don't know why it was upvoted. – Funk Forty Niner Oct 11 '17 at 14:01
No one has upvoted, as it was downvoted for duplicate questions. – Santhosh Oct 11 '17 at 14:04
@San - it has been both upvoted _and_ downvoted. – random_user_name Oct 11 '17 at 14:05
click in the middle of the arrows, you'll see for yourself. – Funk Forty Niner Oct 11 '17 at 14:06
@cale_b oh some one has wrongly upvoted. – Santhosh Oct 11 '17 at 14:07
@Fred-ii- I don't think San can see that. I don't recall the rep required, but fairly confident it's more than 30... (Just checked - it's 1k) – random_user_name Oct 11 '17 at 14:34

INSERT ROW doesn't work

1 Answers1