Need PHP to communicate with MySQL for SMS gateway
5255
£250(approx. $314)
- Posted:
- Proposals: 0
- Remote
- #14365
- Archived
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 & 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.
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 & 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.
A C.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
4 Dec 2009
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies