Freelancer

Need PHP to communicate with MySQL for SMS gateway  

Need PHP to communicate with MySQL for SMS gateway is project number 561452
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 11/30/2009 at 18:49 EST

Bid Count: 11

Average Bid:
$ 47

12/05/2009 at 18:49 EST

Project Creator: freesmstexts
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

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.

Messages Posted:1 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

30

1 day

12-01-2009 02:06 EST

We ready to finish it. Fast and accurate. THANKS

help

 

200

1 day

12-01-2009 02:09 EST

Easy job. Given SMS and PHP/MySQL frontends is my daily job since 2001. See Global.AQ and Kannel.org for past work.

help

 

30

1 day

11-30-2009 19:26 EST

See PM. Thanks.

help

 

30

1 day

11-30-2009 18:53 EST

(No Feedback Yet)

I can do this

help

 

30

1 day

11-30-2009 19:14 EST

(No Feedback Yet)

Like you said, 30 minute job!

help

 

30

0 days

11-30-2009 21:55 EST

(No Feedback Yet)

Ready to work on this, 30 minute job - as you said. Thank you!

help

 

30

1 day

11-30-2009 23:21 EST

(No Feedback Yet)

I have done the similar sms sending options. If you have interested please let me know.

help

 

30

2 days

12-01-2009 01:56 EST

(No Feedback Yet)

Send me more details

help

 

30

1 day

12-01-2009 03:42 EST

(No Feedback Yet)

I have three year experience in PHP and have done several projects in PHP/My sql. I am confident of doing this task within the timeframe. Hope to hear more from you.

help

 

35

1 day

12-01-2009 09:08 EST

(No Feedback Yet)

Plz see pm for my detailed work

help

 

40

1 day

12-01-2009 20:24 EST

(No Feedback Yet)

ready to begin

help


    Bid on this Project