[PHP-DB] ever send SMIME Encrypted mail from PHP4 Mail() to an OUTLOOK EXPRESS user?

[Ken Sommers]

hi,
has anyone ever sent SMIME Encrypted mail from a PHP4 script using the
Mail() function to an MS OUTLOOK EXPRESS user?
from a linux/apache/mysql/PHP4 Server?
I would like to be able to send Secure emails (from within my PHP scripts)
to the members of my site. After these members have gotten their FREE
Personal email cert from www.thawte.com.
anyone come across a tutorial or any docs on this?
thanks,

Ken



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Transforming doc files into html

[Ken Sommers]

try the html editor Arachnophilia :
http://www.arachnoid.com/arachnophilia/index.html

How to make your own page (the easy way)

You always have the option of creating a page from scratch, by entering the
HTML tags on your own. But, even with a lot of predefined tags, this takes a
long time, and you have to learn a lot about HTML as you go along.

But there is an easier way -- Arachnophilia will allow you to import a word
processing document that has been saved in Rich Text Format (RTF) and will
then convert it automatically into a Web page.

Some word processing programs will export their documents in the RTF format,
others won't, but you can still export them using one of the methods
described here. Here are the ways to get your document from your word
processor/spreadsheet/database to Arachnophilia:

· Simply save the document in the Rich Text Format (RTF) document type. Then
open it in Arachnophilia (File . Open File . RTF File). When you do this,
Arachnophilia will ask whether it should convert it into HTML format. Choose
"Yes" and you are done.
· Open Windows Explorer and drag an RTF document icon onto the Arachnophilia
program window (not onto an open document, but onto the background). In the
same way as method (1), Arachnophilia will ask whether it should convert it
into HTML format.

· For programs that do not support the RTF file format, open your source
program and Arachnophilia at the same time. Open a new, blank RTF document
in Arachnophilia (File . New File . RTF File). Move to your source program
and select the block of text you are interested in. Drag this block over to
the open RTF document window in Arachnophilia, and drop it. Then select the
menu option Tools . Convert RTF to HTML.
· Use the Windows clipboard and proceed as in method (3) above.

These methods apply to data sources such as spreadsheets and databases --
just use method 3 or 4 above if the program does not export RTF files.

Here are some suggestions to help Arachnophilia convert your document:

Always use real bulleted lists and real numbered lists, available in most
word processing programs, instead of manually numbering a list of items. If
you use the real versions of these features, Arachnophilia will create the
HTML equivalent of these structures, which look great. If you simply
manually number a list, it will not look nearly as good when viewed on a
browser.

Avoid "outdenting" paragraphs in your document formatting -- Arachnophilia
will interpret this as an outline. Instead, if you create a real outline,
even one with multiple levels, Arachnophilia will translate it into HTML for
you.

Here are some restrictions for this automatic conversion method:

Arachnophilia will automatically import tables and outlines, but cannot
import any pictures that are included in your original document. These parts
of your document have to be imported separately, using the HTML tags that
are designed for that purpose.

Sometimes Arachnophilia will misinterpret a line with tab characters in it
as a table row. If this is not what you intended and you want to prevent
this behavior, choose Tools . Options and select "Convert Tabs into Spaces."
Remember later that you made this choice, because Arachnophilia won't create
tables until the "Convert Tabbed Lines into Tables" option is enabled again.
In general, avoid the use of tabs, because this character is used in the RTF
document format to identify table rows, and Arachnophilia relies on them for
this purpose.

Be sure to review the Arachnophilia File Import methods for more information
on these techniques.

- Original Message -
From: "Cami" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 4:08 AM
Subject: [PHP-DB] Transforming doc files into html


> Hi there,
> Does anybody know if is any way in which when you upload a word document
> file you can parse it and transform
> it into an html file?
> Is this possible ? Has anybody tried it? I know I can transform it into a
> txt file but wouldn't it be even better if we can do an html file?
>
> Thanks,
> Cami
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Submitting a form with the Enter button

[Ken Sommers]

IF I click this submit button:



then (isset($submit_key) )  is TRUE


IF i press  my ENTER button instead of click it

then (isset($submit_key) ) is FALSE..

is this normal behavior?

Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: remote database exchange

[Ken Sommers]

thanks for info,

suppose I need to keep a Vendors' price list on MY site in my mysql database
(PHP4/mysql on a hosting company)
and would like to keep it up to date. I would like to know about dropped or
new items and of course price changes.
i will not need inventory quantities.
What;s the simplest and easiest way to do it?

the vendors database  may or may NOT be online.. and may be of any variety?

first thing that comes to MY mind is to ask them for a comma-delimited text
file,,and I could somehow jam that into my mysql

updates would NOT have to be up to the minute.

I would be using these prices to compare to other vendors.

thanks,

ken


- Original Message -
From: "Manuel Lemos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Ken Sommers" <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 8:17 AM
Subject: [PHP-DB] Re: remote database exchange


> Hello,
>
> Ken Sommers wrote:
> >
> > Is it possible to exchange data on remote databases in PHP mysql?
> >
> > Suppose I had a MUSIC database that you wanted your site visitors to be
able
> > to query,and it was OK with me because you had a MOVIE database that I
> > wanted MY site visitors to be able to query,
> >
> > Could we swing this?
> >
> > what is the name of this process?
> > remote process serving?
> > remote database access?
> > relay exchange process server?
> >
> > IF it exists,,where are all the tutorials and docs on it?
>
> If I were you I would avoid remote database access at all costs for two
> reasons:
>
> - Security: opening a door for remote database access via the Internet
> is asking for trouble. Anybody with knowledge could compromise your
> database server in serious ways.
>
> - Performance: exhcanging remote database request data via the Internet
> is not very fast, not to mention the chances of having the connection go
> down due to temporary routing failures. Your data exchange should be
> reduced to a minimum and should be done over a reliable medium.
>
> What I suggest that you do is to use some HTTP based RPC (Remote
> Procedure Call) method to request just the remote data or execute the
> operations you need.
>
> One of most promissing solutions is to use SOAP protocol over HTTP. SOAP
> is a protocol for making RPC using XML formatted messages.
>
> You may want to try this PHP class that is a base for developing
> arbitrary SOAP servers in PHP without much knowledge of SOAP.
>
> http://phpclasses.UpperDesign.com/browse.html/package/251
>
>
> Here you may find an real example one of a SOAP server via HTTP. It is
> used to make remote requests to a mailing list manager (ezmlm in this
> case), such as like subscribing and subscribing users, verifying if a
> user is already subscribed and return a count of how many subscribers
> there are in a given mailing list.
>
> http://phpclasses.UpperDesign.com/browse.html/package/177
>
>
> Manuel Lemos
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] remote database exchange

[Ken Sommers]

thanks again,
any idea how I can find a hosting company that has Oracle support compiled
into their PHP?
as well as sybase informix mssql etc etc.?

I may need to connect to all of these remote databases from PHP

ken

- Original Message -
From: "CC Zona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 4:33 PM
Subject: Re: [PHP-DB] remote database exchange


> In article <012601c10e4a$6c7a2ec0$b943500c@zeospantera>,
>  [EMAIL PROTECTED] (Ken Sommers) wrote:
>
> > Suppose I Need to get Vendor prices from a very large remote (Oracle)
price
> > list .
> > They probably don't have PHP installed.
>
> If...
>
> -you have PHP installed,
> -AND you have Oracle support compiled in to that install,
> -AND you have connection info (username/password/hostname) for an account
> on that Oracle system that has been granted access to vendor prices,
> -AND you know how to use PHP's Oracle functions,
> -AND you know how to query an Oracle database
>
> ...then you're set.  Whether they have PHP installed or not is irrelevant.
>
> --
> CC
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] anyone use the PHP dl() functiion?

[Ken Sommers]

Hello,
does anyone use the PHP dl() function?
to dynamically load modules at run time?
how does it work for you?

Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Unix-Linux Dynamic Extensions

[Ken Sommers]

this is PHP.INI
it shows all the windows extensions available for automatic loading,.
anyone know why the UNIX extensions are NOT listed?

Ken

;;
; Dynamic Extensions ;
;;
; if you wish to have an extension loaded automaticly, use the
; following syntax:  extension=modulename.extension
; for example, on windows,
; extension=msql.dll
; or under UNIX,
; extension=msql.so
; Note that it should be the name of the module only, no directory
information
; needs to go here.  Specify the location of the extension with the
extension_dir directive above.



;Windows Extensions
;Note that MySQL and ODBC support is now built in, so no dll is needed for
it.
;
;extension=php_bz2.dll
;extension=php_ctype.dll
;extension=php_cpdf.dll
;extension=php_curl.dll
;extension=php_cybercash.dll
;extension=php_db.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_domxml.dll
;extension=php_dotnet.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_java.dll
;extension=php_ldap.dll
;extension=php_mhash.dll
;extension=php_mssql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pdf.dll
;extension=php_pgsql.dll
;extension=php_printer.dll
;extension=php_sablot.dll
;extension=php_snmp.dll
;extension=php_sybase_ct.dll
;extension=php_yaz.dll
;extension=php_zlib.dll

;;;
goes on to something else here..



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

Do you mean the hosting company would have compiled PHP with all the
extenions available at compile time?
I have looked at two different hosting company's phpinfo()

