: How to implement a software trial request form? On my company's website I want to have a form where a visitor can provide an email address and pass an anti-bot challenge. The server would

@Pope3001725

Set a DB with "key", "status", and "client" fields.
Search the client email in the DB
If exists, send the asociated key
Else, query the DB looking for the first key with status "not activated" or something like that and echo it.


form.php
Just a normal form with email and submit. Should use method POST to validate.php

validate.php

<?php
$dbhost = $host; //Use a require file to load your data or replace this ones
$dbname = $base; //
$dbuname = $user; //
$dbpass = $pass; //
$email = $POST_["email"];
$TableName = "keys";
$Link = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuname, $dbpass);
$Query = "SELECT * FROM $TableName WHERE email LIKE $email";
$Result = $Link->query($Query);
if (!$Result) {
$Query = "SELECT * FROM $TableName WHERE status LIKE 'inactive' LIMIT 1";
$Result = $Link->query($Query);
echo $row[key];
} else {
while ($row = $Result->fetch(PDO::FETCH_ASSOC)) {
echo $row[key];
}
}
?>


You probably should add another exception in case there is no keys left and also complete the PHP code in the validate.php (right now it just echoes the keys).

Vote Up Vote Down

@Gretchen104

Hosting with cPanel, MySQL and PHPMyAdmin (which gives you access to the backend of the database(s)) should be sufficient. Any web scripting language could do what you want, so it may be best to let the person you hire choose. PHP is an obvious choice, and when you want something changed it's likely you could find someone else to help you if the original person isn't even available.

Vote Up Vote Down