[PHP-DB] Flash/PHP Resources

2003-02-11 Thread Bruce Levick
Bruce Levick - VivamotionWhere can I find some good resources for tutorials
to pass php queries into flash??

Cheers






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] CDBPHP

2003-02-11 Thread Unknown
Dear Gurus,
Does anyone refer me to the links of PHP interface to CDB (Bernsteins)
module?Coulnd't find yet.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] collaborating on a document

2003-02-11 Thread Baumgartner Jeffrey
I'm thinking about making a little tool where people can contribute ideas in
real time. Thus far, the best way I can see to do this is via 2 frames

Frame 1: for entering data - which is inserted into a table. 

Frame 2: would select from the table.  It would also refresh frequently -
say every 30 seconds.

But perhaps you have a more elegant solution?

Thanks,

Jeffrey Baumgartner

eBusiness Consultant - ITP Europe
http://www.itp-europe.com
[EMAIL PROTECTED]
+32 2 721 51 00


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Hutchins, Richard
1. This question has nothing to do with PHP or databases.
2. Adobe already thought of it: Adobe Acrobat 5.0.

 -Original Message-
 From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 11, 2003 10:13 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] collaborating on a document
 
 
 I'm thinking about making a little tool where people can 
 contribute ideas in
 real time. Thus far, the best way I can see to do this is via 2 frames
 
 Frame 1: for entering data - which is inserted into a table. 
 
 Frame 2: would select from the table.  It would also refresh 
 frequently -
 say every 30 seconds.
 
 But perhaps you have a more elegant solution?
 
 Thanks,
 
 Jeffrey Baumgartner
 
 eBusiness Consultant - ITP Europe
 http://www.itp-europe.com
 [EMAIL PROTECTED]
 +32 2 721 51 00
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Adam Voigt




Riiight, anyway, since Adobe Acrobat is the worst possible answer for

