php-windows Digest 5 Apr 2002 16:29:35 -0000 Issue 1079
Topics (messages 12943 through 12949):
Re: PHP and mySQL...
12943 by: ST Ooi
12944 by: Anthony Ritter
12948 by: Svensson, B.A.T. (HKG)
uploads
12945 by: Sandeep Murphy
Re: update?'
12946 by: Svensson, B.A.T. (HKG)
12947 by: Sandeep Murphy
12949 by: Mike Flynn
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
I've experience developing website using IIS, MySQL and PHP on Windows 2K
machine and upload it to a server that is running Apache, MySQL and PHP
on RedHat Linux 7.1 without a single code modification.
To upload files to your server, you need a FTP client,
to create a database that your local mahcine is running,
most server has some version of PHPMyAdmin.
Thanks
ST Ooi
Malaysia
http://www.shop-streets.com
----- Original Message -----
From: "Anthony Ritter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 05, 2002 8:15 AM
Subject: [PHP-WIN] PHP and mySQL...
> Using MS Windows 98, Apache, PHP and mySQL.
>
> I've installed Apache on my hard drive to test a database driven website
> using PHP and mySQL.
>
> Could somebody lead me through the steps if I want to continue using the
> mySQL database and PHP when the site goes live and the files are uploaded
> and published to my ISP's server?
>
> Is this possible?
>
> Thanking all in advance.
> Tony Ritter
>
>
>
>
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
Sorry if my original question was confusing.
This is what I would like to accomplish:
I am currently developing a database on my website using mysql which is on
my harddrive.
I have installed Apache as well and I am using PHP.
My database is functioning fine on localhost.
I would like to find out the steps one takes in going from the process of
having this reside on my harddrive - localhost - in development - to my
ISP's server when it goes live.
Thanking all in advance.
Tony Ritter
--- End Message ---
--- Begin Message ---
> -----Original Message-----
> From: Anthony Ritter
> Sent: Friday, April 05, 2002 5:26 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] PHP and mySQL...
>
>
> Sorry if my original question was confusing.
>
> This is what I would like to accomplish:
>
> I am currently developing a database on my website using mysql which is on
> my harddrive.
> I have installed Apache as well and I am using PHP.
>
> My database is functioning fine on localhost.
>
> I would like to find out the steps one takes in going from the process of
> having this reside on my harddrive - localhost - in development - to my
> ISP's server when it goes live.
I think this is an issue to discuss with you IPS(?), or what exactly is it that you
need to know?
> Thanking all in advance.
> Tony Ritter
>
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
hi,
I am trying to upload a file from an HTML form to an Oracle database which
has a column of type BLOB...This has been one of the most frustrating things
I hv done rather not hv done...
if anyone has achieved something of this kind, wud be gratefull if u can
mail/paste the relevant script here..
TIa,
sands
--- End Message ---
--- Begin Message ---
First of all, it is useful to know _which_ database system you are using, in order to
give an answer, also weather the databases are
located within the same RDBMS or not.
And secondly your question is not related to php....
Anyhow, to start with the syntax of your update statement, it looks suspicious. The
UPDATE statement (according to ISO 9075) does
only take one(1) table name as a target table.
/Anders
> -----Original Message-----
> From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 1:31 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] update?'
>
>
>
> [Sandeep Murphy]
>
> Hi,
>
>
>
> I need to update an entire table in one database with the values from
> another database... My query reads like this:
>
> update palmeira.t_colaboradores t, hr.member_status s, hr.member_data d
>
> set t.structure=s.structure, t.depart_area=s.area where t.cs_id=d.cs_id
> and d.cs_id=125
> [Sandeep Murphy]
>
> in the query, plameira and hr are the 2 diff databases....
>
> any suggestions as to how to make this work???
--- End Message ---
--- Begin Message ---
hi,
sorry for missing out on the database type.. am using Mysql 3.23... am
trying to execute this query in query analyzer (Mascon) directly...
-----Original Message-----
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]
Sent: sexta-feira, 5 de Abril de 2002 11:34
To: Sandeep Murphy
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] update?'
First of all, it is useful to know _which_ database system you are using, in
order to give an answer, also weather the databases are
located within the same RDBMS or not.
And secondly your question is not related to php....
Anyhow, to start with the syntax of your update statement, it looks
suspicious. The UPDATE statement (according to ISO 9075) does
only take one(1) table name as a target table.
/Anders
> -----Original Message-----
> From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 1:31 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] update?'
>
>
>
> [Sandeep Murphy]
>
> Hi,
>
>
>
> I need to update an entire table in one database with the values from
> another database... My query reads like this:
>
> update palmeira.t_colaboradores t, hr.member_status s, hr.member_data d
>
> set t.structure=s.structure, t.depart_area=s.area where t.cs_id=d.cs_id
> and d.cs_id=125
> [Sandeep Murphy]
>
> in the query, plameira and hr are the 2 diff databases....
>
> any suggestions as to how to make this work???
--- End Message ---
--- Begin Message ---
I doubt there is any way to do this without using an intermediate step. I
would grab all the data you need from whichever tables you are grabbing
from, into a temporary array in PHP, including whatever keys you are using
to place them into the other table where they are being placed. Then go
back through that array, running one or more UPDATE query for each row,
putting the data where it belongs.
-Mike
At 12:36 PM 4/5/02 +0100, Sandeep Murphy wrote:
>hi,
>
>sorry for missing out on the database type.. am using Mysql 3.23... am
>trying to execute this query in query analyzer (Mascon) directly...
--- End Message ---
