Professional Web Applications Themes

Escaping nasty quotes - PHP Development

I have this: $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '" . '"' . "' "; $result = MYSQL_QUERY($query); PRINT "<br>$query2<br>"; The query doesn't take ... but if I cut and paste the printed response into the mysql server manually ... works like a charm :-(...

  1. #1

    Default Escaping nasty quotes

    I have this:

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
    TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";
    $result = MYSQL_QUERY($query);
    PRINT "<br>$query2<br>";

    The query doesn't take ... but if I cut and paste the printed response into
    the mysql server manually ... works like a charm

    :-(

    Roy W Guest

  2. #2

    Default Re: [PHP] Escaping nasty quotes

    --- Roy W <phpwiegmann.net> wrote:
    > The query doesn't take ... but if I cut and paste the printed
    > response into the mysql server manually ... works like a charm
    [url]http://www.php.net/addslashes[/url]

    Chris

    =====
    Become a better Web developer with the HTTP Developer's Handbook
    [url]http://httphandbook.org/[/url]
    Chris Shiflett Guest

  3. #3

    Default RE: [PHP] Escaping nasty quotes

    Thanks, Chris. But I kept what I had and then just added:

    $query = addslashes($query);

    Doesn't return an error.. But doesn't complete the task.

    :-(


    -----Original Message-----
    From: Chris Shiflett [mailto:shiflettphp.net]
    Sent: Thursday, July 31, 2003 12:39 PM
    To: Roy W; [email]php-generallists.php.net[/email]
    Subject: Re: [PHP] Escaping nasty quotes


    --- Roy W <phpwiegmann.net> wrote:
    > The query doesn't take ... but if I cut and paste the printed response
    > into the mysql server manually ... works like a charm
    http://www.php.net/addslashes

    Chris

    =====
    Become a better Web developer with the HTTP Developer's Handbook
    http://httphandbook.org/


    Roy W Guest

  4. #4

    Default RE: [PHP] Escaping nasty quotes

    > I have this:
    >
    > $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE
    > mytable FIELDS
    > TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";
    > $result = MYSQL_QUERY($query);
    > PRINT "<br>$query2<br>";
    >
    > The query doesn't take ... but if I cut and paste the printed
    > response into
    > the mysql server manually ... works like a charm
    What error do you get from mysql_error()? Are you uusing the same user in
    both shell and script? If not does the script user have the proper
    permissions?

    Jennifer Goodie Guest

  5. #5

    Default Re: [PHP] Escaping nasty quotes

    On Thu, 2003-07-31 at 14:31, Roy W wrote:
    > I have this:
    >
    > $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
    > TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";
    > $result = MYSQL_QUERY($query);
    > PRINT "<br>$query2<br>";
    >
    > The query doesn't take ... but if I cut and paste the printed response into
    > the mysql server manually ... works like a charm
    >
    > :-(
    Try this:

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ";

    It'll get rid of your p error

    Matt

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.2.1 (GNU/Linux)

    iD8DBQA/KXQNH+kNu8/qKOwRAg1OAJ4hL9e9/EZNKSMcS9bJQCqp+6hkAgCfcHpf
    BAzelxbB18OlAyPkRRR/RXs=
    =Cgk6
    -----END PGP SIGNATURE-----

    Matthew Vos Guest

  6. #6

    Default Re: Escaping nasty quotes

    > $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable FIELDS
    > TERMINATED BY ',' ENCLOSED BY '" . '"' . "' ";

    put a \ in front of all " that are not at the beginning or the end
    like this:

    $query = "LOAD DATA LOCAL INFILE '/home/data.txt' INTO TABLE mytable
    FIELDS TERMINATED BY ',' ENCLOSED BY '\" . '\"' . \"' ";

    PHP treats characters after a \ as special, such as \n inserts a line
    return \" inserts a ", and \\ inserts a \.

    Robert MacDonald
    Robert MacDonald Guest

Similar Threads

  1. Bug: Escaping of single-quotes in cfQuery !
    By Stefan K. in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: April 11th, 04:42 PM
  2. cfquery not escaping single quotes correctly
    By Gregd66 in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 17th, 10:18 PM
  3. MS Access driver not escaping single quotes?
    By DGH in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 16th, 09:06 PM
  4. [PHP] Escaping nasty quotes
    By Jay Blanchard in forum PHP Development
    Replies: 2
    Last Post: July 31st, 06:57 PM
  5. Escaping single quotes
    By in forum PHP Development
    Replies: 0
    Last Post: July 30th, 11:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139