Skip to main content

php mysql explain with examples



PHP MYSQL
Php is a server side scripting language. By using php we can interact with the different databases. Php support cross database. Database server is a collection of databases. Each database contains the database objects(tables, stored procedure, etc)
By using php we can interact with the mysql database. Mysql is an open source relational database management system implemented by mysql Ab Corporation. This is adapted by sun Microsystems. We can interact with the mysql database using commend prompt, phpmyadmin, php application.
To work with commend prompt execute mysql database. Exact file what it is available in xampp/mysql/bin folder  
Xampp/mysql/bin> mysql  -u root p
Mysql> create a database dbname;
Query ok

Popular posts from this blog

java script

This Javascript tutorial is for people with little or no experience with programming. It covers these topics: The Definition of Javascript The History of Javascript Java Versus Javascript Learning Javascript A Basic JavaScript Example The Definition of Javascript JavaScript is a type of programming language that works with HTML to make web pages more interactive. For instance, if you had a trivia quiz on a web page you could use JavaScript to check the answers. Javascript is limited. It is not a full-featured programming language like Java or C++. Think of the JavaScript language as a simple, easy-to-use programming language that has only the features necessary to make web pages interactive. The History of Javascript When the Web was first created in the early 1990s all web pages were static. In other words there were no popup windows, no shopping carts, no flying thingy's etc. Pages just stayed still. At that time Netscape Navigator and Internet Explorer were the top browsers. Net...
Read more

Collection Shell Commands in MongoDB

Create Collection  Syntax: db.createCollection("Collection Name"); Example: db.createCollection("users"); Delete collection in Mongodb Shell Command db.collection.drop()  Find Collection in Mongodb Shell Command db.collection.find() Show all Collection in Mongodb Shell Command show collections Creat Collection in Mongodb Shell Command db.createCollection("users") Rename the Collection In Mongodb Shell Command db.collection.renameCollection()   Update the single document in MongoDB collections Shell Command db.collection.updateOne()  Updates all the documents in MongoDB collections that match the given query.  db.collection.updateMany() Replaces the first matching document in MongoDB collection db.collection.replaceOne()  Deletes the first document in Mongodb collection db.collection.deleteOne()  db.collection.deleteMany()
Read more