daipratt.co.uk Report : Visit Site


  • Ranking Alexa Global: # 2,398,513

    Server:Apache...
    X-Powered-By:PHP/5.6.36

    The main IP address: 217.160.0.214,Your server Germany,Karlsruhe ISP:1&1 Internet AG  TLD:uk CountryCode:DE

    The description :a technical blog written by david pratt that focuses on website construction and seo. a particular emphasis is given to javascript, jquery, drupal and front-end...

    This report updates in 15-Jul-2018

Technical data of the daipratt.co.uk


Geo IP provides you such as latitude, longitude and ISP (Internet Service Provider) etc. informations. Our GeoIP service found where is host daipratt.co.uk. Currently, hosted in Germany and its service provider is 1&1 Internet AG .

Latitude: 49.004718780518
Longitude: 8.3858299255371
Country: Germany (DE)
City: Karlsruhe
Region: Baden-Wurttemberg
ISP: 1&1 Internet AG

the related websites

HTTP Header Analysis


HTTP Header information is a part of HTTP protocol that a user's browser sends to called Apache containing the details of what the browser wants and will accept back from the web server.

X-Powered-By:PHP/5.6.36
Transfer-Encoding:chunked
Content-Encoding:gzip
Keep-Alive:timeout=15
Server:Apache
Connection:keep-alive
Link:; rel="https://api.w.org/"
Date:Sun, 15 Jul 2018 14:13:14 GMT
Content-Type:text/html; charset=UTF-8

DNS

soa:ns1066.ui-dns.org. hostmaster.schlund.de. 2016042800 28800 7200 604800 600
ns:ns1066.ui-dns.org.
ns1066.ui-dns.com.
ns1066.ui-dns.biz.
ns1066.ui-dns.de.
ipv4:IP:217.160.0.214
ASN:8560
OWNER:ONEANDONE-AS Brauerstrasse 48, DE
Country:DE
mx:MX preference = 10, mail exchanger = mx01.schlund.de.
MX preference = 10, mail exchanger = mx00.schlund.de.

HtmlToText

