<?php
header('Content-type:text/html; charset=utf-8');//UTF-8
//连接数据库
require_once 'lib/MssqlConnect.class.php';
$conn_hy = new MssqlConnect("127.0.0.1", "sa", "dddd", 'Jolink_cs');//连接
$params = array();
//$datas = $conn->query("select * from jcms_normal_content where ClassId = 6 ",$params);//查询
//var_dump($datas);
//$data_hy = $conn_hy->query("select top 1 * from tb_programs_articles order by id DESC",$params);
//var_dump($data_hy);
//echo iconv('GBK', 'UTF-8', $data_hy[0]['article_content']);exit;
$opts = array(
'http'=>array(
'method'=>"GET",
'timeout'=>10,
)
);
$stream = trim(file_get_contents("debug.php", false, stream_context_create($opts)));
$stream = stripslashes($stream);
//echo $stream;exit;
if ($stream != FALSE){
// var_dump($stream);
echo 'ddd';
$stream = str_replace('"', """, $stream);
$stream = str_replace("'", """, $stream);
/*$stream = str_replace(array("\r\n", "\r", "\n"), "", $stream);
$stream = str_replace("<","<",$stream);
$stream = str_replace(">",">",$stream);
*/
$data['article_classid'] = 'sfsfdsf';
$data['program_dir_classid'] = '372b6bb4-4e4d-f542-069e-f73f5c57f57a';
$data['article_content_type'] = 'html';
$data['article_name'] = iconv('UTF-8', 'GBK//IGNORE', "插入节目表,注意单引号会引起失败");
$data['article_content'] = iconv('UTF-8', 'GBK//IGNORE', $stream); //trim($stream);
$result =$conn_hy->add('tb_programs_articles',$data);//插入节目表,注意单引号会引起失败
}else{
echo 'no';
}
echo '<hr>';
$data_hy = $conn_hy->query("select top 1 * from tb_programs_articles order by id DESC",$params);
//var_dump($data_hy);
echo iconv('GBK', 'UTF-8', $data_hy[0]['article_content']);
评论