Mysql table doesnt exist, but it does

Question

I have a weird error, using MyPhpAdmin, I added a row, and the script it generates is:

INSERT INTO 'Users'.'User_Accounts'('Account_ID', 'UserName',
'Email', 'PhoneNumber', 'Password') VALUES (NULL, 'fdsfsadf',
'dfsadf', 'sdfads', 'fsdfasdfsd');

That works, however when I use PHP PDO to insert it gives this error:

Table 'Users.User_Acounts' doesn't exist

uhhhh yes it does...

The PHP code:

$hostname = "127.0.0.1";
$port     = "3306";
$database = "Users";
$username = "AccountControl";
$password = "w67hLAanWESGNJMC";

echo ">>";
$db = new PDO("mysql:host=$hostname; port=$port; dbname=$database", $username, $password);
echo ">>";
$UserName = "KiteDev";
$Email = "johndoveail.com";
$PhoneNumber = "66666";
$Password = "dfsgetagfdasg";

// Create the query
$query = "INSERT INTO User_Acounts (UserName, Email, Phon2eNumber, Password) VALUES (:name, :email, :phone, :pass )";

// Prepare statement with $stmt variable
$stmt = $db->prepare($query);
echo ">>";
// Bind parameters, (you can also remove the PDO::PARAM_INT)
$stmt->bindParam(':name', $UserName, PDO::PARAM_STR);
$stmt->bindParam(':email', $Email, PDO::PARAM_STR);
$stmt->bindParam(':phone', $PhoneNumber, PDO::PARAM_STR);
$stmt->bindParam(':pass', $Password, PDO::PARAM_STR);

// Execute the query once you're done binding all the params
$stmt->execute() or die(print_r($stmt->errorInfo(), true));
echo ">>";

Any ideas as to what's causing this?

use User_Accounts instead of User_Acounts. spelling is incorrect in $query = "INSERT INTO User_Acounts — Tamil Selvan C
– Tamil Selvan C, Commented Apr 19, 2014 at 1:54

Rose Kunkel · Accepted Answer · 2014-04-19 01:54:32Z

2

You've misspelled User_Accounts. The table you created is User.User_Accounts but the table that doesn't exist is User.User_Acounts.

answered Apr 19, 2014 at 1:54

Rose Kunkel

3,3082 gold badges30 silver badges54 bronze badges

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

2 Comments

FrostyFire Over a year ago

Augh. This is proof I need a break. Such a dumb mistake. Thanks

Rose Kunkel Over a year ago

Ha, it happens to all of us.

almo · Accepted Answer · 2014-04-19 01:55:19Z

1

You wrote accounts with one c

Table 'Users.User_Acounts' doesn't exist

answered Apr 19, 2014 at 1:55

almo

6,4376 gold badges50 silver badges93 bronze badges

Comments

Tamil Selvan C · Accepted Answer · 2014-04-19 01:56:33Z

1

The Table Name is User_Accounts. In your php code, it is misspelled as User_Acounts

Correct it as

$query = "INSERT INTO User_Accounts (UserName, Email, Phon2eNumber, Password) VALUES (:name, :email, :phone, :pass )";

answered Apr 19, 2014 at 1:56

Tamil Selvan C

20.3k12 gold badges55 silver badges72 bronze badges

Collectives™ on Stack Overflow

Mysql table doesnt exist, but it does

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related