jason310771

I am wanting to create a system, if not already done by someone else that someone can direct me to, to check if the files on my local computer are the same as that on the server. maybe using MD5. I use XAMPP and wish to code this in PHP. The only issue I have is the first step, accessing the sites files using FTP via PHP and XAMPP. The rest of the PHP code I should be able to do ok. Any suggestions how I might be able to access FTP using PHP in XAMPP ? Thank you My main goal is to have my PHP code show a list of files on the server and whats local and list them and show which files have changed on the server and if any files are missing and if any new files are there that are not present in my local folder.

For sometime I have been using a well known ad revenue plugin. There was never a large amount made, but over the last 6 months to a year I have seen a massive drop in impressions. What methods would people here recommend I check out ? TIA

Thank you for this answer. I was thinking of this and opted to have them enter the full formatted postcode and not one without the space or part code. if they entered B12 then this would get results for B12 but if their postcode was in fact B1 2AB then they would not get the correct results as the my scripts would think they meant B12 ! I was trying to cover too many angles... Seems to work so far. Thanks for your input and best method.

I would like to know how I can get a single result from a table that is like a phrase. My table has all the postcodes like so... B1 B2 B3 CV2 WC1A and if someone enters say B1 2AB or WC1A 1AB that I wish to find the single result that is like the one entered and obtain the other details in the results. What query could I use to do this. My table looks like this... CREATE TABLE IF NOT EXISTS `postcodes` ( `Pcode` text NOT NULL, `Grid_N` int(11) NOT NULL DEFAULT '0' COMMENT 'used', `Grid_E` int(11) NOT NULL DEFAULT '0' COMMENT 'used', `Latitude` decimal(12,5) NOT NULL DEFAULT '0.00000', `Longitude` decimal(12,5) NOT NULL DEFAULT '0.00000', `town` varchar(255) DEFAULT NULL COMMENT 'THIS FIELD WAS ADDED TO USING THE REGION INFO AS SOME TOWNS WERE BLANK', `region` varchar(255) DEFAULT NULL COMMENT 'this is now not used', `country` varchar(3) NOT NULL COMMENT 'this is now not used', `country_string` varchar(16) NOT NULL COMMENT 'used', `state` text NOT NULL, `mydummy` text NOT NULL, KEY `x` (`Grid_N`,`Grid_E`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DanGibbs.co.uk Free UK Postcode Database'; INSERT INTO `postcodes` (`Pcode`, `Grid_N`, `Grid_E`, `Latitude`, `Longitude`, `town`, `region`, `country`, `country_string`, `state`, `mydummy`) VALUES ('AB10', 392900, 804900, '57.13514', '-2.11731', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB11', 394500, 805300, '57.13875', '-2.09089', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB12', 393300, 801100, '57.10100', '-2.11060', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB13', 385600, 801900, '57.10801', '-2.23776', 'Milltimber', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB14', 383600, 801100, '57.10076', '-2.27073', 'Peterculter', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB15', 390000, 805300, '57.13868', '-2.16525', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB16', 390600, 807800, '57.16115', '-2.15543', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB21', 387900, 813200, '57.20960', '-2.20033', 'Aberdeen Airport', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB22', 392800, 810700, '57.18724', '-2.11913', 'Bridge Of Don', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM'), ('AB23', 394700, 813500, '57.21242', '-2.08776', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland', '', 'UNITED KINGDOM');

I am after one that opens up like an overlay. Over the page content.

I did check it but can not see where I can place the images on the page where I want and then have the user click one to open up the gallery overlay of the larger image and the arrows to scroll through them.

Hey, Thank you for your suggestion, but seen a lot of these. I am after one that will allow me to add to a custom made shopping card and when someone clicks one of the images it opens to larger view and you can then scroll through the rest of the images that were on that page you clicked on. Just like the one I had used in the past that now does not work as it is too old and does not work well with some mobiles.

I have been searching for a few months now and still not able to find what I am after. I have the following code running on my site but now this is causing problems for some mobiles... http://highslide.com/ I am looking for a image gallery where a load of images show on the page and when one is clicked you can then scroll through the rest. I am also looking to place text under the image, one or two lines. Can anyone suggest ones that they have seen/used that I can try out to see if they are suitable. Thanks.

I have been searching for a few weeks now and decided to get a little help on this on. I am after a database like that which I found for the UK postcode, but one for the USA but it needs to have the North and East references. Has anyone come across a site that offers a basic zipcode, state, Grid_N and Grid_E references ? if so please can you let me know what sites you have used.

Ok just in case it is not obvious to me here is the complete results of the styles for each of the elements... for each line I click in the code inspector this is what the right side panel shows... <div id="footer"> clear: both; color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; text-align: center; width: 739px; -------------------------------------------------------------------- <div style="float: left;"> color: #FFF; floatleftfont-family: Verdana,Arial,Helvetica,sans-serif; text-align: center; -------------------------------------------------------------------- <div style="float: left;"> color: #FFF; floatleftfont-family: Verdana,Arial,Helvetica,sans-serif; text-align: center; -------------------------------------------------------------------- <a style="font-size: 8pt;" href="#">clickable link one</a> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; text-decoration: none; -moz-text-decoration-color: #FFF; -moz-text-decoration-line: none; -moz-text-decoration-style: solid; -------------------------------------------------------------------- <span style="font-size: 8pt;"> | </span> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; -------------------------------------------------------------------- <a style="font-size: 8pt;" href="#">clickable link two</a> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; text-decoration: none; -moz-text-decoration-color: #FFF; -moz-text-decoration-line: none; -moz-text-decoration-style: solid; -------------------------------------------------------------------- <span style="font-size: 8pt;"> | </span> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; -------------------------------------------------------------------- <a style="font-size: 8pt;" href="#">clickable link three</a> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; text-decoration: none; -moz-text-decoration-color: #FFF; -moz-text-decoration-line: none; -moz-text-decoration-style: solid; -------------------------------------------------------------------- <span style="font-size: 8pt;"> | </span> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; -------------------------------------------------------------------- <a style="font-size: 8pt;" href="#">clickable link four</a> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; text-decoration: none; -moz-text-decoration-color: #FFF; -moz-text-decoration-line: none; -moz-text-decoration-style: solid; -------------------------------------------------------------------- <span style="font-size: 8pt;"> | </span> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; -------------------------------------------------------------------- <a style="font-size: 8pt;" href="#">clickable link five</a> color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; font-size: 10.6667px; text-align: center; text-decoration: none; -moz-text-decoration-color: #FFF; -moz-text-decoration-line: none; -moz-text-decoration-style: solid; -------------------------------------------------------------------- </div> -------------------------------------------------------------------- <div class="clear"></div> clear: both; color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: center; -------------------------------------------------------------------- </div> -------------------------------------------------------------------- <div class="clear"></div> clear: both; color: #FFF; font-family: Verdana,Arial,Helvetica,sans-serif; text-align: center; -------------------------------------------------------------------- </div> --------------------------------------------------------------------

The new site did have a lot of text and images and all shows on my windows mobile and our tablet and on the pc almost 99% the same. 1% is good for me. But having the text so large in the footer is like it being only 10% fine! The footer is the only issue which is why I stripped out the rest of the page, I work with static pages to rule out any other issues with includes and stuff. I gave both version so it could be seen what was needed. But can not get my head around why it fails. The original template code I created for my other site works fine, but has a difference foter layout, but the text is the correct size on all devices, if not identical. I know that trying to cater for al devices with one code is not the best way, but so far I have never had a problem until now. At first I thought it would be an extra font-size in the code or something like a missing div or something. But the code validates and seems to be ok. Ok there is a missing page title, still validates when there is one. I just dont understand why both are almost the same apart from one being contained within divs and the other isn't and yet both show different. I'm going to try to place the link in the new site within divs and left align into one line and see if this works.

I just can not get my head around this one at all. I have copied exactly the same code from my own template site and added in new content to the head, main body and footer and no matter what I change I can not get the footer text to show the same on a mobile and a pc like my site I took the code from does. The size of the text just goes large on mobiles, yet the same code is used apart from the slight formatting differences, it should still show the text the same. I opted to copied the resulting source code from the browser for both my site and the new site i am doing and stripped out the main content and header and left just the footer and the main body container html for both and my own site show perfectly on all but still the new site is not playing ball. Below is the code for the new site. Can anyone spot anything that I may have missed that is causing the text to show differently (larger) in the footer on mobile devices. New site <!DOCTYPE html> <html lang="en"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="keywords" content=""> <meta name="description" content=""> <style> body { font-family: Verdana, Arial, Helvetica, sans-serif; color: #464646; text-decoration: none; background-color: #8C8C8C; margin: 0em; padding: 1.125em; } a, a:visited { color: #164365; text-decoration: underline; } a:hover { color: #6F6F6F; text-decoration: none; } .clear { clear: both; } #main { width: 46.188em; margin:auto; } #main-inner { padding: 0em 1.063em 0.313em 1.063em; border: 0em solid red; min-height: 12.5em; background-color: #FFFFFF; } #footer { margin: 0 auto; clear: both; /*font-size: 0.74em;*/ color: #FFFFFF; text-align: center; width: 46.188em; border: 0.1em solid #ddd; } /* 727 */ #footer a:link, #footer a:visited { color: #FFFFFF; text-decoration: none; } #footer a:hover { color: #FFFFFF; text-decoration: underline; } </style> <meta name="ROBOTS" content="INDEX, FOLLOW"> <link rel="icon" href="favicon.ico" type="image/x-icon"> </head> <body> <div id="main"> <div id="main-inner"> </div> <div class="clear"></div> </div> <div id="footer"> <div style="margin: 0em; text-align: center; font-size: 9pt; border: 0px solid #000;"> <a href="#">clickable link one</a> | <a href="#">clickable link two</a> | <a href="#">clickable link three</a> | <a href="#">clickable link four</a> | <a href="#">clickable link five</a> |© 2014 my shop ™ </div> </div> </body> </html> and just to show what my original code does.. <!DOCTYPE html> <html lang="en"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="keywords" content=""> <meta name="description" content=""> <style> body { font-family: Verdana, Arial, Helvetica, sans-serif; color: #464646; text-decoration: none; background-color: #8C8C8C; margin: 0em; padding: 1.125em; } a, a:visited { color: #164365; text-decoration: underline; } a:hover { color: #6F6F6F; text-decoration: none; } .clear { clear: both; } #main { width: 46.188em; margin:auto; } #main-inner { padding: 0em 1.063em 0.313em 1.063em; border: 0em solid red; min-height: 12.5em; background-color: #FFFFFF; } #footer { margin: 0em auto; clear: both; color:#FFFFFF; text-align: center; padding: 0em 0em 0em 0em; width: 46.188em; border: 0em dashed #ddd; } #footer a:link, #footer a:visited { color: #FFFFFF; text-decoration: none; } #footer a:hover { color: #FFFFFF; text-decoration: underline; } </style> <meta name="ROBOTS" content="INDEX, FOLLOW"> </head> <body> <div id="main"> <div id="main-inner"> </div> <div class="clear"></div> </div> <div id="footer"> <div style="float: left; width: 6em; border: 0em solid #000;"> </div> <div style="float: left; width: 130px; font-size: 7pt; border: 0px solid #000;"> </div> <div style="float: left; width: 275px; font-size: 8pt; border: 0px solid #000;"> <div style="float: left; width: 200px; border: 0px solid #000;"> © <abbr title="">My company</abbr> </div> <div style="float: left; width: 20px; border: 0px solid #000;"> <a href="[redacted]/sitemap.xml" target="_blank" style="text-decoration: none;">sitemap</a> </div> <div class="clear"></div> designed & hosted by <abbr title="">More footer text</abbr><br>images are copyright of their respective owners </div> </div> </body> </html>

I wish to know how google does their search, say there is a road called St. John's Road in my database and I type in my ajax-auto-sugestion field... St John How can I get the auto-selection to show the road that is LIKE the content but do not use the . or the ' in the database If I was to start to type... St. John then it would of course show the suggestion as I used the . Can this be done ? My fields have the proper names of the roads and I use utf8_general_ci for the road name field and the LIKE method to get the results.

Ok I think I have something that may give some more clues as to why this is happening. I added some more code to my scripts so it would notify me via email when the error happened but I also have the IP of the visitor that had the error. It is 99% of the time Google. I added some more so it would log every visit for a day and google did not have an error all of the time. My IP had an error every now and then, but not as much as google did. Why would google have an error so many time but I do not? Would it be that google is visiting to many time in a short time period ? Some time it visits every minute for about 30 minutes or so and other times it would visit a few hundred times in an hour. There does not seem to be a time of the day this happens or a certain time frame or every hour that it has an error. Its just random.

ok I checked the whole table and there are no gaps with the Primary Key or ID when i eventually worked out how to get the columns in phpmyadmin i used this... SHOW COLUMNS FROM places in the sql query Field Type Null Key Default Extra id bigint(20) NO PRI NULL auto_increment place text NO NULL dummy_date datetime NO 0000-00-00 00:00:00