Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
SMS Server connect with MySql in XAMPP
sp_NewPost Add Reply sp_NewTopic Add Topic
December 12, 2011
2:31 pm
Henk Helmantel
Guest
Guests

Hi Alvin,

If you can provide me with a short description of your project, the details of your educational institution and an email address from this institution then I am sure we can work something out. You can send the information to dms@diafaan.com.

Regards, Henk

December 12, 2011
9:23 am
Alvin
Guest
Guests

And the presentation for my FINAL YEAR PROJECT will be on mid of January 2012 which if i can have another 30days free try it will help me alot.

Thanks

December 12, 2011
9:18 am
Alvin
Guest
Guests

Hi Henk,

I would like to ask, the free of charge testing for me left 13 days if i uninstall and install again will it able to reset the time? I using your software as part of my FINAL YEAR PROJECT work.

December 9, 2011
3:00 pm
Henk Helmantel
Guest
Guests

For information on how to use the Web Connector to send messages see: http://www.diafaan.com/manuals/diafaansmsserver/index.html?http_api.htm

You can also use the SMSOut database table with the SQL Connector to send messages:
http://www.diafaan.com/manuals/diafaansmsserver/index.html?connect_to_a_database.htm

Henk

December 9, 2011
12:32 pm
Alvin
Guest
Guests

Hi Henk

I now having another problem is that, how can I get the information from my web application to the sms server to send message?

December 7, 2011
10:46 am
Alvin
Guest
Guests

Hi Henk

Thanks for your guidance. My sms information has successfully stored in the database.

December 6, 2011
2:32 pm
Henk Helmantel
Guest
Guests

I am not sure what you mean with this question. If you set up the Web Connector to forward the received messages to a web server then the PHP script can take care of handling the received messages.

The PHP script can parse the message and put it in a database or return an SMS response back to the Web Connector.

Regards, Henk

December 6, 2011
12:29 pm
Alvin
Guest
Guests

I have enter the parameter that you have show to me. But then in the web page I do not see any message?

December 6, 2011
9:48 am
Henk Helmantel
Guest
Guests

Hi Alvin,

[from][message-text] is not a valid query string template, the query string template should be:

from=[from]&message=[message-text]

The PHP snippet that I wrote was not exactly right (I don't use PHP much). This should be:

$fromAddress = $_GET["from"];
$messageText = $_GET["message"];

Regards, Henk

December 6, 2011
9:08 am
Alvin
Guest
Guests

I try use the parameter you specify but then it still got the problemm.
I have create a file called smsresponse.php then inside the name i write in

Then I tick the box "Forward received SMS message to website" and I enter the Web Page Address:
http://localhost/cutting/smsresponse.php

Parse error: syntax error, unexpected '=' in C:xampphtdocscuttingsmsresponse.php on line 3

December 5, 2011
2:07 pm
Henk Helmantel
Guest
Guests

The actual HTTP parameters that are sent from the Web Connector to the PHP script depend on the query string template. With a default query string template and the default GET method the parameters are from and message. In PHP these parameters can be fetched with:

fromAddress = $_GET["from"];
messageText = $_GET["message"];

Regards, Henk

December 5, 2011
2:13 am
Alvin
Guest
Guests

Can I have a sample of PHP script for SMS Gateway to Website?
Because I do not know what parameter to declare to pass the value from the SMS

Thanks

December 4, 2011
8:42 pm
Henk Helmantel
Guest
Guests

The Web Connector can be used to forward received SMS messages to the web server running the PHP script. The HTTP options can be set on the Receive SMS page in the Web Connector properties.

Sending a Get or Post command makes no difference, you can choose either one. In the query string template you can specify which parameters are sent to your PHP script.

Regards, Henk

December 4, 2011
3:35 pm
Alvin
Guest
Guests

If I using the PHP script how I echo out the message from the sms to the webpage?
And for the HTTP method I should use the POST or GET method?

Thanks

December 4, 2011
10:32 am
Henk Helmantel
Guest
Guests

Good to hear that you got it working.

The SQL Connector writes the whole received message in the database, it has no capabilities to parse the received message and write parts of the message in separate database fields.

If you need to interpret the received message before writing it to a database then you could use the Web Connector to send the messages to a PHP script and use this script to break up the message and write it to the database. You could also use a Scripting Connector and write a C# or Visual Basic.NET script but I think for your setup the PHP route would be easier.

Regards, Henk

December 4, 2011
3:47 am
Alvin
Guest
Guests

I have done the connection string. Thanks.
I have another problem is that, can i set the format of the SMS so that I can retrieve the data and get information insert to the table I want?
Let say I have a table in my database called appointment and this table wants contact number, time, and date. So, can I set the format to require the user SMS with this format and after I receive it then pass to appointment table?

Thanks

December 2, 2011
2:35 pm
Henk Helmantel
Guest
Guests

The error message you get indicates that there is something wrong with the MySQL ODBC driver on your computer, I really could not tell you how to solve this.

If the MySQL 5.1 ODBC driver is installed properly on your system you should not see the ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified error message for a connection string starting with
Driver={MySQL ODBC 5.1 Driver}.

Regards, Henk

December 2, 2011
2:13 pm
Alvin
Guest
Guests

Sorry for that I do not understand what I need to do in ODBC and the SMS Server connection string. Can you please tell me?

December 2, 2011
1:30 pm
Henk Helmantel
Guest
Guests

Hi Alvin,

If you get the same error message then there might be something wrong with the MySQL ODBC setup on your system. I recommend asking a system- or database administrator to help you figure out what the problem is.

Regards, Henk

December 2, 2011
1:07 pm
Alvin
Guest
Guests

I have add a Data Source Name in ODBC administrator. Do I choose a database when add the new data source name? Because when i create the new data source name i choose the database in XAMPP. Is it correct? But then after i type the connection string again in SMS Server it show error again.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488