PHP ʖ²ἯTH
º/A
LXXXI. PostgreSQL ʽ¾ݿ⺯ʽ¿⼯H1
Шdz
°²װ
ԋАʱŤփ
բЩº¯ʽµĐЎªʜµ½ȫ¾ּA HREF="configuration.html#configuration.file" Ťփ΄¼þ php.ini µē°Ϭ¡£
û³Ƽ/TH
Ĭȏֵ
¿ɱ䷶Χ
pgsql.allow_persistent
"1"
PHP_INI_SYSTEM
pgsql.max_persistent
"-1"
PHP_INI_SYSTEM
pgsql.max_links
"-1"
PHP_INI_SYSTEM
pgsql.auto_reset_persistent
"0"
PHP_INI_SYSTEM
pgsql.ignore_notice
"0"
PHP_INI_ALL
pgsql.log_notice
"0"
PHP_INI_ALL
ʹӃ·½·¨¼°̡ʾ
¾¯¸漯B
¾¯¸漯B
Ђû³Ƽ/TH
pg_exec()
pg_query()
pg_getlastoid()
pg_last_oid()
pg_cmdtuples()
pg_affected_rows()
pg_numrows()
pg_num_rows()
pg_numfields()
pg_num_fields()
pg_fieldname()
pg_field_name()
pg_fieldsize()
pg_field_size()
pg_fieldnum()
pg_field_num()
pg_fieldprtlen()
pg_field_prtlen()
pg_fieldisnull()
pg_field_is_null()
pg_freeresult()
pg_free_result()
pg_result()
pg_fetch_result()
pg_loreadall()
pg_lo_read_all()
pg_locreate()
pg_lo_create()
pg_lounlink()
pg_lo_unlink()
pg_loopen()
pg_lo_open()
pg_loclose()
pg_lo_close()
pg_loread()
pg_lo_read()
pg_lowrite()
pg_lo_write()
pg_loimport()
pg_lo_import()
pg_loexport()
pg_lo_export()
Postmaster
PHP
״̬
postmaster
pg_connect("dbname=MyDbName");
OK
postmaster -i
pg_connect("dbname=MyDbName");
OK
postmaster
pg_connect("host=localhost dbname=MyDbName");
Unable to connect to PostgreSQL server: connectDB() failed: Is the postmaster running and accepting TCP/IP (with -i) connection at 'localhost' on port '5432'? in /path/to/file.php on line 20.
postmaster -i
pg_connect("host=localhost dbname=MyDbName");
OK
Ҕǰµē£º $conn = pg_connect ("host", "port", "options", "tty", "dbname") ґ¾²»ԙ̡³«ʹӃ¡£
PGHOST=pgsql.example.com PGPORT=7890 PGDATABASE=web-system PGUSER=web-user PGPASSWORD=secret PGDATESTYLE=ISO PGTZ=JST PGCLIENTENCODING=EUC-JP export PGHOST PGPORT PGDATABASE PGUSER PGPASSWORD PGDATESTYLE PGTZ PGCLIENTENCODING
Ԥ¶¨ҥ³£
ӉӚբЩ³£ʇӉ¸À©չģ¿鶨ҥµģ¬Ҳ´˖»ӐԚ¸À©չģ¿鱻±ҫµ½ PHP £¬»ڔːЊ±±»¶¯̬¼Ӕغ³£²œА§¡£
·¶=
=ד 2. ʹӃ Large Object
?php $database = pg_connect ("dbname=jacarta"); pg_query ($database, "begin"); $oid = pg_lo_create ($database); echo "$oid\n"; $handle = pg_lo_open ($database, $oid, "w"); echo "$handle\n"; pg_lo_write ($handle, "large object data"); pg_lo_close ($handle); pg_query ($database, "commit");?
º/A
ưµ㼯A
posix_uname
ɏһ¼¶
pg_affected_rows