Building Dynamic Websites Using php

CHECK E-MAIL ADDRESS DELIVERY STATUS USING PHP

noreply@blogger.com (Unknown) — Mon, 07 Sep 2009 01:06:00 +0000

(THIS SCRIPT CHECK WHETHER THE DOMAIN NAME OF THE EMAIL ID IS EXISTING OR NOT.BUT IT WILL NOT CHECK THE EMAIL ADDRESS IS DELIVERABLE OR NOT )

hi everyone i checked this script version of php5.3. lower version of php may not support this script but you check it.

CHERAN@EXAMPLE.COM

CHERAN(USERNAME);

EXAMPLE.COM(DOMAIN NAME)
E-mail addresses, such as cheran@example.com, have two parts. The part before the @ sign is the local-part of the address, often the username of the recipient (cheran), and the part after the @ sign is the domain which is a hostname to which the e-mail message will be sent (example.com).

THE CODE:

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method='post'>

<table border='0'>

<tr>

<td>Email</td>

<td><input name='email' type='text' value="<?php if(isset($_REQUEST['email'])){ echo $_REQUEST['email']; } else { } ?>" id='email' /></td>

</tr>

<tr>

<td> </td>

<td><input type='submit' name='Submit' value='Validate' /></td>

</tr>

</table>

</form>

<?php

if(isset($_POST['email'])) {

//check with out function

$email = $_POST['email'];

print("Checking: $email<br>");

if (preg_match ("/^[\w\.-]{1,}\@([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]+$/", $email)) {

print("Format Test: PASSED<br>");

print("Online host verification Test...<br><br>");

print("MX Records for: $email<br>");

list($alias, $domain) = explode("@", $email);

if (checkdnsrr($domain, "MX")) {

getmxrr($domain, $mxhosts);

foreach($mxhosts as $mxKey => $mxValue){

print("     $mxValue<br>");

}

print("Online host verification Test: PASSED<br><br>");

print("Email Status: VALID");

} else {

print("     No records found.<br>");

print("Online host verification Test: FAILED<br><br>");

print("Email Status: INVALID");

}

} else {

print("Format Test: FAILED<br><br>");

print("Invalid email address provided.<br><br>");

print("Email Status: INVALID");

}

}

SCREEN SHOT

deliverable domain email address

click the image to enlarge

Not Deliverable domain name email address

Ajax File Upload

noreply@blogger.com (Unknown) — Mon, 27 Jul 2009 04:24:00 +0000

You might have seen Ajax File Uploading in some sites. The basic idea is to upload a file without refreshing the page. Some sites go even further by providing details on how much percentage is uploaded, etc. It is very easy to achieve this effect using javascript.

ajax file upload example

LightLoader Track Multiple File Uploads Using AJAX With Progress Bar

noreply@blogger.com (Unknown) — Mon, 27 Jul 2009 04:19:00 +0000

view live demo and download the souce code

AJAX file upload

noreply@blogger.com (Unknown) — Sun, 26 Jul 2009 02:44:00 +0000

view tutorial

Ajax upload

noreply@blogger.com (Unknown) — Sun, 26 Jul 2009 02:41:00 +0000

Browsers force us to use file inputs () for uploads, which are impossible to style. Moreover, form-based uploads look obsolete in modern AJAX applications. We can use flash to solve this problem, but JavaScript works nice too.
AJAX Upload allows you to easily upload multiple files without refreshing the page and use any element to show file selection window. It works in all major browsers and starting from version 2.0 doesn’t require any library to run (although it will use some jQuery functions if it’s already loaded on the page). AJAX Upload doesn’t pollute the global namespace, so it’s compatible with jQuery, Prototypejs, Mootools, and other JavaScript libraries

live demo and download

KoolUploader - PHP Ajax File Upload

noreply@blogger.com (Unknown) — Sun, 26 Jul 2009 02:37:00 +0000

In this example, you can add a number of files and click Upload button. The list of files will be uploaded sequentially, one file at a time.

Uploading many files simultaneously is great but consume more server power and bandwidth of connection. This will increase the chances of uploading failure if we do not have strong server or users do not have good connection. Sequential uploading is a solution.

click here to view the file upload script

Free php scripts downloads and tools

noreply@blogger.com (Unknown) — Wed, 22 Jul 2009 06:18:00 +0000

Object Oriented Programming with PHP Video Tutorial

noreply@blogger.com (Unknown) — Sun, 14 Jun 2009 13:20:00 +0000

view tutorial

PHP: Working with Directories

noreply@blogger.com (Unknown) — Tue, 02 Jun 2009 08:42:00 +0000

PHP: Working withDirectories

As is necessary for any language, PHP has a complete set of directory support functions. PHP gives you a variety of functions to read and manipulate directories and directory entries. Like other file-related parts of PHP, the functions are similar to the C functions that accomplish the same tasks, with some simplifications. This tutorial describes how PHP handles directories. You will look at how to create, remove, and read them.

Reading the Contents of a Directory
Deleting the Directory and Its Contents
Creating New Directories

Reading the Contents of a Directory

Let's start with simple listing the contents of a directory. We need three functions to perform this task: opendir(), readdir() and closedir(). The opendir() function takes one parameter, which is the directory we want to read, and returns a directory handle to be used in subsequent readdir() and closedir() calls. opendir() returns False if the directory could not be opened.

The readdir() function takes one parameter, which is the handle that opendir() returned and each time we call readdir() it returns the filename of the next file in the directory. readdir() returns False if the end of the directory has been reached. Note that readdir() returns only the names of its items, rather than full paths.

The example below creates a select box that lists all the files in a directory. Copy and paste this code and save it as index.php in a directory you wish do display all files for. It automatically excludes itself from the list, and is easy to modify to make it ignore other files as well:

<?php
// open the current directory
$dhandle = opendir('.');
// define an array to hold the files
$files = array();

if ($dhandle) {
   // loop through all of the files
   while (false !== ($fname = readdir($dhandle))) {
      // if the file is not this file, and does not start with a '.' or '..',
      // then store it for later display
      if (($fname != '.') && ($fname != '..') &&
          ($fname != basename($_SERVER['PHP_SELF']))) {
          // store the filename
          $files[] = (is_dir( "./$fname" )) ? "(Dir) {$fname}" : $fname;
      }
   }
   // close the directory
   closedir($dhandle);
}

echo "<select name=\"file\">\n";
// Now loop through the files, echoing out a new select option for each one
foreach( $files as $fname )
{
   echo "<option>{$fname}</option>\n";
}
echo "</select>\n";
?>

First, we open the directory for reading with the opendir() function and use a while statement to loop through each of its entries. We call readdir() as part of the while statement's test expression, assigning its result to the $fname variable. We are explicitly testing whether the return value is equal to and of the same type as False since otherwise, any directory entry whose name evaluates to False will stop the loop prematurely. Within the body of the while statement, we check if the file is not this file, and does not start with a . (current directory) or .. (parent directory) and then store the file name into the $files array. We also do one more check. If a full file path leads to a directory then we add to the file name "(Dir)".

There is another way to iterate over all files in a directory. PHP 5 has a set of objects called iterators. Iterators help eliminate problems in your code. For instance, PHP 5 provides a DirectoryIterator:

<?php
echo "<select name=\"file\">\n";
foreach (new DirectoryIterator('.') as $file) {
   // if the file is not this file, and does not start with a '.' or '..',
   // then store it for later display
   if ( (!$file->isDot()) && ($file->getFilename() != basename($_SERVER['PHP_SELF'])) ) {
      echo "<option>";
      // if the element is a directory add to the file name "(Dir)"
      echo ($file->isDir()) ? "(Dir) ".$file->getFilename() : $file->getFilename();
      echo "</option>\n";
   }
}
echo "</select>\n";
?>

This example produces the same results as the earlier code that uses the directory functions, but this code is shorter and safer because you cannot forget the !== = comparison.

Deleting the Directory and Its Contents

PHP has the rmdir( ) function that takes a directory name as its only parameter and will remove the specified directory from the file system, if the process running your script has the right to do so. However, the rmdir() function works only on empty directories. The example below deletes empty directory named "temporary":

<?php
rmdir( "temporary" );
?>

If you want to delete non-empty directory, you should use the recursion. In the following example we create recursive function named deleteDir() that takes a directory name as a parameter and will go through each subdirectory, deleting files as they go. When the directory is empty, we use rmdir() to remove it.

<?php
function deleteDir($dir) {
   // open the directory
   $dhandle = opendir($dir);

   if ($dhandle) {
      // loop through it
      while (false !== ($fname = readdir($dhandle))) {
         // if the element is a directory, and
         // does not start with a '.' or '..'
         // we call deleteDir function recursively
         // passing this element as a parameter
         if (is_dir( "{$dir}/{$fname}" )) {
            if (($fname != '.') && ($fname != '..')) {
               echo "<u>Deleting Files in the Directory</u>: {$dir}/{$fname} <br />";
               deleteDir("$dir/$fname");
            }
         // the element is a file, so we delete it
         } else {
            echo "Deleting File: {$dir}/{$fname} <br />";
            unlink("{$dir}/{$fname}");
         }
      }
      closedir($dhandle);
    }
   // now directory is empty, so we can use
   // the rmdir() function to delete it
   echo "<u>Deleting Directory</u>: {$dir} <br />";
   rmdir($dir);
}

// call deleteDir function and pass to it
// as a parameter a directory name
deleteDir("temporary");
?>

Another way to delete non-empty directory is to use RecursiveDirectoryIterator and RecursiveIteratorIterator. The RecursiveIteratorIterator must be told to provide children (files and subdirectories) before parents with its CHILD_FIRST constant. Have a look at the code:

<?php
function deleteDir($dir) {
   $iterator = new RecursiveDirectoryIterator($dir);
   foreach (new RecursiveIteratorIterator($iterator, RecursiveIteratorIterator::CHILD_FIRST) as $file)
   {
      if ($file->isDir()) {
         rmdir($file->getPathname());
      } else {
         unlink($file->getPathname());
      }
   }
   rmdir($dir);
}

deleteDir("temporary");
?>

Note: The CHILD_FIRST constant was added with PHP 5.1

Creating New Directories

Creating new directories in PHP is accomplished using the mkdir() function, which takes two parameters. These parameters are, in order, a directory name you want to create and a permission mode for a new directory, which must be an octal number. The mode parameter is optional and has an effect only on Unix systems. Have a look at the example:

<?php
// if /path/to/my exists, this should return true
// if PHP has the right permissions
mkdir("/path/to/directory", 0777);
?>

By default, the mkdir() function only creates a directory if its parent exists. In PHP 5 the recursive parameter was added which should be true or false, depending on whether you want to create parent directories or not. In the following example, we pass true as a third parameter to mkdir(), so this makes the function act recursively to create any missing parent directories.

<?php
// will create /path/to/directory and
// also create /path and /path/to if needed and allowed
mkdir("/path/to/directory", 0777, true);
?>

PHP Tips and Tricks

noreply@blogger.com (Unknown) — Thu, 07 May 2009 02:02:00 +0000

Generate random password

1
2
3
4
5
6
7
8
9
10
11
12
13
14

<?php

function generatePassword($length) {
$character = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$password = "";
for($i=0;$i<$length;$i++) {
$password .= $character[rand(0, 61)];
}
return $password;
}

echo generatePassword(7);

?>

Calculate age

1
2
3
4
5
6
7
8
9
10
11
12

<?php

$testcase = array("12-03-1985", "15-01-1987", "01-01-2000");

function getAge($year) {
return floor(abs(strtotime('now') - strtotime($year))/31536000);
}

foreach($testcase as $test) {
echo "Born in $test, approximately age is " . getAge($test)." years<br/>";
}
?>

Get visitor’s IP address

1
2
3
4
5

<?php

echo "Your IP address is " . $_SERVER['REMOTE_ADDR'];

?>

Check even or add number

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

<?php

$testcase = array(1, 4, 5, 6, 11);

function isOdd($number) {
if ($number % 2 == 0) {
return false;
}
return true;
}

foreach($testcase as $test) {
if (isOdd($test)) {
echo $test . " is odd<br/>";
} else {
echo $test . " is even<br/>";
}
}

?>

Get file extension

1
2
3
4
5
6
7
8
9
10
11
12
13

<?php

$testcase = array("sample.txt", "sample.jpg", "sample.case.txt");

function extension($filename){
return substr(strrchr($filename, '.'), 1);
}

foreach($testcase as $test) {
echo "Extension from $test is " . extension($test) . "<br/>";
}

?>

Sort data in array

1
2
3
4
5
6
7
8
9
10

<?php

$data_list = array("lychee", "pineapple", "apple", "mango", "strawberry", "banana", "orange", "grape", "guava");

