php连接sqlserver 方法附赠（2001/8/9）时间转换成时间戳

最新推荐文章于 2026-06-28 18:27:23 发布

原创最新推荐文章于 2026-06-28 18:27:23 发布 · 1.8k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sqlserver #php #mysql #sql #tags

本文介绍了一种使用PHP连接SQLServer的方法，并演示了如何从一个数据库迁移数据到另一个数据库的过程，包括对日期和字符串的处理。

php 操作excel的方法实在弄不明白，就换sqlserver了

<?php
//php连接 sqlserver方法
//com 组件 php帮助里有说明    配置php.ini com .allow_dcom 设为 TRUE
$conn = new COM ( "ADODB.Connection" ) or die ( "Cannot start ADO" );
$conn->Open ( "Provider=SQLOLEDB; Data Source=118.102.24.153;Initial Catalog=jtlhome; User ID=jtlhome; Password=C709@#23J_T_L" );

$rs = $conn->Execute ( "select * from s_n_news where s_id!=0" ); // 记录集

$num_columns = $rs->Fields->Count ();

$arrSub = array ('北京', '上海', '常州', '西安', '新疆', '任丘', '海南', '苏州', '无锡', '张家港', '成都', '深圳', '江阴', '昆山', '哈尔滨' );
$arrSub2 = array ('北京' => 5405, '上海' => 5336, '常州' => 5444, '西安' => 5496, '新疆' => 5548, '任丘' => 5578, '苏州' => 5612, '无锡' => 6001, '张家港' => 5697, '成都' => 5629, '深圳' => 5646, '江阴' => 5680, '昆山' => 5663, '哈尔滨' => 5714 );

$rowcount = 0;

$link = mysql_connect ( 'localhost:3306', 'root', '871123' );
while ( ! $rs->EOF ) {
    $sql = '';
    $par = '';

    $title = $rs->Fields ['title']->value;

    $content = $rs->Fields ['msgbody']->value;

    $content = str_replace ( '/'', '', $content );
    $tags = $rs->Fields ['keywords']->value;
    $digg = $rs->Fields ['memo']->value;
    $read_count = $rs->Fields ['click']->value;
    $createtime = $rs->Fields ['pubdate']->value;

    //$createtime='2001/8/9';
    $year = (( int ) substr ( $createtime, 0, 4 )); //取得年份
    $month = (( int ) substr ( $createtime, 5, 1 )); //取得月份
    $day = (( int ) substr ( $createtime, 7, 1 )); //取得几号


    $createtime = mktime ( 0, 0, 0, $month, $day, $year );

    $cate_id = $rs->Fields ['s_id']->value;

    $address = $arrSub [$cate_id - 1];

    $cate_id = $arrSub2 [$address];

    if (! $link) {
        echo '<br/>连接失败<br/>';
    }

    mysql_select_db ( 'subjtlhome' );

    $sql = 'insert into think_article (title,content,tags,digg,read_count,create_time,cate_id,module) values(/'' . $title . '/',/'' . $content . '/',/'' . $tags . '/',/'' . $digg . '/',/'' . $read_count . '/',/'' . $createtime . '/',/'' . $cate_id . '/',/'info/')';

    $result = mysql_query ( $sql );
    echo mysql_error ();

    if ($result) {
        continue;
    } else {
        echo '<br/>';
        echo $sql;
        echo '<br/>';
        echo $title;
        //    echo $address;
        break;
    }
    $rowcount ++; // rowcount 自增
    $rs->MoveNext ();
}

?>