Unlimited knowledge
SQL QUERY SQL stands for Structured Query Language, it is used for accessing and manipulating databases. Using SQL one can perform more actions in a database.Such as insert, update, select and delete a records from the database. Essential SQL queries 1. To create a database in mysql Create database is used to create the database. Syntax CREATE DATABASE database_name; … Read more
Session in PHP Session is a way to store the user information(in variables) to be used across multiple pages. For example, When we work with an application, we may open it, do some modification and we close it. This is what a session is.The computer may know who you are, and when you start and end … Read more
To find a highest, lowest, count and average numbers in an array Here, we find the sample php programs to find the find he highest number in an array, similarly lowest number in an array, count of the numbers in an array and average of the numbers in an array. <?php $array=array(‘1′,’2′,’3′,’4’); echo “Given array … Read more
To get the client IP address <?php $strCurrentTime = date(“y-m-d h:i:s”,time()); $strIP = $_SERVER[‘REMOTE_ADDR’]; echo $strIP; ?> output 127.0.0.1 Note: IP address is dynamic so output may differ.
Contact page for website <?php include(‘config.inc.php’); class ContactUs { var $arrErrors = array(); var $strSuccess = ”; public $strSelect=null; public $objResult=null; var $objConfig = null; var $objDbConn=null; var $intRandSiteLimit = 35; var $arrRandSites = array(); var $strName = ”; var $strPhone = null; var $strEmail = ”; var $strContent = ”; var $strReferrer = null; … Read more
To create a login page in php Note: Create a table tbl_login with uname and pwd //config.inc.php <?php class Config { public $dbHostname = ‘localhost’; public $dbUsername = ‘root’; public $dbPassword = ‘xxx’; public $dbName = ‘dbname’; } ?> //index.php <?php session_start(); include(“config.inc.php”); class Login { public $strUsername = null; private $strPassword = null; public $arrErrors … Read more
To print a string using php <?php echo “Welcome to learn PHP”; print “Enjoy it”; ?> output Welcome to learn PHP Enjoy it Note: Using echo and print, you can display the string in php To display a number from 1 t0 5 in for loop <?php for($i=1; i<=5; $i++) { echo $i; echo “<br/>”; } … Read more
To print an array result using var_dump() <?php $a = array(1, 2, array(“a”, “b”, “c”)); var_dump($a); ?> Note: var_dump() is used to dumb the information about the variable output array 0 => int 1 1 => int 2 2 => array 0 => string ‘a’ (length=1) 1 => string ‘b’ (length=1) 2 => string ‘c’ (length=1) To print an array result … Read more