About phpCodeGenie

Introduction

Given any database schema, tables within, list of fields and properties, one ought to be able to build any kind of database backed applications in any programming language. The basic operations that a database driven application will have are usually the same - Create Records, Retreive Records, Update Records, Delete Records (CRUD).

phpCodeGenie attempts to generate these CRUD code so that programmers have a base they can work on. The core database access code and scripts are usually the same for most applications. Rather than spending a lot of time doing these common code, we can spend our time on the business logic of our applications and let PCG do the boring code for you. phpCodeGenie can generate simple code for beginners where everything is done in the same PHP script or structure Object Oriented PHP Code that follows the PCG framework.

phpCodeGenie requires you to design your tables and then the genie can generate code for reading and writing to the database, the html forms to enter or edit data in the database, scripts to list data, scripts to delete data, search forms, search scripts among others.

Supported Databases

phpCodeGenie can interact and generate code from many database servers - MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP, through the ADODB Database Abstraction Library.

Overview

Motivation
Object-relational mapping (ORM) is useful in developing web applications.

Many of us in desperate search for good ORM tools for PHP end up finding existing PHP persistence packages are either insufficient to address the problems we face, or unnecessarily complex that demand a steep learning curve that not many of us are able or willing to afford. And most importantly, we don’t see the existing tools providing satisfactory solutions that can work with existing code and/or databases. This is what got us started to work on an alternative.

The goal of this project is to design a lightweight and easy-to-use persistence solution for PHP. This is how the project got its name, Easy PHP Data Objects (EZPDO). Simplicity is the key. Constantly we keep the following requirements in mind when designing EZPDO.

It requires zero SQL knowledge1) and a minumum amount of effort in ORM specification.
It should work with existing classes and does not alter the source code.
It should only introduce overhead to a minimum to guarentee performance.

EZPDO is also a test-driven project with continous integration. More on that in developer’s guide.

Features
Here is a quick look at the features in EZPDO before you delve into any details.

Minimum SQL knowledge required
Requires minimum ORM specification
No Phing! No need of explicit command line compile
Works with existing code and database
Has a small runtime core to guarentee performance
Handles 1:N, and M:N relationships automatically
Provides a simple runtime API
Supports object query (EZOQL)
Auto generates database tables
Test-driven with continuous integration

Recursion in plain English
Recursion is the process a procedure goes through when one of the steps of the procedure involves rerunning the entire same procedure. A procedure that goes through recursion is said to be recursive. Something is also said to be recursive when it is the result of a recursive procedure.

To understand recursion, one must recognize the distinction between a procedure and the running of a procedure. A procedure is a set of steps that are to be taken based on a set of rules. The running of a procedure involves actually following the rules and performing the steps. An analogy might be that a procedure is like a menu in that it is the possible steps, while running a procedure is actually choosing the courses for the meal from the menu.

A procedure is recursive if one of the steps that makes up the procedure calls for a new running of the procedure. Therefore a recursive four course meal would be a meal in which one of the choices of appetizer, salad, entrée, or dessert was an entire meal unto itself. So a recursive meal might be potato skins, baby greens salad, chicken parmesan, and for dessert, a four course meal, consisting of crab cakes, Caesar salad, for an entrée, a four course meal, and chocolate cake for dessert, so on until each of the meals within the meals is completed.

It is important to note that a recursive procedure must complete every one of its steps. Even if a new running is called in one of its steps, each running must run through the remaining steps. What this means is that even if the salad is an entire four course meal unto itself, you still have to eat your entrée and dessert.

This website exists to provide you with information to use while learning or developing PHP and MySQL. If you need PHP Help or you would like to provide PHP Help to other developers, you are in the right place. Additionally, we offer Apache Help, MySQL Help, Javascript Help, CSS Help, XML Help and much more.

MySQL Freaks is an online community built to help each other with MySQL. This community is completely Free to use and get the information you need to solve your MySQL problems.

Apache Freaks is an online community built to help each other with the ever so popular Apache Web Server. This community is completely Free to use and get the information you need to solve your Apache Web Server problems.

WAMP server is Windows Apache MySQL PHP Server all bundled into one nice package. This package is great to test your projects, you don’t need to upload every time you need to test a change. You can test everything from you own Windows machine

Pre-Compiled WebServer for the Windows NT Based OS (NT, 2000, XP, 2003). Includes apache2, mysql, activeperl, mod_perl, mod_security, php, adodb, awstats, phpMyAdmin, phpMyBackupPro, smarty, turck-mmcache packaged into an installer (WAMP).