updating in real time (and completely wouldn't work), I would say, yes,

two frames should work, but you might even want a third (hidden) at the

bottom that never stops executing, just pulling entry's out when new ones

are added, and use _javascript_ to add them to the right frames with the ideas.



On Tue, 2003-02-11 at 10:16, Hutchins, Richard wrote:

1. This question has nothing to do with PHP or databases.

2. Adobe already thought of it: Adobe Acrobat 5.0.



 -Original Message-

 From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]

 Sent: Tuesday, February 11, 2003 10:13 AM

 To: [EMAIL PROTECTED]

 Subject: [PHP-DB] collaborating on a document

 

 

 I'm thinking about making a little tool where people can 

 contribute ideas in

 real time. Thus far, the best way I can see to do this is via 2 frames

 

 Frame 1: for entering data - which is inserted into a table. 

 

 Frame 2: would select from the table.  It would also refresh 

 frequently -

 say every 30 seconds.

 

 But perhaps you have a more elegant solution?

 

 Thanks,

 

 Jeffrey Baumgartner

 

 eBusiness Consultant - ITP Europe

 http://www.itp-europe.com

 [EMAIL PROTECTED]

 +32 2 721 51 00

 

 

 -- 

 PHP Database Mailing List (http://www.php.net/)

 To unsubscribe, visit: http://www.php.net/unsub.php

 



-- 

PHP Database Mailing List (http://www.php.net/)

To unsubscribe, visit: http://www.php.net/unsub.php






-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc








signature.asc
Description: This is a digitally signed message part


RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Hutchins, Richard
Actually, Adobe 5.0 implemented on a server in Assembled or Integrated
(their words, not mine) configuration DOES allow for real-time document
collaboration. Whether this solution would actually solve the problem is
determined by the requirements of the collaboration environment.

If you're thinking Acrobat 4.0, you're absolutely right. Real-time
collaboration is, for all practical purposes, non-existent.

I'm not going to get into any further debate because it's off topic and all
of the information is available on Adobe.com, specifically in the following
links:
http://www.adobe.com/products/acrobat/pdfs/acr05_review_wp.pdf
and, more generally, http://www.adobe.com/acrofamily/collaboration.html.

In regards to actually implementing a solution using JS, yes can work, but
you're walking what can be a tight rope on client-side configuration. Some
of the standard issues are:
1. You have to make sure your users all have JS enabled or your app won't
work.
2. You'll have to write cross-browser compatible code back to v. 4.0
browsers as a standard.
3. Refreshing a screen every 30 seconds is going to really tick off users
that don't have DSL or better connections.

These issues are certainly not insurmountable. All of the above concerns can
be alleviated, if not eliminated, if you're going to implement on an
intranet where you have control over what clients are used. But in the WWW
arena, you just don't know what clients are going to be used.
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 10:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] collaborating on a document


Riiight, anyway, since Adobe Acrobat is the worst possible answer
for 
updating in real time (and completely wouldn't work), I would say, yes, 
two frames should work, but you might even want a third (hidden) at the 
bottom that never stops executing, just pulling entry's out when new ones 
are added, and use javascript to add them to the right frames with the
ideas. 

On Tue, 2003-02-11 at 10:16, Hutchins, Richard wrote: 
1. This question has nothing to do with PHP or databases. 
2. Adobe already thought of it: Adobe Acrobat 5.0. 

 -Original Message- 
 From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, February 11, 2003 10:13 AM 
 To: [EMAIL PROTECTED] 
 Subject: [PHP-DB] collaborating on a document 
 
 
 I'm thinking about making a little tool where people can 
 contribute ideas in 
 real time. Thus far, the best way I can see to do this is via 2 frames 
 
 Frame 1: for entering data - which is inserted into a table. 
 
 Frame 2: would select from the table. It would also refresh 
 frequently - 
 say every 30 seconds. 
 
 But perhaps you have a more elegant solution? 
 
 Thanks, 
 
 Jeffrey Baumgartner 
 
 eBusiness Consultant - ITP Europe 
 http://www.itp-europe.com 
 [EMAIL PROTECTED] 
 +32 2 721 51 00 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/) 
 To unsubscribe, visit: http://www.php.net/unsub.php 
 

-- 
PHP Database Mailing List (http://www.php.net/) 
To unsubscribe, visit: http://www.php.net/unsub.php 

-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Adam Voigt




Ofcourse then everyone has to have Adobe installed, which is probably less likely

then having _javascript_ enabled.



On Tue, 2003-02-11 at 10:39, Hutchins, Richard wrote:

Actually, Adobe 5.0 implemented on a server in Assembled or Integrated

(their words, not mine) configuration DOES allow for real-time document

collaboration. Whether this solution would actually solve the problem is

determined by the requirements of the collaboration environment.



If you're thinking Acrobat 4.0, you're absolutely right. Real-time

collaboration is, for all practical purposes, non-existent.



I'm not going to get into any further debate because it's off topic and all

of the information is available on Adobe.com, specifically in the following

links:

http://www.adobe.com/products/acrobat/pdfs/acr05_review_wp.pdf

and, more generally, http://www.adobe.com/acrofamily/collaboration.html.



In regards to actually implementing a solution using JS, yes can work, but

you're walking what can be a tight rope on client-side configuration. Some

of the standard issues are:

1. You have to make sure your users all have JS enabled or your app won't

work.

2. You'll have to write cross-browser compatible code back to v. 4.0

browsers as a standard.

3. Refreshing a screen every 30 seconds is going to really tick off users

that don't have DSL or better connections.



These issues are certainly not insurmountable. All of the above concerns can

be alleviated, if not eliminated, if you're going to implement on an

intranet where you have control over what clients are used. But in the WWW

arena, you just don't know what clients are going to be used.

-Original Message-

From: Adam Voigt [mailto:[EMAIL PROTECTED]]

Sent: Tuesday, February 11, 2003 10:25 AM

To: [EMAIL PROTECTED]

Cc: [EMAIL PROTECTED]

Subject: RE: [PHP-DB] collaborating on a document





Riiight, anyway, since Adobe Acrobat is the worst possible answer

for 

updating in real time (and completely wouldn't work), I would say, yes, 

two frames should work, but you might even want a third (hidden) at the 

bottom that never stops executing, just pulling entry's out when new ones 

are added, and use _javascript_ to add them to the right frames with the

ideas. 



On Tue, 2003-02-11 at 10:16, Hutchins, Richard wrote: 

1. This question has nothing to do with PHP or databases. 

2. Adobe already thought of it: Adobe Acrobat 5.0. 



 -Original Message- 

 From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] 

 Sent: Tuesday, February 11, 2003 10:13 AM 

 To: [EMAIL PROTECTED] 

 Subject: [PHP-DB] collaborating on a document 

 

 

 I'm thinking about making a little tool where people can 

 contribute ideas in 

 real time. Thus far, the best way I can see to do this is via 2 frames 

 

 Frame 1: for entering data - which is inserted into a table. 

 

 Frame 2: would select from the table. It would also refresh 

 frequently - 

 say every 30 seconds. 

 

 But perhaps you have a more elegant solution? 

 

 Thanks, 

 

 Jeffrey Baumgartner 

 

 eBusiness Consultant - ITP Europe 

 http://www.itp-europe.com 

 [EMAIL PROTECTED] 

 +32 2 721 51 00 

 

 

 -- 

 PHP Database Mailing List (http://www.php.net/) 

 To unsubscribe, visit: http://www.php.net/unsub.php 

 



-- 

PHP Database Mailing List (http://www.php.net/) 

To unsubscribe, visit: http://www.php.net/unsub.php 



-- 

Adam Voigt ([EMAIL PROTECTED])

The Cryptocomm Group

My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc



-- 

PHP Database Mailing List (http://www.php.net/)

To unsubscribe, visit: http://www.php.net/unsub.php






-- 
Adam Voigt ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc








signature.asc
Description: This is a digitally signed message part


RE: [PHP-DB] collaborating on a document

2003-02-11 Thread Mark
1-Since he's posting to a PHP-DB list, I think we can assume he plans
to implement it in PHP using a database to capture and store the
comments/ideas. 

Jeff - Do you have a plan in place for your DB schema or the backend
processing that might take place?

2-Adobe may have a solution, but that doesn't mean a)it's the best
solution, b) it's an affordable solution, and c) there's no room for
developing another solution. If that were the case, there would only
be one software company in the world. For that matter, there'd be
only one anything company in the world.

3-No reason to be a jerk.

--- Hutchins, Richard [EMAIL PROTECTED] wrote:
 1. This question has nothing to do with PHP or databases.
 2. Adobe already thought of it: Adobe Acrobat 5.0.
 
  -Original Message-
  From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, February 11, 2003 10:13 AM
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] collaborating on a document
  
  
  I'm thinking about making a little tool where people can 
  contribute ideas in
  real time. Thus far, the best way I can see to do this is via 2
 frames
  
  Frame 1: for entering data - which is inserted into a table. 
  
  Frame 2: would select from the table.  It would also refresh 
  frequently -
  say every 30 seconds.
  
  But perhaps you have a more elegant solution?
  
  Thanks,
  
  Jeffrey Baumgartner
  
  eBusiness Consultant - ITP Europe
  http://www.itp-europe.com
  [EMAIL PROTECTED]
  +32 2 721 51 00
  
  
  -- 
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
  
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a right unless you are willing to fight to death to 
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***

__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Code for drop down lists

2003-02-11 Thread Roland Perez
I am a novice to PHP and am trying toget a survey with drop down lists.
I am stuck as to if I should connect to the DB (MySQL DB) to get the
values from a table or do I imbed them in the php file?

Thanks for any help in advance.
Roland Perez
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] PHP 4.3.0 + MSSQL database authentication problem?

2003-02-11 Thread Alan Murrell
Hello,

Because I am not sure if this is just a PHP issue or a
PHP+DB issue, I will be posting this message
(seperately) to bith the General and PHP-DB lists.

First, a brief rundown of my setup:

Mandrake Linux 9.0
Apache 1.3.27
PHP 4.3.0

We are in the process of rebuilding our outdated
servers, and all sites have been moved over
successfully, except our own, which has a Control
Panel login.  The login authentication is done using
FreeTDS to an MSSQL 2000 database.

This setup works fine on the current server, but when
I test it on the new server, the authentication seems
to work fine, but instead of the screen I normally see
when logging in, I just get kicked back to the Control
Panel login screen.

At first, I suspected FreeTDS, but I have confirmed
that a connection is definately being made by enabling
and examining the dump file.  The FreeTDS mailing
list has confirmed that this is also the case.

The current (working) server is running Apache 1.3.27
+ PHP v4.1.2 .  I had a similar problem on the current
working server when I tried upgrading the PHP to
v4.2.3 just before Xmas.

I have not yet tried downgrading to v4.1.2 on the
new server, and would rather not. :-)

I am not really sure where to proceed from here.  I
can provide any further information you need, or can
possibly provide a Test account if you wish to see
for yourself what it is doing, which may give some
ideas as to what is happening.

Is there perhaps some logging variables I can enable
in the Control Panel PHP script to see what is going
on?

Thank you, in advance, for your help and advice in
this matter.

Sincerely,

Alan Murrell [EMAIL PROTECTED]


__ 
Post your free ad now! http://personals.yahoo.ca

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Code for drop down lists

2003-02-11 Thread NIPP, SCOTT V (SBCSI)
I would most definitely recommend pulling them from a DB table
rather than hard coding these into a page.  Here is a code snippet that I
use to do this on one of my pages:

mysql_select_db($Prod, $Prod);
$query_systems = SELECT Name FROM systems ORDER BY Name ASC;
$systems = mysql_query($query_systems, $Prod) or die(mysql_error());
# $row_systems = mysql_fetch_assoc($systems);
$totalRows_systems = mysql_num_rows($systems);
$sys_list = select size=\1\ name=\system\\n;
$sys_list .= optionSystem Name/option\n;
$sys_list .= option---/option\n;
while($name = mysql_fetch_row($systems)) {
  $sys_list .= option$name[0]/option\n;
}
$sys_list .= /select\n;

  snip...HTML portion below 

td width=124 valign=topdiv align=rightSystem Name:/div/td
  td colspan=2 valign=top 
?=$sys_list?

 snip 

I also do this with Enum field selections using the following
function that someone passed on to me:

function getEnumOptions($table, $field) {
   global $finalResult;
   $finalResult = array();

   if (strlen(trim($table))  1) return false;
   $query  = show columns from $table;
   $result = mysql_query($query);
   while ($row = mysql_fetch_array($result)){
if ($field != $row[Field]) continue;
//check if enum type
if (ereg('enum.(.*).', $row['Type'], $match)) {
$opts = explode(',', $match[1]);
foreach ($opts as $item)
$finalResult[] = substr($item, 1, strlen($item)-2);
}
else
return false;
   }
   return $finalResult;

You can then use code similar to the first example to create your
dropdown list from Enum field values.  I hope this helps.

-Original Message-
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 11:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Code for drop down lists


I am a novice to PHP and am trying toget a survey with drop down lists.
I am stuck as to if I should connect to the DB (MySQL DB) to get the
values from a table or do I imbed them in the php file?

Thanks for any help in advance.
Roland Perez
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Code for drop down lists

2003-02-11 Thread George Pitcher
If the list is something that may change more than just coccasionally, then
use the database field value. If its going to be really static, then hard
code it into the web form.

Now the code:

?php
$drop_down_list = select name=HEI_ID;
$link = mysql_connect ('localhost', 'user', 'password') // Connects to
database server
or die (Could not select db);
mysql_select_db ('Heronsql') // opens database
or die (Could not connect);
$query=select distinct Nickname, HEI_ID from Customers where (Nickname 
'') order by Nickname; // sets up the find
$result = mysql_query ($query); // runs the find
$num = mysql_num_rows($result); //goes thru each row building the display
for ($i = 0; $i  $num; $i++) {
$HEI = mysql_result($result, $i, Nickname);
$HEI_ID = mysql_result($result, $i, HEI_ID);
$drop_down_list .= option value=$HEI_ID$HEI/option;
}
mysql_close($link);

$drop_down_list .= /select;

echo $drop_down_list; // prints the display

?

This works for me on both Linux and Win servers.

Cheers

George

 -Original Message-
 From: Roland Perez [mailto:[EMAIL PROTECTED]]
 Sent: 11 February 2003 5:03 pm
 To: Receipt Notification Requested
 Subject: [PHP-DB] Code for drop down lists


 I am a novice to PHP and am trying toget a survey with drop down lists.
 I am stuck as to if I should connect to the DB (MySQL DB) to get the
 values from a table or do I imbed them in the php file?

 Thanks for any help in advance.
 Roland Perez
 [EMAIL PROTECTED]

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] Code for drop down lists

2003-02-11 Thread Gary . Every
Always use a DB when you can, makes it much easier to change params.

Here's a snippet you can use:

### SELECT BOX CODE ###
  echo '
   tdSELECT NAME=change SIZE=1';
  $sql = SELECT * from ai.reports order by name;
   $selections = get_rowset($conn_id,$sql);
foreach($selections as $selection){
 echo 'OPTION';
  $reptmp = $selection['name'];
   if ($val == $reptmp){
echo ' SELECTED';
   }
  echo '' . $selection['name'];
}
  echo '/select/td';
  ##

CAVEATS:
The get_rowset is a function we've written for retrieving an array from the
DB
The if $val == $reptmp is to check for whatshould be selected


Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com


-Original Message-
From: Roland Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 11:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Code for drop down lists


I am a novice to PHP and am trying toget a survey with drop down lists.
I am stuck as to if I should connect to the DB (MySQL DB) to get the
values from a table or do I imbed them in the php file?

Thanks for any help in advance.
Roland Perez
[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] PHP 4.3.0 + MSSQL database authenticationproblem?

2003-02-11 Thread Frank M. Kromann
Hi Alan,

I'm not sure what 'Control Panel PHP script' means ?

What version of FreeTDS are you using ?
Do you use the sybase or the mssql extension in PHP ?

- Frank

 Hello,
 
 Because I am not sure if this is just a PHP issue or a
 PHP+DB issue, I will be posting this message
 (seperately) to bith the General and PHP-DB lists.
 
 First, a brief rundown of my setup:
 
 Mandrake Linux 9.0
 Apache 1.3.27
 PHP 4.3.0
 
 We are in the process of rebuilding our outdated
 servers, and all sites have been moved over
 successfully, except our own, which has a Control
 Panel login.  The login authentication is done using
 FreeTDS to an MSSQL 2000 database.
 
 This setup works fine on the current server, but when
 I test it on the new server, the authentication seems
 to work fine, but instead of the screen I normally see
 when logging in, I just get kicked back to the Control
 Panel login screen.
 
 At first, I suspected FreeTDS, but I have confirmed
 that a connection is definately being made by enabling
 and examining the dump file.  The FreeTDS mailing
 list has confirmed that this is also the case.
 
 The current (working) server is running Apache 1.3.27
 + PHP v4.1.2 .  I had a similar problem on the current
 working server when I tried upgrading the PHP to
 v4.2.3 just before Xmas.
 
 I have not yet tried downgrading to v4.1.2 on the
 new server, and would rather not. :-)
 
 I am not really sure where to proceed from here.  I
 can provide any further information you need, or can
 possibly provide a Test account if you wish to see
 for yourself what it is doing, which may give some
 ideas as to what is happening.
 
 Is there perhaps some logging variables I can enable
 in the Control Panel PHP script to see what is going
 on?
 
 Thank you, in advance, for your help and advice in
 this matter.
 
 Sincerely,
 
 Alan Murrell [EMAIL PROTECTED]
 
 
 __ 
 Post your free ad now! http://personals.yahoo.ca
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] fgets find string help please