sort($data_list);
foreach($data_list as $data) {
echo $data . "<br/>";
}

?>

Random pick from array

1
2
3
4
5
6
7
8
9
10
11
12
13

Shuffle data

1
2
3
4
5
6
7
8
9
10

<?php

$data_list = array("lychee", "pineapple", "apple", "mango", "strawberry", "banana", "orange", "grape", "guava");

shuffle($data_list);
foreach($data_list as $data) {
echo $data . "<br/>";
}

?>

Highlight text

1
2
3
4
5
6
7
8
9

<?php

$text = "Sample sentence from KomunitasWeb, regex has become popular in web programming. Now we learn regex. According to wikipedia, Regular exspanssions (abbreviated as regex or regexp, with plural forms regexes, regexps, or regexen) are written in a formal language that can be interspanted by a regular exspanssion processor";

$text = spang_replace("/\b(regex)\b/i", '<span style="background:#5fc9f6">\1</span>', $text);

echo $text;

?>

Change to title case (first letter uppercase)

1
2
3
4
5
6
7
8
9
10
11
12

<?php
$testcase = array("hello world", "Hello WORLD", "heLLO world");

function titleCase($text) {
return ucwords(strtolower($text));
}

foreach($testcase as $test) {
echo titleCase($test)."<br/>";
}

?>

Time since

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

<?php

$testcase = array("12-03-1985", "15-01-2007", "04-04-2009", "01-01-2009", "30-03-2009", "07-04-2009", "07-04-2009 11:12");

define("MINUTE", 60);
define("HOUR", 3600); // 60 * 60
define("DAY", 86400); // 60 * 60 * 24
define("WEEK", 604800); // 60 * 60 * 24 * 7
define("MONTH", 2592000); // 60 * 60 * 24 * 30
define("YEAR", 31536000); // 60 * 60 * 24 * 365

function timeSince($date) {

$since = abs(strtotime('now') - strtotime($date));

if($since > YEAR) {
$year = floor($since / YEAR);
return "more than $year year(s) ago";
}

if ($since > MONTH) {
$month = floor($since / MONTH);
return "about $month month(s) ago";
}

if ($since > WEEK) {
$week = floor($since / WEEK);
$day = floor(($since - ($week * WEEK)) / DAY);
return "about $week week(s), and $day day(s) ago";
}

if ($since > DAY) {
$day = floor($since / DAY);
$hour = floor(($since - ($day * DAY)) / HOUR);
return "about $day day(s), $hour hour(s) ago";
}

if ($since > HOUR) {
$hour = floor($since / HOUR);
$minute = floor(($since - ($hour * HOUR)) / MINUTE);
return "about $hour hour(s), $minute minute(s) ago";
}

if ($since > MINUTE) {
$minute = floor($since / MINUTE);
return "$minute minute(s) ago";
}

return "under 1 minute ago";

}

foreach($testcase as $test) {
echo "Time since $test is " . timeSince($test)."<br/>";
}

?>

Protecting Your PHP/MySQL Queries from SQL Injection

noreply@blogger.com (Unknown) — Thu, 30 Apr 2009 07:50:00 +0000

SQL injection is a serious concern for webmasters, as an experienced attacker can use this hacking technique to gain access to sensitive data and/or potentially cripple your database. If you haven’t secured your applications, I implore you to get yourself familiar with the following method and grind it into your coding routine. One unsafe query can result in a nightmare for you or your client.

In PHP the easiest way is to pass your data through the mysql_real_escape_string function. By escaping special characters on fields where the user can manipulate the database, you will avoid being vulnerable. Take a look below at the example of what to do and what not to do.

// This is a vulnerable query.
$query = "SELECT * FROM products WHERE name=’$productname’";
mysql_query($query);

// This query is more secure
$query = sprintf("SELECT * FROM products WHERE name=’%s’",
mysql_real_escape_string($productname));
mysql_query($query);

Since I primarily code in PHP, I can’t confidently provide techniques for other programming languages. The most important part of protecting yourself is stopping users from being able to pass unaltered database manipulative special characters, like single quotes.

User Authentication with Image Verification Using PHP and MYSQL

noreply@blogger.com (Unknown) — Wed, 29 Apr 2009 10:57:00 +0000

View Source Code

Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.

noreply@blogger.com (Unknown) — Wed, 29 Apr 2009 10:54:00 +0000

