RE: [PHP-DB] strange things going on with InterBase and PHP4.02 ???

well, it seems I was wrong on how to supply parameters to ibase_connect() I did ibase_conenct($host, $user, $passwd, "", "", "", $role) and everything went wrong ... somehow As the sixth parameter is the sql dialect using "" (that results to zero in PHP if I am right) will selct an invalid sql dialect. But there's no comlaining from InterBase ... The fourth parameter (character set) can be "" as it defaults to something (e.g. ISO8859_1). The fifth paramter should - as advised by InterBase docs - not be used if $host is not "ALL" but a hostname / db-file path pair on TCP/IP. So ... when I use 3 instead of "" everything is fine ... roles work and I am happy. Maybe this is of help for another newbie to InterBase (like I still am). Cheers, Arne > -----Original Message----- > From: Arne Borkowski (borko.net) [mailto:arne@borko.net] > Sent: Tuesday, September 05, 2000 10:46 PM > To: PHP DB MailingList > Subject: [PHP-DB] strange things going on with InterBase and PHP4.02 ??? > > > hi folks, > > imagine this: > > $hdb = ibase_connect($host, $user, $passwd, "", "", "", > "$role"); > $sql = "SELECT * FROM items WHERE itemnumber = '4711' "; > $hst = ibase_query($hdb, $sql); > > This leads to $hst having a value of 1 > > now this: > > $hdb = ibase_connect($host, $user, $passwd, "", "", "", > "$role"); > $sql = "SELECT itemdescr, itemname FROM items WHERE > itemnumber = '4711' "; > $hst = ibase_query($hdb, $sql); > > This leads to $hst having a value of "resource identifier #2" > > > PLEASE, what is going on there? In the first example I cannot retrieve a > result set or anything else. > In the second case, I cannot pass $hst to ibase_fetch_object($hst) or > ibase_fetch_row($hst). > > Although I bet everything is as per PHP manual, I am going mad about all > this. I SIMPLY DO NOT > UNDERSTAND WHAT HAPPENS ... > > Info: I run Apache 1.3.12 with mod_ssl 2.6.5 and PHP 4.02 and try this all > in non-SSL sesions as well > in a SSL session. All the same. Where do I miss something? > > Cheers, Arne > > > > > ________________________ > Gruss, Arne Borkowski > Hamburg > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >