Firebird 2.0 PHP5 Programming Manual
|
FBIRD_QUERY –
NEW DATABASE CREATION
Purpose
Use a special form of the fbird_query function to
create a new database.
Syntax
<connect_query> ::= fbird_query(
IBASE_CREATE, create_sql)
Element
|
Type
|
Description
|
create_sql
|
string
|
A valid DB creation statement
|
<return>
|
mixed
|
A connection handle on success, False on failure
|
Semantics
When called with the special connection handle
IBASE_CREATE, the fbird_query function accepts one type of SQL
statement, the create database statement. See the next topic for
syntax.
Example
The below example creates a test database with one
table containing one row:
$user = 'SYSDBA'; $password =
'masterkey'; $test_db = fbird_query(IBASE_CREATE,
sprintf("CREATE SCHEMA 'test.fdb' USER
'%s' PASSWORD '%s' DEFAULT CHARACTER SET NONE",
$user, $password)); $tr =
fbird_trans($test_db); fbird_query($tr,"create table test1 (i
integer, c
varchar(100))"); fbird_commit_ret($tr); fbird_query($tr,"insert
into test1(i, c) values(1, 'test table not created
with isql')"); fbird_commit($tr); fbird_close($test_db);
See also
create
syntax
|
Legal information
|
User comments:
| Contributed by bfimy rxstp on 17 February 2007 12:56 AM | dqiv zcdafby vystquof vzek jcmvn tbghwand eqblki | | Contributed by Kazelpmu on 26 February 2008 06:31 PM | Hi webmaster! | | Contributed by Samuel on 6 May 2008 05:28 PM | jRtoKq Hello! I\'m Samuel Smith, i\'m from Switqerland i and find your site really brilliant! | | Contributed by 24222 on 9 May 2008 09:07 PM | comment5, | | Contributed by 24139 on 9 May 2008 09:07 PM | comment6, | | Contributed by 36538 on 9 May 2008 09:07 PM | comment6, | | Contributed by порно галерея 10729 on 12 May 2008 10:18 PM | comment2, | | Contributed by порно галерея 10729 on 12 May 2008 10:18 PM | comment2, | | Contributed by порно галерея 10729 on 12 May 2008 10:18 PM | comment6, | | Contributed by порно галерея 10729 on 12 May 2008 10:18 PM | comment2, | | Contributed by порно галерея 19953 on 13 May 2008 12:05 AM | comment1, | | Contributed by порно галерея 19953 on 13 May 2008 12:05 AM | comment2, | | Contributed by порно галерея 19953 on 13 May 2008 12:05 AM | comment4, | | Contributed by порно галерея 20390 on 13 May 2008 11:13 PM | comment5, | | Contributed by порно галерея 20390 on 13 May 2008 11:13 PM | comment2, | | Contributed by порно галерея 20390 on 13 May 2008 11:13 PM | comment5, | | Contributed by порно галерея 24919 on 14 May 2008 12:15 PM | comment5, | | Contributed by порно галерея 24919 on 14 May 2008 12:15 PM | comment6, | | Contributed by порно галерея 24919 on 14 May 2008 12:15 PM | comment4, | | Contributed by порно галерея 22829 on 15 May 2008 09:12 AM | comment4, | | Contributed by порно галерея 22829 on 15 May 2008 09:12 AM | comment6, | | Contributed by порно галерея 22829 on 15 May 2008 09:12 AM | comment1, | | Contributed by порно галерея 29145 on 16 May 2008 05:32 PM | comment1, | | Contributed by порно галерея 29145 on 16 May 2008 05:32 PM | comment4, | | Contributed by порно галерея 29145 on 16 May 2008 05:32 PM | comment6, | | Contributed by DvlcYGvqYXxmUhgi on 1 June 2008 09:45 AM | doors.txt;10;15 | | Contributed by uwho pmzt on 9 August 2008 09:50 PM | fxsqaby akycedtz pztvqmis uejy bldfko ngsqtjdc stqvncbj | |
Extend this topic - Post a comment |
|