CODEWITHSUNDEEP
phphtmlmysql
martijnmelchers
martijnmelchers

Reputation: 51

Get specified info from my database

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?

Upvotes: 2

Views: 102

Answers (5)

Funk Forty Niner
Funk Forty Niner

Reputation: 74217

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.

Upvotes: 2

Creaven
Creaven

Reputation: 319

Try this field with a standard post. Turn it into an input and see if it works. It could be a number of things. However try and get something in the database and build on that. If you can't get a standard one in you know there there is a problem elsewhere with your code.

Upvotes: 0

Mike
Mike

Reputation: 573

You seem to be grabbing $_POST['shout'] into your $shout variable, but then using a $shout_name variable for the insert. Try:

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

Upvotes: 0

Sha7x
Sha7x

Reputation: 485

Try printing $shout_name. Maybe your $_POST is incorrect.

Upvotes: 0

Marc B
Marc B

Reputation: 360602

Disabled form fields do NOT submit with the rest of the form:

<textarea name="shout_name" class="form-control" disabled><?php echo  etc...
                                                ^^^^^^^^^^

You don't show how/where you define $shout and $shout_name, but most likely you're not validating the form input at all, and are almost certainly vulnerable to sql injection attacks.

Upvotes: 5

Related Questions