Hi,
It's more comfortable(and sure) if you use C API of MySQL.Order of (few of
the main) functions to be executed is :
mysql_init -initialise MYSQL struct
mysql_options -set options for connection
mysql_real_connect -this function make all for you, from connection point
of view(create socket,setting socket,open socket for read/write....)
...and after this,
mysql_real_query -send query to server
mysql_store(or use)_result -store the result of query in to ,let's say,
recordset
mysql_fetch_field -retrieve data about fields
mysql_fetch_row -retrieve data from row
mysql_free -release memory by recordset
mysql_close -close connection
....now(i think), you can look in documentation to read carefully, all about
C API function.
If you really interested to make your own connection and "channel" for
communication with RDBMS, you must use a data structure(protocol) which must
be "understandable" by the server...and all become very sophisticated.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "justin cunningham" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 11:08 PM
Subject: example connecting to database via socket instead of networking
> Hi list, can someone here give me a quick and dirty example of how there
> connecting to a database via sockets? I see the data in the man page
> but I'm uncertain as to implementation. Thanks, justin
>
> Sql,query
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
