insert函数里传递数组给parseValue函数后变成了字符串,是什么原因呢
class MYSQLModel
{
public function parseValue(&$data)
{
echo ('parseValue' . gettype($data));
if (is_string($data)) {
$data = '\'' . $data . '\'';
} else if (is_array($data)) {
function addquotes($srting)
{
return "$srting";
}
$data = array_map('addquotes', $data);
} else if (is_null($data)) {
$data = null;
}
return $data;
}
public function connect()
{
include_once 'config.php';
$res = mysqli_connect(HOST, USER, PWD, DBNAME);
return $res;
}
public function insert($tablename, $array)
{
$keys = join(',', array_keys($array));
$arr = array_values($array);
echo ('array_values' . gettype($arr));
$valuesarr = self::parseValue($arr);
$values = join(',', $valuesarr);
var_dump($values);
$conn = self::connect();
$sql = "INSERT INTO $tablename ($keys) WHERE VALUES ('$values')";
$result = mysqli_query($conn, $sql);
return var_dump($result);
}
}