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

ok how does mysqli work ? (I have been using mysqli for some time now after changing my script from mysql) what is the complete process that mysqli uses to access return results and all that. As I really need to figure out what is causing this to fail. I feel that there may even be a bug with the mysqli process still.

oh i see, you mean to get the results and then sort them randomly ? if so, this still does not help as the results are still blank, as the results are blank, none returned due to the tmp file being removed too early there is nothing for php to sort or randomize.

application server... whoo now i am lost. I just googled this and still none the wiser. I would think that it is just another method of accessing the databases. I currently use mysqli methods with php. What is application server and would it be installed on reseller hosting servers, i.e. godaddy, hostgator and the like. Or is this only available on dedicated server ?

The script or query is what I put in my original post... SELECT * FROM `places` ORDER BY RAND() LIMIT 4 all it does is get 4 results and then display them. I am waiting to find out if my thoughts on how the server deals with the tmp files is right, as it could be the host has the wrong setting that deletes files or maybe a bug in the server software itself? in that it removes all files and not use a timestamp method. My host just comes back with 'nothing wrong this end all working fine' ! awaiting a reply on their settings when files are deleted and how they are remove, be it all or based on a timestamp.

What I have is 4 random phrases that are taken from the server and say I have 100 people all access the site then it would be running this query once per visit. After many visits the error shows itself. I have not got it running multiple times in the same run of the page, but for testing things I did and found the error showing itself every now and then. It seems that it could be that the server is deleting everything in the tmp folder say every minute or so and when a new person visits the site and the four random results are got the file is deleted moments after causing the script to fail as the file is gone before it has a chance to read the data to show the results on the page. I would have thought the server would use a timestamp method to make sure the files were only removed if older than an hour or something or say 10 minutes or 5 for that matter. not half a millisecond after it is created because the folder is cleared no matter if the file is finished with or not. I could be wrong with all this and have the wrong end of the stick, but logically this is what I think might be happening. How does the normal server deal with files and what is the point of having MYD if the file name does not contain these details to enable the server to effectively remove the older tmp files.

Thank you, I thoguht I'd try another suggestion from a friend of mine. By installing WAMPSERVER and seeing if the same error shows there, but so far after over an hour of running the same script I have yet to get the error. Maybe there is a script on the main server that is deleting the tmp folder content every so often and every few minutes if that. Seems that it is not deleting using a date in the file name method? As the file name suggests that it is not containing the MYD (Month/Year/Day) Does mysql use the MYD or am I going up the wrong path with that thought. If it can use this method. What changes should be made to the server ? My host may need to make some changes to make it delete files after a longer period. Would you know the normal time that a server would delete the tmp files for mysql from the tmp folder ?

I have been having a few issues with mysql getting 4 random results from a table, the query works most of the time, but every now and then it fails causing the page to show errors.... This is the exact error unaltered. mysqli::query() [mysqli.query]: (HY000/6): Error on delete of '/tmp/#sql_b8142_0.MYD' (Errcode: 2) Can anyone suggest what this error relates to or what might be causing it to show up. I have checked the database and done a repair but still the error shows up. The query line I am using is like so... SELECT * FROM `places` ORDER BY RAND() LIMIT 4 There are currently 26682 entries in the table. But the query only asks for 4 random entries to be returned.

