Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
Last updated on October 30th, 2018 at 04:25 amWe will be discussing MySQL COALESCE and NULLIF Function in this post with lot of examples. COALESCE Function COALESCE Function in Mysql is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent to the following IF-THEN-ELSE statement IF val1 is not NULL THEN … Continue reading MySQL COALESCE and NULLIF Function
Last updated on August 22nd, 2018 at 09:47 amUseful and common MySQL queries examples for the developer and DBA’s 1)How to create mysql database mysql> create database techdb; mysql> use techdb; 2) How to create table in mysql database? .How to show the structure of the table after creation Here is the example for table creation in MySQL database 1) We need to first get … Continue reading Top 10 Most Common MySQL queries examples
Last updated on June 21st, 2018 at 10:45 amHere is the compilation of Top 51 Frequently Asked MySQL Interview Questions And Answers,I hope you will like that and it will be useful in the interviews 1) What is the difference between sql and Mysql? Answer SQL or Structured Query Language is a programming language designed for managing data held in a Relational Database Management System. Mysql … Continue reading Top 51 Frequently Asked MySQL Interview Questions And Answers
A php developer would offcourse like to test the php file before deploying on the webserver.A local Apache PHP MySQL development environment on windows allows you to test your code as you develop your web application before publishing it to the web. This article will guide you through setting up a local Apache PHP MySQL development environment on windows Step 1. Download the installation files First of … Continue reading Step by step guide to build local Apache PHP MySQL development environment on windows
The MySQL database server is one of the most popular open-source database servers commonly used in web application development.This document provides Step-by-Step guide for Installing MySQL on Windows. It covers the configuration details also with screen shot Starting the Download 1.Go to http://dev.mysql.com/downloads/installer/. 2.Click the Download button. 3. Scroll down to the MySQL database server & standard clients section and Select the latest production release 3.Save the … Continue reading Step-by-Step guide for Installing MySQL on Windows
Last updated on July 26th, 2018 at 06:06 pmPHP has the function capability as available with other programming languages What is a function? A function is a piece of code which takes one more input in the form of parameter and does some processing and returns a value.Suppose you have to call a piece of code several times in the process,then function will be lot … Continue reading PHP Functions with practical examples
Here are detailed working on useful strings functions in PHP Function Description and working strlen() The PHP strlen() function returns the length of a string. The example below returns the length of the string “john” Example <?php echo strlen(“John”); ?> Output 4 Chr() Converts an ASCII value to its equivalent character Example The ASCII value 64 is the @ symbol <?php $str = chr(046); echo(“the … Continue reading Useful strings function in PHP
Last updated on August 27th, 2016 at 05:34 amWebsite design require header,footer,side bar,right bar, ad bar on multiple pages.It is not possible to change these on thousand of web pages whenever we want to change anything. Include function in php solve this problem. We can use include function in PHP and include the content of a PHP file into another PHP file before the server … Continue reading include or require function in PHP with practical examples
Last updated on August 19th, 2016 at 06:19 pmThe good php File Manager allows you to manage your site through HTTP rather than an FTP tool or other third-party application. You can upload, create or delete files, organize files in folders and change file permissions. Folders and files may be displayed in a hierarchical tree based on their directory structure. Some php file managers contain … Continue reading Awesome 10 good php file manager
Last updated on September 18th, 2016 at 08:39 amIntroduction to if else condition in php php programming like other languages have the conditional statement processing also.Conditional statement add intelligence to our scripts. This gives us the functionality to perform various command based on various conditions We will be working on if/then/else statement in this post i.e if else condition in php The basic format for the … Continue reading How to use if else condition in php
Today in this post, I would talk about Handling HTML forms with PHP. A simple example would be registration form. Lets create a html form with php <html> <form action=”register.php” method=”post”> <table border=0> <tr> <td><font face=”Arial, Helvetica, sans-serif” color=black size=-1> <b>Username:*</b></br> <i>It must be 3 or more characters in length <br> and may only contain letters and number</i></td> <td><input name=”userid” type=”text” id=”userid” maxlength=”30″> </td> … Continue reading Handling HTML forms with PHP
Last updated on September 18th, 2016 at 08:31 amWhy the need for PHP editor for windows It is often necessary to edit HTML, CSS ,PHP and JavaScript files while creating web sites. That is reason usable ide for php web development should supply all those file types and provide full set of tools for effective development. In order to get success in developing PHP sites … Continue reading Best PHP editor for windows