PHP: Includes

You can include a file easily within a .php web page.

[PHP][/PHP]

To learn more visit the php.net site.

Technorati Tags: php, includes, sample code, ironvine, programming

90 Ajax Tutorials Ordered by Topic

Here is a nice resource of AJAX Tutorials from Max Kiesler found on ajaxlessons.com.

Some of the tutorial topics include:
AJAX Activity Indicator Tutorial
AJAX Bookmarklets Tutorial
AJAX Chat Tutorials
AJAX Drag and Drop Tutorial
...and many more.

PHP: Generate XML File From MySQL Records

How to generate a XML file from a MySQL database.

Create a database and name is db_toxml. Create a table in the database and name it tbl_mysqltoxml. Now create four fields in the table. The fields are as follows:

xml_tutorial_id: autoinc.
xml_tutorial_title: (varchar - 100)
xml_tutorial_link: (varchar - 250)
xml_tutorial_description: mediumtext

[php]

$dbh=mysql_connect ("localhost", "user", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("db_toxml");
$sql="SELECT * FROM tbl_mysqltoxml ORDER BY xml_tutorial_id DESC LIMIT 0,10";
$results = mysql_query($sql);
$number = mysql_num_rows($results);
$i=0;

while($i < $number){
$lesson = $lesson . "

" . mysql_result($results, $i, "xml_tutorial_link") . " " . mysql_result($results, $i, "xml_tutorial_description") . "
";
$i++;
}

$file = ('mysqlto.xml');
$fp = fopen($file, "w");
$write = fputs($fp, $news);
fclose($fp);
?>[/php]

PHP: Forms with Image Verification & Security Validation

Forms with Image Verification
DOWNLOAD NECESSARY FORMS HERE (ZIP FILE) >

In an effort to make web forms more secure and prevent spam I have developed a PHP based comment form with image verification. It was designed to make it very easy to use, and no need to modify any cgi files! You can have as many form fields as you like.

There are some instructions that you will need to follow.

1. Forms must be labeled as a .php file
2. Place php code at top of filename.php file at line 1
3. Place form code within html in spot where you want the actual form fields to appear.

SPECIAL NOTE: Only one form will work per page.

4. Place “Thank You” code near top of page (preferrably below page title, just above the content on the page)
5. Change the URL
6. Change Subject
7. Update form fields if need be. Make sure all fields are labeled. – If everything is standard you shouldn’t need to change anything.
8. Place the following files at the same level as the form: arial.ttf, background1.jpg, background2.jpg, background3.jpg, background4.jpg, randomimg.php, sesamefrm.inc.php, filename.php (the form itself)

Optional settings:
To have the page redirected, remove the # and change the redirect URL
To have cc emails add to the php code: $cc='thecc@emailhere.com';

Line 1 of filename.php

[PHP]< ?php
# Instructions:
# Save this file as .php
# Include this ?php section at line 1 of the file
# The submit button must be named 'submit'
# The verification textbox name must be named 'txtNumber' and be accompanied by
# Form action must call this page and be set to POST

# To Email Address
$email='to@emailhere.com';

# Subject
$subject='Web Site Comment Form';

# From Name
$sender='From Your Website';

# From Email Address
$sender_email='webadmin@emailhere.com';

# URL (no www.)
$drurl = "primaryurl.com";

# To use a URL redirect after submission remove the below '#'
# $next_url='http://www.ironvine.com/blog';

###########DO NOT CHANGE THIS LINE############
include("sesamefrm.inc.php");
##############################################
?>[/PHP]

Thank You Code

[PHP] if ($errorMessage != '') {
?>
< p align="center">

< ?php
}
?>[/PHP]

Add the Verification
[html]

Verification Code (case sensitive):

[/html]

HTML: Forms: State Select Drop-Down

[html]

Pick your state Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

[/html]