//FUNCTION TO GET THE WEEK DAY DATES
function get_week_day_dates($year, $month, $day)
{
$start_of_week = mktime(0, 0, 0, $month, $day+(0-(int)date('w')), $year);
for ($x=0; $x<7; $x++)
{
print date('Y-m-d', $start_of_week + $x * 60 * 60 * 24) ."<br/>";
}
}
//USING THE FUNCTION
get_week_day_dates(2009, 10, 25);
<script type='text/javascript'>
function createCookie(name, value,expiredays)
{
var expiry_date = new Date();
expiry_date.setDate(expiry_date.getDate() + expiredays);
document.cookie=name+ "=" +escape(value)+
((expiredays==null) ? ""
:";expires="+expiry_date.toGMTString());
alert("'" + name + "' cookie created.");
}
</script>
createCookie function.<input type="button" value="Create Cookie using JavaScript"
onclick="createCookie('YourName', 'Joel Badinas')"/>
<form method="POST" action="">
<p>
<input type="submit" name="submit" value="Get Cookie using PHP"/>
</p>
</form>
<?php
if (isset($_POST["submit"]))
{
print "Cookie value is '".$_COOKIE["YourName"]."'";
}
?>
<html>
<head>
<title>Practical Web Programming</title>
<script type='text/javascript'>
function createCookie(name, value,expiredays)
{
var expiry_date = new Date();
expiry_date.setDate(expiry_date.getDate() + expiredays);
document.cookie=name+ "=" +escape(value)+
((expiredays==null) ? ""
:";expires="+expiry_date.toGMTString());
alert("'" + name + "' cookie created.");
}
</script>
</style>
</head>
<body>
<p method="POST" action="">
<p>
<input type="button" value="Create Cookie using JavaScript"
onclick="createCookie('YourName', 'Joel Badinas')"/>
<input type="submit" name="submit" value="Get Cookie using PHP"/>
</p>
</form>
<?php
if (isset($_POST["submit"]))
{
print "Cookie value is '".$_COOKIE["YourName"]."'";
}
?>
</body>
</html>
time function, you can get the time elapsed of any process in your web application. The time function returns the current Unix timestamp.
<?php
$t1 = time();
print "Start time : ".$t1."<br>";
for ($i = 0; $i < 90000000; $i++)
{
print "";
}
$t2 = time();
print "End time : ".$t2."<br>";
print "Time elapsed (s) : ".($t2 - $t1)."<br>";
?>
Start time : 1235100956
End time : 1235100980
Time elapsed (s) : 24
head tag section, you will see a b:include tag named all-head-content (highlighted in red) . When your is blog is visited (or loaded in HTML), the Blogger engine will replace that tag with all the meta tags for you blog including the shortcut icon, and you have no control over this.<head>
<b:include data='blog' name='all-head-content'/>
<title><data:blog.pageTitle/></title>
<b:skin><![CDATA[/*
b:include tag named all-head-content. Here's an example from this blog.<head>
<b:include data='blog' name='all-head-content'/>
<title><data:blog.pageTitle/></title>
<link href='http://kabalweg.googlepages.com/blog.com.ico' rel='shortcut icon'/>
<b:skin><![CDATA[/*
count function, you can dynamically get the last element of an array. Here's how.<?php
//Getting the last element of an array dynamically
$arr = array("one", "two", "three", "four", "five");
print "Last element: " . $arr[count($arr) -1];
?>
count($arr) will return 5, while count($arr) - 1 will return 4.
while, do...while, for and foreach loop. The following example demonstrates how to use each loop.while loop.<?php
$x=1;
while($x<=10)
{
echo "The number is " . $x . "<br />";
$x++;
}
?>
while loop output:The number is 1
The number is 2
The number is 3
The number is 4
The number is 5
The number is 6
The number is 7
The number is 8
The number is 9
The number is 10
do...while loop.<?php
$x=1;
do
{
echo "The number is " . $x . "<br />";
$x++;
}
while ($x<10);
?>
do...while loop output:The number is 1
The number is 2
The number is 3
The number is 4
The number is 5
The number is 6
The number is 7
The number is 8
The number is 9
for loop.<?php
for ($x=1; $x<=10; $x++)
{
echo "The number is " . $x . "<br />";
}
?>
for loop output:The number is 1
The number is 2
The number is 3
The number is 4
The number is 5
The number is 6
The number is 7
The number is 8
The number is 9
The number is 10
foreach loop.<?php
$arr=array("one", "two", "three", "four", "five");
foreach ($arr as $value)
{
echo "Value: " . $value . "<br />";
}
?>
foreach loop output:Value: one
Value: two
Value: three
Value: four
Value: five
<?php
//CREATE AN INSTANCE OF DOMDocument() CLASS
$doc = new DOMDocument();
//LOAD THE XML
$doc->loadXML($xml);
//READ THE <employee> AND LOOP THROUGH IT
$employees = $doc->getElementsByTagName("employee");
foreach($employees as $employee)
{
//READ THE <firstname> AND GET THE NODE VALUE
$firstnames = $employee->getElementsByTagName("firstname");
$firstname = $firstnames->item(0)->nodeValue;
//READ THE <lastname> AND GET THE NODE VALUE
$lastnames = $employee->getElementsByTagName("lastname");
$lastname = $lastnames->item(0)->nodeValue;
//DISPLAY IT
print $firstname." ".$lastname."<br/>";
}
?>
Steven King
Neena Kochhar
Lex De Haan
Alexander Hunold
Bruce Ernst
David Austin
Valli Pataballa
Diana Lorentz
Nancy Greenberg
Daniel Faviet
John Chen
Ismael Sciarra
Jose Manuel Urman
Luis Popp
Den Raphaely
Alexander Khoo
Shelli Baida
Sigal Tobias
Guy Himuro
Karen Colmenares
Matthew Weiss
load rather than loadXML.
<?php
//CREATE A DATABASE CONNECTION
$db_conn = mysql_connect("localhost", "root", "root1")
or die("Cannot connect to the database. ".mysql_error());
//SELECT THE DATABASE TO USE
mysql_select_db("test");
$sql = "SELECT
first_name, last_name, email
FROM employees";
$result = mysql_query($sql, $db_conn);
$xml = "<?xml version='1.0' encoding='UTF-8'?>
<employees>";
while ($row = mysql_fetch_assoc($result))
{
$xml .= "<employee>";
$xml .= "<firstname>".$row["first_name"]."</firstname>";
$xml .= "<lastname>".$row["last_name"]."</lastname>";
$xml .= "</employee>";
}
$xml .= "</employees>";
//DISPLAY THE XML
print $xml;
?>
<?xml version='1.0' encoding='UTF-8'?>
<employees>
<employee><firstname>Steven</firstname><lastname>King</lastname></employee>
<employee><firstname>Neena</firstname><lastname>Kochhar</lastname></employee>
<employee><firstname>Lex</firstname><lastname>De Haan</lastname></employee>
<employee><firstname>Alexander</firstname><lastname>Hunold</lastname></employee>
<employee><firstname>Bruce</firstname><lastname>Ernst</lastname></employee>
<employee><firstname>David</firstname><lastname>Austin</lastname></employee>
<employee><firstname>Valli</firstname><lastname>Pataballa</lastname></employee>
<employee><firstname>Diana</firstname><lastname>Lorentz</lastname></employee>
<employee><firstname>Nancy</firstname><lastname>Greenberg</lastname></employee>
<employee><firstname>Daniel</firstname><lastname>Faviet</lastname></employee>
<employee><firstname>John</firstname><lastname>Chen</lastname></employee>
<employee><firstname>Ismael</firstname><lastname>Sciarra</lastname></employee>
<employee><firstname>Jose Manuel</firstname><lastname>Urman</lastname></employee>
<employee><firstname>Luis</firstname><lastname>Popp</lastname></employee>
<employee><firstname>Den</firstname><lastname>Raphaely</lastname></employee>
<employee><firstname>Alexander</firstname><lastname>Khoo</lastname></employee>
<employee><firstname>Shelli</firstname><lastname>Baida</lastname></employee>
<employee><firstname>Sigal</firstname><lastname>Tobias</lastname></employee>
<employee><firstname>Guy</firstname><lastname>Himuro</lastname></employee>
<employee><firstname>Karen</firstname><lastname>Colmenares</lastname></employee>
<employee><firstname>Matthew</firstname><lastname>Weiss</lastname></employee>
</employees>
substr, this function will return the portion of string specified by the start and length parameters. You can you use it to print each character in a string.
$string = "Joel P. Badinas";
for ($i = 0; $i < strlen($string); $i++)
{
print "[" . $i . "] " . substr($string, $i, 1) ."<br/>";
}
?>
[0] J
[1] o
[2] e
[3] l
[4]
[5] P
[6] .
[7]
[8] B
[9] a
[10] d
[11] i
[12] n
[13] a
[14] s
<?php
//CREATE A DATABASE CONNECTION
$db_conn = mysql_connect("localhost", "root", "root1")
or die("Cannot connect to the database. ".mysql_error());
//SELECT THE DATABASE TO USE
mysql_select_db("test");
//COMPOSE THE SQL
$sql = "INSERT INTO employees (
first_name,
last_name,
email,
phone_number)
VALUES (
'Joel',
'Badinas',
'kabalweg@gmail.com',
'123.456.7890')";
//EXECUTE SQL
$result = mysql_query($sql, $db_conn);
//CHECK IF QUERY IS SUCCESSFUL
if(mysql_affected_rows($db_conn) > 0)
{
print "Save successful";
}
else
{
print "Error: ".mysql_error();
}
?>
<?php
//CREATE A DATABASE CONNECTION
$db_conn = mysql_connect("localhost", "root", "root1")
or die("Cannot connect to the database. ".mysql_error());
//SELECT THE DATABASE TO USE
mysql_select_db("test");
//COMPOSE THE SQL
$sql = "UPDATE employees SET
first_name = 'Kabalweg'
WHERE first_name = 'Joel'
AND last_name = 'Badinas'";
//EXECUTE SQL
$result = mysql_query($sql, $db_conn);
//CHECK IF QUERY IS SUCCESSFUL
if(mysql_affected_rows($db_conn) > 0)
{
print "Update successful";
}
else
{
print "Error: ".mysql_error();
}
?>
<?php
//CREATE A DATABASE CONNECTION
$db_conn = mysql_connect("localhost", "root", "root1")
or die("Cannot connect to the database. ".mysql_error());
//SELECT THE DATABASE TO USE
mysql_select_db("test");
//COMPOSE THE SQL
$sql = "DELETE FROM employees
WHERE first_name = 'Kabalweg'
AND last_name = 'Badinas'";
//EXECUTE SQL
$result = mysql_query($sql, $db_conn);
//CHECK IF QUERY IS SUCCESSFUL
if(mysql_affected_rows($db_conn) > 0)
{
print "Delete successful";
}
else
{
print "Error: ".mysql_error();
}
?>
header function, in HTML, we use the meta tag to accomplish the same task.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>HTML Redirect in Meta Tag</title>
<meta http-equiv="REFRESH" content="0;url=http://localhost/redirect.php">
</head>
<body>
</body>
</html>
meta tag should contain the number of seconds to pause before doing the redirection and the page where to redirect. The above sourcecode will redirect the current page to http://localhost/redirect.php in 0 second.<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>HTML Redirect in Meta Tag</title>
<meta http-equiv="REFRESH" content="5;url=http://localhost/redirect.php">
</head>
<body>
<p>This page will redirect in 5 seconds...</p>
</body>
</html>
target='_blank' to your HTML form. Here's an example.<form target='_blank' method='POST' action='index.php'>
<br/>First Name: <input type='text' name='firstname' value='' />
<br/>Last Name: <input type='text' name='lastname' value='' />
<br/><input type='submit' name='submit' value='Submit' />
</form>
<?php
print "<form target='_blank' method='POST' action='index.php'>
<br/>First Name: <input type='text' name='firstname' value='' />
<br/>Last Name: <input type='text' name='lastname' value='' />
<br/><input type='submit' name='submit' value='Submit' />
</form>";
?>
form will be handled.
foreach looping construct in one of the less used looping construnct in the programming language, and PHP is not an exception. This is because in PHP, the foreach works only with arrays and will spit an error if used with other data type.foreach loop construct is really easy. See example below.$array = array("j", "o", "e", "l", "b", "a", "d", "i", "n", "a", "s");
foreach ($array as $char)
{
print $char."<br/>";
}j
o
e
l
b
a
d
i
n
a
s
substr function. See the sourcecode below.<?php
$text = 'The quick brown fox jumps over the lazy dog';
$truncated1 = substr($text, 0, 20);
$truncated2 = substr($text, 20, 40);
print "<br/>The original text: ". $text;
print "<br/>The truncated text 1: ". $truncated1;
print "<br/>The truncated text 2: ". $truncated2;
?>
substr function, you can truncate a text to whatever length you want by changing the third parameter and also change the start position by changing the second parameter.The original text: The quick brown fox jumps over the lazy dog
The truncated text 1: The quick brown fox
The truncated text 2: jumps over the lazy dog
<html>
<head>
<title>A Simple PHP-Ajax Tutotial</title>
<script src="ajax.js"></script>
</head>
<body>
<br/><input type='button' value='Query' onclick='queryDb()' name='Query' /><br/>
<div id='container'></div>
</body>
</html>
//CREATE A VARIABLE THAT WILL HOLD THE XMLHttpRequest OBJECT
request = null;
//THIS FUNCTION WILL CREATE AN INSTANCE OF XMLHttpRequest OBJECT
AND RETURN IT TO THE CALLING FUNCTION
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
//THIS FUNCTION WILL CALL THE GetXmlHttpObject() FUNCTION AND THE ajax.php PAGE
function queryDb()
{
//DISPLAY THE 'LOADING' TEXT IN THE DIV CONTAINER
document.getElementById("container").innerHTML = "Loading";
//CREATE AN INSTANCE OF XMLHttpRequest OBJECT
request = GetXmlHttpObject();
//SET queryDone FUNCTION TO THE onreadystatechange EVENT
request.onreadystatechange = queryDone;
//OPEN THE PHP PAGE USING THE POST METHOD
request.open("POST", "ajax.php", true);
//SEND THE REQUEST
request.send(null);
}
//HELPER FUNCTION FOR queryDb()
function queryDone()
{
if (request.readyState == 4)
{
if (request.status == 200 || request.status == 304)
{
//GET THE RESPONSE FROM THE PHP PAGE
results = request.responseText;
//DISPLAY THE RESPONSE IN THE DIV CONTAINER
document.getElementById("container").innerHTML = results;
}
else
{
//IF A ERROR OCCUR, DISPLAY IT IN THE DIV CONTAINER
document.getElementById("container").innerHTML = "ajax error:\n" + request.statusText;
}
}
}
print function, which will in turn will be passed by the Javascript code to the HTML container. <?php
//CONNECT TO MYSQL DATABASE
$con = mysql_connect("localhost", "root", "root1")
or die("<p class='error-msg'>Cannot connect to the database. ".mysql_error()."</p>");
//SELECT A DATABASE
mysql_select_db("test");
//COMPOSE QUERY
$sql = "
SELECT
CONCAT(first_name, ' ', last_name) AS name
FROM employees
LIMIT 0, 10";
//print "<pre>".$sql."</pre>";
//EXECUTE THE QUERY
$result = mysql_query($sql, $con);
while ($row = mysql_fetch_assoc($result))
{
print "<br/>".$row["name"];
}
?>
substr and strlen functions, you can delete the first and last character in a string. Here's the syntax of the functions from the PHP documentation website.string substr ( string $string , int $start [, int $length ] )
int strlen ( string $string )
substr returns a part of a string, while strlen returns the length of a string. See below for the example.<?php
$my_name = "Joel Badinas";
$str_length = strlen($my_name);
$no_first_char = substr($my_name, 1, $str_length);
$no_last_char = substr($my_name, 0, $str_lenght - 1);
print ("Original String : " . $my_name . "<br/>");
print ("No first character: " . $no_first_char . "<br/>");
print ("No last character: " . $no_last_char . "<br/>");
?>
Original String : Joel Badinas
No first character: oel Badinas
No last character: Joel Badina
LIMIT keyword that you can use in SELET queries.$page_size = 10;
$con = mysql_connect("localhost", "root", "root1")
or die("Cannot connect to the database. ".mysql_error().");
mysql_select_db("test");CEILING function, count the number of pages by dividing the rows with the $page_size variable we declared earlier. //COMPOSE QUERY
$sql = "SELECT
CEILING(count(1) / ".$page_size.") AS count
FROM employees";
$result = mysql_query($sql, $con);
if ($row = mysql_fetch_assoc($result))
{
$page_count = $row["count"];
}
<a> tag, display the number of pages.for ($i = 1; $i < $page_count + 1; $i++)
{
print "<a href='?page=".$i."'>".$i."</a> ";
}
GET variable, page, is available and set the $limit variable.if (isset($_GET["page"]))
{
$page_no = $_GET["page"];
$limit = ($page_no * $page_size) - $page_size;
}
else
{
$limit = 0;
}
$sql = "SELECT
CONCAT(first_name, ' ', last_name) AS name
FROM employees
LIMIT ".$limit .", ".$page_size;
$result = mysql_query($sql, $con);
print "<br/>";
while ($row = mysql_fetch_assoc($result))
{
print "<br/>".$row["name"];
}
//SET THE ROWS FOR EVERY PAGE
$page_size = 10;
//CONNECT TO MYSQL DATABASE
$con = mysql_connect("localhost", "root", "crop")
or die("<p class='error-msg'>Cannot connect to the database. ".mysql_error()."</p>");
//SELECT A DATABASE
mysql_select_db("test");
//COMPOSE QUERY
$sql = "SELECT
CEILING(count(1) / ".$page_size.") AS count
FROM employees";
//EXECUTE THE QUERY
$result = mysql_query($sql, $con);
if ($row = mysql_fetch_assoc($result))
{
$page_count = $row["count"];
}
//DISPLAY A LINK TO THE NUMBER OF PAGES
for ($i = 1; $i < $page_count + 1; $i++)
{
print "<a href='?page=".$i."'>".$i."</a> ";
}
//CHECK IF PAGE VARIABLE IS AVAILABLE AND CALCULATE THE LIMIT
if (isset($_GET["page"]))
{
$page_no = $_GET["page"];
$limit = ($page_no * $page_size) - $page_size;
}
else
{
$limit = 0;
}
//COMPOSE QUERY
$sql = "SELECT
CONCAT(first_name, ' ', last_name) AS name
FROM employees
LIMIT ".$limit .", ".$page_size;
//EXECUTE THE QUERY
$result = mysql_query($sql, $con);
print "<br/>";
while ($row = mysql_fetch_assoc($result))
{
print "<br/>".$row["name"];
}
CREATE TABLE IF NOT EXISTS `employees` (
`employee_id` int(10) unsigned NOT NULL auto_increment,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(50) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`employee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=121;
INSERT INTO `employees` (
`employee_id`, `first_name`, `last_name`, `email`, `phone_number`)
VALUES
(100, 'Steven', 'King', 'SKING', '515.123.4567'),
(101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568'),
(102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569'),
(103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567'),
(104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568'),
(105, 'David', 'Austin', 'DAUSTIN', '590.423.4569'),
(106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560'),
(107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567'),
(108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569'),
(109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169'),
(110, 'John', 'Chen', 'JCHEN', '515.124.4269'),
(111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369'),
(112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469'),
(113, 'Luis', 'Popp', 'LPOPP', '515.124.4567'),
(114, 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561'),
(115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562'),
(116, 'Shelli', 'Baida', 'SBAIDA', '515.127.4563'),
(117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564'),
(118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565'),
(119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566'),
(120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234');
CREATE TABLE emp AS SELECT * FROM employees
CREATE TABLE emp AS SELECT * FROM employees WHERE 1 = 0
LIMITCREATE TABLE emp AS SELECT * FROM employees LIMIT 0, 10
CREATE TABLE emp AS SELECT first_name, last_name FROM employees
SELECT statement. CREATE TABLE [table] AS SELECT statements that I haven't included here, some of them I don't know yet. I'll update this post as soon as I find more.
date and strtotime functions.strtotime parses any English textual datetime description into a Unix timestamp. It expects to be given a string containing a US English date format and will try to parse that format into a Unix timestamp (the number of seconds since January 1 1970 00:00:00 UTC)int strtotime ( string $time [, int $now ] )
print strtotime("Dec. 25, 2008 10:00 AM");date function on the other hand returns a string formatted time/date according to the given format string using the given integer timestamp or the current time if no timestamp is given.string date ( string $format [, int $timestamp ] )
print date("M d, Y H:i:s A");print date("M d, Y H:i:s A", strtotime("Dec. 25, 2008 10:00 AM"));date functions, visit the PHP documentation here.