the only dbms they  build PHP with is mysql..or its' already built in
I think the resoning is: IF you want other dbms PHP functions,,just dl() it
.

Ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 9:56 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
>
> You're correct that .so files are like Windows' .dll files...  However,
> if the library were already available on the PHP host, it most likely
> would already be included in the PHP binary...
>
> Perhaps (as you suggested) you need to find binary distributions of each
> individual library (e.g. mysql.so) that you need...  I'd check for .rpm
> files...
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 17, 2001 12:43 AM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> I think and hope it works like this
> the .so(unix) or .dll(win32) file is already a binary compiled
> executable (I know for a fact that the Win 32 dll's ARE) I looked at one
> with my file viewer quick view plus> I have php4/mysql/apache on my
> local host computer (Win95) I am typing into now. so the extension files
> are already compiled.(Win 32 definalty ARE.executable,,assuming Unix .so
> files are the same) they just have to be LINKED to the PHP binary by a
> ;linker like DL() so then PHP will ACT like it has been compiled with
> the extension.. Hence dynamically linking it.
>
> on win32 they are located (by default) in the C:/php/extensions dir
> under Unix they must be somewhere.
> phpinfo() has an entry for the php extensions dir
> my remote server shows:
> extension_dir  ./
>
> under the heading "Configuration PHP Core" in phpinfo()
>
> and the FAQ I showed you sort of substantiates that hypothesis..
>
> Here it is again:
>
> I found this FAQ: http://www.alt-php-faq.org/#id7
>
> When I try to connect to mysql from php I get this error: "Call to
> unsupported or undefined function mysql_connect();"
> Updated: 2001-06-01
> Either you miss mysql support in the php module or you need to load
> mysql dynamicly in your scripts by inserting:
>
> dl("mysql.so"); (on unix)
> dl("mysql.dll"); (on windows);
>
> in the top of all the scripts that use mysql.
> --- end of FAQ
>
> notice the FAQ master tells the troubled soul to just dl() it ?
>
> no disturbing talk of compiling the "mysql.so" file first...
>
> Has anyone used the dl() function b4???
>
> tell us how it works..
>
> Ken
>
>
>
>
>
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 9:18 PM
> Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> >
> > dl("mysql.so");  won't compile it... You need to provide the
> > "mysql.so" file for it to link to, but I don't know where to obtain
> > it...  :(
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 17, 2001 12:12 AM
> > To: Matthew Loff; 'PHP DB Mailing List'
> > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > I'm hoping the dl("mysql.so"); compiles it for you.
> > I found this FAQ: http://www.alt-php-faq.org/#id7
> >
> > When I try to connect to mysql from php I get this error: "Call to
> > unsupported or undefined function mysql_connect();"
> > Updated: 2001-06-01
> > Either you miss mysql support in the php module or you need to load
> > mysql dynamicly in your scripts by inserting:
> >
> > dl("mysql.so"); (on unix)
> > dl("mysql.dll"); (on windows);
> >
> > in the top of all the scripts that use mysql.
> > --- end of FAQ
> >
> > I hope it is that simple..
> >
> > Ken
> >
> > - Original Message -
> > From: "Matthew Loff" <[EMAIL PROTEC

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

I think and hope it works like this
the .so(unix) or .dll(win32) file is already a binary compiled executable
(I know for a fact that the Win 32 dll's ARE) I looked at one with my file
viewer quick view plus>
I have php4/mysql/apache on my local host computer (Win95) I am typing into
now.
so the extension files are already compiled.(Win 32 definalty
ARE.executable,,assuming Unix .so files are the same)
they just have to be LINKED to the PHP binary by a ;linker like DL()
so then PHP will ACT like it has been compiled with the extension..
Hence dynamically linking it.

on win32 they are located (by default) in the C:/php/extensions dir
under Unix they must be somewhere.
phpinfo() has an entry for the php extensions dir
my remote server shows:
extension_dir  ./

under the heading "Configuration PHP Core" in phpinfo()

and the FAQ I showed you sort of substantiates that hypothesis..

Here it is again:

I found this FAQ: http://www.alt-php-faq.org/#id7

When I try to connect to mysql from php I get this error: "Call to
unsupported or undefined function mysql_connect();"
Updated: 2001-06-01
Either you miss mysql support in the php module or you need to load mysql
dynamicly in your scripts by inserting:

dl("mysql.so"); (on unix)
dl("mysql.dll"); (on windows);

in the top of all the scripts that use mysql.
--- end of FAQ

notice the FAQ master tells the troubled soul to just dl() it ?

no disturbing talk of compiling the "mysql.so" file first...

Has anyone used the dl() function b4???

tell us how it works..

Ken






- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 9:18 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
> dl("mysql.so");  won't compile it... You need to provide the "mysql.so"
> file for it to link to, but I don't know where to obtain it...  :(
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 17, 2001 12:12 AM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> I'm hoping the dl("mysql.so"); compiles it for you.
> I found this FAQ: http://www.alt-php-faq.org/#id7
>
> When I try to connect to mysql from php I get this error: "Call to
> unsupported or undefined function mysql_connect();"
> Updated: 2001-06-01
> Either you miss mysql support in the php module or you need to load
> mysql dynamicly in your scripts by inserting:
>
> dl("mysql.so"); (on unix)
> dl("mysql.dll"); (on windows);
>
> in the top of all the scripts that use mysql.
> --- end of FAQ
>
> I hope it is that simple..
>
> Ken
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 8:53 PM
> Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> >
> > That's all there is to it, I'm just not sure how to compile the
> > mysql.so file!  I looked through the PHP source tree, but the
> > makefiles don't seem to be able to build the shared libs.
> >
> > Maybe it, along with others, can be downloaded from somewhere.
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 11:45 PM
> > To: Matthew Loff; 'PHP DB Mailing List'
> > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > thanks Mat,
> > I found this FAQ:
> >
> > When I try to connect to mysql from php I get this error: "Call to
> > unsupported or undefined function mysql_connect();"
> > Updated: 2001-06-01
> > Either you miss mysql support in the php module or you need to load
> > mysql dynamicly in your scripts by inserting:
> >
> > dl("mysql.so"); (on unix)
> > dl("mysql.dll"); (on windows);
> >
> > in the top of all the scripts that use mysql.
> > --- end of FAQ
> >
> > I am hoping it is that simple.
> > the dl() does it all..
> > please say  it does..:)
> >
> > ken
> >
> >
> >
> > - Original Message -
> > From: "Matthew Loff" <[EMAIL PROTECTED]>
> > To: "'Ken Somme

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

I'm hoping the dl("mysql.so"); compiles it for you.
I found this FAQ: http://www.alt-php-faq.org/#id7

When I try to connect to mysql from php I get this error: "Call to
unsupported or undefined function mysql_connect();"
Updated: 2001-06-01
Either you miss mysql support in the php module or you need to load mysql
dynamicly in your scripts by inserting:

dl("mysql.so"); (on unix)
dl("mysql.dll"); (on windows);

in the top of all the scripts that use mysql.
--- end of FAQ

I hope it is that simple..

Ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 8:53 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
> That's all there is to it, I'm just not sure how to compile the mysql.so
> file!  I looked through the PHP source tree, but the makefiles don't
> seem to be able to build the shared libs.
>
> Maybe it, along with others, can be downloaded from somewhere.
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 11:45 PM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> thanks Mat,
> I found this FAQ:
>
> When I try to connect to mysql from php I get this error: "Call to
> unsupported or undefined function mysql_connect();"
> Updated: 2001-06-01
> Either you miss mysql support in the php module or you need to load
> mysql dynamicly in your scripts by inserting:
>
> dl("mysql.so"); (on unix)
> dl("mysql.dll"); (on windows);
>
> in the top of all the scripts that use mysql.
> --- end of FAQ
>
> I am hoping it is that simple.
> the dl() does it all..
> please say  it does..:)
>
> ken
>
>
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 8:13 PM
> Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> >
> > The ext/ directory under the PHP source tree contains the source to
> > the extensions...
> >
> > You're right about the dl() syntax, except the parameter would need to
>
> > be in quotes, and dl() requires the full filename of the extension.
> >
> > For xml, it would be:
> >
> > dl("xml.so");
> >
> > But compiling those shared modules is another story-- I'm not quite
> > sure how to.  Can anyone else help?
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 10:18 PM
> > To: Ken Sommers; Matthew Loff; 'PHP DB Mailing List'
> > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > is this what some of them look like
> > is this the name that would go into the dl() function??
> >
> > print_r (get_loaded_extensions());
> >  will print a list like:
> > Array
> > (
> > [0] => xml
> > [1] => wddx
> > [2] => standard
> >[3] => session
> >[4] => posix
> >[5] => pgsql
> >[6] => pcre
> >[7] => gd
> >[8] => ftp
> >[9] => db
> >[10] => Calendar
> >[11] => bcmath
> > )
> >
> > so would
> >
> > dl(posix);
> > dl(pgsql);
> >
> > work?
> >
> > Ken
> > - Original Message -
> > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > To: "Matthew Loff" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> > <[EMAIL PROTECTED]>
> > Sent: Monday, July 16, 2001 7:11 PM
> > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > > Help.
> > > I just spent the last hour looking for the
> > > the PHP extension library to see what the
> > > the PHP extension defined in library is to put in
> > > dl (string library);
> > > to load an extension at run time.
> > > has someone seen the library door?
> > > I Keep missing it?
> > >
> > > Ken
> > >
> > >
> > > - Original Message -
> > > From: "

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

thanks Mat,
I found this FAQ:

When I try to connect to mysql from php I get this error: "Call to
unsupported or undefined function mysql_connect();"
Updated: 2001-06-01
Either you miss mysql support in the php module or you need to load mysql
dynamicly in your scripts by inserting:

dl("mysql.so"); (on unix)
dl("mysql.dll"); (on windows);

in the top of all the scripts that use mysql.
--- end of FAQ

I am hoping it is that simple.
the dl() does it all..
please say  it does..:)

ken



- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 8:13 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
> The ext/ directory under the PHP source tree contains the source to the
> extensions...
>
> You're right about the dl() syntax, except the parameter would need to
> be in quotes, and dl() requires the full filename of the extension.
>
> For xml, it would be:
>
> dl("xml.so");
>
> But compiling those shared modules is another story-- I'm not quite sure
> how to.  Can anyone else help?
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 10:18 PM
> To: Ken Sommers; Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> is this what some of them look like
> is this the name that would go into the dl() function??
>
> print_r (get_loaded_extensions());
>  will print a list like:
> Array
> (
> [0] => xml
> [1] => wddx
> [2] => standard
>[3] => session
>[4] => posix
>[5] => pgsql
>[6] => pcre
>[7] => gd
>[8] => ftp
>[9] => db
>[10] => Calendar
>[11] => bcmath
> )
>
> so would
>
> dl(posix);
> dl(pgsql);
>
> work?
>
> Ken
> - Original Message -
> From: "Ken Sommers" <[EMAIL PROTECTED]>
> To: "Matthew Loff" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 7:11 PM
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> > Help.
> > I just spent the last hour looking for the
> > the PHP extension library to see what the
> > the PHP extension defined in library is to put in
> > dl (string library);
> > to load an extension at run time.
> > has someone seen the library door?
> > I Keep missing it?
> >
> > Ken
> >
> >
> > - Original Message -
> > From: "Matthew Loff" <[EMAIL PROTECTED]>
> > To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> > <[EMAIL PROTECTED]>
> > Sent: Monday, July 16, 2001 6:37 PM
> > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
> >
> >
> > >
> > >
> > > I'm not sure if dl() can be restricted in php.ini-- Someone else
> > > will have to comment on that...
> > >
> > > I believe you'll have to dl() on every page you create... You could
> > > always do the following for portability to other PHP hosts, just in
> > > case they have the module already compiled in:
> > >
> > > if(!extension_loaded("mysql")) dl("mysql.so");
> > >
> > > That's assuming that the mysql ext. is named "mysql.so" in a
> > > compiled state, of course.
> > >
> > >
> > > -Original Message-
> > > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, July 16, 2001 9:26 PM
> > > To: Matthew Loff; 'PHP DB Mailing List'
> > > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > > support>?
> > >
> > >
> > > Thanks for the HOT tip..on the dl() function.
> > >
> > > should the dl() function work an ANY PHP4 host?
> > > or do restrictons apply?
> > >
> > >
> > > would I put the dl()  at the top of  EVERY  script page In which I
> > > Need the functionality..? or just load it once per "session" and
> > > check and see if it';s already loaded before I Load it,each time
> > > because it might already be loaded,, like I Used to do when I used
> > > to get loaded? the do

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

is this what some of them look like
is this the name that would go into the dl() function??

print_r (get_loaded_extensions());
 will print a list like:
Array
(
[0] => xml
[1] => wddx
[2] => standard
   [3] => session
   [4] => posix
   [5] => pgsql
   [6] => pcre
   [7] => gd
   [8] => ftp
   [9] => db
   [10] => Calendar
   [11] => bcmath
)

so would

dl(posix);
dl(pgsql);

work?

Ken
----- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "Matthew Loff" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 7:11 PM
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


> Help.
> I just spent the last hour looking for the
> the PHP extension library to see what the
> the PHP extension defined in library is to put in
> dl (string library);
> to load an extension at run time.
> has someone seen the library door?
> I Keep missing it?
>
> Ken
>
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 6:37 PM
> Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
support>?
>
>
> >
> >
> > I'm not sure if dl() can be restricted in php.ini-- Someone else will
> > have to comment on that...
> >
> > I believe you'll have to dl() on every page you create... You could
> > always do the following for portability to other PHP hosts, just in case
> > they have the module already compiled in:
> >
> > if(!extension_loaded("mysql")) dl("mysql.so");
> >
> > That's assuming that the mysql ext. is named "mysql.so" in a compiled
> > state, of course.
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 9:26 PM
> > To: Matthew Loff; 'PHP DB Mailing List'
> > Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > Thanks for the HOT tip..on the dl() function.
> >
> > should the dl() function work an ANY PHP4 host?
> > or do restrictons apply?
> >
> >
> > would I put the dl()  at the top of  EVERY  script page In which I Need
> > the functionality..? or just load it once per "session" and check and
> > see if it';s already loaded before I Load it,each time because it might
> > already be loaded,, like I Used to do when I used to get loaded? the
> > documentation is kinda skimpy. here's what it says:
> > ---
> > dl
> > (PHP 3, PHP 4 >= 4.0b1)
> >
> > dl -- load a PHP extension at runtime
> > Description
> >
> > int dl (string library)
> >
> >
> > Loads the PHP extension defined in library. See also the extension_dir
> > configuration directive.
> > ---
> >
> > thanks,
> >
> > Ken
> >
> > - Original Message -
> > From: "Matthew Loff" <[EMAIL PROTECTED]>
> > To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> > <[EMAIL PROTECTED]>
> > Sent: Monday, July 16, 2001 6:01 PM
> > Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > >
> > > Even if a PHP host doesn't have all the DBMS extensions you need, you
> > > could compile them and load them yourself with dl()
> > >
> > > http://www.php.net/manual/en/function.dl.php
> > >
> > > I thought you might want to keep that in mind, in case one particular
> > > host has a great price but not all the features you need...
> > >
> > >
> > > -Original Message-
> > > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, July 16, 2001 8:53 PM
> > > To: PHP DB Mailing List
> > > Subject: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > > support>?
> > >
> > >
> > > Any one use or know of a php/mysql/unix-Linux hosting company with
> > > PHP database support compiled with all the major DBMS's such as:
> > >
> > >  mSQL
> > > MySQL
> > > PostgreSQL
> > > Sybase
> > > Oracle
> > > Informix
> > > MS-SQL
> > > Other ODBC Database
> > >
> > > I will need to use some or all of these DBMS PHP functions for remote
> > > access.
> > >
> > > thanks,,
> > > Ken
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
> > > [EMAIL PROTECTED]
> > >
> > >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

Help.
I just spent the last hour looking for the
the PHP extension library to see what the
the PHP extension defined in library is to put in
dl (string library);
to load an extension at run time.
has someone seen the library door?
I Keep missing it?

Ken


- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:37 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
>
> I'm not sure if dl() can be restricted in php.ini-- Someone else will
> have to comment on that...
>
> I believe you'll have to dl() on every page you create... You could
> always do the following for portability to other PHP hosts, just in case
> they have the module already compiled in:
>
> if(!extension_loaded("mysql")) dl("mysql.so");
>
> That's assuming that the mysql ext. is named "mysql.so" in a compiled
> state, of course.
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 9:26 PM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> Thanks for the HOT tip..on the dl() function.
>
> should the dl() function work an ANY PHP4 host?
> or do restrictons apply?
>
>
> would I put the dl()  at the top of  EVERY  script page In which I Need
> the functionality..? or just load it once per "session" and check and
> see if it';s already loaded before I Load it,each time because it might
> already be loaded,, like I Used to do when I used to get loaded? the
> documentation is kinda skimpy. here's what it says:
> ---
> dl
> (PHP 3, PHP 4 >= 4.0b1)
>
> dl -- load a PHP extension at runtime
> Description
>
> int dl (string library)
>
>
> Loads the PHP extension defined in library. See also the extension_dir
> configuration directive.
> ---
>
> thanks,
>
> Ken
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
> <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 6:01 PM
> Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> support>?
>
>
> >
> > Even if a PHP host doesn't have all the DBMS extensions you need, you
> > could compile them and load them yourself with dl()
> >
> > http://www.php.net/manual/en/function.dl.php
> >
> > I thought you might want to keep that in mind, in case one particular
> > host has a great price but not all the features you need...
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 8:53 PM
> > To: PHP DB Mailing List
> > Subject: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
> > support>?
> >
> >
> > Any one use or know of a php/mysql/unix-Linux hosting company with
> > PHP database support compiled with all the major DBMS's such as:
> >
> >  mSQL
> > MySQL
> > PostgreSQL
> > Sybase
> > Oracle
> > Informix
> > MS-SQL
> > Other ODBC Database
> >
> > I will need to use some or all of these DBMS PHP functions for remote
> > access.
> >
> > thanks,,
> > Ken
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

Thanks for the HOT tip..on the dl() function.

should the dl() function work an ANY PHP4 host?
or do restrictons apply?


would I put the dl()  at the top of  EVERY  script page In which I Need the
functionality..?
or just load it once per "session" and check and see if it';s already loaded
before I Load it,each time because it might already be loaded,,
like I Used to do when I used to get loaded?
the documentation is kinda skimpy.
here's what it says:
---
dl
(PHP 3, PHP 4 >= 4.0b1)

dl -- load a PHP extension at runtime
Description

int dl (string library)


Loads the PHP extension defined in library. See also the extension_dir
configuration directive.
---

thanks,

Ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 6:01 PM
Subject: RE: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?


>
> Even if a PHP host doesn't have all the DBMS extensions you need, you
> could compile them and load them yourself with dl()
>
> http://www.php.net/manual/en/function.dl.php
>
> I thought you might want to keep that in mind, in case one particular
> host has a great price but not all the features you need...
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 8:53 PM
> To: PHP DB Mailing List
> Subject: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?
>
>
> Any one use or know of a php/mysql/unix-Linux hosting company with
>  PHP database support compiled with all the major DBMS's such as:
>
>  mSQL
> MySQL
> PostgreSQL
> Sybase
> Oracle
> Informix
> MS-SQL
> Other ODBC Database
>
> I will need to use some or all of these DBMS PHP functions
> for remote access.
>
> thanks,,
> Ken
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] php/mysql/unix-Linux hosting with major DBMS support>?

