Question

php，用curl获取到的cookie文件怎么把内容储存在mysql中？

用curl模拟登录获取到的cookie是保存在文件中的，怎么把它储存在数据库里？
php语言。谢谢

Answer 1

/*-----保存COOKIE-----*/
$url = 'www.xxx.com'; //url地址
$post = "id=user&pwd=123456"; //POST数据
$ch = curl_init($url); //初始化
curl_setopt($ch,CURLOPT_HEADER,1); //将头文件的信息作为数据流输出
curl_setopt($ch,CURLOPT_RETURNTRANSFER,1); //返回获取的输出文本流
curl_setopt($ch,CURLOPT_POSTFIELDS,$post); //发送POST数据
$content = curl_exec($ch); //执行curl并赋值给$content
preg_match('/Set-Cookie:(.*);/iU',$content,$str); //正则匹配
$cookie = $str[1]; //获得COOKIE（SESSIONID）
curl_close($ch); //关闭curl

/*-----使用COOKIE-----*/
curl_setopt($ch,CURLOPT_COOKIE,$cookie);

Answer 2

把文件保存到mysql：
保存到mysql中，通过insert语句插入
<?php
$con = mysql_connect("localhost", "", "");
mysql_select_db("w3m");
$error = $_FILES['w3img']['error'];
$tmp_name = $_FILES['w3img']['tmp_name'];
$size = $_FILES['w3img']['size'];
$name = $_FILES['w3img']['name'];
$type = $_FILES['w3img']['type'];
print("\n");
if ($error == UPLOAD_ERR_OK && $size > 0) {
$fp = fopen($tmp_name, 'r');
$content = fread($fp, $size);
fclose($fp);
$content = addslashes($content);
$sql = "INSERT INTO fyi_files (name, type, size, content)"
. " VALUES ('$name', '$type', $size, '$content')";
mysql_query($sql, $con);
print("File stored.\n");
} else {
print("Database Save for upload failed.\n");
}
print("\n");
mysql_close($con);
?>