Re[2]: Mysql Web interface for normal Users
Hi! Just wanted to bring up an old topic - the situation with mysql web clients is the same as last year or is there any new good software? Something that would be easy to use and look nice to the users? I'm also looking for something quite simple yet enough customizable. Thanks! Martins Tuesday, November 7, 2006, 6:29:37 PM, you wrote: Return-Path: [EMAIL PROTECTED] Received: from murder ([unix socket]) by mx.dmmc.lv (Cyrus v2.2.12-Gentoo) with LMTPA; Tue, 07 Nov 2006 17:32:33 +0200 X-Sieve: CMU Sieve 2.2 Received: from localhost (localhost [127.0.0.1]) by mx.dmmc.lv (Postfix) with ESMTP id 7D44B376740 for [EMAIL PROTECTED]; Tue, 7 Nov 2006 17:32:33 +0200 (EET) X-Virus-Scanned: amavisd-new at Received: from mx.dmmc.lv ([127.0.0.1]) by localhost (mx.dmmc.lv [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qHBWBUTiWlZx for [EMAIL PROTECTED]; Tue, 7 Nov 2006 17:32:27 +0200 (EET) Received: from lists.mysql.com (lists2.mysql.com [213.136.52.31]) by mx.dmmc.lv (Postfix) with SMTP id 83D9235E42D for [EMAIL PROTECTED]; Tue, 7 Nov 2006 17:32:27 +0200 (EET) Received: (qmail 17155 invoked by uid 510); 7 Nov 2006 15:26:43 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:mysql@lists.mysql.com List-Archive: http://lists.mysql.com/mysql/203189 Delivered-To: mailing list mysql@lists.mysql.com Received: (qmail 12711 invoked by uid 509); 7 Nov 2006 15:25:40 - Received-SPF: pass (lists.mysql.com: domain of [EMAIL PROTECTED] designates 217.169.24.120 as permitted sender) Message-ID: [EMAIL PROTECTED] Date: Tue, 07 Nov 2006 15:29:37 + From: Jonathon Wardman [EMAIL PROTECTED] User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com, Anthony [EMAIL PROTECTED] Subject: Re: Mysql Web interface for normal Users References: [EMAIL PROTECTED] [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Vittorio Zuccalà wrote: Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode it will ask the user for their user name and password and use that information to decide which databases they have access to. - Jonathon Wardman, flutt.net -- Best regards, Martinsmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Web interface for normal Users
Hello, i am looking for a simple Web interface, for normal users (non admin), that will only have access to their Database, and have the possibility to manage their tables (create,delete,insert,...). for root access, i already have phpMyAdmin installed on the server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Web interface for normal Users
Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Web interface for normal Users
Vittorio Zuccalà ha scritto: You can also use phpmyadmin for normal user. In my organization i use it for all users... Uff... I didn't remember... If it is not enought you can use Dadabik (www.dadabik.org) It is great: do not be impressed from its simple interface. It is very completed software :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Web interface for normal Users
Vittorio Zuccalà wrote: Anthony ha scritto: for root access, i already have phpMyAdmin installed on the server. You can also use phpmyadmin for normal user. In my organization i use it for all users... Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode it will ask the user for their user name and password and use that information to decide which databases they have access to. - Jonathon Wardman, flutt.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
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
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
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]
Web interface
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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
Another one on lost connections( using web interface)
I also have a problem with lost connections. I have small mysql database (version 3.23.49 on FreeBSD 4.5) I have created a website interface to enter and retrieve data. I used ASP to do this. Sometimes when I go to the website I get the error can't connect or lost connection to server. The mysql install has been done with default settings and There are never more than 2 people using the database at the same time. I also created a PHP interface to the database and I received the same error. The error does not occur all the time and when it occurs it goes away by refreshing the web browser. I never have any problems when working on the mysql server from the command line. Any ideas? - 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: Another one on lost connections( using web interface)
PHP's more than likely just loosing persistent connections to the DB. It's a coding thing I think... You need to call mysql_connect() on every page where you need to use the database, even if you use mysql_pconnect(). If there's a mysql specific error, I think MySQL would most definitely write something to the error log... Tweaking your my.cnf and php.ini may also help you cause here... -- me - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 11:25 PM Subject: Another one on lost connections( using web interface) I also have a problem with lost connections. I have small mysql database (version 3.23.49 on FreeBSD 4.5) I have created a website interface to enter and retrieve data. I used ASP to do this. Sometimes when I go to the website I get the error can't connect or lost connection to server. The mysql install has been done with default settings and There are never more than 2 people using the database at the same time. I also created a PHP interface to the database and I received the same error. The error does not occur all the time and when it occurs it goes away by refreshing the web browser. I never have any problems when working on the mysql server from the command line. Any ideas? - 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
Newbie question : Can't connect to database through a web interface
Hi, I'm developing a web application using mysqld as a localhost but accessed from anywhere. My problem is simple, after entering form data, and execute the php script, always returns an error I wrote in case of unsuccesful connection to the db. I did everything , create a user with many privileges, then flushed the privileges, if I use PhpMyAdmin to access the db I have no problems, the error happens when I use my program, what can be wrong here are the lines I use to connect to the db and display error message: @ $db = mysql_pconnect(localhost, testdb, test123); if (!$db) { echo Error: could not connect to database. Please try again later.; exit; } mysql_db(mydb); ... What can be wrong ? I'm starting to learn both php and mysql and I still can't understand why this happened. Regards, Rick AmpaSA Engineering - 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: Newbie question : Can't connect to database through a web interface
Type this line of code before your line $db = mysql_pconnect(localhost, testdb, test123) or die(mysql_error()); The error u get will be pretty descriptive. If not revert back to me. nev L. -Original Message- From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] @ $db = mysql_pconnect(localhost, testdb, test123); if (!$db) { echo Error: could not connect to database. Please try again later.; exit; } mysql_db(mydb); ... What can be wrong ? I'm starting to learn both php and mysql and I still can't understand why this happened. Regards, Rick - 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
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
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
Webdata Pro, an easy web interface for MySQL
This may be of interest to newbies that would like a point-and-click method of building their web database tables, queries, forms, and reports in MySQL. http://webdatapro.com Description: Easily create relational database solutions online, requires no programming or SQL knowledge. Provides the admin a point-and-click path through: building tables, designing search pages managing records, configure shopping cart and defining member accounts. Import data and upload images or documents through the browser. Creates complex JOIN queries automatically. Customized reports can be generated using any HTML editor. How is this different from PHP? It's easier. The admin can configure the entire design 100% without knowing a single bit of SQL. One of our users wrote: Most all php data application are for specific-type databases, such as address books or member directories. If you want to use one, you have to modify it by hand which is complicated. With WebData Pro, it is generic, you can setup any type of database, relational or otherwise. Outstanding support is offered through an online BBS. Webteacher Software, LLC 'Webdata' - the first EASY database for the web 'JavaScript for the Total Non-Programmer' 'CGI for the Total Non-Programmer' http://www.webteacher.com mailto:[EMAIL PROTECTED] - 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? 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
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
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