PDO Insert Statement

[hermann87]

Good God, I've been stuck for like 2 hours, I suppose I can't think clearly anymore, but I just don't see why the statement below won't work, please help me out :

<?php session_start();
	$username = $_GET['username'];

	$db = new PDO('mysql:host=localhost;dbname=subscribers', 'root', '');
	$sql = "INSERTO INTO users (username) VALUES (?)";
	$stmt = $db->prepare($sql);
	$stmt->execute(array($username));
?>

There are no errors after the query is ran, however the value is not inserted, nothing happens!

[aquilax]

Try to execute the query manually in mysql. It may be unique field index, wrong field name that's preventing inserting new value.

[vibhaJ]

Yes.. Try to debug printed sql query in phpmyadmin.

echo $sql = "INSERTO INTO users (username) VALUES (?)"; exit;

[aquilax]

Just noticed the typo INSERTO should be INSERT.

[hermann87]

Just noticed the typo INSERTO should be INSERT.

That was it! I think I would have never noticed!
Thank you!