[dba-Tech] Simple online entry form solution
Jim Lawrence
accessd at shaw.ca
Sun Apr 29 20:59:53 CDT 2018
Real programmers use C, not C++ or assembler only.
Jim
----- Original Message -----
From: "stuart" <stuart at lexacorp.com.pg>
To: "Discussion of Hardware and Software issues" <dba-tech at databaseadvisors.com>
Sent: Wednesday, February 7, 2018 12:21:26 PM
Subject: Re: [dba-Tech] Simple online entry form solution
This Quora post crossed my desk the other day.
https://www.quora.com/Why-is-it-that-PHP-programmers-are-not-considered-as-real-progra
mmers
You could subsititue Access/VBA for PHP in the comments and it would repeat what we have
all been saying for years :)
...
Typical response:
<begin quote>
"PHP is so simple for any developer (someone who´s already learned programming itself) to
learn that it´s gotten such a bad reputation - because people with no idea of how to build
websites can build garbage with PHP."
It's so easy to get started with PHP that a lot of people just do that and produce a lot of
amateur code, leading to a bad reputation not only of the language, but also of the people
writing in it.
<end quote>
--
Stuart
On 7 Feb 2018 at 11:22, Peter Brawley wrote:
> On 2/7/2018 6:02, Susan Harkins wrote:
> > That was one of the OT crew suggestions too. I don't know php but
> > don't mind learning enough of it to make that happen. My one
> > consideration is that this is a pro bono project for a nonprofit.
> > They need something that I can show them how to support it when I'm
> > not available -- if I can come up with one.
>
> PHP has the quickest learning curve of any language I know. Most web
> hosting companies support it.
>
> PB
>
> -----
>
> >
> > Thank you!
> > Susan H.
> >
> >
> > On 2/6/2018 21:07, Susan Harkins wrote:
> >> I'm currently looking for a very simple way to solicit data from
> >> very unsavvy users. I have OneDrive for Business but I've found
> >> Excel Online Forms very limited. I need to limit responses using
> >> dropdowns. Also, I can't figure out how to edit a form once I've
> >> saved and shared it.
> >>
> >> Or either of these possible?
> >>
> >> I'm also looking at Googles Spreadsheet. I've got a script that
> >> will let me create a form based on the sheet, but again, I need
> >> populated dropdowns -- and I don't know if the form will pick up on
> >> those. I haven't tried yet.
> >>
> >> The 365 Excel Online Form would probably be the easiest and
> >> quickest route for me if I can generate dropdowns and edit the
> >> forms as needed.
> >>
> >> Looking for suggestions. Thanks!
> > Susan,
> >
> > They're a snap in PHP. This one grabs its dropdown entries from
> > MySQL but it's every bit as easy writing to MSSQL ...
> >
> > |<html>
> > <head>
> > |<script type='text/Javascript'>
> > function submit( f ) {
> > f.submit();
> > }
> > </script>|
> > </head>
> > <body>
> > <form>
> > |
> > |<?php
> > $conn = mysqli_connnect(...);
> > $resfoo = mysqli_query( $conn, "SELECT foo FROM footable" )
> > or exit( "Cannot retrieve foo values" ); echo "<b>Foo
> > Value:</b> n"; echo " <select name='foo'
> > onChange='submit(this.form)'>n"; while( $row =
> > mysqli_fetch_row( $resfoo )) { $sel = ( $table ===
> > $row[0] ) ? "id='sel' selected" : ""; printf( " <option
> > %s value='%s'>%s</option>n", $sel, $row[0], $row[0] ); }
> > echo " </select>n"; echo " <input id='edit'
> > type='button' value='Pick a foo'
> > onClick='submit(this.form)'>n"; ?>|
> > |
> > </form>
> > </body></html>
> >
> > PB
> >
> > -----
> > |
> >
> >
> >> Susan H.
> >>
> >> _______________________________________________
> >> dba-Tech mailing list
> >> dba-Tech at databaseadvisors.com
> >> http://databaseadvisors.com/mailman/listinfo/dba-tech
> >> Website: http://www.databaseadvisors.com
> >>
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
> >
> > _______________________________________________
> > dba-Tech mailing list
> > dba-Tech at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-tech
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
More information about the dba-Tech
mailing list