2003-02-11 Thread Dave Carrera
Hi all
 
I would like to find a string say “hello” from the result of my
fsockopen result.
 
I have searched all over for an answer but to no avail so I hand it over
to you clever people here.
 
The kind of result I want is if string excists the $result = 0 else
$result = 1
 
I can carry on from there….
 
while(!feof($socket)) {
   echo fgets($socket,128);
  }
  fclose($socket);
 
$socket is working and echoing a result.
 
Any help is very much appreciated
 
Dave Carrera

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 



Re: [PHP-DB] for xml auto from MS Sql Server

2003-02-11 Thread Frank M. Kromann
Hi,

selectting XML data forces the result to be returned a a unicode text
field. That is not suported by the DBLIB library (From Microsoft) used to
build the mssql extension does not support that.

You can use ODBC or you can wait untill I have a working compy of FreeTDS
on Win32. FreeTDS is developed to access MS SQL and Sybase servers from
(nix, and I have just tested 'for xml auto' from my Mandrake 9.0 box to a
SQL Server 2000, and it seams to be working.

- Frank

 Folks,
 
 I'd like to use Microsoft SQL Server 2000 XML capabilities for
generating
 query results in XML. It is very easy, just say for xml auto at the
end of
 your query.
 
 The problem is that I cannot seem to retrieve the results back into
PHP.
 Anyone ever accomplish this?
 
 Daniel
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PHP 4.3.0 + MSSQL database authentication problem?

2003-02-11 Thread Alan Murrell
Hi Frank,

--- Frank M. Kromann [EMAIL PROTECTED] wrote:
 I'm not sure what 'Control Panel PHP script' means ?

I meant the PHP page itself that is the Control Panel
(i.e., 's_controlpanel.php')

 What version of FreeTDS are you using ?

0.60 on the new server; I am not sure about the
currently working server, but I think it is 0.50 or
0.51.

 Do you use the sybase or the mssql extension in PHP

The Sybase one ('sybase_connect').  The PHP was
compiled with the '--with-sybase=/path/to/freetds'
option.

Thanx!

Alan


__ 
Post your free ad now! http://personals.yahoo.ca

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PHP 4.3.0 + MSSQL database authenticationproblem?

2003-02-11 Thread Frank M. Kromann
Hi Alan,

Did you configure FreeTDS with the right tdsver ? This can be none when
compiling FreetTDS using --with-tdsver=7.0 or in freetds.conf.

You should use the correct version according to your MSSQL server (70. =
SQL Server 7, 80 = SQL Server 2000).

From PHP 4.3.0 you can compile php using --with-mssql=/path/to/freetds.
FreeTDS needs to be compiled with --enable-msdblib, and you need to change
your code (sybase_* should be mssql_*). The upside is access to all the
mssql_* functions.

I'm using this on a Mandrake 9.0 system and it works fine (FreeTDS 0.61)

- Frank

 Hi Frank,
 
 --- Frank M. Kromann [EMAIL PROTECTED] wrote:
  I'm not sure what 'Control Panel PHP script' means ?
 
 I meant the PHP page itself that is the Control Panel
 (i.e., 's_controlpanel.php')
 
  What version of FreeTDS are you using ?
 
 0.60 on the new server; I am not sure about the
 currently working server, but I think it is 0.50 or
 0.51.
 
  Do you use the sybase or the mssql extension in PHP
 
 The Sybase one ('sybase_connect').  The PHP was
 compiled with the '--with-sybase=/path/to/freetds'
 option.
 
 Thanx!
 
 Alan
 
 
 __ 
 Post your free ad now! http://personals.yahoo.ca
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




RE: [PHP-DB] fgets find string help please

2003-02-11 Thread Matthew Moldvan
Correct me if I'm wrong, but something like:

if(($string=fgets($socket,128)) == hello)
echo 'success!';

should work.  In C or C++ you would use strcmp, but luckily PHP doesn't have
that drawback.

Out of curiosity, what are you working on?

Regards,
Matthew Moldvan

---
 System Administrator
 Trilogy International, Inc
  http://www.trilogyintl.com/ecommerce/
--- 

-Original Message-
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 1:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] fgets find string help please


