Exactly repeating the quote will escape it.
But it is much better to not insert the values directly into the SQL
String but to bind them instead, as the DB (if Oracle or SQL Server or
whatever) does not have to parse the statement over and over again.
You also do not have to worry about repeating
php-windows Digest 6 Feb 2001 04:54:42 - 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
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 , 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
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_cust
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,
P
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
> us
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/we
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 scri
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+apostr
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 wo
Do I need to have anything special installed on the server (IIS) to call
excel and word with COM.
Ryan
--
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: [EM
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 a
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,
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
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
> 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, te
I tried with FALSE same error.
I also tried the following word example
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.
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
Visible = false; //line3
$worksheet = $excel_handle->workbooks->add(); //line4
$worksheet->Cells(1,1)->valu
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
Visible = false; //line3
$worksheet->Cells(1,1)->value = "Name"; //line4
$worksheet->SaveAs("temp.xls"); //line5
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 p
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
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
--
PHP Windows Mailing List (http://www.ph
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 assi
php-windows Digest 5 Feb 2001 12:57:24 - Issue 429
Topics (messages 5372 through 5383):
Re: File Uploading
5372 by: Alain Fontaine
5377 by: Per Nielsen
Re: forking processes
5373 by: Alain Fontaine
Re: php_imap4r2.dll not loaded ?!?! (win2k)
5374 by: Alain
Hi Paul, I would be happy if you could contact me when your script works. I
think I might need it too, and I would not mind if you can send me the
script and steps to take.
Thank you
Bikes
-Original Message-
From: Paul R. Edelkamp, Jr.
To: [EMAIL PROTECTED]
Sent: 2/4/01 7:57 AM
Subje
Try this site, they give a tutorial on encryption.
http://hotwired.lycos.com/webmonkey/programming/php/index.html
Hope it works for you.
> --
> From: Danilo Meles[SMTP:[EMAIL PROTECTED]]
> Reply To: Danilo Meles
> Sent: Monday, February 05, 2001 1:41 PM
> To: [EMAI
Hi there;
I have to encrypt a string into a cookie, how to do that??? Should a use
mcrypt function???
If yes how to put this function working in PHP???
Thank you all!!!
Danilo Meles
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional co
And it's not in the full php-4.0.4-Win32.zip distribution either. :(
I'm kinda desperate with this issue.
Eelco.
> Surely all you need to do is find the php_imap4r2.dll ? its
> probably in the
> large windows (~3mb) download ? Otherwise, just search for it on
> the net...
>
> Siggy
>
> - O
but the whole php_imap4r2.dll file does not exist in my entire system. It's
not a wonder it can't find it, is it?
Where can I get that file?
Anybody ...??
> Eelco,
>
> You don't need to compile anything yourself (unless you really want to) on
> Windows. Your problem is more related to an incorr
>
Berber-Guy,
I don't believe that there is any question today that apache [on ony platform],
is the best webserver you *can't* buy ;)
ingo baab
> > Guys,
> >
> > I don't believe that there is any question today that IIS5 on win2K
> > is the best webserver $$$ can buy.
> >
> > Sincerely
> >
> >
Hi Randall,
The code below should show you how to handle the file upload process (in
example a text file). I've kept the source as simple as possible. Place both
files in the same directory and the uploaded file should also appear there.
If you want to upload multiple files you will need to ha
Is this List for explaining trivial PHP-coding???
ingo baab
phobo schrieb:
> use the mysql functions. - see www.php.net/mysql.
> if you're on windows (i assume, since you're on this list), mysql functions
> are built in.
>
> in a nut shell :
>
> > $row = 1;
> > $fp = fopen ("test.txt","r");
>
>
32 matches
Mail list logo
