Zrejme nejde navazat spojeni s Postgresql – PHP – Fórum – Programujte.com

Zdar, sem si stahl a nainstalovat postgresql a vytvoril si tabulku. A k tomu v php skriptik

<?

$conn = Pg_connect("host=localhost user=postgres password=heslo dbname=postgres port=5432");

$result = pg_exec("SELECT * FROM otanet");

$pocet = pg_NumRows($result);

echo "V tabulce otanet je $pocet záznamů.";

pg_Close($conn);

?>

sedlons píše:#
# bohuzel se moi zobrazi jenom prazdna stranka a neviim co s tim.

<?php

echo 'hello world';

?>

error_reporting  =  E_ALL



; Print out errors (as a part of the output).  For production web sites,

; you're strongly encouraged to turn this feature off, and use error logging

; instead (see below).  Keeping display_errors enabled on a production web site

; may reveal security information to end users, such as file paths on your Web

; server, your database schema or other information.

display_errors = on



; Even when display_errors is on, errors that occur during PHP's startup

; sequence are not displayed.  It's strongly recommended to keep

; display_startup_errors off, except for when debugging.

display_startup_errors = on

To D1ce: Velice dik za ten error raport. diky tomu jsem prisel na to, ze 1. potrebuju modul do php pro komunikaci s psql (pod linuxem to neni *.dll) a pak jeste v souboru /var/lib/pgsql/data/pg_hba.conf zmenit

 local all all md5



 host all all 127.0.0.1 255.255.255.255 md5

sedlons píše:#
# 1. potrebuju modul do php pro komunikaci s psql (pod linuxem to neni *.dll) a pak jeste v souboru /var/lib/pgsql/data/pg_hba.conf zmenit

 local all all md5#
##
# host all all 127.0.0.1 255.255.255.255 md5

To D1ce: hm, podle me, ten kdo nema pc jenom na hrani her, tak pro neho je linux jasna volba. Zvlast pro programatory. Uff sem rad ze s tim umim pracovat, nez abych musel neco slozite resit ve windoušich. Podle mne linux je (ackoliv se to nezda) lechcii.

Jinak jsem se jeste chtel zeptat: Mam tabulku, v ktery je jmeno, ipadresa,,,,. Mno a potrebuju z ty ipadresy (napr. 192.168.8.96) vytahnout posledni 2 cisla, vim slo by to jednoduse, jenze se meni pocet cifer. diik

V pgSQL takto:
brute force:

--skoda, ze strpos nepodporuje parametr offset, mohlo to byt o mnoho lepsi

db=# SELECT SUBSTR(SUBSTR(COLUMN1, STRPOS(COLUMN1, '.') + 1), STRPOS(SUBSTR(COLUMN1, STRPOS(COLUMN1, '.') + 1), '.') + 1) AS final FROM mytbl;

--nevim proc mi nefacha \d

db=# SELECT SUBSTRING(COLUMN1 from '[0-9]+\.[0-9]+$') AS final FROM mytbl;

echo substr('192.168.8.96', strpos('192.168.8.96', '.', strpos('192.168.8.96', '.') + 1) + 1);

To D1ce: Ok, diik!