Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
Building a sample PHP/mySQL web app showcase
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  13 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post will appear after it is approved by moderators
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Gokemon  
View profile  
 More options Nov 17 2012, 11:47 am
From: Gokemon <michael.of.go...@gmail.com>
Date: Sat, 17 Nov 2012 08:47:43 -0800 (PST)
Local: Sat, Nov 17 2012 11:47 am
Subject: Building a sample PHP/mySQL web app showcase

If you were building a sample PHP/mySQL web app to show off your skills,
what 5 or 6 features would you want to showcase or think you need to have
in there, to prove you can do the work?

In my case, so much of my work has been rather simple in design, not fancy,
not flashy, and just functional? Like a user register with email
activation, log in system with profile editing and password reset, which
can show you understand sessions & cookies, and SQL & database connectivity
is one, but what else would you build into a showcase?
I can paginate record sets across pages, and do file uploads, which I am
working on converting into a photo tool for advanced profiles.
I’ve never done a shopping cart from scratch yet, so that’s on tap for
later, but what would convince you that I knew what I was doing, if you
were an employer?


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
WhiteAlbumRegistry  
View profile  
 More options Nov 17 2012, 3:39 pm
From: WhiteAlbumRegistry <t...@whitealbumregistry.com>
Date: Sat, 17 Nov 2012 12:39:50 -0800 (PST)
Local: Sat, Nov 17 2012 3:39 pm
Subject: Re: Building a sample PHP/mySQL web app showcase

First thing that comes to my mind is security. Be able to show that
understand using globals ($_POST) isn't part of your process and that you
scrub any data coming in.

Obj Orientated Programming - show you can build objects, classes,
private/public methods, etc.

The real issue is if a company uses a framework, in which case knowing
code-igniter or zend is important. Otherwise, understanding how to program
(in a general sense, like how to loop thru an array or ) is more important
than what you can do with it. The reason for this is there are often
several ways to achieve the same goal, but what's important is that you can
demonstrate a 'smart' way to solve the problem.

Then, there might be some additional specifications like command-line
experience (unix and/or access mysql). Depending on the size of the firm
you might need to have some UX/UI understanding, CSS, JS, jQuery, Ajax,
HTML5, etc.

Oh, just thought of another. While it might not be required or even
requested, demonstrating well organized code with appropriate commenting
would be a selling point.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jason Shinn  
View profile  
 More options Nov 17 2012, 10:43 pm
From: Jason Shinn <jmsh...@gmail.com>
Date: Sat, 17 Nov 2012 19:43:41 -0800 (PST)
Local: Sat, Nov 17 2012 10:43 pm
Subject: Re: Building a sample PHP/mySQL web app showcase

There's no "5 or 6 features" that really make a comprehensive target to aim
for.  WhiteAlbumRegistry hits a lot of high points (though I don't exactly
know the best way to "scrub data" without first pulling it from $_POST, but
I don't think that's what he meant).

I think the important takeaway is that, as far as hiring is concerned,
which means interacting with requirements as submitted to HR, keywords are
more important than samples.  Odds are if you build a sample, no one would
look at the actual code that you built.  What's important is that you can
work with the keywords (technologies/frameworks/etc) that are important to
the company you're aiming to get hired by, and those are so variable that
you couldn't hope to build a comprehensive sample that would really
encompass everyone.

The best answer is to be and know you are an expert in PHP, which means
that if you haven't dealt with a particular problem or requirement, you can
immediately formulate an approach to handle it anyway.  If you are at that
level with PHP, then everything else is just details.  If you're not, then
know what you can do and know enough to know what you can't do.  If you are
able to articulate the things that are on your list of things to learn,
that's almost as good as already knowing how to do them, because it shows
that you have the capacity to identify how and where to grow.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brian Moon  
View profile  
 More options Nov 17 2012, 11:28 pm
From: Brian Moon <br...@moonspot.net>
Date: Sat, 17 Nov 2012 22:25:27 -0600
Local: Sat, Nov 17 2012 11:25 pm
Subject: Re: [AtlantaPHP] Re: Building a sample PHP/mySQL web app showcase

> There's no "5 or 6 features" that really make a comprehensive target to aim for.  WhiteAlbumRegistry hits a lot of high points (though I don't exactly know the best way to "scrub data" without first pulling it from $_POST, but I don't think that's what he meant).

See http://php.net/filter_input


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "Fwd: [AtlantaPHP] Building a sample PHP/mySQL web app showcase" by Jonathon Hill
Jonathon Hill  
View profile  
 More options Nov 17 2012, 8:33 pm
