clockwerk-www – Diff between revs 7 and 43

Subversion Repositories:
Rev:
Show entire file – Ignore whitespace
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 }