Hi guys,

I know how to create query by SQL language, I do it from command line or
by phpmyadmin but I'd like to know how to create a graphic form for the
end user to add/modify data!

I know I could use PHP and Python I thought to them because are
available in the first case on every web browser and in the second case
like a local program for Mac, Linux and Windows but they're not easy to
use... :\

I saw people who use Visual Studio 2019 and it seems very powerful but
I'd like to use something compatible with Mac, Linux and Windows and not
too difficult to use for a beginner! :)

Yes of course I'll need to study but now I'd like to start to climb a
hill and not a mountain! :)

^Bart

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 26/03/2020 16.06, ^Bart wrote:

Hi guys,

I know how to create query by SQL language, I do it from command line or
by phpmyadmin but I'd like to know how to create a graphic form for the
end user to add/modify data!

I know I could use PHP and Python I thought to them because are
available in the first case on every web browser and in the second case
like a local program for Mac, Linux and Windows but they're not easy to use... :\

The browser has no concept about php or python, those are run on server
side and all the web browsers sees is the html the web server has generated.

I saw people who use Visual Studio 2019 and it seems very powerful but
I'd like to use something compatible with Mac, Linux and Windows and not
too difficult to use for a beginner! :)

Using Visual Studio is like using MySql Workbench or phpmyadmin, you
still need to know SQL to get the most out of it and what you can do
without any knowledge is to work on one table at the time and with the
risk of the person messing things really badly.

Yes of course I'll need to study but now I'd like to start to climb a
hill and not a mountain! :)

Try to learn some PHP and make some simple forms that allows people to
see data and modify in the cases they need. You may want to have a SQL
user with limited privileges which you use in your web ui and don't
forget to verify user data before you use it in queries, don't use
blacklisting as ain't as secure as whitelisting.


--

//Aho

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

The browser has no concept about php or python, those are run on server
side and all the web browsers sees is the html the web server has
generated.

PHP runs on server side but with python you can make a local program
which runs sql queries...

Using Visual Studio is like using MySql Workbench or phpmyadmin, you
still need to know SQL to get the most out of it and what you can do
without any knowledge is to work on one table at the time and with the
risk of the person messing things really badly.

Ok.

Try to learn some PHP and make some simple forms that allows people to
see data and modify in the cases they need. You may want to have a SQL
user with limited privileges which you use in your web ui and don't
forget to verify user data before you use it in queries, don't use blacklisting as ain't as secure as whitelisting.

Ok, thanks for your reply! :)

^Bart

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 26/03/2020 18.45, ^Bart wrote:

The browser has no concept about php or python, those are run on
server side and all the web browsers sees is the html the web server
has generated.

PHP runs on server side but with python you can make a local program
which runs sql queries...

You can do do programs that has GUI with PHP too
http://gtk.php.net/

--

//Aho

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

You can do do programs that has GUI with PHP too
http://gtk.php.net/

I didn't know it! :)

^Bart

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 03/26/2020 04:06 PM, ^Bart wrote:

Hi guys,

I know how to create query by SQL language, I do it from command line or by phpmyadmin but I'd like to know how to create a graphic form for the end user to add/modify data!

I know I could use PHP and Python I thought to them because are available in the first case on every web browser and in the second case like a local program for Mac, Linux and Windows but they're not easy to use... :\

I saw people who use Visual Studio 2019 and it seems very powerful but I'd like to use something compatible with Mac, Linux and Windows and not too difficult to use for a beginner! :)

Yes of course I'll need to study but now I'd like to start to climb a hill and not a mountain! :)

^Bart

libreoffice BASE may have a suitable db connection, but I don't know how crashy it is these days.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

libreoffice BASE may have a suitable db connection, but I don't know how crashy it is these days.

I didn't know it, thanks! :)

I don't know why school teachers start to teach to their students db
just from a payed program like access... :\

^Bart

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 04/12/2020 06:47 PM, ^Bart wrote:

I didn't know it, thanks! :)

I don't know why school teachers start to teach to their students db
just from a payed program like access... :\

^Bart

Can't really recommend it. too slow. too much memory. The few things I do, I do with shell scripts now.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 4/12/2020 12:47 PM, ^Bart wrote:

libreoffice BASE may have a suitable db connection, but I don't know
how crashy it is these days.

I didn't know it, thanks! :)

I don't know why school teachers start to teach to their students db
just from a payed program like access... :\

^Bart

When I was teaching for corporations, I taught both DB2 and ANSI SQL.
If someone isn't familiar with relational databases, the first thing you
need to do is teach them the concepts. This is very difficult from just
using SQL.

The first day (of a five day course) was basically spent discussing
relational database concepts, database design (including normalization), indexes and the like. The exercises were all "paper exercises" - which
if very boring for programmers. Having a graphical tool like Access
would have made things much easier.

The rest of the week the course covered SQL itself. It was much easier
to understand the SQL when one understands the underlying database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)