[Ken Sommers]

Any one use or know of a php/mysql/unix-Linux hosting company with 
 PHP database support compiled with all the major DBMS's such as:

 mSQL
MySQL
PostgreSQL
Sybase
Oracle
Informix
MS-SQL
Other ODBC Database

I will need to use some or all of these DBMS PHP functions
for remote access.

thanks,,
Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] remote database exchange

[Ken Sommers]

Great,
thanks for a complete answer
 I love it..

I ran
mysql> show variables;
to see if my host server has Oracle support,,
I don't see anything about Oracle  or any  other DBMS,,
any way to tell without asking them?

ken
- Original Message -
From: "CC Zona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 4:33 PM
Subject: Re: [PHP-DB] remote database exchange


> In article <012601c10e4a$6c7a2ec0$b943500c@zeospantera>,
>  [EMAIL PROTECTED] (Ken Sommers) wrote:
>
> > Suppose I Need to get Vendor prices from a very large remote (Oracle)
price
> > list .
> > They probably don't have PHP installed.
>
> If...
>
> -you have PHP installed,
> -AND you have Oracle support compiled in to that install,
> -AND you have connection info (username/password/hostname) for an account
> on that Oracle system that has been granted access to vendor prices,
> -AND you know how to use PHP's Oracle functions,
> -AND you know how to query an Oracle database
>
> ...then you're set.  Whether they have PHP installed or not is irrelevant.
>
> --
> CC
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] remote database exchange