daipratt .co.uk adventures in code and seo... all posts sitemap comments contact exporting data from sql server express 2005 to csv using php by david pratt / tags: db , php / 5 comments / published: 10-06-11 annoyingly, one of the limitations of sql server express 2005 is that it doesn’t allow you to export data as csv, or any other format (bar sql) for that matter. this is fine is you have a small dataset as you can just copy the data out of the results pane, and then paste into a spreadsheet program to save in the format of your choosing. if like me on the other hand whereby you have a massive result set of +100k records then that doesn’t quite work. googleing around for a solution i came across a couple of different options (using dts wizard, another using a 3rd party app etc.), but nothing looked like it could do the job i was after – basically i wanted a no-fuss phpmyadmin style export to csv option. dissatisfied with the options out there, i ended up deciding to write a php script that would connect to the db using the mssql php extension, get the required data, and automatically spit out a csv file. writing the script was the easy part, the difficult bit was getting php to talk to the database due to an incompatibility between the sql server express 2005 db driver and the php extension. to get php to play nicely with ms sql server 2005 express you need to resolve this driver problem, here’s how you do it: search your computer for ntwdblib.dll if you right click on each occurance of the file (i had one in the php, apache and system32 directories) hit the details tab, and if any of them say a number that isn’t 2000.80.194.0 then you need to download that version of the file. once you have downloaded the file, you need to replace all of the existing ntwdblib.dll files with the one you have downloaded, or figure out which one your php version is using. obviously, make back-ups first. a more in depth tutorial on how to do this can be found here . here’s the code for connecting to the db, generating a csv file and outputting to file in the simplest way i could come up with: //mssql connection string details. $dbhost = "localhost\sqlexpress"; $dbuser = 'dave'; $dbpass = 'password'; $dbname = 'target_db_name'; $db = mssql_connect($dbhost, $dbuser, $dbpass); if (!$db) { die('could not connect to mssql - check your connection details & make sure that ntwdblib.dll is the right version!'); } $db_selected = mssql_select_db($dbname, $db); if (!$db_selected) { die('could not select mssql db'); } $sql = "select * from target_database_table_name"; $results = mssql_query($sql, $db); //generate csv file - set as mssql_assoc as you don't need the numeric values. while ($l = mssql_fetch_array($results, mssql_assoc)) { foreach($l as $key => $value){ //if the character " exists, then escape it, otherwise the csv file will be invalid. $pos = strpos($value, '"'); if ($pos !== false) { $value = str_replace('"', '\"', $value); } $out .= '"'.$value.'",'; } $out .= "\n"; } mssql_free_result($results); mssql_close($db); // output to browser with the csv mime type header("content-type: text/x-csv"); header("content-disposition: attachment; filename=table_dump.csv"); echo $out; for reference, i’m using php 5.2.3 on wamp – the driver fix mentioned above didn’t seem to work with 5.3.* wget examples for a linux newbie by david pratt / tags: command line , linux , wget / 2 comments / published: 06-05-11 having ditched windows entirety at the start of the year and made the switch to linux (ubuntu flavour), i’ve discovered a range of tools that would have come in very handy in my days as a windows user. one of those tools is called wget . wget is basically a bit of software that allows you to download files from webservers via the command line. that in itself doesn’t sound very exciting, but when you start wielding some of its options, you can do some interesting things with it. to showcase some of the things that wget can do, here is a collection of one-liners that you might find interesting or useful – i haven’t come up with them all myself, mostly collected them from around the net from forums and places such as command line fu : [to understand what the options after the wget command, you’ll need to refer to the wget documentation ] download a single file start with an easy one! wget http://www.example.com/archive.zip download an entire website if you don’t want to be courteous, then you can ignore the –random-wait switch if you don’t mind running the risk of getting banned. if you only want to download the site to a certain depth, then you can use the switch -l followed by a number to indicate the depth e.g. “-l 2” to a depth level of 2. downloading an entire website can also be achieved using the -mirror parameter. wget --random-wait -r -p -e robots=off -u mozilla http://www.example.com download an entire ftp directory using wget handy if you don’t want to spark up an ftp client. wget -r ftp://username:[email protected] or wget --ftp-user=username --ftp-password=password example.com check for broken links using wget as a spider this is the command line equivalent of using a windows based tool called xenu link sleuth. it will spider an entire website, ignoring the robots.txt and generate a log file of all broken links. handy. wget --spider -o wget.log -e robots=off --wait 1 -r -p http://www.example.com get server information wget -s -q -o - http://www.example.com | grep ^server diff remote webpages using wget diff <(wget -q -o - http://www.example.com) <(wget -q -o - http://www.example2.com) schedule a download if you've got a big file to download, you could schedule getting it in this manner. couple this command with a cron job and you could feasibly create a snapshot of a website at given time intervals. echo 'wget http://www.example.com' | at 01:00 using fb.api to make a full post to a users wall by david pratt / tags: facebook , javascript / 21 comments / published: 26-09-10 i just thought i’d make another quick post about the facebook graph api seen as there seems to be so little documentation and examples for it. the below example shows you how to make a full wall post with message, name, description, link, picture and caption to the wall of a facebook user using javascript to call the facebook fb.api . so, assuming that you have an authenticated session, here’s what you need to do: var params = {}; params['message'] = 'message'; params['name'] = 'name'; params['description'] = 'description'; params['link'] = 'http://apps.facebook.com/summer-mourning/'; params['picture'] = 'http://summer-mourning.zoocha.com/uploads/thumb.png'; params['caption'] = 'caption'; fb.api('/me/feed', 'post', params, function(response) { if (!response || response.error) { alert('error occured'); } else { alert('published to stream - you might want to delete it now!'); } }); if you do this right you should get something like this appearing: spamtastic. create a facebook page that shows a different version to those that “like” it by david pratt / tags: facebook / no comments / published: 17-09-10 continuing on the facebook theme from by previous post about how to create a facebook photo album and insert photos into it using php, i thought i’d share another facebook technique that i’ve used a few times recently. that is, one of showing one version of a facebook fan/tab page to those people who “like” it, and another to those who are yet to “like” it. i won’t talk about why you would want to do this here, i’ll just show you how… assuming that you have installed the facebook static fbml application on your fan page, and you are on the page where you enter your source code, drop in the following (but obviously replace yourdomain with your own server address): <link rel="stylesheet" type="text/css" href="http://yourdomain.com/stylesheet.css?v=1.1" /> <div id="wrapper"> <fb:visible-to-connection> <img src="http://yourdomain.com/thanks.jpg" alt="thanks!" width="

