prefix."addressbook SET organisation = '".$wpdb->escape($_POST['organisation'])."', first_name = '".$wpdb->escape($_POST['first_name'])."', surname = '".$wpdb->escape($_POST['surname'])."', email = '".$wpdb->escape($_POST['email'])."', website = '".$wpdb->escape($_POST['website'])."', address_line1 = '".$wpdb->escape($_POST['address_line1'])."', address_line2 = '".$wpdb->escape($_POST['address_line2'])."', suburb = '".$wpdb->escape($_POST['suburb'])."', postcode = '".$wpdb->escape($_POST['postcode'])."', state = '".$wpdb->escape($_POST['state'])."', country = '".$wpdb->escape($_POST['country'])."', phone = '".$wpdb->escape($_POST['phone'])."', notes = '".$wpdb->escape($_POST['notes'])."'"; $wpdb->query($sql); ?>

Address added. Continue »

prefix."addressbook WHERE id='".$wpdb->escape($_GET['id'])."'"; $row = $wpdb->get_row($sql); if ($_GET['confirm']=='yes') { $wpdb->query("DELETE FROM ".$wpdb->prefix."addressbook WHERE id='".$wpdb->escape($_GET['id'])."'"); echo '

The address has been deleted. Continue »

'; } else { echo "

Are you sure you want to delete the following address?

".$row->first_name." ".$row->surname."
".$row->organisation."
".$row->email." ".$row->phone."
".$row->address_line1."
".$row->address_line2."
".$row->suburb." ".$row->postcode."
".$row->state."
".$row->country."
Notes: ".$row->notes."

[Yes] [No]

"; } } else if ($_GET['action']=='edit') { $sql = "SELECT * FROM ".$wpdb->prefix."addressbook WHERE id='".$wpdb->escape($_GET['id'])."'"; $row = $wpdb->get_row($sql); if ($_POST['save']) { $wpdb->query("UPDATE ".$wpdb->prefix."addressbook SET first_name = '".$wpdb->escape($_POST['first_name'])."', surname = '".$wpdb->escape($_POST['surname'])."', organisation = '".$wpdb->escape($_POST['organisation'])."', email = '".$wpdb->escape($_POST['email'])."', phone = '".$wpdb->escape($_POST['phone'])."', address_line1 = '".$wpdb->escape($_POST['address_line1'])."', address_line2 = '".$wpdb->escape($_POST['address_line2'])."', suburb = '".$wpdb->escape($_POST['suburb'])."', postcode = '".$wpdb->escape($_POST['postcode'])."', state = '".$wpdb->escape($_POST['state'])."', country = '".$wpdb->escape($_POST['country'])."', notes = '".$wpdb->escape($_POST['notes'])."', website = '".$wpdb->escape($_POST['website'])."' WHERE id ='".$wpdb->escape($_GET['id'])."'"); echo '

The address has been updated. Continue »

'; } else { ?>

Edit Address

prefix."addressbook"; If ($wpdb->get_var("SHOW TABLES LIKE '$table_name'")!=$table_name || get_option("addressbook_version")!=$addressbook_version ) { // Call the install function here rather than through the more usual // activate_blah.php action hook so the user doesn't have to worry about // deactivating then reactivating the plugin. Should happen seemlessly. _addressbook_install(); echo '

The Addressbook plugin (version '.get_option("addressbook_version").') has been installed or upgraded.

'; } ?>

Select an address from below to see its details displayed here.

This is version of the Addressbook plugin by Sam Wilson.
Please report any bugs and feature requests at samwilson.id.au/blog/addressbook-plugin.
Thankyou.

Add new address ↓

Addressbook

prefix."addressbook ORDER BY first_name"; $results = $wpdb->get_results($sql); foreach ($results as $row) { echo""; } ?>

Name	Organisation	Email address	Phone number
".$row->first_name." ".$row->surname."	".$row->organisation."	".$row->email."	".$row->phone."

id."-info' style='display:none'>

[Edit] [Delete]

".$row->first_name." ".$row->surname."
".$row->email." ".$row->phone."

"; if ($row->notes) { echo "

Notes: ".$row->notes."

"; } echo "

".$row->address_line1."
"; if ($row->address_line2) echo $row->address_line2."
"; echo $row->suburb." ".$row->postcode."
".$row->state."
".$row->country."

"; } ?>

Add Address

website; $out = '

                First name:
                
                Surname:
                
                Organisation:
                
                Email Address:
                
                Phone:
                
                Website:

                    Address Line 1:
                    
                    Address Line 2:
                    
                    Suburb:
                    
                    Postcode:
                    
                    State or Territory:
                    
                    Country:

Notes:

'; return $out; } function _addressbook_install() { global $wpdb, $addressbook_version; $table_name = $wpdb->prefix."addressbook"; $sql = "CREATE TABLE " . $table_name . " ( id mediumint(9) NOT NULL AUTO_INCREMENT, first_name tinytext NOT NULL, surname tinytext NOT NULL, organisation tinytext NOT NULL, email tinytext NOT NULL, phone tinytext NOT NULL, address_line1 tinytext NOT NULL, address_line2 tinytext NOT NULL, suburb tinytext NOT NULL, postcode tinytext NOT NULL, state tinytext NOT NULL, country tinytext NOT NULL, website VARCHAR(55) NOT NULL, notes tinytext NOT NULL, PRIMARY KEY (id) );"; require_once(ABSPATH . 'wp-admin/upgrade-functions.php'); dbDelta($sql); update_option('addressbook_version', $addressbook_version); } function addressbook_getselect($name) { global $wpdb; $out = ""; return $out; } add_filter('the_content', 'addressbook_list'); function addressbook_list($content) { global $wpdb; $sql = "SELECT * FROM ".$wpdb->prefix."addressbook ORDER BY first_name"; $results = $wpdb->get_results($sql); $out = "

\n". " ".$row->first_name." ".$row->surname."\n". " ".$row->email."\n". " ".$row->phone."\n". "
\n". " ".$row->address_line1."\n"; if ($row->address_line2) $out .= " ".$row->address_line2."\n"; $out .= " ".$row->suburb."\n". " ".$row->postcode."\n". " ".$row->state."\n". " ".$row->country."\n". "

\n"; return preg_replace("//", $out, $content); } ?>