Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, mysql feiertage, bash netcat eof, 192.168.1.41:8000

Links

XODOX
Impressum

#1: crud application please help

Posted on 2011-05-16 04:19:27 by hatem gamal elzanaty

hi,
can you please guide me in a crud application for one table that have
auto increment serial number for each record can you please give what
syntax do i have to enter new record without writing manually the id of
the record through php connection to postgresql if you can send me an
example for one table with two fields it would be more than enough i
would appreciate if you gave me a link , book name , tutorial web site
,........ etc
thanks in advance

hatem gamal
201515604034
hatem@softpro.bz

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Report this message

#2: Re: crud application please help

Posted on 2011-05-16 09:13:38 by Rod

On 16/05/2011 03:19, hatem gamal elzanaty wrote:
> hi,
> can you please guide me in a crud application for one table that have
> auto increment serial number for each record can you please give what
> syntax do i have to enter new record without writing manually the id of
> the record through php connection to postgresql if you can send me an
> example for one table with two fields it would be more than enough i
> would appreciate if you gave me a link , book name , tutorial web site

Auto-incrementing columns, or SERIAL types [1]:

http://www.postgresql.org/docs/9.0/static/datatype-numeric.h tml#DATATYPE-SERIAL

Default values - look for the DEFAULT keyword:

http://www.postgresql.org/docs/9.0/static/sql-createtable.ht ml

[1] Note that SERIAL isn't a real type, but just syntactic sugar that
creates a sequence and sets the column to pull from the sequence by
default. More on sequences:

http://www.postgresql.org/docs/9.0/static/sql-createsequence .html

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Report this message