Jump to content

Ralph

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by Ralph

  1. <?php // SET variables $servername = ******* your server $username = ******* your user name $password = ******* your password $database = ******* your database $table = ******* table name to return column names to assign to $_SESSION[$column] $column = ******* column to query $value = ******* column value to match column query /** WARNING avoid using on databases where column contents are large eg. BLOBs **/ // Create connection to database $conn = new mysqli($server, $username, $password, $database); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); // echo 'con failed'; } if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Database configuration $db = new mysqli($server, $username, $password, $database); // Check connection if ($db->connect_error) { die("Connection failed: " . $db->connect_error); } // Query to get columns from table $query = 'SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "'.$database.'" AND TABLE_NAME = "'.$table.'"'; //echo $query; $resultcols = $conn->query($query); //print_r($_SESSION); while($rowcols = $resultcols->fetch_assoc()) { $sql = ' SELECT `'. $rowcols["COLUMN_NAME"].'` FROM `'.$table.'` where `'. $column .'` = "'.$value.'"'; $result = $conn->query($sql); // print_r($_SESSION); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $_SESSION[$rowcols["COLUMN_NAME"]] = $row[$rowcols["COLUMN_NAME"]]; } $err_message = "Success<br>"; } else { $err_message = "unknown information can not complete session variables<br>"; } } // see what you get print_r($_SESSION); echo "<br>".$err_message."<br>"; foreach($_SESSION as $x => $x_value) { echo "SESSION Key=" . $x . ", SESSION Value=" . $x_value; echo "<br>"; } ?>
×
×
  • Create New...