· 9 years ago · Apr 26, 2017, 04:52 PM
1<?php
2$db = pg_connect("
3host=ec2-54-163-252-55.compute-1.amazonaws.com
4port=5432
5dbname=dbname
6user=user
7password=password
8") or die("Ðевозможно подключитьÑÑ Ðº БД");
9
10if (!$db) {
11 echo "Произошла ошибка.\n";
12 exit;
13}
14
15pg_query($db, "CREATE TABLE IF NOT EXISTS users (
16 id SERIAL PRIMARY KEY,
17 name varchar(30) DEFAULT NULL,
18 pts INT DEFAULT 0);");
19
20pg_query($db, "CREATE TABLE IF NOT EXISTS klik (
21 id SERIAL PRIMARY KEY,
22 kliks INT DEFAULT 0);");
23
24
25?>