in , , , , , ,

Mad lad explains how to connect to an SQL database via Javascript

Mad lad explains how to connect to an SQL database via Javascript | javascript-memes, php-memes, java-memes, server-memes, data-memes, password-memes, security-memes, sql-memes, sql server-memes, database-memes, string-memes, object-memes, cli-memes, rds-memes, ide-memes, language-memes | ProgrammerHumor.io
javascript-memes, php-memes, java-memes, server-memes, data-memes, password-memes, security-memes, sql-memes, sql server-memes, database-memes, string-memes, object-memes, cli-memes, rds-memes, ide-memes, language-memes | ProgrammerHumor.io

[text] PN 748 v 4 You shouldnt use client javascript to access databases for several reasons bad practice security issues etc but if you really want to do this here is an example var connection new ActiveXObjectADODE.Connection var connectionstringData SourceserverInitial CatalogcatalogUser IDuserPassword connection. Openconnectionstring var rs new ActiveXobjectADODB.Recordset Fs.0penSELECT FROM table connection Ty UL Y i document.writers. fields1 Pt i rs.close connection. close A better way to connect to a sql server would be to use some server side language like PHP Java NET among others. Client javascript should be used only for the interfaces. And there are rumors of an ancient legend about the existence of server javascript but this is another story. Share Edit Follow Flag N RERERetey T e H Fabio Vinicius Binder EEIRYRE R