Uncategorized

The HTTP 500 Error – Internal Server Error may also be caused by PHP scripts that exceed the memory limit of your website. How to Live Search using PHP MySQL and Ajax Solution: This will set it for just the script. You will still need to tell apache to allow that much for a php script. … Read more

What is Bootstrap Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive and mobile friendly website .  Bootstrap helps web developers build website faster as they don’t need to worry about basic commands and functions. Bootstrap became popular very quickly, and not without reason. Web designers and web developer like bootstrap because it … Read more

The DELETE statement is used to delete records from a table. you can delete records from a table using the SQL DELETE statement. It is typically used in conjugation with the WHERE clause to delete only those records that matches specific criteria or condition. Syntax : DELETE FROM table_nameWHERE some_column = some_value ; Implementation of the Delete Query … Read more

Introduction : MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications.  It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world. Prerequisites : A Linux … Read more

What is XML : XML is stand for (Extensible Markup Language)  is a mark up language. It is designed to store transmitting, and reconstructing arbitrary data. The XML standard is a flexible way to create information formats and electronically share structured data via the public internet, as well as via corporate networks.XML does not define … Read more

Define Binary logs : In MySQL, the changes that occur within the database are logged simultaneously. The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. The log is enabled by starting the server with the –log- bin option. The MySQL Bin Log (Binary Logs) … Read more

Select : Select Data From a MySQL Database The SELECT statement is used to select data from one or more tables The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP. Syntax : Columns are the column names … Read more

MySQL String Functions : MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description: Name Description CONTACT Concatenate two or more strings into a single string INSTR Return the position of the first occurrence of a substring in a string ASCII Returns the ASCII … Read more

VARCHAR Datatype:  Varchar is a datatype in SQL that holds characters of variable length. This data type stores character strings of up to 255 bytes in a variable-length field. If the length of the string is less than set or fixed-length then it will store as it is without padded with extra blank spaces. The … Read more