php-windows Digest 6 Feb 2001 04:54:42 -0000 Issue 430
Topics (messages 5384 through 5404):
Re: odbc/array
5384 by: Jello
ImageString and ImageLoadFont
5385 by: Martin Verstegen
Make good money online! It's easy ....
5386 by: NEWS!!
Re: [PHP-INST] php_imap4r2.dll not loaded ?!?! (win2k) [SOLVED]
5387 by: Eelco de Vries
COM and PHP
5388 by: Conover, Ryan
Revised [PHP] COM and PHP
5389 by: Conover, Ryan
5390 by: Conover, Ryan
5393 by: Pablo Vera
Re: [PHP] RE: [PHP-WIN] Revised [PHP] COM and PHP
5391 by: Sterling Hughes
Converting apostrophes for insertion into Oracle
5392 by: Asendorf, John
5394 by: Pablo Vera
5395 by: Asendorf, John
5397 by: Asendorf, John
5398 by: Christopher Derr
5401 by: Andrian Pervazov
5403 by: Pablo Vera
COM Question
5396 by: Conover, Ryan
Re: forking processes
5399 by: Jason Gan
Fatal Error?
5400 by: Corn Vollney-R7019C
5402 by: Pablo Vera
Includes in Xitami
5404 by: Ben Franske
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]
----------------------------------------------------------------------
sorry... new to this.....
the problem i have is using odbc (mysql can do this but the server i use is
only set for odbc at the moment).....
i have a DB which contains email addresses.... i can connect to the DB...
retrive the data and print the Email addresses to the browser....
i want to assign an increasing variable to each Email address for use later
in the script...
eg: $var(first number) = email addrees 1
$var(second number) = address 2 ... etc...
so i can update the DB and PHP does the rest( that's what it's for ??)
the script i tried is .....
<?php
// connect to system dsn odbc name login and password or die
$connect = odbc_connect("DB","login","password") or die (" not connected");
// create SQL statement
$sql = "SELECT Email FROM Table";
// prepare SQL statement
$sql_result = odbc_prepare($connect,$sql)
or die("Couldn't prepare query.");
// execute SQL statement and get results
odbc_execute($sql_result) or die("Couldn't execute statement.");
// set fields as total email addreses
$Fields = odbc_num_fields($sql_result);
while( odbc_fetch_row( $sql_result ))
{
$item1 = odbc_result( $sql_result, $Fields ); // the 1 could be "fieldname"
$item2 = odbc_result( $sql_result, $Fields );
print " item one is $item1 and item2 is $item2<br>";
}
odbc_free_result($sql_result);
odbc_close($connect);
?>
this just prints the results and there is where i get stuck... how do i add
an increasing variable to each address
any help or pointers welcome
Jello
""Jello"" <[EMAIL PROTECTED]> wrote in message
95jfbl$63d$[EMAIL PROTECTED]">news:95jfbl$63d$[EMAIL PROTECTED]...
> i use
>
> $Outer=0;
> while( odbc_fetch_row( $sql_result )){
> $Outer++;
> print "<tr>";
> for($i=1; $i <= $Fields; $i++){
> printf("<td>%s</td>", odbc_result( $sql_result, $i ));
> }
> print "</tr>";
> }
>
> which gets and prints the info from my DB.... how can i assign a variable
to
> each of the fields returned
>
> $var1 = row1 data
> $var2 = row2 data etc....
>
> like the mysql_fetch_array .... please help as this is driving me up the
> wall.
> Thanks
> Jeremy
>
>
>
> --
> 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]
>
Hi there,
I want to make my buttons on run-time. ImageString does the job. But I can
only use font 1 to 5. That are built-in fonts. Off course I want to use
another font. ImageLoadFont should do that job. But how??
Greetings,
Martin verstegen
2FIT
Please see the bottom of the message for the remove instuctions.
What you are about to read is tried, true, proven and effective. Above all, this
offer
is utterly and ridicously excellent!!
Have you ever tried or considered making money using the internet? Are you
marketing or promoting a business online? There is a lot of money to be made on the
internet and in reality, anyone can do it! Why not get your share? Read on and
weep with joy, if you would like to know exactly how to begin making money online
right away!
FREEDOM - Working on the internet allows you the freedom to work at home, or
wherever you keep a computer with an internet connection.
FLEXIBILITY - Work when you want, choose your own hours! No time clocks
here! Spend more time with your family, and supplement your current income.
Maybe even give up your day job.
There's definately more money to be made on the internet. In fact there are huge
amounts, but lets not get carried away. The secret is to have the right system, as
you
must have the right method for marketing and promoting your business. Of course
you will firstly need a money generating business, if you don't already have one. If
you need an online business, you will be referred to a reputable one if you read on.
Prepare to be amazed!
The following info and programmes would cost you in excess of $1000.00, if you
bought them singularly over your internet travels. Not to mention the time, and
painstakingly gruelling effort you are saved. It took me years to perfect, collect,
and
put together this system. Nowhere else will you find such a complete package.
Experienced marketers keep these secrets closely guarded from possible
competition.
METHOD - You must promote your business to as many people as you can. The
more exposure, the more money you will generate. Classified sites, FFA sites and
search engine submissions are all great to mess around with, but are not worth the
time that you put in. Replies, hits and sales from these advertising methods are
dismal
to say the least. Opt in lists are much the same. So many people use these methods,
that the chance of your sales ad being noticed are slim. The moment I discovered
bulk emailing my profits soared literally overnight. Bulk mailing reaches you your
target customers and reaches them quickly and efficiently.
Bulk mailing is the simplest way to get your advertisement seen by your target
audience. You could think of it as dropping thousands of flyers advertising your
business from an aeroplane over a city, some will be read and some will not. The law
of averages applies to bulk mailing, sales can be increased by a catchy sales ad or
decreased by a boring, uninspiring ad. Bulk mailing is wrongly frowned apon by a
section of the internet community. Bulk emailing is an amazing new way of advertising
and if gone about correctly you can avoid the hassles and achieve your aim - to
generate sales. There are the cowboy bulk emailers who send out huge amounts of
mail everyday, they do not give recipients the option to be removed from thier lists
and basically don't give a damn. These 'cowboys' are the cause of the bad press on
bulk mailing, they may make a lot of money in the short time they are mailing, but
they
never last long. Internet service providers will not stand for that kind of
behavior.
The methods I am about to outline to you here will have you profiting continuosly for
years to come, not just for a couple of days. You will not be sending out mail
blindly,
but in a sensible and controlled manner. If you are going to send out bulk email,
then
why not do it the right way to start with and save yourself and others a lot of
headaches. There are thousands upon thousands of people out there who are ready
and willing to respond to your ads and purchase your products. Get out there and be
seen, stand out from the crowd and reap the rewards. It is not as hard as you may
think! You must have a system to be successful and to work out the correct system
for you could take years of trial and error. There are not many successful marketers
out there who are willing to give away their secrets such as I have here!
To save you gruelling and lengthy task of learning to make money online, I have
outlined and supplied you with the complete, ready to go system. I fully guarantee
the system and the associated programmes. They will work for you!
First you will need the right business opportunity or product to sell. You can search
around for one yourself, but beware of scams. I will refer you to a great business
opp later in this message. You will need to write a killer ad that grabs peoples
attention, try different ads and gauge the responses.
To send bulk mail you need a reliable bulk mailing programme, I will refer you to a
great one later in this message. Once again, there are many different programmes
around and some are better than others. They can range in cost from free to
$3000.00. The free programmes that are around tend to be slow and unreliable, they
also blatantly expose your dialup ISP causing more trouble than they are worth. The
best solution is a low cost mailer which masks your dialup ISP and sends about 5000
emails per hour. I will refer you to the best bulk mail programme for your purposes
later in this message.
You need loads and loads of fresh (preferably targeted) email addresses to send your
ads to. No doubt you will find offers all over the place selling email lists. Do Not
buy these lists whatever you do. A great one I have seen is 1 000 000 email
addresses for $30.00. Most of these addresses are old and full of undeliverables. I
will tell you how to get your addresses later in this message.
POP 3 ADDRESS EXTRACTOR - The process of collecting addresses from
removal requests is a very lengthy and tedious job, nevertheless it must be done
religiously after every mailing. Personally, I've laboured through this task every
day
to compile my remove lists. After stumbling across a POP 3 extractor, things
instantly became so much easier. This simple programme runs from your desktop. It
logs into your POP 3 accessable email account and collects all email addressess from
all of the messages from your inbox and then saves them into a file. There is no
simpler way to collect your remove addresses! It even deletes the messages as it
goes, leaving your inbox nice and clean ready for your next mailing. This programme
saves you countless hours and lets you spend more time on other tasks. POP 3
Extractor normally sells for over $50.00, but not anymore!
You will need a list management programme. These programmes are designed
specifically for bulk mail lists. They allow you to manage, organise, clean removes,
and save your lists. Your removes can be easily stored and new lists can be purged
of these unwanted addresses. They are worth there weight in gold! read on!
You will need a web space. You should never link directly to your business URL
from your email ad. Some people like to complain to the webhost of the business
that you are bulk mailing, and try to have you booted off. To prevent this happening,
get yourself some free webspace. Design a simple page linking to your product or
business URL. It's very easy to set up a webpage, as most hosts offer design
wizards to guide you through. If you get kicked off your free website, simply sign up
for another. Link to your free webspace from your intial email ad. To find a free
website, go to www.freewebspace.net, or find your own through an engine search. If
you prefer you can ask the reader to reply to your ad with a request for "more info"
instead of sending them to another website. You can then direct them to your
business site directly, as you have proof of their request.
You need a "throw away" dial up ISP (Internet service provider). There are people
out there, who will check your emails properties to find out who your ISP is. They
will then complain to your ISP which could result in the closure of your account. You
should try to keep your mailings to a maximum of
10 000 per day. You can send more if you wish, but your internet service provider
may not like it too much and at the worst may close your account. This occasionally
happens, so it makes sense to have a disposable account to use for your bulk mailing.
Then if it becomes shut down, you still have your main everyday account. Simply
sign up for another throw away account, and continue on your merry way.
Using the above methods, you will see results right away. Your degree of success
depends on the grab of your ad and your product. It took me a couple of years to
learn and perfect these methods, it will take you a lot less after reading this
information. Even if you are a beginner, you will see results right away. There is
no
need to rush into it, take your time and set everything up properly. Things will run
much more smoothly if you plan ahead. If you fail to plan, you plan to fail!
I have put together for you a package which includes all of the programmes you will
need to start and run your marketing campaign. The programme package is called
Jumpstart Kit 2001. The value of the kit is in excess of $1000.00, but all I'm
asking is a mere $59.00. I am only offering the kit for a short time at this price,
the
price will go up to $180.00 again next month. Now is a great opportunity for you to
purchase these excellent programmes at such a unheard of price.
JUMPSTART KIT 2001 INCLUDES -
Business opportunity
http://www.goingplatinum.com/member/buckeroo
Bulk mailing programme
Incredible new programme for mailing out your ads. Usually costs well over $200.
This mailer actually hides your ISP's details from grumpy people who might want to
complain. Sends mail incredibly fast compared to other mailers, it utilises your
modem's full potential. If you can think of your modem as an eight lane highway for a
moment. Conventional mailing programmes will only send mail down one of these
lanes. This mailer actually uses all eight lanes, sending your mail a lot faster and
more efficiently.
Email Addresses
I will supply you with 50 000 fresh, targeted and unused email addresses to get you
off on the right foot.
Email address collecting programme
Fresh email addresses will not be far away with this programme in your arsenal.
Simply type in a keyword and sit back and watch your addresses roll in. You will
have an endless supply of addresses whenever you require them.
Pop 3 extractor programme
This programme will log onto your email account and collect addresses to place into
your remove database. Very easy to use and also very essential.
List manager
List manager is required to keep your email lists in order. This programme can
breakup large lists into any size. Your remove database is kept here and all new
email lists can be purged before they are sent to.
All of the above programmes come with detailed instructions and full technical
support 24 hours a day 7 days a week. I would be surprised if you found even one
of these programmes alone selling for $59.00.
To order now and take advantage of this unbeatable offer, simply follow this link to
make your secure online payment. The programmes will be emailed to you within 12
hours of your order.
http://www.geocities.com/starterkit2000au/JUMPSTART.html
This message was posted as you have visited my site or requested
information from me at
some time. To unsubscribe from any possible future mailing, send an
email to
[EMAIL PROTECTED] with "unsubscribe" as the subject
Problem solved ..
For reference:
I'm using Omni 2.07 webserver that installed PHP 4.01 as part of the
webserver. But the php.ini file is not of the same version (or something).
The IMAP extension in the php.ini file refers to php_imap4r2.dll while it's
not part of that distribution. However the php_imap.dll that _does_ come
with that version didn't seem to work somehow. Omni's fault, I guess. :|
I installed the full 4.04 and used its php.ini file, uncommented the IMAP
extension and it's working.
Eelco.
> Hello,
>
> I'm trying to use some POP3 functions and the manual states I
> would need to
> use the IMAP functions.
> So I uncommented the ";extension=php_imap4r2.dll" line in my
> "c:\winnt\php.ini" file. But it gave me the following error:
>
> "Unable to load dynamic library './php_imap4r2.dll' - The specified module
> could not be found".
>
> I read I needed the download install the "imap-4.5.tar" module. The README
> file has only instructions how to "make" it for UNIX. The default
> "MakeFile"
> is for UNIX. So I tried to clown around and rename "MakeFile.nt" to
> "MakeFile" and make it. But I only get errors:
>
> Could Not Find D:\temp\imap-4.5\c-client\LINKAGE.*
> NMAKE : fatal error U1077: 'C:\WINNT\system32\cmd.exe' : return code '0x1'
> Stop.
> NMAKE : fatal error U1077: 'C:\WINNT\system32\cmd.exe' : return code '0x2'
> Stop.
>
>
> I also tried this with the "MakeFile.ntk" (don't know what ntk
> stands for),
> but no fix.
> Can anybody help me with this problem?
>
> Regards;
> Eelco.
>
>
>
>
> --
> PHP Install 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]
>
>
I have been trying the following example from the PHP developer's cookbook
and it keeps giving me the following error.
Parse error: parse error in c:\Inetpub\wwwroot/temp.php on line 4
<? //line 1
$excel_handle = new COM("excel.application"); //line2
$excel_handle->Visible = false; //line3
$worksheet->Cells(1,1)->value = "Name"; //line4
$worksheet->SaveAs("temp.xls"); //line5
$excel_handle->quit(); //line6
//line7
?> //line8
Anyone that has Com and PHP experience help please
Ryan
I have been trying the following example from the PHP developer's cookbook
and it keeps giving me the following error.
Parse error: parse error in c:\Inetpub\wwwroot/temp.php on line 5
<? //line 1
$excel_handle = new COM("excel.application"); //line2
$excel_handle->Visible = false; //line3
$worksheet = $excel_handle->workbooks->add(); //line4
$worksheet->Cells(1,1)->value = "Name"; //line5
$worksheet->SaveAs("temp.xls"); //line6
$excel_handle->quit(); //line7
//line8
?> //line9
Anyone that has Com and PHP experience help please
Ryan
I tried with FALSE same error.
I also tried the following word example
<?
$word = new COM("word.application") or die("Unable to instanciate Word");
print "Loaded Word, version {$word->Version}\n";
$word->Visible = 0;
$word->Documents->Add();
$word->Selection->TypeText("Testing, testing... 1,2,3");
$word->Documents[1]->SaveAs("Some.doc");
$word->Quit();
?>
I get the following error
Loaded Word, version 9.0
Warning: Invoke() failed: No description available in
c:\Inetpub\wwwroot/temp2.php on line 5
Warning: Invoke() failed: Exception occurred. in
c:\Inetpub\wwwroot/temp2.php on line 7
Ryan
-----Original Message-----
From: Andris Jancevskis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 3:01 PM
To: Conover, Ryan
Subject: Re: [PHP-WIN] Revised [PHP] COM and PHP
Try "FALSE" instead of "false"
Andris
mailto:[EMAIL PROTECTED]
+---------------------------
Monday, February 05, 2001, 10:05:24 PM, you wrote:
> I have been trying the following example from the PHP developer's cookbook
> and it keeps giving me the following error.
> Parse error: parse error in c:\Inetpub\wwwroot/temp.php on line 5
> <? //line 1
> $excel_handle = new COM("excel.application"); //line2
$excel_handle->>Visible = false; //line3
> $worksheet = $excel_handle->workbooks->add(); //line4
$worksheet->>Cells(1,1)->value = "Name"; //line5
$worksheet->>SaveAs("temp.xls"); //line6
$excel_handle->>quit(); //line7
> //line8
?>> //line9
> Anyone that has Com and PHP experience help please
> Ryan
Ryan:
Just a thought, try using square brackets on the offending line:
$worksheet->Cells[1,1]->value = "Name"; //line5
Saludos,
Pablo
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Monday, February 05, 2001, 2:05:24 PM, Ryan wrote:
CR> I have been trying the following example from the PHP developer's cookbook
CR> and it keeps giving me the following error.
CR> Parse error: parse error in c:\Inetpub\wwwroot/temp.php on line 5
CR> <? //line 1
CR> $excel_handle = new COM("excel.application"); //line2
$excel_handle->>Visible = false; //line3
CR> $worksheet = $excel_handle->workbooks->add(); //line4
$worksheet->>Cells(1,1)->value = "Name"; //line5
$worksheet->>SaveAs("temp.xls"); //line6
$excel_handle->>quit(); //line7
CR> //line8
?>> //line9
CR> Anyone that has Com and PHP experience help please
CR> Ryan
> I tried with FALSE same error.
>
> I also tried the following word example
>
> <?
> $word = new COM("word.application") or die("Unable to instanciate Word");
> print "Loaded Word, version {$word->Version}\n";
> $word->Visible = 0;
> $word->Documents->Add();
> $word->Selection->TypeText("Testing, testing... 1,2,3");
> $word->Documents[1]->SaveAs("Some.doc");
> $word->Quit();
> ?>
>
> I get the following error
>
> Loaded Word, version 9.0
> Warning: Invoke() failed: No description available in
> c:\Inetpub\wwwroot/temp2.php on line 5
>
> Warning: Invoke() failed: Exception occurred. in
> c:\Inetpub\wwwroot/temp2.php on line 7
>
That means that you don't have the com component installed on your machine
correctly...
>
>
>
> > I have been trying the following example from the PHP developer's
cookbook
> > and it keeps giving me the following error.
>
> > Parse error: parse error in c:\Inetpub\wwwroot/temp.php on line 5
> > <? file://line 1
> > $excel_handle = new COM("excel.application"); file://line2
> $excel_handle->>Visible = false; file://line3
> > $worksheet = $excel_handle->workbooks->add(); file://line4
> $worksheet->>Cells(1,1)->value = "Name"; file://line5
This should be:
$cell = $worksheet->Cells(1, 1);
$cell->value = 1;
And it should work..
I've got a web form that might have someone entering apostrophes.
Unfortunately, my SQL statement has apostrophes in it and it seems to be
messing it up...
Any suggestions other than a regex (which I could do myself)?
John
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
The benefit to the government of replacing all $1 Federal Reserve notes with
$1 coins would be $522.2 million per year, according to estimates of the
General Accouting Office released on April 7, 2000.
John:
When you say that your SQL statement has apostrophes, you mean single
quotes enclosing a string value ?, if this is the case, why not try
changing the single quotes in your SQL for double quotes.
Saludos,
Pablo
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Monday, February 05, 2001, 3:03:21 PM, John wrote:
AJ> I've got a web form that might have someone entering apostrophes.
AJ> Unfortunately, my SQL statement has apostrophes in it and it seems to be
AJ> messing it up...
AJ> Any suggestions other than a regex (which I could do myself)?
AJ> John
AJ> ---------------------
AJ> John Asendorf - [EMAIL PROTECTED]
AJ> Web Applications Developer
AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
AJ> Licking County, Ohio, USA
AJ> 740-349-3631
AJ> The benefit to the government of replacing all $1 Federal Reserve notes with
AJ> $1 coins would be $522.2 million per year, according to estimates of the
AJ> General Accouting Office released on April 7, 2000.
Hi Pablo
To answer your question, yes... It doesn't seem to like that because the
field can be empty... for some reason Oracle won't allow you to have an
empty field enclosed by two "'s... ORA-01741: illegal zero-length
identifier
John
> John:
>
> When you say that your SQL statement has apostrophes, you mean single
> quotes enclosing a string value ?, if this is the case, why not try
> changing the single quotes in your SQL for double quotes.
>
> Saludos,
> Pablo
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
> Monday, February 05, 2001, 3:03:21 PM, John wrote:
>
> AJ> I've got a web form that might have someone entering apostrophes.
> AJ> Unfortunately, my SQL statement has apostrophes in it and
> it seems to be
> AJ> messing it up...
>
> AJ> Any suggestions other than a regex (which I could do myself)?
>
> AJ> John
>
> AJ> ---------------------
> AJ> John Asendorf - [EMAIL PROTECTED]
> AJ> Web Applications Developer
> AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> AJ> Licking County, Ohio, USA
> AJ> 740-349-3631
>
> AJ> The benefit to the government of replacing all $1 Federal
> Reserve notes with
> AJ> $1 coins would be $522.2 million per year, according to
> estimates of the
> AJ> General Accouting Office released on April 7, 2000.
>
>
>
> --
> 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]
>
The error comes up when you have something like this
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
VALUES("$Max_ID", "$SHORT_NAME")
and $SHORT_NAME is empty so the SQL looks like this
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002",
"") //doesn't work
If I use the single quote or apostrophe, it works fine....
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002',
'') //works fine
> -----Original Message-----
> From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 4:39 PM
> To: Asendorf, John
> Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> into Oracle
>
>
> That seams to be related to the name of the attribute(?)
> (filed), not the
> content of the attribute (filed). Or do I misinterpret the
> error message?
>
> >-----Original Message-----
> >From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, February 05, 2001 10:21 PM
> >To: Pablo Vera; Php-Windows (E-mail)
> >Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> into Oracle
> >
> >
> >Hi Pablo
> >
> >To answer your question, yes... It doesn't seem to like that
> >because the
> >field can be empty... for some reason Oracle won't allow you
> >to have an
> >empty field enclosed by two "'s... ORA-01741: illegal zero-length
> >identifier
> >
> >John
> >
> >> John:
> >>
> >> When you say that your SQL statement has apostrophes, you
> mean single
> >> quotes enclosing a string value ?, if this is the case, why not try
> >> changing the single quotes in your SQL for double quotes.
> >>
> >> Saludos,
> >> Pablo
> >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> >>
> >> Monday, February 05, 2001, 3:03:21 PM, John wrote:
> >>
> >> AJ> I've got a web form that might have someone entering
> apostrophes.
> >> AJ> Unfortunately, my SQL statement has apostrophes in it and
> >> it seems to be
> >> AJ> messing it up...
> >>
> >> AJ> Any suggestions other than a regex (which I could do myself)?
> >>
> >> AJ> John
> >>
> >> AJ> ---------------------
> >> AJ> John Asendorf - [EMAIL PROTECTED]
> >> AJ> Web Applications Developer
> >> AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> >> AJ> Licking County, Ohio, USA
> >> AJ> 740-349-3631
> >>
> >> AJ> The benefit to the government of replacing all $1 Federal
> >> Reserve notes with
> >> AJ> $1 coins would be $522.2 million per year, according to
> >> estimates of the
> >> AJ> General Accouting Office released on April 7, 2000.
> >>
> >>
> >>
> >> --
> >> 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]
> >
>
I'm working on this same issue with my, don't laugh, Access 97 backend. When
users enter apostrophes into the field, it chokes on them. I've been using
urlencode and urldecode and that converts everything happily but makes looking
directly at the database entries painful:
Let%5C%27s+test+apostrophes
is actually Let's test apostrophes. Urldecode works it out on the web end.
I would imagine there are scripts to get the apostrophe's out, but magic_quotes
(from the PHP.ini file) and addslashes doesn't seem to do the trick...
Chris
"Asendorf, John" wrote:
> The error comes up when you have something like this
>
> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
> VALUES("$Max_ID", "$SHORT_NAME")
>
> and $SHORT_NAME is empty so the SQL looks like this
>
> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002",
> "") //doesn't work
>
> If I use the single quote or apostrophe, it works fine....
>
> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002',
> '') //works fine
>
> > -----Original Message-----
> > From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, February 05, 2001 4:39 PM
> > To: Asendorf, John
> > Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> > into Oracle
> >
> >
> > That seams to be related to the name of the attribute(?)
> > (filed), not the
> > content of the attribute (filed). Or do I misinterpret the
> > error message?
> >
> > >-----Original Message-----
> > >From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > >Sent: Monday, February 05, 2001 10:21 PM
> > >To: Pablo Vera; Php-Windows (E-mail)
> > >Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> > into Oracle
> > >
> > >
> > >Hi Pablo
> > >
> > >To answer your question, yes... It doesn't seem to like that
> > >because the
> > >field can be empty... for some reason Oracle won't allow you
> > >to have an
> > >empty field enclosed by two "'s... ORA-01741: illegal zero-length
> > >identifier
> > >
> > >John
> > >
> > >> John:
> > >>
> > >> When you say that your SQL statement has apostrophes, you
> > mean single
> > >> quotes enclosing a string value ?, if this is the case, why not try
> > >> changing the single quotes in your SQL for double quotes.
> > >>
> > >> Saludos,
> > >> Pablo
> > >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> > >>
> > >> Monday, February 05, 2001, 3:03:21 PM, John wrote:
> > >>
> > >> AJ> I've got a web form that might have someone entering
> > apostrophes.
> > >> AJ> Unfortunately, my SQL statement has apostrophes in it and
> > >> it seems to be
> > >> AJ> messing it up...
> > >>
> > >> AJ> Any suggestions other than a regex (which I could do myself)?
> > >>
> > >> AJ> John
> > >>
> > >> AJ> ---------------------
> > >> AJ> John Asendorf - [EMAIL PROTECTED]
> > >> AJ> Web Applications Developer
> > >> AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> > >> AJ> Licking County, Ohio, USA
> > >> AJ> 740-349-3631
> > >>
> > >> AJ> The benefit to the government of replacing all $1 Federal
> > >> Reserve notes with
> > >> AJ> $1 coins would be $522.2 million per year, according to
> > >> estimates of the
> > >> AJ> General Accouting Office released on April 7, 2000.
> > >>
> > >>
> > >>
> > >> --
> > >> 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]
> > >
> >
>
> --
> 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]
For SQLServer and Oracle, the single quote is escaped by simply
repeating it. You can dio it by hand, but I believe this is what the
sybase magic quotes directive does as well.
Andrian
Christopher Derr wrote:
>
> I'm working on this same issue with my, don't laugh, Access 97 backend. When
> users enter apostrophes into the field, it chokes on them. I've been using
> urlencode and urldecode and that converts everything happily but makes looking
> directly at the database entries painful:
>
> Let%5C%27s+test+apostrophes
>
> is actually Let's test apostrophes. Urldecode works it out on the web end.
>
> I would imagine there are scripts to get the apostrophe's out, but magic_quotes
> (from the PHP.ini file) and addslashes doesn't seem to do the trick...
>
> Chris
>
> "Asendorf, John" wrote:
>
> > The error comes up when you have something like this
> >
> > INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
> > VALUES("$Max_ID", "$SHORT_NAME")
> >
> > and $SHORT_NAME is empty so the SQL looks like this
> >
> > INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002",
> > "") //doesn't work
> >
> > If I use the single quote or apostrophe, it works fine....
> >
> > INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002',
> > '') //works fine
> >
> > > -----Original Message-----
> > > From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, February 05, 2001 4:39 PM
> > > To: Asendorf, John
> > > Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> > > into Oracle
> > >
> > >
> > > That seams to be related to the name of the attribute(?)
> > > (filed), not the
> > > content of the attribute (filed). Or do I misinterpret the
> > > error message?
> > >
> > > >-----Original Message-----
> > > >From: Asendorf, John [mailto:[EMAIL PROTECTED]]
> > > >Sent: Monday, February 05, 2001 10:21 PM
> > > >To: Pablo Vera; Php-Windows (E-mail)
> > > >Subject: RE: [PHP-WIN] Converting apostrophes for insertion
> > > into Oracle
> > > >
> > > >
> > > >Hi Pablo
> > > >
> > > >To answer your question, yes... It doesn't seem to like that
> > > >because the
> > > >field can be empty... for some reason Oracle won't allow you
> > > >to have an
> > > >empty field enclosed by two "'s... ORA-01741: illegal zero-length
> > > >identifier
> > > >
> > > >John
> > > >
> > > >> John:
> > > >>
> > > >> When you say that your SQL statement has apostrophes, you
> > > mean single
> > > >> quotes enclosing a string value ?, if this is the case, why not try
> > > >> changing the single quotes in your SQL for double quotes.
> > > >>
> > > >> Saludos,
> > > >> Pablo
> > > >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> > > >>
> > > >> Monday, February 05, 2001, 3:03:21 PM, John wrote:
> > > >>
> > > >> AJ> I've got a web form that might have someone entering
> > > apostrophes.
> > > >> AJ> Unfortunately, my SQL statement has apostrophes in it and
> > > >> it seems to be
> > > >> AJ> messing it up...
> > > >>
> > > >> AJ> Any suggestions other than a regex (which I could do myself)?
> > > >>
> > > >> AJ> John
> > > >>
> > > >> AJ> ---------------------
> > > >> AJ> John Asendorf - [EMAIL PROTECTED]
> > > >> AJ> Web Applications Developer
> > > >> AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
> > > >> AJ> Licking County, Ohio, USA
> > > >> AJ> 740-349-3631
> > > >>
> > > >> AJ> The benefit to the government of replacing all $1 Federal
> > > >> Reserve notes with
> > > >> AJ> $1 coins would be $522.2 million per year, according to
> > > >> estimates of the
> > > >> AJ> General Accouting Office released on April 7, 2000.
> > > >>
> > > >>
> > > >>
> > > >> --
> > > >> 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]
> > > >
> > >
> >
> > --
> > 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]
John:
You could do something like this (I'm not sure if this will work):
if (!isset($SHORT_NAME) || $SHORT_NAME=="") {
$SQL="
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
VALUES(\"$Max_ID\", null)
";
} else {
$SQL="
INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
VALUES(\"$Max_ID\", \"$SHORT_NAME\")
";
}
Saludos,
Pablo
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Monday, February 05, 2001, 3:42:12 PM, John wrote:
AJ> The error comes up when you have something like this
AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME)
AJ> VALUES("$Max_ID", "$SHORT_NAME")
AJ> and $SHORT_NAME is empty so the SQL looks like this
AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES("20002",
AJ> "") //doesn't work
AJ> If I use the single quote or apostrophe, it works fine....
AJ> INSERT into cfull2.tbl_dl_customers (CUSTID_NUM, SHORT_NAME) VALUES('20002',
AJ> '') //works fine
>> -----Original Message-----
>> From: Svensson, B.A.T. [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, February 05, 2001 4:39 PM
>> To: Asendorf, John
>> Subject: RE: [PHP-WIN] Converting apostrophes for insertion
>> into Oracle
>>
>>
>> That seams to be related to the name of the attribute(?)
>> (filed), not the
>> content of the attribute (filed). Or do I misinterpret the
>> error message?
>>
>> >-----Original Message-----
>> >From: Asendorf, John [mailto:[EMAIL PROTECTED]]
>> >Sent: Monday, February 05, 2001 10:21 PM
>> >To: Pablo Vera; Php-Windows (E-mail)
>> >Subject: RE: [PHP-WIN] Converting apostrophes for insertion
>> into Oracle
>> >
>> >
>> >Hi Pablo
>> >
>> >To answer your question, yes... It doesn't seem to like that
>> >because the
>> >field can be empty... for some reason Oracle won't allow you
>> >to have an
>> >empty field enclosed by two "'s... ORA-01741: illegal zero-length
>> >identifier
>> >
>> >John
>> >
>> >> John:
>> >>
>> >> When you say that your SQL statement has apostrophes, you
>> mean single
>> >> quotes enclosing a string value ?, if this is the case, why not try
>> >> changing the single quotes in your SQL for double quotes.
>> >>
>> >> Saludos,
>> >> Pablo
>> >> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>> >>
>> >> Monday, February 05, 2001, 3:03:21 PM, John wrote:
>> >>
>> >> AJ> I've got a web form that might have someone entering
>> apostrophes.
>> >> AJ> Unfortunately, my SQL statement has apostrophes in it and
>> >> it seems to be
>> >> AJ> messing it up...
>> >>
>> >> AJ> Any suggestions other than a regex (which I could do myself)?
>> >>
>> >> AJ> John
>> >>
>> >> AJ> ---------------------
>> >> AJ> John Asendorf - [EMAIL PROTECTED]
>> >> AJ> Web Applications Developer
>> >> AJ> http://www.lcounty.com - NEW FEATURES ADDED DAILY!
>> >> AJ> Licking County, Ohio, USA
>> >> AJ> 740-349-3631
>> >>
>> >> AJ> The benefit to the government of replacing all $1 Federal
>> >> Reserve notes with
>> >> AJ> $1 coins would be $522.2 million per year, according to
>> >> estimates of the
>> >> AJ> General Accouting Office released on April 7, 2000.
>> >>
>> >>
>> >>
>> >> --
>> >> 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]
>> >
>>
Do I need to have anything special installed on the server (IIS) to call
excel and word with COM.
Ryan
Your pages are dynamic instead of static HTML, which imposes a bit of time
to generate.
Email sending in PHP doesn't actually take much time, as it doesn't actually
"send email", but queues the message for the email server to do the actual
sending. If you are experiencing slowness, your email script might be
complex in code and therefore it would take time to interpret the script.
For high performance, you could try compiled, rather than interpreted
languages. Your form could action a Java servlet which would run in its
process.
-----Original Message-----
From: Alain Fontaine [mailto:[EMAIL PROTECTED]]
Sent: Monday, 5 February 2001 6:36 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] forking processes
Jason,
I have recently read about another quite useful way to do what you want:
create a separate php script file the purpose of which is to do the actual
mail sending. From your main PHP script on the website, use system() [see
documentation] to call that script and let that script process the mail
sending in the background. Your user won't have any feedback about the mail
sending process, but you could design a system that logs the process
information to a file or database, and display that information once the
sending is done.
"Jason Hoover" <[EMAIL PROTECTED]> a écrit dans le message news:
[EMAIL PROTECTED]
> I have a form that launches an e-mail message to numerous people as
> determined by the user filling out the form (user picks people from select
> lists...e-mail addresses are kept in database,etc..).
>
> When the form is submitted the user is forced to wait until the script
that
> launches the e-mails finishes it's job, before he/she is redirected to
> another page in the application.
>
> Question: Is there a way to launch this e-mail script as a separate
> process, so the user isn't forced to wait through this script before being
> redirected.? I know in Java you can do this, but is is possible in
> Interpreted languages?
>
>
> Jason Hoover
> Web Application Programmer
>
> Entolo
> 2299 Territorial Road
> St. Paul, MN 55114
> Phone: 763.847.8022
> Fax: 763.642.1600
> [EMAIL PROTECTED]
> www.entolo.com
>
>
> --
> 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]
>
Hello All,
I have just set up PHP3.0 on a linux box w/ Apache. User rights are correct
and php works with a simple test script but I keep getting this error when
using a script to insert form data into a mysql db,
Fatal error: Call to unsupported or undefined function mysql_connect() in
/home/webauthor/www2.1/GURApplications/msrp/scripts/inputprocess.php3 on
line 30
I tried reloading the packages but nada. Any ideas?
Thanks,
Voll
Corn:
You are talking about PHP 3 and MySQL support is not built in, so
you need to load the MySQL extension dll. Go to php.ini, under
[extensions] and uncomment the line that makes reference to the MySQL
extension. Also be sure to have your extensions_dir setting correctly
defined.
Saludos,
Pablo
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Monday, February 05, 2001, 4:38:51 PM, Corn wrote:
CVR> Hello All,
CVR> I have just set up PHP3.0 on a linux box w/ Apache. User rights are correct
CVR> and php works with a simple test script but I keep getting this error when
CVR> using a script to insert form data into a mysql db,
CVR> Fatal error: Call to unsupported or undefined function mysql_connect() in
CVR> /home/webauthor/www2.1/GURApplications/msrp/scripts/inputprocess.php3 on
CVR> line 30
CVR> I tried reloading the packages but nada. Any ideas?
CVR> Thanks,
CVR> Voll
Hey everyone! I'm a Xitami/PHP4.0 user. My problems started when I moved
from CGI scripts to PHP. I really like PHP, but I have one little problem.
When I use PHP includes <? include ("filename.txt"); ?>, in a filename.php
script it doesn't reload the file if I made changes to it . For example, my
index.php file includes a file called menu.txt which is a file that
contains my page menu. If I make a change to menu.txt (but not to
index.php) and then click reload in my browser the changes don't show up.
Only when I clear my browser cache and then reload the page do the changes
show up. It becomes even more of a problem with my php news script, if I
add or delete a user, I have to flush my browser's cache to see the new
user profile. I tried the same exact scripts on an apache/linux server and
they didn't have this problem. A friend of mine with xitami had the same
problem I do. I'm not really sure what I can do about this, I really like
PHP but this is really kind of a large problem. Any help would be
appreciated, thanks. After pouring over all sorts of sites, pages and
trying all sorts of things I believe that the problem lies in some odd
setting for php, any suggestions would be appreciated
Ben Franske
Ben Franske
Master Technical Wizard
http://www.franske.cjb.net
AOL Instant Messenger: BenFranske
-----------------------------------------------------------
Founder, CEO, Owner, President Ben Franske Enterprises
Master Technical Wizard, Edina High School http://edina.k12.mn.us/edinahigh
Technical Producer, Edina High School Theater
Director Of Tech Edina High School Choir Department
http://www.edina.k12.mn.us/edinahigh/choralmusic/
Director Of Tech Edina High School Orchestra Department
Director Of Tech Edina High School Band Department http://www.edinabands.com/
