Realtime Chat Application with CakePHP and Socket.IO #1


In this blog we will build a Realtime Chat Application with CakePHP and Socket.IO



Your are free to use another framework, the idea is just learning the basics and a few (Socket.IO) tips

Database : 

To store our data for this application we need 4 tables : 

users :        contains user's informations such as username and password hash ,email ... 


messages : contains messages between users, it also store the information of sender and destination 

user

companies : or teams table ,in order to organise groups i add this table to give the user the freedom 

of organizing his contact it stores the company name with his owner .

 companies_users : it contains the users and their respective companies


here the SQL file fo database structure     file

in the next tutorial we'r gone started building the frontend using cakephp

 


Comments

Popular posts from this blog

Twitter API with PHP

Let's build a mobile application with Ionic Framework #3