Menu
Community /Pin to ProfileBookmark
@NogDogMar 06.2010 — #One approach:
Please help me!!
Hello everybody, i have a problem
Example:
$tableName=”User”;
$colummName=array(‘userID’,’User_name’,’Password’);
$valueName=array(‘1′,’admin’,’123456′);
and i want to print query like that
INSERT INTO User (userID, User_name, Password) VALUES (1,’admin’,’123456′)
What can i do? ?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogMar 06.2010 — #One approach:[code=php]
<?php
/**
* Get comma-separated list for use in query
* @return string
* @param array $array Values to be used
* @param string $type 'Value' (default) or 'Column'
*/
function dbListFromArray($array, $type='Value')
{
$type = ucfirst($type);
if(in_array($type, array('Value', 'Column')))
{
$func = 'mysql'.$type;
array_walk($array, $func);
}
return implode(', ', $array);
}
/**
* Callback function for 'Column' list type
* @return bool
* @param string $value
* @param string $key (Not used)
*/
function mysqlColumn(&$value, $key)
{
$value = "$value";
return true;
}
/**
* Callback function for 'Value' list type
* @return bool
* @param string $value
* @param string $key (Not used)
*/
function mysqlValue(&$value, $key)
{
if(!is_numeric($value))
{
if(get_magic_quotes_gpc())
{
$value = stripslashes($value);
}
if(($value = mysql_real_escape_string($value)) === false)
{
throw new Exception("No MySQL connection");
}
$value = "$value";
}
return true;
}
// Sample usage:
mysql_connect('localhost', '*****', '*****');
$cols = array('col_1', 'col_two', 'column3');
$vals = array(1.23, "John", "O'Reilly");
try
{
$sql = "INSERT INTO table (" . dbListFromArray($cols, 'Column') .
") VALUES (" . dbListFromArray($vals, 'Value') . ")";
echo $sql;
}
catch(Exception $e)
{
die($e);
}
[/code]