phpDealerLocator 4.6
Contents
1. Export Zipcodes Export the contents of the zip code table to a CSV file 19 Delete Zipcodes Empty the entire zip code table Use cautiously Statistics List Statistics Statistics List Dealer Statistics Count Statistics Export Statistics Delete Statistics List Zipcode Statistics List Statistics List Dealer Statistics List Zipcode Statistics List Statistics Displays a list of the individual results from searches List Dealer Statistics Displays a list of dealers that have been delivered in the results of searches and the number of hits for each dealer List Zipcode Statistics Displays a list of zip codes that have been delivered in the results of searches and the number of hits for each zip code Count Statistics Shows the number of search results delivered for each zip code The figures are not the number of searches for that zip code A search that yields ten results for a search zip code adds ten to the count for that zip code Export Statistics Export the contents of the statistics table to a CSV file Delete Statistics Reset the entire set of statistics to zero values Use cautiously Category Category Add Edit Categories Upload Categories Export Categories Delete Category Add Edit Categories Add or edit the category table one record at a time via a form Upload Categories Upload category information from a CSV file The contents of the uploaded category file are2. Installation Information Record the following information for your site as a reference for the future Even if you have someone else install your locator you ll have to provide this information You ll find an online example of a default phpDealerLocator administration interface ES Databasehost installation at the following address You may want to refer to it while reading this manual You may log on using the logon name admin and password 1234 a http phpdealerlocator yourphppro com demo Organize phpDealerLocator Files After downloading the phpDealerLocator archive file zip file expand the entire archive to a new directory on your local computer Once that is done locate the Windows executable file phpDealerLocator_Setup exe That is the file you will need to run It will walk you through the rest of the installation Once the files are uploaded to your webserver you ll see that the webserver contains four directories e admin The admin interface for managing your dealer records and the dealer locator installation e Database SQL script file for creating the tables in the phpDealerLocator database SQL script file for creating the zip code table and CSV file in four parts to avoid upload size restrictions on some systems with examples of dealer information for testing e logins The interface that allows dealers to modify their own listings optional feature you may choose not to implement
3. lt td s phpDealerLocati yle DataTD gt Dealer_Country snbsp lt td gt lt td s phpDealerLocat tyle DataTD gt lt form action http maps yahoo com py maps py target xlocator gt lt input type image src http us il yimg com us yimg com i us mp gr mplogo gif width 99 height 13 border 0 gt lt input type hidden name addr value Dealer_Ad form gt lt td gt lt tr gt lt END Row gt lt BEGIN NoRecords gt lt tr gt lt td class phpDealerLocatorStyle DataTD colspan 9 gt No records lt td gt lt tr gt lt END NoRecords gt lt tr gt lt td class phpDealerLocatorStyle FooterTD nowrap align center colspan 9 gt lt BEGIN Navigator Navigator gt S2SS1BEGINEIESE ON S lt a class phpDealerLocatorStyle NavigatorLink href First_URL gt First lt a gt lt i ENDIEIESEOne gt lt t BEGIN First Off SFirst lt END First Off gt S155 BEGIN Prev On gt lt a class phpDealerLocatorStyle NavigatorLink href Prev_URL gt Prev lt a gt lt END Srevl0n lt BEGIN Prev_Off gt Prev lt END Prev Off gt anbsp lt BEGIN Pages gt S15 BEGIN Page On gt lt a class phpDealerLocatorStyle NavigatorLink href Page URL gt Page Number lt a gt snbsp lt gt END Page Of gt Upload Format Problem Fatal error Unable to read 27840 bytes in home webserver example com dealer_locator Classes
4. e an d e di t their dea ler recor d Dea lers Address http phpdealeriocator yourphopro com demo 4 6 admin edit_dealers php Dealer_1D 00000003 Bo phpDealerLocator v4 6 Classic can edit only their own record za Add Edit Dealers Address Line 1 of dealer s street address Sai Address2 Line 2 of dealer s street address isooAmpnereare Foxe Mountain View City Dealer s city 5 USA ltest example com State Dealer s state SS p i 650 253 0001 ex 000 000 0000 http www google com wwew example com Zip Dealer s zip code 5 digit zip codes for U S Co Moitas applications The zip code field allows 7 digits to accommodate Canadian postal codes Country Dealer s country ise Ta mm dd yyyy h nn ss 09 18 2006 17 14 46 mm dd yy h nn ss Email Dealer s email address 9 18 06 05 16 37 PM Phone Dealer s phone number Fax Dealer s fax number Browse Submit Website Dealer s web site address To provide a 2006 vournro com functional link on the results pages the address must be fully qualified address e g http www example co
5. made PHP applications and we offer complete technical support services and customization for each We can also create new PHP applications to suit your specific need phpDealerLocator Installation Services For the quickest and easiest installation of your locator application let Your PHP Pro install the software for you Typically an installation can be completed at a cost of 55 with the entire installation ready for use on the same day you make the request Call us for details phpDealerLocator Custom Programming If you want to customize you phpDealerLocator installation consider having Your PHP Pro do the job for you We ll work to your specifications and desires and we l complete the job promptly at a cost that will surprise you If you don t have a background in PHP coding and don t want to spend the time learning something you might not need again just call us Even if you re a PHP expert we can offer a cost effective alternative to doing the work yourself Think of us a additional staff available on demand We re highly effective and efficient at customizations After all we wrote the code and we work with it every day Support Rates and Details We offer support to our software customers using several standard rate plans We can also custom tailor a support package to your needs Just call to describe your needs Support time is purchased using a secure server on the web at www YourPhpPro com We accept VISA Maste
6. receive a higher priority in the list order of a results page Preferred dealers are listed before non preferred dealers Last Modified The date of the last modification to a dealer record Note that the value shown in the edit screen is NOT the value stored in the database but the current date When you submit the edits the current date or another value you enter manually is written to the table Last Emailed The date of the last email sent by phpDealerLocator to the address in the dealer record You may manually edit the date Directions A text field normally used to provide driving directions to the dealer s location It may be used for any other purpose you choose The field allows up to 32k of text information Logo A graphic file to be displayed with the dealer record on the results pages GIF JPG and PNG files are permitted but you can change the filetype by modifying the phpDealer_img_typelist config variable You may set the maximum logo file size and the maximum height and width of the image in the config php The defaults are 50k and 75 x 75 Logo Delete Delete the logo file from the server Form Buttons Add Appears only when creating a new record Clicking the button writes the information in the form to a new dealer record in the database Submit Appears only when editing a record Clicking the Submit button overwrites the edited information in the form to the existing record in the databa
7. so just break the file into smaller files and upload them sequentially Export Dealers Export a copy of the dealers table to a CSV file Delete Dealers Delete the entire contents of the dealer database Use cautiously Email Dealers Send an email to each dealer with an email address listed This feature is intended to be used with locator installations that allow dealers to edit their own database records It is very useful for periodic communications with dealers to show them the current record and remind them to update it if information is changed The contents of the email body are stored in the dealer_email txt file located in the admin folder The sender s email address and the reply address are specified in the config php file Zip Codes ZipCodes Add Edit Zipcodes Upload Zipcodes Export Zipcodes Delete Zipcodes Add Edit Zipcodes Add or edit the information for zip codes one record at a time via a form Upload Zipcodes Upload zip code information from a CSV file The contents of the uploaded zip code file is added to the current contents of the zip code table If you wish to completely replace the current zip code table with the uploaded information delete the contents of the table before uploading the CSV file Web hosts may set an upload limit that is smaller than the dealers or zip code files you want to upload to your locator If so just break the file into smaller files and upload them sequentially
8. the Themes folder as well as the logins folder gt Ifyou don t intend to allow dealers to log on and maintain their own records you can further reduce upload time and server storage requirements by not uploading the logins folder at all Please refer to your web host if you have questions on how to upload files Create a directory on the web server to contain dealer logo files using the directory name you specified in config php This is required even if you do not intend to use dealer logos The directory defined in config php for dealer images must exist on the server Even if you don t plan to use dealer logos you must create the directory and assign the proper permissions to allow the application to write files into that directory Setting File Permissions on the Server The directory containing your dealer locator installation need have only the read and execute permissions used for the rest of the HTML content The directory used to store dealer logos must also have read write permissions for the web server to create files in that directory when logos are uploaded 12 Testing Your Locator Using Sample Files gt You may want to test your application using sample data rather than entering a set of dealer records The phpDealerLocator_4 0_Test_Dealers csv files contains a listing of 42K dealers one for each zip code and is useful for demos and for debugging The files can be uploaded through the admin interface
9. 1 4 5 9 10 19 20 Price 50 00 45 00 42 50 40 00 34
10. Dealers is set to FALSE The main dealer admin interface screen is shown in the following figure The statistics shown describe how the dealer records have been searched for directly or indirectly Direct The record was shown to someone who clicked on the dealer link from a search listing Indirect 2 The listing was shown with E phpDealerLocator Dealer Microsoft Internet Explorer Eile Edit View Favorites Tools Help other dealers on a search results page E aa EE E es http phpdealerlocator yourphppro com demo 4 6 login index php Click Here to Modify Your Listing Opens a form page for modifying the dealer record phpDealerLocator v4 6 Classic Home Logout Dealer Administration List Statistics Lists each search transaction for this dealer Dealer Statistics Indirect Viewing Direct Viewing Total Viewings Today 0 Viewings This Week 0 Viewings This Month 0 0 Total Viewings Click Here to Modify Your Listing List Statistics c 2006 YourPHPPro com Internet Chapter Customizing phoDealerLocator Themes and_Templates phpDealer_ocator can be customized to exactly match the format used throughout your web site You also have full control over search features and results information shown to users The default configuration created when you install phpDealerLocator is fully functional and may be used as is However you ll probably want to i
11. Test your public locator installation by opening the search page in your web browser amp http www example com phpDealerLocator_4_6 You should see a page like the example here Experiment with the various search options and refer to Chapter 6 if you need assistance When you re done testing delete the sample dealer records using the Delete Dealers link on the admin page Use the Delete functions on the admin page Delete Dealers Delete Zipcodes Delete Ca tegories k very a phpDealerLocator Microsoft Internet Explorer Eek carefully You can delete 5e ce vew Favortes teos nep the entire contents of each O gt A AO AO krai Ol 2 table with only two mouse Address a http phpdealerlocator yourphppro com demo 4 6 v Bo clicks phpDealerLocator v4 6 Classic Search for a Dealer in your Country Search for a Dealer in your Area feng Select Value Search for a Dealer in your State State Select Value v Select Value v Required Search for a Dealer by Category With il Select value Required m Category Select Value ae ra c 2006 yourPHPPro com 13 Administrative Interface Test the administrative interface by opening the search page in your web browser a http www example com phpDealerLocator_4 6 admin You ll find an online example of a default phpDealerLocator administration interface installation a
12. YOUR PHP PRO Helping Customers Increase Profitability through Professional PHP Applications phpDealerLocator 4 6 YOUR PHP PRO phpDealerLocator 4 6 Revision History January 2 2006 1 00 First released version updated from old 3 6 manual January 6 2006 1 01 Updated to include functionality for the 4 5 1 release of phpDealerLocator which added the Delete All Unpublished and Delete All Unapproved links added to the admin interface September 18 2006 1 10 Updated to include functionality for the 4 6 release of phpDealerLocator YOUR PHP PRO phpDealerLocator 4 6 Your PHP Pro 3636 Hiawatha Boulevard Fort Wayne Indiana 46809 574 202 7729 Limited Agreement This is NOT a freely distributed script Distribution or allowing public access to password protected resources that make phpDealer Locator available to the public is strictly prohibited and violates the license agreement phpDealerLocator is a copyrighted program using versions beyond the public release without the purchase of a license or equivalent written permission violates the above license and violates fair use In short not limited to you MAY Install phpDealerLocator for one domain per license Modify phpDealerLocator for your OWN use You MAY NOT Distribute phpDealerLocator in any way in whole or part Release a fork of phpDealerLocator based on the contained code Selling the code for this program or a program derived
13. added to the current contents of the category table If you wish to completely replace the current category table with the uploaded information delete the contents of the table before uploading the CSV file Export Categories Export the contents of the category table to a CSV file Delete Category Empty the entire category table Use cautiously 20 Dealer Category Matrix Add Edit Upload Export Delete Dealer Category Dealer Category Dealer Category Dealer Category Matrix Matrix Matrix Matrix Add Edit Dealer Category Matrix Add or edit the information for the dealer_category _matrix table one record ata time via a form Upload Dealer Category Matrix Export Dealer Category Matrix Export the contents of the dealer_category_matrix table toa CSV file Delete Dealer Category Matrix Empty the entire dealer_category_matrix table Use cautiously Users Users Add Edit Users Delete Users Add Edit Users Add or edit the information for the users table one record ata time via a form This table contains the records for the administrative users Delete Users Empty the entire users table Use cautiously Dealer Database Status Total Dealers Total number of dealer records in the database Dealers UnPublished Total number of 2 dealers with the unpublished switch setto _Pea ers UnPublished 2 Click Here yes 7 Dealers UnA
14. ar the bottom of the page Enter the dealer information in the form that appears 14 Uploading Dealer Records You may prefer to create and maintain your dealer database using software on your local computer Or you may have another software system that maintains a dealer list for other eee aga Purposes that can export the information you need for Se ae the locator Either way it s easy to update or replace D ETE teenage your phpDealerLocator dealers table by importing a CSV phpDealerLocator v4 6 Classic file tone I Add Edit Dealers an Customizing for Your Web Site 1600 Amphitheatre Parkway The HTML files distributed with phpDealerLocator provide a basic dealer locator for your web site using a om default set of options and features You have full control over the features and appearance of the locator Look sn 29 000 for details and instructions in Chapter 5 ex 000 000 0000 650 253 0001 ex 000 000 0000 http www google com ex http vww example gt For most applications only the CSS and HTML files in the dealer installation should be edited Other than the config php file PHP files should be edited only by advanced users 09 18 2006 17 16 39 mm dd yyyy h nn ss 09 18 2006 17 14 46 Securit
15. atch the online example http phpdealerlocator yourphppro com demo gt This example shows a sample set of search features and search results You have full control over what search features are offered to users and what dealer information is shown on the results and the record page Search for a Dealer in your Area The most common method of searching for dealers uses a home zip code and a search radius Store Name Optional parameter to restrict the results to records containing a particular dealer name You may enter a complete store name or any portion of aname Boolean operators are not allowed Store State Optional parameter to restrict the results to records for a particular state gt phpDealerLocator automatically provides pull down values for each of the unique states that appear in the dealer table Category Optional parameter to restrict the results to records for a particular category You may assign multiple categories to a record However searches can be done based only ona single category Your ZIP Code The zip code you want use as the center of the search radius The zipcode is a required parameter 16 Within Miles The search radius to be used All records with zip codes within this radius will be displayed on the results pages The search radius is a required parameter gt The default array of search radius values includes these values 5 10 25 50 100 and 250 miles You may edit these valu
16. cator search page a dae res ults p age a nd reco rd Address hto hpdeslerlocater yourphopro com demo 4 6 results php sDesler_Businessiame 8e Dealer State 8e Desler_2p 940438e Dealer Radius 310 Ee s a a g e phpDealerLocator v4 6 Classic page List of Dealers in your Area Distance Miles name Address address2 gt city JJ state zip J country memo Maps Google Inc Headquarters Preferred Phone 650 253 0000 YAHOO Maps 0 00 Fax 650 253 0001 1600 Amphitheatre Parkway Mountain View CA 94043 USA Email test example com PCEN WebSite http www google com Category Google Inc Santa Monica Sales Phone 310 460 4000 YAHOO Maps 309 14 Fax 310 309 6840 604 Arizona Avenue Santa Monica CA 90401 USA Email Joost nar WebSite Category First Prev 1 of 1 Next Last a gs Mai Satellite Hybrid g p tyl ml fd 401 Name Google Inc Headquarters A 1600 Amphitheatre Parkway Mountain View CA 94043 USA Email test example com Nevada Phone 650 253 0000 Fax 650 253 0001 Website http www google com rower ot d Cacole x a B SH internet 17 Chapter Administration This chapter will walk you through the different administrative functions for maintaining phpDealerLaocator through the included admin interface phpDealerLocator Administration Interface Basics phpDealerLocator includes a convenient web based administration interface that allows you
17. e Themes 36 different themes or styles to modify the basic appearance of your locator application The default is Python simple and straightforward format Themes have no effect on the function of your locator only on the appearance gt Themes are intended only as a starting point for customizing your dealer locator s appearance For the most complete and flexible control over your locator use the CSS files that you use for the rest of your web site for your locator Configuring phpDealerLocator The config php file specifies basic configuration settings for your dealer locator Open config php in an HTML editor or text editor and replace the example values with your own values for the following parameters e Dealer Locator Title e Database Table Name Server Name Username Password e Email Addresses From and Reply for email sent by your locator application e System paths and website URL dealer image files 10 You may also use the values in the config php file to modify the look and feel of your locator Other appearance and feature settings are made in the template you select See chapter 5 for more information Setting up the Database After successful installation of phpDealerLocator your web browser should now be displaying the Post Installation screen for phpDealerLocator This application walks you through the process of creating the mySQL database creating and configuring the mySQL tables and making su
18. es in index html Advanced users can edit index php instead Search for a Dealer in your State Country and Category An alternative method of searching that lists all the dealer records for a selected state country or category Other search criteria including zip code ess http phpdealerlocator yaurphppro com demo 4 6 phpDealerLocator v4 6 Classic are ignored For category searches only a single ict fora Dasler ia your Gly category can be searched on at one time Search for a Dealer In your Area oom Sa Select Value Search for a Dealer in your State State Select Value v Search Search Results a Search for a Dealer by Category Select Value Required eet Category Select Value v The figure shows a portion of a typical search result 2006 yourPHPPro com gt Results can be sorted in ascending or descending order by each field Just click the heading or the sort arrows at the top of the column Click the link at the dealer name to open the full record page for that dealer gt Remember that you can modify the HTML template files to change both the content and the format of the peal octor Search Results Mirosaft rn Epler t h Ele Edit View Favorites Tools Help LJ o
19. for a full comparison of the editions and a description of the expanded installation and support provided with the premium editions How Does phpDealerLocator Work phpDealerLocator is installed on your web site as HTML PHP files and a database Web site users visit a search page to enter a zip code and other optional search criteria including a search radius phpDealerLocator searches a table of zip codes to identify all zip codes within the search radius The software calculates distances based on values of latitude and longitude for the center point of each zip code from the zip codes table phpDealerLocator then searches the dealers table for records in those zip codes and displays them in a results page for the web visitor gt Distances calculated by phpDealerLocator are from the center of the user s zip code to the center of the dealer s zip code For a user and dealer in the same zip code the calculated distance will be zero In addition to providing the user with basic location and contact information you can choose to include email links web site links and mapping links from Mapquest Yahoo or Google for each dealer What About Updates phpDealerLocator incorporates a standard zip code file that can be readily updated as the postal service updates zip code locations and adds new zip codes You can edit and maintain your dealer information on the web using the admin utilities included with phpDealerLocator Alternative
20. from phpDealerLocator without prior written consent is expressly forbidden Similarly redistributing this program or a program derived from phpDealerLocator over the Internet CD ROM or any other me dium is expressly forbidden without prior written consent Your PHP Pro makes no warranties of any kind expressed or implied including any warranty of merchantability or fitness for a particular purpose Your PHP Pro shall have no liability to any person or entity with respect to any liability loss or damage including indirect special incidental or consequential damages caused directly or indirectly by the use or performance of phpDealerLocator Reproduction or redistribution of the software or this document not in accordance with the license agreement is expressly prohibited by law and may result in severe civil and criminal penalties Anyone violating the aforesaid will be prosecuted to the maximum ex tent possible Copyright 2006 Your PHP Pro All Rights Reserved 3 Table of Contents Introduction and Background 5 Conventions and SyMbols cscseeeeeeenenenens 5 What is phpDealerLocator esssese00 6 Features TEIE A 6 Choose an Edition to Match Your Need sssssss2222222522 55 6 How Does phpDealerLocator Work 6 What About Updates csscssessseeeeseeeenees 7 How do Install phpDealerLocator 7 Hardware amp Software Requirements 8 Instal
21. he parameter for the variable phpDealerLocatorStyle Example phpDealerLocatorStyle Python 26 Changing the theme is a convenient way to quickly and easily change the appearance of your entire locator application gt You can customize a theme or create anew one by editing the gif and CSS files that define the theme HTML and PHP File Pairs In the root of the locator directory you ll see pairs of html and PHP files with the same main file name like index html and index php These two files provide the basic search page in the default locator The PHP file is the actual workhorse that finds records that match the search criteria and prepares the information for display The html file provides a friendly interface to the user to enable the user to tell the locator software what to search for These default html files are included in the root directly and have a corresponding PHP file that works with them to provide content The html files may be edited to customize the locator To edit a particular page you are viewing on the locator installation the URL lets you know what file to edit If you are on the results country php page the template to edit is results country html If the item you need to change appears on all locator pages you ll probably find it on the header and footer pages gt The phpDealerLocator html files provide a template that you may edit to customize the contents and appearance of your locator in
22. lati n S R 9 Installation Assistance 2 cseseeseseeeeeeeeees 9 Installation Information 2 0 0 eseeeeeeeeeeees 9 Organize phpDealerLocator Files 10 Configuring phpDealerLocator 01sseeeeee 10 Setting up the Database ccssseeeeeeeeeneeees 11 Uploading phpDealerLocator via FTP 12 Setting File Permissions on the Server 12 Testing Your Locator Using Sample Files 13 Administrative Interface s ccsseeseeeeeees 14 Creating Your Own Dealer Records 000 14 Customizing for Your Web Site ss000 15 Sec rity e ee nnana 15 Back up Your Installation and Your Database 15 Program Operation seeeeee 16 Search for a Dealer in your Area cssssseessee 16 Search in a State Country Category 00006 17 Search ReSUlts ART paenneen ne 17 Administration 2 ccccccceeeseeeeeseeeees 18 Interface Basics 00 18 Logging In as the Administrator 18 Logging Out as the Administrator 18 Elements of the Administration Interface 18 Dealers wcccceeccecceeeeeeeeeeeeeeeeeeeeneeneeeeeeeeeeeeeeennees 19 Zip COdeS wssccccnecccnececnnceeneceoneeonueseenesoenenennenes 19 Statistics wcccceeceeeeeeeeeeee scence aa aaa 20 Category ssccccncccnneccnnecenneceeneceeseseenesesnesnneeenae 20 Dealer Category Matrix ccscceceneceeecnseneeeeeenee
23. lays system information like PHP version mySQL version of queries executed by the mySQL server file system path and other variables Update Google Geocoding This link displays the total number of records that need to have their longitude latitude coordinates updated from Google Clicking this link will refresh to a page that will cycle through the dealers and update their longitude latitude coordinates Dealer Record Details The figure on the following page shows the default dealer record edit insert form page Each field is described in the text that follows To create a new dealer record load the dealer record editor from the Administration Interface and click the Add Edit Dealers Near the bottom of the form click the Add New Dealers link to open a blank input form To edit an existing record click the Add Edit Dealers link on the Administration Interface Then locate the record to be edited and open it by clicking the link at the Business Name gt Not all fields are required You may also choose to include data in some fields and not display that data to locator users by editing the HTML template file Business Name The dealer s business name Username Username for logging on to the dealers admin page Password Password for logging on to the dealers admin page 22 gt The dealer username and password are needed CE only if you choose to allow a dealer to log on to the Q D Psa ferms BS a a dm in in t e rf Z c
24. ly you can make edits in PHPMyAdmin or another database software tool You may even export the entire dealer table to a CSV file on your local computer and make edits using a variety of software including spreadsheets and text editors How do Install phpDealerLocator phpDealerLocator now includes a Windows based application that walks you through the process of installing the application on your webserver It includes a built in FTP client and a configuration editor Upon running the setup exe application it will ask you for the necessary information ftp username password hostname allow you to select the directory for installation and setup the mySQL database If you have basic familiarity Installation phpDealerLocator with HTML web servers and databases Remote Server Details you ll find it to be a simple process Enter the details of your FTP account and install location FTP login If you cannot use a Windows based FTP server address FTP port 21 application and would like an archive without the setup application please contact Your PHP Pro Alternatively Your FTP usemame FTP password Install location on FTP server PHP Pro can install and configure your This installer will create an install folder called php DealerLocator dealer locator application for you usually creste instal folder in within one day and always ata very reasonable cost Even if you re an Click Next to begin uploading or Cancel to exit thi
25. m Advanced users may modify the template to allow omitting http from the dealer records if desired Category A list of categories that can be used to describe the dealer and as criteria in the locator searches You may edit the category names to fit your needs amp Avoid changing categories after dealer records have been entered records may not reflect the new categories as you intended Publish One of two yes no switches used to determine whether a record is displayed in the results of a locator search If you set the switch value to no the dealer record will not appear in any results pages Approved One of two yes no switches used to determine whether a record is displayed in the results of a locator search If you set the switch value to no the dealer record will not appear in any results pages gt You can moderate dealers by using the config variables 23 phpDealer_AutoApprove_Dealers and phpDealer_SendAdminEmail_EditDealers Those two variables control whether dealer changes to their record are approved or whether they have to wait for admin approval If you want to receive an email when dealers edit their record set the second variable to TRUE Records edited by dealers will not be available for searches until a locator administrator sets the Approved switch if phpDealer_AutoApprove_Dealers is set to FALSE Preferred A yes no switch used to indicate that a record is to
26. mmediately customize the locator to match the rest of your web site You have full control over the search features by zip code only by state by country by category offered to users and over the dealer information presented in the results pages dealer name phone email address Customize your locator installation by editing the HTML files in the locator directory and the web site s CSS files It s most convenient to edit the locator files using the same WYSIWYG HTML editor you use for the rest of the web site This allows you to quickly remove add or relocate search features and tailor the information shown on the results page Before you jump into editing it s useful to know a bit about how phpDealerLocator works Background Your phpDealerLocator installation can be easily customized through your choice of themes and by editing the HTML code that creates the pages Themes deal with the appearance of the locator pages and define fonts colors text sizes and other properties The structure and content of the locator pages is modified by editing the locator s HTML files Advanced users may also edit the PHP files Themes PhpDealerLocator is distributed with a set of more than 50 themes to choose from A theme consists of a set of gif files and a CSS file The Python theme is specified in the default locator setup You can select a different theme by editing the config php file and setting the theme name as t
27. nennunes 21 USETS mectececteuteseceececesteucesedcnceeesseuteeesencceenens 21 Dealer Database Status sssssss222522202220u220u22002202 55 21 Dealer Record Details sssscccsseeeeeseeeeeeseeeeeeees 22 Form Buttons cccceeece scence eee sense eeeee ee eeeeeeeeeeeeeeeeeeeeeeee 24 Dealer Interface cccccceseeceeeeeeeeeeeeseeeeeeeseeeeeees 24 Customizing phpDealerLocator 26 Background fi Reel eeeerneee 26 THEMES ccccccccamenectttescceccccnqdeinenes soc ctiissscscsscscsscscsscss 26 HTML and PHP File Pairs sssssasunnsunnnunnnnnnnnnnnnnnnnnnnnnnnnnnnna 27 Program Parameters in Code sscccncccnnncccnnsecnncesnnnenunsenanes 28 Customizing the Administrative Interface 29 Common Questions and Issues c00 30 Potential Problems sscsesecssscnseeceeeseneeeeeesees 30 Images Directory Not Found s 2 22 2 2 2 22 2 30 Pages Not Being Processed 30 Pages Not Being Displayed Properly 31 Upload Format ProbleM 31 Have a Problem Where Can Find Help ccesnccnnncennneennnen 31 Showcase of Customer SiteS ccccccceee 32 Software amp Services from Your PHP Pro 33 phpDealerLocator Installation Services s0ss00000 33 phpDealerLocator Custom Programming 33 Support Rates and Details ccsscsss
28. oducts or services with this quick and easy web based PHP application Your website visitors will be able to search by distance specialty state country and or zip code Features e Aone time license that runs on your server shared dedicated or virtual e Unlimited locations dealers with one license limited to 100 dealers for phpDealerLocator Free e Supports US Canadian and Mexican postal codes e Easy to customize to match your website design e Can be customized to your exact specifications for a lot less than you think You ll find an online example of a default phpDealerLocator installation at the following address You may want to refer to it while reading this manual y http phpdealerlocator yourphppro com demo gt You have full control over search criteria available to users Zip code is the only required criterion and full control over what information is shown to users in the search results For example you may wish to keep a record of email addresses for each dealer but not display them to locator users Choose an Edition to Match Your Need phpDealerLocator is available in several editions Free Classic Standard Pro and Premier For the purposes of this manual the primary functional differences are that the Free and Classic editions are compiled and require that the Zend Optimizer be present on the web server Also the Free edition is limited to 100 dealer records Visit http www YourPhpPro com
29. php on line 0 This error affects only phpDealerLocator Free and Classic It is caused by uploading phpDealerLocator in ASCII format rather than BINARY format To resolve the problem resend the files making sure the FTP application transmits them in binary I Have a Problem Where Can I Find Help This user manual is the primary source of information You ll also find useful information in the readme txt file distributed with phpDealerLocator If you re unable to find what you need send an email request using the form at http www yourphppro com email or call 574 202 7729 If you think you ve found a bug please email the details to bugreport yourphppro com 31 Chapter Showcase of Customer Sites Were proud of the web based locators our customers have created with phpDealerLocator Here are just a few samples Visit the Your PHP Pro web site at http www yourphppro com for the latest examples of our customers locators amp http www yourphppro com version en us content page_4_0_36 html REVENIR So AMERICA S LEADING SADDLE BRAND http www circley com http www revenirbeauty com LOR yey It s all in the death Brown Street Furniture Solid Wood Furniture Made in America Find ADealer a Type in Your Zip Code http www scoutboats com http www pureandbasic com 32 Chapter Software and Services from Your PHP Pro Your PHP Pro has a library of other ready
30. pproved 0 Click Here Dealers without Login Password 0 Click Here Dealers UnApproved Total number of Approve All Approve All Unapproved Publish All Unpu dealers with the unapproved switch set to Delete Delete All Unapproved Delete All Unpublished yes Dealers Preferred i Click Here System Information Click Here Dealers without Login Password Total Update Google Geocoding 0 Dealers Need Geocoding Geocode Dealers number of dealer records not having a login name and password These dealers will not be able to utilize the dealer section of the website to login and modify their own information since they do not have a username password combination 21 Approve All Unapproved Set the approved switch to yes for all unapproved dealer records Publish All Unpublished Set the publish switch to yes for all unpublished dealer records Delete All Unapproved Remove all dealers with the approved switch set to no from the database Use cautiously Delete All Unpublished Remove all dealers with the published switch set to no from the database Use cautiously Dealers Preferred Total number of dealers with the preferred switch set to yes gt Tables of results shown in the Administration Interface can be sorted in ascending or descending order by each field Just click the heading or the sort arrows at the top of the column System Information This link disp
31. r archive If this does not solve the problem contact your web host for help in having PHP files parsed before HTML files 30 Pages Not Being Displayed Properly If your phpDealerLocator pages are not being displayed properly like the example below make sure that when editing your HTML templates you do not remove the comments They are used by phpDealerLocator to know where to place the field and form data To correct this problem the easiest way is to restore the broken HTML template from the original phpDealerLocator archive and then customize it again being careful not to remove the HTML comments Examples of HTML comments can be seen below lt tr gt lt td class phpDealerLocatorStyle DataTD gt Dealer Distance lt td gt lt td class phpDealerLocatorStyle DataTD gt Dealer_Logo lt br gt lt a href Dealer_BusinessName_Src gt Dealer_BusinessName lt a gt lt br gt Phone Dealer_Phone lt br gt Fax Dealer_Fax lt br gt Email Dealer_Email lt br gt WebSite Dealer _WebSite lt br gt nbsp lt input type hidden value Dealer_ID name Dealer_ID gt lt td gt t s 1 lt td c phpDealerLocat Address1 enbsp lt td gt lt td s phpDealerLocat DataTD gt Dealer_Address2 snbsp lt td gt lt td s phpDealerLocat DataTD gt Dealer_City lt td gt lt td phpDealerLocat DataTD gt Dealer_State lt td gt lt td phpDealerLocat e DataTD gt Dealer_Zip lt td gt
32. r Card American Express and Discover credit and debit cards 33 E mail Support Email support is available for projects that need non immediate response to questions Time can be purchased in one hour segments Email response is available Monday through Friday from 8 am to 8 pm with a maximum response time of 24 hours and an average of 8 hours The billing increment is 10 minutes Quantity 1 4 5 14 15 29 30 Price 35 00 33 75 32 00 31 25 Phone Support Phone support is available for projects where direct communication is necessary and where a higher level of response is desired Phone Support is available on a monthly basis with a maximum response time of 8 hours and an average of four hours The billing increment for phone support is 15 minutes Quantity 1 4 5 14 15 39 40 Price 50 00 46 00 43 50 40 00 On Call Support On Call support is available for critical projects where immediate response and direct communication are required On Call Support is available on a limited basis with a maximum response time of 2 hours The average is only 20 minutes The billing increment for on call support is 30 minutes Quantity 1 4 5 9 10 24 25 Price 75 00 72 00 70 00 60 00 Custom PHP Programming Your PHP Pro can custom develop software specifically for your needs with the functionality you require We are professionals when it comes to helping you achieve your desires with a custom designed application Quantity
33. re the mySQL information stored in the config php file is correct Your PHP Pro is able to assist with this step or the entire installation for a reasonable fee gt The post installation setup application is located at http www example com phpDealerLocator_4_6 install index php Once you complete the installation feel free to remove this directory as it is no longer needed gt The database of dealers must be created and populated with dealer records before phpDealerLocator can be used Be aware that some database management interfaces on shared hosting systems automatically include a prefix to all user names and database names Be sure that the names you specify in the config php are correct and complete If you are not able to use the post installation application you can use the provided SQL command file located in the Database directory to create the necessary mySQL tables The following tables will be created All except the users table will be empty The users table will contain a record for the default administrative user e category defines the categories used to sort dealers You can define custom categories to describe specialties and capabilities for the dealers e dealer_category_matrix matches dealers to categories used for search criteria e dealers contact information and other descriptive information for each dealer including name address phone e statistics information on searches cond
34. s This chapter provides solutions to easily resolved problems sometimes encountered If you want assistance installing and configuring your locator please call Your PHP Pro We offer support services for all our software products at very reasonable rates Installations can usually be completed in one day V Installation is included with the Premier edition of phpDealerLocator Potential Problems Images Directory Not Found If you are unable to submit dealer edits or other changes check for a message at the top of the form saying Unable to upload the file specified in Dealer_Logo upload folder doesn t exist That indicates that you haven t created the directory name specified in the config php file or the config variable phpDealer_img_dir is incorrectly defined Simply create the directory or change the value in the config php file to that of an existing directory The dealer logo directory must exist even if you are not using logo files for the dealer records Pages Not Being Processed If your dealer locator pages are being displayed like those shown here your web server is displaying the HTML template files without processing the PHP application files This happens when the web server parses the HTML file before the PHP file On Apache web servers this problem can usually be fixed by including an htaccess file in the root directory of the locator There is a sample htaccess file in the phpDealerLocato
35. s program experienced web site and database phat this may be a desirable approacn What are the Hardware amp Software Requirements phpDealerLocator requires a web server with PHP version 4 1 or later and mySQL 4 0 or later version The Zend Optimizer 2 6 2 or greater is required for the Free and Classic editions phpDealerLocator has not yet been fully tested on PHP 5 x If you are running phpDealerLocator on a PHP 5x system please contact us Chapter Installation This chapter provides step by step instructions for those who prefer to do their own installation Remember that installation is included with the Premier edition of phpDealerLocator We can install other editions at a small additional cost Install Assistance phpDealerLocator now includes a customized Windows setup application that assists you in setting up phpDealerLocator for your website If you are not able to use a Windows application please contact us and we will be happy to send you the non installer version free of charge When not using the provided installer you would need to be reasonably familiar with HTML ftp file transfers database setup and setting file permissions If you re not up to speed on these topics in a hurry or just want to simplify the process Your PHP Pro can install the software for you Typically an installation can be completed at a cost of 55 with the entire installation ready for use on the same day you make the request
36. se Delete Delete the current record from the database Use the Delete button carefully clicking the button deletes the record without a confirmation step Dealer Interface This section is applicable only if you allow dealers to edit their own records by entering a 24 user id and password in their dealer record To prevent access by dealers simply omit the id and password from the dealers table The dealer interface is located here amp http www example com phpDealerLocator_4 6 login You can see an online example here a http phpdealerlocator yourphppro com demo login The login process is typical The login name and password for each dealer are specified in the dealer s record in the locator database Forgot your login Click Here Allows the dealer to retrieve forgotten login information by automatically sending an email to the email address dealer s record The text of the message is defined by the Sendpassword txt in the login directory Add Your Listing Click Here This link allows dealer candidates to request the addition of a record in the database and to submit the required information An email is to the address provided confirming the information submitted in the form The text of the email is defined by the add_email txt file in the login directory The record is not available on the locator until it has been approved by the locator administrator if the config variable phpDealer_AutoApprove_
37. sssssessseeeseeeees 33 E mail S p Oe e nnn nnn Annaan 34 Phone SUppoOft 22 2222 5 34 On Call Support s 34 Custom PHP Programming 34 Chapter Introduction and Background phpDealerLocator provides a simple and economical way to implement a full featured dealer locator on your web site This chapter provides an overall description of the software and some background on how it works Conventions and Symbols Throughout this manual youll see icons identifying information that is of particular interest or importance The key provides an explanation of each icon Symbol Key vV Key Information d AN Potential Problem Web Example E E References and Sources g Information You Provide V Specific to a particular edition Throughout this manual example com is used as the domain name for the web site where the locator is installed Youll replace example com with your own domain name Similarly phpDealer_ocator_4_6 is used for the server directory in which phpDealer_ocator is installed You may choose any legal directory name instead What is phpDealerLocator phpDealerLocator is a complete PHP application to allow your visitors to search for the nearest dealer store or location based on their zip code Help your website visitors find the nearest location for your pr
38. stallation Advanced users may also edit the corresponding PHP files to modify the operation of phpDealerLocator e DatePicker html Used with a corresponding javascript file to create the popup calendars in the date fields on the edit dealer page e footer html specifies the footer of each locator page usually used for a copyright or basic site information e header html page header usually used for a title e index html the starting point for dealer locator searches where the user makes his request e record html a results page that shows the single dealer record e record_category html Displays an individual record identified by a category search 27 e record_country html Displays an individual record identified by a country search e record_state html Displays an individual record identified by a state search e results html Displays the results of a zip code search e results_category html Displays results of a search by category e results_country html Displays results of a search by country e results_state html Displays results of a search by state gt For most applications only the CSS and HTML files in the dealer installation should be edited Other than the config php file PHP files should be edited only by advanced users Template refers to an html file or to the entire set of html files in the locator directory It does not refer to the Template php files in the root of
39. t the following address You may want to refer to it while reading this manual You may log on using the logon name admin and password 1234 a http phpdealerlocator yourphppro com demo Log in using the default values admin for the login name and 1234 for the password You Lee aga Should see a page like the example below Refer ss to Chapter 4 for details on the features 7 x 2 O J seach She Favorites O0 2 o s PEE amp For security you should immediately change the admin password or create anew administrative account and delete the default togn account Password Login C 2006 vourPHPPro com Creating Your Own Dealer Records gt You can create and edit your own set of dealer records either by using the phpDealerLocator web based admin interface page or by uploading a CSV file created on your local computer or elsewhere Creating and Editing Dealer Records With the Web Based Administrative Interface Open the administrative interface for your phpDealerLocator installation as described above The admin page provides convenient links to forms for adding editing and deleting dealer records To edit an existing record click the Add Edit Dealers button select the record by double clicking the dealer name Then just modify the information in the form To create a new record click the Add Edit Dealers button and then click the Add New link ne
40. the locator directory or the login directory Do not edit the files name Template php Program Parameters in Code Use caution with the program parameters show in curly brackets in the html files These parameters insert dynamic values into the web page There are several types of program parameters The parameter names for dealer information are the field names from the locator database They are self explanatory For example Dealer_BusinessName Dealer_Phone Dealer_Address1 If youdonot wish to display the entire dealer record in the locator output you can remove items by removing the corresponding parameter in the html file Hint Rather than simply erasing the parameter consider leaving a copy of the original code in the html file as a comment If you ever decide to include the information you ll have a ready reference Other program parameters allow displaying information calculated by phpDealerLocator e Dealer_Distance distance from dealer s location to center of zip code searched e Page_Number number of result page being displayed e Total_Pages total number of results pages The third type of program parameters including header and footer insert the contents of the header and footer html files 28 Customizing the Administrative Interface The administrative interface can be customized in the same manner as described for the public user interface 29 Chapter Common Questions and lssue
41. to manage your dealer database and view usage statistics for your dealer locator Logging In as the Administrator The administrative interface is located here http www example com phpDealerLocator_4 6 admin The admin interface is protected by a login procedure Enter your administrator login name and password in the fields provided and click the Login button Logging Out as the Administrator When you are done with the admin interface it is always best to log out Just click the Logout link near the top right corner of the screen C 2006 YourPHPPro com Elements of the Administration Interface The following pages provide a brief description of each of the elements of the Administration Interface and tips on how to use them 18 Dealers Dealers Add Edit Dealers Upload Dealers Export Dealers Delete Dealers T 5 Add Edit Dealers Administer dealer records in the database one ata time You can edit existing records or create new records Upload Dealers Upload dealer information from a CSV file The contents of the uploaded dealer file is added to the current contents of the database table If you wish to completely replace the current dealers table with the uploaded information delete the contents of the table before uploading the CSV file Web hosts may set an upload limit that is smaller than the dealers or zip code files you want to upload to your locator If
42. ucted on your locator e users User names and password combinations for those admin users authorized to edit the database Also defines whether the user is authorized to have admin access If you choose to allow dealers to edit their own records their user account information is stored in their dealer record e zipcode latitude and longitude for each zip code An SQL script file to create the zip 11 code table with more than 42 000 current US zip codes is provided in the phpDealerLocator distribution package You can update this table in the future as zip code definitions change and new zip codes are added by the postal service V After completing the post installation application make sure you log into the admin area and upload your postal code database Without a postal code database phpDealerLocator won t be able to successfully process radius searches Uploading phpDealerLocator via FTP The Windows based setup application takes care of sending the files to your website If for some reason you are not able to use the setup application you will need to upload the files yourself and place the files in a directory within the public HTML area of your site V Ifyou re installing the Free edition or the Classic edition you must use a binary file transfer when uploading the files gt To substantially reduce upload time and sever storage requirements upload only the theme files you plan to use Themes are stored in both
43. y 122 083740 37 423019 9 18 06 05 16 37 PM Admin user and dealer users logon names and passwords are stored unencrypted inside the locator database Security is provided by the encrypted communication connections between mySQL and PHP This simplifies providing forgotten logon names and 2006 vourrurero com passwords to dealer users Browse Back up Your Installation and Your Database Include you dealer locator installation in your regular web site backup schedule You may need to do separate backups of your database Be sure to make backups prior to any substantial modifications or upgrades to software gt You can export the individual tables from mySQL using the export functions on the admin page Other applications like phpMyAdmin and Navicat allow you to create backup copies of your entire database 15 Chapter Program Operation This chapter familiarizes you with the operation of a full featured phpDealerLocator application on the web It also provides a convenient reference for each feature and information field gt You can view a sample phpDealerLocator installation at the address below The figures in this manual are taken from that site That installation uses the HappyPumpkin theme Set your installation of phpDealerLocator to the HappyPumpkin theme if you want it to m
Download Pdf Manuals
Related Search