0

Hello i cant understand how i can send database info to user for example i want to send my note which contain (date, text, title and other info) and this info is under ID for ex. (123456) please someone explain me how i can do that or help me thank you :)

Edited by Stefan_1

2
Contributors
3
Replies
20
Views
2 Years
Discussion Span
Last Post by diafol
0

If you have a db table ('notes') like so:

id | date | text | title | to | from

Then all you need to do is create a prepared statement (PDO or mysqli):

SELECT `id`, `date`, `title`, `text` ... FROM `notes` WHERE `to` = ? ORDER BY `date`  DESC 

Then bind the session user id to it - this is assuming that you have a user login system ad that you store the user's user_id in the session on successful login.

Obviously you can make it more sophisticated by getting the sender's name and by limiting this to say 20 notes (pagination):

SELECT n.id, n.date, n.title, n.text, u.username ... FROM `notes` AS n INNER JOIN `users` AS u WHERE n.to = ? ORDER BY n.date DESC LIMIT ?,?

If you have inbox and outbox tabs (like DW), it's a similar thing to do sent items:

SELECT n.id, n.date, n.title, n.text, u.username ... FROM `notes` AS n INNER JOIN `users` AS u WHERE n.from = ? ORDER BY n.date DESC LIMIT ?,?

If you want conversation type output:

SELECT n.id, n.date, n.title, n.text, u.username ... FROM `notes` AS n INNER JOIN `users` AS u WHERE n.to = ? OR n.from = ? ORDER BY n.date DESC LIMIT ?,?

This can be even more complicated is you have message statuses, like 'read', 'deleted', etc. Limitless options! This is fun stuff to play with.

Edited by diafol

0

hmm i get it but not at all, i have table kladilnica and im getting the values title, text, and date for ex. so in your example you have one more row which is to but i dont have that row in the database i dont understand what i need to do. Should i create one more row and that row to be the noteReceiver if yes, what if i want to send it to two users the note ?

Edited by Stefan_1

0

You have a few options for sending to multiple recipients, but the best is probably:

NOTES

id | date | text | title | sender_id

MESSAGES

note_id | recipient_id | status_id (PK on note_id and recipient_id)

That way you can send this to as many people as you like:

Note

1 | 2001-01-08 12:09:07 | Some text | This is a Title | 8

Messages (note #1 sent to users 5,6,9)

1 | 5 | 1
1 | 6 | 1
1 | 9 | 2

However you could do this in a number of ways as I said. You could also adapt it to create a group conversation - more like a chat or forum type communication.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.