Some Programming
Knowledge Questions and Answers
1.
Can JavaScript connect with MySQL?
Answer : No, JavaScript can not directly connect to
MySQL. But you can mix JS with PHP to do so.
JavaScript is a
client-side language and your MySQL database is going to be running on a server
2.MVC Model(Model,View,Controller)
in PHP ?
1. MODEL: The model is what
deals with the data, in this case the PHP scripts that manage variables or that
access data stored, in this case in our MySQL database and send it as JSON data
to the client.
2. VIEW: The view is what we
see and it should be completely independent from the model. It just need to
show the data contained in the model, but it shouldn't have relevant data on
it. In this case the view use HTML and CSS. HTML to create the basic structure
of the view, and CSS to give the shape to this basic structure.
3. CONTROLLER: The controller is the
interface between our model and our view. In this case the language used is
JavaScript and it takes the data the model send us as a JSON package and put it
inside the containers that offer the HTML structure. The way the controller
interacts with the model is using AJAX. We use GET and POST methods
to call PHP scripts in the server side and to catch the returned data from the
server.
3.Abbreviations :-
SQL
: Structured Query Language.
JSON
: JavaScript Object Notation.
CSS : Cascade StyleSheet.
AJAX
: Asynchronous JavaScript and XML.
DLL :Dynamic Link Library
GIF : Graphics Interchange
Format
J2EE :Java 2
Enterprise Edition
J2ME :Java 2 Micro
Edition
J2SE :Java 2 Standard
Edition
NT :New Technology
NTFS :NT
Filesystem
WYSIWYG :What You See Is What You Get
XHTML :eXtensible
Hypertext Markup Language
PHP :PHP:
Hypertext Preprocessor
Wi-Fi : Wireless Fidelity
WAMP : Windows,Apache,Mysql,PHP.