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.