I need a simple script - php, form input, search a db and add new record?

First off, it this does not belong here, I understand and will remove it Maybe there might be a better place to post it?

If it is ok, then what I need is a script that I can make work for my purpose. I’ve been trying to learn enough php to create this but am floundering.

What i want to do Is create a script to.

Called from an html page,
Have the script ask a user for his desired email name, look in my database to see if the name has already been entered, and if NOT
ASK the user if he would like to make a reservation now.

If Yes, then ask for his name and add the new email address to a field named “EmailName”, the current date under a field named “reserved on”, the current time, in a field named “reservation time” and the persons name the under a field named “Customer Name”.

If NO, do not make reservations yet, then ask the user if he would like to check another email name.

If yes, then go back to the beginning.

If no, exit to the calling html.

A key, is that we have various domains and need to have different tables to look into, which would be based on the users choice of domains.
IN the basic question to the user, they would need to select from 7 different domains (maybe a drop down table). The search would look for the new email name entered in the go-gators.us data table.

Once the domain is selected, Like the “Go-Gators.us” domain, the search function must handle various characters found in email and domain names. (in go-gators, the dash is killing me, in my efforts, so far)

I just want something I can work with and make other mods to, but I need the basic functions working.

If you do not have one, maybe you could recommend a place to find something , but I have tried a bunch of FREE learning scripts and have struggled to get something to actually work, as written. I am just not smart enough to understand what is happening to me, when they error and I get very frustrated…
I can see the script, in my pea brain, but I just can’t make it work :’(

Can anyone help?

Thanks Randy

We’ll be happy to help out if you run into problems and answer any questions, but we’re not goig to start something like that from scratch. It sounds like you just need to look up tutorials on doing a registration script and then modify it to suit your needs.

Yes, I did figure that. I was just hoping someone would have the heart to put me out of my misery. these languages have become far more complicated than my old Dbase days.

I have tried several modifiable scripts but just have had bad luck (Ok lack of knowledge) to get them going. I am working with someone who is helping me so I truly appreciate all the help I have received so far. I’ll close this topic. but leave it in place in case anyone has such an idea, but understand the result up front.

Thanks

Sponsor our Newsletter | Privacy Policy | Terms of Service