PHP Developers Network

"somethinggoeshere" should be a valid API key. Are you using one?

The logic is wrong. You are creating a Race Condition. Do not check if a user already exists. Set a unique constraint on the appropriate field(s), attempt the insert and capture the duplicate error if any.

Better yet, use PDO. Here is a tutorial to get you going.
https://phpdelusions.net/pdo

PRG is the answer. https://en.wikipedia.org/wiki/Post/Redirect/Get

What is the REAL problem you are trying to solve?

Problem 1. You create $username and then don't use it. Problem 2. You have a variable $memberID that comes out of nowhere that you do not use. Problem 3. The table transfer does not have a column named or spelled username Problem 4. You never ever put variables in a query. You need to use Prepared S...

I am a Software Engineer with 25+ years experience. Please provide a summary of what you are looking for and your budget for the project.

Wait, I got this....

Forms do not send emails. They submit data. The mail function sends emails. http://php.net/manual/en/function.mail.php

Aside from your question, the code you posted is obsolete and has been completely removed from Php. You need to use PDO https://phpdelusions.net/pdo.

@requinix, Am I misunderstanding you? This is perfectly valid. <select> <optgroup label="England"> <option value="avon">avon</option> </optgroup> <optgroup label="Northern Ireland"> <option value="Antrim">Antrim</option> </optgroup> <optgroup label="Scotl...

When you have an error you set a session but then kill the script, thus the blank page.

Looks like you're missing semi-colons.

Hopefully you have learned what you need to know by now. For others running across this post, the OP has pretty much done everything you could possibly do wrong in this code. Problems include using dangerous, obsolete mysql code that has been completely removed from PHP, depending in the name of a b...

There is so much that needs to be changed that it would end up being a re-write. You cannot just add an i and make it mysqli. It would also be best to use PDO. If you decide to try this on your own, study this tutorial first. https://phpdelusions.net/pdo I understand if you cannot afford to hire som...

This is not a modification or conversion. This will require a complete re-write of your script. You should probably make a post in the "for hire" section.