php数据库滚动文字_php文字向上滚动类（暂停，滚动，及数据库调用）

文字向上滚动，停一下，再动，粘过去直接可以使用的

index.php类的调用及数据库取数据

session_start();

include "conn.php";

?>

/p>

Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

北京

style="height:150px;overflow:hidden"

οnmοuseοver="iScrollAmount=0"

οnmοuseοut="iScrollAmount=1">

$result=$db->query("select * from

db_companynews where TypeID='1'");

while($row=$db->fetch_array($result)){

echo '

>';

echo

'

>

';

echo

'

>

/>'.

$row['Title'].'

'.'

align="right"

width="100">'.date('Y-m-d',$row['PubDate']).'

'.'';

}

?>

jquery.js类文件

var oMarquee = document.getElementByIdx_x_x("gd"); //滚动对象

var iLineHeight = 28; //单行高度，像素

var iLineCount = 7; //实际行数

var iScrollAmount = 1; //每次滚动高度，像素

function run() {

oMarquee.scrollTop += iScrollAmount;

if ( oMarquee.scrollTop == iLineCount * iLineHeight )

oMarquee.scrollTop = 0;

if ( oMarquee.scrollTop % iLineHeight == 0 ) {

window.setTimeout( "run()", 500 );

} else {

window.setTimeout( "run()", 50 );

}

}

oMarquee.innerHTML += oMarquee.innerHTML;

window.setTimeout( "run()", 500 );

conn.php数据库连接页

class db

{

private $host;

private $name;

private $pass;

private $dbname;

function

__construct($host,$name,$pass,$dbname)

{

$this->host=$host;

$this->name=$name;

$this->pass=$pass;

$this->dbname=$dbname;

$this->connect();

}

function connect()

{

$link=mysql_connect($this->host,$this->name,$this->pass)

or die($this->error());

mysql_select_db($this->dbname,$link);

mysql_query("set names utf8");

}

function query($sql)

{

$query=mysql_query($sql);

return $query;

}

function fetch_row($query)

{

return

mysql_fetch_row($query);

}

function fetch_array($result)

{

return

mysql_fetch_array($result);

}

function close()

{

return

mysql_close();

}

}

$db=new

db('localhost','root','12345678','nnn')//(“服务器”，“用户名”，“密码”，“数据库名”);

?>