PHP MySQL simple CMS and integrate with Android app

[danielhan]

I have a plan to create my own project and need some help. I want create small android application with PHP / Mysql Backend.

I create table in SQL like this :

Code: Select all

CREATE TABLE posts (
id int(9) AUTO_INCREAMENT PRIMARY_KEY,
content varchar(1024) NOT NULL,
writer varchar(128) NOT NULL
);

1. i know for now i need to make a simple CMS to add my Content with Writer name (Based on MySQL Table). and i need your help to make my simple/secure cms to solve this step.

2.each post have a content + writer. like this image : (Android APP)

and in this step i want show the posts only in my android app. What do i need for this step? Note: like another android application the developer website home page is app review and all data shown in android app.