note 76126 added to ref.ibase

Here is a minimalistic code example. Be sure to create an user and a database in order to make it work. <?php // Minimalistic code example // Connection $db = '/path/to/database.gdb'; $user = 'username'; $password = 'password'; $res = ibase_connect($db,$dbuser,$dbpass) or die("<br>" . ibase_errmsg()); // Query $sql="SELECT * FROM table;" $result=ibase_query($res,$sql) or die(ibase_errmsg()); while($row=ibase_fetch_object($result)){ // use $row->FIELDNAME not $row->fieldname print $row->FIELDNAME; } ibase_free_result($result); // Closing ibase_close($res) or die("<br>" . ibase_errmsg()); ?> The following code can be used when creating tables in order to get auto incrementing fields: <?php // This function generates an autoincrement field, such as MySQL AUTO_INCREMENT. function generate_autoincrement($tablename,$primarykey){ // * Generator dbexec('CREATE GENERATOR GEN_' . $tablename . '_PK;'); // * Trigger dbexec('CREATE TRIGGER INC_' . $primarykey . ' FOR ' . $tablename . chr(13) . 'ACTIVE BEFORE INSERT POSITION 0' . chr(13) . 'AS' . chr(13) . 'BEGIN' . chr(13) . 'IF (NEW.' . $primarykey . ' IS NULL) THEN' . chr(13) . 'NEW.' . $primarykey . '= GEN_ID(GEN_' . $tablename . '_PK, 1);' . chr(13) . 'END'); } ?> Usage: <?php generate_autoincrement('table','column name'); ?> ---- Server IP: 200.73.8.42 Probable Submitter: 201.246.251.240 ---- Manual Page -- http://www.php.net/manual/en/ref.ibase.php Edit -- https://master.php.net/note/edit/76126 Del: integrated -- https://master.php.net/note/delete/76126/integrated Del: useless -- https://master.php.net/note/delete/76126/useless Del: bad code -- https://master.php.net/note/delete/76126/bad+code Del: spam -- https://master.php.net/note/delete/76126/spam Del: non-english -- https://master.php.net/note/delete/76126/non-english Del: in docs -- https://master.php.net/note/delete/76126/in+docs Del: other reasons-- https://master.php.net/note/delete/76126 Reject -- https://master.php.net/note/reject/76126 Search -- https://master.php.net/manage/user-notes.php