Basic2-DBconn

[insert_php]
$servername = ‘localhost’;
$username = ‘i3141100_wp2’;
$password = ‘I.YLB7jy7H9JwGZ199H12’;
//$dbname = localhost;
$dbname = ‘i3141100_wp2’;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error)
{
die(“Connection failed: ” . $conn->connect_error);
}
else
{
global $wpdb;
global $current_user;
global $wp;

// echo home_url( $wp->request );

//these work
// get_currentuserinfo();
// echo $current_user->user_email;
// these work
// session_start();
// $_SESSION[“emailtemp”] = $current_user->user_email;
// echo $_SESSION[“emailtemp”];

//these work
// $resultsB = $wpdb->get_results (“SELECT id, lname from leestest”, ARRAY_A);
// var_dump($resultsB);
//echo $current_user->display_name;
//echo $current_user->user_email;
}
[/insert_php]