php-windows Digest 15 Mar 2004 08:21:21 -0000 Issue 2165
Topics (messages 23134 through 23143):
Re: servers in php
23134 by: Svensson, B.A.T. (HKG)
23137 by: Comex
Windows 95
23135 by: Bobo Wieland
23138 by: Svensson, B.A.T. (HKG)
sql dumps
23136 by: Bobo Wieland
23139 by: Svensson, B.A.T. (HKG)
23140 by: Bobo Wieland
23142 by: Svensson, B.A.T. (HKG)
load data infile
23141 by: Bobo Wieland
Angry, up all night newbie (re: apache config)
23143 by: Rob Conklin
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 ---
>> And if you don't use fork(), how did you plan to handle the
>> port situation, once a process has connected to the server?
>I don't know, which is why I asked.
The answer is: unless you bifurcate your process, you can't.
--- End Message ---
--- Begin Message ---
On Sat, 13 Mar 2004 19:06:38 -0500, Comex <[EMAIL PROTECTED]> wrote:
I was wondering how to go about making a server in PHP that would accept
multiple connections..in windows, so I can't use forks. I'd need to
call the program from itself but I don't know how the listening works.
I found an example from the Zend mailing list that allowed this by looping
through the clients..thanks.
--- End Message ---
--- Begin Message ---
Hi! Is it possible to install apache/php/mysql under Windows 95?
.bobo
--- End Message ---
--- Begin Message ---
AS far as I know:
For apache, yes, php should be yes, MySQL I don't know, but think so,
but to have any use of it you need to have winsocket installed.
There is an explanation on the apache pages how to deal with
Win95.
-----Original Message-----
From: Bobo Wieland
To: [EMAIL PROTECTED]
Sent: 14-3-2004 13:56
Subject: [PHP-WIN] Windows 95
Hi! Is it possible to install apache/php/mysql under Windows 95?
.bobo
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi!
Is there some good tutorial or example code for dumping sql-files
back-and-forth via php?
.bobo
--- End Message ---
--- Begin Message ---
What does "sql file" mean? (no such thing exists)
-----Original Message-----
From: Bobo Wieland
To: [EMAIL PROTECTED]
Sent: 14-3-2004 13:58
Subject: [PHP-WIN] sql dumps
Hi!
Is there some good tutorial or example code for dumping sql-files
back-and-forth via php?
.bobo
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
A file with the .sql extension.... When I use MySQL-Front and export tables
and data they are saved in sql-files. Just a simple txtfile with all INESET
queries...
I think I know how to do this now, but have just one problem; thought of
using this bit of code from the users comments from the mysql_query entry in
the online documentation:
$dbf_handle = fopen($db_file, "r");
$sql_query = fread($dbf_handle, filesize($db_file));
fclose($dbf_handle);
foreach ( explode(";", "$sql_query") as $sql_line) {
if ( $dbquery = mysql_query("$sql_line") ) { ...
But what is the data contaions several ";" ? Any other suggestions than a
simple string_replace?
.bobo
----- Original Message -----
From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 14, 2004 2:12 PM
Subject: RE: [PHP-WIN] sql dumps
> What does "sql file" mean? (no such thing exists)
>
> -----Original Message-----
> From: Bobo Wieland
> To: [EMAIL PROTECTED]
> Sent: 14-3-2004 13:58
> Subject: [PHP-WIN] sql dumps
>
> Hi!
>
> Is there some good tutorial or example code for dumping sql-files
> back-and-forth via php?
>
> .bobo
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
That will fail if the query is broken into several lines.
In any case I would suprise me if MySQL did not have the
ability to do batch queries - e.i. with an interactive
shell tell the shell to execute a certain file.
-----Original Message-----
From: Bobo Wieland
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 14-3-2004 14:33
Subject: Re: [PHP-WIN] sql dumps
A file with the .sql extension.... When I use MySQL-Front and export
tables
and data they are saved in sql-files. Just a simple txtfile with all
INESET
queries...
I think I know how to do this now, but have just one problem; thought of
using this bit of code from the users comments from the mysql_query
entry in
the online documentation:
$dbf_handle = fopen($db_file, "r");
$sql_query = fread($dbf_handle, filesize($db_file));
fclose($dbf_handle);
foreach ( explode(";", "$sql_query") as $sql_line) {
if ( $dbquery = mysql_query("$sql_line") ) { ...
But what is the data contaions several ";" ? Any other suggestions than
a
simple string_replace?
.bobo
----- Original Message -----
From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 14, 2004 2:12 PM
Subject: RE: [PHP-WIN] sql dumps
> What does "sql file" mean? (no such thing exists)
>
> -----Original Message-----
> From: Bobo Wieland
> To: [EMAIL PROTECTED]
> Sent: 14-3-2004 13:58
> Subject: [PHP-WIN] sql dumps
>
> Hi!
>
> Is there some good tutorial or example code for dumping sql-files
> back-and-forth via php?
>
> .bobo
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
This code...
<code>
$q = "LOAD DATA INFILE '".str_replace("\\","/",$sqlfil["tmp_name"])."'
REPLACE INTO TABLE sortiment";
$res = mysql_query($q, $link_id);
print(mysql_affected_rows($link_id)."<br
/>".str_replace("\\","/",$sqlfil["tmp_name"]));
</code>
...gives the output:
-1
C:/WINDOWS/TEMP/php1D0.tmp
Any idea why this isn't working?
.bobo
--- End Message ---
--- Begin Message ---
I found the "install" text file included with the PHP for Windows download
incomphrehensible and useless. I won't go on and on, but was wondering if
someone can point me to some information that would explain, in a simple,
deterministic and clear way, what steps are necessary to get Apache to load
the proper PHP modules and recognize the contents of .php files.
I'm working with the latest version of PHP, which doesn't particularly like
the latest version of apache (2.0), so I downloaded and installed the 1.3x
version of apache.
All I can say is that if someone can help me with this, I'll owe 'ya one.
TIA
RC
ps. please send email regarding this to [EMAIL PROTECTED]
--- End Message ---