I can not seem to find out why this code will not work. I am wanting it to first set a dummy string to 'notin' then check if any of the strings in the array are in the $fromlink4 variable that has the contents of gethostbyaddr($_SERVER['REMOTE_ADDR']), if just one is set the dummy string $isinarray to 'isin' the next step is to see if $isinarray is set to 'notin' if not then store the visitor details. at the moment it stores everything even if any of the array strings are in $fromlink4 $fromlink4 = $_SERVER['REMOTE_ADDR'] != "" ? gethostbyaddr($_SERVER['REMOTE_ADDR']) : "" . $_SERVER['REMOTE_ADDR'] . ""; $needle = array('bot', 'crawl', 'spider', 'superkabel', 'telenet', 'your-server' ,'whois', 'unassigned', 'fastwebserver', 'opendub', 'sagonet', 'search'); $isinarray = "notin"; //echo("isinarray = false<br>"); foreach($needle as $item){ //echo("<br>item = " . $item . " "); if(strpos("$fromlink4", $item) == true) { // 'false' = IS in string $isinarray = "isin"; //echo("isinarray = true "); } } if($isinarray == "notin") { //echo("<br><br><br><br>isinarray = true add to the DB<br>"); $send_error = "INSERT INTO visitTracker (`data`, `allvars`, `time`, `theip`, `fromlink4`) VALUES ('" . $mysqli->real_escape_string($data) . "', '" . $mysqli->real_escape_string($allvars) . "', '" . $mysqli->real_escape_string($datetimenow) . "', '" . $mysqli->real_escape_string($ipAddress) . "', '" . $mysqli->real_escape_string($fromlink4) . "')"; db_query($mysqli, $send_error); }

For some reason I can not sort the array list, can anyone tell me what I am doing wrong ? My output is... Array ( [0] => 2 [1] => 5 [2] => 3 ) 1 $product_length = 2; $product_width = 5; $product_height = 3; // work out volume. $sizeArray = array(); $sizeArraySORTED = array(); $sizeArray = array($product_length, $product_width, $product_height); print_r($sizeArray); ?><br><br><br><? $sizeArraySORTED = asort($sizeArray, SORT_NUMERIC); print_r($sizeArraySORTED);

I am looking for a way to remove a certain row from a set of results. I grab the product title and price and other details including the `product_id` (int) I am then wanting to remove an item from the results that has a certain `product_id` This can not be done easily from the query due to me using OpenCart, and the getProducts file is so much a mess in itself that I am lost as to how or where I do this. So think the best way is to remove the item that I do not need from the results set, as this item is already shown elsewhere on the page and do not want to have duplicates on the page. I echoed the results array to my page, this is that array, but based on only showing two products, one of which I would need to remove. I realised that the product_id is not actually used for the array location but as a sub variable. So in the example array below how would I remove say the first or second product (the product i am wanting to remove will not be the first item, it could be anywhere in the array) The product_id is shown in the first part of the array 1720 or 2057. array(2) { [1720]=> array(40) { ["product_id"]=> string(4) "1720" ["name"]=> string(26) "aaaaaaaaaaaaaaa" ["description"]=> string(71) "ssssssssssssss" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "r592" ["sku"]=> string(0) "" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(3) "100" ["stock_status"]=> string(9) "Pre-Order" ["image"]=> string(25) "data/r592x.jpg" ["manufacturer_id"]=> NULL ["manufacturer"]=> NULL ["price"]=> string(7) "38.9500" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2013-07-06" ["weight"]=> string(10) "0.15000000" ["weight_class_id"]=> string(1) "1" ["length"]=> string(10) "0.00000000" ["width"]=> string(10) "0.00000000" ["height"]=> string(10) "0.00000000" ["length_class_id"]=> string(1) "0" ["subtract"]=> string(1) "0" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2013-07-06 14:05:13" ["date_modified"]=> string(19) "2013-07-06 14:05:13" ["viewed"]=> string(1) "4" } [2057]=> array(40) { ["product_id"]=> string(4) "2057" ["name"]=> string(25) "ddddddddddddd" ["description"]=> string(73) "ffffffffffffffffffff" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(6) "770400" ["sku"]=> string(0) "" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(3) "100" ["stock_status"]=> string(9) "Pre-Order" ["image"]=> string(27) "data/770400x.jpg" ["manufacturer_id"]=> NULL ["manufacturer"]=> NULL ["price"]=> string(6) "4.5000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2013-07-06" ["weight"]=> string(10) "0.10000000" ["weight_class_id"]=> string(1) "1" ["length"]=> string(10) "0.00000000" ["width"]=> string(10) "0.00000000" ["height"]=> string(10) "0.00000000" ["length_class_id"]=> string(1) "0" ["subtract"]=> string(1) "0" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2013-07-06 14:05:13" ["date_modified"]=> string(19) "2013-07-06 14:05:13" ["viewed"]=> string(1) "4" } }