从我的数据库中获取指定信息

Question

I want to make a table with all chat messages that have been send to the server. I got the table working but now i want to get when i click a user name like 'demo' it shows all chat messages that have been send by 'demo'

Im using this table: http://almsaeedstudio.com/AdminLTE/pages/tables/data.html

How do i get when i click like the username 'demo' a bootstrap alert box pops up with all the by user send messages appear? I mean like 'USERNAME GET FROM TABLE SHOUTS SHOUT_NAME=DEMO' and it shows all messages.

How do i do that?

Answer 1

You haven't defined the variable for $shout_name, only for:

$shout = mysqli_real_escape_string($dbc, $_POST['shout']);

where you may have meant to use or meant to add it:

$shout_name = mysqli_real_escape_string($dbc, $_POST['shout_name']);

in relation to (null, '$shout', NOW(), '$shout_name')

which is why after adding error reporting (as stated in comments between you and I), have received an undefined variable warning.

Also make sure you have initialized the session with session_start(); since you are using sessions.