My Account

user_firstname;
$email =$current_user->user_email;

$_SESSION[‘user’]=$user;
$uname=$_SESSION[‘user’];

include “wp-config.php”;

$mysqli = new mysqli(“$DB_HOST”, “$DB_USER”, “$DB_PASS”, “$DB_NAME”);
if ($mysqli->connect_errno) {
echo “Failed to connect to MySQL: (” . $mysqli->connect_errno . “) ” . $mysqli->connect_error;
}
$select1=mysqli_query($mysqli,”Select order_id from wp_woocommerce_order_items where order_item_name=’EBook'”);
while($arr1=mysqli_fetch_array($select1,MYSQLI_ASSOC))
{
$order_id=$arr1[‘order_id’];

$select2=mysqli_query($mysqli,”Select id,post_status from wp_posts where id=’$order_id’ and post_status=’wc-completed’ or post_status=’wc-processing'”);
$arr2=mysqli_fetch_array($select2,MYSQLI_ASSOC);
$order_id2=$arr2[‘id’];

$select3=mysqli_query($mysqli,”Select post_id,meta_key,meta_value from wp_postmeta where post_id=’$order_id2′ and meta_value=’$email'”);
$count=mysqli_num_rows($select3);
$arr3=mysqli_fetch_array($select3,MYSQLI_ASSOC);
//echo $arr3[‘meta_value’];

}

if($count!=”)
{
?>

EBook

Recent products