[Ken Sommers]

Suppose I Need to get Vendor prices from a very large remote (Oracle) price
list .
They probably don't have PHP installed.
What are my options?

Ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 3:31 PM
Subject: RE: [PHP-DB] remote database exchange


>
>
> The mysql_connect() function accepts a host name, which can be the
> internet address of another machine!  However-- the MySQL database on
> that machine has to be set up to allow outside connections for whatever
> particular username/password you are using!
>
> Please see these pages to answer your questions:
> http://www.mysql.com/doc/A/d/Adding_users.html--  MySQL
> username/password configuration
> http://www.php.net/manual/en/ref.mysql.php---MySQL functions in
> PHP
>
> The PHP page has an example on that page that will show you -exactly-
> how to do it.
>
> --Matt
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 5:53 PM
> To: PHP DB Mailing List
> Subject: [PHP-DB] remote database exchange
>
>
> Is it possible to exchange data on remote databases in PHP mysql?
>
> Suppose I had a MUSIC database that you wanted your site visitors to be
> able to query,and it was OK with me because you had a MOVIE database
> that I wanted MY site visitors to be able to query,
>
> Could we swing this?
>
> what is the name of this process?
> remote process serving?
> remote database access?
> relay exchange process server?
>
> IF it exists,,where are all the tutorials and docs on it?
>
>
> Ken
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: the body of the response

[Ken Sommers]

thanks CC,
are you saying that i can grab the output of your echo() statements in YOUR
PHP script by Fopen()ing your URL
in MY script and then Fread()ing that resulting file pointer?
IF so,, is this done much? or are there easier more stable less error-prone
ways to access remote databases?

Suppose I had a MUSIC database that you wanted your site visitors to be able
to query,and it was OK with me because you had a MOVIE database that i
wanted MY site visitors to be able to query,
would we set it up this way?

ken

- Original Message -
From: "CC Zona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 2:16 PM
Subject: [PHP-DB] Re: the body of the response


> In article <008101c10e0f$379207e0$c844500c@zeospantera>,
>  [EMAIL PROTECTED] (Ken Sommers) wrote:
>
> > PHP manual says:
> > fopen
> > fopen -- Opens file or URL
> > Description
> > int fopen (string filename, string mode [, int use_include_path])
> >
> > If filename begins with "http://"; (not case sensitive), an HTTP 1.0
> > connection is opened to the specified server, the page is requested
using
> > the HTTP GET method, and a file pointer is returned to the beginning of
the
> > body of the response.
> > 
> > can someone explain the clause:
> >
> > "and a file pointer is returned to the beginning of the
> > body of the response."
> >
> > can someone explain and describe what this "body"  is?
>
> Presumably that's what RFC 2616 refers to as the "message body", the part
> of the response that follows the headers.  Translated: what you get with
> fopen() is what you'd get by fetching the same URL with a browser and then
> viewing source.
>
> BTW, fsockopen() can be used to get both headers ("Content-type",
> "Content-length", "Expires", "Location", etc.) and body
> ("" or whatever).
>
> --
> CC
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] remote database exchange

[Ken Sommers]

Is it possible to exchange data on remote databases in PHP mysql?

Suppose I had a MUSIC database that you wanted your site visitors to be able
to query,and it was OK with me because you had a MOVIE database that I
wanted MY site visitors to be able to query,

Could we swing this?

what is the name of this process?
remote process serving?
remote database access?
relay exchange process server?

IF it exists,,where are all the tutorials and docs on it?


Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] the body of the response

[Ken Sommers]

I looked up Output();
could not find output() function in PHP.

what is the secret code to output?

Ken
- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 2:05 PM
Subject: RE: [PHP-DB] the body of the response


>
> Ken--
>
> There's no "secret code".  By "giving" the response, I mean the
> MovieResponder.php outputs that data... This is the most elementary of
> PHP features... See:
>
> http://www.php.net/manual/en/function.echo.php
> http://www.php.net/manual/en/function.print.php
>
> By "giving" the data to your script, I am saying that the
> MovieResponder.php script outputs the data (see above) thinking that a
> -web browser- is at the other end... Your script takes that data, and
> stores it to a variable by calling fread() (which I explained before).
>
> You may want to start from the beginning, and get a good grasp as how
> exactly the PHP language works:
>
> http://www.php.net/manual/en/langref.php
>
> Then experiment!  Create a PHP script that reads the data from a URL,
> for example:
>
> 
> $url = fopen("http://snaps.php.net/";, "r");
> $page = fread($url, 10240);
> fclose($url);
>
> echo $page;
>
> ?>
>
> The $page variable will contain the output of http://snaps.php.net/.
>
> Good luck!
> --Matt
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 4:50 PM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] the body of the response
>
>
> MR.Loff,
> I see the concept.. but i still don;t see the secret code.
> for this process:
>
> And you created MovieResponder.php to give you this response:
>
> Movie One 1977
> Movie Two 1977
> Movie Three 1977
>
> how does it GIVE..is there a php function called GIVE()? where does
> the Give() function Give it's data?
>
> does it have to give in here?
>
>   
>
> what gives?
>
>
> what is the secret code?
> I looked up Give()  in the php manual..no such function.as give().
>
> what is the secret code?
>
> ---
> MovieResponder.php can generate -anything- you want... HTML code, a
> serialize()d array, or anything else...
>
> suppose I Need MovieResponder.php to generate  an  array..
> how do I "generate" it ?
> what does "generate" mean in PHP?
>
> does it mean an assignment statement? does an assignment statement
> GENERATE an array? or maybe an Echo statement to the  GENERATEs an
> array? what is the secret code Generate() is not a valid php function
> either.
>
> what is the secret code,?,and why is it secret?
>
> Ken
>
>
>
>
>
>
> Ken
>
>
>
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 1:34 PM
> Subject: RE: [PHP-DB] the body of the response
>
>
> >
> > MovieResponder.php can generate -anything- you want... HTML code, a
> > serialize()d array, or anything else...
> >
> > By using fopen() to call http://www.wherever.com/MovieResponder.php
> > and
> > fread() to grab the data to a local variable, you're calling the
> > MovieResponder.php script as if you are simply accessing it through a
> > web browser!
> >
> > Whatever MovieResponder.php outputs-- HTML, etc... Will be saved in
> > your local variable for manipulation!
> >
> >
> > Here's an example... Say your MovieResponder.php file takes the $actor
>
> > and $year variables, and queries MySQL, then returns a list of movies.
> >
> > ... Let's say you called your script through your web browser as
> > http://www.wherever.com/MovieResponder.php?actor=Somebody&year=1977
> > And you created MovieResponder.php to give you this response:
> >
> > Movie One 1977
> > Movie Two 1977
> > Movie Three 1977
> >
> > ... If your local PHP script looks like this:
> >
> > $file = fopen("http://www.wherever.com/MovieResponder.php?actor="; .
> > urlencode($actor) . "&year=" . urlencode($year), "r");
> > $data = fread($file, 10240);
> > fclose($file);
> >
> > ... Then if you called your local script with $actor = Somebody and
> > $year = 1977, when it is called, your $data variable would c

Re: [PHP-DB] the body of the response

[Ken Sommers]

MR.Loff,
I see the concept.. but i still don;t see the secret code.
for this process:

And you created MovieResponder.php to give you this response:

Movie One 1977
Movie Two 1977
Movie Three 1977

how does it GIVE..is there a php function called GIVE()?
where does the Give() function Give it's data?

does it have to give in here?

  

what gives?


what is the secret code?
I looked up Give()  in the php manual..no such function.as give().

what is the secret code?

---
MovieResponder.php can generate -anything- you want... HTML code, a
 serialize()d array, or anything else...

suppose I Need MovieResponder.php to generate  an  array..
how do I "generate" it ?
what does "generate" mean in PHP?

does it mean an assignment statement? does an assignment statement GENERATE
an array?
or maybe an Echo statement to the  GENERATEs an array?
what is the secret code Generate() is not a valid php function either.

what is the secret code,?,and why is it secret?

Ken






Ken




- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 1:34 PM
Subject: RE: [PHP-DB] the body of the response


>
> MovieResponder.php can generate -anything- you want... HTML code, a
> serialize()d array, or anything else...
>
> By using fopen() to call http://www.wherever.com/MovieResponder.php and
> fread() to grab the data to a local variable, you're calling the
> MovieResponder.php script as if you are simply accessing it through a
> web browser!
>
> Whatever MovieResponder.php outputs-- HTML, etc... Will be saved in your
> local variable for manipulation!
>
>
> Here's an example... Say your MovieResponder.php file takes the $actor
> and $year variables, and queries MySQL, then returns a list of movies.
>
> ... Let's say you called your script through your web browser as
> http://www.wherever.com/MovieResponder.php?actor=Somebody&year=1977
> And you created MovieResponder.php to give you this response:
>
> Movie One 1977
> Movie Two 1977
> Movie Three 1977
>
> ... If your local PHP script looks like this:
>
> $file = fopen("http://www.wherever.com/MovieResponder.php?actor="; .
> urlencode($actor) . "&year=" . urlencode($year), "r");
> $data = fread($file, 10240);
> fclose($file);
>
> ... Then if you called your local script with $actor = Somebody and
> $year = 1977, when it is called, your $data variable would contain:
>
> Movie One 1977
> Movie Two 1977
> Movie Three 1977
>
> Easy as that!  It's a very simple concept.
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 4:04 PM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] the body of the response
>
>
> thanks for response,
>
> I am curious, how does the http://www.site.com/MovieResponder.php script
> get the data in the body?. what is the mechanism involved? is this
> "body" the   
>
> of an html page?
>
> is this the "body we are talking about or some other body?
>
>
> what is the secret code involved?
> thanks again,
>
> Ken
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 12:53 PM
> Subject: RE: [PHP-DB] the body of the response
>
>
> >
> >
> > The "body" of the response is the data that the
> > http://www.site.com/MovieResponder.php script would produce.
> >
> > The fread() call that I meantioned before would read -all- of this
> > data into a variable.
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 11:52 AM
> > To: PHP DB Mailing List
> > Subject: [PHP-DB] the body of the response
> >
> >
> > PHP manual says:
> > fopen
> > fopen -- Opens file or URL
> > Description
> > int fopen (string filename, string mode [, int use_include_path])
> >
> > If filename begins with "http://"; (not case sensitive), an HTTP 1.0
> > connection is opened to the specified server, the page is requested
> > using the HTTP GET method, and a file pointer is returned to the
> > beginning of the body of the response.
> > 
> > can someone explain the clause:
> >
> > "and a file pointer is returned to the beginning of the
> > body of the response."
> >
> > can someone explain and describe what this "body"  is?
> >
> > can query results be put in this 'body',,if so how?
> >
> > thanks,
> >
> > Ken
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] the body of the response

