+ 3

Database in sololearn

Howdy! Do You know, can I interact with database in sololearn code playground? Thx for answer :) Best regards!!!

25th Apr 2019, 9:25 AM
Eugene Overchenko
Eugene Overchenko - avatar
8 odpowiedzi
+ 3
I think you can but you definitely shouldn't as it will make the authentication vulnerable as anyone can "borrow" it and fetch anything from the database.
25th Apr 2019, 11:47 AM
Kartik
Kartik - avatar
+ 11
Firstly you just complete your SQL course. Then you will work, few days later, it's easy for you.
26th Apr 2019, 10:33 AM
Nasir❤
Nasir❤ - avatar
+ 3
Kartik, you are right, but it's just educational goal, db is not important
25th Apr 2019, 4:51 PM
Eugene Overchenko
Eugene Overchenko - avatar
0
Music
25th Apr 2019, 4:47 PM
Surendra choudhary Surendra Choudhary
0
Oh in that case, ActiveXObject is used imo. Check it out. And here is a sample code I found: var connection = new ActiveXObject("ADODB.Connection") ; var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB"; connection.Open(connectionstring); var rs = new ActiveXObject("ADODB.Recordset"); rs.Open("SELECT * FROM table", connection); rs.MoveFirst while(!rs.eof) { document.write(rs.fields(1)); rs.movenext; } rs.close; connection.close;
25th Apr 2019, 4:59 PM
Kartik
Kartik - avatar
0
I think this is for SQL server...
25th Apr 2019, 5:00 PM
Kartik
Kartik - avatar
0
Good morning
26th Apr 2019, 4:00 AM
Surendra choudhary Surendra Choudhary
- 1
Hello
26th Apr 2019, 3:57 AM
Lx suren Moktan
Lx suren Moktan - avatar