VB.net Connect to Online MySQL through PHP Web Service.

Question

0.00/5 (No votes)

See more:

Hi All,

Kindly note that I'm new to this forum. Hope that you can help me.

I have a VB.Net application that must connect to online MySql database.
I already have a MySql database and I connected to it from VB.net using the MySql connector (new instance and direct connect).

All I want to do is to connect to this database via a PHP web service, this will make a fast connection and more users can be connected at the same time.
I tried to search for this, and I think that the solution is easy and simple, but I don't know a lot about PHP; how to upload files and connect via Web service Reference in VB.net.

I downloaded these files: RemoteMySQLDatasetWS.zip And RemoteMySQLTest.zip. from: http://code.google.c.../downloads/list. which contains ".php" / ".wsdl" / ".dll" files and a VB.Net test solution.
I uploaded the files (".php" / ".wsdl" / ".dll") to the FTP manager in the cPanel where I created the database.
The problem is,
First: I don't know if these files are working.
Second: i tried many time to access the file "server.php" without any result.
I'll be thankful if you can help me solve this problem.
However, if the question wasn't clear or if anyone has another solution, please let me know it. It will be very helpful.

Thank you.

Posted 2-Jan-12 5:34am

Elie_86

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kevin Schaefer · Answer 1 · 2012-01-03T10:02:00

You could maybe try posting data to the php app, the having the php decode what you posted and executing the mysql query and optionally returning some output. The VB.net would just "download" the php file using http(s).

You can get the POST data from requests in php with:

PHP

$post = $_POST['var_name'];
//do something with the post data
print "Any output text, including this, is what gets sent back";
print " to your vb.net app.";

Let me know if this helps!

Elie_86 · Answer 2 · 2012-01-03T19:20:00

Hi
Thank you for your kind reply, I appreciate it a lot as you are trying to help me.
Kindly note that I will try your idea in a simple PHP example and return to you as soon as possible.
Mean while, do you have any idea on how to connect to as online MySQL from VB.net without using the MySQL connector?
It could be PHP, Java. Someone told me that there's a protocol called WAMP.

Thank you again.

itzuqkhie · Answer 3 · 2013-04-12T00:10:00

Solution 3

Up Up for this Question!
I've search how to create this but no luck..>

Please anyone answer his question....

Posted 12-Apr-13 0:10am

itzuqkhie

VB.net Connect to Online MySQL through PHP Web Service.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0