We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 58d6a62 commit 500d2c5Copy full SHA for 500d2c5
README.md
@@ -137,10 +137,11 @@ Next, create the following in presence_auth.php:
137
```php
138
<?php
139
header('Content-Type: application/json');
140
-if ($_SESSION['user_id']){
141
- $sql = "SELECT * FROM `users` WHERE id='$_SESSION[user_id]'";
142
- $result = mysql_query($sql,$mysql);
143
- $user = mysql_fetch_assoc($result);
+if (isset($_SESSION['user_id'])) {
+ $stmt = $pdo->prepare("SELECT * FROM `users` WHERE id = :id");
+ $stmt->bindValue(':id', $_SESSION['user_id'], \PDO::PARAM_INT);
+ $stmt->execute();
144
+ $user = $stmt->fetch();
145
} else {
146
die('aaargh, no-one is logged in')
147
}
0 commit comments