[Ken Sommers]

thanks for response,

I am curious, how does the http://www.site.com/MovieResponder.php script get
the data in the body?.
what is the mechanism involved?
is this "body" the




of an html page?

is this the "body we are talking about or some other body?


what is the secret code involved?
thanks again,

Ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 12:53 PM
Subject: RE: [PHP-DB] the body of the response


>
>
> The "body" of the response is the data that the
> http://www.site.com/MovieResponder.php script would produce.
>
> The fread() call that I meantioned before would read -all- of this data
> into a variable.
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 11:52 AM
> To: PHP DB Mailing List
> Subject: [PHP-DB] the body of the response
>
>
> PHP manual says:
> fopen
> fopen -- Opens file or URL
> Description
> int fopen (string filename, string mode [, int use_include_path])
>
> If filename begins with "http://"; (not case sensitive), an HTTP 1.0
> connection is opened to the specified server, the page is requested
> using the HTTP GET method, and a file pointer is returned to the
> beginning of the body of the response.
> 
> can someone explain the clause:
>
> "and a file pointer is returned to the beginning of the
> body of the response."
>
> can someone explain and describe what this "body"  is?
>
> can query results be put in this 'body',,if so how?
>
> thanks,
>
> Ken
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] the body of the response

[Ken Sommers]

PHP manual says:
fopen
fopen -- Opens file or URL
Description
int fopen (string filename, string mode [, int use_include_path])

If filename begins with "http://"; (not case sensitive), an HTTP 1.0
connection is opened to the specified server, the page is requested using
the HTTP GET method, and a file pointer is returned to the beginning of the
body of the response.

can someone explain the clause:

"and a file pointer is returned to the beginning of the
body of the response."

can someone explain and describe what this "body"  is?

can query results be put in this 'body',,if so how?

thanks,

Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] FOPEN () communication

[Ken Sommers]

PHP manual says:
fopen
fopen -- Opens file or URL
Description
int fopen (string filename, string mode [, int use_include_path])

If filename begins with "http://"; (not case sensitive), an HTTP 1.0
connection is opened to the specified server, the page is requested using
the HTTP GET method, and a file pointer is returned to the beginning of the
body of the response.


consider this use of Fopen():

$movie_site = fopen("http://www.site.com/MovieResponder.php?star="; .
urlencode($star) . "&year=" . urlencode($year), "r");
$movie_info = fread($movie_site, 10240);
fclose($movie_site);
---
http://www.site.com/MovieResponder.php performs a query on it;s own database
with $star and $year


how does http://www.site.com/MovieResponder.php get the query result in the
body of the response?

a simple



echo ($result);


??

how does this stuff communicate?

where's a tutorial or some docs on it?

Ken



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] relay response transactions between PHP scripts on different servers

[Ken Sommers]

Thanks,,
are we talking about something like this?


http://www.site.com/MovieResponder.php?star="; .
urlencode($star) . "&year=" . urlencode($year), "r");
$movie_info = fread($movie_site, 10240);
fclose($movie_site);

echo"your movie info is: ";
echo ($movie_info);
}
else{

 >
star: 
year: 
 
 
}

?>





- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 10:51 PM
Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
different servers


>
> You could use file functions with a URL:
>
> $movie_site = fopen("http://www.site.com/MovieResponder.php?star="; .
> urlencode($star) . "&year=" . urlencode($year), "r");
> $movie_info = fread($movie_site, 10240);
> fclose($movie_site);
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 1:40 AM
> To: Matthew Loff; 'PHP DB Mailing List'
> Subject: Re: [PHP-DB] relay response transactions between PHP scripts on
> different servers
>
>
> Here's the part that confuses me:
> How does MovieResponder.php on your site get the results back to my site
> and back to the browser/user who is visiting my site..?
>
>
> ken
>
> - Original Message -
> From: "Matthew Loff" <[EMAIL PROTECTED]>
> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing
> List'" <[EMAIL PROTECTED]>
> Sent: Sunday, July 15, 2001 9:37 PM
> Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
> different servers
>
>
> >
> > Ken--
> >
> > If you have access to that server with the SQL database... Then
> > instead of creating an additional PHP script on the SQL server...
> > Could you simply add a username/password that was allowed to access
> > that particular database (read-only, of course) remotely?
> >
> > If that isn't an option, here's an idea:
> >
> > Transmit the $star and $decade variables to the MovieResponder.php
> > (don't pass the SQL query directly-- that's a bad idea!)... Have the
> > MovieResponder.php execute the SQL query, retrieve all results into an
>
> > array, and serialize() the array, then pass the serialized data back
> > to MovieInfo.php.
> >
> > I'm sure others will have other suggestions, and there are probably
> > better ways to do it than this.
> >
> > Good luck!
> >
> >
> > -Original Message-
> > From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 16, 2001 12:22 AM
> > To: PHP DB Mailing List
> > Subject: [PHP-DB] relay response transactions between PHP scripts on
> > different servers
> >
> >
> > Hello,
> > suppose you have a MOVIES table in your database on your server at
> > your hosting company. Suppose I want some MOVIE info from your
> > database..the titles of all the Robert Deniro movies released in the
> > 1980's. Can I get the info and relay it back to the user on MY site?
> >
> > Would it be something like this?:
> >
> > Suppose I have a php page on MY web site called MovieInfo.php
> >
> > MovieInfo.php creates a sql command string from info provided by the
> > user at MY site.
> >
> > something like $sql=" select titles,dates from movies where star =
> > 'Robert Deniro' and decade = '1980'"
> >
> > assume correct syntax.
> >
> > Suppose you have a PHp script on your site called MovieResponder.php
> > that is designed to run the query and send the result back to MY
> > script.
> >
> > The php page on MY web site called MovieInfo.php has something like
> > this
> > form:
> >
> > FORM method="post"
> > action="https://www.yourserver.com/gateway/MovieResponder.php";>
> >  > VALUE="https://www.myserver.com/MovieInfo.php";>
> > 
> > 
> > 
> >
> > etc? etc?
> >
> > how could it work?
> >
> > Ken
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> >
> >
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] relay response transactions between PHP scripts on different servers

[Ken Sommers]

Here's the part that confuses me:
How does MovieResponder.php on your site get the results back to my site
and back to the browser/user who is visiting my site..?


ken

- Original Message -
From: "Matthew Loff" <[EMAIL PROTECTED]>
To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "'PHP DB Mailing List'"
<[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 9:37 PM
Subject: RE: [PHP-DB] relay response transactions between PHP scripts on
different servers


>
> Ken--
>
> If you have access to that server with the SQL database... Then instead
> of creating an additional PHP script on the SQL server... Could you
> simply add a username/password that was allowed to access that
> particular database (read-only, of course) remotely?
>
> If that isn't an option, here's an idea:
>
> Transmit the $star and $decade variables to the MovieResponder.php
> (don't pass the SQL query directly-- that's a bad idea!)... Have the
> MovieResponder.php execute the SQL query, retrieve all results into an
> array, and serialize() the array, then pass the serialized data back to
> MovieInfo.php.
>
> I'm sure others will have other suggestions, and there are probably
> better ways to do it than this.
>
> Good luck!
>
>
> -Original Message-
> From: Ken Sommers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 12:22 AM
> To: PHP DB Mailing List
> Subject: [PHP-DB] relay response transactions between PHP scripts on
> different servers
>
>
> Hello,
> suppose you have a MOVIES table in your database on your server at your
> hosting company. Suppose I want some MOVIE info from your database..the
> titles of all the Robert Deniro movies released in the 1980's. Can I get
> the info and relay it back to the user on MY site?
>
> Would it be something like this?:
>
> Suppose I have a php page on MY web site called MovieInfo.php
>
> MovieInfo.php creates a sql command string from info provided by the
> user at MY site.
>
> something like $sql=" select titles,dates from movies where star =
> 'Robert Deniro' and decade = '1980'"
>
> assume correct syntax.
>
> Suppose you have a PHp script on your site called MovieResponder.php
> that is designed to run the query and send the result back to MY script.
>
> The php page on MY web site called MovieInfo.php has something like this
> form:
>
> FORM method="post"
> action="https://www.yourserver.com/gateway/MovieResponder.php";>
>  VALUE="https://www.myserver.com/MovieInfo.php";>
> 
> 
> 
>
> etc? etc?
>
> how could it work?
>
> Ken
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] relay response transactions between PHP scripts on different servers

[Ken Sommers]

Hello,
suppose you have a MOVIES table in your database on your server at your
hosting company.
Suppose I want some MOVIE info from your database..the titles of all the
Robert Deniro movies released in the 1980's.
Can I get the info and relay it back to the user on MY site?

Would it be something like this?:

Suppose I have a php page on MY web site called MovieInfo.php

MovieInfo.php creates a sql command string from info provided by the user at
MY site.

