php-windows Digest 4 Dec 2001 12:24:09 -0000 Issue 884
Topics (messages 10713 through 10718):
IIS snmp address?
10713 by: Josh Seward
PHP 4/MS Sql Server
10714 by: Louis Romestant
Re: MYSQL and PHP
10715 by: Svensson, B.A.T. (HKG)
Convert number to letters
10716 by: Mad Nas
Re: IIS help
10717 by: Christian Sandfeld
Posting data to a web page
10718 by: FPU.WHITES1.FRIENDSPROVIDENT.CO.UK
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 ---
Does anyone have a link for setting up SNMP on IIS w/ PHP?
I need the mail functions to work!
Thanks,
--- End Message ---
--- Begin Message ---
I've been doing this:
<?
$cn=mssql_connect (<IP address>, <UID>, <PWD>);
mssql_select_db(<db> , $cn);
?>
And it works like a dream on servers over which I have control. My ISP
supports PHP4 (on Windows) and Ms Sql Server. They setup a db for me which
I can connect to using Enterprise Manager. No matter how I cast
mssql_connect(), thought, I can't get to their server from a script. I've
tried names and ip addresses. Phpinfo() shows mssql extensions.
Is there some other way I can connect?
--- End Message ---
--- Begin Message ---
First of all, this is not an php question. Second of all, if the second
insert fails, the only think I can think of, regarding the information you
gave, is that u_id is a "not null" field, that is you must supply a value
for this field.
-----Original Message-----
From: Jordan Arendt
To: [EMAIL PROTECTED]
Sent: 2001-12-03 18:26
Subject: [PHP-WIN] MYSQL and PHP
Hi,
I'm struggling with some php code. I'm trying to insert some info into
a
mysql DB. I beleive I'm failing on the SQL statement, specifically the
WHERE syntax. Can anyone help?
------------
bypass = 0 --confirmed
$i = 0 works and inserts into the DB.
$i=1 works, but doesn't insert into DB.
-------------
if ($bypass==0){
// Add picks: this is ugly!
if ($i==0){
echo " i equals zero";
$sql = "INSERT INTO picks (u_id, p_1) VALUES ('$u_id','$s_id0')";
$result = mysql_query ($sql);
}
elseif ($i==1){
echo "i equals one";
printf ("u_id equals %s\n",$u_id);
$sql = "INSERT INTO picks (p_2) VALUES ('$s_id1')WHERE
picks.u_id=$u_id";
$result = mysql_query ($sql,$db);
}
---------------
The phppool.picks looks like (with more p_*):
mysql> select u_id,p_1,p_2,p_3 from phppool.picks
-> ;
+------+-----+-----+-----+
| u_id | p_1 | p_2 | p_3 |
+------+-----+-----+-----+
| 1 | 2 | 0 | 0 |
| 2 | 1 | 0 | 0 |
| 3 | 7 | 0 | 0 |
| 4 | 7 | 0 | 0 |
| 0 | 0 | 2 | 0 |
| 5 | 2 | 0 | 0 |
+------+-----+-----+-----+
6 rows in set (0.00 sec)
Any help would be greatly appreciated. I know the code is ugly. I
haven't
coded in a few years, and this is my first php program.
Jordan
--
PHP Windows 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]
--- End Message ---
--- Begin Message ---
Hi all
How can convert number to letters in PHP?
( for example 254=two handres and fifty four )
Thanks for help
Mad Nas
--- End Message ---
--- Begin Message ---
Don't know if you can find your answer there, but have a look at
www.15seconds.com
/Christian
-----Original Message-----
From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
Sent: 3. december 2001 23:02
To: '[EMAIL PROTECTED]'
Subject: [PHP-WIN] IIS help
I know this is a php forum, but I am not sure where to go. Anyone know of a
good site on IIS other than Microsoft's junk. I am trying to use directory
security on win2k IIS 5 machine using the NTFS permissions. For some reason
the only account that can get access to view anything page on the site, is
the administrator account. Any ideas??
Ryan Conover
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.pitt.edu/~rscst25/
--
PHP Windows 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]
--- End Message ---
--- Begin Message ---
--- Received from FPU.WHITES1 799 3703 04-12-01 12:22
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> [EMAIL PROTECTED]
-> [EMAIL PROTECTED]
Be careful using long urls!
It's a very unreliable mechanism.
I've tried it in the past and anything over 1K is pushing your luck. Depending on the
systems the URL is being passed through I've had truncations (or
just things going horribly wrong) from as little as 500 characters before now - and of
course unless you're on a purely local setup, it might not even be
consistent.
It's more work but for anything like this use POST if you can.
-Steve
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sun, 2 Dec 2001 22:14:18 -0000
Subject: [PHP-WIN] Posting data to a web page
Hi,
I am trying to post data to a web page using the code
fopen("http://www.someserver.com?data=XXXXXXXXXXX";);
The data is actually around 7k worth and I seem to be having trouble
with the app it is posting to ( I have URL encoded it). I was reading
in various places on the web that there might be a url length limitation
and was wondering if this method should work or not for posting data to
a form??
If anyone can confirm, deny, or point me in the direction of something
better, I'd apreciate it.
Regards,
Paul
This email or attachment(s) may contain confidential or legally privileged information
intended for the sole use of the addressee(s). Any use, redistribution, disclosure, or
reproduction of this message, except as intended, is prohibited. If you received
this email in error, please notify the sender and remove all copies of the message,
including any attachments. Any views or opinions expressed in this email (unless
otherwise stated) may not represent those of Microtech Limited.
This email has been scanned for viruses by MailSafe. For more infomation please visit
http://www.microtech.co.gg/mailSafe
--
PHP Windows 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]
This e-mail may contain confidential information and/or copyright
material. This e-mail is intended for the use of the addressee
only. Any unauthorised use may be unlawful.
If you receive this e-mail by mistake please advise the sender
immediately by using the reply facility in your e-mail software.
Friends Provident Marketing Group consists of the following
companies:
Friends Provident Life and Pensions Limited.
Registered number 4096141.
Friends' Provident Unit Trust Managers Limited.
Registered number 970641
FP Life Assurance Limited.
Registered number 782698
Friends Provident Pensions Limited.
Registered number 475201
Friends Ivory & Sime Managed Pensions Funds Limited.
Registered number 1020044
Registered and Head Office of each of the above companies is at Pixham End,
Dorking, Surrey RH4 1QA.
Registered in England. Incorporated companies limited by shares.
Ivory & Sime Trustlink Limited. Registered number 151198
Registered and Head Office: One Charlotte Square, Edinburgh EH2
4DZ. Registered in Scotland. Incorporated company limited by
shares.
Companies within this Group transact life assurance, pension,
permanent health, unit trust and investment trust business
All are regulated by the Personal Investment Authority.
--- End Message ---
