Welcome To Basenetix
This is a summary blog of the things the Netbasic development team talk about in their spare time. If you see a post that intrests you, why not click the link and read their blog :)
-
MySQL gotcha when using non-compulsory foreign keys
Posted on January 27th, 2010 No commentsI’m just writing a query at the moment that filters out test records from a database. These records have a foreign-keyed value that identifies test apps, e.g. a table with: id name 1 TEST 2 ANOTHER_VALUE 3 SOMETHING_ELSE This is joined onto the main data table, sensibly with a query like this: SELECT * FROM the_data LEFT JOIN the_values ON the_data.some_value = the_values.id WHERE the_values.name != 'TEST' The gotcha is however, that this doesn’t work as you’d expect
Read more here:
Sphere: Related Content
MySQL gotcha when using non-compulsory foreign keys
17, Eye, IDE, James, SQL, amp, base, check, coding, data, database, filter, gotcha, http, in, ing, join, key, left, like, me, mysql, name, no, not, null, query, record, simple, solution, something, table, test, to, value, values, work amp, base, gotcha, identifies-test, instance, joined-onto, null, onto-the-main, query, record, simple, simple-once, table, work -
Changing The Default Search Engine in Firefox Back To Google or To Something Else
Posted on September 6th, 2009 No commentsWhen you type keywords into your Firefox address bar and hit enter it usually goes off and searches a particular search engine for you. e.g.
View post:
Sphere: Related Content
Changing The Default Search Engine in Firefox Back To Google or To Something Else
17, 5, Chris, Google, IDE, Mac, OS, PS3, SQL, SSH, Search, URL, amp, apache, applications, book, box, browser, browser search, case, change, changing, chrome, click, code, config, default, default options, default search engine, development, double, double click, engine, filter, fine, firefox, fix, google co uk, google search, hanging, http, http www google com, in, install, iso 8859, key, keyword, keyword searches, linux, map, me, media, microsoft, mistake, mysql, new, no, not, one, open, opera, php, place, post, posts, replace, rest, search options, search url, server, software, something, system, thought, time, title, to, type, type keywords, ubuntu, value, web, when, windows, word, www box, chrome, config, double, from-the-google, google co uk, mysql, permanent-link, search options, server, thought -
Filling In Forms – Increasing Your Form Conversion
Posted on September 1st, 2009 No commentsThis kind of lazy form creation really annoys me. This company is trying to make users jump through hoops just so their form developers don’t have to bother reformatting the data into an acceptable format to them. It is absolutely critical when developing a form that must convert well to accept pretty much anything in the form.
Excerpt from:
Sphere: Related Content
Filling In Forms – Increasing Your Form Conversion
17, 5, BT, Class, HTML, IDE, James, Java, JavaScript, OS, RDP, Top, Wordpress, box, change, characters, check, code, coding, conversion, convert, custom, data, decimal, developers, error, exam, field, filter, form, format, formatting, forms, help, high, highlight, http, ical, ice, image, in, input, insurance, light, like, live, load, me, message, no, not, number, oop, ping, place, places, post, press, problem, replace, script, solution, sub, term, test, thought, tip, tips, title, to, upload, valid, value, warning, when, word, wp, www box, change, european, formatting, image, JavaScript, load, message, oop, ping, problem, reformatting, script, user, www -
in_array in Excel – or a Vertical Lookup
Posted on July 9th, 2009 No commentsI’m not a power Excel user, but as we handle a lot of data, I had to use it earlier today to do some in_array type searching. Basically, I had a CSV with a load of IDs, but we’d already processed some of the IDs
Read more here:
Sphere: Related Content
in_array in Excel – or a Vertical Lookup
17, 5, James, Read, Search, Technology, The List, data, day, excel, filter, first, form, http, ical, in_array, like, list, load, lookup, me, microsoft, new, no, not, one, open, php, process, script, something, time, to, type, value, values, vertical excel, James, list, load, matching, php, remove-the-ids, Search, similar-thing, Technology, type, values -
Master Master Replication on MySQL 5.1
Posted on May 6th, 2009 No commentsNot much for me to say here that isn’t covered in the following tutorial: http://www.howtoforge.com/mysql_master_master_replication Aside from the comments I made there, which I hope they include, if not I’ll update this post with those comments in due course Related posts: Getting Wordpress To Ping Google Blog Search I noticed today that my blog wasn't included in Google... How to filter user submitted data easily in PHP? How to filter user submitted data easily in PHP
Go here to read the rest:
Sphere: Related Content
Master Master Replication on MySQL 5.1
17, 5, Chris, Databases, Google, IDE, OS, RDP, Search, Wordpress, blog, book, click, code, comment, data, double, fact, filter, get, howto, http, ice, include, map, me, mysql, php, post, posts, sub, submit, tutorial, update, web, website, word, www double, fact, howto, include, map, permanent-link, thought, tutorial, www -
Some Recent Stuff on Web Application Security
Posted on May 5th, 2009 No commentsI subscribe to the Security Focus web application security mailing list and as a result I get all kinds of mail through on various topics from across the field. Recently (last 6-9 months or so) a few have caught my eye that I thought would be useful to forward to friends and colleagues also in the business, and similarly I thought I’d summarise those items here too: Anti-fraud Image Solutions from Gunter Ollmann Checklist for testing web apps from Paul Johnston OWASP TESTING GUIDE v3 from OWASP The Extended HTML Form attack revisited from Sandro Gauci Related posts: How to filter user submitted data easily in PHP? How to filter user submitted data easily in PHP
Go here to see the original:
Sphere: Related Content
Some Recent Stuff on Web Application Security
17, 5, Chris, Eye, FAIL, Google, HTML, IDE, Lol, OS, RDP, Search, Top, Uncategorized, Wordpress, blog, book, click, code, colleague, colleagues, data, double, filter, firefox, form, friends, get, home, http, ical, ice, image, images, include, list, map, me, php, post, posts, security, solution, source, sub, submit, technical, test, web, web development, word, www centos, colleague, Eye, FAIL, firefox, list, Lol, php, security, web -
Filter Input, Escape Output
Posted on January 29th, 2009 No commentsI’m currently working on cleaning up the sanitisation and validation libraries in our homegrown framework at Netbasic here, and I was given an excerpt from the Php|architect’s Zend PHP 5 Certification Study Guide - the Security chapter. The summary section really outlines a key point you should always bear in mind when writing any PHP code… filter input, escape output . Filtering input is important, and it is recommended to do this using a “white list” approach - i.e.
View post:
Sphere: Related Content
Filter Input, Escape Output
-
Advanced Syntax-Hilighting Online Code Editors – A Wordpress IDE?
Posted on July 2nd, 2008 No commentsWhen I write plugins for wordpress I like to do it on a test blog in a live environment. Maybe not the best idea, but it's how I like to do it, and it also flags up any weird and wonderful restrictions to the development of the plugin as a result of my hosting company's security policy
See the original post:
Sphere: Related Content
Advanced Syntax-Hilighting Online Code Editors – A Wordpress IDE?
17, 5, Chris, File, Files, Google, HTML, IDE, Java, JavaScript, OS, Plug, Pot O' Ideas, RDP, Read, Someone, Top, Wordpress, auto, available, backup, base, blog, book, cd, code, codepress, cool, data, development, editor, exam, fact, filter, flash, fun, functionality, functions, get, high, highlight, host, hosting, http, ical, ice, language, light, like, list, live, me, name, no, not, one, open, opera, page, php, place, player, plugin, plugins, post, posts, press, problem, project, rest, script, security, solution, string, sub, submit, syntax, system, term, test, theme, thought, time, tip, title, to, type, update, value, values, view, web, web development, website, when, word, work, wp, www exam, File, functionality, host, laptop, mobbler, php, price, project, tip, update, www -
Firefox Fail
Posted on June 17th, 2008 No commentsOK.... Let's make history.....
Read this article:
Firefox Fail5, Chris, Class, FAIL, Google, Lol, OS, SEO, Search, Uncategorized, book, code, data, domains, filter, firefox, home, http, image, in, key, keyword, linux, load, loaded, me, no, one, php, post, posts, record, running, sub, submit, title, to, upload, word, world, wp, www domains, filter, firefox, firefox-fail, image, load, php, random-search, router-which, running, Search, sub, sub-domains, upload