something like $sql=" select titles,dates from movies where star = 'Robert
Deniro' and decade = '1980'"

assume correct syntax.

Suppose you have a PHp script on your site called MovieResponder.php
that is designed to run the query and send the result back to MY script.

The php page on MY web site called MovieInfo.php has something like this
form:

FORM method="post"
action="https://www.yourserver.com/gateway/MovieResponder.php";>
https://www.myserver.com/MovieInfo.php";>




etc? etc?

how could it work?

Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] CGI or API installation?

[Ken Sommers]

Hello,
How to tell if php4 is installed as a CGI or API module) installation?
will phpinfo() tell me?
thanks ,
Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP Mysql apache economy hosting

[Ken Sommers]

Hello,
can anyone recommend a good
PHP4/ Mysql/ apache/Unix-Linux economy web hosting co.?
what should I look for?
how do I verify uptime?

thanks 
Ken




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

php-db@lists.php.net

[Ken Sommers]

Please explain the dynamic link .
is that in the documentation somewhere>?

Kne
- Original Message -
From: "Rankin, Randy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 8:18 AM
Subject: [PHP-DB] Escaping &


> Hello,
>
> I have a table in a MySQL DB (RH Linux/Apache) with a field called
> customer_name. Some of the customer names have an ampersand in them (ie; X
&
> X Supply). I am performing a select statement on this table to create a
> sales summary with customer name and total sales.
>
> This works fine; however, I am also creating a dynamic link on the
customer
> name so that the user can click on it to get a detailed report of sales to
> that customer. This works great EXCEPT for the customers with ampersands
in
> thier names. The result of clicking on these customers indicates a "No
> Records found for X" where X is the letter immediately preceding the
> ampersand.
>
> Does anyone know how to get around this?
>
> TIA,
>
> Randy Rankin
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Thank you everyone :-)

[Ken Sommers]

Here,,Here
I second that emotion

Ken
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 12:52 PM
Subject: [PHP-DB] Thank you everyone :-)


Hi there,

Thanks everyone for your help on this list - it really is a credit to the
PHP community to have you all out there helping those of us who don't know
what the heck we are doing (But who are trying to learn :-)

I appreciate it, and I am sure many others do too.

Regards

Chris Payne
www.planetoxygene.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Are PHP user-defined functions recursive?

[Ken Sommers]

Manual says:
---
"Any valid PHP code may appear inside a function, even other functions and
class definitions.

In PHP 3, functions must be defined before they are referenced. No such
requirement exists in PHP 4.

PHP does not support function overloading, nor is it possible to undefine or
redefine previously-declared functions. "
-

I say:

What is function overloading?

Can a php user-defined function call itself from within itself?

thanks,
Ken




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] cookie problems

[Ken Sommers]

HI,
my guess is is that the cookies will be killed the NEXT time you run this
script.

Ken
- Original Message -
From: "Brad Lipovsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 11:24 PM
Subject: [PHP-DB] cookie problems


> can anyone help me with this code?  i cant believe it wont work, it seems
> pretty simple!
>
>  setcookie ("logged_in", "logged in", time() - 3600);
> setcookie ("logged_user_name", "logged user name", time() - 3600);
>
> print "$logged_in ";
> print "$logged_user_name";
> ?>
>
> brad
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Fw: Referential Integrity

[Ken Sommers]

- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:46 PM
Subject: Re: Referential Integrity


> I started learning PHP Mysql about 2 weeks ago.
> I'm still reading the tutorials.
> Hopefuly some experienced programmers in PHP mysql will share how they
> cascade their updates when they change a primary key.
>
> But my guess is If you keep a table of related table names /foreign key
> names,,related to the table that needs to have it's updates cascaded,,you
> can code it in a few lines; maybe 5 or 10 lines  in PHP using mysql
> functions.
> I would love to see some real world examples.
>
> Ken
>
> - Original Message -
> From: "pak" <[EMAIL PROTECTED]>
> To: "Ken Sommers" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 10:32 PM
> Subject: Re: Referential Integrity
>
>
> > Ken,
> > What I am doing is programmatically to cascade update the detail/related
> > tables, that is the way.
> > Every body know Oracle handles great in database operation, that is
> another
> > story.
> > I am asking for help, as I am not familiar with MySQL, is there other
way
> to
> > do the update cascade besides doing so in application programming
> > statements.
> > - Original Message -
> > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > To: "pak" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 11, 2001 3:09 PM
> > Subject: Re: Referential Integrity
> >
> >
> > | OK agreed, if the primary keys have any human value which might need
> > | changing,,then i recommend Oracle ..:)
> > | IF the Employee ID has the department embedded in it( bad design
> > | imho),,,then I recommend a dbms with Ref Integrety built in.
> > | But if you have a system with all primary keys as computer-generated
> > | meaningless values,
> > | I can't; see a reason to ever have to change one of those keys.
> > |
> > | Then what about deleting primary-keyed rows that point to other
tables?
> > | Maybe 50 other tables? hmmm it may be time for Oracle,,got any money?
> > |
> > | Ken
> > |
> > |
> > |
> > | - Original Message -
> > | From: "pak" <[EMAIL PROTECTED]>
> > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 10, 2001 9:40 PM
> > | Subject: Re: Referential Integrity
> > |
> > |
> > | > Ken,
> > | > These are trivial examples. What if the Administrator changes the
> > | Employee's
> > | > ID if the ID is not a pure numerical one and not a computer
generated
> ?
> > | eg.
> > | > IT001 represents employee in IT department. HR001 represents in
Human
> > | > Resources department.
> > | > The point is the basic principle in database design : referential
> > | integrity
> > | > gaurantee the master-detail relationship be maintained without data
> > loss.
> > | > And this is the important function provided by DBMS.
> > | > If we have a ER diagram when do the normalization, then we can see
the
> > | > tables invloved. How about if there are 200 tables in the database,
> and
> > 50
> > | > tables invloved, how many lines of code we have to write to do the
> > update
> > | in
> > | > our program developed by ,say VB, VC++, Delphi.
> > | >
> > | > - Original Message -
> > | > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > To: "pak" <[EMAIL PROTECTED]>
> > | > Sent: Wednesday, July 11, 2001 2:26 PM
> > | > Subject: Re: Referential Integrity
> > | >
> > | >
> > | > | Thanks for nice example,
> > | > | Question,,Why would you ever have to change these codes
> > | > | [EmpID or SuburbCode]?, if they are meaningless, arbitrary,
probably
> > | > | computer-generated numbers that should have no intrinsic or any
> other
> > | > | meaning of their own?,,Isn't; one meaningless number as good as
the
> > | next?
> > | > | ..
> > | > | ken
> > | > | - Original Message -
> > | > | From: "pak" <[EMAIL PROTECTED]>
> > | > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > | Sent: Tuesday, July 10, 2001 9:08 PM
> > | > | Subject: Re: Referential Integrity
> > | > |
> > | > |
> > | > | > 1)Table Employee
> > | > | > EmpID
> > | > | > Name
> > | > | > Add

[PHP-DB] Fw: Referential Integrity

[Ken Sommers]

- Original Message -
From: "Ken Sommers" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:29 PM
Subject: Re: Referential Integrity


> Ever play .,.Name that Code?
>
> I can delete those related rows in those 50 tables in about 5 lines..
> but first you gotta keep a table with the names of the 50 related tables
and
> the name of the foreign key in the row.
>
> then just loop around 50 times{
> get next table name and foreign key name form related_tables table
> Delete from related_table Where foreign_key = primary_key;
> }
>
> might work...!
>
> Ken
>
> - Original Message -
> From: "pak" <[EMAIL PROTECTED]>
> To: "Ken Sommers" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 10, 2001 9:40 PM
> Subject: Re: Referential Integrity
>
>
> > Ken,
> > These are trivial examples. What if the Administrator changes the
> Employee's
> > ID if the ID is not a pure numerical one and not a computer generated ?
> eg.
> > IT001 represents employee in IT department. HR001 represents in Human
> > Resources department.
> > The point is the basic principle in database design : referential
> integrity
> > gaurantee the master-detail relationship be maintained without data
loss.
> > And this is the important function provided by DBMS.
> > If we have a ER diagram when do the normalization, then we can see the
> > tables invloved. How about if there are 200 tables in the database, and
50
> > tables invloved, how many lines of code we have to write to do the
update
> in
> > our program developed by ,say VB, VC++, Delphi.
> >
> > - Original Message -
> > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > To: "pak" <[EMAIL PROTECTED]>
> > Sent: Wednesday, July 11, 2001 2:26 PM
> > Subject: Re: Referential Integrity
> >
> >
> > | Thanks for nice example,
> > | Question,,Why would you ever have to change these codes
> > | [EmpID or SuburbCode]?, if they are meaningless, arbitrary, probably
> > | computer-generated numbers that should have no intrinsic or any other
> > | meaning of their own?,,Isn't; one meaningless number as good as the
> next?
> > | ..
> > | ken
> > | - Original Message -
> > | From: "pak" <[EMAIL PROTECTED]>
> > | To: "Ken Sommers" <[EMAIL PROTECTED]>
> > | Sent: Tuesday, July 10, 2001 9:08 PM
> > | Subject: Re: Referential Integrity
> > |
> > |
> > | > 1)Table Employee
> > | > EmpID
> > | > Name
> > | > Address
> > | > Phone
> > | > SuburbCode (reference table Suburb)
> > | >
> > | > 2)Table Manager
> > | > ManID (reference Employee)
> > | > SubordinateID (reference table Employee)
> > | >
> > | > 3)Table Suburb
> > | > SuburbCode
> > | > Suburb
> > | > State
> > | > Postcode
> > | >
> > | > If the user/Administrator of the application/database change the
> > | SuburbCode
> > | > for a particular Suburb,
> > | > he needs to change the table Employee also for every record with
same
> > | > SuburbCode.
> > | >
> > | > If the application allows the user/clerk changes the SuburbCode, my
> > | > application needs to change the detail
> > | > table (Employee).
> > | >
> > | > This is the same case as if any changes of EmpID in table Employee,
> > | changes
> > | > also need in table Manager explicitly.
> > | > MySQL does not do that itself.
> > | >
> > | >
> > | > - Original Message -
> > | > From: "Ken Sommers" <[EMAIL PROTECTED]>
> > | > To: "pak" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > | > Sent: Wednesday, July 11, 2001 1:44 PM
> > | > Subject: Re: Referential Integrity
> > | >
> > | >
> > | > | Please give some examples where you would need the dbms to do the
> > | > | referential integrity?
> > | > | Ken
> > | > | - Original Message -
> > | > | From: "pak" <[EMAIL PROTECTED]>
> > | > | To: "Ken Sommers" <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > | > | Sent: Tuesday, July 10, 2001 8:31 PM
> > | > | Subject: Re: Referential Integrity
> > | > |
> > | > |
> > | > | > So is MySQL not suitable for large corporate database ?
> > | > | > - Original Message -
> > | > | &g

