StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQLSTATE[42000]: Syntax error or access violation: 1064
primarykey
Id
18988935
data
AcceptedAnswerId
18989914
AnswerCount
2
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2013-09-24T18:10:20.793
FavoriteCount
1
LastActivityDate
2018-04-09T07:23:21.137
LastEditDate
2013-09-24T18:20:08.760
LastEditorUserId
1760090
OwnerUserId
1760090
ParentId
0
PostTypeId
1
Score
2
ViewCount
21358
LastEditorDisplayName
text
Body
I am writing some software right now. Reader's digest version: users select a package, enter their name, email, and desired subdomain. Subdomain is then checked to see if someone already registered it, and if it is only alphanumeric. I had all of this working using OO mysqli, but I have decided to make the move to PDO. Exact wording of the error: <blockquote> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '->subdomain' at line 1 </blockquote> When I get to instantiating my Admin object, all is well. However, when I call the <code>createAccount()</code> function, all hell breaks loose. The stack trace is all over the place, and I can barely figure out when to begin troubleshooting this. I have checked the other answers here, and they all seem too localized, so here's the code that produces it, then all of the methods that contain errors. Here we go.... First, the code that produces the error: <pre><code>include 'classes/Admin.class.php'; $admin = new Admin('test@test.com'); try { $admin->createAccount('John', 'Smith', 'test', 'pro'); } catch(Exception $e) { echo '<pre />'; echo $e->getMessage(); die(print_r($e->getTrace())); } </code></pre> Admin Class Constructor <pre><code>public function __construct($email) { $this->email = $email; include 'Database.class.php'; include 'PasswordHash.php'; define("DB_HOST", "localhost"); define("DB_USER", "root"); define("DB_PASS", ""); define("DB_NAME", "ems"); $this->data = new Database; $this->hasher = new PasswordHash(8, false); } </code></pre> Inside Admin class,checking the subdomain <pre><code>private function checkSubdomain() { $this->data->query('SELECT * FROM clients WHERE subdomain = :subdomain'); $this->data->bind(':subdomain', $this->subdomain); $this->data->execute(); return ($this->data->rowCount() == 0) && (ctype_alnum($this->subdomain)); } </code></pre> PDO class execute, bind, and query <pre><code>public function execute() { return $this->stmt->execute(); } public function query($query) { $this->stmt = $this->dbh->prepare($query); } public function bind($param, $value, $type = null) { if(is_null($type)) { switch(true) { case is_int($value): $type = PDO::PARAM_INT; break; case is_bool($value): $type = PDO::PARAM_BOOL; break; case is_null($value): $type = PDO::PARAM_NULL; default: $type = PDO::PARAM_STR; } } $this->stmt->bindValue($param, $value, $type); } </code></pre> This error is rampant through my code, so I think its only in the PDO class, but my Session class worked just fine. Also, my queries worked perfectly using only mysqli, so I am confident in my syntax. Any help is greatly appreciated. By request, the create account function: <pre><code>public function createAccount($firstname, $lastname, $subdomain, $package) { $this->firstname = $firstname; $this->lastname = $lastname; $this->subdomain = $subdomain; $this->package = $package; //does the subdomain exist, or is it invalid? if(!$this->checkSubdomain()) throw new Exception('This domain is not available. It can only contain letters and numbers and must not already be taken.'); //now comes the table creation, provided everything is in order $this->setup(); } </code></pre> Here's the setup function that is called by createAccount (sans all of the table structures): <pre><code>private function setup() { $isError = false; $queries = array( //all of these are CREATE statements, removed for security reasons ); //need a database that matches with the client subdomain $this->data->query('CREATE TABLE $this->subdomain'); $this->data->bind(':subdomain', $this->subdomain); //PDO secured...execute $this->data->execute(); $this->data->beginTransaction(); foreach($queries as $query) { $this->data->query($query); if(!$this->data->execute()) { //we hit some sort of error, time to GTFO of here $isError = true; $this->data->cancelTransaction(); //die('Error with: ' . $query); break; } } if(!$isError) { $this->data->endTransaction(); mkdir('a/' . $this->subdomain, 0755); $this->generatePass(); //this is where I insert the user into the admin table using PDO, removed for security $this->data->execute(); } $this->data->close(); } </code></pre>
Tags
<php><mysql><pdo>
Title
SQLSTATE[42000]: Syntax error or access violation: 1064
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USbrokekidweb
UserOwnerUserId
1. USbrokekidweb
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.