#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    13
    Rep Power
    0
    hello,

    sorry if this is described in the FM, but i have been looking...

    does anyone store the html code in the MySQL database? i am trying to figure out a way to use his/her login information open up a personalized web page. in other words if jack logs in he sees jack's page, not sue's.

    thanks.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    You can but it's problemtic. Why not just store the URL of the page in the db?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    32
    Rep Power
    15
    Yeah.. i don't see why not? It's only text and chars you are entering.
    Just make sure that you use the addslashes() function to add those slashes in there before you add it into the database otherwise mysql will give you problems.
    Html codes has alot of " and ' that needs to be added slashes in front of it.

    addslashes($html_code);

    i hope that makes sense to you.... =)

    scoobydoo
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Den Laeghe Landen
    Posts
    107
    Rep Power
    15
    You sure can.
    But are these pages all the same layout/categories/items etc, except that Johns page shows Johns header, johns bookmarks, johns other nice data?

    In that case, you should create a table with all these data, and generate the pages with one script, and let it fill in all the user-specific data.

    Much better, much more powerful, much er!

    ------------------
    --
    ...tiktak...tiktak...
    --
    ...Tommyknockers, Knocking On Your Door...
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    13
    Rep Power
    0
    hello eYe,

    thanks for the input. this is where everyone seems to be pointing me.

    this method also opens up a neat door: i can create a script for our customers to add a new user. if they get a new customer that they want to add, they can go into this form and add the info. in doing this they effectively create a "new" web page.

    now if i can just figure out a way for them to ftp images to me via the admin script. any ideas?


    thanks.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Den Laeghe Landen
    Posts
    107
    Rep Power
    15
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by ted andersen:
    Hello Ted,
    is there a simple way to add the ability to ftp a file to me via the same script?
    [/quote]
    I've never used it, but PHP has some special tools to do this. Read the following part of the PHP-manual: http://www.php.net/manual/features.file-upload.php
    I think that should do it.

    Greetz,

    EyE



    ------------------
    --
    ...tiktak...tiktak...
    --
    ...Tommyknockers, Knocking On Your Door...

Similar Threads

  1. Connecting to mysql with just html code?
    By myrkrul in forum Beginner Programming
    Replies: 2
    Last Post: January 2nd, 2004, 07:05 PM
  2. perl cgi html mysql help please
    By homerjj in forum Perl Programming
    Replies: 4
    Last Post: December 30th, 2003, 09:09 AM
  3. edit mysql data from html
    By Vodau in forum PHP Development
    Replies: 3
    Last Post: June 27th, 2003, 10:26 AM
  4. MySQL manual in HTML Help (.chm) - complete conversion
    By powermcpet in forum MySQL Help
    Replies: 0
    Last Post: June 24th, 2003, 10:45 AM
  5. PHP form submitting html to MySQL
    By BahBah in forum PHP Development
    Replies: 1
    Last Post: February 1st, 2003, 10:54 AM

IMN logo majestic logo threadwatch logo seochat tools logo