Home > Article > Backend Development > PHP saves array to database program code_PHP tutorial
PHP saves array to database program code_PHP tutorial
- WBOYOriginal
- 2016-07-13 16:56:48852browse
When we cache files, we often need to convert php code or arrays into strings and save them in the database. Below I will introduce two methods of saving arrays to the database.
Method 1:
Use serialize to write, and then use unserialize to output
serialize() is to serialize the values of variables in PHP such as objects, arrays, etc. into strings and store them. We can store the serialized strings in other places such as databases and Sessions , Cookie, etc., the serialization operation will not lose the type and structure of these values. In this way, the data of these variables can be passed between PHP pages and even different PHP programs.
And unserialize() converts the serialized string back to a PHP value. What is returned is the converted value, which can be integer, float, string, array or object. If the passed string cannot be deserialized, FALSE
| The code is as follows | Copy code | ||||
";
print_r ( $rows );
}
function __wakeup(){ //Deserialization,
$this->db();
}
}
$chanel = new db("localhost",'root','','hdcms');
//$chanel->select();
session_start();
$_SESSION['channel_obj'] = serialize($chanel); //Serialize the object and save the properties of the object. There are no methods, so use __wakeup()
class ren{
private $name;
private $age;
function __construct($name,$age){
$this->name =$name;
$this->age = $age;
}
function show(){
echo "Name is: {$this->name} Age is: {$this->age}";
}
function __sleep(){
Return array_keys(get_object_vars($this)); //Or get the key name in the array and serialize some variables
}
}
$zao = new ren("Zhao Liu",44);
echo serialize($zao); //Serialization (specify which variable to serialize)
====================================
session_start();
include '59.php';
$channel_obj=unserialize($_SESSION['channel_obj']); //Deserialize class object
$channel_obj->select(); //It only works with the __wakeup method
|
|||||
Method 2:
Use json_encode to write, and then use json_decode to output
Before json_encode, use urlencode() to process all the contents of all arrays, then use json_encode() to convert them into json strings, and finally use urldecode() to convert the encoded Chinese back.
The code is as follows
|
Copy code | ||||
*
* Use a specific function to process all elements in the array
* @param string &$array The string to be processed
* @param string $function The function to be executed
* @return boolean $apply_to_keys_also Whether it is also applied to keys
* @access public
*
*************************************************** ***********/
function arrayRecursive(&$array, $function, $apply_to_keys_also = false)
{
static $recursive_counter = 0;
If (++$recursive_counter > 1000) {
die('possible deep recursion attack');
}
foreach ($array as $key => $value) {
if (is_array($value)) {
arrayRecursive($array[$key], $function, $apply_to_keys_also);
} else {
$array[$key] = $function($value);
}
If ($apply_to_keys_also && is_string($key)) {
$new_key = $function($key);
if ($new_key != $key) {
$array[$new_key] = $array[$key];
unset($array[$key]);
}
}
}
$recursive_counter--;
}
/***************************************************** **********
*
* Convert array to JSON string (compatible with Chinese)
* @param array $array The array to be converted
* @return string The converted json string
* @access public
*
*************************************************** ***********/
function JSON($array) {
arrayRecursive($array, 'urlencode', true);
$json = json_encode($array);
return urldecode($json);
}
$array = array
(
'Name'=>'Shia',
'Age'=>20
);