Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday)

$today = getdate();
echo $today[wday];

Generate distinct random number using recursion in php

function generateRandomNumber($howmanynumber)
{
for($i=0; $i<$howmanynumber;$i++)
{
$random = mt_rand(1,53);
if($i == 0)
{
$rnum = $random;
}
elseif($i < 6)
{
$rnum = $rnum.",".$random;
}
else
{
$rnum = $random;
}
}
$rannum_arr = explode(",",$rnum);
$countnum = count(array_unique($rannum_arr));
if($countnum == 6)
{
return $rnum;
}
else
{
return generateRandomNumber(6);
}
}
$rannum = generateRandomNumber(6);
?>

Get start date of a week by passing week_no,month,year,weekday

/**
* convert week no,Day of week and Year to Date
*
* @var int $WeekNo - week no (1-52)
* @var int $Day - day of the week (0-6) 0-Sunday, 6-Saturday
* @var int $Year - Year
*/
function week_to_date($WeekNo,$Day,$Year,$month)
{
$WeekNo--;
$week_date = date('Y-m-d',strtotime($Year."-".$month."-01 + ".$WeekNo." weeks"));
$wDay = date('w',strtotime($week_date));
if($Day < $wDay){
$day_offset = $wDay - $Day;
$date = date('Y-m-d',strtotime($week_date." + -".$day_offset." days"));
}elseif($Day > $wDay){
$day_offset = $Day - $wDay;
$date = date('Y-m-d',strtotime($week_date." + ".$day_offset." days"));
}else{
$date = $week_date;
}
return $date;
}

$Day = 1;
$Year = "2007";
$month= "01";
$week = 1;
$cpldate = week_to_date($week,$Day,$Year,$month);

$cplday = substr($cpldate,8,2);
if($cplday < 10)
{
$cplday = substr($cplday,1,1);
}


if($cplday == 1)$gsd = $cplday;
else $gsd = $cplday - 1;

if($cplday < 10)
{
echo $year."-".$month."-0".$gsd;
}
else
{
echo $year."-".$month."-".$gsd;
}

Get Current Week Using PHP

Only copy an dpaste it you get current week

$currentweek= (int)((date("d") + date('w',mktime(0,0,0,date("m"),1,date("Y"))) - 1 )/7)+1 ;

php db class

/**********************************************************************************************/

//////////////THIS DB CLASS CREATED BY ZIYA///////////

/*
1) Functions Description :

(a) setup_conn() [This function used to establish a connection to database]
(b) db_connect() [This function is also used to establish a connection to database]
(c) select_db() [This function is used to select database]
(d) query() [This function is used to execute a query and get result from it]
(e) fetch_array() [This function is used to fetch an array of query result]
(f) num_rows() [This function is responsible for give num of rows]
(g) last_insertid() [This function is give last inserted id]
(h) insert_record() [This function is used to insert a record]
(i) update_record() [This function is used to select record]
(j) delete_record() [This function is used to delete records according to condition]
(k) select_record() [This function is used to select records according to OR condition]
(l) delete_all_record() [This function is used to delete all records from a table]
(m) select_all_record() [This function is used to select all records from a table]
(n) fetchSingleRow($result) [For fetch single record]
(o) executeQuery($query)
(p) select_records() [This function is used to select records according to AND condition]
*/
/***********************************************************************************************/

