PHP Test Page
MySQL
Creating and Executing Query
';
echo "messageID\tdate\t\tsender\trecipient\tmessage\n\n";
$sql_select = "SELECT messageID, date, sender, recipient, message";
$sql_from = "FROM messages";
$sql_where = "WHERE recipient='".$_SESSION["loggedInUser"]."' OR sender='".$_SESSION["loggedInUser"]."'";
$sql_order = "ORDER BY messageID";
$sql_statement = $sql_select." ".$sql_from." ".$sql_where." ".$sql_order;
foreach($db_connection->query($sql_statement) as $row){
print $row['messageID']."\t\t";
print $row['date']."\t";
print $row['sender']."\t";
print $row['recipient']."\t\t";
print $row['message']."\n";
}
echo '';
}catch(PDOException $e){
echo "PDOException: ".$e->getMessage().PHP_EOL;
}catch(Exception $e){
echo "Exception: ".$e->getMessage().PHP_EOL;
}
echo 'Variables
';
echo '$sql
';
echo "";
print_r($sql);
echo "";
$superglobalsList = array('$_SERVER','$_REQUEST','$_POST','$_GET','$_FILES','$_ENV','$_COOKIE','$_SESSION');
foreach($superglobalsList as $value){
echo "$value
";
echo '';
print_r(eval('return '.$value.';'));
echo '';
}
echo ' Like, everything everything?...
';
echo '$GLOBALS
';
echo "";
print_r($GLOBALS);
echo "";
?>