From: Jonathon Hill <jhill9...@gmail.com>
Date: Sat, 17 Nov 2012 20:33:04 -0500
Local: Sat, Nov 17 2012 8:33 pm
Subject: Fwd: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

Failed to copy the list on my reply, here it is for your benefit.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Discussion subject changed to "Building a sample PHP/mySQL web app showcase" by Todd Blumenthal
Todd Blumenthal  
View profile  
 More options Nov 18 2012, 10:33 am
From: Todd Blumenthal <t...@whitealbumregistry.com>
Date: Sun, 18 Nov 2012 10:11:38 -0500
Local: Sun, Nov 18 2012 10:11 am
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

Every programming interview I've had has requested to see code. If you get past HR, be prepared to show and explain your code.

One other point I'd like to make is that most places probably already have most their operational code written. You might only be needed for maintenance or adding new features to the existing codebase. I've found that many of the things I learned like mysql_connect never gets 'practiced'.

On Nov 17, at 11:25PM, Brian Moon <br...@moonspot.net> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Duane  
View profile  
 More options Nov 19 2012, 4:28 am
From: Duane <dacme...@gmail.com>
Date: Mon, 19 Nov 2012 01:28:51 -0800 (PST)
Local: Mon, Nov 19 2012 4:28 am
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

Everyone has raised some valid points and given great advise, but the most important and impressive skill is communication.

If you can explain your code (why you choose a certain method, process, implementation, etc.) to anyone else and have them understand your logic that alone will prove that you know your stuff.

If you can't explain it then you don't know it, plain and simple.

Creating a website to showcase backend skills won't serve that purpose. It will not show that you have created a killer form handling class or image management class, all it will show is that your login form works or you image does get uploaded or at least the errors are handled properly.

I am assuming that this is for the purpose of interviews; most companies want to see your code and want to know that you can explain and back up your logic whether it is the best way to do it or not.

So all that just to say that there is no backend skill that you can display on a website that will quantify or qualify your skills, you gotta be able to talk that stuff and roll with it.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brian Moon  
View profile  
 More options Nov 18 2012, 2:31 pm
From: Brian Moon <br...@moonspot.net>
Date: Sun, 18 Nov 2012 13:31:10 -0600
Local: Sun, Nov 18 2012 2:31 pm
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase
As someone that hires people, I would ask if you want to be a web
developer/engineer or do you want to be a PHP programmer. I typically
don't hire "PHP programmers" despite 90% of all the code we write being
PHP. Learning the frameworks and knowing how PHP sessions work will get
you a mediocre job. And I would guess that those places only really care
about a small part of your skills.

On the other hand if you want to be a web developer/engineer, you need
to show that you understand concepts like security (and not just PHP
specifc things), scalability, high availability, maintainability,
algorithms, etc. Being well versed in more than just PHP is a good thing
as well. The last few hires I have made have had little to no PHP
experience. But, they had solid development and engineering skills.

Some of the comments are right. If you have to interface with HR first,
keywords are required. That is the only thing they have to go on is
those keywords. But, once you are past HR, things will change. You may
have to talk to managers. Those guys may not know anything about PHP or
the things I mentioned. So, again, keywords may be important. In that
case you will have to be able to speak intelligently about those
keywords however. Not that they will know everything you are talking
about, but they may know enough.

We rarely ask for sample code in interviews. That is like asking for a
highlight real. Sure, if the person is really, really bad, it will show.
But, the interview probably already weeded those people out.

Just my 2 cents.

Brian.
--------
http://brian.moonspot.net/

On 11/17/12 10:47 AM, Gokemon wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Brian Moon  
View profile  
 More options Nov 18 2012, 2:33 pm
From: Brian Moon <br...@moonspot.net>
Date: Sun, 18 Nov 2012 13:33:05 -0600
Local: Sun, Nov 18 2012 2:33 pm
Subject: Re: [AtlantaPHP] Re: Building a sample PHP/mySQL web app showcase

> The best answer is to be and know you are an expert in PHP.

The only people that have ever told me they were an expert in PHP were
far from it. There are only about 100 of those people in the world.

Brian.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jason Shinn  
View profile  
 More options Nov 19 2012, 8:46 pm
From: Jason Shinn <jmsh...@gmail.com>
Date: Mon, 19 Nov 2012 20:35:21 -0500
Local: Mon, Nov 19 2012 8:35 pm
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

What I mean by "be an expert in PHP" is pretty much a combination of what
Brian Moon is talking about with regard to being a "web
developer/engineer", and Duane is talking about with being able to
communicate.

Ultimately, if you know your craft and you can communicate that, be
confident in that ability, because that alone will put you ahead of the
vast majority of your peers, unless you're interviewing at Google or
similar marquee development company.

