>-Ursprüngliche Nachricht-
>Von: AndrewJames [mailto:andrewhu...@gmail.com]
>Gesendet: Montag, 7. September 2009 13:37
>An: Skoric, Majk
>Betreff: Re: AW: mysql_real_escape_string()
Dont forget to put the list in!
>hmmm, my mysql_real... function call is below my db co
>-Ursprüngliche Nachricht-
>Von: AndrewJames [mailto:andrewhu...@gmail.com]
>Gesendet: Montag, 7. September 2009 11:39
>An: mysql@lists.mysql.com
>Betreff: mysql_real_escape_string()
>
>Hey guys,
>
>whenever i try to perform this function on my $variables
if (!is_numeric($value))
{
echo "just before->" . $value . "<-";
$value = mysql_real_escape_string($value);
echo "just after->" . $value . "<-";
}
return $value;
"bruce" <[EMAIL PROTECTED]> wrote on 09/22/2005 09:15:56 PM:
> hi...
>
> from the docs... it appears the the mysql_real_escape_string function
(from
> php) is used to backslash a set of chars in the string for insertion
into
> the mysql db...
>
> however,
bruce wrote:
from the docs... it appears the the mysql_real_escape_string function (from
php) is used to backslash a set of chars in the string for insertion into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was wondering if there's a
way to force it to use th
hi...
from the docs... it appears the the mysql_real_escape_string function (from
php) is used to backslash a set of chars in the string for insertion into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was wondering if there's a
way to force it to use th
At 23:58 -0400 10/9/04, leegold wrote:
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
At 23:18 -0400 10/9/04, leegold wrote:
>Seems like mysql_real_escape_string function is not working?
>mysql Ver 14.5 Distrib 4.1.3a-beta
leegold wrote:
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
At 23:18 -0400 10/9/04, leegold wrote:
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $origi
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
> At 23:18 -0400 10/9/04, leegold wrote:
> >Seems like mysql_real_escape_string function is not working?
> >mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
> >
>
At 23:18 -0400 10/9/04, leegold wrote:
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $originalstring ), "";
echo mysql_escape_string( $originalstring ), "";
echo
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $originalstring ), "";
echo mysql_escape_string( $originalstring ), "";
echo mysql_real_escape_string( $originalstring ), "
Hello
I'm getting a segmentation fault in the mysql function mysql_real_escape_string
and I don't have a clue why. What am I missing?
#include /* Headers for MySQL usage */
#include
#include
#include
// #define INSERT_STATEMENT "INSERT INTO patient (idno,first,last,medre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again
After further inspection of libmysql sources the conclusion is:
- - mysql_real_escape_string() uses MYSQL->charset field from the MYSQL
struct
- - this field is initilized in mysql_real_connect()
- - so after my connection times ou
because of "wait_timeout" setting).
When the connection is timed out, if I do mysql_real_escape_string() on it
what should happen ? Fail ? Crash ?
My question is does mysql_real_escape_string() really needs an active
connection every time its called or can it use data in "MYSQL*"
At 0:07 + 3/12/03, Lai Liu-yuan wrote:
Thanks for your reply.
But, what then is the role of mysql_real_query? In document, it says
"You must use mqsql_real_query for queries that contain binary data"?
That doesn't mean the data values don't need to be properly escaped.
What if you put a binar
Thanks for your reply.
But, what then is the role of mysql_real_query? In document, it says "You must use
mqsql_real_query for queries that contain binary data"?
-
Before posting, please check:
http://www.mysql.com/manual.php
At 23:05 + 3/11/03, Lai Liu-yuan wrote:
Hi, everyone.
I use blob to store image data in mysql. I use mysql_real_query to
store it, but did not use mysql_real_escape_string to process it
before hand.
Then I saw in the document that this is needed. But I am testing the
data stored by
Hi, everyone.
I use blob to store image data in mysql. I use mysql_real_query to store it, but did
not use mysql_real_escape_string to process it before hand.
Then I saw in the document that this is needed. But I am testing the data stored by
reading them out to do some processing, there seems
variable in the my.cnf/my.ini file. I
> prefer the latter:
mysql_real_escape_string ist a client_side function, so in this case there is
no communication between client and server (the charset information is stored
on the client side too (in mysql->charset)
PROTECTED]>
Sent: Wednesday, December 04, 2002 4:29 PM
Subject: question about mysql_real_escape_string()
> hi
>
> does this function handle a binary string of any length or is there some
> sort of max limit.
>
> when i load a binary file (filesize 49Kb) into a blob field, the
On 4 Dec 2002, at 17:29, Tom Roos wrote:
> when i load a binary file (filesize 49Kb) into a blob field, the function is
> ok but when the filesize is 1.8Mb, the function fails and my programs
> aborts.
There are two limits you should be concerned about. First a BLOB
field has a maximum size o
in this function.
if mysql_real_escape_string() has a max limit, how does one get around this?
could it be set in my.cnf, or somewhere else? or is this a case of bad
practise to load big (> 1Mb) into mysql?
tks
tom
_
Add photos
he function fails and my programs
> aborts. using the debugger, the program aborts when in this function.
>
> if mysql_real_escape_string() has a max limit, how does one get around
> this? could it be set in my.cnf, or somewhere else? or is this a case of
> bad practise to load big (&g
. using the debugger, the program aborts when
in this function.
if mysql_real_escape_string() has a max limit, how does one get
around this? could it be set in my.cnf, or somewhere else? or is
this a case of bad practise to load big (> 1Mb) into mysql?
tks
tom
Are you using the C API direc
On Fri, 14 Dec 2001, Ian Collins wrote:
>
> I am having difficulties with entering binary data from a c program.
> I have passed the string through mysql_real_escape_string.
Post the C data then. However read on.
>
> . . .
>
> drop table if exists junk5;
>
> create
(The following was done in mysql_4.0 alpha)
I am having difficulties with entering binary data from a c program.
I have passed the string through mysql_real_escape_string.
What I am seeing is that if the binary data contains an ascii 0, then
mysql_real_escape_string, correctly, translates it
ser string */
secure_user = malloc(strlen(user) * 2 + 1);
if ( secure_user == NULL ) {
_nss_mysql_log(LOG_ERR,"initgroups: not enough memory to escape the
user string");
*errnop = EAGAIN;
return NSS_STATUS_TRYAGAIN;
}
mysq
Hi,
I use the windows binary distribution from www.mysql.com (version 3.23.40).
When I try to use the function mysql_real_escape_string, the linker complains
about not finding it...
Solution is easy :-) Add the symbol to libmysql.def and recompile...
Cheers
Oliver
28 matches
Mail list logo