Easy, modular and flexible WAMP bundling Apache2/SSL, MySQL4, PHP4, Perl5.8/ASP, Python2.3, Tomcat5, FirebirdDB, FileZilla, Mail/News-Server, phpMyAdmin, Awstats, WordPress, etc. It also includes a web-GUI to control/manipulate all bundled services.

A complete server platform for business: web, database, portal, ecommerce, intranet, office, email, virtual office/VPN, security, groupware, CMS, CRM, workflow. Apache, LAMP, WAMP, J2EE, Zope, Webware,Perl,Python, jk2, portal kit, portlet, accounting/ERP

Extroverted (E) 58.33% Introverted (I) 41.67%
Sensing (S) 48.78% Intuitive (N) 51.22%
Thinking (T) 57.89% Feeling (F) 42.11%
Judging (J) 57.89% Perceiving (P) 42.11%

ENTJ
decisive, fearless, planner, thrill seeker, engaged, social, self centered, comfortable around others, image conscious, likes to be center of attention, adventurous, outgoing, manipulative, emotionally stable, leader, ambitious, hard working, dominant, prepared, hates to be bored, confident, opinionated, analytical, prepares for worst case scenarios, organized, orderly, clean, driven, resourceful, finishes most things they start, achieving, risk taker, desires fame/acclaim, image focused, narcissistic, arrogant, perfectionist, driven, academic, scientific, critical, avoids giving in to others, does not like to compromise, skeptical

favored careers:
marketing specialist, government employee, lawyer, developer, political scientist, bounty hunter, international relations specialist, software designer, systems analyst, business manager, entertainment lawyer, foreign service officer, strategist, project manager, advertising executive, cia agent, marketing manager, geneticist, private investigator, administrator, business analyst, politician, management consultant, producer, financial advisor, entrepreneur, genetics researcher, cardiologist, professor, fbi agent

disfavored careers:
singer, bookstore owner, job in the performing arts, poet, photographer, english professor, chef, health care worker, child psychologist, massage therapist, video editor

Enneagram Tests
The Enneagram is a nine factor personality system that is sort of a historical mutt, many different influences. The nine factors are - orderliness, helpfulness, image focus, hypersensitivity, detachment, caution, adventurousness, strength, and calmness.

Jung Tests
These tests are based on the work of Carl Jung, David Kiersey, Isabel Myers and Katherine Briggs. They are similar in underlying theory to the Myers-Briggs Type Indicator (MBTI) and the Kiersey Temperment Sorter. They measure four bipolar factors, Introversion/Extroversion, Thinking/Feeling, Intuition/Sensing, and Judging/Percieving.

Percentile Tests
These tests show you how your answers on statements or descriptive words/phrases compare to other people who have answered in the past, a useful/interesting test to see how you compare to others on different issues.

Big Five Tests
The Big Five is the most proven personality test in the academic research community presently. It is composed of 5 factors - open-mindedness, conscientiousness, agreeableness, emotional stability, and extroversion (the factor names vary a little among authors).

Right-Left Brain Tests (Brain Laterization)
These tests measure your right and left brain functions, indicating strengths and possible weaknesses, and whether you are more dominant in one hemisphere.

Other Personality Tests
Personality Disorder Test - this test is based on the 10 DSM-IV personality disorders.
Eysenck Personality Test - based on the personality theory of pioneering theorist Hans Eysenck, 3 factors - extraversion, neuroticism, and psychoticism.
Cattell 16 Factor Test - based on the work of Raymond Cattell, another personality research pioneer.

Compatibility Tests
*The multi-user tests require two or more people to respond to receive results (an option to email the test is available). The single user tests are self reporting (you can provide the answers for yourself and the person you are trying to assess compatibility with).
Multi-user Enneagram Test
Single-user Enneagram Test
Single-user Jung test
Single-user Big Five Test

Personality Tools
Word Association Test - this test displays a series of words for you to answer positive, negative, or neutral to and then displays your responses and response times.
Ask The Oracle is a decision making tool.
Query the Universal Mind allows you to type in an interest (author, band, book, movie, etc) and then searches a database of over 20,000 users to find interests which correlate with it.
Search Minds allows you to take a personality test and see what users from a large database match most closely to your personality type.

Non-Serious Tests
The Famous Leader test and Classic Movie test are based on a large randomized custom personality question database and contain results which are meant to be relevant and amusing.

http://similarminds.com/personality_tests.html