Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.mysql > #7436

Re: Graphic form to insert/modify data

Show all headers | View raw

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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Graphic form to insert/modify data ^Bart <gabriele1NOSPAM@hotmail.com> - 2020-03-26 16:06 +0100
  Re: Graphic form to insert/modify data "J.O. Aho" <user@example.net> - 2020-03-26 18:06 +0100
    Re: Graphic form to insert/modify data ^Bart <gabriele1NOSPAM@hotmail.com> - 2020-03-26 18:45 +0100
      Re: Graphic form to insert/modify data "J.O. Aho" <user@example.net> - 2020-03-26 20:59 +0100
        Re: Graphic form to insert/modify data ^Bart <gabriele1NOSPAM@hotmail.com> - 2020-03-27 10:21 +0100
  Re: Graphic form to insert/modify data Johann Klammer <klammerj@NOSPAM.a1.net> - 2020-04-09 14:16 +0200
    Re: Graphic form to insert/modify data ^Bart <gabriele1NOSPAM@hotmail.com> - 2020-04-12 18:47 +0200
      Re: Graphic form to insert/modify data Johann Klammer <klammerj@NOSPAM.a1.net> - 2020-04-13 21:44 +0200
      Re: Graphic form to insert/modify data Jerry Stuckle <jstucklex@attglobal.net> - 2020-04-13 18:21 -0400

csiph-web