Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5

Thread: Php insert

  1. #1
    New Coder
    Join Date
    Jan 2012
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Php insert

    I have recently moved hosting companies, my whole site works apart from one script, just a little form that adds text to MySQL but it has stopped working with large amounts of text? The new server uses the same php version? Any ideas?

  • #2
    New Coder
    Join Date
    Apr 2012
    Posts
    23
    Thanks
    3
    Thanked 1 Time in 1 Post
    have you checked your config file? (mysql login details)

    If you have changed servers, then it is likely you need to update your mysql login details

  • #3
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    Is the problem with your SQL only inserting partial or is it that PHP doesn't handle the input returning nothing?
    If its the SQL, ensure the datatype is large enough to contain the entire text. If its PHP, show your code, it could be related to use of deprecated functionality that's disabled by one host and not the other.

  • #4
    New Coder
    Join Date
    Jan 2012
    Posts
    27
    Thanks
    5
    Thanked 0 Times in 0 Posts
    it was magic quotes

  • #5
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    Quote Originally Posted by soupy1985 View Post
    it was magic quotes
    Yep deprecated functionality.
    Always assume that these are enabled, and make sure you remove the escape items as necessary.


  •  

    Posting Permissions

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