(Apr 17, 2016 12:30 PM)+Haze Wrote:  In that case I would say learn PHP, understand how things work in PHP. Then learn how you can use PHP to create an API Endpoint that other devices can interact with.

(Apr 17, 2016 12:59 PM)Only3 Wrote:  tut http://www.visual-basic-tutorials.com/Tutorials/MsCodes/code8.htm
cmd http://www.w3schools.com/sql

(Apr 17, 2016 01:06 PM)Zilog80 Wrote:  Connect to MySQL from .NET using PHP? Really?
Maybe you need to connect it throught a wrapper coded in C++, and this C++ wrapper calls a VB5 wrapper and this one calls another COBOL app, and this finally call another wrapper coded in Delphi...[/ironic Mode off]

You only need the MySQL ".NET conector" available from dev.MySQL (http://dev.mysql.com/downloads/connector/net/) or the super-easy alternative: use NuGet Manager and simply use:

Install-Package MySql.Data

Once you have the MySql.Data reference into your project, all the CRUD operaciones are basically the same as SqlClient:

PHP Code


<?php 
Dim sqlConnection1 As New SqlConnection("Your Connection String")
Dim cmd As New SqlCommand
Dim reader As SqlDataReader

cmd.CommandText = "SELECT * FROM Customers"
cmd.CommandType = CommandType.Text
cmd.Connection = sqlConnection1

sqlConnection1.Open()

reader = cmd.ExecuteReader()
' Data is accessible through the DataReader object here.

sqlConnection1.Close() 


Instead SqlConnection type you should have MySqlConnection type, instead SqlCommand you should have MySqlCommand, instead SqlDataReader you have MySqlDataReader,...