|
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.
However, you need to study ASP.NET or PHP for the backend, HTML, CSS and Javascript for the frontend, and a suitable Database system. You can also Google for ecommerce to see if there are templated systems available to get you started.
|
|
|
|
|
can this ecommerce website be transformed into or opened as android app as well?
|
|
|
|
|
Possibly, but this is not something you can achieve in an afternoon. The question again requires considerable research.
|
|
|
|
|
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?
Thanks for your answers. really helped a lot with your answers. I have learned HTML, css and currently working on JavaScript. Anyway, do i need to learn about Typescript and React as well as Im building this web ecommerce website for android app as well?
|
|
|
|
|
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.
|
|
|
|
|
Ben A Johnson wrote: learn to create a simple web application
What you described is not simple.
Simple would be just to get a web server up and responding to a request.
Ben A Johnson wrote: what I need to learn
1. Do you know a normal programming language? Java, C# and/or C/C++. But JavaScript might also work (but NOT using it only in a web page.)
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.
|
|
|
|
|
Thank you so much for all of your answers man. Really helpful a lot. Yes, I'm still learning about JavaScript and I have been doing some research on YouTube regarding how to build an ecommerce website/app using MySQL PHP. But I want to ask. So i saw a video where this guy create an ecommerce site (clothing site) with the abilities for customers to sign up and then edit their profile (shippinng address, avatar, phone number, so on), and the admin is also able to edit any product that he sells through the admin page of his site. What i want to ask is, when he opens his admin page (where he can edit all of his products, verify payment, verify whether the product has been shipped or not, etc) is that ADMIN PAGE MySQL? How did he create that admin page? Did he build it from a scratch? I'm sorry for asking this, but I still want to get a better understanding about how this ecommerce site works?
|
|
|
|
|
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.
LAMP (software bundle) - Wikipedia[^]
|
|
|
|
|
Hi I was just seeing a video on YOuTube explaining about MySQL and how it works with localhost XAMPP especially to create the database of data like products, customers, etc. What I want to know, Can I just learn about MySQL, HTML, CSS and JavaScript to make a fully working ecommerce website? And if I want to make an Android app of that ecommerce website, what else do I need to learn? Do i need to learn about React, Python and Java too (with Android studio)?
|
|
|
|
|
Ben A Johnson wrote: Can I just learn about MySQL, HTML, CSS and JavaScript to make a fully working ecommerce website?
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.
|
|
|
|
|
Thanks for your reply. Yes, I just saw a video explaining about the connection between HTML page, PHP and MySQL database? And how the login password or how user can register an account and then connect their data using PHP to our MySQL database using XAMPP. I wanna ask again. About MySQL. After we finish creating our database from user information, our products, etc using MySQL, do we need to upload these database (including our website with HTML, css and JavaScript) from our localhost (XAMPP) to our web hosting/server so the who ecommerce site can start operating?
|
|
|
|
|
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.
|
|
|
|
|
As said before and just with the last post...
You cannot understand the big picture until you have at least some familiarity with some of the various parts. You need to pick a part and start learning just that part.
|
|
|
|
|
I received the following message from you, but it does not appear in the forum here (maybe you deleted it):
Quote: 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.
|
|
|
|
|
Richard MacCutchan wrote: Forget about ecommerce as you are nowhere near ready to implement such a system.
I've been developing Android apps since around 2009 and don't even think I'd try tackling an eCommerce project. Now sending data to a database backend from an Android device...way easier.
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
|
|
|
|
|
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?
|
|
|
|
|
Ben A Johnson wrote: Can PHP still be promising to learn in the next 5 or 10 years?
Well, if I coild foretell the future I would be living on a Caribbean Island with a young blonde or two.
Seriously though, you need to make these decisions for yourself. Use whatever systems are available now, that you understand, and actually get on with the work.
|
|
|
|
|
Ben A Johnson wrote: I heard that PHP is getting less and less popular these days
I have been using the following site for years. Notice that their graph goes back to 2002.
TIOBE Index - TIOBE[^]
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.'
|
|
|
|
|
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 😕
|
|
|
|
|
|
Now, it is time to read and learn something about sync data between sqlite and mssql 
Thanks
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
