I take on both responsibilities at work. If I'm not styling or building the html for a site I'm interacting with a database through sql calls, creating a database table to store information or creating files to encapsulate functionality that is needed throughout multiple pages.
However, Due to the subjective nature of that question I figure its probably just best to show you and allow you to decide the answer. Like anything if your going to learn it you might as well learn to do it well. Knowing how to use a conditional or loop isn't going to get you very far when it comes to back end programming. Understanding Object Oriented methodology and its application/similarity to web programming is what would make you valuable as a backend developer responsible for php. Furthermore, knowing a server side language is only one part of the puzzle.
To accomplish anything useful with a server side language you will need to understand database relationships. You will also need to understand how to communicate with a database front end client such as mysql with the chosen server side language. This is because most of what goes into back end development involves communicating with a database. If you don't under these key components than I wouldn't consider you an asset to back end team.
If your truly serious about programming then I recommend picking up a book on java. Learning a actual programming language will help you to get away from the mentality of thinking of a website as website and more like an application. It will also aid you in understanding key methodologies existent in most web programming languages such as php, javascript and actionscript. Once you understand OOP methodology its relatively easy to move from language to language web wise and most other OOP languages for that matter.
<?php
abstract class AppModel extends App {
var $hasOne;
var $hasMany;
var $belongsToMany;
var $hasAndBelongsToMany;
protected $_db;
protected $_result;
private $_records;
public function __construct() {
$this->_db =& self::$_CONNECTION;
/*
* make arguments available
*/
$this->args =& self::$_ARGS;
//echo '<p>'.get_class($this).' created'.'</p>';
$this->_appendModel();
/*
* hasOne relationships
*/
if($this->hasOne) {
if(is_array($this->hasOne)) {
foreach($this->hasOne['tables'] as $model) {
$relatedModelName = strtolower($model['name']).'s';
$this->_newModel($relatedModelName);
}
} else {
$relatedModelName = strtolower($this->hasOne).'s';
$this->_newModel($relatedModelName);
}
}
/*
* hasMany relationships
*/
/*
* belongsToMany relationships
*/
if($this->belongsToMany) {
if(is_array($this->belongsToMany)) {
foreach($this->belongsToMany['tables'] as $model) {
$relatedModelName = strtolower($model['name']).'s';
$this->_newModel($relatedModelName);
}
} else {
$relatedModelName = strtolower($this->belongsToMany).'s';
$this->_newModel($relatedModelName);
}
}
/*
* init method called on creation. This is mainly here
* for required for top level app models such as navigation,
* config, etc to get their data automatically
*/
if(method_exists($this,'_init')) {
$this->_init();
}
}
/*
* generates a model
*/
private function _newModel($pRelatedModelName) {
$relatedModelClass = ucfirst($pRelatedModelName).'Model';
if(class_exists($relatedModelClass)) {
/*
* avoids duplicate models to be created
*/
if(!array_key_exists($pRelatedModelName,self::$_VA RS)) {
new $relatedModelClass();
}
}
}
/*
* sets dynamic variable whose name is the model name
* and value is equal to $this object.
*/
private function _appendModel() {
$name = $this->myNameIs();
$this->$name = $this;
}
public function buildSql($pId='',$pWhere='',$pOrder='',$pLimit='') {
$name = $this->myNameIs();
$select = array();
$joins = array();
$where = array();
$order = array();
$limit = array();
$sqlInfo = array(
'select'=>&$select,
'table'=>$name,
'joins'=>&$joins,
'where'=>&$where,
'order'=>&$order,
'limit'=>&$limit
);
if($this->has) {
if(array_key_exists('cols',$this->has)) {
foreach($this->has['cols'] as $column) {
$select[] = array('table'=>$name,'col'=>$column['col']);
}
} else {
$select[] = array('table'=>$name,'col'=>'*');
}
} else {
$select[] = array('table'=>$name,'col'=>'*');
}
if($this->hasOne) {
foreach($this->hasOne['tables'] as $model) {
$modelRealName = strtolower($model['name'].'s');
if(array_key_exists($modelRealName,self::$_VARS)) {
/*
* selects
*/
if(array_key_exists('cols',$model)) {
foreach($model['cols'] as $column) {
$select[] = array('table'=>$modelRealName,'col'=>$column);
}
} else {
$select[] = array('table'=>$modelRealName,'col'=>'*');
}
/*
* joins
*/
$joins[] = array(
'type'=>'left',
'tables'=>array(
array(
'table'=>$name,
'col'=>'id'
),
array(
'table'=>$modelRealName,
'col'=>substr($name,0,-1).'_id'
)
)
);
/*
* where
*/
if(array_key_exists('where',$model)) {
foreach($model['where'] as $wClause) {
$where[] = array(
'table'=>$modelRealName,
'comp'=>array_key_exists('comp',$wClause)?$wClause['comp']:'=',
'value'=>$wClause['value'],
'col'=>$wClause['col']
);
}
}
}
}
}
/*
* where clause(s)
*/
/* required to findById */
//$where[] = array('table'=>$name,'comp'=>'=','col'=>'id','value'=>$pId);
if($this->has) {
if(array_key_exists('where',$this->has)) {
$hs = $this->has['where'];
foreach($hs as $clause) {
$comp = array_key_exists('comp',$clause)?$clause['comp']:'=';
$where[] = array(
'table'=>$name,
'col'=>$clause['col'],
'value'=>$clause['value'],
'comp'=>$comp
);
}
}
}
/*
* order by
*/
if($pOrder!='') {
$order[] = array('table'=>$name,'col'=>'created','order'=>'asc');
} else if($this->has) {
if(array_key_exists('order',$this->has)) {
foreach($this->has['order'] as $arrange) {
$order[] = $arrange;
}
}
}
/*
* limit
*/
if($pLimit!='') {
$limit = $pLimit;
$limit2= count($limit)==2?implode(',',$sqlInfo['limit']):$limit['finish'];
} else if($this->has) {
if(array_key_exists('limit',$this->has)) {
$limit = $this->has['limit'];
$limit2= count($limit)==2?implode(',',$sqlInfo['limit']):$limit['finish'];
}
//$limit = array('start'=>0,'finish'=>20);
}
/*
* start building sql statement
*/
/*
* build select statement
*/
$select2 = array();
foreach($sqlInfo['select'] as $var) {
$col = strcmp('*',$var['col'])==0?'*':'`'.$var['col'].'`';
$select2[] = $var['table'].'.'.$col;
}
//echo implode(',',$select2);
/*
* build join comparison sequence
*/
$join2=array();
$join3=array();
foreach($sqlInfo['joins'] as $var) {
$comparisons = array(
$var['tables'][0]['table'].'.`'.$var['tables'][0]['col'].'`',
$var['tables'][1]['table'].'.`'.$var['tables'][1]['col'].'`'
);
$join2[] = implode(' = ',$comparisons);
$join3[] = strtoupper($var['type']).' JOIN '.$var['tables'][1]['table'];
}
//echo implode('AND',$join2);
$select3 = implode(' ',array($name,implode(' ',$join3)));
//echo $select3;
/*
* where statements
*/
$where2=array();
foreach($sqlInfo['where'] as $var) {
$comparison = array(
$var['table'].'.`'.$var['col'].'`',
is_string($var['value'])?'\''.$var['value'].'\'':$var['value']
);
$comp = array_key_exists('comp',$var)?$var['comp']:'=';
$where2[] = implode($comp,$comparison);
}
//echo implode(',',$where2);
/*
* order
*/
$order2=array();
foreach($sqlInfo['order'] as $var) {
$ord = $var['table'].'.`'.$var['col'].'`';
if(array_key_exists('order',$var)) {
$ord.=' '.strtoupper($var['order']);
}
$order2[] = $ord;
}
//echo implode(',',$order2);
/*
* limit
*/
/*
* set proir just easier. No reason to set it here
*/
/*if(isset($limit)) {
$limit2= count($limit)==2?implode(',',$sqlInfo['limit']):$limit['finish'];
}*/
//echo $limit2;
/*
* bringing it all together
*/
$sql = 'SELECT '.implode(',',$select2).' FROM '.$select3;
if($join2) {
$sql.=' ON '.implode(' AND ',$join2);
}
if($where2) {
$sql.= ' WHERE '.implode(' AND ',$where2);
}
if($order) {
$sql.= ' ORDER BY '.implode(',',$order2);
}
if(isset($limit2)) {
$sql.= ' LIMIT '.$limit2;
}
$sql.=';';
echo '<p>query: '.$sql.'</p>';
return $sql;
}
public function findBy($pName,$pValue) {
$name = $this->myNameIs();
$token = time();
$whereClause = array(
'col'=>$pName,
'comp'=>'=',
'value'=>$pValue,
'table'=>$name
);
if($this->has) {
$this->has['where'][$token] = $whereClause;
} else {
$this->has = array(
'where'=>array(
$token=>$whereClause
)
);
}
print_r($this->has);
$sql = $this->buildSql();
/* destroy whereClause */
unset($this->has['where'][$token]);
$this->sendToSql($sql);
if($this->_records) {
return $this->records->next();
} else {
return array();
}
}
public function __call($pName,$pArgs) {
/*
* If findBy found create magical reroute
*/
if(stristr($pName,'findBy')) {
$col = strtolower(substr($pName,6));
$this->findBy($col,$pArgs[0]);
}
}
public function sqlFormatedStatement() {
return $this->myNameIs();
}
public function formatCols($pCols='') {
if($pCols!='') {
}
}
/*
* query db and store result set
*/
public function sendToSql($pSql,$pAppend=true) {
$result = $this->_db->query($pSql);
if($pAppend) {
if(!$result) { return; }
if($result->rowCount()>=1) {
$this->_result = $result;
$this->_records = $result->recordSet();
}
} else {
return $result;
}
}
/*
* check for records
*/
public function hasRecords() {
return $this->_records?true:false;
}
/*
* public function
*/
public function getRecords() {
return $this->_records?$this->_records:false;
}
}
?>
;)