Some of the more advanced duties of the oracle DBA might include the following: Data Analysis: The DBA will frequently be called on the analysis the data stored in the database and to make recommendation related to the performance and efficiency data storage. This might related to more effective use…
Components of DBMS / Elements of DBMS DBMS is a complex software, which provides interface for each category of the user. DBMS interrupts user commands so that computer can operate on that command to perform the desire task. The important components of BDMS are: DDL (Data Definition language): DDl used…
The main objective of DBMS are: Minimal Redundancy: Data redundancy is the duplicate of same data at more than one storage place. This duplication of data leads to wastage of storage space and time and affect cost also. This redundancy has to be eliminated by integrating the data at one place….
DBMS Concept A database is a collection of related data. Data means fact that can be recorded and that have implicit meaning for e.g. if we consider the name, telephone numbers, addresses of the people we know. We may have recorded this data in an indexed addressed book or we…
There are many difference between file management system and database management system: S.no File Management Database Management System 1. Redundant data: Means the duplication of same data at more than one storage or place, since all the files are design independently, same file are stored in more than one file….
CHtmlPurifier is wrapper of HTML Purifier. CHtmlPurifier removes all malicious code (better known as XSS) with a thoroughly audited, secure yet permissive whitelist. It will also make sure the resulting code is standard-compliant. In your model Add the below content in your model page. For more details : HTML Purifier…
This is the custom PHP by this one’s can get date range from two different dates in PHP. Example : Function call Just pass the two different dates and the date format which you want the output.In the above call we are calling getDatesFromRange defined above and we want the…
PHP Pushwoosh notification using Pushwoosh API Pushwoosh is real time cross-platfrom service to send push notification on android and IOS mobile application. To send and push notification fro PHP pannel we need push auth and push application id that we will get from https://www.pushwoosh.com/ and by using those credentials we…
The following query display the count number of rows added last hours MySQL. Function used : DATE_SUB(), NOW()
In YII2 there are many function including built-in helper for building urls. So we can easily build the url to image by path too . To display the image in grid view : To display the image in DetailView :