May I suggest PHP wrapped around XML/XSLT/XSL-FO and XUL

:D



> Hya Jon,
> 
> The easiest way I found is to use html forms inside php code.
> I written a database with select from and insert into via a web page
> frontend. Php is not far different from perl, and like most good Linux
> apps there is heaps of docs at the php web site
> (http://www.php.net/manual/en/).
> If you would like some pointers email me off list and I will be glad to
> help.
> 
> 
> On 2 Jan 2003, Jon Miller wrote:
> 
> > Daniel I'm using phpMyAdmin, but it does not all ow me to create a
> > front-end that my wife can use or anyone in the office could use unless
> > you do a browse of the entire database or know the command set to query
> > the database.  This isn't what I'm looking for.  What I'm after is a
> > tool or program that will allow us to develop a web page where the user
> > can pull up and enter values in certain fields and the results should
> > show up.  New data should be able to be inputted into a new or the same
> > form.  But the whole system needs to be web-based via a browser.
> > I was told by a friend that he used MS Frontpage to develop these
> > frontend systems and it just makes a connection to MySQL database of
> > some of the others.  Also I've been told that Dreamweaver does the
> > same.  But I'm looking for a product/program that runs in Linux not MS
> > Windows.
> > 
> > Jon
> > 
> > On Wed, 2003-01-01 at 22:24, Daniel Pearson wrote:
> > > Have you considered using something like phpMyAdmin?
> > > 
> > > Daniel
> > > 
> > > ----- Original Message -----
> > > From: Jon Miller <jlmiller@mmtnetworks.com.au>
> > > To: plug <plug@plug.linux.org.au>
> > > Sent: Wednesday, January 01, 2003 10:23 PM
> > > Subject: Re: [plug] auto-increment in mysql
> > > 
> > > 
> > > > I would like to know what application most folks find good and 
easy to
> > > > use when creating a web-based front-end for a MySQL database.  I've
> > > > heard MS Frontpage is one, but I want a Linux (RH) package if 
possible.
> > > > It really would not make a difference where the field was in the
> > > > database I guess as long as it can be manipulated in the front-end
> > > > system.
> > > > This is a test system I'm designing to get a feel for MySQL and
> > > > Web-based systems.
> > > >
> > > > Thanks
> > > >
> > > > On Wed, 2003-01-01 at 22:05, Daniel Pearson wrote:
> > > > > Get a dump of the table.. then modify the order, and copy the 
commands
> > > and
> > > > > paste them back through the command line, maybe - or get it to 
input
> > > data
> > > > > from the text file.
> > > > >
> > > > > Just a suggestion..
> > > > >
> > > > > Daniel
> > > > >
> > > > > ----- Original Message -----
> > > > > From: Jon Miller <jlmiller@mmtnetworks.com.au>
> > > > > To: plug <plug@plug.linux.org.au>
> > > > > Sent: Wednesday, January 01, 2003 10:06 PM
> > > > > Subject: Re: [plug] auto-increment in mysql
> > > > >
> > > > >
> > > > > > Seems the only way is to create a new table with the columns 
in the
> > > > > > correct order and then copy the data from the old table to the 
new
> > > > > > table.  Is there a better/quicker way?
> > > > > >
> > > > > > Thx
> > > > > >
> > > > > > On Wed, 2003-01-01 at 22:02, Jon Miller wrote:
> > > > > > > Thanks for that just one more question is there a way to 
make the
> > > new
> > > > > > > column the first column?
> > > > > > >
> > > > > > > Jlm
> > > > > > >
> > > > > > > On Wed, 2003-01-01 at 21:46, James Bromberger wrote:
> > > > > > > > Craig Ringer (craig@postnewspapers.com.au) wrote:
> > > > > > > > > ALTER TABLE tablename ADD COLUMN colname TYPENAME
> > > AUTO_INCREMENT;
> > > > > > > > >
> > > > > > > > > thats the general idea, anyway. I mainly use postgresql 
these
> > > days
> > > > > so I
> > > > > > > > > may be a bit rusty. Hmm... when I tried it the db said:
> > > > > > > > >
> > > > > > > > > mysql> ALTER TABLE test ADD COLUMN testing int 
AUTO_INCREMENT;
> > > > > > > > > ERROR 1075: Incorrect table definition; There can only 
be one
> > > auto
> > > > > > > > > column and it must be defined as a key
> > > > > > > >
> > > > > > > >
> > > > > > > >  mysql> ALTER TABLE test ADD COLUMN testing int PRIMARY KEY
> > > > > AUTO_INCREMENT;
> > > > > > > >
> > > > > > > >
> > > > > > > > But there can be only one... primary key per table (hence 
the
> > > name
> > > > > > > > 'primary', and thus there can be only one auto_increment). 
ut I am
> > > > > sure
> > > > > > > > that mysql 4 is a whole new world, just bursting to get 
out of
> > > > > > > > Debian/experimental into debian/unstable.... at some 
time...
> > > > > > > >
> > > > > > > >
> > > > > > > >    JB
> > > > > > > >
> > > > > > > > PS: All you PLUGers and lurkers who are thinking about 
registering
> > > for
> > > > > > > > LCA; hurry up and DO IT! It's only 2 and a bit weeks away! 
Hurry
> > > up!
> > > > > > > > http://www.linux.conf.au/
> > > > > > --
> > > > > > Jon Miller <jlmiller@mmtnetworks.com.au>
> > > > > > MMT Networks Pty Ltd
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > --
> > > > Jon Miller <jlmiller@mmtnetworks.com.au>
> > > > MMT Networks Pty Ltd
> > > >
> > > >
> > > >
> > > >
> > 
> 
> -- 
> Paul...
> 
> /***** Experience is that marvelous thing that enables you to 
> 	recognize a mistake when you make it again. 
> 	-- Franklin P. Jones *****/
> 
> /*****All programmers are playwrights and all computers are lousy actors.
>             -- Unknown*****/
> 
> /* How smart are Computers? They seem to need instructions all the 
time... 
> 	-- Me */
> 
> 