Hi all
 
I would like to find a string say “hello” from the result of my
fsockopen result.
 
I have searched all over for an answer but to no avail so I hand it over
to you clever people here.
 
The kind of result I want is if string excists the $result = 0 else
$result = 1
 
I can carry on from there….
 
while(!feof($socket)) {
   echo fgets($socket,128);
  }
  fclose($socket);
 
$socket is working and echoing a result.
 
Any help is very much appreciated
 
Dave Carrera

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] cookie blues

2003-02-11 Thread Ron Lloyd
I have 4 directories on my server saving different cookies for each one.  When a 3rd 
or 4th cookie is saved, cookies on a directory get deleted.  Has anyone come accross 
this problem?


[PHP-DB] php oops

2003-02-11 Thread Rajesh Fowkar
Hello,

Is there any site which contains some tutors or some details regarding
OOPS (Object Oriented Programming) using PHP ?

Thanks in advance.

Peace

--
Rajesh
:
[ GNU/Linux One Stanza Tip (LOST) ]###

Sub : Console boot (debian systems)  LOST #045

To boot into  console with  xdm/ gdm/ kdm installed, changing
at /etc/inittab does not help.  Use the [update-rc.d] program
meant for changing init parameters in Sys-V init process. All 
system startup links for /etc/init.d/xdm will be removed. viz
   