URL analysis for daipratt.co.uk


http://daipratt.co.uk/tag/css/
http://daipratt.co.uk/tag/marketing/
http://daipratt.co.uk/internet-and-programming/sitemap/
http://daipratt.co.uk/2009/10/
http://daipratt.co.uk/tag/javascript/
http://daipratt.co.uk/crontab-plesk-php/
http://daipratt.co.uk/tag/seo/
http://daipratt.co.uk/using-fb-api-to-make-a-full-post-to-a-users-wall/
http://daipratt.co.uk/facebook-api-upload-photo/
http://daipratt.co.uk/exporting-data-sql-server-2005-express-csv-php-mssql/#comments
http://daipratt.co.uk/2011/05/
http://daipratt.co.uk/a-few-things-to-consider-when-developing-on-a-public-domain/
http://daipratt.co.uk/internet-and-programming/contact/
http://daipratt.co.uk/2010/08/
http://daipratt.co.uk/2010/01/
google.co.uk

Whois Information


Whois is a protocol that is access to registering information. You can reach when the website was registered, when it will be expire, what is contact details of the site with the following informations. In a nutshell, it includes these informations;

Error for "daipratt.co.uk".

the WHOIS query quota for 2600:3c03:0000:0000:f03c:91ff:feae:779d has been exceeded
and will be replenished in 289 seconds

WHOIS lookup made at 09:57:39 14-Jul-2017

--
This WHOIS information is provided for free by Nominet UK the central registry
for .uk domain names. This information and the .uk WHOIS are:

Copyright Nominet UK 1996 - 2017.

You may not access the .uk WHOIS or use any data from it except as permitted
by the terms of use available in full at http://www.nominet.uk/whoisterms,
which includes restrictions on: (A) use of the data for advertising, or its
repackaging, recompilation, redistribution or reuse (B) obscuring, removing
or hiding any or all of this notice and (C) exceeding query rate or volume
limits. The data is provided on an 'as-is' basis and may lag behind the
register. Access may be withdrawn or restricted at any time.

  REFERRER http://www.nominet.org.uk

  REGISTRAR Nominet UK

SERVERS

  SERVER co.uk.whois-servers.net

  ARGS daipratt.co.uk

  PORT 43

  TYPE domain

DISCLAIMER
This WHOIS information is provided for free by Nominet UK the central registry
for .uk domain names. This information and the .uk WHOIS are:
Copyright Nominet UK 1996 - 2017.
You may not access the .uk WHOIS or use any data from it except as permitted
by the terms of use available in full at http://www.nominet.uk/whoisterms,
which includes restrictions on: (A) use of the data for advertising, or its
repackaging, recompilation, redistribution or reuse (B) obscuring, removing
or hiding any or all of this notice and (C) exceeding query rate or volume
limits. The data is provided on an 'as-is' basis and may lag behind the
register. Access may be withdrawn or restricted at any time.

  REGISTERED no

DOMAIN

  NAME daipratt.co.uk

NSERVER

  NS23.SCHLUND.DE 217.160.80.144

  NS24.SCHLUND.DE 217.160.81.144

Go to top

Mistakes


