how connect mysql database in host

[jr_ozv]

hi
i want connect to mysql database in host
i install mydac component in delphi but closed 3306 port

Friends had suggested use php web service for connect database

How it should be done?

have example?

tnx

[kolbasz]

Did you install a mysql server to your computer or do you want to connect to a remote computer? Please be more specific!

[jr_ozv]

i want connect to remote compure

[kolbasz]

i want connect to remote compure

Then make sure:
1. Remote access is enabled on the mysql server
2. A firewall/AV doesn't block your connection

Remote access is usually disabled for security reasons, so probably the best solution is to use a php webservice to communicate with the mysql service. You can send Get and Post commands from delphi with TIdHttp(just google it), and read the response.

[jr_ozv]

have you example ?

if have , plaease uploud.

tnx

[kolbasz]

have you example ?
if have , plaease uploud.
tnx

Tested with Delphi XE2 and PHP 5.4.25. This will add two numbers, but you can do more complex operation, like read data from table, send receive images, etc...

1. Delphi

Drop a TidHTTP component and a TButton to your form. Doubleclick the button:

procedure TForm1.Button1Click(Sender: TObject);
var
  url: string;
  SS: TStringStream;
  SL: TStringList;
begin
  url := 'http://localhost/Delphi.php'; //<--change this to your URL
  SL := TStringList.Create;
  try
    SL.Add('a=' + IntToStr(4));
    SL.Add('b=' + IntToStr(5));
    SS := TStringStream.Create('');
    try
      IdHTTP1.Post(URL, SL, SS);
      ShowMessage(ss.DataString);
    finally
      SS.Free;
    end;
  finally
    SL.Free
  end;
end;

2. PHP(save this to delphi.php, and upload to your server)

<?php
  $a=$_POST['a'];
  $b=$_POST['b'];
  echo $a + $b;
?>

[jr_ozv]

thank you my dear friend
very gooood

[Rantor777]

HTTP Tunneling is the Answer... Sorry. Late Reply.

Regards!