Failing that, you need to learn 1 thing: know what you don't know - if
you've never used OOP, that's OK, probably.  But when you tell that to your
interviewer, it's more like "I've never been involved with a project that
used OOP, but I've been looking for a way to get started."  If you can pick
out the high points that will be relevant, OOP, frameworks, security, etc.,
then you're halfway there, it tells them that even if you don't have the
experience, you have the knowledge and interest to improve yourself,
whether you do it with that company or somewhere else.

Regardless of your level of ability, you'll always struggle if you're not
able to communicate, to Duane's point.  The whole point of an interview is
to enlighten those trying to hire you about yourself, and why you deserve
the job.  Not everyone likes doing that, and not everyone feels confident
that they have anything worthwhile to enlighten the interviewer of.  It's
not hard to know your worth to a company.  Be curious, educate yourself,
and communicate what you've learned.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Dan Kelly  
View profile  
 More options Nov 20 2012, 6:48 am
From: Dan Kelly <dankelly2...@gmail.com>
Date: Tue, 20 Nov 2012 06:48:18 -0500
Local: Tues, Nov 20 2012 6:48 am
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

Hello All,

Has any one else had this problem? When I'm at home developing a PHP
application and I need something I go to my Library and grab the code that
I have written before.. I don't write the same code over and over again..If
it's new code I will write it and add it to my library.

When I go on a job interview I show my sample application and code.. I
explain what the coding does in detail.. The next thing they do is give me
a test and I seem to freeze or I am unable to finish the test. If I was
working at the company I would not have any issues with coding.

I have over 15 years of development experience, but I struggle with this
issue.  I have been in Atlanta going on 4 years and I've been on many job
interviews and its the same issue over and over again.. I never even get a
call back.. I've had a freelance job in software testing during this
time(work from home), but every once in a while I decide that I may be
better off working for a company, therefore I go through the same process
over again. Maybe I am just meant to continue on the path that I am on and
not work for a company.. I don't know the answer..

-  Dan

--
Thanks,
Dan Kelly
http://www.kellywebserv.com
Professional Portfolio<http://www.kellywebserv.com/design/index.php?content=portfolio>

Customer Testimonials<http://www.kellywebserv.com/design/index.php?content=testimonials>
229-848-3243

~~~~~~~~~~~~~~~~~~~~~~
Add me as a friend! - FACEBOOK<http://www.facebook.com/profile.php?id=542101016>
Follow me! - Twitter <http://twitter.com/#%21/kellywebservice>
Looking for a great deal on
Razors<https://www.dollarshaveclub.com/ref/lg8/jr1tvd>?


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Jason Shinn  
View profile  
 More options Nov 21 2012, 12:15 am
From: Jason Shinn <jmsh...@gmail.com>
Date: Tue, 20 Nov 2012 21:15:05 -0800 (PST)
Local: Wed, Nov 21 2012 12:15 am
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

I haven't had the problem (though I don't actually have that much
"interview experience", and have only once been given any sort of skills
test), that said the solution seems straight forward enough: practice,
practice, practice.  If you find yourself getting stuck on a PHP skills
assessment test when you don't have access to your code library, then find
some tests online and take them without accessing your code library.  If
you find a point you get stuck on, study it.

It's not exactly easy to find more than basic tests online (at least, not
for free).  I googled "online php skills test" and came up with a couple
potential options that might get you going.

If it's more of a "code up an application or function to these specs" type
of test, then pick a couple representative projects that you remember from
interviews where you got stuck, and just bang it out on your own time
without using any external resources.  If you get stuck, make a note of
where and why, and study up on it.

It really doesn't matter what you're getting stuck on in the interview
process, the test or some other area, if you find yourself getting stuck,
study, practice, and just do it to death before you ever walk through the
door.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Mike Schinkel  
View profile  
 More options Nov 21 2012, 1:42 am
From: Mike Schinkel <mikeschin...@gmail.com>
Date: Wed, 21 Nov 2012 01:42:13 -0500
Local: Wed, Nov 21 2012 1:42 am
Subject: Re: [AtlantaPHP] Building a sample PHP/mySQL web app showcase

Surprised nobody has mentioned activity on GitHub and open source as being important. See:

http://news.cnet.com/8301-10797_3-57495099-235/forget-linkedin-compan...
http://programmers.stackexchange.com/questions/82973/how-would-you-as...
http://code.dblock.org/github-is-your-new-resume
http://apievangelist.com/2012/10/06/github-is-the-social-network-of-t...
http://news.ycombinator.com/item?id=2763182

-Mike

On Nov 21, 2012, at 12:15 AM, Jason Shinn <jmsh...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »