Problem with displaying inverted commas input into MYSQL database

Discussion in 'PHP' started by Titanite, May 31, 2006.

0
  1. #1
    Hello,

    I hope somebody can help me.

    My provider has recently changed the PHP version and apparently the php settings have been changed. The version number is 4.3.9.

    It used to be a later version: 4.3.11.

    I have a data entry page, a data update/changing page, and a public page which displays the data, and it was working fine.

    Now, whenever I enter in a field something within inverted commas (within apostrophe is fine), it will appear on the public page. No problem there.

    But when I access the data update page to change certain other details, anything AFTER the first inverted comma does not appear.

    I re-entered the data within inverted commas again, and then click on submit, the changes then appear on the public page.

    Hence my problem is "when my update page draws data from the mysql database, it deletes anything that is after an inverted comma".

    What should I do?

    Here is my php settings for magic quotes:
    magic_quotes_gpc On On
    magic_quotes_runtime Off Off
    magic_quotes_sybase Off Off

    Please help! :)
     
    Titanite, May 31, 2006 IP
  2. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #2
    And for newly entered date: "everything after the first inverted comma doesn't get entered".

    Start escaping strings with mysql_real_escape_string: http://uk.php.net/manual/en/function.mysql-real-escape-string.php
     
    T0PS3O, May 31, 2006 IP
  3. Titanite

    Titanite Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Hiya!

    Thanks for your reply!
    I have tried the quote_smart function:


    <p>
    <? echo quote_smart("$filename5")?>
    File 05:<br>
    <input name="ud_filename5" type="text" value="<? echo quote_smart("$filename5")?>" size="80"><br>

    URL 05:<br><input name="ud_filelink5" type="text" value="<? print "$filelink5"?>" size="80">
    </p>
    ​

    The result I got was:

    Presentation by Helen Penn on Providing for Children Under Three in England: The Difficulties of a Targeted "Approach" File 05:
    [Presentation by Helen Penn on Providing for Children Under Three in England: The Difficulties of a Targeted ]​

    --- [] being within the input box.
    Whatever I have done for stripping the text of slashes turned out beautifully in text, but when it comes to echoingit in input box, it didn't appear after the inverted commas.

    Perhaps someone can advise me further?
     
    Titanite, Jun 2, 2006 IP