ruraldev Posted September 16, 2009 Share Posted September 16, 2009 Hi Hope someone can point me it the right direction with this query. I have a table of mysql query results on my page each of which is a link, how can I set a session variable depending on which link is chosen, each link has 2 fields, link_id and link_name, link_name is the visable item and link_id is the value I would like to set the variable to. Thanks Gordon Quote Link to comment https://forums.phpfreaks.com/topic/174485-session-variable-set-from-link-table/ Share on other sites More sharing options...
Hybride Posted September 16, 2009 Share Posted September 16, 2009 if(isset($link1)) { $_SESSION['var'] = $link_id1; } else { $_SESSION['var'] = $link_id2; } ? An if/else statement works; if it gets more complicated, you can do a switch/case. It'd help if there were code attached to see what you are trying to do. Quote Link to comment https://forums.phpfreaks.com/topic/174485-session-variable-set-from-link-table/#findComment-919658 Share on other sites More sharing options...
ruraldev Posted September 16, 2009 Author Share Posted September 16, 2009 Happy to add to code if it helps: <?php session_start(); require_once('Connections/cycle.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_Recordset1 = 25; $pageNum_Recordset1 = 0; if (isset($_GET['pageNum_Recordset1'])) { $pageNum_Recordset1 = $_GET['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $colname_Recordset1 = "-1"; if (isset($_SESSION['location'])) { $colname_Recordset1 = $_SESSION['location']; } mysql_select_db($database_cycle, $cycle); $query_Recordset1 = sprintf("SELECT route_id, route_name FROM route WHERE location_id = %s ORDER BY route_name ASC", GetSQLValueString($colname_Recordset1, "int")); $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $cycle) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); if (isset($_GET['totalRows_Recordset1'])) { $totalRows_Recordset1 = $_GET['totalRows_Recordset1']; } else { $all_Recordset1 = mysql_query($query_Recordset1); $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); } $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <p>Select a route or refine your criteria</p> <form id="form1" name="form1" method="post" action=""> <table border="1"> <tr> <td>route_id</td> <td>route_name</td> </tr> <?php do { ?> <tr> <td><?php echo $row_Recordset1['route_id']; ?></td> <td><a href="arearoutes.php?countrytabs=3"><?php echo $row_Recordset1['route_name']; ?></a></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table> </form> <p><?php echo $_SESSION['location']; ?> <?php $_SESSION['route'] = $row_Recordset1['route_id']; ?></p> </body> </html> <?php mysql_free_result($Recordset1); ?> Quote Link to comment https://forums.phpfreaks.com/topic/174485-session-variable-set-from-link-table/#findComment-919672 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.