DataBase Info Example There are a few important commands in MySQL which can be executed either at the MySQL prompt or by using any script like PHP to get various important information about the database server. Sr.No. Command & Description 1 SELECT VERSION( ) Server version string 2 SELECT DATABASE( Read more…
Handling NuLL Example You can use the if…else condition to prepare a query based on the NULL value. The following example takes the tutorial_count from outside and then compares it with the value available in the table. Example Copy and paste the following example as mysql_example.php − <html> <head> <title>Handling NULL</title> </head> Read more…
Environment Setup In order to develop and run PHP Web pages, three vital components need to be installed on your computer system. Web Server − PHP works with virtually all Web Server software, including Microsoft’s Internet Information Server (IIS) but most often used is Apache Server. Download Apache for free here Read more…
PHP&MySQL Overview MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of these languages, PHP is the most popular one because of its web application development capabilities. PHP provides various functions to access the MySQL database and to manipulate the data Read more…
Auto-Increment Sequence MongoDB does not have out-of-the-box auto-increment functionality, like SQL databases. By default, it uses the 12-byte ObjectId for the _id field as the primary key to uniquely identify the documents. However, there may be scenarios where we may want the _id field to have some auto-incremented value other than the Read more…
Capped Collections MongoDB Capped collections are fixed-size circular collections that follow the insertion order to support high performance for create, read, and delete operations. By circular, it means that when the fixed size allocated to the collection is exhausted, it will start deleting the oldest document in the collection without providing Read more…
MongoDB – GridFS GridFS is the MongoDB specification for storing and retrieving large files such as images, audio files, video files, etc. It is kind of a file system to store files but its data is stored within MongoDB collections. GridFS has the capability to store files even greater than its Read more…
Working With rock MongoDB RockMongo is a MongoDB administration tool using which you can manage your server, databases, collections, documents, indexes, and a lot more. It provides a very user-friendly way for reading, writing, and creating documents. It is similar to PHPMyAdmin tool for PHP and MySQL. Downloading RockMongo You Read more…
Text Search-MongoDB Starting from version 2.4, MongoDB started supporting text indexes to search inside string content. The Text Search uses stemming techniques to look for specified words in the string fields by dropping stemming stop words like a, an, the, etc. At present, MongoDB supports around 15 languages. Enabling Text Search Initially, Text Search Read more…
Add Your Heading Text Here MongoDB uses ObjectIds as the default value of _id field of each document, which is generated while the creation of any document. The complex combination of ObjectId makes all the _id fields unique. Creating New ObjectId To generate a new ObjectId use the following code − >newObjectId Read more…