View The Tutorial

SQL Server 2000 vs MySQL version 4.1

noreply@blogger.com (Unknown) — Wed, 29 Apr 2009 10:50:00 +0000

View Tutorial

Uploading Files and Downloading Files From MySQL Database

noreply@blogger.com (Unknown) — Mon, 27 Apr 2009 08:36:00 +0000

File Uplod & Download From Mysql Using Php

Secure file upload in PHP web applications

noreply@blogger.com (Unknown) — Mon, 27 Apr 2009 08:28:00 +0000

Click Here to View File Upload (Pdf document)

Upload Files to MySQL using PHP Tutorial

noreply@blogger.com (Unknown) — Mon, 27 Apr 2009 08:24:00 +0000

Upload Files to MySQL using PHP Tutorial

Posted using ShareThis

Populate triple drop down list from database using Ajax and PHP

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 15:17:00 +0000

view live demo

download source code

How to connect to MS Access with PHP - PHP code example

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 15:06:00 +0000

Php-MS Access connection link

create popup window using onclick event in javascript

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 14:41:00 +0000

CLICK HERE TO THE SOURCE CODE OF POP WINDOW EXAMPLE 1

CLICK HERE TO THE SOURCE CODE OF POP WINDOW EXAMPLE 2

CLICK HERE TO THE SOURCE CODE OF POP WINDOW EXAMPLE 3

PHP - MYSQL SECURE DATABASE CONNECTION

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 14:15:00 +0000

Example #1 mysql_connect() example

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

Example #2 mysql_connect() example using hostname:port
// we connect to example.com and port 3307
$link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

// we connect to localhost at port 3307
$link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

Example #3 mysql_connect() example using ":/path/to/socket" syntax
// we connect to localhost and socket e.g. /tmp/mysql.sock

