I'm trying to send a sms from my website to a user registered in the database.
On my first page (sendsms.jsp) i have a drop down menu that Selects all the Users from the MySQL database. And then a submit button to call the jsp page (smssent.jsp) necessary to perform the sending of the sms message. By the way I'm doing this with clickatell if anyone has used it before. I select one user from this drop down and hence it gets sent to one user.
Not too sure if I should have posted this here or in the other section ... anyway
What I have so far for the smssent.jsp is as follows:
Statement statement = null;
ResultSet resultset = null;
ResultSetMetaData rsmd = null;
Connection connection = null;
connection = DriverManager.getConnectio
statement = connection.createStatement
ResultSet rs = statement.executeQuery("SE
LECT * FROM Member WHERE UserName= method="post" action="http://api.clickatell.com/http/sendmsg?user=&password=&api_id=&to=&text=Meet+me+outside
user = "";
password = "";
api_id = "";
text = urlencode("Hi from ...");
to = Phone;
<p align="center"> </p>
Problem is sending it. What my intention is to select the User's phone no. from the database that equals to the member selected from the drop down menu. And to have a pre defined messsage like, "Hi bla bla bla". I probably need to have variables in there for some of the values?