LeonLatex

Sets up a mysqli connection script which I retrieve with included. If a user enters the wrong password or username then the connection to the database will be interrupted, and a message will be given about this. I want to do this in a different way. I want the .php connection script to work so that the script lets me or the ser know if it is the password that is incorrect or the username that is not authenticated. This way the user can find out if he / she has entered the wrong password or username. If both are incorrect, notice of this will be given. connection file is a fairly standard script. I have no clue about how to solve this problem. Is it posible at all? Do you know how to do it? <? $servername = "localhost"; $username = "username"; $password = "password"; // Oppretter tilkobling. $conn = new mysqli($servername, $username, $password); // Kontrollerer tilkoblingen. if ($conn->connect_error) { die("Tilkoblingen feilet: " . $conn->connect_error); } echo "Tilkoblingen var vellykket"; ?>

Ahaaaa... Then I understand why I did not remember this from either mySQL (SQL) or PHP. Did not find anything about it online nor other than what you say is the meaning of FUBAR. Still, I had to ask in case there was something important I had forgotten or overlooked.

Thanks to both of you. You have really helped me along the way with the database. Barand got me started with his ideas, and then gizmola came up with some add-ons that were in my head as add-on features to enter into the database later. It was the addition of gizmola that was missing to get this to vote. With the table berthBoat I will easily be able to add these extra features afterwards. gizmola and Barand, you are talking about something when you talk about how the system in the boating association is. It is thus the case that there is an association with permanent members where the membership is year-based, but continuously until the member terminates the membership. That is, you receive an invoice once a year. This applies to both support members who are without a boat or a member with a boat and berth. Possibly in anticipation of berth becoming vacant (then the member is listed in a waiting list). I will probably need some help with this waiting list later as well, but it will come when the rest of the system is ready for it. As it has been suggested from their side until now is completely in my street for how the system should be, what data should be stored and retrieved etc. Just like a history section about each member. The plan is for each note to be saved each year before it is deleted. It will not be deleted permanently, but transferred to a separate table for a register for posterity, but which will not have a negative effect, only storage of what a person has done, etc. if you understand what I'm talking about. A lot of this is in PHP scripting as well, these are some of the plans for my boat association's system. I will also include some functions with regard to invoicing directly from the member list. This is far into the future. I'll now give you both a small donation. It's not much, but that's what I can do now for this time (gizmola) I did not get to donate anything to because he does not have a paypal account). Hope there is so much that I can get more help when I need it Barand. This system is becoming more advanced than first thought. Ideas are created as time goes on. Thanks for the help so far. P.S. What meens FUBAR?

Thanks. neither do I like phpMyAdmin. I will try out MySQL WorkBench.

Barand, thank you soooooo much. I am on the right way now i can see. Just what i needed. Hope i can come back to you for further questions. What kind of MySQL GUI do you use for draving the database?

Zane, thanks for your reply. I can try to answer. It so happens that I have a membership database for a boating association with members. These members must be / are linked to a number, which is the berth on the pier they belong to. This number is determined by me and I want there to be ID in the table (s). This is basically what I want to do in the first place, but which I do not understand how to do. Secondly, I want these numbers / berths to be able to be used again. When a member is deleted because he acquires a boat that is larger or smaller, a berth / number on the pier is released. This number must be able to be used again by others when a member is deleted and transferred to another berth, and another jetty number that is available. Hope you understood a little more of what I meant now. I think Barand is talking about something in his proposal. I'll check out and see what I come up with. I will definitely come back with more questions, about this issue or a new question, and I will certainly be able to help solve other people's problem as time goes on. I'm new to both the site here and MySQL and PHP. I will also eventually be able to contribute with donations. What is a normal sum and donate to those who help me. Will not seem like someone who is stingy and gives too little, but I do not have much money to give away. So how much is accepted as enough money when i donate?

How do I get the my MySQL database to enter my number system to assign an ID number space that goes from 01, 02, 03 etc. from 10 and up to 99 there should still be two numbers as in 10, 11, 12 etc. From 100 three numbers as in 100, 101, 102 etc. When a member is deleted from the list, the number must be able to be used again. I tried a few different solutions here, but managed to delete everything in the end. Only the databases are left. These numbers should not only be reusable, but also reusable and automatically dialed when the member registers. As I said, the number will be automatically chosed if it is available. They must also be transferred and selected into other DBs as the ID already assigned as. Exactly this part of the database I am struggling with now. If you do not understand what I mean, please ask me. I will answer as best I can. Thanks for the help you give me.

mac_gyver: This is the kind of help i want. Then i can look up and if i have further questions i hope i can come back and ask for help, tips and how to/best way to do it. Thanks mac_gyver for puting me in the right direction. I will look throug this and save it localy at my network.

Of course ... 😞 I deleted everything I had done. The only thing I have left is the MySQL DB. I deleted it because I was so upset that I did not make it work. I had then done this PHP script for 3 days and I have hardly slept. Now i dont know what to do.

I am in the process of creating a waiting list that I want to work automatically. When a new member registers for membership, the member must be on a waiting list for a while before the member gets permanent membership. When the membership is activated by me, I want this to work like when I delete the person who is number 1 in the list, and number 2 will be number 1. the remaining numbers in the list will automatically move a number up, just now . 5 will be number 4 and so on. PErson number one is the person that allways will be deleted from the waiting list. An idea would be that this persons name ande rest of data connected to hes membership number will be moved automaticaly to the permanent members list when hi is deleted from the waiting list. Only the name will be displayed in the member list, but the form that the new member submits will have several fields. There are t12 fields to be filled in in the MySQL database, but only the name and surname to be displayed in the list. The numbers will be generated automatically in front of the name. I have tried to do this by myself. I have tried to do this myself, but I do not succeed. I am very new when it comes to PHP and programming in general. Hope someone here can help me with this. I can not find out.