1. How many months/years of active PHP programming experience do you have?
2. Are you available during EST* working hours (9 am - 5 pm) for IM chats? What hours?
9-5 is perfect.
3. Please provide an ERD diagram for a well-designed database that you had already created.
Yes of course…
4. What general practicesdo you follow to insure site security and what specifically for PHP/MYSQL? How do you handle client state?
I have designed a php funtion to avoid usual attacks like sql, xss injection. In the case of RFI and LFI attacks I use the instruction switch php to protect my applications of them. I ensure don't display error notifications to the user to avoid he knows the details of the web siteconfiguring display_errors instruction.
5. Describe in which situations you would use a transactional system? What are its advantages and disadvantages?
Well, transactional systems are useful for those environments where it's important be careful with the correct execution of the operations ensuring the integrity, reliability, consistency of the information in the database and it letus undo wrong operations with mistakes. The most significant disadvantage in this system is performance compared with those systems no transactional.
6. If you were about to start a new Project; what things would you consider in order to determinate what type of tables you will be using (innodb or myisam)?
Well, Innodb protects referential integrity (using pk, fk) and allows usetransactional operations otherwise Myisam doesn't allow use it but it's faster.
7. Describe how a database handles transactions. Describe a typical transactional sequence at programming level?
To use transactional sequence is important to configure innodb option in the database. With the instruction 'begin' we initialize the operation in the database engine afterwards we indicatestatements to manipulate the information database for example insert, update or delete. To confirm this transaction into database we need to apply a commit command otherwise we could use rollback command to undo action in the database.
if processA is trueCommit;
8. How do you handle PHP/SQL errors on a web page? How would you trap and report errors in real time?
To dealing with error handling and logging I basically use three options:
I try, during software testing time, to show all possible outputs for the bugs and in this way to recognize them as early as possible. Once softwareis near to release I use to hide those messages so process will be clear for the user.
To handle error on my pages I usually prevent some errors in runtime using the outputs of the php functions, for example mysql_query (it returns false in the case on error), in conjunction with the sentence if.
And the last one is employing the set command for error handling provided for phplike the sentences: try and catch, set_error_handler, error_log to name just a few.
9. What build process do you use for a website?
My build process is:
1. To get the requirements
2. Feedback with the clientAnalyze the requirements
3. Analyze the requirements
4. Design of Data Base: DER
5. Design of Software: UML
6. Confirm with the client myproposal assures a solution for his problem.
7. To configure the features necessary that allows the developers team to work and to customize the site in accordance with client's requirements.
8. Programming the site.
9. To test the site web, recognize bugs and correct them
10. Approve site
11. Release site
10. What software release lifecycle do you use for a website?...