-
Posts
1,008 -
Joined
-
Last visited
Posts posted by spiderwell
-
-
hey all,
Wanted to share my good fortune really, so this is what has been happening with my career this year.
Got my first professional web developer job laster year (in over 8 years after a break) with a small local firm in Devon (rural west england to those overseas), and it wasnt paying great at 17k, but that isnt a bad wage in that part of the country, but I was just grateful to be back in the business professionally after so long.
At xmas this year, I made a point of changing and improving my situation, and moved to london, worked out 3 weeks at home and departed my old job. Updated my CV, put it online and omg, the phone did not stop ringing for over a week! so many recruiters and jobs around! So i had a few interviews, and after a bit of a cock up, accepted a job that I had originally turned down, and started work for a firm as a php developer with a 8K increase on my wage.
I was totally happy, I had proven to myself I was worth more, gotten a good job with a good firm and settling into London life (again).
However 2 weeks ago, they let me go, somewhat unfairly, but I wont go into that, and found myself on the market again!
I was a bit pissed off with this as it was unexpected and meant I had to go through the job hunt all over again. Well it was just as good as last time, update my cv online at a few job sites and the phine starts going mental!!
I just missed a role I really wanted at IPC media (publish every magazine in the UK pretty much), a close second I was told. Then another job I was also interviewing for offered me a role, which I wasn't as keen on (furniture company) but it was still good, and they offered me 35k!!!
I bit their hand off of course and start on Tuesday!
Still a bit shocked but have managed to double my salary in 6 months!!
So I hope this story inspires others!
-
i use Ion_auth for codeigniter
-
i have vague memories of doing this with old classic asp because it didnt like echoing out </script> as a complete word, so maybe its someone with old habits
-
-
and does the fact its different tables make any point?
-
totally disagree with this (the OP statement)
-
i will make my sites comply when the government bother to do the same to all of theirs
-
alternatively you could store the message id into the session object on message viewing, and then retrieve it when on the reply page.
-
in the past i have made a site that stored all the insects i had caught, and put them into the correct order/family/species/genus kinda of thing, but it was classic ASP, so long gone now!
not sure if this chemical compound quiz counts as an app?
its still in development, currently though im in the process of converting what i have done to codeigniter, as building my own mvc framework was too much effort!! : http://ethickink.co.uk/elemental/
-
there is no code relating to sessions here for us to work with...
-
what code have you got so far?
-
radio buttons would be the obvious choice for a yes or no response, you should stick to them, or as sugggested just the one to 'opt in' and hae opt out as default
-
ah i hadnt used the group by bit. that has fixed it, thanks again
-
using double quotes is also a waste of server resources as it then has to check every string for embedded variables, using single quotes and concatenation is a better way of doing it, because it does not check strings with single quotes for embedded variables.
-
ok so further investigation shows that this isnt working after all, if i have 2 users, it only shows 1 user, and puts both users' roles into 1 user, the first one. I am really not sure where to go next
-
this is not uncommon, i have come across it myself at my work, it down to users closing the window before the page loads entirely, as far as I can tell. one thing is for sure, it isn't fraud.
-
ah perfect, thanks a lot for your help, my sql definately needs some big improvement!
-
ok so now i have this:
SELECT *, GROUP_CONCAT(groups.name) as `roles` from users join users_groups on users.id = users_groups.user_id join groups on users.id = users_groups.user_id
which works but i am getting the 'roles' all listed twice, do you know why that might be?
-
having a look now, thanks for the link
-
Hi all, I am having trouble returning a recordset in the way i want.
I have 2 tables, one is users, the other is user_groups
any user can have 1 or more entrys in the user_groups table, hence the one to many relationship title.
I am trying to return a recordset that only returns 1 row per user with an alias that has a comma seperated list of the groups that the user is in.
In this particular instance there is an extra table joined to the user_groups, called groups which will give names to the int entrys in the users_groups.
this is the query i have come up with but it seems to fall over near the XML path bit, but i am not sure how to fix it, my sql is rather weak sadly:
SELECT *, Stuff((SELECT ','+ `name` FROM users_groups join groups on users.id = users_groups.user_id WHERE users.id = users_groups.user_id FOR XML Path('')),1,1,'') as `roles` from users limit 10 ;
my table structures are:
CREATE TABLE `users` ( `id` MEDIUMINT( UNSIGNED NOT NULL AUTO_INCREMENT, `ip_address` INT(10) UNSIGNED NOT NULL, `username` VARCHAR(100) NOT NULL, `password` VARCHAR(40) NOT NULL, `salt` VARCHAR(40) NULL DEFAULT NULL, `email` VARCHAR(100) NOT NULL, `activation_code` VARCHAR(40) NULL DEFAULT NULL, `forgotten_password_code` VARCHAR(40) NULL DEFAULT NULL, `forgotten_password_time` INT(11) UNSIGNED NULL DEFAULT NULL, `remember_code` VARCHAR(40) NULL DEFAULT NULL, `created_on` INT(11) UNSIGNED NOT NULL, `last_login` INT(11) UNSIGNED NULL DEFAULT NULL, `active` TINYINT(1) UNSIGNED NULL DEFAULT NULL, `first_name` VARCHAR(50) NULL DEFAULT NULL, `last_name` VARCHAR(50) NULL DEFAULT NULL, `company` VARCHAR(100) NULL DEFAULT NULL, `phone` VARCHAR(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=2; CREATE TABLE `users_groups` ( `id` MEDIUMINT( UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` MEDIUMINT( UNSIGNED NOT NULL, `group_id` MEDIUMINT( UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=3; CREATE TABLE `groups` ( `id` MEDIUMINT( UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(20) NOT NULL, `description` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=3;
an assistance would be greatly appreciated!
-
i was about to suggest CK Editor
-
as a uk resident i would say it really bugs me when address options only have zipcode and dont have postcode as well, especially if they are trying to be offering all options for global addresses, and the same for putting U.S. as the default country, its probably just me though
-
its a shame that w3 schools is riddled with errors, i would never suggest that site to anyone
-
its all run by jquery in the front end, and i think the layout cant all be credited to me since most of it is the periodic table.
got a new job (again)
in Miscellaneous
Posted
my CV isnt that impressive, or at least I dont think so! I think the main reason of my improved stituation is down to moving to london!!
however my CV is here:
Personal Profile:
I am a web developer and have built websites from concept through to live status. Used multiple languages and software to match requirements when necessary. Varied IT skills that also cover ISP support and server maintenance, network support. Successfully managed client relations, some graphic design, worked to deadlines. An example of Jquery here .
Recent Work:
Environmental Business Products April 2012 ? June 2012
Short contract as a PHP Developer ? maintain current and build new sites, using Codeigniter, which is another MVC OOP style framework.
Shake Creative - PHP Developer; May 2011 ? March 2012
A new media company based in Tiverton, Devon I was hired as a php developer. My role had a wider spectrum than just pure php. It also involved taking concept documents such as PDFs/PSDs and chopping those up into separate images and creating html/css templates. The sites that I have worked on have been integrated into an OOP MVC application that is unique to the company, written in php. Some projects involved custom classes to extend the ability of the system, a recent example was a class booking system for a baby swimming franchise. My role is currently a healthy mix of front and back end development. I also have made facebook pages and e-shots (html emails) to be then used in such sites like mailchimp etc.
Some examples of sites I worked on during my employment.
http://clahrc-peninsula.nihr.ac.uk/
http://www.dukessidmouth.co.uk/
http://www.computercomponents.ltd.uk/
Company Site: www.shakecreative.co.uk
Recent Freelance Work:
www.wafphoto.fr ? We are French Photography site, launched December 2011
A members only collaboration of like minded French photographers. PHP & MySQL & JQuery technologies used along with HTML & CSS, allows members to create profiles and upload images as a portfolio. Admin members can also edit site content and keep spreadsheets of data online and are downloadable on demand.
www.tusculum.co.uk ? Property Auction Site, completed November 2010
Client wanted an online auction site for properties. System includes a full backend which allows user management, property uploads, and bid management. Front end has property listings, registration page, bid functions, which error checks bids, to ensure correct bids are placed, users are registered and bid is of at least a minimum increment from last bid. All data is stored in mysql database.
www.cedricdelsaux.com - Photographer, completed March 2010
Client required an online facility for gallerys to login and enter details of exhibits sold. I had to build with PHP and MySQL. Site has user specific login, permissions, updateable content, etc and was all turned around in 2 week deadline. Due to the nature of content this site is not available publically, but I can show the code involved if requested.
www.geoline.co.za - Geoline Services, completed October 2009
[/color]This company had an outdated website that they wanted updating as well as adding further information to the site. I met with the owner, and discussed what was required from the site. I came up with a design and had it signed off by the client, and completed the construction of the site. It was completed and put live in the last quarter of 2009. This site uses xhtml, css & javascript
[/color]In the last 3 months I was approached to add a private file sharing area for their clients.
www.tsr-performance.com - TSR Performance Garage, completed 2008
This company also had an outdated site, and required a redesign as well as the ability to update certain aspects of the site. I met with the owner, discussed all that was required from the site, and gave them a new design for the site. Once this was agreed, I built the site, with its content management suite and the whole thing was put live in mid 2008. This site uses html, css, javascript and asp
Other Relevant Experience
Freelance Web developer; 06/2002 to 05/2004 Meeting clients and taking web site through complete life cycle from concept to final sign off and put live. Web design and development, bespoke Content Management Systems. Database construction / Management. IIS, NT4 and SQL2000 maintenance for host server.
[/color]Changes Live Digital Cosmetics; Senior Web developer - 09/2000 to 06/2002
[/color]Site maintenance. (Cross browser DHTML), PERL and DSQ coding to ensure ease of future site maintenance. Created new databases utilising stored procedures and triggers, SQL7 server maintenance. Set up XML database tied into new registration page. It used simple COM objects such as CDONTS and ADO.
[/color]Online Travel Company;[/color] New media developer - 01/2000 to 09/2000
Hand coding using ASP, DHTML, CSS, JavaScript & Cookies. Used VSS development package. Maintained companies web site, including IIS 4 server maintenance. Developed new content; banner ads, logos, buttons & dynamic pages. Training other temporary members of staff.
[/color]Connect Internet Services; Web designer - 01/1999 to 01/2000
Web design for local businesses. Domain / Email set up for clients.
[/color]Custom graphics build where required.
[/color]
[/color]Other Previous Jobs:
Mendip District Council Benefits - Assistant April 2009 to Nov 2009
Worked in Primary team dealing with all correspondence that was received, from simple updates to complete new claim applications. Assessing claims and ensuring that relevant inclusive material was correct and applicable to claims. Using specialist software to suspend payments if necessary and write correspondence to keep all parties aware of any changes in circumstances to prevent overpayments and other possible deviations.
Easynet Technical Assistant ? Nov 2006 to April 2009
Monitoring the network and advising technical support operators with regard to fault issues via websites and over the phone. Diagnosing any escalated issues through troubleshooting and knowledge of fault symptoms to find a resolution within a given SLA. An in depth knowledge of Windows and Macintosh Software, ADSL, dial up connection and core exchange stinger commands. A professional and friendly phone manner with great customer service skills. Taking ownership of escalated and VIP customer problems and resolving them to a satisfactory conclusion for all involved.
[/color]P&D Agency Work - 09/2003 to 07/2006[/color]
Worked in admin of military association, redesigned access database, maintained and kept updated. Responsible for stock, setting up direct debits, dealing with dividends of shares. Worked for Highways Agency in environmental department. Responsible for pulling hard copy data from files, entered into database information related to endangered species recorded on site works for a new database application. Worked for NHS in post room; Responsible for redistribution of Doc Notes, Forms, Syringes; Worked in Warehouse dealing with archived records & Doctor Practice ?stationary? orders
Stilwell Gray Accountants; Tax Assistant - 01/1997 to 09/1998 Handled telephone / email enquiries. Processed tax returns / dividend payments. Issued tax / N.I payments. Assisted clients in creation of individual tax / salary schemes. Acted as office technical support, included I.T upgrades, maintenance.
[/color]Benefits Agency; Administrative Officer - 01/1995 ? 01/1997[/color]
Face to face customer relations.Issued Giro cheques / payments.Maintained benefits database. Issued N.I numbers to new immigrants. Managed day to day running of office
Educational Qualifications [/color]09/98 ? 01/99.[/color] Adult Education Centre, Southampton. Business Studies A-Level
[/color]09/95 ? 06/96.[/color] Peter Symonds Adult Education, Winchester. 5 GCSEs include English and Sciences
[/color]09/93 ? 06/95.[/color] Technical College, Southampton. BTEC National in Science
[/color]09/89 ? 06/91.[/color] Technical College, Eastleigh. Completed 1st year of Electrical Engineering course
[/color]09/85 ? 07/88.[/color] Charterhouse School, Charterhouse. 8 GCSEs & O Level Maths (took early)