Re: help please... session -> database

From: Date: Thu, 23 Aug 2001 12:39:52 +0000
Subject: Re: help please... session -> database
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-11713@lists.php.net to get a copy of this message
cheers andre i tried that too.. and while i can get it to work by extracting with stripslashes i was trying to enter the '.' itself .. when i see the entry in myphpadmin it is still a '@' thanks tho.. brendan Andre P. wrote:
Try $link = addslashed($HTTP_SESSION_VARS["HREF"]) and then use $link in the sql insert and.. stripslashes(query result) when you retrieve the value and need to display it on the page. hth andre brendan wrote:
hello, i have hit a major stumbling block and am now getting really frustrated.. if someone could point me in the right direction i would really appreciate it.. - i have a set of forms across a number of pages - the user enters data into each of the forms and these are placed in a session variable - at the completion of form entry the session variables are supposed to be passed to a mysql database - one of the variables is a URL for some reason the form entry the data is encoded so that a full stop '.' is changed into an AT '@' - I have tried urlencoding and decoding the session, using str_replace for the @ .. adding slashes - for some reason this just wont work .. ... help? ... i.e Adds form post to session if (is_array($HTTP_POST_VARS)) {
     while (list($var, $value) = each($HTTP_POST_VARS)) {
     session_register($var);
     $HTTP_SESSION_VARS[$var]=$value;
     }
    }
i.e adds session to database (simplified so as to find problem) $title =stripslashes($HTTP_SESSION_VARS["title"]); $href= $HTTP_SESSION_VARS["HREF"]; $fee =stripslashes($HTTP_SESSION_VARS["fee"]); $result= mysql_query("INSERT INTO links (Title, Hyperlink,fee) VALUES ('$title','$href','$fee')") or die(mysql_error());
                              print $result;


« previous php.db (#11713) next »