We can help. But, what you are asking is a total site system and this will take some time to learn.
There are many many examples of each section you requested on the internet. Some are better than others. The experienced programmers here can help as you progress through your learning process.
Glad you can join us here! Now, lets break down your requests into some sort of list that will cover the various aspects of the entire system. You will need to learn, and worst of all, understand each step.
Here is a partial list…
Database, Xamp. This system is already in place on your system. To create the database, you start the Xamp system so that it is running. Next, open a browser and go to localhost which will be your Xamp system. This system should show you the parts of your system. It should show you the MySQL admin page named phpMyAdmin. If you click on that you can see your database system. You can create a database name. You can pick any name. This is only used when you create a connection to the database inside your PHP program. If this is for a sales site or info site, you can name the database anything that corresponds to that field of interest. Normally, you do NOT use caps in this name.
Next, still inside the phpMyAdmin, now you have a database. (Using default settings of course.) Select the database on the left side. Then, you can enter a database TABLE on the right side. Since you are using just reference numbers and names, you could call it something like “references” or something else to do with your data that will be saved in it. Normally you would have many tables inside your database. Each table would correspond to one type of data separated by use. For example, you would have one called users that would be where all your user’s data would be saved. Their email addresses, phone numbers names and other user-only info.
Once you have created a table inside your database, you click on the left the name of the table.
Then, on the right side you create three fields. The first would be named " id " and would be set to INT. This field will be used for all indexing of the data inside this table. The next would be your reference and the last your name fields. You need to decide what type of data goes into the ref and name fields. If the reference number is a code number, set it to INT, if it is alphanumeric set it the VARCHAR and put 255 in it for the size. This will let you enter from 1 to 255 characters in it. Designing a database, table and field structure is a study in itself. Most of these can be found on the internet or you can ask here.
Now, that covers just the database creation and does not give a lot of details on what you are really doing there. But, it gives you the basics.
Here are other areas you will need to learn… Without a lot of notes!
HTML - Basic webpage code, a language of it’s own. This lets you put things on a webpage.
CSS - This is styling code, another language of it’s own. This lets you paint the HTML code nicely.
( Note, this also lets you resize items on the screen, place borders around things, change fonts, etc )
PHP - The guts of the program. This language let’s you connect to the database, read data, display data, write data back to the database, insert, delete and update data. It also handles all of the real commands you give to your site, such as how to handle buttons that are pressed by your users.
*** There are many more, but, you need to learn so much first. This gives you an idea where to start ***
Oh, for the programming on the database sections, I suggest PDO. That is what all professional programmers are using these days. There is a great document that walks you thru the correct way to use PDO inside your programs and website. Here it is… PDO Tutorial
The PDO might be over your head at this point. But, I suggest you review it and note some of the examples as they will help later on.
Another question or two… What are you using for your editor? In my Windows laptop, I use Wamp which is similar to Xampp. (You have a Mac I see…) And, I use Netbeans as an editor. But, some use Notepad++ and others use more complex editors. You need to select one to use. Some will show your errors and that makes it easier to debug once you get a site working. You site will be inside a folder under the Xampp folder. Not sure, but htdocs or www. That would be where you save your actual website. You website will contain HTML, CSS and PHP files. You can put them all into just one file for testing. We will cover that later on once you get your database set up and have read up on all of these…
Good luck! ( PS: Sorry for so much to read, but, you are walking into a large amount of studying! Ha! )