$pdo = new PDO('mysql:host=' . $host . ';dbname=' . $database, $username, $password); $query = " SELECT * FROM [database] "; $stmt = $pdo->query($query); foreach ($stmt->fetchAll() as $item) { $data[] = $item; }$stmt = $pdo->prepare("SELECT * FROM table WHERE id = ?"); $stmt->execute([$id]); $result = $stmt->fetchAll(); <?php $sql = 'SELECT name, color, calories FROM fruit ORDER BY name'; foreach ($conn->query($sql) as $row) { print $row['name'] . "\t"; print $row['color'] . "\t"; print $row['calories'] . "\n"; } ?> select a particular user by id$pdo = new PDO('mysql:host=' . $host . ';dbname=' . $db, $user, $pass); $query = " INSERT INTO [table] (column1, column2, column3) VALUES (:value1, :value2, :value3) "; $pdo->prepare($query)->execute([ 'value1' => $variable1, 'value2' => $variable2, 'value3' => $variable3 ]);