Need PHP to communicate with MySQL for SMS gateway

  • Posted
  • Proposals 0
  • Remote
  • #14365
  • Archived
  • 0

Description

Experience Level: Expert
I need a quote regarding a simple PHP page that communicates with a MYSQL database. The page will generate a dynamic code that does the following:

Person A - Inputs Name of Recipient, Phone Number and Message and their number.
This information is then input into a database under person A\'s phone number.
person A is then directed to a page which shows \'thank you your message has been sent\'. A Url is then generated for example .com/q=07540422011 which references that informaton within the database and sends this information as a url to the SMS service provider.

Using a form such as:

<script language=\"javascript\">

function limitLength(textarea,maxlimit)
{
if (textarea.value.length > maxlimit)
textarea.value = textarea.value.substring(0, maxlimit);
}

function validate()
{
var Prefix = \"0044\"

var ToMobile = window.document.SMSForm.ToMobile.value;
var FromMobile = window.document.SMSForm.FromMobile.value;
var ToName = window.document.SMSForm.ToName.value;
var FromName = window.document.SMSForm.FromName.value;
var Message = window.document.SMSForm.Message.value;

// Ensure To-Mobile number is international format &amp; from correct country
if (ToMobile.indexOf(Prefix)!=0)
{
alert(ToMobile + \" is not a valid Phone number.\");
return false;
}
// Ensure From-Mobile number is international format
if (FromMobile.indexOf(\"00\")!=0)
{
alert(FromMobile + \" is not a valid Phone number.\");
return false;
}

// Ensure names are filled in
if (ToName.length<3 || FromName.length<3)
{
alert(\"Your name must be between 3 and 11 letters long.\");
return false;
}

// To and from cannot be the same.
if (FromMobile == ToMobile)
{
alert(\"You cannot send a message to and from the same person\");
return false;
}

if (Message.length==0)
{
alert(\"Your message is blank. Please type a message in the box provided\");
return false;
}

return true;
}

</script>

The code generated needs to look like this:
http://web.testsite.co.uk/cgibin/
psmssend.pl?number=44777777771&user=yourusername&pass=yourpassword&message=test
message&pamt=50&network=VODAFONEUK

I\'ve been told for an expert this shouldn\'t longer than approx 30 min. Let me know what price you can do this for and a timescale. This is just one simple page in PHP (with Javascript) absolutely no design.

Clarification Board

    There are no clarification messages.