php-windows Digest 25 Mar 2002 23:16:05 -0000 Issue 1062
Topics (messages 12748 through 12754):
Re: How to Pass the Username which from Windows Login
12748 by: brother
12753 by: Vail, Warren
Re: Is there anyway to save a file into Mysql database
12749 by: Mike Flynn
IIS + Oracle 7.* connection
12750 by: Daniel Ryhle
12752 by: Asendorf, John
Re: Strange error with FastTemplate and IIS 5
12751 by: Elias Santiago
Re: [PHP] Is there anyway to save a file into Mysql database
12754 by: Miguel Cruz
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 ---
The easiest way of doing this (asuming you are using IIS) is to set the
securitysettings for the website and just allow those domainaccounts you
want.
Properties > Directory Security
Uncheck Anonymous access.
Set userrights at the directory you are using as wwwroot.
c:\inetpub\wwwroot\my_domain\
Properties > Security > Add...
/brother
> -----Original Message-----
> From: Jack [mailto:[EMAIL PROTECTED]]
> Sent: den 25 mars 2002 07:26
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-WIN] How to Pass the Username which from Windows Login
>
>
> Dear all
> I want to prevent user to make another login before they can
> browse the
> Intranet, so is there anyway that php can grep the username
> from the windows
> Login or Domain Login?
> Which means if a user can login to the Windows NT, then
> he/she will have the
> right to browse the Intranet!
>
> Thx a lot
> Jack
> [EMAIL PROTECTED]
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Are you referring to the userid on the machine where your web application
runs (your server) or the userid of the user who connects to your website
with his browser? I suspect you mean the latter and would be very
interested in how this could be done as well.
Warren Vail
Tools, Metrics & Quality Processes
(415) 667-7814
Pager (877) 774-9891
215 Fremont 02-658
-----Original Message-----
From: Jack [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 24, 2002 10:26 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] How to Pass the Username which from Windows Login
Dear all
I want to prevent user to make another login before they can browse the
Intranet, so is there anyway that php can grep the username from the windows
Login or Domain Login?
Which means if a user can login to the Windows NT, then he/she will have the
right to browse the Intranet!
Thx a lot
Jack
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Yes, you can store "files" in a MySQL database. You store them in some
type of BLOB field, and just insert the binary data right into it. One
thing to watch out for is slashes. I forget if you need to addslashes
before putting the data into the database, but I think you need to
stripslashes after retrieving it, so it's not corrupt. I could tell you
for sure but I don't have any of my code in front of me right now :)
So basically you can create a table for files like this:
tblFiles:
int intFileID (for primary key purposes)
tinytext strFileFilename (you'll probably want this)
tinytext strFileType (if you're storing different kinds of file formats,
you'll need this or some other way to identify the file {MIME} type)
int intFileSize (optional)
tinytext strFileDescription (optional)
mediumblob blbFileData
Then you can store the file binary data into the blbFileData field and
retrieve it later. You can do this for any file formats.. including
images. There are many tutorials showing how to do this with images on the
web.
-Mike
At 02:14 PM 3/25/2002 +0800, you wrote:
>Dear all
>Can someone pls tell me is php will be able to grep text from MS Word and
>then save that word file into MYSQL database? Which means is MYSQL will be
>able to store files into it's table?
>
>Thx a lot
>jack
>[EMAIL PROTECTED]
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
Mike Flynn - Burlington, VT
http://www.mikeflynn.net/ - [EMAIL PROTECTED]
home=>work=>home=>store=>home
--- End Message ---
--- Begin Message ---
Hi!
I never connected to a oraxcle db before and this is my problem:
I need to connect to an oracle db through the network.
I have SID, user id, pass and ip adress.
My IIS system is placed on a win2k machine with php4 installed.
Can anybody post the complete code over a login/query procedure
against oracle(NOT 8). I would be extra happy if it contained some comments.
As of now i only get the error "PHP Warning: Oracle: Connection Failed:
ORA-03121: no interface driver connected - function not performed in
\*\*.php on line 4 "
Greatful for all help
--- End Message ---
--- Begin Message ---
It sounds like you don't have the oracle or OCI8 dlls loading. The major
problem with connections to oracle are usually these:
1) Use the 8.1.6 client, even if you're connecting to an 7.3.4 database...
2) Make sure you have the oracle dlls uncommented in the php.ini file
3) Use PHP in cgi mode, don't use the isapi module...
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
Nullum magnum ingenium sine mixtura dementiae fuit
> -----Original Message-----
> From: Daniel Ryhle [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 25, 2002 10:56 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] IIS + Oracle 7.* connection
>
>
> Hi!
> I never connected to a oraxcle db before and this is my problem:
>
> I need to connect to an oracle db through the network.
> I have SID, user id, pass and ip adress.
>
> My IIS system is placed on a win2k machine with php4 installed.
>
> Can anybody post the complete code over a login/query procedure
> against oracle(NOT 8). I would be extra happy if it contained
> some comments.
>
> As of now i only get the error "PHP Warning: Oracle:
> Connection Failed:
> ORA-03121: no interface driver connected - function not performed in
> \*\*.php on line 4 "
>
> Greatful for all help
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi:
I designed a website using FastTemplate 1.1.0. I used Apache for Windows
1.3.14 and PHP version 4.0.6 for development in a test-server. Everything
went fine, and I am sure that all template variables were defined.
Now, when I uploaded the finished site to the IIS 5.0 server running the
SAME PHP version, I get errors beneath ALL pages saying for example:
"[FastTemplate] Warning: no value found for variable: $main"
It spits out this error for ALL template variables, but strangely all the
content for the variables is shown on the page, yet FastTemplate spits out
this error, but ONLY on the IIS server, not on Apache... In Apache, it runs
without a hitch. No scripts or variables use Apache or IIS directives or
variables. I even compared both php.exe files on the test server and the IIS
(production) server, and they are identical. The test server is configured
EXACTLY as the Production one, they even have the EXACT same hardware and
software installation (Norton Ghost'ed). The PHP, MySQL initialization
files and directories are identical. The ONLY difference is the webserver
software.
Any ideas?
P.D. I am the server administrator . Before someone else "recommend" using
Apache,
it is a server running some databases that MUST run on IIS... Management
decision,
not mine, can't change webserver software.
--- End Message ---
--- Begin Message ---
On Mon, 25 Mar 2002, Jack wrote:
> Can someone pls tell me is php will be able to grep text from MS Word and
> then save that word file into MYSQL database? Which means is MYSQL will be
> able to store files into it's table?
You can pipe the Word document through a program like catdoc
(http://www.ice.ru/~vitus/catdoc/) and then save it in a TEXT field in
MySQL.
miguel
--- End Message ---