Re: [PHP-DB] RE: trash last message ,this ones right I think

[Ken Sommers]

Thanks again,
why couldn't the main root be /htdocs/
?
ken
- Original Message -
From: "Tom Peck" <[EMAIL PROTECTED]>
To: "Ken Sommers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 6:05 PM
Subject: Re: [PHP-DB] RE: trash last message ,this ones right I think


> Yes that is correct.
>
> Your main site root is: /htdocs/www/
> And your sub site (util) root is /htdocs/util/
>
> These are two different sites from the browser's point of view.
>
> Neither site will have access to anything below the root folder (from the
> browser).
>
> Tom
>
> At 18:02 10/07/2001 -0700, you wrote:
> >Thanks Tom
> >  and sorry I didn't mention it properly at first,,
> >I was trying to analyse the problem.
> >is it becuz the first part of the referenece being the   ../
> >in 
> >the ../  wants to take the browser into illegal territory above the root?
> >because we are starting from /htdocs/util  so the  ../  would try to go
back
> >to /htdocs
> >
> >which is above the root (/htdocs/www) illegal territory.
> >just tryin to understand it
> >
> >thanks ,
> >Ken
> >
> >- Original Message -
> >From: "Tom Peck" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Tuesday, July 10, 2001 5:50 PM
> >Subject: Re: [PHP-DB] RE: trash last message ,this ones right I think
> >
> >
> > > The problem is that they are completely different websites, from the
web
> > > browser point of view - even though they are so close to each other on
the
> > > server...  You should have mentioned this was a sub domain site :-)
> > >
> > > If you REALLY don't want to copy the image from the www folder to the
util
> > > folder, then you have to use:
> > >
> > > http://www.consumergrapevine.org/img/background.jpg";>
> > >
> > > So that the browser can reach the image file.
> > >
> > > Tom
> > >
> > >
> > >
> > > At 17:30 10/07/2001 -0700, you wrote:
> > > >Hello again,
> > > >  DOCUMENT_ROOT is..  /htdocs/www
> > > >I  have a php file ( showdatabases.php) in my subdomain area
> >/htdocs/util/
> > > >it loads up just fine: and if you click it, you will see my database
> > > >structure if you like..:)
> > > >http://util.consumergrapevine.org/showdatabases.php
> > > >I have images stored in  /hdocs/www/img/  right now  (of course i
could
> >move
> > > >them, and fix all references to them) but I like them there because I
can
> > > >refer to images in pages in /www/ with background="img/bgpic.jpg"
> >...of
> > > >course this works just fine becuz /img/ is just down from /www/.
> > > >but now I have pages in subdomains as menitoned above like:
> > > >/htdocs/util/showdatabases.php
> > > >and of course I want to refer to images from those subdomain pages
> >too,,and
> > > >of course
> > > >I don't want to have another dir with the same pics in
them..something
> > > >like...  /htdocs/util/img/
> > > >becuz I already have the pics in /htdocs/www/img/  and if I make
another
> >sub
> > > >domain called /htdocs/stuff , I don't want to have to copy the pics
AGAIN
> > > >into /htdocs/stuff/img
> > > >right? So,,, (yes I may be getting to the end now..) how or where
should
> >I
> > > >put my pics so the /www/ and /util/ and /stuff/ guys can use them as
> > > >background pics?
> > > >
> > > >what would the body tag look like?
> > > >   doesn;t work
> > > >what will?
> > > >
> > > >thanks again,
> > > >
> > > >Ken
> > > >
> > > >
> > > >
> > > >--
> > > >PHP Database Mailing List (http://www.php.net/)
> > > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > >For additional commands, e-mail: [EMAIL PROTECTED]
> > > >To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> > >
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] RE: trash last message ,this ones right I think

[Ken Sommers]

Thanks Tom
 and sorry I didn't mention it properly at first,,
I was trying to analyse the problem.
is it becuz the first part of the referenece being the   ../
in 
the ../  wants to take the browser into illegal territory above the root?
because we are starting from /htdocs/util  so the  ../  would try to go back
to /htdocs

which is above the root (/htdocs/www) illegal territory.
just tryin to understand it

thanks ,
Ken

- Original Message -
From: "Tom Peck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 5:50 PM
Subject: Re: [PHP-DB] RE: trash last message ,this ones right I think


> The problem is that they are completely different websites, from the web
> browser point of view - even though they are so close to each other on the
> server...  You should have mentioned this was a sub domain site :-)
>
> If you REALLY don't want to copy the image from the www folder to the util
> folder, then you have to use:
>
> http://www.consumergrapevine.org/img/background.jpg";>
>
> So that the browser can reach the image file.
>
> Tom
>
>
>
> At 17:30 10/07/2001 -0700, you wrote:
> >Hello again,
> >  DOCUMENT_ROOT is..  /htdocs/www
> >I  have a php file ( showdatabases.php) in my subdomain area
/htdocs/util/
> >it loads up just fine: and if you click it, you will see my database
> >structure if you like..:)
> >http://util.consumergrapevine.org/showdatabases.php
> >I have images stored in  /hdocs/www/img/  right now  (of course i could
move
> >them, and fix all references to them) but I like them there because I can
> >refer to images in pages in /www/ with background="img/bgpic.jpg"
...of
> >course this works just fine becuz /img/ is just down from /www/.
> >but now I have pages in subdomains as menitoned above like:
> >/htdocs/util/showdatabases.php
> >and of course I want to refer to images from those subdomain pages
too,,and
> >of course
> >I don't want to have another dir with the same pics in them..something
> >like...  /htdocs/util/img/
> >becuz I already have the pics in /htdocs/www/img/  and if I make another
sub
> >domain called /htdocs/stuff , I don't want to have to copy the pics AGAIN
> >into /htdocs/stuff/img
> >right? So,,, (yes I may be getting to the end now..) how or where should
I
> >put my pics so the /www/ and /util/ and /stuff/ guys can use them as
> >background pics?
> >
> >what would the body tag look like?
> >   doesn;t work
> >what will?
> >
> >thanks again,
> >
> >Ken
> >
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] RE: trash last message ,this ones right I think

[Ken Sommers]

Hello again,
 DOCUMENT_ROOT is..  /htdocs/www
I  have a php file ( showdatabases.php) in my subdomain area   /htdocs/util/
it loads up just fine: and if you click it, you will see my database
structure if you like..:)
http://util.consumergrapevine.org/showdatabases.php
I have images stored in  /hdocs/www/img/  right now  (of course i could move
them, and fix all references to them) but I like them there because I can
refer to images in pages in /www/ with background="img/bgpic.jpg"...of
course this works just fine becuz /img/ is just down from /www/.
but now I have pages in subdomains as menitoned above like:
/htdocs/util/showdatabases.php
and of course I want to refer to images from those subdomain pages too,,and
of course
I don't want to have another dir with the same pics in them..something
like...  /htdocs/util/img/
becuz I already have the pics in /htdocs/www/img/  and if I make another sub
domain called /htdocs/stuff , I don't want to have to copy the pics AGAIN
into /htdocs/stuff/img
right? So,,, (yes I may be getting to the end now..) how or where should I
put my pics so the /www/ and /util/ and /stuff/ guys can use them as
background pics?

what would the body tag look like?
   doesn;t work
what will?

thanks again,

Ken



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Sub domain image referencing

[Ken Sommers]

Hello again,
 DOCUMENT_ROOT is..  /htdocs/www
I  have a php file ( showdatabases.php) in my subdomain area   /htdocs/util/
it loads up just fine: and if you click it, you will see my database
structure if you like..:)
www.util.consumergrapevine.org/showdatabases.php
I have images stored in  /hdocs/www/img/  right now  (of course i could move
them, and fix all references to them) but I like them there because I can
refer to images in pages in /www/ with background="img/bgpic.jpg"...of
course this works just fine becuz /img/ is just down from /www/.
but now I have pages in subdomains as menitoned above like:
/htdocs/util/showdatabases.php
and of course I want to refer to images from those subdomain pages too,,and
of course
I don't want to have another dir with the same pics in them..something
like...  /htdocs/util/img/
becuz I already have the pics in /htdocs/www/img/  and if I make another sub
domain called /htdocs/stuff , I don't want to have to copy the pics AGAIN
into /htdocs/stuff/img
right? So,,, (yes I may be getting to the end now..) how or where should I
put my pics so the /www/ and /util/ and /stuff/ guys can use them as
background pics?

what would the body tag look like?
   doesn;t work
what will?

thanks again,

Ken



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] HTML question

[Ken Sommers]

I Looked up the root..sorry
 it is DOCUMENT_ROOT ..  /htdocs/www
so I guess browsers think they are starting out at /htdocs/www  and can't go
below to get anything?
so if I have phtml pages at /htdocs/util/ like
www.util.consumergrapevine.org/showdatabases.php and images at
/htdocs/www/img can I use an image in /htdocs/www/img  as sa background imge
in a page located in dir  /htdocs/util/  ??
if so,what would be the body tag look like?
   ?
