Hi guys, i want to know, can you guys tell me what I need to learn to create a simple web application for ecommerce website (not a complicated marketplace app) like for example: "shoes website" with the abilities for customers to sign up and put the product into shopping cart and then check out with simple payment system like paypal?
I am not sure why you posted this in the Android forum.
Anyway, last question. What is the suitable database system for this ecommerce website that can store customers accounts and then send their order to us as well as payment confirmation when they have made the payment?
The most common database systems are MySQL and Microsoft SQL Server. But you would need to study both to decide which is best for you. I do not know whether Typescript and React would be necessary or not, but their respective websites would probably give some ideas.
Simple would be just to get a web server up and responding to a request.
Ben A Johnson wrote:
what I need to learn
2. Database. Doesn't matter which one. You don't actually need to learn a relational one (SQL) but I consider those more useful, but more difficult, to learn.
3. Basics of Web Servers: Server, Client, other misc stuff, like how IP works.
4. After you learn most of that then you need to get a basic web server up which usually requires some sort of 'web server'. Which one depends on what you learned above.
5. Then you need to learn how to deliver content to a Client. So for example how a browser sends a request then gets a response.
After all of that then you could start, if that is your real goal (this forum) learning how to create a cell phone application. Such as one that runs on an Android phone. There are examples out there that would allow you to start from this step but it might not help if you do not understand at least some of the above.
There is nothing special about that page versus other pages. Any page does what the page does. Only difference there is that the page (and supporting backend functionality) was written to do that.
Basic outline of functionality for a page
browser => front end => business logic (of some sort) => database layer (of some sort) => database
Everything else is in the the details.
Since you mentioned PHP and MySQL you could look at LAMP. However I am not sure that is a good route for you to take at your experience level. But there might be some better tutorials now (versus very long ago when I looked to help.) If you go down that route then use Python rather than PHP since it is more widely used thus knowledge of it is more beneficial.
Not quite, as you need backend code to act as the interface between the web pages and the database. So you will need C#/VB.NET or PHP for that part. As to the Android system, you need to study some articles on Android development.
You can host your database anywhere you like, although the logical place is on the webserver. And you would use that live database for all your account creation, i.e. users register on the site and then use their id and password for future logins.
But, TBH, you seem to be trying to run before you can walk. You should start small and get a basic website working, with a simple front end page and a simple text file rather than a database at the back end. That would help you to understand some of the issues that need to be worked on. The internet, and indeed Web Development[^] here on CodeProject, has many articles and samples that will help you.
I received the following message from you, but it does not appear in the forum here (maybe you deleted it):
Thanks man for your reply. Yes you are right. I think i need to build simple website project for ecommerce first before jumping to the more difficult parts. I wanna ask by the way, so i found these 2 cool websites: Netlify and then 000webhost. And these 2 sites offers free web hosting for web projects and also Database with phpmySQL, and you can add your own domain there. what do you think about these 2 sites, are they legit and can be trusted for our professional web projects like serious ecommerce sites.
I cannot say whether either of those site will help you as I have no experience of them. However, as I and @jschell keep saying, you need to start with something simple. Forget about ecommerce as you are nowhere near ready to implement such a system. Just create a simple website that allows you to enter some data that can be checked by the backend. If necessary the backend can write it to a file so you can do some manual checking. You could host such a system on your own PC using IIS, which is part of Windows. I have such a system on my PC and it works fine as a test bed.
I agree, and have done both on a very small scale. I don't think the OP fully understands the issues involved, despite me and @jschell trying to point out some of the things that need to be understood.
Thanks man for your answer. What do you think about PHP and mySQL. I heard that PHP is getting less and less popular these days, based on the trend. What do you think about that? Is that true? Can PHP still be promising to learn in the next 5 or 10 years? Or do I need to step on another programming language that can still connect to the database to our website?
Years ago I track down how that site collects their data. Which seems much more reasonable than any other trend report which almost always seems to be based on something like 'we surveyed 50 companies and they said they will be using X in the next year.'
Building an e-commerce app or website can be an exciting venture. The general steps you can follow to create your e-commerce platform:
Establish your app's goals. ...
Decide on your target audience. ...
Determine the essential features. ...
Choose the technology. ...
Build the app's minimal requirements and features. ...
Publish and Market the app. ...
Keep building the app with your users' feedback.
Hmmm, it's kind of hard to ask a question because I know something, but only that I don't know much yet 😕.
I want to go back to learning in the project.
Blocks to use: #android , #kotlin , #mssql
Interface in Kotlin already covered (as such ) Database in MS SQL (not the worst, a bit of my hubby ) Connection covered.
And here comes the conundrum of which way to go. Conditions to be met:
1. Work with the database offline/online.
2. When resuming the connection, the client data is synchronized with the server connection test is carried out "independently"
3. data update on the server is done "independently"
4. In offline mode, customer data cannot be lost even after restarting the device
I was thinking of using #sqllite #maven on a device between user and #mssql
Do you know any simple tutorial?
Most of the tutorials I've come across end with "select * from table"; and the rest is up to you. Hurrah 😕
It sounds like you already know many of the basics, so the next step is to figure out how to implement the conditions you listed. You reminded me of this question when I was studying cotlin, but to write, also required a database. You will need to figure out how to establish a connection between the client and the server, and how to ensure that the data is synchronized when the connection is resumed. In addition, you'll need to figure out how to ensure that the data on the server updates itself, and how to make sure that client data isn't lost even after a device reboot. Good luck!
-- modified 26-Jan-23 9:58am.
Last Visit: 31-Dec-99 18:00 Last Update: 20-Sep-23 23:55