13 lines
1.0 KiB
PHP
13 lines
1.0 KiB
PHP
<?php
|
|
$pdo = new PDO("pgsql:host=195.189.227.117;dbname=tinytalkhub;user=postgres;password=testing");
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
$get_user = $pdo->prepare("SELECT * FROM users WHERE username = ? AND password = ?; ");
|
|
$get_user_password = $pdo->prepare("SELECT * FROM users WHERE id = ?");
|
|
$get_user_id = $pdo->prepare("SELECT username FROM users WHERE id = ?;");
|
|
$get_user_posts = $pdo->prepare("SELECT content,date::date FROM posts WHERE autor_id = ? ORDER BY id DESC");
|
|
$get_posts_count = $pdo->prepare("SELECT COUNT(*) FROM posts WHERE autor_id = ?");
|
|
$add_user = $pdo->prepare("INSERT INTO users (username,password,avatar_id) VAlUES(?,?,floor(random() * (20-1+1) + 1)::int);");
|
|
$add_post = $pdo->prepare("INSERT INTO posts (content, autor_id, date) VALUES(?, ?, NOW());");
|
|
$get_posts_query = "SELECT posts.id, content, username, date::date,autor_id, avatar_url FROM posts JOIN users ON posts.autor_id = users.id JOIN avatars ON users.avatar_id = avatars.id ORDER BY posts.id DESC";
|
|
?>
|