Re: web interface...
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]
RE: web interface...
Hi Dora! It depends what are you looking for. I can help you in Java via Netbeans (TM), or look on the netbeans.org mailing list, where is a subject proposed by me, and I have answers directly from sun. Best regards On Thu, 9 Oct 2003 18:40:25 -0400, Dora wrote Thank you. I'd like to do it myself though. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: web interface... There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: Dora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:21 PM 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? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illyes Teaching-assistant Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] RE: web interface...
On Thu, Oct 09, 2003 at 06:41:42PM -0400, Dora wrote: 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. I'd suggest PHP. Perl, PHP and to a lesser degree, C and Python, are the popular languages for doing interactive web development on Unix/Linux. I admittedly haven't played with Python yet, but PHP is quite easy to pick up, and from what I've seen of JavaScript, will probably be the closest to what you're used to. YMMV and everyone here will have different suggestions. :^) The aforementioned MySQL: The definitive guide... by Paul DuBois, published by New Riders, is where I first picked up PHP, and seems to be a most excellent book on MySQL in general. :) http://www.nerdbooks.com/item.php?id=0735712123 Good luck! -bill! [disclaimer: I'm consulting for Nerdbooks :^) ] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Re: web interface...
There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: Dora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:21 PM 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? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web interface...
Thank you. I'd like to do it myself though. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: web interface... There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: Dora [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:21 PM 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? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
Martin Gainty wrote: There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty Who am I missing? I only counted 997. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Re: web interface...
On Thu, 9 Oct 2003 18:41:42 -0400, Dora [EMAIL PROTECTED] wrote: 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. Add PHP to your list of skills. There is so much documentation on this on the internet -- and so much sample code -- it will make your head swim. Start with google. Proceed intelligently. -bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
Dora wrote: 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 PHP... http://www.php.net And if PHP isn't doable, Perl. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: web interface...
Dont worry The indians will put 3 more of us out of work by tommorrow am! -M - Original Message - From: John Nichel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 6:45 PM Subject: Re: web interface... Martin Gainty wrote: There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty Who am I missing? I only counted 997. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web interface...
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]
Re: Web interface
I started using MySQL about two months ago (and I already love it!) and I'm new to this list... I would like to know if there's some web interface for MySQL management that has been released as open source. Preferably this should be in ASP 3.0 or ASP .NET languages, but I'll appreciate to know any other language available. Thank to everyone who'll spent time to send me a fee-back. Have you been using it under a rock?? ;) PHPMyAdmin is probably the most popular. It's written in PHP, of course. http://www.phpwizard.net/projects/phpMyAdmin/ I don't know of any ASP solutions and I'm sure you'd have to pay for them. ---John Holmes... - 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
Re: Web interface
I am using phpMyAdmin. But it is written in php. Regards, KH Hi all! I started using MySQL about two months ago (and I already love it!) and I'm new to this list... I would like to know if there's some web interface for MySQL management that has been released as open source. Preferably this should be in ASP 3.0 or ASP .NET languages, but I'll appreciate to know any other language available. Thank to everyone who'll spent time to send me a fee-back. Regards, Michele http://www.devspy.com/ - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - 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
RE: Web interface and backup
As to your second question, I'd /highly/ recommend http://phpwizard.net/projects/phpMyAdmin/. I use it to manage all the databases where I work, and have had very few problems with it. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Kory Wheatley [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:14 PM To: [EMAIL PROTECTED] Subject: Web interface and backup I have two questions. (If you would be so kind to respond I would appreciate it) 1. What is the best way, or correct way to backup the MYSQL databases. I thought shutting the server then perform the backup, so that there are no connections to the databases? 2. What's the best command graphic interface for MYSQL, to be able to perform querys with a web interface? -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Web Interface
Thanks to everyone who replied. I got a lot of people who said I should either use phpMyAdmin or webadmin. It turns out that neither will quite do what I need it to, and I just wanted to try to get any other suggestions. In particular, the former doesn't allow one to put any kind of good security on the pages s.t. a user needs a password to do things, w/o a good deal of recoding. The latter requires root access on a server, which I don't have. Does anyone have any other suggestions? There's something written in Perl called "MysqlTool". It looks good. Haven't really used it seriously yet. You can find it at: http://www.dajoba.com/projects/mysqltool/index.html Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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
RE: Web Interface
Webmin is robust and it gives a good database interface... You can customize it to only perform Database Administration Check www.webmin.com Regards Claudio -Mensaje original- De: John Williams [mailto:[EMAIL PROTECTED]] Enviado el: Saturday, February 03, 2001 4:44 PM Para: [EMAIL PROTECTED] Asunto: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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
Re: Web Interface
http://www.php.net/ http://httpd.apache.org/ John Williams wrote: I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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
RE: Web Interface
Webmin www.webmin.com -Original Message- From: John Williams [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 03, 2001 1:44 PM To: [EMAIL PROTECTED] Subject: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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
Re: Web Interface
You might want to try the php-nuke 'construction kit'. Looks good (www.wageningen.org was build using this, take a look) - Original Message - From: "John Williams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 8:44 PM Subject: Web Interface I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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
Re: Web Interface
Thanks to everyone who replied. I got a lot of people who said I should either use phpMyAdmin or webadmin. It turns out that neither will quite do what I need it to, and I just wanted to try to get any other suggestions. In particular, the former doesn't allow one to put any kind of good security on the pages s.t. a user needs a password to do things, w/o a good deal of recoding. The latter requires root access on a server, which I don't have. Does anyone have any other suggestions? Thanks again, John On 3 Feb 2001, at 19:44, John Williams wrote: I'm running MySQL 3.22.32 on Linux. I was wondering if anybody knew of a good robust program to put a web interface on a database so that it can be viewed and modified by people who don't know SQL syntax. Thanks, John _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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