I read UTR 1 -- it only describes the Windows implementation, with
the user manually storing hostname in some internal Windows location.
I'm running on a Linux system controlled by GoDaddy.
You'll note from the PHP example code, that the hostname is
a run-time parameter, which the Unicon open( "o" ) function
does not accept.
Dick McCullough
http://mkrmke.org
----- Original Message -----
From: "Clinton Jeffery" <clint.jeff...@gmail.com>
To: "Richard H. McCullough" <r...@pioneerca.com>
Cc: "Unicon group" <unicon-group@lists.sourceforge.net>; "Paola Di Maio"
<paoladimai...@googlemail.com>
Sent: Friday, July 24, 2009 1:56 AM
Subject: Re: [Unicon-group] Unicon interface to MySQL database
> Richard,
>
> Unicon has been used heavily with MySQL.
>
> The documentation is the Unicon book chapter on databases, or UTR 1.
>
> The short summary is: make sure ODBC is setup right, make sure MySQL
> account is setup with right permissions and password, call open() with the
> correct mode letter and other parameters, call sql() and call fetch() a lot.
>
> Cheers,
> Clint
>
> On Thu, Jul 23, 2009 at 11:45 PM, Richard H.
> McCullough<r...@pioneerca.com> wrote:
>> Are they compatible? If so, how do I do it?
>>
>> I am using GoDaddy web hosting -- virtual dedicated Linux.
>> They supply MySQL 5 with InnoDB engine.
>> Their sample PHP interface is
>>
>> <?php
>> //Connect To Database
>> $hostname='p50mysql145.secureserver.net';
>> $username='mkr0905703223506';
>> $password='your password';
>> $dbname='mkr0905703223506';
>> $usertable='your_tablename';
>> $yourfield = 'your_field';
>>
>> mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to
>> database! Please try ag
>> in later.');
>> mysql_select_db($dbname);
>>
>> $query = 'SELECT * FROM $usertable';
>> $result = mysql_query($query);
>> if($result) {
>> while($row = mysql_fetch_array($result)){
>> $name = $row['$yourfield'];
>> echo 'Name: '.$name;
>> }
>> }
>> ?>
>>
>> Dick McCullough
>> http://mkrmke.org
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Unicon-group mailing list
>> Unicon-group@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/unicon-group
>>
>>
>
>------------------------------------------------------------------------------
_______________________________________________
Unicon-group mailing list
Unicon-group@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/unicon-group