class db
{

var $hostname;// Hostname that the object should connect to

var $username;// Username that the object should use

var $password;// Password that the object should use

var $database;// Database that the object should use

var $query_num;// counts the total queries that the object has done.

var $con;//contains connection object.

function setup_conn($hostname,$username,$password)
{
$this->hostname = $hostname;
$this->username = $username;
$this->password = $password;
}

function db_connect()
{
$con = mysql_connect($this->hostname,$this->username,$this->password)or die(mysql_error());/*Open a non persistant connection to the server.*/
if (!$con)
{
echo 'Connection to database server at: '.$this->hostname.' failed.';
return false;
}
else
{
return $con;
}
}

function db_pconnect()
{
$result = mysql_pconnect($this->hostname,$this->username,$this->password);/*Open a persistant connection to the server. */

if (!$result)
{
echo 'Connection to database server at: '.$this->hostname.' failed.';
return false;
}
return $result;
}

function select_db($database,$con)
{
$this->database = $database;
$this->con=$con;
if (!mysql_select_db($this->database,$this->con))
{
'Selection of database: '.$this->database.' failed.';
return false;
}
}

function query($query)
{
$result = mysql_query($query) or die("Query failed:$query

" . mysql_error());
return $result;
}



function return_query_num()
{
return $this->query_num;
}

function num_rows($result)
{
return mysql_num_rows($result);
}

function last_insertid()
{
return mysql_insert_id();
}

function fetchSingleRow($result)
{
return mysql_fetch_row($result);
}

function delete_all_record($table)
{
$delete_query = "DELETE FROM $table";
$delete_result = mysql_query($delete_query)or mysql_error();

$flag = mysql_affected_rows();
if($flag != 0)
return true;
else
return false;
}

function fetch_array($result)
{
return mysql_fetch_array($result);
}

function select_all_record($table)
{
$select_query = "SELECT * FROM ".$table;
$select_result = mysql_query($select_query)or mysql_error();
return $select_result;
}

function select_record($conditon,$table)
{
$len = count($conditon);
$i = 0;
$cond = "";
$sql = "select * from ".$table." where ";

foreach ($conditon as $key => $value) {
if($len - 1 == $i)
$cond.= $key."='".$value."'";
else
$cond.= $key."='".$value."' and ";
$i++;
}

$sql = $sql.$cond;
//die($sql);
return mysql_query($sql);
}

function get_row($rs){

$this->row = mysql_fetch_object($rs);
return $this->row;
}

function get_first_id($tbl,$id){

$rs = $this->query("SELECT ".$id." FROM ".$tbl." WHERE ".$id." > 0 ORDER BY ".$id);
$this->row = mysql_fetch_object($rs);
return $this->row->$id;
}

function get_child_id($tbl,$ParentId,$Cid=""){
$this->res = $this->query("SELECT * from $tbl WHERE $ParentId = '$Cid'");
$this->row = $this->fetch_array($this->res);
return $this->row[Cid];
}

function get_parent_id($tbl,$Cid_Field,$Cid=""){
$this->res = $this->query("SELECT * from $tbl WHERE $Cid_Field = '$Cid'");
$this->row = $this->fetch_array($this->res);
return $this->row[ParentId];
}

function select_record_with_limit($conditon,$table,$limit)
{
$len = count($conditon);
$i = 0;
$cond = "";
$sql = "select * from ".$table." where ";

foreach ($conditon as $key => $value) {
if($len - 1 == $i)
$cond.= $key."='".$value."'";
else
$cond.= $key."='".$value."' and ";
$i++;
}

echo $sql = $sql.$cond." ".$limit;
return mysql_query($sql);
}

function insert_record($qry,$table)
{
$len = count($qry);
$i = 0;
$field = "";
$data = "";

foreach ($qry as $key => $value) {
if($len - 1 == $i)
{
$field.= $key;
$data.= "'".$value."'";
}
else
{
$field.= $key.",";
$data.= "'".$value."',";
}
$i++;
}

$sql = "insert into ".$table."(".$field.")values(".$data.")";
//die($sql);
mysql_query($sql)or die(mysql_error());
//return $this -> last_insertid();
}


function update_record($sql,$conditon,$table)
{
$len = count($sql);
$i = 0;
$data = "";

foreach ($sql as $key => $value) {
if($len - 1 == $i)
$data.= $key."='".$value."'";
else
$data.= $key."='".$value."',";
$i++;
}

$lim = count($conditon);
$j = 0;
$cond = "";

foreach ($conditon as $key => $value) {
if($lim - 1 == $j)
$cond.= $key."='".$value."'";
else
$cond.= $key."='".$value."' and ";
$j++;
}

$sql = "update ".$table." set ".$data." where ".$cond;
//echo "Test".$sql;die();
if(mysql_query($sql))return 1;
//return mysql_affected_rows();
}

function delete_record($conditon,$table)
{
$len = count($conditon);
$i = 0;
$cond = "";
$sql = "delete from ".$table." where ";

foreach ($conditon as $key => $value) {
if($len - 1 == $i)
$cond.= $key."='".$value."'";
else
$cond.= $key."='".$value."' and ";
$i++;
}

$sql = $sql.$cond;//die($sql);
mysql_query($sql);
return mysql_affected_rows();
}
}
$dbobj = new db();
?>