clockwerk-www – Diff between revs 7 and 43
?pathlinks?
Rev 7 | Rev 43 | |||
---|---|---|---|---|
Line 65... | Line 65... | |||
65 | } |
65 | } |
|
66 | } |
66 | } |
|
67 | try { |
67 | try { |
|
68 | $mysql = new PDO('mysql:host=MYSQL_HOSTNAME;dbname=MYSQL_DATABASE;', 'MYSQL_USERNAME', 'MYSQL_PASSWORD'); |
68 | $mysql = new PDO('mysql:host=MYSQL_HOSTNAME;dbname=MYSQL_DATABASE;', 'MYSQL_USERNAME', 'MYSQL_PASSWORD'); |
|
69 | $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
69 | $mysql->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
|
70 | $query = $mysql->prepare("INSERT INTO DB_REALM.account (username,sha_pass_hash,email) VALUES(:username,:password,:email)"); |
- | ||
71 | $query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); |
70 | $query = $mysql->prepare("SELECT RegionName FROM regions WHERE owner_uuid=(SELECT PrincipalID FROM UserAccounts WHERE FirstName=:first AND LastName=:last)"); |
|
72 | $query->bindParam(':first', $first); |
71 | $query->bindParam(':first', $first); |
|
73 | $query->bindParam(':last', $last); |
72 | $query->bindParam(':last', $last); |
|
74 | $query->execute(); |
73 | $query->execute(); |
|
75 | } |
74 | } |