Re: web interface...

[Michael Johnson]

If you are looking at PHP, may I suggest the PEAR DB <URL: 
http://pear.php.net > family of classes? It implements functionality that 
I imagine is similar to perl's DBI interface.

<?php

require_once('DB.php');

// Note that database backend can be specified.
$db = DB::connect('mysql://username:[EMAIL PROTECTED]/database_name');
// Check for errors (should do this throughout :)
if (DB::isError($db)) {
  // do something
}
$data = $db->getAll('SELECT * FROM my_table');
// $data is now an array representing all the result rows from the query
$aRow = $db->getRow('SELECT * FROM my_table WHERE id = 345');
// $aRow is the first row from the query
// etc...

?>

HTH,
Michael
On Thu, 9 Oct 2003 15:53:45 -0700, Dathan Vance Pattishall 
<[EMAIL PROTECTED]> wrote:

If the are a UNIX CGI plant then they probably run PERL which then you
can use DBI; this is much different then writing HTML since PERL by
itself can't include raw imbedded html. So, I suggest using PHP it
should be easier for you to make a transition to then a pure old fashion
CGI script.
Look below

<?php

mysql_connect()

?>
<h2> I connected </h2>
<?php

# do something else

?>

<h2> More html </h2>

Check out www.php.net and PHP for programmers by WOX publishing. This
will help you out allot.
- Dathan Vance Pattishall
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688
-->-----Original Message-----
-->From: Dora [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, October 09, 2003 3:42 PM
-->To: 'Dathan Vance Pattishall'; [EMAIL PROTECTED]
-->Subject: RE: web interface...
-->
-->I m open to suggestions.  I use HTML and JavaScript regularly.  If I
-->have some sample code I could hack it do what I need.  My website is
on
-->a UNIX CGI plant form.
-->
-->What are your thoughts?
-->
-->Thanks
-->
-->-----Original Message-----
-->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, October 09, 2003 6:28 PM
-->To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
-->Subject: RE: web interface...
-->
-->
-->
-->
-->-->-----Original Message-----
-->-->From: Dora [mailto:[EMAIL PROTECTED]
-->-->Sent: Thursday, October 09, 2003 3:18 PM
-->-->To: [EMAIL PROTECTED]
-->-->Subject: web interface...
-->-->
-->-->
-->-->Hi
-->-->
-->-->I have used other relational databases but am new to my sql.
Where
-->can
-->-->I find documentation on how to connect my database to a web page?
-->
-->Depends which language your using. Perl, C++, Java, PHP, etc. all do
it
-->differently.
-->-->
-->-->Thanks
-->-->
-->
-->- Dathan Vance Pattishall
-->  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
-->  - http://friendfinder.com/go/p40688
-->
-->
-->
-->
-->


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
Michael Johnson < [EMAIL PROTECTED] >
Internet Application Programmer, Pitsco, Inc.
620-231-2424x516
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]