|
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.'
|
|
|
|
|
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 😕
|
|
|
|
|
|
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.
|
|
|
|
|
|
Hi
I'm new to Kotlin and I would like to declare an two-dimensional ArrayList (450/10)
But it didn't work - tried different versions like
ArrayList<ArrayList<String>>
or
arrayListOf<String>(arrayListOf())
But it seems not the right one
Can someone help me?
modified 7-Dec-22 18:22pm.
|
|
|
|
|
|
I would like a data structure like this
a b c d e f
a b c d e f
a b c d e f
a b c d e f
and would like to access [2][3]=c
|
|
|
|
|
|
I've checked the many blogs and forums and github but nothing found related/help for implementing shoutcast v1 or v2 in android, only ref which is helpful I've found in github is this:
https:
but above code only work with icecast server and also very limited use and files which is used for broadcasting is *.so files so we can not change or override the exiting methods.
is there any guide or helpful link or source code which I can use to build shoutcast broadcasting in
|
|
|
|
|
Would that be something that could be answered here?
"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
|
|
|
|
|
How to develop mobile background service to fetch battery information using javascript?
|
|
|
|
|
That's a tall order. Which piece do you need help with exactly? Do you have experience coding other Android apps?
"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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
