sql front end forms -


i starting learn sql , silly question code used front end, user friendly input database or table? example when fill in contact information website information doesn't go off inputs individually in table/database using sql syntax, how sql tied individual form sections being filled in customer? responsibility of database manager create link or of web developer through html code?

this open question because there ton in middle guess best way summarize it

in modern web development (not looking @ aspx or mvc5 razor templates) have client side application web technologies client side lands in area of html5, css3, javascript creates ui user. once form filled out there 2 ways submit data 1 via form attribute (you can read more in link) have attribute called method defines type of http protocol send data can read different type here , action server endpoint. there ton more info why has it's own books written should read about. other method via custom javascript using xmlhttprequest

this http protocol send data server have written in massive amounts of languages generic c#, java, node.js(javascript), php, server listen request , things such validation , handle business logic. @ point once goes dandy , data gets sanitized , processed database, operation can take place. server open connection desired rdbms database (mssql, mysql, postgresql) or nosql db (mongodb, couchdb) @ point run sql provided server or execute procedure on db sanitized data passed in.

essentially small workflow be

  • customer enters data form
  • custom submits data , passes web server via http method (get,post,put,delete)
  • server receives http request , reads it. verification , based on url called server execute specific sql or stored procedure action
    • lets action add new order, server send database sql command such insert order values (id, price, date)

the rough picture beginning steps enterprise n-tier architecture in of cases. there enough key words google , research on along way better understanding.


Comments

Post a Comment

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

hi i'm using ngfor create set of 3 slides while starting in middle i'm guaranteed able slide left or right on start. when slide right can simple listen reachedend , push slide array i'm looping. but have problem adding slide beginning. if same above , use e.g. array.unshift() or spread add item beginning, view think it's on position 0 , snaps view new slide. the code below work animates slide change index 1. slide = [0,1,2] //example loop slidechanged(event) { if(this.slides.isbeginning()){ this.slide = [this.slide[0]-1, ...this.slide]; this.slides.update(); this.slides.slideto(1) } } <ion-slides [initialslide]="1" (ionslidedidchange)="slidechanged($event)"> <ion-slide *ngfor="let item of slide"> <h1>slide {{item}}</h1> </ion-slide> </ion-slides> any appreciated! you can using ionslidenextend , ionslideprevend events slides . please
Read more

minify - Minimizing css files -

i want know how css files can minimized. currently, using external sites css minifier compress css files. however, after removing whitespaces, comments, etc, file sizes reduced 10-15%. how frameworks bootstrap manage make minimized versions kilobytes. as example, css is: body { background-color: #ff0; } the reduction goes 28 bytes 22 bytes other css files have lot more characters still smaller this. actually minifying code means it's remove thing code white space characters new line characters comments block delimiters it reduces amount of code has transferred on web , speed site load fastly.but unreadable format.
Read more

Add a dynamic header in angular 2 http provider -

i have http interceptor built via tutorial https://scotch.io/@kashyapmukkamala/using-http-interceptor-with-angular2 the problem need have dynamic header changes automatically once changes 'mode' in app. service able tell interceptor change header, or have interceptor pull header (which string)from service each request. able throwing away patch method, call http.patch('new header string') set header string. call in service controls 'mode' setting. wondering if there way interceptor pull recent value service each request or if can add method http provider via interceptor? i've tried call service in interceptor each request returns undefined. because creating new instance of service or copying value before service fired , loaded/changed data. i don't want pass header string every http provider call because defeats purpose of having interceptor, id able set once changes or have provider fetch service before makes request. tl;dr : need add autom
Read more