php-windows Digest 22 Feb 2005 06:59:08 -0000 Issue 2586
Topics (messages 25649 through 25653):
Re: php 4.3.7 and MS-SQL access
25649 by: Danny Willis
Re: w2k and IIS4 partially working
25650 by: The Disguised Jedi
Re: [PHP] Is there a way I can read full path names of files on the server and
enter it into the database ?
25651 by: Richard Lynch
Missing MySQL DLLs in Windows PHP 5.0.3 - not in pecl either!
25652 by: Jimbus
25653 by: M. Sokolewicz
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 ---
Ok,
I restarted the web server but I am still getting the same error. I've
uncommented the MSSQL server extension and restarted the server.
Is my build version not compiled to run the extensions? Also, Are there
build options that I can use to increase the performance of php?
This really has me stumped. Any more assistance is greatly appreciated.
Thanks.
"Frank M. Kromann" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> You need to restart the web server after making changes to the hp.ini
> file.
> When you are using ISAPI the ini file is only read when the server is
> started.
>
> - Frank
>
>> That's what's strange. I uncommented the MSSQL Server extension but I
> am
>> still unable to connect.
>>
>> Is there anything else I need to install or configure?
>>
>> -----Original Message-----
>> From: Frank M. Kromann [mailto:[EMAIL PROTECTED]
>> Sent: Friday, February 18, 2005 2:40 PM
>> To: Danny Willis
>> Cc: [email protected]
>> Subject: Re: [PHP-WIN] php 4.3.7 and MS-SQL access
>>
>> Hello,
>>
>> You need to load the MSSQL Server etension form php.ini with this line:
>>
>> extension=php_mssql.dll
>>
>> - Frank
>>
>> > I'm running the following:
>> >
>> > Win 2k3 server
>> > IIS 6.0
>> > php 4.3.7 in IASPI mode
>> >
>> >
>> > Now I am trying to get php to connect to MSSQL but it will not let me
> do
>> so.
>> > I keep getting the error message:
>> >
>> > "You do not have MSSQL support in this version/complie of php"
>> >
>> > I really need to get this connection figured out. Any ideas?
>> >
>> > --
>> > PHP Windows Mailing List (http://www.php.net/)
>> > To unsubscribe, visit: http://www.php.net/unsub.php
>> >
>>
>>
>>
--- End Message ---
--- Begin Message ---
you need to put all of your HTML and such in the *.php file. That is
the only way it will work inline....
On Sat, 19 Feb 2005 08:30:02 -0500, Frank <[EMAIL PROTECTED]> wrote:
> php runs from .php modules but not inline as <?php. It seems like I need to
> add a server extension to handle the scripting, but I can't for the life of
> me see how to do it with iis manager. I'm wondering if I need to do a
> registry addition or something. Thanks.
>
> Frank
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
The Disguised Jedi
[EMAIL PROTECTED]
Now you have my $0.02. Or .01 Pounds, .014 Euros, or $0.025 CAN. I'm
already internationally compatible!
PHP rocks!
"Knowledge is Power. Power Corrupts. Go to school, become evil"
Disclaimer: Any disclaimer attached to this message may be ignored.
However, I must say that the ENTIRE contents of this message are
subject to other's criticism, corrections, and speculations.
This message is Certified Virus Free
--- End Message ---
--- Begin Message ---
Vaibhav Sibal wrote:
> I wanted to ask whether there is a way whereby a script can read
> filenames from a particular directory on the server and enter those
> filenames with the complete path into the MySQL database? I am trying
> to do this, because I am developing an application where a supervisor
> will be distributing files to different users, and those users are to
> work on the files allocated to them by the supervisor. There is a big
> pool of files containing around 10k-15k files and the supervisor will
> be instructed to allocate around 200 files to a user each day, and the
> user should be able to open that file and work on it. I am using a
> Linux Fedora core 2 server running Apache 2.0.53 and PHP 5.0.3 and
> MySQL, and my clients are Windows clients. So I wanted to ask all of
> you people what would be a better approach to do this, the following
> are the 2 options :
I hope the work load for a single file is rather low -- 200 files to edit
seems like an awful lot...
> (1)As soon as the supervisor selects say around 200 files for a user
> called robert, 200 files from the file pool automatically get copied
> to the home directory of robert. While they are copied to the home
> directory of Robert, the name of each file with their complete path
> name gets logged onto the database. Now I am doing since because I
> need to know where each file went and what user is working on what
> file. Now since robert is working on a client running on windows, we
> can map a drive of windows onto the home directory of robert. In this
> scenario can we instruct PHP to open files from a local directory
> (i.e. the mapped directory of windows)? Because I need to, somehow,
> log when a user opened the file and when he closed it.
I would avoid this route -- Mainly because to give PHP permission to copy
files onto Robert's computer will open up some pretty major security holes
in every single desktop machine.
> (2) The second scenario is that, I just enter the name of the files
> allocated to a user alongwith the complete pathnames to a database and
> I have another column this time where I store the user's name. Now
> whenever the user logs into our system using his username and
> password, and checks to see his work, he sees a list of files on the
> browser itself, but now we will have to convert this list of files
> into links so that the user can click on the links and directly open
> the file in the required software from the server itself. The issue,
> again, in this kind of design is that how do i open the file in the
> required software and even if i do it then how do i record when the
> user opened the file and when he finished working on it.
This seems perfectly reasonable approach.
Once you have assigned a file to 'robert' in the database, then you can
let 'robert' download the file -- or even a zip file with all 200 files in
it.
The downloaded file will have the correct Windows extension -- or they
will after 'robert' unzips them, and Windows will open the right software,
if 'robert' has it installed and the machine is configured correctly.
If it's not installed or the machine isn't configured correctly, there is
nothing you can do about it from PHP.
Then 'robert' can work on them, and, when they are finished, they can
upload the edited files.
You can track when 'robert' downloaded the files, and when 'robert'
uploaded the files.
If you want to do it one file at a time you could track each and every
download/upload -- but it would be very painful for 'robert' to download
every single file and upload every single file.
Most likely, just knowing that 'robert' downloaded 200 files, took 43
minutes to work on them, and uploaded them again, is plenty of info to
track productivity.
--
Like Music?
http://l-i-e.com/artists.htm
--- End Message ---
--- Begin Message ---
The instructions state that php_mysql.dll is included in either the pecl
extension package, or the installer itself (not sure, it wasn't clear).
After installing this dll is no where to be found... neither is
libmySQL.dll as the docs say it is.
All I see is php_pdo_mysql.dll, i tried using this by enabling in ext
folder, but no dice.
Any idea what's going on with these missing dlls.
BTW, I made sure everything else was set (path, ext path, php.ini ext
path, extension enabled in php.ini, etc)
--- End Message ---
--- Begin Message ---
well, they should be available via PECL (php_mysql.dll that is),
libmysql should be in the download of the main product. As for
php_pdo_mysql.dll, you'll need php_pdo.dll running aswell, and then use
the PDO functions:
http://www.php.net/manual/en/ref.pdo.php
Jimbus wrote:
The instructions state that php_mysql.dll is included in either the pecl
extension package, or the installer itself (not sure, it wasn't clear).
After installing this dll is no where to be found... neither is
libmySQL.dll as the docs say it is.
All I see is php_pdo_mysql.dll, i tried using this by enabling in ext
folder, but no dice.
Any idea what's going on with these missing dlls.
BTW, I made sure everything else was set (path, ext path, php.ini ext
path, extension enabled in php.ini, etc)
--- End Message ---
