Re: User interfaces for mysql

2010-12-09 Thread James Fait
On Thu, 2010-12-09 at 16:31 -0500, Larry Linder wrote:
> Have a nice set of  interfaces for humans.  Planed to use php scripts 
> to 
> insert data into data base.   However there is a catch to this scheme the php 
> is a server side script and will not execute - or at least I couldn't get it 
> to run under a brouser interface.
> 
> Have been looking at "wxpython" 
> 
> Any sugestions other than shoot myself.
> 
> Thanks
> Larry Linder

Unfortunately, there is not an easy way to do this short of installing a
web server on the local machine to host the php scripts.  However,
wxPython is a very viable interface to use for this type of interaction,
and python has a reasonable mySQL interface.  There is a good interface
builder for wxWidgets, including wxPython, called wxGlade, that will do
the messy stuff of layout, etc. for you, so all that you do is write the
logic behind the GUI.  wxGlade is available at
http://wxglade.sourceforge.net .

Hope this helps.

Jim

-- 
James Fait, Ph.D
Beamline Scientist
SER-CAT, APS
Argonne National Laboratory
Building 436B-008
9700 S. Cass Ave.
Argonne, IL 60439

Email: f...@anl.gov
Phone: 630-252-0644
Fax:   630-252-0652


Re: User interfaces for mysql

2010-12-09 Thread Mark Stodola

Larry,

Could you elaborate on this.  I'm having trouble following what exactly 
you are trying to accomplish.  If you want to provide a web interface to 
a mysql database using php, this is certainly possible.  You'll need 
apache, php, php-mysql all installed and functioning.  If you've written 
your php properly and have apache set correctly, the php will be 
interpreted and executed by apache when the clients visit, with your 
script outputting html back to the client.


I lose you when you say it will not execute, and then talk about the 
browser interface.  Have you checked apache's error logs? Are you trying 
to get the php to run on each client?  If so, then a web browser is not 
the way to go, unless you write a java applet to handle this, which will 
end up sandboxed.


Cheers,
Mark

Larry Linder wrote:
Have a nice set of  interfaces for humans.  Planed to use php scripts to 
insert data into data base.   However there is a catch to this scheme the php 
is a server side script and will not execute - or at least I couldn't get it 
to run under a brouser interface.


Have been looking at "wxpython" 


Any sugestions other than shoot myself.

Thanks
Larry Linder
  



--
Mr. Mark V. Stodola
Digital Systems Engineer

National Electrostatics Corp.
P.O. Box 620310
Middleton, WI 53562-0310 USA
Phone: (608) 831-7600
Fax: (608) 831-9591