1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, mySQL,inifiles, Unit4, Grids, DBGrids, DB;
type
TForm1 = class(TForm)
DBGrid1: TDBGrid;
dts: TDataSource;
procedure FormCreate(Sender: TObject);
private
{ Déclarations privées }
public
{ Déclarations publiques }
end;
function connexion(ip,username,password,base,resultat:string):string;
var
Form1: TForm1;
read: array of string;
FichierIni : TIniFile;
mysql : PMYSQL;
myrow : PMYSQL_ROW;
myres : PMYSQL_RES;
mycout : longword;
ligne:string;
I: Word;
implementation
function connexion(ip,username,password,base,resultat:string):string;
begin
mysql := mysql_init(nil);
if mysql_real_connect(mysql, PAnsiChar(ip), PAnsiChar(username), PAnsiChar(password), PAnsiChar(base), 0, nil, 0) <> nil then
begin
end
else
begin
showmessage('La connexion a mysql a échoué');
end;
end;
{$R *.dfm}
procedure TForm1.FormCreate(Sender: TObject);
begin
FichierIni:=TIniFile.Create(ExtractFilePath(Application.ExeName)+'config.ini');
SetLength(read, 5);
read[0]:=FichierIni.ReadString('mysql','ip','0');
read[1]:=FichierIni.ReadString('mysql','username','n');
read[2]:=FichierIni.ReadString('mysql','password','n');
read[3]:=FichierIni.ReadString('mysql','base','n');
connexion(read[0],read[1],read[2],read[3],read[4]);
mysql_query(mysql, pChar('select * from phpbb_smilies'));
myres := mysql_store_result(MySQL);
mycout := mysql_num_fields(myres);
myrow := mysql_fetch_row(myres);
while myrow <> nil do begin
for I := 0 to mycout - 1 do begin
//myrow[i];
end;
myrow := mysql_fetch_row(myres);
end;
end;
end.
------------------------- |