The following list shows you to spelling mistakes possible of the internet users for the website searched .

  • www.udaipratt.com
  • www.7daipratt.com
  • www.hdaipratt.com
  • www.kdaipratt.com
  • www.jdaipratt.com
  • www.idaipratt.com
  • www.8daipratt.com
  • www.ydaipratt.com
  • www.daiprattebc.com
  • www.daiprattebc.com
  • www.daipratt3bc.com
  • www.daiprattwbc.com
  • www.daiprattsbc.com
  • www.daipratt#bc.com
  • www.daiprattdbc.com
  • www.daiprattfbc.com
  • www.daipratt&bc.com
  • www.daiprattrbc.com
  • www.urlw4ebc.com
  • www.daipratt4bc.com
  • www.daiprattc.com
  • www.daiprattbc.com
  • www.daiprattvc.com
  • www.daiprattvbc.com
  • www.daiprattvc.com
  • www.daipratt c.com
  • www.daipratt bc.com
  • www.daipratt c.com
  • www.daiprattgc.com
  • www.daiprattgbc.com
  • www.daiprattgc.com
  • www.daiprattjc.com
  • www.daiprattjbc.com
  • www.daiprattjc.com
  • www.daiprattnc.com
  • www.daiprattnbc.com
  • www.daiprattnc.com
  • www.daipratthc.com
  • www.daipratthbc.com
  • www.daipratthc.com
  • www.daipratt.com
  • www.daiprattc.com
  • www.daiprattx.com
  • www.daiprattxc.com
  • www.daiprattx.com
  • www.daiprattf.com
  • www.daiprattfc.com
  • www.daiprattf.com
  • www.daiprattv.com
  • www.daiprattvc.com
  • www.daiprattv.com
  • www.daiprattd.com
  • www.daiprattdc.com
  • www.daiprattd.com
  • www.daiprattcb.com
  • www.daiprattcom
  • www.daipratt..com
  • www.daipratt/com
  • www.daipratt/.com
  • www.daipratt./com
  • www.daiprattncom
  • www.daiprattn.com
  • www.daipratt.ncom
  • www.daipratt;com
  • www.daipratt;.com
  • www.daipratt.;com
  • www.daiprattlcom
  • www.daiprattl.com
  • www.daipratt.lcom
  • www.daipratt com
  • www.daipratt .com
  • www.daipratt. com
  • www.daipratt,com
  • www.daipratt,.com
  • www.daipratt.,com
  • www.daiprattmcom
  • www.daiprattm.com
  • www.daipratt.mcom
  • www.daipratt.ccom
  • www.daipratt.om
  • www.daipratt.ccom
  • www.daipratt.xom
  • www.daipratt.xcom
  • www.daipratt.cxom
  • www.daipratt.fom
  • www.daipratt.fcom
  • www.daipratt.cfom
  • www.daipratt.vom
  • www.daipratt.vcom
  • www.daipratt.cvom
  • www.daipratt.dom
  • www.daipratt.dcom
  • www.daipratt.cdom
  • www.daiprattc.om
  • www.daipratt.cm
  • www.daipratt.coom
  • www.daipratt.cpm
  • www.daipratt.cpom
  • www.daipratt.copm
  • www.daipratt.cim
  • www.daipratt.ciom
  • www.daipratt.coim
  • www.daipratt.ckm
  • www.daipratt.ckom
  • www.daipratt.cokm
  • www.daipratt.clm
  • www.daipratt.clom
  • www.daipratt.colm
  • www.daipratt.c0m
  • www.daipratt.c0om
  • www.daipratt.co0m
  • www.daipratt.c:m
  • www.daipratt.c:om
  • www.daipratt.co:m
  • www.daipratt.c9m
  • www.daipratt.c9om
  • www.daipratt.co9m
  • www.daipratt.ocm
  • www.daipratt.co
  • daipratt.co.ukm
  • www.daipratt.con
  • www.daipratt.conm
  • daipratt.co.ukn
  • www.daipratt.col
  • www.daipratt.colm
  • daipratt.co.ukl
  • www.daipratt.co
  • www.daipratt.co m
  • daipratt.co.uk
  • www.daipratt.cok
  • www.daipratt.cokm
  • daipratt.co.ukk
  • www.daipratt.co,
  • www.daipratt.co,m
  • daipratt.co.uk,
  • www.daipratt.coj
  • www.daipratt.cojm
  • daipratt.co.ukj
  • www.daipratt.cmo
Show All Mistakes Hide All Mistakes