//variant 1: ommit localhost
$link = mysql_connect(':/tmp/mysql', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

// variant 2: with localhost
$link = mysql_connect('localhost:/tmp/mysql.sock', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

Notes

Note:
Whenever you specify "localhost" or "localhost:port" as server, the MySQL client library will override this and try to connect to a local socket (named pipe on Windows). If you want to use TCP/IP, use "127.0.0.1" instead of "localhost". If the MySQL client library tries to connect to the wrong local socket, you should set the correct path as Runtime Configuration in your PHP configuration and leave the server field blank.

Note:
The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling mysql_close().

Note: You can suppress the error message on failure by prepending a @ to the function name.

Note: Error "Can't create TCP/IP socket (10106)" usually means that the variables_order configure directive doesn't contain character E. On Windows, if the environment is not copied the SYSTEMROOT environment variable won't be available and PHP will have problems loading Winsock.

PHP/MySQL Tutorial - Single Records & Error Trapping

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 13:02:00 +0000

Introduction

In the past two parts of this tutorial I have shown you how to take data out of the database and display it on screen. In this part I will enter into the final aspect of this data displaying, selecting one piece of data and stopping errors from happening when you output data.

Error Trapping

By outputting all the information from the database, it is quite unlikely that there will be no data, but if you allow updating and deleting of records, it is certainly a possibility. Luckily, with PHP and MySQL, there is an easy way round this using:

$num=mysql_numrows($result);

where $result contains the result of a query on the database (like selecting all the records). As I expalined before, this will set the value of $num as the number of rows in the result (and it was used in a loop in part 4). Because of this you can make a simple error trap using an IF statement:

if ($num==0) {
echo "The database contains no contacts yet";
} else {
Output Loop
}

You can expand on this more by making it more user friendly (for example by providing a link to the Add Data page if no contacts exist).

Ordering Data

Not only can you output data based on the contents of a field, but you can also order the output based on a field (for example placing users in alphabetical order). By default, the output from your queries will be in order of the id field, going from 1 upwards. You can sort it on any field, though.

For example, a useful sort would be to place all the users in alphabetical order based on their last name. For those not familiar with standard databases, this would be in Ascending order as it goes from A to Z. (Ascending order is also for 1-10 etc. and descending order provides Z to A and 10-1). To do this you would use the following query:

SELECT * FROM contacts ORDER BY last ASC

You could also use DESC to order the data in Descending order.

More Uses Of mysql_numrows and Sorting

The value you have assigned to $num is very imiportant as, apart from error trapping and loops, it has many other uses. An example of this would be to print out only the last 5 records added to a database. Firstly, they would need to be placed into order based on the id field (as the one with the latest ID would have been added last. This would require them to be in Descending order.

Now you have them in order of newest to oldest but this does not restrict the script to only showing the first 5. To do this, you would need to set your loop to run to 5 instead of $num (as this would only run the loop 5 times so only 5 records would be output).

Of course, before doing this, it would be important to check that $num was greater than 5, as if you ran the loop 5 times and there were only 3 rows you would get an error. This is easy to do though and the following code is an example of the sort of thing you would want to have:

if ($num>5) {
$to=5;
}else{
$to=$num;
}

$i=0;
while ($i < $to) {
REST OF CODE

This code would check if there were more than 5 rows in the database. If there were, the loop would be set to run 5 times. If there were less than 5 rows the loop would run the correct number of times to output the whole database.

The ID Field

If you remember back to creating the database for the contacts at the beginning of this tutorial, you will remember that we included a numerical field called id. This field was set as auto_increment as well as being the primary field. I have already explained how this field is unique for every single record in the database, but I will now take this a stage further by explaining how this can be used to select an individual record from a database.

Selecting A Single Record

At the end of the last part of this tutorial, I s
howed you how to select records from the database based on the contents of partiular fields using:

SELECT * FROM contacts WHERE field='value'

Now, by using the unique ID field we can select any record from our database using:

SELECT * FROM contacts WHERE id='$id'

Where $id is a variable holding a number of a record. This may seem to be a little worthless as it is, but you can use this very effectively in a number of different ways. For example, if you wanted to have a dynamically generated site run through a database and a single PHP script, you could write the script to include the database data into the design. Then, using the id field, you could select each individual page and put it into the output. You can even use the page's URL to specify the record you want e.g.

http://www.yoursite.com/news/items.php?item=7393

And then have the PHP script look up the record with the id corresponding to $item, which in this case would be 7393

Links For Single Records

Using this method of choosing a record using the URL to select the record can be expanded further by generating the URL dynamically. This sounds a bit complicated so I will elaborate. In the contacts script we are writing, I will be showing you how to create an Update page where the user can update the contact details.

To do this, another column will be included in the output column, with an Update link in it. This update link will point to a page allowing the user to update the record. To select the record in this page, we will put:

?id=$id

By getting the id of the record along with the other information when we are outputting the information from the database, this code will create a link which has each record's ID number in it. Then, on the update page, there can be code to just select this item.

PHP/MySQL Tutorial - Updating & Deleting

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 12:59:00 +0000

Introduction

So far you have learnt how to put information into your MySQL database, view the information in it and select which information you would like to view. In this part I will show you how to do the two final actions, updating your database and deleting records from it.

The Update Script

Last week I explained how to create a link for each record to point to your update script. By using the $id variable you output links which would pass the correct ID to the script so that it can update the database. Using this you can then create the update script, which will actually have two sections to it.

Displaying The Update Page

The first part of the update script uses the single record selection from last week but adds a little HTML to it to make it more useful. First of all, we connect to the database and select the appropriate record.

$id=$_GET['id'];
$username="username";
$password="password";
$database="your_database";
mysql_connect(localhost,$username,$password);

$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) { $first=mysql_result($result,$i,"first"); $last=mysql_result($result,$i,"last"); $phone=mysql_result($result,$i,"phone"); $mobile=mysql_result($result,$i,"mobile"); $fax=mysql_result($result,$i,"fax"); $email=mysql_result($result,$i,"email"); $web=mysql_result($result,$i,"web"); Space For Code ++$i; } Where 'Space For Code' is in this script is where the code for the update page will go. This is, in fact, just HTML formatting for the output:

As you can see, this code will output a standard form, but instead of having blank boxes like on the form for inserting a new record, this one already has the current information from the database inserted into it. This makes it much more effective for an update script.

Updating The Database

The next stage of this script is to actually update the database. This is a simple operation and just involves a new query for the database:

$query = "UPDATE contacts SET first = '$ud_first', last = '$ud_last', phone = '$ud_phone', mobile = '$ud_mobile', fax = '$ud_fax', email = '$ud_email', web = '$ud_web' WHERE id = '$ud_id'";

This query tells the database to update the contacts table where the ID is the same as the value stored in $ud_id (which as you can see from the form on the previous page was set as the id of the record we are updating) and to set the following fields to the specified values (which were set using the form on the previous page).

This query could then be integrated into a simple script:

$ud_id=$_POST['ud_id'];
$ud_first=$_POST['ud_first'];
$ud_last=$_POST['ud_last'];
$ud_phone=$_POST['ud_phone'];
$ud_mobile=$_POST['ud_mobile'];
$ud_fax=$_POST['ud_fax'];
$ud_email=$_POST['ud_email'];
$ud_web=$_POST['ud_web'];

$username="username";
$password="password";
$database="your_database";
mysql_connect(localhost,$username,$password);

$query="UPDATE contacts SET first='$ud_first', last='$ud_last', phone='$ud_phone', mobile='$ud_mobile', fax='$ud_fax', email='$ud_email', web='$ud_web' WHERE id='$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();

This code would update the database and give the user a confirmation.

Deleting Records

The final part of the contacts database which needs to be created is a page to delete records. As with the Update page, this should have a record ID sent to it in the URL e.g.:

delete.php?id=9

The code to do this is the same as to update the database, except with a slightly different MySQL query. Instead of the UPDATE query you should use:

DELETE FROM contacts WHERE id='$id'

This would then be used with the connection and confirmation code as above.

Loops

At this time it seems appropriate to mention another use of loops with a database. As well as using a loop to get information from a database as we have before, you can also use loops to execute queries. For example, if you wanted to change all the records in the database with the last name Smith to have the website www.smith.com:

Standard Database Connection Code

$query=" SELECT * FROM contacts WHERE last='Smith'";
$result=mysql_query($query);
$num=mysql_numrows($result);

$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$query1="UPDATE contacts SET web='http://www.smith.com' WHERE id='$id'";
mysql_query($query);
++$i;
}

mysql_close();

Of course, this could have been achived far easier and quicker using:

$query1="UPDATE contacts SET web='http://www.smith.com' WHERE last='Smith'";

and no loop.

PHP/MySQL Tutorial [ Finishing The Script]

noreply@blogger.com (Unknown) — Sun, 26 Apr 2009 12:52:00 +0000

Introduction

Throughout this tutorial I have taught you how to use PHP to interact with a MySQL (or SQL) database and how to use the most common commands available. I have, throughout this tutorial, also shown you how to create a basic contacts management system to illustrate some of the options you can use. In this part I will show you some final MySQL tips and will give you a final version of the script.

Saving Time

When creating complex scripts using databases you will find that the most common thing you are doing is connecting to a database. Because of this, you can actually save time by creating either a username/password file or a connection file. For example for a username/password file you would create a file called:

dbinfo.inc.php

and put the following in it:

Replacing the appropriate sections. Then in your php files use the following code:

include("dbinfo.inc.php");

or
include("/full/path/to/file/dbinfo.inc.php");

at the beginning. Then, you can use the variables $username, $password and $database throughout your scripts without having to define them every time. Also, if you ever change this information, for example if you move to another web host, there is only one file to change.

You can use the same principal to connect to the database, by putting the connection code in the file, but you must always be sure to close the connection in each file or you may have problems with your MySQL server.

Searching

A limited form of searching can also be performed on your database using a built in MySQL function. This is by using the LIKE function as follows:

SELECT * FROM tablename WHERE fieldname LIKE '%$string%'

To explain furhter, LIKE tells the database to perform its 'searching' feature. The % signs mean that any other data could appear in their place and $string would hold your search string. In this place could be a word or number as well e.g.:

LIKE '%piano%'

which would output any rows with piano in the specified field.

Similarly, you can leave out one of the % signs so that you can specify the position of the string e.g.:

LIKE 'piano%'

Will only output rows where the specified field begins with piano, so:

The piano is next to the table.

Would not show up.

The Finished Script

Throughout this tutorial I have given you pieces of code to make a contacts database script. You can download the full script as a zip file so that you can examine the code (see Related Links).

Conclusion

From this tutorial you should now know the basics of using PHP and MySQL together to create database-enabled websites and programs. Using databases with the web opens up a huge new selection of things you can do and can make a simple website much more powerful, saving time updating the site, allowing user interaction and feedback and much more.

Email Form Script (AJAX)

noreply@blogger.com (Unknown) — Sat, 25 Apr 2009 15:49:00 +0000

DOWNLOAD SCRIPT

DEMO