#update-rc.d -f xdm remove(or gdm / kdm)

[EMAIL PROTECTED]###
:

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] PHP 4.3.0 + MSSQL database authentication problem?

2003-02-11 Thread Alan Murrell
Hi Frank,

--- Frank M. Kromann [EMAIL PROTECTED] wrote:
 This should be ok. --with-tdsver=4.2 sets the
 default.

I figured as much, since I think the default can be
overridden in the 'freetds.conf' and/or $TDSVER
environment variable, no?
 Have you tried the tsql tool to see if you can
 connect ?

Yes, and connected was made successfully.  I used the
name of the connection in 'freetds.conf'.  I was able
to confirm successful connection earlier by posting
some logs to the FreeTDS list.

I am starting to to think it is more and more a PHP
issue.  The only thing I haven't tried yet is
downgrading the PHP version to that which is on the
current server (4.1.2; an attempted upgrade to v4.2.3
just before Xmas resulted ina very similar problem)

 If you plan to use stored procedures I would make

Not as far as I know.  Right now, it is only used to
pull information from tables.

Alan


__ 
Post your free ad now! http://personals.yahoo.ca

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Re: CDBPHP

2003-02-11 Thread Manuel Lemos
Hello,

On 02/11/2003 12:33 PM, Unknown wrote:

Dear Gurus,
Does anyone refer me to the links of PHP interface to CDB (Bernsteins)
module?Coulnd't find yet.


Check the DBA extension. There is limited support to CDB.

--

Regards,
Manuel Lemos


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php