Fermé

Simple PHP/MySQL Random String Generation w/Value

Right now I currently have a members system and each member has points. Its a type of fake online currency, it is their "balance" -- What we need done is pretty simple. We are going to give you an example then go into more detail.

Basically we need a "create points certificate" function on the members account panel. Lets say I have 50 points balance and I want to pay you for this coding work. You charge 20 points. So I would go to this new function, which has 2 text boxes. 1) points and 2) password. I would enter "20" under the points data box because that is how much you charge. Then I would choose a 4 digit numeric password (for security purposes) lets say "1234" -- I would then click a submit button "create" and it would generate a random 34 character string with a value of "20" and the pass "1234" Lastly, it would deduct 20 points from my account.

You, the seller, would go to the "claim certificate" function on your account panel. This function is even more simple. All you do is enter the 34 randomized string and the 4 digit password and click the submit button "claim" -- Then it would add the value (20) to your account.

To break it down into POSSIBLE coding lingo...

We would have 2 MySQL Tables. 1) Account and 2) Certificates

Okay so first we need to create the certificate. We would generate the random 34 character string with a value of ($variable) points. We would then use MySQL and insert a new line into the table "Certificates" -- There will be 3 fields: 1) Certificate String and 2) Password and 3) Value -- We will insert the 3 variables. For example [CCLN2NS8LuRKeTo8YmQaxBtmtenGnDgNLr, 1234, 20]

Then, the person accepting the payment. We will use the "Accounts" table and the "Certificates" table for a simple search. We want to search the "Certificates" database for the matching 2 variables [CCLN2NS8LuRKeTo8YmQaxBtmtenGnDgNLr, 1234] -- If not found, display the msg "Cannot find certificate!" if it IS found, then add the third fields variable, which is "Value" or "20" in our example -- This will always be a numeric number. Lastly we add that variable (20) to the persons "Balance" which is in the "Accounts" Table. Then we delete it so it can't be used again.

Thats it! I know its a lengthy explanation but to someone who is even just somewhat skilled at php/mysql it shouldn't take more than 1 hour. Its a long explanation because I wanted to give you the most detailed description possible.

Compétences : HTML, MySQL, PHP

Voir plus : what is string matching, what is search string, what is a search string, to string, text to string, text string search, string the, string search in c, string matching in c, string i, string find c, string 2, search text string, search string in c, search string c, search string, search c string, search character in string, random no generation in c, php mysql create, php find a person, pay someone to do coding, online coding certificate, new line in php, matching string

Concernant l'employeur :
( 0 commentaires ) edmonds, United States

N° du projet : #2362406

16 freelance ont fait une offre moyenne de 35 $ pour ce travail

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

60 $ USD en 1 jour
(384 Commentaires)
7.0
VileGnosis

Details in PMB

30 $ USD en 0 jours
(178 Commentaires)
6.6
webedict

HELLO SIR, READY TO START WORK. I HAVE 4 YEARS OF EXPERIENCE IN PHP, MYSQL, AJAX, JAVASCRIPT, XHTML. THANKS !!

40 $ USD en 3 jours
(61 Commentaires)
5.2
dazakeen

HI , I am ready to start

30 $ USD en 1 jour
(15 Commentaires)
4.7
pollux1er

I can do this for you!

30 $ USD en 0 jours
(27 Commentaires)
4.6
LogikaKita

Very clear description about the certificate thing, good example of buyer's attitude. Ready to do it for you and waiting to work with you!

40 $ USD en 1 jour
(26 Commentaires)
4.0
fensoft

I have over 30 years' IT experience. As you say, this is a fairly simple task. I can start immediately.

30 $ USD en 1 jour
(9 Commentaires)
4.0
piyushccet

Ready to get start immediately.

35 $ USD en 1 jour
(13 Commentaires)
3.5
k7moorthi

Hi Sir, I can do this. I have a better experience in PHP and MySQL. I have worked on many projects in PHP and MySQL. Please check your PMB for more...

30 $ USD en 1 jour
(3 Commentaires)
3.2
amilli21

Hi, I can have this done for you within 2 hours guaranteed

50 $ USD en 0 jours
(3 Commentaires)
3.2
jaypala

I am expert to this.

30 $ USD en 1 jour
(2 Commentaires)
2.3
marimphil

Ready to start now

30 $ USD en 1 jour
(0 Commentaires)
0.0
AdarshChacko

----------------------------------------

30 $ USD en 2 jours
(0 Commentaires)
0.0
nick43137

Hello, I am a new freelancer but I am more than capable of completing this project in about a day or less for your minimum price. This I fairly simple and I have an optimized idea on how to do it. Thank you for reading Plus

30 $ USD en 1 jour
(0 Commentaires)
0.0
Zuf9CYX74

Custom software development - <b><i>Removed by Admin</i></b>

40 $ USD en 1 jour
(0 Commentaires)
0.0
Simulator88

Try out us! You will not be disappointed.

30 $ USD en 0 jours
(0 Commentaires)
0.0