or should I move my /img/ dir somewhere else like maybe throw 'em in with
all the pages in /htdocs/www
?

thanks again,

Ken

- Original Message -
From: "Tom Peck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 4:00 PM
Subject: Re: [PHP-DB] HTML question


> Is /htdocs/  your web root?  If it isn't the browser loading up the page
> would not have access to /www/img/backgroundimage.jpg.  If it is - try
> removing the space after the .jpg in your body tag look like?
>
>
> Tom
>
>
> At 15:51 10/07/2001 -0700, you wrote:
> >Hello, pure HTML server question:
> >
> >images like (backgroundimage.jpg) stored on server at: /htdocs/www/img
> >
> >util.showpic.html is stored at :   /htdocs/util/
> >
> >How to use backgroundimage.jpg as background in util.showpic.html  ?
> >
> >
> >
> >
> >does not work..
> >what if anything will work?
> >
> >Thnaks
> >Ken
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] HTML question

[Ken Sommers]

HI, thanks
not sure what the web root is.
first dir I see on FTP is  /  so is that the root?
and it contains a whole bunch of dirs including htdocs
htdocs contains dirs:  img (pics)   util (utility html pages)   www (main
html pages)

is there a way to refer to images in imgfrom html pages in  util AND www

I have things like  ../img/   not sure what that means.

thanks,
ken







- Original Message -
From: "Tom Peck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 4:00 PM
Subject: Re: [PHP-DB] HTML question


> Is /htdocs/  your web root?  If it isn't the browser loading up the page
> would not have access to /www/img/backgroundimage.jpg.  If it is - try
> removing the space after the .jpg in your body tag.
>
> Tom
>
>
> At 15:51 10/07/2001 -0700, you wrote:
> >Hello, pure HTML server question:
> >
> >images like (backgroundimage.jpg) stored on server at: /htdocs/www/img
> >
> >util.showpic.html is stored at :   /htdocs/util/
> >
> >How to use backgroundimage.jpg as background in util.showpic.html  ?
> >
> >
> >
> >
> >does not work..
> >what if anything will work?
> >
> >Thnaks
> >Ken
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] image mapping

[Ken Sommers]

Hello, pure HTML server question:

images like (backgroundimage.jpg) stored on server at: /htdocs/img

util.showpic.html is stored at :   /htdocs/util/

How to use backgroundimage.jpg as background in util.showpic.html  ?




does not work..
what if anything will work?

Thnaks 
Ken




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] HTML question

[Ken Sommers]

Hello, pure HTML server question:

images like (backgroundimage.jpg) stored on server at: /htdocs/www/img

util.showpic.html is stored at :   /htdocs/util/

How to use backgroundimage.jpg as background in util.showpic.html  ?




does not work..
what if anything will work?

Thnaks 
Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Can anyone recommend PHPLIB?

[Ken Sommers]

Can anyone recommend PHPLIB? for authentication and session management? or
something else?



thanks Ken



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: Homesite Server Mapping

[Ken Sommers]

Thanks alot,
 that mapping works for me too: I use

From: C:\Program Files\Apache Group\Apache\htdocs\

To: http://localhost

for local mapping

Have you ever tried mapping to your REMOTE host?

I have tried and failed too many times, what works for Remote mapping?
any one ever done it?

Thanks,
Ken

"Hugh Bothwell" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "Ken Sommers" <[EMAIL PROTECTED]> wrote in message
> 001001c107e2$b84ad5c0$aa42500c@zeospantera">news:001001c107e2$b84ad5c0$aa42500c@zeospantera...
> > Has anyone successfully mapped their browser to a Remote Server?
> >
> > Please show your:
> > map from:
>
> C:\Program Files\Apache Group\Apache\htdocs\
>
> > Map to:
>
> http://127.0.0.1/
>
> (http://localhost/  would do exactly the same thing more prettily, but
would
> bug me about connecting before doing it.)

>PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Homesite Server Mapping

[Ken Sommers]

Hello,
any Homesite users out there??

Has anyone successfully mapped their browser to a Remote Server?

Please show your:

map from:

&

Map to:


thanks

ken 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Re: setting cookies so the cookie will expire when the user's session ends.

[Ken Sommers]

Kelvin,
thanks,

do you believe or hopefully even know that that expiration time for this
cookie:

setcookie ("TestCookie", $value,time()+3600);  /* expire in 1 hour */

will be one hour after the cookie is set OR
one hour after the session expires?

Ken

"Kelvin" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi Ken,
>
>  Do not specific the time in your cookie.
>
> ex: setcookie("usercookie","$username");
> once the user close the session, it will terminate the cookie.
>
> Kelvin.
>
>
> "Ken Sommers" <[EMAIL PROTECTED]> wrote in message
> 001701c1056d$2cb7c620$ca42500c@zeospantera">news:001701c1056d$2cb7c620$ca42500c@zeospantera...
> > Hello,
> > any way to set cookies so the cookie will expire when the user's session
> > ends.
> >
> > IN PHP 4?
> >
> > Ken
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
- Original Message -
From: "Kelvin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 3:11 PM
Subject: [PHP-DB] Re: setting cookies so the cookie will expire when the
user's session ends.


> Hi Ken,
>
>  Do not specific the time in your cookie.
>
> ex: setcookie("usercookie","$username");
> once the user close the session, it will terminate the cookie.
>
> Kelvin.
>
>
> "Ken Sommers" <[EMAIL PROTECTED]> wrote in message
> 001701c1056d$2cb7c620$ca42500c@zeospantera">news:001701c1056d$2cb7c620$ca42500c@zeospantera...
> > Hello,
> > any way to set cookies so the cookie will expire when the user's session
> > ends.
> >
> > IN PHP 4?
> >
> > Ken
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Authomatic Sorting

[Ken Sommers]

HI,
Look into Optimizing the Table..
it seems to clean up the holes.

Ken
- Original Message -
From: "Wilmar Pérez" <[EMAIL PROTECTED]>
To: "PHP List" <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:50 PM
Subject: [PHP-DB] Authomatic Sorting


> Hello guys
>
> I have the following two problems:
>
> I've got a table with an autoincrement field which is the registry's ID,
> everything goes well until I delete any registry.  MySQL doesn't re-sorts
> the information.  That is, I have the following:
>
> 001  user1
> 002  user2
> 003  user3
>
> If I delete user2, I would like to have something as shown next:
>
> 001  user1
> 002  user3
>
> But instead I end up with the following:
>
> 001  user1
> 003  user3
>
> Any idea or comment?
> ---
> Wilmar Pérez
>  IT Manager - Central Library
>  University of Antioquia
>Medellín - Colombia
>   tel: ++57(4)2105145
> ---
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] setting cookies so the cookie will expire when the user's session ends.

[Ken Sommers]

Hello,
any way to set cookies so the cookie will expire when the user's session
ends.

IN PHP 4?

Ken


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Authomatic Sorting

[Ken Sommers]

D you ever create an index on the primary key to speed things up??
ken
- Original Message -
From: "Paul Burney" <[EMAIL PROTECTED]>
To: "Wilmar Pérez" <[EMAIL PROTECTED]>; "PHP List"
<[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 3:18 PM
Subject: Re: [PHP-DB] Authomatic Sorting


on 7/4/01 1:50 PM, Wilmar Pérez at [EMAIL PROTECTED] wrote:

> I've got a table with an autoincrement field which is the registry's ID,
> everything goes well until I delete any registry.  MySQL doesn't re-sorts
> the information.  That is, I have the following:



Just add an "ORDER BY" clause to your query.  That is, if you want to sort
by reg_id, append "ORDER BY reg_id".  You can also add a DESC keyword to put
them in reverse order.

HTH.

Sincerely,

Paul Burney

++
Paul Burney
Webmaster && Open Source Developer
UCLA -> GSE&IS -> ETU
(310) 825-8365
<[EMAIL PROTECTED]>

++



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] kinda unrelated, but curious...

[Ken Sommers]

HI,
I stumbled on this site
http://www.missoulaweb.com/freelance.phtml
see if you think it is cool..

Ken
- Original Message -
From: "David Balatero" <[EMAIL PROTECTED]>
To: "Szii" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 03, 2001 12:03 AM
Subject: RE: [PHP-DB] kinda unrelated, but curious...


> Can you recommend job boards I won't have to pay to use?
>
> -- David
>
> -Original Message-
> From: Szii [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 02, 2001 11:27 PM
> To: David Balatero; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] kinda unrelated, but curious...
>
>
> Most of the time, by word of mouth.  Other than that, scan the 'net, look
on
> the
> job boards.  If you're new to the field, put your name in a couple
> recruiters hands.
> Sure, it's not freelance, and you won't make as much, but a couple jobs
and
> you
> start to become known.  Once you're known, and have a portfolio, it just
> gets
> easier from there on out.
>
> Also look for "part time work from home PHP jobs."  You can pick up some
> "reputation" that way before quitting your REAL job.  These are a real
PITA
> to
> find, but they do exist.
>
> Oh, and let all your friends know that you're a PHP/web coder looking for
> work.
> It's amazing how many people know people that know people and you end up
> with work. 8-)
>
> -Szii
>
>
> - Original Message -
> From: "David Balatero" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, July 02, 2001 11:27 PM
> Subject: [PHP-DB] kinda unrelated, but curious...
>
>
> > ...where do you people pick up freelance jobs? Any input on this?
> >
> > -
> > David Balatero
> > [EMAIL PROTECTED]
> > -
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] adding Carrol O'Conner in a form

[Ken Sommers]

HI,
IF i add my name as Carol O'Conner in a form and Echo (PHP 4.06 on win 95) it back I 
see 

Carol O\'Conner 

If I pass that name along to another page I'll see it as:

 Carol O\\\'Conner 

Even if I use :  

IF I enter my name as:Carol O'Conner  
I'll see it echoed as

Carol O\'Conner  

so I am thrilled that the <> came back and was displayed as it was typed in by the user

but how do I get rid of that pesky slash \   ?

so I can echo exactly what the user typed in?

I am already using:

 

Thanks for the help,

ken