So I am newer to using databases but really good at coding, i just never really had to use a database. Now i have to and im a bit lost. I own a server and i know how to use phpmyadmin to set up a database if thats even what im supose to do. Once I do that im having trouble of how to link that to my xcode project and then how to populate it with the data meaning usernames, userids and everything else. If you guys have any good videos that you know would help me out that would be great!
Using DataBases With xcode
Seems a bit of a high level question for the forums, I think.
Perhaps if you discussed what it will be used for, how many users, how much data, how/if it will be backed up, what type of security is needed, what your budget is for tools and finally, is this for macOS, iOS, tvOS or watchOS or?
Otherwise, see the docs: https://developer.apple.com/search/?q=database
"Typically" you would define a REST API using JSON, and write some PHP code on the server side to translate between the well-defined JSON format and your internal database representation. But there are many ways to attack it and as KMT suggests, some non trivial implementation details such as security. Bottom line, it's completely up to you how you choose to interact with your database server. Simple GET / POST of JSON over HTTP(S) is the most common but you could do it however you like.
You might expllore whether CloudKit will serve your purposes:
Sorry guys I almost forgot I had this post running let me post the more detailed explinatiom.
Im going to try and be as detailed as possable as to what I am looking to learn here. I have basically finished the UI part of my xcode project now I face the user login and registration system. What I know how to do is this, I know how to create a database in panel, create tabels and so on. What I do not know how to do is Write the php webservice that runs on the website to communicate with xcode as well as linking xcode to the webservice or to the database. Im looking for either like a detailed explaination or links to some articles or videos that will be able to help me. The next thing I would like to know how to do in xcode is when the user is creating an account how do I validate the email so they cannot enter and invalid email mean one that doesnbt exhist, also when the user is setting a password i want there to have to be at least one leter in that password capital how can I make them have to do that in xcode. The last thing that I would like to do is after the user signs up setting up and email varification system, so preventing them access until the email is verrified. Thanks for the help in advance!
I dont want to have to rely on things like firebase and what not. I want to be able to write and manage on my own. I already own a webserver that can handle the database. Security I am not to sure to be honest but there will need to be some.
The thing is, i see all these tuts online and they are either not using a database or there using firebase. Theres no real tuts on how to do it and link them to xcode using your own database.