php的prepare,PHP: mysqli::prepare - Manual

I wrote this function for my personal use and figured I would share it.  I am not sure if this is the appropriate forum but I wish I had this when I stumbled on to mysqli::prepare.  The function is an update of the function I posted previously.  The previous function could not handle multiple queries.

For queries:

Results of single queries are given as arrays[row#][associated Data Array]

Results of multiple queries are given as arrays[query#][row#][associated Data Array]

For queries which return an affected row#, affected rows are returned instead of (array[row#][associated Data Array])

Code and example are below:

if($stmt=mysqli_prepare($link,$sql)){

if(count($params) ==count($params,1)){$params= array($params);$multiQuery=FALSE;

} else {$multiQuery=TRUE;

}

if($typeDef){$bindParams= array();$bindParamsReferences= array();$bindParams=array_pad($bindParams,(count($params,1)-count($params))/count($params),"");

foreach($bindParamsas$key=>$value){$bindParamsReferences[$key] = &$bindParams[$key];

}array_unshift($bindParamsReferences,$typeDef);$bindParamsMethod= newReflectionMethod('mysqli_stmt','bind_param');$bindParamsMethod->invokeArgs($stmt,$bindParamsReferences);

}$result= array();

foreach($paramsas$queryKey=>$query){

foreach($bindParamsas$paramKey=>$value){$bindParams[$paramKey] =$query[$paramKey];

}$queryResult= array();

if(mysqli_stmt_execute($stmt)){$resultMetaData=mysqli_stmt_result_metadata($stmt);

if($resultMetaData){$stmtRow= array();$rowReferences= array();

while ($field=mysqli_fetch_field($resultMetaData)) {$rowReferences[] = &$stmtRow[$field->name];

}mysqli_free_result($resultMetaData);$bindResultMethod= newReflectionMethod('mysqli_stmt','bind_result');$bindResultMethod->invokeArgs($stmt,$rowReferences);

while(mysqli_stmt_fetch($stmt)){$row= array();

foreach($stmtRowas$key=>$value){$row[$key] =$value;

}$queryResult[] =$row;

}mysqli_stmt_free_result($stmt);

} else {$queryResult[] =mysqli_stmt_affected_rows($stmt);

}

} else {$queryResult[] =FALSE;

}$result[$queryKey] =$queryResult;

}mysqli_stmt_close($stmt);

} else {$result=FALSE;

}

if($multiQuery){

return$result;

} else {

return$result[0];

}

}?>

Example(s):

For a table of firstName and lastName:

John Smith

Mark Smith

Jack Johnson

Bob Johnson

returns array(

0=> array('firstName' => 'Bob', 'lastName' => 'Johnson')

)

*/

//single query, multiple results$query="SELECT * FROM names WHERE lastName=?";$params= array("Smith");mysqli_prepared_query($link,$query,"s",$params)/*

returns array(

0=> array('firstName' => 'John', 'lastName' => 'Smith')

1=> array('firstName' => 'Mark', 'lastName' => 'Smith')

)

*/

//multiple query, multiple results$query="SELECT * FROM names WHERE lastName=?";$params= array(array("Smith"),array("Johnson"));mysqli_prepared_query($link,$query,"s",$params)/*

returns array(

0=>

array(

0=> array('firstName' => 'John', 'lastName' => 'Smith')

1=> array('firstName' => 'Mark', 'lastName' => 'Smith')

)

1=>

array(

0=> array('firstName' => 'Jack', 'lastName' => 'Johnson')

1=> array('firstName' => 'Bob', 'lastName' => 'Johnson')

)

)

*/?>

Hope it helps =)