php-windows Digest 11 Feb 2001 06:22:29 -0000 Issue 439
Topics (messages 5497 through 5503):
Re: Mysql tutorials
5497 by: Alain Samoun
Re: php access query problem
5498 by: Bikes
Re: PHP is not stable under Windows platform...
5499 by: phobo
CAN YOU ADVERTISE TO OVER 20 MILLION E-MAIL ADDRESSES?
5500 by: Luke6
Re: spam detection
5501 by: Paul Trapnell
5.5 cents Long Distance, 24 hrs/day, No Fees!
5502 by: LD305.knto.or.kr
IIS Manipulation
5503 by: David Harrison
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]
----------------------------------------------------------------------
Also the excellent book by Paul DuBois: MySQL
Alain
On Sat, Feb 10, 2001 at 10:26:14AM -0800, Paul Trapnell wrote:
> MYSQL TUTORIALS
>
> http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
> (by Graeme Merrall)
>
> http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
> (by Israel Denis & Eugene Otto tutorial)
>
> http://www.webmasterbase.com/article.php?aid=228&pid=0
> (by Kevin Yank)
>
> http://www.thickbook.com/extra/php_apachephp4_win.phtml
> http://www.thickbook.com/extra/php_mysql.phtml
> (by Julie Meloni)
>
> http://212.223.75.38/workshops/Default.asp?workshop=21
> (by Edward Tanguay)
>
> http://dcfonline.sfu.ca/ying/linux/webdb/toc.html
> (by Ying Zhang)
>
>
>
> http://www.nusphere.com/services/training.htm (mysql training program; fees)
>
> http://www.mysql.com/documentation/index.html (mysql manual)
> http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html (index)
>
> http://marc.theaimsgroup.com/?l=mysql&r=1&w=2 (Mysql mailing list archives)
>
>
>
> ----- Original Message -----
> From: "Jan Aagaard" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, February 09, 2001 3:32 AM
> Subject: [PHP-WIN] MySQL setup tutorial
>
>
> > Anybody out there know where I can find a good tutorial on how to set op
> > MySQL and make it work with PHP on the Windows platform?
> >
> > Please send a reply to my e-mail address allso.
> >
> > - Jan Aagaard
> >
> >
> >
>
I think you should also use mysql, for guaranteed interoperability with php.
But meanwhile, just keep playing around with the quotes ' and " .
Bikes
-----Original Message-----
From: Gonzalo Vera
To: aaron
Cc: [EMAIL PROTECTED]
Sent: 2/9/01 8:45 PM
Subject: Re[2]: [PHP-WIN] php access query problem
At least in older versions of access it's better to enclose field
names in square brackets, like
"SELECT Location, [Dept ID], [Equip Type] FROM Equipment01 WHERE
Location = '415C' AND [Equip Type] = 'C'"
Also, shouldn't you end with a semicolon? The weird thing here is that
it worked before. Sorry if I can't get any farther, I'm just switching
from access 95 to MySQL (bye bye MS), and in access 95 those would be
troublesome issues.
Gonzalo.
> Access 2000 on IIS 4.0
> "Gonzalo Vera" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What DB are you using?
> Gonzalo.
>> I have the query
>> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
>> Equipment01 WHERE Location = '415C'");
>> which returns the proper results but when I add AND 'Equip Type' =
'C' to
>> the end of it I get no results. Is my syntax correct? Thanks, Aaron
>> $cur= odbc_exec( $cnx, "SELECT Location, 'Dept ID', 'Equip Type' FROM
>> Equipment01 WHERE Location = '415C' AND 'Equip Type' = 'C'");
> --
> 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]
--
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]
"reliably crashing"?
heheh
Siggy
> I found the ISAPI plugin to be reliably crashing on Win/NT4 and W2K
> platforms altogether. Simple advice - don't use ISAPI on a Windows
platform
> (sad, but true).
>
>
> ...ebird
>
> >O Ernest E. Vogelsinger
> (\) http://www.1-at-web.at/
> ^ ICQ# 13394035
>
>
> --
> 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]
>
>
TO BE REMOVED FROM FUTURE MAILINGS, SIMPLY REPLY TO THIS
MESSAGE AND PUT
"REMOVE" IN THE SUBJECT.
20 MILLION
E-MAIL ADDRESSES
FOR ONLY $249
**Over Night International Shipping Included**
Many Call This "The "Perfect E-Mail List"
Over 20-Million Of The Best E-Mail Addresses Available
_/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/
Our research has found that many people have tried one or more of
the following...
Free Classifieds? (Don't work anymore)
Web Site? (Takes thousands of visitors)
Banners? (Expensive and losing their punch)
E-Zine? (Hope they have a *huge* subscriber list)
Search Engines? (Forget it, unless you're in the top 20)
S O W H A T W I L L W O R K ?
Although often misunderstood, there is one method that has proven
to succeed time-after-time.
E - M A I L M A R K E T I N G ! !
IT'S A FACT... If you're not using your computer to generate
income, GOOD income, you're leaving money on the table.
Here's what the experts have to say about E-Mail Marketing:
"E-mail is an incredible lead generation tool"
-Crains Magazine
"A gold mine for those who can take advantage of
bulk e-mail programs" - The New York Times
"Blows away traditional Mailing" - Advertising Age
Here's an example of your potential earnings if you have a
product or service that brings you a profit of around $30.
Remember, on the Internet, you can make money 7 days a week, 24
hours a day... even while you sleep, orders come from all over
the world!
Orders
Per Day Weekly Monthly Yearly
1 $ 210 $ 840 $ 10,080
2 420 1,680 20,160
3 630 2,520 30,240
5 1,050 4,200 50,400
10 2,100 8,400 100,000
15 3,150 12,600 151,200
THE QUESTION IS... how do you generate those orders?
The least expensive and fastest way is through E-Mail Marketing.
You want to make some money?
I can put you in touch with over 20 million people at virtually no cost.
Can you make one cent from each of theses names?
If you can you have a profit of over $200,000.00
That's right, I have over 20 Million Fresh email
addresses that I will sell for only $249. These are all
fresh addresses that include almost every English person
on the Internet today, with no duplications. They are
all sorted and ready to be mailed. That is the best
deal anywhere today!
Don't believe it? People are making that kind of
money right now by doing the same thing, that is
why you get so much email from people selling you
their product....it works!
These 20 Million email addresses are
yours to keep, so you can use them over and
over.
This offer is not for everyone. If you can not
see just how excellent the risk / reward ratio
in this offer is then there is nothing I can do
for you. To make money you must stop dreaming
and TAKE ACTION.
Over the past 2 years, we have gained a reputation for having the
cleanest, most responsive e-mail address lists in the industry.
No one has gone to the work it takes to produce an e-mail address
list of this quality.
Here's how we prepare our e-mail lists:
1. We clean and eliminate all duplicates.
2. Next, we use a filter list of 400+ words/phrases to clean even
more. No address with inappropriate or profane wording survives!
3. Then we use our private database of thousands of known
Internet "extremists", those opposed to any kind of commercial
e-mail, and kicked off every one we could find.
4. All domains were verified to insure they're valid.
5. And finally, we sorted the list into easy-to-manage packets of
20,000 addresses in simple text (.txt) format that will work with
any computer operating system.
******************************************
It is time to order!
Shipping is not an issue.
******FedEx next day world wide shipping included********
As soon as we receive payment we will FedEx your e-mail list via
CD straight to your door anywhere in the world FedEx next day guaranteed.
******International Orders Welcome*********
US funds paid via paypal.com welcomed
PayPal is now available in the following countries:
Australia
Austria
Belgium
Brazil
Canada
Denmark
France
Germany
Hong Kong
Ireland
Israel
Italy
Japan
Mexico
Netherlands
New Zealand
Norway
Portugal
Singapore
South Africa
South Korea
Spain
Sweden
Switzerland
United Kingdom
PayPal.com is very easy to sign up to. They accept wire transfers,
checks and credit cards from any of the countries listed above.
This payment process is in your own interest of safety. Paypal.com
processes all transactions and keeps all your personal information
secret. After signing up please send the U.S. equivalent of $249
to [EMAIL PROTECTED] last name Smith.
If there is another way you would like to pay please e-mail me
at [EMAIL PROTECTED] and I will get back to you.
*******Wondering how to send 20 million E-mails********
I will tell you how/where to download the softwhere you need for free
Please NOTE:
Congress shall make no law respecting an establishment of religion, or
prohibiting the free exercise thereof, or abridging the freedom of speech
or of the press; or the right of the people peaceably to assemble, and to
petition the Government for a redress of grievances.
Amendment I, The US Constitution
BlankAren't there any methods of spam sniffing that could be
incorporated into this mailer?
Dear [EMAIL PROTECTED],
5.5 cents/min. State to State calling, All Day, Every Day, No Fees!
- Commercial and residential.
- 4.5 cents/min. in-state for California!
- 5.5 cents/min. inbound service.
- Rates apply all day, every day.
- NO monthly fees, and NO minimums!
- 6 second billing increments!
- Great international rates!
- Direct billing available.
... and International Callback for residents outside the US.
For complete details, contact us at: [EMAIL PROTECTED]
Please type "info" in the subject line.
With the absence of any ADSI interface for PHP (and a COM implementation
that seems dodgy, at least for me and the others that have tried it), I'd
sort of given up thinking about using PHP for IIS manipulation and had
resigned myself to a fate of VBScript for anything I needed to do.
I'd noticed there's a DLL that comes with the latest distribs of PHP called
php_iisfunc.dll, which I'd always wondered what it did. Whilst looking at
the zend.com site today, I found a list of undocumented functions
(http://www.zend.com/phpfunc/nodoku.php), which makes reference to these
functions.
Because noone has done it yet (unless I've missed it) I thought I'd just
spam some quick information about some testing I did with them.
----------------
string iis_GetScriptMap(string id, string virtualPath, string extension)
Returns IIS script mappings for a site.
eg:
echo iis_GetScriptMap(iis_GetServerByComment("srvName"), "", ".asp");
returns:
.asp,F:\WINNT\System32\inetsrv\asp.dll,1,GET,HEAD,POST,TRACE
----------------
int iis_AddServer(string Path, string Comment, string ServerIP, int
ServerPort, string HostName, int ServerRights, int StartServer)
Adds a server to the IIS Metabase with the supplied parameters.
eg:
iis_AddServer("f:\\", "comment","130.102.1.1", 80,"hostname", 0,1);
Creates a new server with a hostheader name "hostname". Returns the Server
Instance ID for the created server.
----------------
int iis_GetServerByComment(string comment);
int iis_GetServerByPath(string path);
Returns the server instance ID for the server with the comment (ie, the name
that appears in MMC). This ID can then be passed to some of the other
functions (as done below).
eg:
iis_GetServerByComment("Default Web Site");
iis_GetServerByPath("f:\inetpub\wwwroot");
Returns:
Using 'Default Web Site' as the comment should return 1.
----------------
int iis_StopServer(int serverID);
Stops a particular server
eg:
iis_StopServer("Default Web Site");
Returns
1 on success, 0 on failure, I _think_ - however, I couldn't get this
function to work.
I'm not sure of the difference between this one and iis_StopService. I would
have thought StopService would stop the whole webservice, but it seems to
take a serverID parameter. Shrug.
----------------
int iis_StartServer(int serverID);
Starts a particular server
eg:
iis_StartServer("Default Web Site");
Returns
1 on success, 0 on failure, I _think_. That is, the function returned 1 on
one site that I'd stopped, and successfully restarted it. However, I
couldn't make it restart the 'Default Web Site', yet it still returned 1.
Shrug.
----------------
int iis_RemoveServer(int serverID);
eg:
iis_RemoveServer(iis_GetServerByComment("comment"));
Returns
1 on success, -602 on failure (if I made up a fake comment)
----------------
There are also the following, which return values that I didn't try to
figure out (laziness), and take a 2nd parameter (referred to in the source
as string VirtualPath) that I also didn't figure out (also laziness):
iis_getdirsecurity(iis_GetServerByComment("website"), "");
iis_GetServerRight(iis_GetServerByComment("website"), "");
iis_GetServiceState(iis_GetServerByComment("website"));
Sorry about the poor documentation, but its better than what is on the PHP
site :)
I'm not sure how stable/reliable these are. I had a quick look through the
source but I'm not familiar enough with the metabase functions that are used
to know whether or not its done in the most stable way. I know though that
I've had enough problems with metabase corruption on servers that have only
ever been administered through MMC to be wary when trying 3rd party products
to do a similar thing.
--dave
