Android Cha8 - Minimal Chatting Application
Please Install PHP Scripts along With MySQL Database
- PHP Scripts are located in PHP_SCRIPTS directory
- Please install MySQL Database and change credentials in config.php
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
CREATE TABLE `chat_message` (
`id` int(11) NOT NULL,
`sender` int(11) NOT NULL,
`receiver` int(11) NOT NULL,
`message` text CHARACTER SET utf8mb4 NOT NULL,
`time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `chat_user` (
`id` int(11) NOT NULL,
`name` text NOT NULL,
`user` varchar(32) NOT NULL,
`pass` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
ALTER TABLE `chat_message`
ADD PRIMARY KEY (`id`);
ALTER TABLE `chat_user`
ADD PRIMARY KEY (`id`);
ALTER TABLE `chat_message`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `chat_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;
- Please Change URL's in ChatActivity.java accordingly
public static String registerURL = "http://localhost/com.softopian.cha8/register.php";
public static String loginURL = "http://localhost/com.softopian.cha8/login.php";
public static String sendURL = "http://localhost/com.softopian.cha8/send.php";
public static String fetchURL = "http://localhost/com.softopian.cha8/fetch.php";