discussion forum using php, mysql and apache
| From: | Simba Pangeti | Date: | Tue, 16 Oct 2001 14:01:24 +0000 |
| Subject: | discussion forum using php, mysql and apache | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-68229@lists.php.net to get a copy of this message | ||
guys i want to develop or iether to put a discussion forum on my web site
how best can i do this.is there some one with an alredy running module for
this.
Thanks
-----Original Message-----
From: derick@php.net [mailto:derick@php.net]
Sent: 18 October 2001 15:55
To: php-dev@lists.php.net
Subject: [PHP-DEV] Bug #13736 Updated: exec sybase procedure in .php but
only ' 0 'returns!
ID: 13736
Updated by: derick
Reported By: wenk@bt-t.com
Old Status: Open
Status: Bogus
Bug Type: Unknown/Other Function
Operating System: soliars,win2000
PHP Version: 4.0.4pl1
New Comment:
Submitted twice, status: bogus
Previous Comments:
------------------------------------------------------------------------
[2001-10-18 09:48:51] wenk@bt-t.com
I defined the sybase procedure as following:
*******************************************************
create proc circul.circul_hold
@rec_ctrl_id char(10),
@reader_barcode char(14),
@department_id char(2),
@user_id char(4),
@list_no int output,
@errmsg varchar(200) output
as
......
***********************************************************
and I ececuted this proc in test.php as fllowing:
<?php
include "../include/connect.php";
....
$rec_ctrl_id='15400';
$barcode='21113000694135';
$departid='70';
$userid = 'web';
$sql = "declare @list_no2 int, @errmsg2 varchar(200) ";
$sql.= "exec circul.circul_hold
'$rec_ctrl_id','$barcode','$departid','$userid',@list_no
=@list_no2 output,@errmsg=@errmsg2 output ";
$sql.= "select list_no = @list_no2 , errmsg = @errmsg2";
$query=sybase_query($sql);
if ($query){
$array = sybase_fetch_array($query);
echo $array[list_no] .'<br>';
echo $array[errmsg] .'<br>';
}
...
?>
I found that $array[list_no]=$array[list_no]=null,and
sybase_num_rows($query)=1 and $array[0]= 0,which means
only '0' returns (while the sybase proc excute succeed,it always return 0).
But I execute $sql in SYBASE SQL ADVANTAGE ,I can get
$array[list_no] and $array[errmsg] ,whilch are not null.
Why?I have been confused for months.
Please tell me the right way to execute sybase proc with output parameters
in php as soon as possible.
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=13736&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
For additional commands, e-mail: php-dev-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01