How to get customers id from session php/mysqli?

Question

I have a login page which creates $_SESSION['username']= $username and $_SESSION['id'] = $id

now I have a shopping cart and I want to get that id so I can get the rest of the user's information

i tried $_SESSION['order'] = $_SESSION[id']; but it doesn't work. I'm still learning PHP and I don't know how to get these data from that session.

<?php 

include 'dbConfig.php';


include 'Cart.php';
$cart = new Cart;


if($cart->total_items() <= 0){
    header("Location: ");
}


$_SESSION['order'] = $_SESSION[id'];


$query = $db->query("SELECT * FROM members WHERE id = ".$_SESSION['id']);
$custRow = $query->fetch_assoc();
?>

First try to troubleshoot as follows echo '
'; var_dump($_SESSION); echo '
'; See whether the id is set or not once. And if the id is set in session then change $_SESSION in the query to static id, say 8 and check whether the query works. Hoping you can do this throw some checkings Note: See whether the session start is required — Hariharan V., Dec 26 '18 at 06:55
Your code contains a parse error as posted. It's also open to SQL injection; use a prepared statement. — Funk Forty Niner, Dec 26 '18 at 15:17

score -1 · Answer 1 · edited Dec 26 '18 at 15:16

-1

You need to use session_start() at the top of the page

A single quotes is missing on $_SESSION['order'] = $_SESSION[id']; replace it with $_SESSION['order'] = $_SESSION['id'];

<?php 
session_start();
include 'dbConfig.php';


include 'Cart.php';
$cart = new Cart;


if($cart->total_items() <= 0){
    header("Location: ");
}


$_SESSION['order'] = $_SESSION['id'];


$query = $db->query("SELECT * FROM members WHERE id = ".$_SESSION['id']);
$custRow = $query->fetch_assoc();
?>

NOTE: You must confirm the session value is already set, please echo the session value and confirm it's not null

edited Dec 26 '18 at 15:16

Funk Forty Niner

74,372
15
66
132

answered Dec 26 '18 at 06:54

JIJOMON K.A

1,250
2
11
29

ok i did that and it's still not working. i guess i created the $_SESSION['id'] wrongly. – Cli Ad Dec 26 '18 at 07:33

score -1 · Answer 2 · answered Dec 26 '18 at 06:59

-1

I believe so you forgot to write this on top of the other page.

session_start()

Please do write it, and than check it by

print_r($_SESSION)

answered Dec 26 '18 at 06:59

Muhammad Tahir Qaiser

300
5
23

How to get customers id from session php/mysqli?

2 Answers2